superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where PARK_NAME = "Lighthouse Field State Beach"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 2
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15121 | 15121 | 15120 | {"type": "MultiPolygon", "coordinates": [[[[-122.03263, 36.95389], [-122.03168, 36.95398], [-122.03166, 36.95402], [-122.02508, 36.95468], [-122.02561, 36.95329], [-122.02585, 36.95287], [-122.0259, 36.95286], [-122.02613, 36.95258], [-122.02622, 36.95243], [-122.02627, 36.95229], [-122.02621, 36.95222], [-122.02632, 36.95209], [-122.02648, 36.952], [-122.02667, 36.95197], [-122.02711, 36.95198], [-122.0273, 36.95202], [-122.0281, 36.95227], [-122.02834, 36.95231], [-122.02866, 36.95234], [-122.0289, 36.95234], [-122.02979, 36.95218], [-122.03066, 36.95216], [-122.03135, 36.95203], [-122.03162, 36.952], [-122.03188, 36.952], [-122.03228, 36.95205], [-122.03233, 36.95207], [-122.03263, 36.95389]]], [[[-122.03229, 36.95194], [-122.03219, 36.95192], [-122.03218, 36.95196], [-122.03186, 36.95192], [-122.0316, 36.95192], [-122.03132, 36.95195], [-122.03069, 36.95207], [-122.02978, 36.9521], [-122.02889, 36.95226], [-122.02866, 36.95226], [-122.02819, 36.95221], [-122.02819, 36.95188], [-122.02831, 36.95192], [-122.02843, 36.95202], [-122.02864, 36.95208], [-122.0288, 36.9521], [-122.02887, 36.95203], [-122.02888, 36.95197], [-122.02904, 36.95195], [-122.02916, 36.95198], [-122.0293, 36.95205], [-122.02938, 36.95206], [-122.02942, 36.95205], [-122.02953, 36.95194], [-122.02967, 36.95192], [-122.02985, 36.95188], [-122.02993, 36.95178], [-122.03, 36.95178], [-122.03023, 36.95172], [-122.03023, 36.95166], [-122.03024, 36.95164], [-122.0304, 36.95174], [-122.03059, 36.95173], [-122.03069, 36.9517], [-122.03072, 36.95168], [-122.03079, 36.9517], [-122.031, 36.9517], [-122.03116, 36.95162], [-122.0313, 36.9516], [-122.03135, 36.95157], [-122.03138, 36.95153], [-122.0314, 36.95141], [-122.03143, 36.95139], [-122.03148, 36.95141], [-122.03149, 36.95143], [-122.03145, 36.95149], [-122.03144, 36.95155], [-122.03148, 36.95163], [-122.03157, 36.95161], [-122.03167, 36.95167], [-122.0317, 36.9517], [-122.03178, 36.9517], [-122.03183, 36.95173], [-122.03195, 36.95171], [-122.03206, 36.95172], [-122.03215, 36.95178], [-122.03228, 36.95181], [-122.03229, 36.95194]]]]} | Open Access 1 | Lighthouse Field State Beach | http://www.parks.ca.gov/?page_id=550 | 1605 | 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 | 38.474 | Lighthouse Field SB | 1978 |
15167 | 15167 | 15166 | {"type": "MultiPolygon", "coordinates": [[[[-122.02819, 36.95221], [-122.02734, 36.95194], [-122.02712, 36.9519], [-122.0266, 36.95189], [-122.0264, 36.95193], [-122.02623, 36.95203], [-122.02612, 36.95217], [-122.02604, 36.95238], [-122.02594, 36.95255], [-122.02585, 36.95252], [-122.02559, 36.95287], [-122.02549, 36.95286], [-122.02547, 36.95282], [-122.0254, 36.95277], [-122.02542, 36.95275], [-122.02547, 36.95275], [-122.0255, 36.95272], [-122.02551, 36.95268], [-122.0255, 36.95258], [-122.02551, 36.95253], [-122.02561, 36.95261], [-122.02567, 36.95261], [-122.02583, 36.9525], [-122.02594, 36.95232], [-122.02599, 36.95232], [-122.02596, 36.95216], [-122.02586, 36.95205], [-122.02584, 36.95195], [-122.02584, 36.95187], [-122.02588, 36.95181], [-122.02595, 36.95176], [-122.02604, 36.95177], [-122.02602, 36.9517], [-122.02603, 36.95156], [-122.02601, 36.95153], [-122.02587, 36.95145], [-122.02587, 36.95137], [-122.02595, 36.95118], [-122.02609, 36.95108], [-122.02615, 36.95114], [-122.02616, 36.95122], [-122.0263, 36.95131], [-122.02639, 36.95133], [-122.02644, 36.95132], [-122.02647, 36.95129], [-122.02647, 36.95118], [-122.02654, 36.95106], [-122.02655, 36.95099], [-122.02649, 36.95085], [-122.02647, 36.95057], [-122.02651, 36.9505], [-122.02653, 36.9504], [-122.02655, 36.95038], [-122.02659, 36.95039], [-122.02674, 36.95059], [-122.0267, 36.95074], [-122.0267, 36.95082], [-122.02671, 36.95086], [-122.02677, 36.95093], [-122.02678, 36.95099], [-122.0268, 36.95099], [-122.02683, 36.95096], [-122.02683, 36.95077], [-122.02688, 36.95071], [-122.02695, 36.95071], [-122.02706, 36.95083], [-122.02708, 36.95096], [-122.02693, 36.95104], [-122.02689, 36.95111], [-122.02696, 36.95112], [-122.02702, 36.9511], [-122.02705, 36.95111], [-122.02703, 36.95123], [-122.02706, 36.95127], [-122.02709, 36.9514], [-122.02719, 36.95155], [-122.02732, 36.95167], [-122.02736, 36.95166], [-122.02738, 36.95162], [-122.02746, 36.95163], [-122.02762, 36.95175], [-122.02765, 36.95175], [-122.02767, 36.95173], [-122.02773, 36.95174], [-122.02773, 36.95165], [-122.02779, 36.95164], [-122.02795, 36.95178], [-122.02796, 36.95182], [-122.02801, 36.95188], [-122.0281, 36.95192], [-122.02819, 36.95188], [-122.02819, 36.95221]]], [[[-122.03355, 36.95212], [-122.03327, 36.95213], [-122.0328, 36.95202], [-122.0323, 36.95194], [-122.03229, 36.95186], [-122.03352, 36.95195], [-122.03355, 36.95212]]]]} | Open Access 1 | Lighthouse Field State Beach | http://www.parks.ca.gov/?page_id=550 | 21231 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 4.447 | Lighthouse Field SB | 1978 |
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]);