superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LABEL_NAME = "Legion Park" and MNG_AGENCY = 510
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6085 | 6085 | 6084 | {"type": "MultiPolygon", "coordinates": [[[[-120.97536, 37.62596], [-120.9748, 37.62595], [-120.97479, 37.62474], [-120.97378, 37.62412], [-120.97343, 37.62388], [-120.97081, 37.62291], [-120.96924, 37.62277], [-120.96846, 37.62263], [-120.96623, 37.62277], [-120.96624, 37.62248], [-120.96668, 37.62245], [-120.96805, 37.62223], [-120.96922, 37.62197], [-120.96923, 37.62201], [-120.96928, 37.62202], [-120.96968, 37.62203], [-120.96993, 37.62209], [-120.97009, 37.62211], [-120.97045, 37.6222], [-120.9706, 37.62227], [-120.97085, 37.62234], [-120.97115, 37.62249], [-120.97136, 37.62253], [-120.97151, 37.62258], [-120.97163, 37.62259], [-120.97209, 37.62284], [-120.97268, 37.62302], [-120.97377, 37.62362], [-120.97409, 37.62385], [-120.9743, 37.62397], [-120.97439, 37.62406], [-120.97473, 37.62425], [-120.97536, 37.62465], [-120.97536, 37.62596]]], [[[-120.97632, 37.62587], [-120.97555, 37.62588], [-120.97553, 37.62609], [-120.97542, 37.62609], [-120.97542, 37.62469], [-120.97564, 37.62482], [-120.97575, 37.62485], [-120.97582, 37.6249], [-120.97604, 37.62499], [-120.97604, 37.62558], [-120.97632, 37.6256], [-120.97632, 37.62587]]]]} | Open Access 1 | Legion Park | 21142 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 14.814 | Legion Park | ||
6086 | 6086 | 6085 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | Legion Park | 21143 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.196 | Legion Park |
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]);