superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where MNG_AGENCY = 110
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10683 | 10683 | 10682 | {"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 | Ventura holding 105 | 26858 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.401 | Ventura holding 105 | ||
10684 | 10684 | 10683 | {"type": "Polygon", "coordinates": [[[-119.17467, 34.27812], [-119.17461, 34.27816], [-119.17442, 34.27794], [-119.17446, 34.27792], [-119.1745, 34.27793], [-119.17467, 34.27812]]]} | Open Access 1 | Ventura holding 106 | 26859 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.046 | Ventura holding 106 | ||
10685 | 10685 | 10684 | {"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 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.034 | Ventura holding 107 | ||
10686 | 10686 | 10685 | {"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 | Ventura holding 108 | 26861 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.177 | Ventura holding 108 | ||
10687 | 10687 | 10686 | {"type": "Polygon", "coordinates": [[[-119.16787, 34.29732], [-119.16767, 34.29729], [-119.16753, 34.29719], [-119.1674, 34.29701], [-119.16719, 34.29692], [-119.16695, 34.29688], [-119.1671, 34.29655], [-119.16778, 34.29692], [-119.16762, 34.29703], [-119.16787, 34.29732]]]} | Open Access 1 | Ventura holding 109 | 26862 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.641 | Ventura holding 109 | ||
10688 | 10688 | 10687 | {"type": "Polygon", "coordinates": [[[-119.16591, 34.26726], [-119.16557, 34.26764], [-119.16558, 34.26762], [-119.16556, 34.26758], [-119.16534, 34.26744], [-119.16518, 34.26744], [-119.16512, 34.26735], [-119.16408, 34.26651], [-119.16396, 34.26647], [-119.16386, 34.26649], [-119.16379, 34.26653], [-119.16292, 34.26753], [-119.16258, 34.26789], [-119.16196, 34.26849], [-119.16186, 34.26861], [-119.16178, 34.26875], [-119.16172, 34.2689], [-119.16171, 34.26905], [-119.16172, 34.26922], [-119.16105, 34.2693], [-119.16099, 34.26909], [-119.16157, 34.2687], [-119.16205, 34.26825], [-119.16282, 34.26747], [-119.16372, 34.26644], [-119.16382, 34.26638], [-119.16402, 34.26635], [-119.16415, 34.26642], [-119.16442, 34.26626], [-119.16503, 34.26697], [-119.16591, 34.26726]]]} | Open Access 1 | Ventura holding 11 | 26863 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 3.413 | Ventura holding 11 | ||
10690 | 10690 | 10689 | {"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.19562, 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.195, 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 | Ventura holding 110 | 26864 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 5.269 | Ventura holding 110 | ||
10691 | 10691 | 10690 | {"type": "Polygon", "coordinates": [[[-119.15329, 34.27338], [-119.15139, 34.2745], [-119.15103, 34.27476], [-119.1507, 34.27506], [-119.15037, 34.27543], [-119.15006, 34.2759], [-119.14991, 34.2762], [-119.14981, 34.27645], [-119.14964, 34.2771], [-119.14959, 34.27705], [-119.14975, 34.27644], [-119.14985, 34.27618], [-119.14997, 34.27594], [-119.15011, 34.27569], [-119.15027, 34.27546], [-119.15045, 34.27524], [-119.15065, 34.27502], [-119.15104, 34.27468], [-119.15141, 34.27442], [-119.15312, 34.27342], [-119.15329, 34.27337], [-119.15329, 34.27338]]]} | Open Access 1 | Ventura holding 111 | 26865 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.783 | Ventura holding 111 | ||
10692 | 10692 | 10691 | {"type": "Polygon", "coordinates": [[[-119.2018, 34.27289], [-119.19837, 34.27339], [-119.19833, 34.27322], [-119.20177, 34.27274], [-119.2018, 34.27289]]]} | Open Access 1 | Ventura holding 112 | 26866 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.465 | Ventura holding 112 | ||
10693 | 10693 | 10692 | {"type": "Polygon", "coordinates": [[[-119.19638, 34.26334], [-119.19635, 34.2633], [-119.19581, 34.26338], [-119.19567, 34.26357], [-119.19587, 34.26407], [-119.19552, 34.26478], [-119.19558, 34.26511], [-119.19605, 34.26592], [-119.19601, 34.26635], [-119.19611, 34.26703], [-119.19602, 34.26759], [-119.19572, 34.26763], [-119.19571, 34.26722], [-119.19577, 34.26701], [-119.1957, 34.26681], [-119.1957, 34.26642], [-119.19562, 34.2661], [-119.19564, 34.26586], [-119.19541, 34.26529], [-119.19526, 34.26501], [-119.1952, 34.26484], [-119.19519, 34.26472], [-119.19523, 34.26462], [-119.19538, 34.26449], [-119.19546, 34.26438], [-119.19555, 34.26418], [-119.19555, 34.26398], [-119.19542, 34.26347], [-119.19542, 34.2634], [-119.19548, 34.26332], [-119.19569, 34.26325], [-119.19572, 34.26321], [-119.19565, 34.26293], [-119.19555, 34.2628], [-119.19549, 34.26268], [-119.19539, 34.26229], [-119.1954, 34.26221], [-119.19547, 34.26213], [-119.19549, 34.26208], [-119.19548, 34.26194], [-119.1954, 34.26185], [-119.1953, 34.26168], [-119.19606, 34.26157], [-119.19607, 34.26171], [-119.19619, 34.26183], [-119.19623, 34.26195], [-119.19622, 34.26205], [-119.19611, 34.26221], [-119.19614, 34.26234], [-119.19612, 34.26258], [-119.19618, 34.2627], [-119.19639, 34.26289], [-119.19645, 34.26304], [-119.19645, 34.26319], [-119.19642, 34.26327], [-119.19638, 34.26334]]]} | Open Access 1 | Ventura holding 113 | 26867 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 6.671 | Ventura holding 113 | ||
10694 | 10694 | 10693 | {"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 | Ventura holding 114 | 26868 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.617 | Ventura holding 114 | ||
10695 | 10695 | 10694 | {"type": "Polygon", "coordinates": [[[-119.17705, 34.27796], [-119.17699, 34.27793], [-119.17693, 34.27794], [-119.17623, 34.27829], [-119.17578, 34.27854], [-119.17577, 34.27853], [-119.17622, 34.27828], [-119.17693, 34.27792], [-119.177, 34.27792], [-119.17705, 34.27796]]]} | Open Access 1 | Ventura holding 115 | 26869 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.051 | Ventura holding 115 | ||
10696 | 10696 | 10695 | {"type": "Polygon", "coordinates": [[[-119.16894, 34.26278], [-119.16757, 34.26339], [-119.16711, 34.26351], [-119.16688, 34.26359], [-119.16669, 34.26368], [-119.16635, 34.26389], [-119.16625, 34.26365], [-119.16678, 34.26348], [-119.16717, 34.26347], [-119.16737, 34.26339], [-119.16798, 34.26302], [-119.16863, 34.26273], [-119.16894, 34.26278]]]} | Open Access 1 | Ventura holding 116 | 26870 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.922 | Ventura holding 116 | ||
10697 | 10697 | 10696 | {"type": "Polygon", "coordinates": [[[-119.19307, 34.24786], [-119.19284, 34.24793], [-119.19266, 34.24767], [-119.19234, 34.24732], [-119.19219, 34.24712], [-119.19206, 34.24692], [-119.19198, 34.24674], [-119.19192, 34.24656], [-119.19181, 34.2461], [-119.19173, 34.24592], [-119.19162, 34.2457], [-119.1916, 34.2456], [-119.19162, 34.24552], [-119.19196, 34.24486], [-119.19237, 34.24468], [-119.19244, 34.24501], [-119.19254, 34.24529], [-119.19209, 34.24544], [-119.19199, 34.24567], [-119.19213, 34.24641], [-119.19222, 34.24671], [-119.19238, 34.247], [-119.19253, 34.2472], [-119.19286, 34.24755], [-119.19307, 34.24786]]]} | Open Access 1 | Ventura holding 117 | 26871 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 2.841 | Ventura holding 117 | ||
10698 | 10698 | 10697 | {"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 | Ventura holding 118 | 26872 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.058 | Ventura holding 118 | ||
10699 | 10699 | 10698 | {"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.27022, 34.26679], [-119.27048, 34.26706], [-119.27075, 34.26743], [-119.27139, 34.26844], [-119.2721, 34.26937], [-119.27281, 34.27006]]]} | Open Access 1 | Ventura holding 119 | 26873 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.179 | Ventura holding 119 | ||
10700 | 10700 | 10699 | {"type": "Polygon", "coordinates": [[[-119.29875, 34.30564], [-119.29856, 34.30616], [-119.29808, 34.30606], [-119.29829, 34.30606], [-119.29848, 34.30599], [-119.29856, 34.30592], [-119.29862, 34.30585], [-119.29869, 34.30563], [-119.29875, 34.30564]]]} | Open Access 1 | Ventura holding 12 | 26874 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.176 | Ventura holding 12 | ||
10701 | 10701 | 10700 | {"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 | Ventura holding 120 | 26875 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.144 | Ventura holding 120 | ||
10702 | 10702 | 10701 | {"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 | Ventura holding 122 | 26877 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.731 | Ventura holding 122 | ||
10703 | 10703 | 10702 | {"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 | Ventura holding 123 | 26878 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.146 | Ventura holding 123 |
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]);