superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Civic Ctr. Lagoon Park" and MNG_AG_TYP = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15539 | 15539 | 15538 | {"type": "Polygon", "coordinates": [[[-122.53671, 38.00113], [-122.53636, 38.00112], [-122.53598, 38.00094], [-122.53585, 38.00113], [-122.53575, 38.00113], [-122.53448, 38.00304], [-122.53437, 38.00314], [-122.53264, 38.00397], [-122.52966, 38.00525], [-122.52941, 38.00533], [-122.52915, 38.00539], [-122.52888, 38.00542], [-122.52862, 38.00541], [-122.52829, 38.00536], [-122.52663, 38.00495], [-122.5291, 38.00327], [-122.52684, 38.00151], [-122.52722, 38.00121], [-122.52735, 38.00129], [-122.52947, 37.99959], [-122.52899, 37.9992], [-122.52905, 37.99915], [-122.52905, 37.99913], [-122.52833, 37.99856], [-122.52883, 37.99815], [-122.52883, 37.99814], [-122.52788, 37.99739], [-122.52834, 37.99703], [-122.52839, 37.99701], [-122.52845, 37.99701], [-122.5285, 37.99704], [-122.52855, 37.99702], [-122.52882, 37.99679], [-122.52881, 37.9967], [-122.52883, 37.99666], [-122.52916, 37.9964], [-122.52958, 37.99605], [-122.52996, 37.99569], [-122.5305, 37.99536], [-122.53086, 37.99535], [-122.53126, 37.99554], [-122.53206, 37.99559], [-122.53224, 37.99562], [-122.53249, 37.99571], [-122.53264, 37.99579], [-122.53284, 37.99594], [-122.53309, 37.99622], [-122.53338, 37.99649], [-122.53575, 37.99984], [-122.53671, 38.00113]]]} | Open Access 1 | Civic Center Lagoon Park | 17350 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 137.024 | Civic Ctr. Lagoon 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]);