units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
106 rows where DES_TP = 14, MNG_AGENCY = 110 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 106 ✖
MNG_AGENCY 1
- Ventura, City of · 106 ✖
DES_TP 1
- Local Other or Unknown · 106 ✖
ACCESS_TYP 1
- Open Access 106
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13212 | 13212 | 13211 | {"type": "Polygon", "coordinates": [[[-119.29184, 34.30315], [-119.29181, 34.30323], [-119.29176, 34.30325], [-119.28819, 34.3025], [-119.28815, 34.30248], [-119.28814, 34.30246], [-119.28819, 34.30212], [-119.28829, 34.30214], [-119.28823, 34.30237], [-119.28845, 34.30242], [-119.28845, 34.30245], [-119.29184, 34.30315]]]} | Open Access 1 | 35249 | Ventura holding 51 | 26931 | 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.127 | Ventura holding 51 | 0 | Local Other or Unknown 14 | 4 | |
13219 | 13219 | 13218 | {"type": "Polygon", "coordinates": [[[-119.21773, 34.2678], [-119.21768, 34.26781], [-119.21761, 34.26761], [-119.21757, 34.26758], [-119.21751, 34.26756], [-119.21691, 34.2677], [-119.2169, 34.26771], [-119.21645, 34.26779], [-119.21661, 34.26857], [-119.21653, 34.26858], [-119.21635, 34.26774], [-119.21698, 34.26763], [-119.2176, 34.26749], [-119.21763, 34.26751], [-119.21773, 34.2678]]]} | Open Access 1 | 35263 | Ventura holding 59 | 26939 | 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.391 | Ventura holding 59 | 0 | Local Other or Unknown 14 | 4 | |
13220 | 13220 | 13219 | {"type": "Polygon", "coordinates": [[[-119.19521, 34.28644], [-119.19519, 34.28644], [-119.19511, 34.28596], [-119.19513, 34.28596], [-119.19521, 34.28644]]]} | Open Access 1 | 35264 | Ventura holding 58 | 26938 | 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.019 | Ventura holding 58 | 0 | Local Other or Unknown 14 | 4 | |
13221 | 13221 | 13220 | {"type": "Polygon", "coordinates": [[[-119.21697, 34.27068], [-119.21561, 34.27081], [-119.21516, 34.27077], [-119.21415, 34.27013], [-119.21391, 34.26989], [-119.21431, 34.27002], [-119.21524, 34.27061], [-119.21561, 34.27064], [-119.21683, 34.27053], [-119.21625, 34.26775], [-119.21635, 34.26774], [-119.21697, 34.27068]]]} | Open Access 1 | 35265 | Ventura holding 88 | 26971 | 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.072 | Ventura holding 88 | 0 | Local Other or Unknown 14 | 4 | |
13222 | 13222 | 13221 | {"type": "Polygon", "coordinates": [[[-119.17019, 34.27219], [-119.17012, 34.27215], [-119.17004, 34.27207], [-119.17003, 34.27202], [-119.16991, 34.27195], [-119.16982, 34.27187], [-119.16977, 34.27181], [-119.16971, 34.27177], [-119.16966, 34.27171], [-119.16968, 34.27168], [-119.16914, 34.2712], [-119.16898, 34.2711], [-119.16904, 34.27105], [-119.16885, 34.27084], [-119.16891, 34.27083], [-119.16895, 34.27085], [-119.1694, 34.27137], [-119.1702, 34.27209], [-119.17022, 34.27214], [-119.17019, 34.27219]]]} | Open Access 1 | 35266 | Ventura holding 57 | 26937 | 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.345 | Ventura holding 57 | 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 | |
13228 | 13228 | 13227 | {"type": "Polygon", "coordinates": [[[-119.1911, 34.28234], [-119.19107, 34.28236], [-119.19083, 34.28244], [-119.19075, 34.28238], [-119.19073, 34.28229], [-119.19076, 34.28229], [-119.19078, 34.28238], [-119.19083, 34.28242], [-119.1911, 34.28234]]]} | Open Access 1 | 35269 | Ventura holding 60 | 26941 | 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.022 | Ventura holding 60 | 0 | Local Other or Unknown 14 | 4 | |
13099 | 13099 | 13098 | {"type": "Polygon", "coordinates": [[[-119.29391, 34.3037], [-119.29388, 34.30377], [-119.2938, 34.3038], [-119.29334, 34.3037], [-119.29259, 34.30343], [-119.29204, 34.30331], [-119.29201, 34.30329], [-119.292, 34.30325], [-119.29202, 34.30319], [-119.29348, 34.30349], [-119.29345, 34.30361], [-119.29391, 34.3037]]]} | Open Access 1 | 35272 | Ventura holding 65 | 26946 | 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.699 | Ventura holding 65 | 0 | Local Other or Unknown 14 | 4 | |
13231 | 13231 | 13230 | {"type": "Polygon", "coordinates": [[[-119.28934, 34.29977], [-119.28906, 34.30067], [-119.2889, 34.30063], [-119.28891, 34.30058], [-119.28879, 34.30056], [-119.28877, 34.30057], [-119.28874, 34.30065], [-119.28867, 34.30065], [-119.28865, 34.30073], [-119.2887, 34.30075], [-119.2887, 34.30078], [-119.28854, 34.30075], [-119.28884, 34.30039], [-119.28897, 34.30023], [-119.28911, 34.29997], [-119.28921, 34.29974], [-119.28934, 34.29977]]]} | Open Access 1 | 35274 | Ventura holding 64 | 26945 | 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.564 | Ventura holding 64 | 0 | Local Other or Unknown 14 | 4 | |
13232 | 13232 | 13231 | {"type": "Polygon", "coordinates": [[[-119.3056, 34.29196], [-119.30467, 34.29284], [-119.30441, 34.29312], [-119.30405, 34.29472], [-119.30393, 34.29512], [-119.30378, 34.29545], [-119.30362, 34.29574], [-119.30346, 34.29571], [-119.30355, 34.2955], [-119.30366, 34.29519], [-119.30373, 34.29493], [-119.3039, 34.29382], [-119.30399, 34.29354], [-119.30411, 34.29331], [-119.30422, 34.29313], [-119.30444, 34.29285], [-119.30535, 34.29199], [-119.30542, 34.29193], [-119.3056, 34.29196]]]} | Open Access 1 | 35275 | Ventura holding 66 | 26947 | 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.462 | Ventura holding 66 | 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 | |
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 | |
13242 | 13242 | 13241 | {"type": "Polygon", "coordinates": [[[-119.16635, 34.26389], [-119.16519, 34.26459], [-119.16502, 34.26471], [-119.16483, 34.26489], [-119.16434, 34.26543], [-119.16427, 34.26549], [-119.16421, 34.26561], [-119.16421, 34.26569], [-119.16426, 34.26578], [-119.16434, 34.26585], [-119.16477, 34.26636], [-119.16504, 34.2666], [-119.16527, 34.26674], [-119.16561, 34.2669], [-119.1657, 34.26691], [-119.16578, 34.2669], [-119.16591, 34.26683], [-119.16615, 34.26702], [-119.16593, 34.26727], [-119.16504, 34.26697], [-119.16402, 34.26581], [-119.16411, 34.2656], [-119.16436, 34.26534], [-119.16444, 34.26513], [-119.16455, 34.26502], [-119.16479, 34.26487], [-119.16484, 34.26469], [-119.16556, 34.26419], [-119.1657, 34.26396], [-119.16584, 34.2639], [-119.16613, 34.26396], [-119.1662, 34.26389], [-119.16635, 34.26389]]]} | Open Access 1 | 35286 | Ventura holding 96 | 26980 | 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.502 | Ventura holding 96 | 0 | Local Other or Unknown 14 | 4 | |
13243 | 13243 | 13242 | {"type": "Polygon", "coordinates": [[[-119.16877, 34.27064], [-119.16876, 34.27067], [-119.16858, 34.27045], [-119.16824, 34.27065], [-119.16814, 34.27064], [-119.16805, 34.2704], [-119.16835, 34.2703], [-119.16825, 34.27004], [-119.1683, 34.27007], [-119.16877, 34.27064]]]} | Open Access 1 | 35287 | Ventura holding 91 | 26975 | 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.372 | Ventura holding 91 | 0 | Local Other or Unknown 14 | 4 | |
13244 | 13244 | 13243 | {"type": "Polygon", "coordinates": [[[-119.17644, 34.27619], [-119.17638, 34.27618], [-119.17631, 34.27613], [-119.17498, 34.27458], [-119.17492, 34.27461], [-119.17453, 34.27415], [-119.17424, 34.27389], [-119.17402, 34.27356], [-119.17305, 34.27243], [-119.17267, 34.27214], [-119.17256, 34.2719], [-119.17264, 34.27187], [-119.17365, 34.27303], [-119.1737, 34.27301], [-119.17644, 34.27619]]]} | Open Access 1 | 35288 | Ventura holding 90 | 26974 | 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.325 | Ventura holding 90 | 0 | Local Other or Unknown 14 | 4 | |
13246 | 13246 | 13245 | {"type": "Polygon", "coordinates": [[[-119.17722, 34.26059], [-119.17718, 34.26059], [-119.1769, 34.26038], [-119.17675, 34.26011], [-119.17642, 34.26014], [-119.17633, 34.26019], [-119.17607, 34.26025], [-119.17606, 34.26031], [-119.17581, 34.26047], [-119.17576, 34.26057], [-119.17563, 34.26054], [-119.17562, 34.26057], [-119.17457, 34.26054], [-119.17433, 34.26059], [-119.17373, 34.26086], [-119.17364, 34.26092], [-119.17348, 34.26107], [-119.1734, 34.26125], [-119.17333, 34.26123], [-119.1731, 34.26128], [-119.17327, 34.26119], [-119.17314, 34.26103], [-119.1732, 34.26095], [-119.17334, 34.26091], [-119.17346, 34.26078], [-119.17379, 34.26074], [-119.17388, 34.26062], [-119.17398, 34.26054], [-119.17407, 34.26054], [-119.17415, 34.26045], [-119.17425, 34.26039], [-119.17435, 34.26037], [-119.17453, 34.26046], [-119.17481, 34.26044], [-119.17483, 34.26029], [-119.17491, 34.26023], [-119.17511, 34.26028], [-119.17528, 34.26021], [-119.17545, 34.26027], [-119.17545, 34.26046], [-119.17563, 34.26049], [-119.17587, 34.26021], [-119.17616, 34.26002], [-119.17644, 34.25999], [-119.17658, 34.26003], [-119.17678, 34.25991], [-119.17703, 34.26039], [-119.1772, 34.26049], [-119.17722, 34.26059]]]} | Open Access 1 | 35291 | Ventura holding 95 | 26979 | 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.007 | Ventura holding 95 | 0 | Local Other or Unknown 14 | 4 | |
13247 | 13247 | 13246 | {"type": "Polygon", "coordinates": [[[-119.19609, 34.25545], [-119.19601, 34.2557], [-119.19558, 34.25596], [-119.19573, 34.25634], [-119.19517, 34.25684], [-119.195, 34.25825], [-119.19511, 34.25833], [-119.19501, 34.2584], [-119.19502, 34.25842], [-119.19529, 34.25841], [-119.19556, 34.25848], [-119.19553, 34.25863], [-119.19561, 34.25882], [-119.19558, 34.25897], [-119.19561, 34.25909], [-119.19556, 34.25911], [-119.19527, 34.25939], [-119.19534, 34.25961], [-119.19546, 34.25977], [-119.19544, 34.25994], [-119.19549, 34.26001], [-119.19557, 34.26002], [-119.19566, 34.26014], [-119.19585, 34.26029], [-119.19558, 34.2604], [-119.19544, 34.26052], [-119.19538, 34.26068], [-119.19541, 34.26096], [-119.19572, 34.2614], [-119.19513, 34.26146], [-119.19508, 34.26144], [-119.19506, 34.2614], [-119.19504, 34.2614], [-119.19477, 34.26015], [-119.19476, 34.26005], [-119.19472, 34.25997], [-119.19466, 34.25991], [-119.19483, 34.2597], [-119.19479, 34.25953], [-119.19479, 34.2591], [-119.19482, 34.25885], [-119.19471, 34.25886], [-119.19449, 34.25865], [-119.19439, 34.2585], [-119.19435, 34.25834], [-119.19436, 34.25822], [-119.19472, 34.2571], [-119.19477, 34.25669], [-119.19474, 34.25649], [-119.19497, 34.25635], [-119.19493, 34.25607], [-119.19484, 34.25574], [-119.19535, 34.25561], [-119.19581, 34.25515], [-119.19587, 34.25511], [-119.19609, 34.25545]]]} | Open Access 1 | 35292 | Ventura holding 94 | 26978 | 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 | 10.393 | Ventura holding 94 | 0 | Local Other or Unknown 14 | 4 | |
13248 | 13248 | 13247 | {"type": "Polygon", "coordinates": [[[-119.19796, 34.28378], [-119.19779, 34.28402], [-119.19793, 34.2843], [-119.19789, 34.28445], [-119.19762, 34.28482], [-119.19739, 34.28582], [-119.197, 34.28569], [-119.19713, 34.28545], [-119.19748, 34.28448], [-119.1975, 34.28427], [-119.19745, 34.284], [-119.19745, 34.28385], [-119.19796, 34.28378]]]} | Open Access 1 | 35293 | Ventura holding 133 | 26889 | 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.7 | Ventura holding 133 | 0 | Local Other or Unknown 14 | 4 | |
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-119.19871, 34.28098], [-119.19821, 34.2821], [-119.19765, 34.28218], [-119.19803, 34.28189], [-119.19846, 34.28084], [-119.19839, 34.28049], [-119.19865, 34.28045], [-119.19871, 34.28098]]]} | Open Access 1 | 35294 | Ventura holding 93 | 26977 | 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.228 | Ventura holding 93 | 0 | Local Other or Unknown 14 | 4 | |
13250 | 13250 | 13249 | {"type": "Polygon", "coordinates": [[[-119.20753, 34.27207], [-119.20215, 34.27284], [-119.20212, 34.27268], [-119.2061, 34.27211], [-119.20613, 34.272], [-119.20633, 34.27201], [-119.20648, 34.272], [-119.20749, 34.27186], [-119.20753, 34.27207]]]} | Open Access 1 | 35295 | Ventura holding 92 | 26976 | 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.462 | Ventura holding 92 | 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]);