superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where PARK_NAME = "Silver Strand State Beach"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15163 | 15163 | 15162 | {"type": "MultiPolygon", "coordinates": [[[[-117.20426, 32.64359], [-117.16473, 32.66737], [-117.16448, 32.66717], [-117.16425, 32.66694], [-117.16363, 32.66626], [-117.16331, 32.66598], [-117.16307, 32.66571], [-117.1626, 32.66504], [-117.1621, 32.66445], [-117.16187, 32.66422], [-117.16165, 32.66393], [-117.16114, 32.66336], [-117.16064, 32.66286], [-117.16043, 32.66261], [-117.16029, 32.66237], [-117.16021, 32.66217], [-117.16003, 32.66169], [-117.15987, 32.66144], [-117.15963, 32.66114], [-117.15946, 32.66097], [-117.15929, 32.66077], [-117.15888, 32.66005], [-117.15812, 32.65921], [-117.15793, 32.65906], [-117.15755, 32.65871], [-117.15739, 32.65851], [-117.1571, 32.65799], [-117.15694, 32.65776], [-117.15677, 32.65757], [-117.15658, 32.65739], [-117.15621, 32.65698], [-117.15593, 32.65663], [-117.15578, 32.6564], [-117.15564, 32.65608], [-117.15498, 32.65501], [-117.15477, 32.65474], [-117.15427, 32.65402], [-117.15389, 32.65331], [-117.15368, 32.65306], [-117.15319, 32.65226], [-117.153, 32.65202], [-117.15283, 32.65174], [-117.15258, 32.6512], [-117.15201, 32.65045], [-117.15173, 32.65013], [-117.1509, 32.64872], [-117.15066, 32.64835], [-117.15043, 32.64805], [-117.15027, 32.64776], [-117.15012, 32.64743], [-117.14982, 32.64691], [-117.14918, 32.64598], [-117.14897, 32.64562], [-117.1489, 32.64538], [-117.14861, 32.64471], [-117.14842, 32.64437], [-117.14816, 32.64397], [-117.14802, 32.64365], [-117.14779, 32.64331], [-117.14732, 32.6424], [-117.14691, 32.64169], [-117.14656, 32.64096], [-117.14644, 32.64064], [-117.14626, 32.64031], [-117.14614, 32.64002], [-117.14562, 32.63901], [-117.14545, 32.63873], [-117.1452, 32.63826], [-117.14512, 32.63797], [-117.14503, 32.63778], [-117.14467, 32.63727], [-117.14454, 32.63704], [-117.14449, 32.6369], [-117.14311, 32.63735], [-117.13987, 32.63049], [-117.13885, 32.62751], [-117.13852, 32.62479], [-117.13721, 32.62253], [-117.13696, 32.62176], [-117.13565, 32.61698], [-117.13482, 32.61274], [-117.13469, 32.61226], [-117.13446, 32.61168], [-117.13416, 32.61113], [-117.13395, 32.61082], [-117.13299, 32.60954], [-117.13489, 32.60924], [-117.18518, 32.60043], [-117.18826, 32.60889], [-117.19042, 32.6163], [-117.19451, 32.62552], [-117.19672, 32.63018], [-117.19795, 32.63266], [-117.2007, 32.6379], [-117.20216, 32.64043], [-117.20426, 32.64359]]], [[[-117.14429, 32.64116], [-117.1407, 32.64241], [-117.14059, 32.64218], [-117.14048, 32.64203], [-117.14043, 32.64187], [-117.14017, 32.6415], [-117.14007, 32.64129], [-117.13984, 32.64074], [-117.13974, 32.64062], [-117.13961, 32.6404], [-117.13947, 32.64024], [-117.13916, 32.63967], [-117.13885, 32.63918], [-117.13845, 32.63862], [-117.13836, 32.63843], [-117.13828, 32.63832], [-117.13816, 32.63808], [-117.13816, 32.63798], [-117.13819, 32.63796], [-117.13826, 32.638], [-117.13837, 32.63816], [-117.13868, 32.63816], [-117.13894, 32.63824], [-117.13911, 32.63825], [-117.13925, 32.63823], [-117.13949, 32.63809], [-117.13979, 32.63784], [-117.14001, 32.63772], [-117.14027, 32.6376], [-117.14048, 32.63748], [-117.14069, 32.63742], [-117.14088, 32.63733], [-117.141, 32.6373], [-117.14109, 32.63724], [-117.14118, 32.63714], [-117.14125, 32.63701], [-117.14126, 32.63687], [-117.14126, 32.6366], [-117.14119, 32.63638], [-117.14112, 32.63623], [-117.14067, 32.63579], [-117.1405, 32.63569], [-117.14031, 32.63573], [-117.14008, 32.63581], [-117.13982, 32.6358], [-117.13977, 32.6356], [-117.1397, 32.63551], [-117.13941, 32.63543], [-117.1393, 32.63529], [-117.1392, 32.63499], [-117.13913, 32.63449], [-117.13913, 32.6343], [-117.13916, 32.6341], [-117.13915, 32.63399], [-117.13911, 32.63388], [-117.13887, 32.63358], [-117.13876, 32.63339], [-117.13873, 32.63313], [-117.13876, 32.6328], [-117.13871, 32.63265], [-117.1385, 32.63249], [-117.13838, 32.63233], [-117.13821, 32.63203], [-117.13817, 32.63181], [-117.13812, 32.63164], [-117.13805, 32.63147], [-117.13793, 32.63129], [-117.1379, 32.63117], [-117.13791, 32.63093], [-117.1379, 32.63076], [-117.1378, 32.63027], [-117.13907, 32.62998], [-117.13948, 32.63097], [-117.14245, 32.63727], [-117.14429, 32.64116]]]]} | Open Access 1 | Silver Strand State Beach | http://www.parks.ca.gov/?page_id=654 | 1743 | 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 | 7388.084 | Silver Strand SB | 1932 |
15174 | 15174 | 15173 | {"type": "Polygon", "coordinates": [[[-117.16473, 32.66737], [-117.16316, 32.66872], [-117.16032, 32.66552], [-117.15991, 32.66503], [-117.1595, 32.66449], [-117.15649, 32.6603], [-117.15592, 32.65948], [-117.15535, 32.6586], [-117.15511, 32.65827], [-117.1549, 32.6579], [-117.15469, 32.65759], [-117.15381, 32.65642], [-117.15356, 32.65605], [-117.1533, 32.65555], [-117.15302, 32.65509], [-117.15274, 32.65456], [-117.15243, 32.65395], [-117.15204, 32.65331], [-117.15173, 32.65276], [-117.15042, 32.65008], [-117.15011, 32.64955], [-117.14975, 32.64907], [-117.14901, 32.64826], [-117.14839, 32.64751], [-117.1481, 32.64718], [-117.14787, 32.64688], [-117.14766, 32.64656], [-117.14744, 32.64616], [-117.14311, 32.63735], [-117.14449, 32.63689], [-117.14455, 32.63704], [-117.14467, 32.63727], [-117.14503, 32.63777], [-117.14512, 32.63797], [-117.14521, 32.63826], [-117.14545, 32.63872], [-117.14562, 32.63901], [-117.14614, 32.64002], [-117.14626, 32.64031], [-117.14644, 32.64064], [-117.14656, 32.64097], [-117.14691, 32.64169], [-117.14732, 32.6424], [-117.14779, 32.64331], [-117.14802, 32.64365], [-117.14816, 32.64397], [-117.14842, 32.64437], [-117.14861, 32.64471], [-117.1489, 32.64538], [-117.14897, 32.64562], [-117.14918, 32.64598], [-117.14982, 32.64691], [-117.15012, 32.64743], [-117.15027, 32.64776], [-117.15043, 32.64805], [-117.15066, 32.64835], [-117.1509, 32.64872], [-117.15173, 32.65013], [-117.15201, 32.65045], [-117.15258, 32.6512], [-117.15283, 32.65174], [-117.153, 32.65202], [-117.15319, 32.65226], [-117.15368, 32.65306], [-117.15389, 32.65331], [-117.15427, 32.65402], [-117.15477, 32.65474], [-117.15498, 32.65501], [-117.15564, 32.65609], [-117.15578, 32.6564], [-117.15593, 32.65663], [-117.15621, 32.65698], [-117.15658, 32.65739], [-117.15677, 32.65757], [-117.15694, 32.65776], [-117.1571, 32.65799], [-117.15739, 32.65851], [-117.15755, 32.65871], [-117.15793, 32.65906], [-117.15812, 32.65921], [-117.15889, 32.66005], [-117.15929, 32.66077], [-117.15946, 32.66097], [-117.15963, 32.66114], [-117.15987, 32.66144], [-117.16003, 32.66169], [-117.16021, 32.66217], [-117.16029, 32.66237], [-117.16043, 32.66261], [-117.16064, 32.66286], [-117.16114, 32.66336], [-117.16165, 32.66393], [-117.16187, 32.66422], [-117.1621, 32.66445], [-117.1626, 32.66505], [-117.16307, 32.66571], [-117.16331, 32.66598], [-117.16363, 32.66626], [-117.16425, 32.66694], [-117.16448, 32.66717], [-117.16473, 32.66737]]]} | No Public Access 3 | Silver Strand State Beach | http://www.parks.ca.gov/?page_id=654 | 30694 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 158.394 | Silver Strand SB | 1932 |
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]);