Iterate over each feature
Status Frequency History
Below is a visualization of the history for current_conditions.csv over the last 60 days. Each bar represents the breakdown properties_Status, across the 13 sections of the canal. current_conditions.csv is updated 3 times per day, therefore there are 3 bars per day.
The ice conditions data shown on the map can be accessed from the ESRI feature layer
Esri Dump. This allows you to quickly dump a ESRI REST endpoint to GeoJSON. .
import json
from esridump.dumper import EsriDumper
d = EsriDumper('http://example.com/arcgis/rest/services/Layer/MapServer/1')
# Iterate over each feature
for feature in d:
print(json.dumps(feature))
d = EsriDumper('http://example.com/arcgis/rest/services/Layer/MapServer/2')
# Or get all features in one list
all_features = list(d)
Here is an example of the python, and feel free to use this as the starting point for your own experiment transforming geo data to tabular.
View the Data Data –>
This technique using Esri Dump should be reusable with a huge number of Geospatial datasets from the Open Maps collection on Open.Canada.ca.