superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Harmony Headlands SP" and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15239 | 15239 | 15238 | {"type": "Polygon", "coordinates": [[[-121.02028, 35.47854], [-121.01594, 35.47853], [-121.01589, 35.48252], [-120.99801, 35.48234], [-120.998, 35.48236], [-120.99816, 35.4829], [-120.99834, 35.48332], [-120.99801, 35.48376], [-120.99811, 35.48438], [-120.99742, 35.48323], [-120.997, 35.48245], [-120.99622, 35.48139], [-120.99538, 35.48054], [-120.99433, 35.47971], [-120.99213, 35.47823], [-120.99223, 35.47785], [-120.99196, 35.47768], [-120.99135, 35.47686], [-120.99132, 35.47665], [-120.99205, 35.4754], [-120.99749, 35.4713], [-121.00653, 35.46592], [-121.00653, 35.464], [-121.00774, 35.464], [-121.00779, 35.46405], [-121.00794, 35.46438], [-121.00813, 35.46456], [-121.00831, 35.46456], [-121.00821, 35.46476], [-121.00827, 35.46492], [-121.00818, 35.46505], [-121.00838, 35.46508], [-121.00853, 35.46526], [-121.00867, 35.46537], [-121.00854, 35.46545], [-121.00854, 35.46546], [-121.00877, 35.46554], [-121.00876, 35.46571], [-121.00887, 35.46579], [-121.00871, 35.46595], [-121.00895, 35.46598], [-121.00896, 35.46606], [-121.00891, 35.46623], [-121.00899, 35.46632], [-121.00891, 35.46647], [-121.00899, 35.46663], [-121.00923, 35.46664], [-121.00929, 35.46692], [-121.00953, 35.46701], [-121.00951, 35.46718], [-121.00957, 35.46753], [-121.00962, 35.46771], [-121.00982, 35.4678], [-121.01, 35.46764], [-121.01026, 35.46796], [-121.0106, 35.46813], [-121.01054, 35.46835], [-121.01072, 35.46838], [-121.01089, 35.46855], [-121.011, 35.46887], [-121.01119, 35.46891], [-121.01147, 35.46893], [-121.01148, 35.46907], [-121.01131, 35.46932], [-121.01143, 35.46954], [-121.01208, 35.46996], [-121.01226, 35.47003], [-121.01226, 35.47018], [-121.01242, 35.47034], [-121.01252, 35.47064], [-121.01249, 35.47078], [-121.01234, 35.47083], [-121.01233, 35.47093], [-121.01274, 35.47102], [-121.01262, 35.47112], [-121.01262, 35.47114], [-121.0131, 35.47132], [-121.01312, 35.47138], [-121.01327, 35.47176], [-121.01343, 35.47208], [-121.01366, 35.47224], [-121.01373, 35.47241], [-121.01396, 35.47256], [-121.0142, 35.4726], [-121.01428, 35.4727], [-121.01449, 35.47266], [-121.01455, 35.47255], [-121.01471, 35.47263], [-121.01481, 35.47282], [-121.01494, 35.47286], [-121.01539, 35.47311], [-121.01553, 35.47334], [-121.01561, 35.47393], [-121.01578, 35.47413], [-121.01598, 35.47418], [-121.01616, 35.47431], [-121.01637, 35.47434], [-121.01645, 35.47447], [-121.01661, 35.47458], [-121.01659, 35.47473], [-121.01677, 35.47477], [-121.01687, 35.47504], [-121.01689, 35.47516], [-121.01708, 35.47521], [-121.01743, 35.47551], [-121.01772, 35.47584], [-121.01798, 35.47617], [-121.01814, 35.47664], [-121.01833, 35.47657], [-121.01834, 35.47681], [-121.01845, 35.47696], [-121.01872, 35.47696], [-121.01885, 35.47685], [-121.01884, 35.47696], [-121.01901, 35.47725], [-121.01906, 35.47749], [-121.0194, 35.47758], [-121.01981, 35.47822], [-121.0201, 35.47838], [-121.02028, 35.47854]]]} | Open Access 1 | Harmony Headlands State Park | http://www.parks.ca.gov/?page_id=25735 | 1555 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 748.73 | Harmony Headlands SP | 2003 |
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]);