Covid19 Cases Feature Layer Data and ESRI DUMPER

Question

Morning All

I want to download the Covid19 Daily Cases data from here

https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/Coronavirus_2019_nCoV_Cases/FeatureServer/1

I have tried this way.

1. ESRI DUMPER - Works but then I have difficulty converting the ESRI geojson to something that is usable in a DataBase.

Any thoughts on the best way to convert this output to a SQL readable format ? CSV/TAB delimited flat file for example ?

Many thanks

Regards.

Jeremy.

Dunn_Jeremy · Answer

Morning Randy

I solved this by simply running a where statement on the ObjectID's.

Where "ObjectID>1000"

Seemed to work.

Regards.

Jeremy.

Dunn_Jeremy · Answer

Good Afternoon Randy

Many thanks for the post. After a little bit of re-working I successfully created a script that worked.

Many many thanks. The only issue I have is that the feature layer I am querying has 3466 features in it and the Max Record Count is limited to 1000. Is there anyway to increase this ?

Regards.

Jeremy.

RandyBurton · Answer

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.'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍