Latest Contributions by RandyBurton

I like to test field calculations with the CalculateField tool and then look at the results window and 'copy as Python snippet'.  When this was done, I noticed that the domain code was wrapped in single quotes and then wrapped in double quotes.  So try: arcpy.CalculateField_management(ug, "LENGTHSOURCE", "'USER'", "PYTHON_9.3")‍ I also noticed most of your domain codes are 2 characters.  If you still have issues, you may wish to confirm that 'USER' is the correct code. ... View more

As an alternative to ogr2ogr, you might consider Features to JSON.  If you are using Pro or Desktop 10.5+, there is an option to Create output as GeoJSON, conforming to the GeoJSON specification. I tested the following, to which you can add a walk through your shape file directory: import arcpy shp = r'C:\Path\To\file.shp' out = r'C:\Path\To\file.json' # cannot use '.geojson' as extension arcpy.FeaturesToJSON_conversion(shp, out, format_json="FORMATTED", geoJSON='GEOJSON') # format_json is optional, makes file a bit more human readable print('Done') ‍‍‍‍‍‍‍‍ ... View more

Another option might be to use a combination of List Domains and Create Domain to copy and create the domains.  These tools are available in both Pro and Desktop.  There are some related tools mentioned on these help pages that work with the range or coded values. ... View more

It looks like you might be using python 3.  Try: print(f"Writing: {fileLocation}{os.sep}{filename}")‍ If this doesn't solve the issue, confirm which version of Python you are using. ... View more

Look at line 52-54 in the script and you will see this note: # initialize the portal helper class # ago.py is part of the 10.3 python install agol_helper = ago.AGOLHelper(portal_url) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I was able to import it using desktop 10.5.  So the script is a desktop thing using Python 2.7, apparently. >>> help(ago) Help on module ago: NAME ago - ago.py: interact with an ArcGIS Portal instance FILE c:\program files (x86)\arcgis\desktop10.5\arctoolbox\scripts\ago.py CLASSES __builtin__.object AGOLHelper MultipartFormdataEncoder class AGOLHelper(__builtin__.object) | Interact with an ArcGIS Portal instance, such as ArcGIS Online. Must be | initialized with either the login() method, or by reusing an existing | OAuth token via token_login(). Covers approximately 1/3 of the complete | API, primarily focused on the common operations around uploading and | managing services and web maps. ... etc.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Assuming that the error on line 41 referrers to line 7 in your snippet, you might use a print statement to see what the variable gdb[0] is referencing.  I also notice that later you are referencing gdb[1] for messaging which is also puzzling.  Since gdb appears to be a tuple/list, you might try a print statement just to verify that it is what is expected. ... View more

If you requested json instead of geojson, you could use the JSONToFeatures  tool (Pro version) to import into ArcMap. My test script using python 2.7: import arcpy, urllib, urllib2, json URL = "https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/Coronavirus_2019_nCoV_Cases/FeatureServer/1/query" # query this feature # using GET method query_dict = { "where" : "1=1", "outFields" : "*", "f": "json" } # results in json format response = urllib.urlopen(URL, urllib.urlencode(query_dict)) with open('covid_update.json', 'w') as f: f.write(response.read()) arcpy.JSONToFeatures_conversion(in_json_file="covid_update.json", out_features="C:/Path/to/file.gdb/covid_update") print 'Done.'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

You can use the json module to process the geojson.  I was testing the following using python 2.7.  It makes the URL request and writes a tab delimited file. import urllib, urllib2, json, sys, time, collections fw = open("covidUpdate.txt", "w") # file to write URL = "https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/Coronavirus_2019_nCoV_Cases/FeatureServer/1/query" # query this feature # using GET method query_dict = { "where" : "1=1", # something always true "outFields" : "*", "f": "geojson" } # results in geojson format jsonResponse = urllib.urlopen(URL, urllib.urlencode(query_dict)) features = json.loads(jsonResponse.read(), object_pairs_hook=collections.OrderedDict)[u'features']# using the features section # Header fw.writelines("{}\t{}\t{}\t{}\t{}\t{}\t{}\t{}\t{}\n".format( 'OBJECTID','Province_State','Country_Region','Last_Update','Latitude','Longitude','Confirmed','Recovered','Deaths')) # Data rows for f in features: fw.writelines("{}\t{}\t{}\t{}\t{}\t{}\t{}\t{}\t{}\n".format( f['properties']['OBJECTID'], f['properties']['Province_State'] if f['properties']['Province_State'] is not None else '', f['properties']['Country_Region'], # convert timestamp to local time # time.strftime('%c', time.localtime(f['properties']['Last_Update']/1000)) if f['properties']['Last_Update'] is not None else '', # convert timestamp to GMT time.strftime('%Y-%m-%d %H:%M:%S', time.gmtime(f['properties']['Last_Update']/1000)) if f['properties']['Last_Update'] is not None else '', f['properties']['Lat'], f['properties']['Long_'], f['properties']['Confirmed'], f['properties']['Recovered'], f['properties']['Deaths'])) fw.close() print 'Done.'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Results: OBJECTID Province_State Country_Region Last_Update Latitude Longitude Confirmed Recovered Deaths 1 Abruzzo Italy 2020-05-22 23:32:40 42.35122196 13.39843823 3220 1647 394 2 Acre Brazil 2020-05-22 23:32:40 -9.0238 -70.812 3343 0 80 3 Aguascalientes Mexico 2020-05-22 23:32:40 21.8853 -102.2916 586 402 21 .....‍‍‍‍‍‍‍‍‍‍ I noticed that Provence_State is sometimes null/None, as was the timestamp on occasion.  I kept the time in GMT/UTC, but you can convert it to local time if desired.  It is also possible to use an insert cursor and create a feature layer if desired. This should give you some ideas. ... View more

It should run with 10.6.  I assume you are running the script as a script tool inside ArcMap.  Can you describe your process, what parameters you are using, etc.? ... View more

You might check out the answer given in this Stackoverflow discussion about the 64 and 32-bit versions of Access 2010. ... View more

Are you connecting to 32 or 64 bit Access?  You might try: connStr = ( r"DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};" r"P:\Conservation Programs\Natural Heritage Program\Data Management\ACCESS databases\POND_entry\POND_be.accdb;" ) conn = pyodbc.connect(connStr)‍‍‍‍‍‍‍‍‍‍ ... View more

I think you have the solution.  For a "prettier way", perhaps: if 'TableView' in str(type(brknItem)): # do something‍‍‍‍‍‍ ... View more