-
-
Notifications
You must be signed in to change notification settings - Fork 2
Closed
Labels
enhancementNew feature or requestNew feature or request
Description
The county park shapefiles from #5 use EPSG:2227 (California 3) as their projection.
I had to hack the script around to import the data correctly. I replaced 4326 with 2227 in a couple of places:
| conversions = {"geometry": "GeomFromText(?, 4326)"} |
| "SELECT AddGeometryColumn(?, 'geometry', 4326, 'GEOMETRY', 2);", [table] |
Then to get the data to show correctly as a GeoJSON-powered map I had to use this in the queries:
select AsGeoJSON(Transform(geometry, 4326)) as geojson ...
Demo: https://santa-clara-county-parks-j7hipcg4aq-uc.a.run.app/parks/park_boundary_maps
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or request