superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 1 and MNG_AGENCY = 110 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10714 | 10714 | 10713 | {"type": "Polygon", "coordinates": [[[-119.24072, 34.26566], [-119.24031, 34.26572], [-119.2403, 34.26567], [-119.24039, 34.26566], [-119.2407, 34.26556], [-119.24072, 34.26566]]]} | Open Access 1 | Ventura holding 2 | 26896 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.075 | Ventura holding 2 | ||
10761 | 10761 | 10760 | {"type": "Polygon", "coordinates": [[[-119.17578, 34.27854], [-119.17406, 34.27956], [-119.17405, 34.27955], [-119.17567, 34.27859], [-119.17577, 34.27853], [-119.17578, 34.27854]]]} | Open Access 1 | Ventura holding 8 | 26962 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.075 | Ventura holding 8 | ||
10760 | 10760 | 10759 | {"type": "Polygon", "coordinates": [[[-119.19348, 34.28277], [-119.19345, 34.28278], [-119.19343, 34.28277], [-119.19323, 34.28259], [-119.19306, 34.28242], [-119.1929, 34.28221], [-119.19282, 34.28219], [-119.19258, 34.28229], [-119.19281, 34.28217], [-119.19293, 34.2822], [-119.19319, 34.2825], [-119.19348, 34.28277]]]} | Open Access 1 | Ventura holding 79 | 26961 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.081 | Ventura holding 79 | ||
10678 | 10678 | 10677 | {"type": "Polygon", "coordinates": [[[-119.17273, 34.27675], [-119.17269, 34.27683], [-119.17247, 34.27657], [-119.17253, 34.27654], [-119.17258, 34.27654], [-119.17272, 34.27669], [-119.17273, 34.27675]]]} | Open Access 1 | Ventura holding 100 | 26853 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.084 | Ventura holding 100 | ||
10740 | 10740 | 10739 | {"type": "Polygon", "coordinates": [[[-119.18883, 34.28189], [-119.18679, 34.28217], [-119.18678, 34.28216], [-119.18882, 34.28187], [-119.18883, 34.28189]]]} | Open Access 1 | Ventura holding 6 | 26940 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.087 | Ventura holding 6 | ||
10762 | 10762 | 10761 | {"type": "Polygon", "coordinates": [[[-119.19127, 34.28332], [-119.19124, 34.28332], [-119.19122, 34.28329], [-119.19114, 34.28308], [-119.19106, 34.28291], [-119.19085, 34.28263], [-119.19087, 34.28254], [-119.19111, 34.28247], [-119.19115, 34.28247], [-119.1909, 34.28255], [-119.19088, 34.28261], [-119.19112, 34.28294], [-119.19121, 34.28313], [-119.19127, 34.28332]]]} | Open Access 1 | Ventura holding 80 | 26963 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.087 | Ventura holding 80 | ||
9206 | 9206 | 9205 | {"type": "Polygon", "coordinates": [[[-119.16693, 34.29644], [-119.16693, 34.29644], [-119.16679, 34.29676], [-119.16665, 34.2966], [-119.16687, 34.2964], [-119.16693, 34.29644]]]} | Open Access 1 | Ventura holding 10 | 26852 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.109 | Ventura holding 10 | ||
10728 | 10728 | 10727 | {"type": "Polygon", "coordinates": [[[-119.28856, 34.30082], [-119.28842, 34.30113], [-119.28837, 34.30129], [-119.2884, 34.30131], [-119.28838, 34.30138], [-119.28828, 34.30136], [-119.28833, 34.30115], [-119.28843, 34.30092], [-119.28849, 34.30081], [-119.28856, 34.30082]]]} | Open Access 1 | Ventura holding 46 | 26925 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.118 | Ventura holding 46 | ||
10743 | 10743 | 10742 | {"type": "Polygon", "coordinates": [[[-119.16594, 34.26727], [-119.16553, 34.26773], [-119.16525, 34.26799], [-119.16494, 34.26823], [-119.16488, 34.26823], [-119.16468, 34.26802], [-119.16467, 34.268], [-119.16486, 34.26819], [-119.16494, 34.26819], [-119.16525, 34.26795], [-119.16552, 34.26769], [-119.16591, 34.26726], [-119.16594, 34.26727]]]} | Open Access 1 | Ventura holding 62 | 26943 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.121 | Ventura holding 62 | ||
10744 | 10744 | 10743 | {"type": "Polygon", "coordinates": [[[-119.2884, 34.30152], [-119.28837, 34.3016], [-119.28834, 34.3016], [-119.28831, 34.30171], [-119.28831, 34.30176], [-119.28834, 34.30177], [-119.2883, 34.30201], [-119.2882, 34.30199], [-119.28827, 34.3015], [-119.2884, 34.30152]]]} | Open Access 1 | Ventura holding 63 | 26944 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.121 | Ventura holding 63 | ||
10778 | 10778 | 10777 | {"type": "Polygon", "coordinates": [[[-119.19394, 34.28125], [-119.19393, 34.28125], [-119.1939, 34.28121], [-119.19385, 34.2812], [-119.19316, 34.28133], [-119.193, 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.19384, 34.28119], [-119.19391, 34.2812], [-119.19394, 34.28125]]]} | Open Access 1 | Ventura holding 99 | 26983 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.13 | Ventura holding 99 | ||
1241 | 1241 | 1240 | {"type": "Polygon", "coordinates": [[[-119.16534, 34.2838], [-119.16455, 34.28426], [-119.16452, 34.28422], [-119.1653, 34.28375], [-119.16534, 34.2838]]]} | Open Access 1 | Ventura holding 87 | 26970 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.134 | Ventura holding 87 | ||
10769 | 10769 | 10768 | {"type": "Polygon", "coordinates": [[[-119.19275, 34.28192], [-119.19271, 34.28193], [-119.1926, 34.28171], [-119.19254, 34.28155], [-119.19235, 34.28146], [-119.19161, 34.28157], [-119.19154, 34.28157], [-119.19154, 34.28155], [-119.19249, 34.28142], [-119.19255, 34.28146], [-119.19264, 34.28171], [-119.19275, 34.28192]]]} | Open Access 1 | Ventura holding 89 | 26972 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.135 | Ventura holding 89 | ||
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 | ||
10756 | 10756 | 10755 | {"type": "Polygon", "coordinates": [[[-119.2358, 34.27008], [-119.23514, 34.27057], [-119.23498, 34.27052], [-119.23496, 34.27046], [-119.23513, 34.2705], [-119.23575, 34.27004], [-119.2358, 34.27008]]]} | Open Access 1 | Ventura holding 75 | 26957 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.144 | Ventura holding 75 | ||
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 | ||
10763 | 10763 | 10762 | {"type": "Polygon", "coordinates": [[[-119.19154, 34.28157], [-119.1914, 34.28159], [-119.1912, 34.28156], [-119.19076, 34.28163], [-119.19065, 34.28177], [-119.19075, 34.28225], [-119.19076, 34.28228], [-119.19073, 34.28229], [-119.1906, 34.28169], [-119.19062, 34.28163], [-119.19066, 34.28161], [-119.19118, 34.28154], [-119.1914, 34.28156], [-119.19154, 34.28155], [-119.19154, 34.28157]]]} | Open Access 1 | Ventura holding 81 | 26964 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.146 | Ventura holding 81 | ||
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 | ||
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 | ||
11721 | 11721 | 11720 | {"type": "Polygon", "coordinates": [[[-119.29927, 34.28098], [-119.29918, 34.28154], [-119.29906, 34.28154], [-119.29914, 34.28097], [-119.29927, 34.28098]]]} | Open Access 1 | Valdez Alley | 30407 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.178 | Valdez Alley |
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]);