units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
106 rows where DES_TP = 14 and MNG_AGENCY = 110 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 86
MNG_AGENCY 1
- Ventura, City of · 86 ✖
DES_TP 1
- Local Other or Unknown · 86 ✖
ACCESS_TYP 1
- Open Access 86
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13251 | 13251 | 13250 | {"type": "Polygon", "coordinates": [[[-119.19394, 34.28125], [-119.19393, 34.28125], [-119.1939, 34.28121], [-119.19385, 34.2812], [-119.19316, 34.28133], [-119.19299, 34.28152], [-119.19315, 34.28186], [-119.19341, 34.28221], [-119.1934, 34.28222], [-119.19324, 34.28201], [-119.19311, 34.28181], [-119.19297, 34.28152], [-119.19293, 34.28142], [-119.19294, 34.28138], [-119.193, 34.28134], [-119.19385, 34.28119], [-119.19391, 34.2812], [-119.19394, 34.28125]]]} | Open Access 1 | 35296 | Ventura holding 99 | 26983 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.127 | Ventura holding 99 | 0 | Local Other or Unknown 14 | 4 | |
13252 | 13252 | 13251 | {"type": "Polygon", "coordinates": [[[-119.15969, 34.27006], [-119.15962, 34.2701], [-119.15848, 34.27077], [-119.15851, 34.27073], [-119.15963, 34.27008], [-119.15969, 34.27006]]]} | Open Access 1 | 35297 | Ventura holding 104 | 26857 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.051 | Ventura holding 104 | 0 | Local Other or Unknown 14 | 4 | |
13253 | 13253 | 13252 | {"type": "Polygon", "coordinates": [[[-119.18424, 34.28252], [-119.18342, 34.28264], [-119.18296, 34.28272], [-119.18242, 34.28286], [-119.18238, 34.2829], [-119.18239, 34.28295], [-119.18238, 34.28296], [-119.18236, 34.28293], [-119.18237, 34.28288], [-119.18241, 34.28285], [-119.18296, 34.28271], [-119.18351, 34.28261], [-119.18423, 34.28251], [-119.18424, 34.28252]]]} | Open Access 1 | 35298 | Ventura holding 98 | 26982 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.069 | Ventura holding 98 | 0 | Local Other or Unknown 14 | 4 | |
13254 | 13254 | 13253 | {"type": "Polygon", "coordinates": [[[-119.16704, 34.29601], [-119.16663, 34.29625], [-119.16528, 34.29542], [-119.16408, 34.29455], [-119.1635, 34.29388], [-119.16364, 34.2938], [-119.16372, 34.29381], [-119.16398, 34.29415], [-119.16414, 34.2943], [-119.1646, 34.29464], [-119.16496, 34.2948], [-119.1651, 34.29489], [-119.16566, 34.29542], [-119.16603, 34.29569], [-119.1662, 34.29578], [-119.16643, 34.29587], [-119.16704, 34.29601]]]} | Open Access 1 | 35299 | Ventura holding 97 | 26981 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.39 | Ventura holding 97 | 0 | Local Other or Unknown 14 | 4 | |
13255 | 13255 | 13254 | {"type": "Polygon", "coordinates": [[[-119.19505, 34.28555], [-119.19504, 34.28555], [-119.19479, 34.28417], [-119.1948, 34.28417], [-119.19481, 34.28421], [-119.19505, 34.28555]]]} | Open Access 1 | 35300 | Ventura holding 86 | 26969 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.062 | Ventura holding 86 | 0 | Local Other or Unknown 14 | 4 | |
13257 | 13257 | 13256 | {"type": "Polygon", "coordinates": [[[-119.17269, 34.27683], [-119.17247, 34.27657], [-119.17247, 34.27657], [-119.17253, 34.27654], [-119.17258, 34.27654], [-119.17272, 34.27669], [-119.17273, 34.27675], [-119.17269, 34.27683]]]} | Open Access 1 | 35302 | Ventura holding 100 | 26853 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.085 | Ventura holding 100 | 0 | Local Other or Unknown 14 | 4 | |
13258 | 13258 | 13257 | {"type": "Polygon", "coordinates": [[[-119.19685, 34.26747], [-119.19664, 34.2675], [-119.19663, 34.26748], [-119.19654, 34.26749], [-119.19661, 34.26668], [-119.19607, 34.26675], [-119.19601, 34.26634], [-119.19605, 34.26592], [-119.19558, 34.26511], [-119.19552, 34.26478], [-119.19587, 34.26407], [-119.19567, 34.26357], [-119.1958, 34.26338], [-119.19636, 34.2633], [-119.19663, 34.26436], [-119.19624, 34.26442], [-119.19616, 34.26451], [-119.19619, 34.26523], [-119.19632, 34.26548], [-119.19638, 34.26554], [-119.19645, 34.26556], [-119.19679, 34.26555], [-119.19685, 34.26747]]]} | Open Access 1 | 35303 | Ventura holding 102 | 26855 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 6.511 | Ventura holding 102 | 0 | Local Other or Unknown 14 | 4 | |
13245 | 13245 | 13244 | {"type": "Polygon", "coordinates": [[[-119.16516, 34.26881], [-119.16499, 34.26864], [-119.16492, 34.26863], [-119.16465, 34.26879], [-119.16388, 34.26916], [-119.16322, 34.26952], [-119.16279, 34.26941], [-119.16126, 34.26959], [-119.16098, 34.26984], [-119.16101, 34.27013], [-119.16059, 34.26969], [-119.16097, 34.2696], [-119.16121, 34.26957], [-119.16253, 34.26941], [-119.16297, 34.26935], [-119.1634, 34.26925], [-119.16382, 34.26912], [-119.16422, 34.26896], [-119.16461, 34.26877], [-119.16494, 34.26859], [-119.16498, 34.2686], [-119.16515, 34.26878], [-119.16516, 34.26881]]]} | Open Access 1 | 35304 | Ventura holding 101 | 26854 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.929 | Ventura holding 101 | 0 | Local Other or Unknown 14 | 4 | |
13259 | 13259 | 13258 | {"type": "Polygon", "coordinates": [[[-119.16467, 34.2683], [-119.16449, 34.26812], [-119.16453, 34.26813], [-119.16471, 34.26833], [-119.16473, 34.26835], [-119.16471, 34.26838], [-119.16443, 34.26854], [-119.16407, 34.26872], [-119.16369, 34.26887], [-119.1633, 34.26899], [-119.16289, 34.26908], [-119.16193, 34.2692], [-119.16188, 34.26918], [-119.16289, 34.26905], [-119.16329, 34.26896], [-119.16368, 34.26884], [-119.16405, 34.26869], [-119.16441, 34.26852], [-119.16466, 34.26838], [-119.16468, 34.26834], [-119.16467, 34.2683]]]} | Open Access 1 | 35305 | Ventura holding 103 | 26856 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.226 | Ventura holding 103 | 0 | Local Other or Unknown 14 | 4 | |
13261 | 13261 | 13260 | {"type": "Polygon", "coordinates": [[[-119.30091, 34.29935], [-119.30079, 34.29963], [-119.30051, 34.3005], [-119.30039, 34.30047], [-119.30067, 34.2996], [-119.30078, 34.29932], [-119.30091, 34.29935]]]} | Open Access 1 | 35308 | Ventura holding 105 | 26858 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.401 | Ventura holding 105 | 0 | Local Other or Unknown 14 | 4 | |
13266 | 13266 | 13265 | {"type": "Polygon", "coordinates": [[[-119.19587, 34.25428], [-119.19576, 34.25444], [-119.19578, 34.25477], [-119.19583, 34.25483], [-119.19571, 34.2549], [-119.19569, 34.25465], [-119.19563, 34.25446], [-119.19536, 34.25451], [-119.19516, 34.25477], [-119.19514, 34.255], [-119.1953, 34.25522], [-119.19516, 34.2553], [-119.19483, 34.25547], [-119.19438, 34.25563], [-119.19339, 34.25581], [-119.19333, 34.25579], [-119.19338, 34.2558], [-119.19433, 34.25562], [-119.19473, 34.2555], [-119.19504, 34.25535], [-119.19507, 34.25512], [-119.19485, 34.25498], [-119.19499, 34.25477], [-119.19505, 34.25458], [-119.19506, 34.25443], [-119.19504, 34.25414], [-119.19501, 34.25394], [-119.19474, 34.25308], [-119.19462, 34.25286], [-119.19461, 34.2528], [-119.19458, 34.25274], [-119.1945, 34.25267], [-119.19441, 34.25263], [-119.19428, 34.25229], [-119.19489, 34.25211], [-119.19513, 34.25249], [-119.19534, 34.2525], [-119.1956, 34.2532], [-119.1958, 34.25407], [-119.19581, 34.25417], [-119.19587, 34.25428]]]} | Open Access 1 | 35316 | Ventura holding 110 | 26864 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.262 | Ventura holding 110 | 0 | Local Other or Unknown 14 | 4 | |
12427 | 12427 | 12426 | {"type": "Polygon", "coordinates": [[[-119.1914, 34.28159], [-119.19124, 34.2816], [-119.1908, 34.28162], [-119.1912, 34.28156], [-119.1914, 34.28159]]]} | Open Access 1 | 35321 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.034 | Ventura holding 107 | 0 | Local Other or Unknown 14 | 4 | |
12527 | 12527 | 12526 | {"type": "Polygon", "coordinates": [[[-119.17388, 34.27875], [-119.17251, 34.27957], [-119.17248, 34.27953], [-119.17383, 34.27873], [-119.17385, 34.27872], [-119.17388, 34.27875]]]} | Open Access 1 | 35322 | Ventura holding 108 | 26861 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.177 | Ventura holding 108 | 0 | Local Other or Unknown 14 | 4 | |
12939 | 12939 | 12938 | {"type": "Polygon", "coordinates": [[[-119.16787, 34.29732], [-119.16767, 34.29729], [-119.16753, 34.29719], [-119.1674, 34.29702], [-119.16719, 34.29692], [-119.16695, 34.29688], [-119.1671, 34.29655], [-119.16778, 34.29692], [-119.16762, 34.29702], [-119.16787, 34.29732]]]} | Open Access 1 | 35323 | Ventura holding 109 | 26862 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.639 | Ventura holding 109 | 0 | Local Other or Unknown 14 | 4 | |
13273 | 13273 | 13272 | {"type": "Polygon", "coordinates": [[[-119.30112, 34.29895], [-119.30091, 34.29935], [-119.30078, 34.29932], [-119.30099, 34.29893], [-119.30112, 34.29895]]]} | Open Access 1 | 35326 | Ventura holding 120 | 26875 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.144 | Ventura holding 120 | 0 | Local Other or Unknown 14 | 4 | |
13275 | 13275 | 13274 | {"type": "Polygon", "coordinates": [[[-119.27281, 34.27006], [-119.27267, 34.27013], [-119.2716, 34.26928], [-119.27164, 34.26926], [-119.27171, 34.26931], [-119.27181, 34.2693], [-119.27188, 34.26925], [-119.27188, 34.26917], [-119.27146, 34.26865], [-119.27095, 34.26784], [-119.27023, 34.26685], [-119.27, 34.26661], [-119.27004, 34.26658], [-119.27022, 34.26677], [-119.27021, 34.26678], [-119.27048, 34.26706], [-119.27075, 34.26743], [-119.27139, 34.26844], [-119.2721, 34.26937], [-119.27281, 34.27006]]]} | Open Access 1 | 35329 | Ventura holding 119 | 26873 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.178 | Ventura holding 119 | 0 | Local Other or Unknown 14 | 4 | |
3831 | 3831 | 3830 | {"type": "Polygon", "coordinates": [[[-119.21633, 34.28845], [-119.216, 34.28946], [-119.21597, 34.28964], [-119.21595, 34.2896], [-119.21596, 34.28948], [-119.21603, 34.28913], [-119.2163, 34.28845], [-119.21633, 34.28845]]]} | Open Access 1 | 35331 | Ventura holding 123 | 26878 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.146 | Ventura holding 123 | 0 | Local Other or Unknown 14 | 4 | |
13278 | 13278 | 13277 | {"type": "Polygon", "coordinates": [[[-119.24492, 34.26488], [-119.24423, 34.26494], [-119.24206, 34.26537], [-119.24072, 34.26568], [-119.2407, 34.26556], [-119.24211, 34.26531], [-119.24433, 34.26488], [-119.24482, 34.26485], [-119.24492, 34.26488]]]} | Open Access 1 | 35332 | Ventura holding 114 | 26868 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.618 | Ventura holding 114 | 0 | Local Other or Unknown 14 | 4 | |
13279 | 13279 | 13278 | {"type": "Polygon", "coordinates": [[[-119.16488, 34.29512], [-119.16458, 34.2953], [-119.16445, 34.29515], [-119.1643, 34.29509], [-119.16413, 34.29494], [-119.16392, 34.2948], [-119.16386, 34.29466], [-119.16407, 34.29454], [-119.16488, 34.29512]]]} | Open Access 1 | 35333 | Ventura holding 122 | 26877 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.731 | Ventura holding 122 | 0 | Local Other or Unknown 14 | 4 | |
13282 | 13282 | 13281 | {"type": "Polygon", "coordinates": [[[-119.15094, 34.27517], [-119.15067, 34.27547], [-119.15043, 34.27579], [-119.1503, 34.27601], [-119.15018, 34.27624], [-119.15015, 34.27633], [-119.15016, 34.27636], [-119.15019, 34.27638], [-119.15019, 34.27639], [-119.15016, 34.27638], [-119.15013, 34.27635], [-119.15013, 34.2763], [-119.15025, 34.27606], [-119.15042, 34.27578], [-119.1507, 34.27541], [-119.15093, 34.27517], [-119.15094, 34.27517]]]} | Open Access 1 | 35337 | Ventura holding 118 | 26872 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.058 | Ventura holding 118 | 0 | Local Other or Unknown 14 | 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]);