superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Uvas Canyon County 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12317 | 12317 | 12316 | {"type": "Polygon", "coordinates": [[[-121.81889, 37.09054], [-121.81048, 37.09054], [-121.81034, 37.08688], [-121.79689, 37.08693], [-121.79604, 37.08665], [-121.79596, 37.08665], [-121.79463, 37.08629], [-121.79413, 37.08608], [-121.79233, 37.08564], [-121.79227, 37.0833], [-121.78772, 37.0833], [-121.78761, 37.07967], [-121.78311, 37.07967], [-121.783, 37.07604], [-121.77853, 37.07588], [-121.7785, 37.07389], [-121.77965, 37.0739], [-121.77967, 37.07389], [-121.77961, 37.07213], [-121.77848, 37.07211], [-121.77845, 37.06896], [-121.78283, 37.06913], [-121.78769, 37.06913], [-121.78753, 37.06216], [-121.78781, 37.06223], [-121.7881, 37.06235], [-121.78815, 37.06242], [-121.78821, 37.06275], [-121.78827, 37.06284], [-121.78838, 37.0629], [-121.78871, 37.06293], [-121.78884, 37.06297], [-121.78899, 37.0631], [-121.78915, 37.06332], [-121.78925, 37.06339], [-121.78938, 37.06341], [-121.78961, 37.0634], [-121.78972, 37.06342], [-121.78981, 37.06347], [-121.78999, 37.06366], [-121.79011, 37.06372], [-121.7902, 37.06373], [-121.79047, 37.0637], [-121.7907, 37.06379], [-121.79104, 37.06379], [-121.79109, 37.06382], [-121.79121, 37.06393], [-121.79138, 37.06398], [-121.79206, 37.06397], [-121.79215, 37.06913], [-121.79189, 37.06916], [-121.79198, 37.07255], [-121.7966, 37.07257], [-121.7967, 37.07602], [-121.801, 37.07602], [-121.81385, 37.07584], [-121.8139, 37.07836], [-121.81731, 37.07833], [-121.81733, 37.07854], [-121.81723, 37.07871], [-121.81718, 37.07886], [-121.81713, 37.07896], [-121.81706, 37.07904], [-121.81691, 37.07916], [-121.81662, 37.07932], [-121.81652, 37.07945], [-121.81649, 37.0796], [-121.81652, 37.07976], [-121.81651, 37.07993], [-121.81394, 37.07997], [-121.814, 37.08313], [-121.81768, 37.0831], [-121.81776, 37.08319], [-121.81789, 37.0833], [-121.81796, 37.08338], [-121.818, 37.08347], [-121.81805, 37.08368], [-121.81814, 37.08381], [-121.81822, 37.08387], [-121.81831, 37.0839], [-121.8187, 37.08397], [-121.81889, 37.09054]]]} | Open Access 1 | Uvas Canyon County Park | http://www.sccgov.org/sites/parks/parkfinder/Pages/UvasCanyon.aspx | 29312 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 1146.222 | Uvas Canyon County 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]);