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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5192 | 5192 | 5191 | {"type": "Polygon", "coordinates": [[[-119.18193, 34.28262], [-119.17992, 34.28381], [-119.17988, 34.28376], [-119.17982, 34.28376], [-119.17976, 34.28374], [-119.17908, 34.28296], [-119.18115, 34.28172], [-119.18193, 34.28262]]]} | Open Access 1 | Hobert Park | 20017 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 7.064 | Hobert Park | ||
5622 | 5622 | 5621 | {"type": "Polygon", "coordinates": [[[-119.19409, 34.28345], [-119.19406, 34.28349], [-119.19352, 34.28372], [-119.19323, 34.28379], [-119.19143, 34.28403], [-119.19137, 34.28401], [-119.19124, 34.28332], [-119.19164, 34.28327], [-119.19174, 34.2833], [-119.19185, 34.2833], [-119.19193, 34.28328], [-119.19201, 34.28324], [-119.19264, 34.28314], [-119.19282, 34.28313], [-119.19292, 34.28309], [-119.19299, 34.28302], [-119.19348, 34.28277], [-119.19377, 34.28303], [-119.19396, 34.28324], [-119.19409, 34.28341], [-119.19409, 34.28345]]]} | Open Access 1 | Juanamaria Park | 20513 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 5.001 | Juanamaria Park | ||
5640 | 5640 | 5639 | {"type": "Polygon", "coordinates": [[[-119.17382, 34.2657], [-119.17222, 34.26667], [-119.17186, 34.26626], [-119.17188, 34.26622], [-119.17342, 34.26529], [-119.17347, 34.2653], [-119.17382, 34.2657]]]} | Open Access 1 | Junipero Serra Park | 20532 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 2.621 | Junipero Serra Park | ||
6448 | 6448 | 6447 | {"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 | Ocean Avenue Park | 23049 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.225 | Ocean Avenue Park | ||
6655 | 6655 | 6654 | {"type": "Polygon", "coordinates": [[[-119.2715, 34.24778], [-119.27137, 34.248], [-119.27093, 34.24857], [-119.26993, 34.24979], [-119.26963, 34.25021], [-119.26943, 34.25055], [-119.26929, 34.25108], [-119.26924, 34.25176], [-119.26926, 34.25198], [-119.26939, 34.25259], [-119.26959, 34.25322], [-119.26983, 34.25377], [-119.27022, 34.25443], [-119.27133, 34.25416], [-119.27139, 34.25417], [-119.27138, 34.25424], [-119.27049, 34.25443], [-119.27049, 34.25456], [-119.27005, 34.25469], [-119.26964, 34.25478], [-119.26922, 34.2549], [-119.269, 34.25495], [-119.26878, 34.25497], [-119.26815, 34.25497], [-119.26768, 34.25502], [-119.2676, 34.25475], [-119.26703, 34.25485], [-119.2666, 34.25311], [-119.26716, 34.2528], [-119.2674, 34.25291], [-119.26757, 34.25343], [-119.26775, 34.25347], [-119.26883, 34.25322], [-119.26894, 34.25314], [-119.26897, 34.25305], [-119.26864, 34.25214], [-119.26845, 34.25145], [-119.26842, 34.25093], [-119.26845, 34.25059], [-119.26851, 34.2505], [-119.26888, 34.25043], [-119.26921, 34.25029], [-119.26963, 34.24988], [-119.27018, 34.24926], [-119.27114, 34.24794], [-119.27138, 34.24769], [-119.27149, 34.24766], [-119.2715, 34.24778]]]} | Open Access 1 | Marina Park | 21838 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 20.482 | Marina Park | ||
6683 | 6683 | 6682 | {"type": "Polygon", "coordinates": [[[-119.22184, 34.2617], [-119.21958, 34.26203], [-119.21948, 34.26171], [-119.21934, 34.26104], [-119.22048, 34.26087], [-119.22144, 34.26121], [-119.22173, 34.26117], [-119.22184, 34.2617]]]} | Open Access 1 | Marion Cannon Park | 21862 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 5.024 | Marion Cannon Park | ||
6927 | 6927 | 6926 | {"type": "Polygon", "coordinates": [[[-119.28155, 34.28091], [-119.28137, 34.2815], [-119.28138, 34.28152], [-119.28144, 34.28152], [-119.28131, 34.282], [-119.2812, 34.28198], [-119.28119, 34.28195], [-119.27996, 34.28169], [-119.27993, 34.28171], [-119.27875, 34.28146], [-119.27908, 34.28039], [-119.28155, 34.28091]]]} | Open Access 1 | Memorial Park | 22137 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 7.12 | Memorial Park | ||
7049 | 7049 | 7048 | {"type": "Polygon", "coordinates": [[[-119.29881, 34.2807], [-119.29868, 34.28069], [-119.29865, 34.28065], [-119.29825, 34.28064], [-119.29823, 34.28062], [-119.29798, 34.28062], [-119.29792, 34.2807], [-119.29782, 34.2807], [-119.29782, 34.28012], [-119.29826, 34.28012], [-119.29827, 34.28], [-119.29881, 34.27999], [-119.29881, 34.2807]]]} | Open Access 1 | Mission Park | 22306 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.501 | Mission Park | ||
7118 | 7118 | 7117 | {"type": "Polygon", "coordinates": [[[-119.21107, 34.25987], [-119.20587, 34.26068], [-119.20572, 34.25995], [-119.20576, 34.25989], [-119.2063, 34.25984], [-119.20648, 34.25981], [-119.20662, 34.25975], [-119.20684, 34.25962], [-119.20695, 34.25952], [-119.20705, 34.2594], [-119.2071, 34.25938], [-119.20742, 34.25944], [-119.20773, 34.25943], [-119.20785, 34.25997], [-119.20801, 34.26004], [-119.21, 34.25969], [-119.21005, 34.25986], [-119.21103, 34.25971], [-119.21107, 34.25987]]]} | Open Access 1 | Montalvo Neighborhood Park | 22383 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 6.841 | Montalvo Neighborhood Park | ||
8240 | 8240 | 8239 | {"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 | Plaza Park | 23788 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 3.581 | Plaza Park | ||
9205 | 9205 | 9204 | {"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.28741], [-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 | Ventura holding 1 | 26851 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.233 | Ventura holding 1 | ||
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 | ||
9238 | 9238 | 9237 | {"type": "Polygon", "coordinates": [[[-119.16877, 34.27064], [-119.16876, 34.27067], [-119.16858, 34.27046], [-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 | Ventura holding 91 | 26975 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.376 | Ventura holding 91 | ||
9239 | 9239 | 9238 | {"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 | Ventura holding 92 | 26976 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 2.46 | Ventura holding 92 | ||
9466 | 9466 | 9465 | {"type": "Polygon", "coordinates": [[[-119.31032, 34.27539], [-119.30982, 34.2768], [-119.30703, 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 | Seaside Wilderness Park | 25268 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 18.648 | Seaside Wilderness Park | ||
10144 | 10144 | 10143 | {"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.23974], [-119.26816, 34.24048], [-119.26813, 34.2416]]]} | Open Access 1 | Surfers Knoll | 26076 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 10.055 | Surfers Knoll | ||
10320 | 10320 | 10319 | {"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 | Thille Neighborhood Park | 26302 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 5.0 | Thille Neighborhood Park | ||
10663 | 10663 | 10662 | {"type": "Polygon", "coordinates": [[[-119.17299, 34.27661], [-119.17293, 34.27664], [-119.17289, 34.27663], [-119.17275, 34.27647], [-119.17274, 34.27641], [-119.17279, 34.27638], [-119.17299, 34.27661]]]} | Open Access 1 | Ventura holding 13 | 26885 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.067 | Ventura holding 13 | ||
10673 | 10673 | 10672 | {"type": "Polygon", "coordinates": [[[-119.19484, 34.25184], [-119.19466, 34.25189], [-119.19455, 34.25162], [-119.19298, 34.24821], [-119.19311, 34.24817], [-119.19315, 34.24819], [-119.19318, 34.24822], [-119.19386, 34.24969], [-119.19389, 34.24979], [-119.19397, 34.24988], [-119.19474, 34.25156], [-119.19484, 34.25184]]]} | Open Access 1 | Ventura holding 132 | 26888 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1.882 | Ventura holding 132 | ||
10677 | 10677 | 10676 | {"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.27117], [-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.26831], [-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.19643, 34.27132], [-119.1966, 34.27197], [-119.19684, 34.27333], [-119.19697, 34.2736]]]} | Open Access 1 | Ventura Community Park | 26850 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 96.766 | Ventura Community Park |
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]);