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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13931 | 13931 | 13930 | {"type": "Polygon", "coordinates": [[[-119.17513, 34.27798], [-119.17494, 34.27809], [-119.17486, 34.27808], [-119.1748, 34.27804], [-119.17505, 34.27789], [-119.17513, 34.27798]]]} | Open Access 1 | 36537 | Ventura holding 124 | 26879 | 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.075 | Ventura holding 124 | 0 | Local Other or Unknown 14 | 4 | |
13289 | 13289 | 13288 | {"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 | 35343 | Ventura holding 2 | 26896 | 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.076 | Ventura holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13362 | 13362 | 13361 | {"type": "Polygon", "coordinates": [[[-119.19348, 34.28277], [-119.19345, 34.28278], [-119.19343, 34.28277], [-119.19323, 34.28259], [-119.19307, 34.28242], [-119.1929, 34.28221], [-119.19282, 34.28219], [-119.19258, 34.28229], [-119.19281, 34.28217], [-119.19293, 34.2822], [-119.19318, 34.28249], [-119.19348, 34.28277]]]} | Open Access 1 | 35446 | Ventura holding 79 | 26961 | 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.08 | Ventura holding 79 | 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 | |
13361 | 13361 | 13360 | {"type": "Polygon", "coordinates": [[[-119.19127, 34.28332], [-119.19124, 34.28332], [-119.19122, 34.28329], [-119.19114, 34.28307], [-119.19106, 34.28291], [-119.19085, 34.28263], [-119.19087, 34.28254], [-119.19111, 34.28247], [-119.19115, 34.28247], [-119.19089, 34.28255], [-119.19087, 34.28261], [-119.19112, 34.28294], [-119.19121, 34.28313], [-119.19127, 34.28332]]]} | Open Access 1 | 35445 | Ventura holding 80 | 26963 | 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.086 | Ventura holding 80 | 0 | Local Other or Unknown 14 | 4 | |
13296 | 13296 | 13295 | {"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 | 35350 | Ventura holding 6 | 26940 | 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.087 | Ventura holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13294 | 13294 | 13293 | {"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 | 35348 | Ventura holding 10 | 26852 | 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.11 | Ventura holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13332 | 13332 | 13331 | {"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 | 35408 | Ventura holding 46 | 26925 | 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.117 | Ventura holding 46 | 0 | Local Other or Unknown 14 | 4 | |
13223 | 13223 | 13222 | {"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.16487, 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 | 35267 | Ventura holding 62 | 26943 | 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.12 | Ventura holding 62 | 0 | Local Other or Unknown 14 | 4 | |
13236 | 13236 | 13235 | {"type": "Polygon", "coordinates": [[[-119.2884, 34.30152], [-119.28837, 34.3016], [-119.28834, 34.3016], [-119.2883, 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 | 35280 | Ventura holding 63 | 26944 | 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.12 | Ventura holding 63 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
13241 | 13241 | 13240 | {"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 | 35285 | Ventura holding 87 | 26970 | 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.134 | Ventura holding 87 | 0 | Local Other or Unknown 14 | 4 | |
13358 | 13358 | 13357 | {"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 | 35442 | Ventura holding 89 | 26972 | 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.134 | Ventura holding 89 | 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 | |
13352 | 13352 | 13351 | {"type": "Polygon", "coordinates": [[[-119.2358, 34.27008], [-119.23514, 34.27057], [-119.23498, 34.27052], [-119.23496, 34.27046], [-119.23512, 34.2705], [-119.23575, 34.27004], [-119.2358, 34.27008]]]} | Open Access 1 | 35431 | Ventura holding 75 | 26957 | 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 75 | 0 | Local Other or Unknown 14 | 4 | |
13360 | 13360 | 13359 | {"type": "Polygon", "coordinates": [[[-119.19154, 34.28157], [-119.1914, 34.28159], [-119.1912, 34.28156], [-119.19077, 34.28162], [-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.28153], [-119.1914, 34.28156], [-119.19154, 34.28155], [-119.19154, 34.28157]]]} | Open Access 1 | 35444 | Ventura holding 81 | 26964 | 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 81 | 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 | |
13124 | 13124 | 13123 | {"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 | 35357 | Ventura holding 12 | 26874 | 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.176 | Ventura holding 12 | 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 | |
13359 | 13359 | 13358 | {"type": "Polygon", "coordinates": [[[-119.16104, 34.2693], [-119.16057, 34.2694], [-119.16054, 34.26934], [-119.16099, 34.26909], [-119.16104, 34.2693]]]} | Open Access 1 | 35443 | Ventura holding 82 | 26965 | 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.179 | Ventura holding 82 | 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]);