superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 23, MNG_AG_TYP = 3 and PARK_NAME = "Veren Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10786 | 10786 | 10785 | {"type": "Polygon", "coordinates": [[[-121.65535, 36.14492], [-121.65525, 36.14864], [-121.65386, 36.14763], [-121.65385, 36.14752], [-121.65399, 36.14735], [-121.65389, 36.14607], [-121.65374, 36.14584], [-121.65341, 36.14576], [-121.65314, 36.14575], [-121.65293, 36.1453], [-121.65272, 36.14538], [-121.65239, 36.14573], [-121.65235, 36.14542], [-121.65198, 36.14474], [-121.65177, 36.14463], [-121.65147, 36.14463], [-121.65137, 36.14468], [-121.65116, 36.14459], [-121.65079, 36.14454], [-121.65052, 36.14463], [-121.65059, 36.1445], [-121.65066, 36.14424], [-121.65068, 36.14402], [-121.6505, 36.14395], [-121.6499, 36.1439], [-121.64972, 36.14395], [-121.64996, 36.14376], [-121.65037, 36.14371], [-121.65056, 36.1435], [-121.6513, 36.14321], [-121.65163, 36.14301], [-121.65169, 36.14305], [-121.65195, 36.14289], [-121.65201, 36.14294], [-121.65211, 36.14287], [-121.65237, 36.14286], [-121.65256, 36.14307], [-121.65324, 36.14282], [-121.65369, 36.14283], [-121.65387, 36.14319], [-121.65407, 36.14339], [-121.65407, 36.14365], [-121.65414, 36.14379], [-121.65407, 36.14384], [-121.65378, 36.14355], [-121.65334, 36.14345], [-121.65332, 36.14351], [-121.65359, 36.14366], [-121.65385, 36.14418], [-121.65378, 36.1444], [-121.65365, 36.1441], [-121.65331, 36.14395], [-121.65324, 36.144], [-121.65348, 36.1442], [-121.65351, 36.14468], [-121.65363, 36.14478], [-121.65396, 36.14481], [-121.65438, 36.14473], [-121.65458, 36.1449], [-121.65465, 36.14506], [-121.65535, 36.14492]]]} | Open Access 1 | Veren Park | 26993 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 28.056 | Veren 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]);