units_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 SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP 12
- Local Other or Unknown 106
- Local Park 12
- Local Recreation Area 2
- Local Conservation Area 1
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 129
MNG_AGENCY 1
- Ventura, City of · 129 ✖
ACCESS_TYP 1
- Open Access · 129 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9859 | 9859 | 9858 | {"type": "Polygon", "coordinates": [[[-119.27907, 34.27421], [-119.2788, 34.27444], [-119.27871, 34.27449], [-119.2779, 34.27472], [-119.278, 34.27443], [-119.27799, 34.27438], [-119.27795, 34.27435], [-119.27813, 34.27393], [-119.27907, 34.27421]]]} | Open Access 1 | 18234 | Ocean Avenue Park | 23049 | 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.226 | Ocean Avenue Park | 0 | Local Park 2 | 4 | |
328 | 328 | 327 | {"type": "Polygon", "coordinates": [[[-119.29146, 34.27945], [-119.29013, 34.27946], [-119.29013, 34.27839], [-119.29145, 34.27838], [-119.29146, 34.27945]]]} | Open Access 1 | 18656 | Plaza Park | 23788 | 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 | 3.582 | Plaza Park | 0 | Local Park 2 | 4 | |
6048 | 6048 | 6047 | {"type": "Polygon", "coordinates": [[[-119.31032, 34.27539], [-119.30982, 34.2768], [-119.30702, 34.27681], [-119.30701, 34.27687], [-119.30673, 34.27687], [-119.30669, 34.27439], [-119.30656, 34.27418], [-119.30655, 34.27387], [-119.30722, 34.27419], [-119.31032, 34.27539]]]} | Open Access 1 | 747 | Seaside Wilderness Park | 25268 | 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 | 18.648 | Seaside Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
6209 | 6209 | 6208 | {"type": "Polygon", "coordinates": [[[-119.26813, 34.2416], [-119.26604, 34.24115], [-119.26603, 34.24099], [-119.266, 34.24083], [-119.26594, 34.24068], [-119.26585, 34.24051], [-119.26573, 34.24035], [-119.2656, 34.24023], [-119.26544, 34.2401], [-119.2653, 34.24002], [-119.26568, 34.23968], [-119.26797, 34.23964], [-119.26797, 34.23973], [-119.26816, 34.24048], [-119.26813, 34.2416]]]} | Open Access 1 | 1264 | Surfers Knoll | 26076 | 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.057 | Surfers Knoll | None 501 | |||
5248 | 5248 | 5247 | {"type": "Polygon", "coordinates": [[[-119.2221, 34.26685], [-119.22138, 34.26692], [-119.22084, 34.26693], [-119.22068, 34.26693], [-119.22064, 34.26691], [-119.2206, 34.26686], [-119.2206, 34.26657], [-119.22058, 34.26637], [-119.22054, 34.26617], [-119.22035, 34.26566], [-119.22182, 34.26545], [-119.2221, 34.26685]]]} | Open Access 1 | 1345 | Thille Neighborhood Park | 26302 | 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.001 | Thille Neighborhood Park | 0 | Local Park 2 | 4 | |
4241 | 4241 | 4240 | {"type": "Polygon", "coordinates": [[[-119.19697, 34.2736], [-119.19523, 34.27385], [-119.19373, 34.27395], [-119.19338, 34.27393], [-119.19304, 34.27389], [-119.1927, 34.27383], [-119.19221, 34.2737], [-119.19188, 34.27366], [-119.19172, 34.27365], [-119.19126, 34.27367], [-119.19095, 34.27377], [-119.19079, 34.2734], [-119.19033, 34.27312], [-119.18987, 34.27244], [-119.18962, 34.27202], [-119.18927, 34.27128], [-119.18934, 34.2712], [-119.18943, 34.27118], [-119.18938, 34.27097], [-119.18929, 34.27098], [-119.18919, 34.27092], [-119.18879, 34.26901], [-119.1888, 34.26897], [-119.18886, 34.26893], [-119.18896, 34.26892], [-119.18906, 34.26893], [-119.18931, 34.26889], [-119.18943, 34.26885], [-119.1933, 34.26829], [-119.19336, 34.2683], [-119.19341, 34.26834], [-119.19366, 34.2683], [-119.19369, 34.26825], [-119.19374, 34.26822], [-119.19593, 34.26791], [-119.19595, 34.2682], [-119.19663, 34.26878], [-119.19634, 34.26986], [-119.19682, 34.2708], [-119.19642, 34.27132], [-119.1966, 34.27197], [-119.19684, 34.27333], [-119.19697, 34.2736]]]} | Open Access 1 | 1703 | Ventura Community Park | 26850 | 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 | 96.758 | Ventura Community Park | 0 | Local Park 2 | 4 | |
13288 | 13288 | 13287 | {"type": "Polygon", "coordinates": [[[-119.21761, 34.28638], [-119.21698, 34.28703], [-119.21633, 34.28845], [-119.2163, 34.28845], [-119.21663, 34.28765], [-119.21669, 34.28742], [-119.21672, 34.28726], [-119.21673, 34.28703], [-119.21676, 34.287], [-119.21693, 34.28695], [-119.21703, 34.28687], [-119.21731, 34.28641], [-119.21739, 34.28622], [-119.21742, 34.28601], [-119.21738, 34.28531], [-119.21736, 34.28526], [-119.21732, 34.28522], [-119.21725, 34.2852], [-119.21719, 34.28521], [-119.21719, 34.28515], [-119.21755, 34.28514], [-119.21761, 34.28638]]]} | Open Access 1 | 35342 | Ventura holding 1 | 26851 | 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.233 | Ventura holding 1 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
3584 | 3584 | 3583 | {"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 | 36691 | Ventura holding 106 | 26859 | 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.046 | Ventura holding 106 | 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 | |
13299 | 13299 | 13298 | {"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.16407, 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.16177, 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.16206, 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.16504, 34.26697], [-119.16591, 34.26726]]]} | Open Access 1 | 35352 | Ventura holding 11 | 26863 | 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 | 3.411 | Ventura holding 11 | 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 |
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]);