superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Janes Creek Meadows Openspace" and MNG_AGENCY = 577
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13319 | 13319 | 13318 | {"type": "Polygon", "coordinates": [[[-124.08511, 40.88587], [-124.08396, 40.88873], [-124.08299, 40.88851], [-124.08291, 40.88869], [-124.08254, 40.8887], [-124.08248, 40.88873], [-124.08231, 40.88899], [-124.08225, 40.889], [-124.08209, 40.88899], [-124.0825, 40.88849], [-124.08255, 40.88846], [-124.08271, 40.88841], [-124.08299, 40.8884], [-124.08333, 40.88846], [-124.08346, 40.88813], [-124.08351, 40.88808], [-124.0837, 40.88795], [-124.08381, 40.8877], [-124.08407, 40.88743], [-124.08412, 40.88735], [-124.08413, 40.88722], [-124.08402, 40.88687], [-124.08407, 40.88654], [-124.08409, 40.88648], [-124.08416, 40.8864], [-124.08428, 40.88634], [-124.08431, 40.88628], [-124.08427, 40.88623], [-124.08392, 40.88608], [-124.08335, 40.88579], [-124.08313, 40.88574], [-124.08272, 40.88604], [-124.0824, 40.88632], [-124.08238, 40.88637], [-124.08241, 40.8865], [-124.0824, 40.8867], [-124.08231, 40.88697], [-124.08161, 40.88806], [-124.08155, 40.88806], [-124.0815, 40.88804], [-124.08147, 40.888], [-124.08147, 40.88789], [-124.08148, 40.88782], [-124.08156, 40.88762], [-124.08194, 40.88678], [-124.08197, 40.88667], [-124.08197, 40.88643], [-124.08192, 40.8863], [-124.08184, 40.88613], [-124.08275, 40.88537], [-124.08511, 40.88587]]]} | Open Access 1 | Janes Creek Meadows Openspace | 30682 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 8.931 | Janes Creek Meadows Openspace |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);