Latest Contributions by BruceHarold

Hi, it is a known issue that the expression in Make Query Table may not validate when it is correct and vice versa. For File GDB inputs build the expression without double quotes. ... View more

A good pattern is to make a numpy array of typed data and use arcpy.da.ExtentTable to add the fields to your table. The Python snippet would be in a Calculate Value model tool.  An example of syntax is in this GP sample: http://www.arcgis.com/home/item.html?id=da9efbe1232f426ead182213f53c8cd8  ... View more

Its a mystery, I would log a support call.  I'll ask around the shop here if we're aware of any incompatibilities and reply here if I hear anything. ... View more

You can use a composite locator like you envision.  Try just the Geocode_Addresses geoprocessing tool manually with the arguments you want and check everything is OK then you will know it will work in code.  ... View more

Using a generator function is  a pattern I find useful so I thought I would mention it. Handling StopIteration lets you automate returning something you design, like below I return a dictionary if the cursor is empty or not. # Define row generator def rowGenerator(table,fields,sortField=None):     if sortField is not None:         sql = [None,'ORDER BY ' + sortField]         cursor = arcpy.da.SearchCursor(table,fields,sql_clause=sql)     else:         cursor = arcpy.da.SearchCursor(table,fields)     with cursor:         for row in cursor:             yield row # Create row generator if postalField:     rowGen = rowGenerator(inTable,cursorFields,postalField) else:     rowGen = rowGenerator(inTable,cursorFields) # Define recordset builder def recordsetBuilder(rowgen):     records = []     for i in range(0,1000):         try:             data = next(rowgen)             attributes = {'attributes':{recordFields:data                                         for i in range(len(data))}}             records.append(attributes)         except StopIteration:             break     return {'records':records} ... View more

Another one is wrapping the cursor in a generator function and seeing if StopIteration is raised when you request a row. ... View more

Data Interoperability extension can compare two arbitrary data sources without any shared key requirement and drop out unchanged/insert/delete or CRUD sets insert/update/delete over any set of geometry or attribute comparisons.  If the scripted approach doesn't work for you email me at [email protected] with sample data and I'll run it. ... View more

..or if it is to be a new feature class each load and the field names are stable then Feature Class to Feature Class. The field map needs to be set up to control input and output field naming and typing. ... View more

Hi You could instrument your code to write error conditions to a file. The worker script in the below sample shows error trapping and file writing. http://arcgis.com/home/item.html?id=b3c7c6273ef54e91aa57a073aa873eca  Regards ... View more

You should be able to use 64bit arcpy. Install 64bit background geoprocessing, this will lay down 64bit arcpy. Use a master/worker script approach, your existing script is worker.py. master.py can look like this: import os, subprocess, time command = r'C:\Python27\ArcGISx6410.4\pythonw.exe C:\your\path\to\worker.py' os.environ['PYTHONPATH'] = r'C:\Python27\ArcGISx6410.4\Lib\site-packages' process = subprocess.Popen(command) while process.poll() == None:     time.sleep(5) It might work better to also first in worker.py make a dictionary of OID:Polygon key/value instead of the selection, and use a geometry as input to the clip rather than a selection on a feature class. Using geometry objects with geoprocessing tools—Help | ArcGIS for Desktop  ... View more

The coordinate you entered was in Antactica, if you are looking in New York this works but you need a search distance of 1000 metres as its in the river: -73.955443,40.759516 http://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/reverseGeocode?location=-73.955443%2C40.759516&distan…  ... View more

Hi Nils You might get better support sticking to 'unwrapped' approaches, i.e. vanilla Python calling Esri's REST API natively.  For example you can leverage the code in this sample to help with your reverse geocoding problem: http://www.arcgis.com/home/item.html?id=da9efbe1232f426ead182213f53c8cd8  Be aware storing the results of ArcGIS Online geocoding or reverse geocoding requires service credits; in the sample the user token is picked up from the app but you can do it standalone with the generateToken call. Regards ... View more

See if this approach works for you: http://www.arcgis.com/home/item.html?id=da9efbe1232f426ead182213f53c8cd8  ... View more

No, stick with the composite but make two reverse geocode calls, one with returnIntersection true and one false. For example: http://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/reverseGeocode?location=2.2945%2C+48.8583&distance=20…  http://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/reverseGeocode?location=2.2945%2C+48.8583&distance=20…  ... View more