units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1 and MNG_AGENCY = 583
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3193 | 3193 | 3192 | {"type": "Polygon", "coordinates": [[[-119.19405, 34.15613], [-119.1939, 34.15658], [-119.19391, 34.15663], [-119.19397, 34.15665], [-119.19363, 34.15675], [-119.19377, 34.15636], [-119.19376, 34.15635], [-119.19303, 34.15658], [-119.19302, 34.15659], [-119.19316, 34.1569], [-119.19011, 34.15787], [-119.18975, 34.15804], [-119.18954, 34.15817], [-119.18941, 34.15828], [-119.18922, 34.15847], [-119.18905, 34.15871], [-119.18892, 34.15897], [-119.18886, 34.15919], [-119.18882, 34.15944], [-119.18881, 34.16092], [-119.18879, 34.16094], [-119.18613, 34.16092], [-119.1861, 34.16091], [-119.18611, 34.1596], [-119.18644, 34.1596], [-119.18645, 34.15955], [-119.18757, 34.15956], [-119.18782, 34.15915], [-119.18791, 34.15919], [-119.18797, 34.1591], [-119.18796, 34.15909], [-119.18788, 34.15905], [-119.18818, 34.15858], [-119.18926, 34.15752], [-119.19383, 34.15607], [-119.19405, 34.15613]]]} | Open Access 1 | 22118 | Richard Barb Bubbling Springs | 24321 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | Ventura 8 | 20.37 | Richard Barb Bubbling Springs | None 263 | |||
10550 | 10550 | 10549 | {"type": "Polygon", "coordinates": [[[-119.2115, 34.14498], [-119.21144, 34.1451], [-119.21107, 34.14541], [-119.21085, 34.14564], [-119.21076, 34.14577], [-119.21036, 34.14629], [-119.21009, 34.14666], [-119.20999, 34.14675], [-119.20965, 34.14675], [-119.21029, 34.14606], [-119.21007, 34.1459], [-119.21066, 34.1451], [-119.21066, 34.14509], [-119.21019, 34.14498], [-119.20968, 34.14508], [-119.20968, 34.1448], [-119.20939, 34.1449], [-119.20923, 34.14492], [-119.20903, 34.14498], [-119.20848, 34.14505], [-119.20719, 34.14501], [-119.20696, 34.14498], [-119.20618, 34.14493], [-119.20559, 34.14486], [-119.2047, 34.1448], [-119.20412, 34.14471], [-119.20317, 34.14468], [-119.20299, 34.14466], [-119.20291, 34.14496], [-119.20276, 34.14496], [-119.20078, 34.14437], [-119.20039, 34.14443], [-119.20004, 34.1448], [-119.19995, 34.14479], [-119.19953, 34.14467], [-119.19632, 34.14354], [-119.19595, 34.14346], [-119.19551, 34.14345], [-119.19531, 34.14358], [-119.19519, 34.14351], [-119.19504, 34.14345], [-119.19325, 34.14297], [-119.19281, 34.14283], [-119.19253, 34.14272], [-119.19215, 34.14254], [-119.19213, 34.14249], [-119.19217, 34.14241], [-119.19218, 34.14235], [-119.19216, 34.14223], [-119.19207, 34.14206], [-119.19191, 34.14191], [-119.19073, 34.14132], [-119.1907, 34.14133], [-119.19054, 34.14123], [-119.1904, 34.14143], [-119.19008, 34.14182], [-119.18738, 34.14024], [-119.18701, 34.14013], [-119.18703, 34.14009], [-119.18691, 34.14002], [-119.1872, 34.13969], [-119.18842, 34.14039], [-119.18921, 34.13945], [-119.18921, 34.13944], [-119.18897, 34.13931], [-119.19003, 34.1384], [-119.19478, 34.1407], [-119.19691, 34.14178], [-119.19859, 34.14257], [-119.19944, 34.14301], [-119.20034, 34.14353], [-119.2015, 34.14387], [-119.20213, 34.14416], [-119.2024, 34.14424], [-119.20259, 34.14426], [-119.2027, 34.14425], [-119.20296, 34.14417], [-119.20317, 34.14415], [-119.20328, 34.14417], [-119.20346, 34.14424], [-119.20376, 34.14433], [-119.20615, 34.14465], [-119.2073, 34.14478], [-119.20802, 34.14482], [-119.20852, 34.14484], [-119.2088, 34.14481], [-119.20899, 34.14477], [-119.2094, 34.14459], [-119.20952, 34.14456], [-119.2098, 34.14458], [-119.20989, 34.14456], [-119.20992, 34.1445], [-119.21, 34.14444], [-119.21012, 34.1444], [-119.21039, 34.14439], [-119.21049, 34.14443], [-119.21061, 34.14452], [-119.2107, 34.14464], [-119.21095, 34.14479], [-119.21125, 34.14486], [-119.21144, 34.14489], [-119.2115, 34.14498]]]} | Open Access 1 | 18769 | Port Hueneme Beach Park | 23895 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | Ventura 8 | 84.698 | Port Hueneme Beach Park | 0 | Local Park 2 | 4 | |
10685 | 10685 | 10684 | {"type": "Polygon", "coordinates": [[[-119.19989, 34.14896], [-119.19989, 34.14896], [-119.19806, 34.14897], [-119.19932, 34.1479], [-119.19941, 34.14788], [-119.19989, 34.14788], [-119.19989, 34.14896]]]} | Open Access 1 | 19042 | Dewar Park | 18129 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | Ventura 8 | 3.254 | Dewar Park | 0 | Local Park 2 | 4 | |
10686 | 10686 | 10685 | {"type": "Polygon", "coordinates": [[[-119.20755, 34.17884], [-119.20754, 34.17904], [-119.20727, 34.17903], [-119.20726, 34.17901], [-119.20656, 34.17901], [-119.20655, 34.17934], [-119.20584, 34.17933], [-119.20584, 34.179], [-119.20515, 34.179], [-119.20513, 34.17902], [-119.20486, 34.17902], [-119.20486, 34.17882], [-119.20545, 34.17882], [-119.20545, 34.17859], [-119.2055, 34.17859], [-119.2055, 34.17882], [-119.20585, 34.17882], [-119.20586, 34.1777], [-119.20655, 34.1777], [-119.20655, 34.17883], [-119.20687, 34.17883], [-119.20688, 34.1786], [-119.20692, 34.1786], [-119.20693, 34.17883], [-119.20755, 34.17884]]]} | Open Access 1 | 19043 | Bolker Park | 16242 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | Ventura 8 | 3.884 | Bolker Park | 0 | Local Park 2 | 4 | |
14611 | 14611 | 14610 | {"type": "MultiPolygon", "coordinates": [[[[-119.19434, 34.14702], [-119.19433, 34.14707], [-119.19391, 34.14688], [-119.19333, 34.1465], [-119.19303, 34.14638], [-119.19298, 34.14639], [-119.19295, 34.14641], [-119.19288, 34.14663], [-119.19269, 34.14661], [-119.19238, 34.14661], [-119.19236, 34.14658], [-119.19233, 34.14657], [-119.1923, 34.14658], [-119.1923, 34.14662], [-119.192, 34.14662], [-119.19195, 34.1466], [-119.19192, 34.14657], [-119.19185, 34.14631], [-119.19075, 34.14631], [-119.19062, 34.14621], [-119.19072, 34.14603], [-119.19077, 34.14582], [-119.19086, 34.14561], [-119.19091, 34.14537], [-119.19105, 34.14499], [-119.19356, 34.14501], [-119.19357, 34.1463], [-119.19362, 34.14637], [-119.19359, 34.14643], [-119.19359, 34.14649], [-119.19364, 34.14655], [-119.19372, 34.14658], [-119.19386, 34.14673], [-119.194, 34.14684], [-119.19434, 34.14702]]], [[[-119.1912, 34.14742], [-119.19114, 34.14742], [-119.1911, 34.14727], [-119.19113, 34.14727], [-119.19116, 34.14742], [-119.1912, 34.14742]]], [[[-119.19532, 34.14759], [-119.19529, 34.14762], [-119.19438, 34.14762], [-119.19436, 34.1476], [-119.19459, 34.14755], [-119.19487, 34.14743], [-119.19489, 34.14739], [-119.19488, 34.14736], [-119.19466, 34.14714], [-119.19478, 34.14704], [-119.19501, 34.1472], [-119.19508, 34.1472], [-119.19519, 34.14706], [-119.19525, 34.14694], [-119.19529, 34.1468], [-119.19532, 34.14679], [-119.19532, 34.14759]]]]} | Open Access 1 | 48305 | Moranda Park | 32874 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | https://www.ci.port-hueneme.ca.us/553/City-Parks | Ventura 8 | 11.157 | Moranda Park | 0 | Local Park 2 | 4 |
16832 | 16832 | 16831 | {"type": "MultiPolygon", "coordinates": [[[[-119.19078, 34.14223], [-119.19054, 34.14233], [-119.19052, 34.14221], [-119.19013, 34.14195], [-119.18818, 34.1408], [-119.18823, 34.14074], [-119.19078, 34.14223]]], [[[-119.19114, 34.14742], [-119.19055, 34.1474], [-119.19052, 34.14738], [-119.19042, 34.14709], [-119.19037, 34.14681], [-119.19039, 34.14498], [-119.19105, 34.14499], [-119.19091, 34.14537], [-119.19086, 34.14561], [-119.19077, 34.14582], [-119.19072, 34.14603], [-119.19062, 34.14621], [-119.19075, 34.14631], [-119.19072, 34.14676], [-119.19079, 34.1471], [-119.19086, 34.14726], [-119.1911, 34.14727], [-119.19114, 34.14742]]], [[[-119.19156, 34.14326], [-119.1915, 34.14399], [-119.19141, 34.14442], [-119.19124, 34.14492], [-119.19083, 34.14492], [-119.19088, 34.1449], [-119.19105, 34.14436], [-119.19114, 34.14397], [-119.1912, 34.14325], [-119.1912, 34.14286], [-119.1911, 34.14272], [-119.19063, 34.14282], [-119.19047, 34.14276], [-119.19055, 34.14265], [-119.19065, 34.14255], [-119.19081, 34.14247], [-119.19095, 34.14243], [-119.19111, 34.14241], [-119.19126, 34.14243], [-119.19153, 34.14253], [-119.19153, 34.14324], [-119.19156, 34.14326]]], [[[-119.193, 34.15068], [-119.19266, 34.15067], [-119.19241, 34.14991], [-119.1917, 34.14914], [-119.19093, 34.14813], [-119.19068, 34.14772], [-119.19072, 34.14768], [-119.19085, 34.14769], [-119.19099, 34.14796], [-119.19158, 34.14883], [-119.19169, 34.1489], [-119.19182, 34.14912], [-119.19189, 34.14912], [-119.19222, 34.14952], [-119.19238, 34.14967], [-119.19264, 34.15048], [-119.19292, 34.15042], [-119.193, 34.15068]]], [[[-119.19455, 34.15469], [-119.19447, 34.15469], [-119.19448, 34.15466], [-119.19417, 34.1539], [-119.19391, 34.15397], [-119.19298, 34.15167], [-119.1932, 34.15167], [-119.19363, 34.15272], [-119.19366, 34.15272], [-119.19382, 34.15311], [-119.19382, 34.15324], [-119.19397, 34.15325], [-119.19455, 34.15469]]], [[[-119.19426, 34.15496], [-119.19386, 34.15608], [-119.19383, 34.15607], [-119.19422, 34.15496], [-119.19426, 34.15496]]]]} | Open Access 1 | 48306 | Bubbling Springs Recreation Corridor | 32875 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | Ventura 8 | 8.856 | Bubbling Springs Rec. Corridor | 0 | Local Recreation Area 3 | 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]);