Iterate over each feature
Condition Status Map
Below is a export of the current GeoJSON Map.
The GeoJSON can be viewed as an interactive map at https://geojson.io/#id=github:PatLittle/skateway_data/blob/main/status_styled.geojson&map=13.23/45.40468/-75.69245
Mermaid Gantt Chart
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.
This technique using Esri Dump should be reusable with a huge number of Geospatial datasets from the Open Maps collection on Open.Canada.ca.