Latest Contributions by ErnestoCarreras3

I have used this script in the past: import arcpy, os, sys arcpy.env.ovewriteOutput = True arcpy.env.qualifiedFieldNames = False     def SelectRelatedRecords(in_ft, in_field, rel_table, rel_field, sql=''):     '''         Selects all features from input layer based on selection from another table.  Acts like           a "relationship class".  There must be a common field between the two tables.         in_ft = input features         in_field = field for the relate from input features         rel_table = related table         rel_field = related table field         sql = SQL Query for the related table (optional)     '''     # Check to make sure field types match, otherwise raise error and exit tool     in_ft_fields = arcpy.Describe(in_ft).fields     ftype1 = [f.type for f in in_ft_fields if f.name == in_field][0]     ftype2 = [f.type for f in arcpy.Describe(rel_table).fields if f.name == rel_field][0]     if ftype1 != ftype2:         arcpy.AddError('\nField type for "{0}" in "{1}" does not match field type for "{2}"' \                        ' in "{3}"!\n'.format(in_field,in_ft,rel_field,rel_table))         arcpy.AddError('Field type is "{0}", must be "{1}".\n'.format(ftype1,ftype2))         sys.exit()         # map doc     mxd = arcpy.mapping.MapDocument('CURRENT')     df = arcpy.mapping.ListDataFrames(mxd)[0]     # determine version for cursor type     ver = float(arcpy.GetInstallInfo()['Version'])     if ver > 10:         dataAccess = True     else:         dataAccess = False     # make feature layer if sql     if sql:         arcpy.SelectLayerByAttribute_management(rel_table, 'NEW_SELECTION', sql)     rel_count = int(arcpy.GetCount_management(rel_table).getOutput(0))     arcpy.AddMessage('\n{0} selected records from from "{1}"\n'.format(rel_count, rel_table))     # grab unique id's     if dataAccess:         with arcpy.da.SearchCursor(rel_table, [rel_field]) as rows:             if ftype2 == 'String':                 recs = tuple(r[0].encode('utf-8') for r in rows)             else:                 recs = tuple(r[0] for r in rows)     else:         rows = arcpy.SearchCursor(rel_table)         if ftype2 == 'String':             recs = tuple(r.getValue(rel_field).encode('utf-8') for r in rows)         else:             recs = tuple(r.getValue(rel_field) for r in rows)         del rows     # Select records in in_ft table     par_path = os.path.dirname(arcpy.Describe(in_ft).catalogPath)     where = ''' {0} in {1} '''.format(arcpy.AddFieldDelimiters(par_path, in_field), recs)     arcpy.SelectLayerByAttribute_management(in_ft, 'NEW_SELECTION', where)     sel_count = int(arcpy.GetCount_management(in_ft).getOutput(0))     arcpy.AddMessage('Selected {0} related records from "{1}"\n'.format(sel_count, in_ft))     return if __name__ == '__main__':     # Get args     argv = tuple(str(arcpy.GetParameterAsText(i)) for i in range(arcpy.GetArgumentCount()))     # Run it     SelectRelatedRecords(*argv) This should do the trick.  I have a more complicated version where there is an option to export the selected records joined to the related table.  You can download the attached toolbox if you want to try this one out. Thanks for the quick reply! ... View more

Is there any way to select related records using python? similar to the related records button within ArcMap. I like to include this operation as a script in a GP Model. Thanks in advanced. EC ... View more

Ernesto, out of the box the query tool don't contain date-pickers. You will have to implement it yourself. The code for the add-in is available. That makes me think to implement a date-picker into the query tool myself. Hmmm, hopefully someone can modify/or create such tool.... My coding/programming skills are limited. 😞 Thanks for your input. ... View more

Thanks to both of you!!! ... View more

Hi Frank Yes, they are the same locators. Regards Bruce, isn't the world locator be part of the community project? Does the World Geocoding service contains more data contributed by other sources (local) other thank NAVTEQ and TomTom? ... View more

In this, I am not speaking officially for Esri (hey, I handle map projections, not geocoding), but I used the Wayback Machine (web.archive.org) to check a random earlier version of the page. The rate was 80 credits per 1000 geocodes in April 2013. April 2013 version of the Geocoding page of ArcGIS Online Thanks everyone!! ... View more

Mike, I just wanted to confirm they credits were adjusted to what was announcd during the past conference: "Geocoding costs have been reduced by 50 percent." http://www.esri.com/esri-news/releases/13-3qtr/get-more-with-arcgis-online I will appreciate if you can confirm this fact. Reagrds, Ernesto ... View more

Is this page up-to-date? http://www.esri.com/software/arcgis/arcgisonline/credits/geocoding ... View more

So you have an Advanced license, which is good, since that gives you the most options. What was the search radius setting that you used?  Not specifying a radius would probably require eseentially perfect alignment of your points and lines, and nearly invisible imperfections in the alignment would result in lines not splitting.  You may also want to make a copy of your data and run the Integrate tool first to ensure the lines and points are fully snapped before trying the Split Lina at Point tool. Will the tool actually split the line at every single location where it intersects with a point? ... View more

Your post is completely vague.  What did you expect that you did not get?  A picture of what you got and comments on what you don't like would help a lot. Sorry for not been so clear. Basically I have two Feature Classes, one for points and one for liens. Some points intersect the lines. I want to run a script or tool that splits the line wherever the point intersects the lines (like valves on top of mains). I have tried the Split Lines at Points but it does not split the lines wherever the point intersect the lines.[ATTACH=CONFIG]24369[/ATTACH] ... View more