units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 47 and UNIT_NAME = "Refugio State Beach"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16435 | 16435 | 16434 | {"type": "MultiPolygon", "coordinates": [[[[-120.08969, 34.46038], [-120.08959, 34.46076], [-120.08875, 34.46077], [-120.08808, 34.46082], [-120.08751, 34.46087], [-120.08679, 34.46097], [-120.08613, 34.46104], [-120.08462, 34.46123], [-120.0842, 34.46126], [-120.08303, 34.46119], [-120.07792, 34.46063], [-120.07688, 34.46057], [-120.07602, 34.46059], [-120.07592, 34.46063], [-120.07574, 34.46066], [-120.07534, 34.46076], [-120.07498, 34.46092], [-120.07462, 34.46111], [-120.07412, 34.46146], [-120.07379, 34.46177], [-120.07322, 34.46241], [-120.07275, 34.46307], [-120.07246, 34.46345], [-120.07194, 34.46395], [-120.07158, 34.46422], [-120.07113, 34.46445], [-120.07073, 34.46462], [-120.07015, 34.46467], [-120.06967, 34.46469], [-120.0692, 34.46466], [-120.0689, 34.46462], [-120.06836, 34.46438], [-120.06699, 34.46369], [-120.06563, 34.463], [-120.06515, 34.46273], [-120.06441, 34.46254], [-120.06384, 34.46242], [-120.06245, 34.46218], [-120.06153, 34.46206], [-120.05989, 34.4618], [-120.05947, 34.46175], [-120.05826, 34.46166], [-120.05737, 34.46166], [-120.05664, 34.4617], [-120.05611, 34.4617], [-120.0555, 34.46175], [-120.05458, 34.46186], [-120.05285, 34.4621], [-120.05079, 34.46231], [-120.05016, 34.46236], [-120.04992, 34.46241], [-120.04838, 34.46261], [-120.04765, 34.46268], [-120.0424, 34.46342], [-120.04184, 34.46346], [-120.04112, 34.46357], [-120.03919, 34.46374], [-120.03861, 34.46377], [-120.03827, 34.46377], [-120.03594, 34.46366], [-120.03363, 34.46345], [-120.03231, 34.46336], [-120.03219, 34.46333], [-120.03264, 34.46186], [-120.03327, 34.46209], [-120.03471, 34.46252], [-120.03518, 34.46271], [-120.03602, 34.46293], [-120.03709, 34.46315], [-120.03749, 34.46321], [-120.03857, 34.46334], [-120.03921, 34.46335], [-120.04222, 34.46318], [-120.04278, 34.46307], [-120.0433, 34.46299], [-120.04343, 34.46298], [-120.04383, 34.4629], [-120.04425, 34.46278], [-120.04485, 34.46266], [-120.04511, 34.46251], [-120.04536, 34.46246], [-120.0456, 34.46238], [-120.04611, 34.46231], [-120.04658, 34.46229], [-120.04687, 34.46222], [-120.04705, 34.46208], [-120.04704, 34.46193], [-120.04709, 34.46186], [-120.04731, 34.46191], [-120.04745, 34.46191], [-120.04815, 34.46189], [-120.04881, 34.46183], [-120.04905, 34.46185], [-120.04933, 34.4618], [-120.04945, 34.46164], [-120.04979, 34.46152], [-120.05001, 34.4615], [-120.0504, 34.46157], [-120.05074, 34.46158], [-120.05103, 34.46162], [-120.05178, 34.46167], [-120.05239, 34.46168], [-120.05258, 34.46171], [-120.05282, 34.46181], [-120.05298, 34.46183], [-120.05326, 34.46183], [-120.05386, 34.46175], [-120.05462, 34.46175], [-120.05498, 34.46166], [-120.05521, 34.46155], [-120.05533, 34.46141], [-120.05549, 34.46128], [-120.05593, 34.46123], [-120.05614, 34.46124], [-120.05634, 34.46124], [-120.05693, 34.46116], [-120.05702, 34.46116], [-120.05725, 34.46121], [-120.05738, 34.46121], [-120.05749, 34.46111], [-120.05759, 34.46096], [-120.05771, 34.46099], [-120.05785, 34.46107], [-120.05824, 34.46114], [-120.05923, 34.46121], [-120.05974, 34.46126], [-120.06057, 34.46147], [-120.06113, 34.46158], [-120.06336, 34.46187], [-120.06371, 34.46187], [-120.06396, 34.4619], [-120.06452, 34.46198], [-120.06579, 34.46208], [-120.06684, 34.46222], [-120.06724, 34.46232], [-120.06781, 34.46248], [-120.06843, 34.46258], [-120.06884, 34.46263], [-120.06997, 34.46264], [-120.07143, 34.4624], [-120.07246, 34.46211], [-120.07319, 34.46179], [-120.0734, 34.46162], [-120.07357, 34.46137], [-120.07356, 34.46111], [-120.07333, 34.46076], [-120.0735, 34.46063], [-120.07372, 34.46055], [-120.07413, 34.46044], [-120.07425, 34.46037], [-120.07463, 34.46037], [-120.07549, 34.46042], [-120.07571, 34.46039], [-120.07597, 34.46026], [-120.07637, 34.46036], [-120.07856, 34.46042], [-120.0788, 34.46046], [-120.07899, 34.46046], [-120.08026, 34.46034], [-120.0811, 34.46033], [-120.082, 34.46041], [-120.08269, 34.46038], [-120.08301, 34.46043], [-120.08379, 34.4603], [-120.08467, 34.46041], [-120.08508, 34.46035], [-120.08571, 34.4603], [-120.08617, 34.46023], [-120.08701, 34.46021], [-120.0874, 34.46016], [-120.08796, 34.46019], [-120.08828, 34.46022], [-120.08853, 34.46017], [-120.08888, 34.4602], [-120.08969, 34.46038]]], [[[-120.07916, 34.46104], [-120.07914, 34.4611], [-120.07903, 34.46115], [-120.07881, 34.4612], [-120.0784, 34.46122], [-120.07813, 34.46128], [-120.07783, 34.46138], [-120.07696, 34.46199], [-120.07661, 34.4622], [-120.07617, 34.46242], [-120.07518, 34.4628], [-120.07486, 34.46299], [-120.07466, 34.46315], [-120.07451, 34.46332], [-120.07429, 34.46368], [-120.07415, 34.46386], [-120.07401, 34.46398], [-120.07317, 34.46446], [-120.07304, 34.46451], [-120.07271, 34.46456], [-120.07238, 34.46466], [-120.07205, 34.46481], [-120.07167, 34.46495], [-120.07126, 34.46504], [-120.07092, 34.46509], [-120.07003, 34.4652], [-120.06961, 34.46521], [-120.06927, 34.4652], [-120.06911, 34.46515], [-120.0688, 34.465], [-120.06855, 34.46493], [-120.06794, 34.46487], [-120.06731, 34.46476], [-120.06701, 34.46463], [-120.06671, 34.46446], [-120.06652, 34.46423], [-120.06624, 34.46395], [-120.06602, 34.46369], [-120.06581, 34.46349], [-120.0656, 34.46336], [-120.06545, 34.4633], [-120.06519, 34.46325], [-120.06418, 34.46335], [-120.06384, 34.46335], [-120.06329, 34.4633], [-120.06292, 34.46325], [-120.06257, 34.46315], [-120.06199, 34.46289], [-120.0617, 34.46273], [-120.06144, 34.46253], [-120.06129, 34.46245], [-120.06092, 34.46242], [-120.06052, 34.46235], [-120.05948, 34.46227], [-120.05844, 34.46214], [-120.0576, 34.46209], [-120.05729, 34.46204], [-120.05695, 34.46201], [-120.05581, 34.46195], [-120.05722, 34.46188], [-120.05818, 34.46188], [-120.0587, 34.46192], [-120.05985, 34.46205], [-120.06201, 34.46235], [-120.06369, 34.46263], [-120.06416, 34.46276], [-120.06482, 34.46291], [-120.06553, 34.46319], [-120.06686, 34.46389], [-120.06846, 34.46468], [-120.06883, 34.46481], [-120.06932, 34.4649], [-120.06977, 34.46491], [-120.07014, 34.4649], [-120.07067, 34.46484], [-120.07117, 34.46469], [-120.07173, 34.46441], [-120.07201, 34.46423], [-120.07231, 34.46396], [-120.07283, 34.46341], [-120.07317, 34.46297], [-120.07389, 34.46219], [-120.07428, 34.46174], [-120.0745, 34.46152], [-120.07462, 34.46142], [-120.07478, 34.46133], [-120.07525, 34.46112], [-120.07572, 34.46096], [-120.07596, 34.4609], [-120.07686, 34.46088], [-120.07735, 34.46089], [-120.07916, 34.46104]]]]} | Open Access 1 | 8 | Refugio State Beach | 1978 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=603 | Santa Barbara 7 | 138.86 | Refugio SB | 1950 | State Park 15 | 4 |
16490 | 16490 | 16489 | {"type": "Polygon", "coordinates": [[[-120.09742, 34.45396], [-120.08969, 34.46038], [-120.08888, 34.4602], [-120.08854, 34.46017], [-120.08828, 34.46022], [-120.08796, 34.46019], [-120.0874, 34.46016], [-120.08701, 34.46021], [-120.08617, 34.46023], [-120.08571, 34.4603], [-120.08508, 34.46035], [-120.08467, 34.46041], [-120.08379, 34.4603], [-120.08301, 34.46043], [-120.08269, 34.46038], [-120.082, 34.46041], [-120.0811, 34.46033], [-120.08026, 34.46034], [-120.07899, 34.46046], [-120.0788, 34.46046], [-120.07856, 34.46042], [-120.07636, 34.46036], [-120.07597, 34.46026], [-120.07571, 34.46039], [-120.07549, 34.46042], [-120.07463, 34.46037], [-120.07425, 34.46037], [-120.07413, 34.46044], [-120.07372, 34.46055], [-120.0735, 34.46063], [-120.07334, 34.46076], [-120.07356, 34.46111], [-120.07357, 34.46137], [-120.0734, 34.46162], [-120.07319, 34.46179], [-120.07246, 34.46211], [-120.07143, 34.4624], [-120.06997, 34.46264], [-120.06884, 34.46263], [-120.06843, 34.46258], [-120.06781, 34.46248], [-120.06724, 34.46232], [-120.06684, 34.46222], [-120.06579, 34.46208], [-120.06452, 34.46198], [-120.06396, 34.4619], [-120.06371, 34.46187], [-120.06336, 34.46187], [-120.06113, 34.46158], [-120.06057, 34.46147], [-120.05974, 34.46126], [-120.05923, 34.46121], [-120.05824, 34.46114], [-120.05785, 34.46107], [-120.05771, 34.46099], [-120.05759, 34.46097], [-120.05749, 34.46111], [-120.05738, 34.46121], [-120.05725, 34.46121], [-120.05702, 34.46116], [-120.05693, 34.46116], [-120.05634, 34.46124], [-120.05614, 34.46124], [-120.05593, 34.46123], [-120.05549, 34.46128], [-120.05533, 34.46141], [-120.05521, 34.46155], [-120.05498, 34.46166], [-120.05462, 34.46175], [-120.05386, 34.46175], [-120.05326, 34.46183], [-120.05298, 34.46183], [-120.05282, 34.46181], [-120.05258, 34.46171], [-120.05239, 34.46168], [-120.05178, 34.46167], [-120.05103, 34.46162], [-120.05074, 34.46158], [-120.0504, 34.46157], [-120.05, 34.4615], [-120.04979, 34.46152], [-120.04945, 34.46164], [-120.04933, 34.4618], [-120.04905, 34.46185], [-120.04881, 34.46183], [-120.04815, 34.46189], [-120.04745, 34.46191], [-120.04731, 34.46191], [-120.04709, 34.46186], [-120.04704, 34.46193], [-120.04705, 34.46208], [-120.04688, 34.46222], [-120.04681, 34.46224], [-120.04681, 34.45491], [-120.09742, 34.45396]]]} | Open Access 1 | 25817 | Refugio State Beach | 1978 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=603 | Santa Barbara 7 | 790.974 | Refugio SB | 1950 | State Park 15 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);