units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where MNG_AGENCY = 110 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Other or Unknown 106
- Local Park 17
- Local Recreation Area 2
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 130
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 131
MNG_AGENCY 1
- Ventura, City of · 131 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10132 | 10132 | 10131 | {"type": "Polygon", "coordinates": [[[-119.2715, 34.24778], [-119.27137, 34.248], [-119.27093, 34.24857], [-119.26993, 34.24979], [-119.26963, 34.25021], [-119.26942, 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.27023, 34.25443], [-119.27133, 34.25416], [-119.27139, 34.25417], [-119.27138, 34.25424], [-119.27048, 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.26814, 34.25497], [-119.26768, 34.25502], [-119.26761, 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.25306], [-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.2692, 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 | 17627 | Marina Park | 21838 | 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 | 20.468 | Marina Park | 0 | Local Park 2 | 4 | |
2173 | 2173 | 2172 | {"type": "Polygon", "coordinates": [[[-119.22184, 34.2617], [-119.21958, 34.26203], [-119.21948, 34.26171], [-119.21934, 34.26104], [-119.22048, 34.26087], [-119.22145, 34.26121], [-119.22173, 34.26117], [-119.22184, 34.2617]]]} | Open Access 1 | 17676 | Marion Cannon Park | 21862 | 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.024 | Marion Cannon Park | 0 | Local Park 2 | 4 | |
2537 | 2537 | 2536 | {"type": "Polygon", "coordinates": [[[-119.28155, 34.28091], [-119.28137, 34.2815], [-119.28137, 34.28152], [-119.28144, 34.28152], [-119.28131, 34.282], [-119.2812, 34.28198], [-119.2812, 34.28195], [-119.27995, 34.28168], [-119.27993, 34.28171], [-119.27875, 34.28146], [-119.27908, 34.28039], [-119.28155, 34.28091]]]} | Open Access 1 | 17763 | Memorial Park | 22137 | 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 | 7.12 | Memorial Park | 0 | Local Park 2 | 4 | |
2554 | 2554 | 2553 | {"type": "Polygon", "coordinates": [[[-119.29544, 34.2807], [-119.29517, 34.28071], [-119.29517, 34.28016], [-119.29543, 34.28015], [-119.29544, 34.2807]]]} | Open Access 1 | 17815 | Downtown Mini Park | 30396 | 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.367 | Downtown MP | 0 | Local Park 2 | 4 | |
2571 | 2571 | 2570 | {"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 | 17855 | Mission Park | 22306 | 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.499 | Mission Park | 0 | Local Park 2 | 4 | |
2579 | 2579 | 2578 | {"type": "Polygon", "coordinates": [[[-119.21107, 34.25987], [-119.20587, 34.26068], [-119.20572, 34.25995], [-119.20573, 34.25993], [-119.20576, 34.25991], [-119.20576, 34.25989], [-119.2063, 34.25985], [-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.25998], [-119.20801, 34.26004], [-119.21, 34.25969], [-119.21005, 34.25986], [-119.21103, 34.25971], [-119.21107, 34.25987]]]} | Open Access 1 | 17901 | Montalvo Neighborhood Park | 22383 | 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.837 | Montalvo Neighborhood Park | 0 | Local Park 2 | 4 | |
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 | |
15696 | 15696 | 15695 | {"type": "Polygon", "coordinates": [[[-119.25659, 34.24231], [-119.25428, 34.24229], [-119.25451, 34.244], [-119.25412, 34.24391], [-119.25352, 34.24372], [-119.2535, 34.2436], [-119.25333, 34.24354], [-119.25321, 34.24362], [-119.25217, 34.24328], [-119.25168, 34.24317], [-119.25117, 34.24308], [-119.25049, 34.24303], [-119.2489, 34.24299], [-119.24827, 34.24302], [-119.24768, 34.2431], [-119.24767, 34.24276], [-119.24749, 34.24276], [-119.24709, 34.24323], [-119.24437, 34.24382], [-119.2436, 34.24393], [-119.24348, 34.24318], [-119.24343, 34.24302], [-119.24322, 34.24276], [-119.24288, 34.24238], [-119.2422, 34.24282], [-119.24183, 34.24303], [-119.24184, 34.24356], [-119.24141, 34.24358], [-119.24116, 34.24321], [-119.24087, 34.23673], [-119.24288, 34.23684], [-119.25623, 34.23634], [-119.25629, 34.23783], [-119.25642, 34.23784], [-119.25659, 34.24231]]]} | Restricted Access 2 | 18293 | Olivas Links Golf Course | 33063 | 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 | 254.598 | Olivas Links GC | 0 | Local Recreation Area 3 | 4 | |
2715 | 2715 | 2714 | {"type": "Polygon", "coordinates": [[[-119.24423, 34.26821], [-119.24402, 34.26824], [-119.24392, 34.26819], [-119.24388, 34.26802], [-119.24397, 34.26778], [-119.2441, 34.26777], [-119.24413, 34.26779], [-119.24423, 34.26821]]]} | Open Access 1 | 18346 | Pacific View Skateboard Bowl | 30404 | 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.303 | Pacific View Skateboard Bowl | None 224 | |||
2758 | 2758 | 2757 | {"type": "Polygon", "coordinates": [[[-119.25364, 34.26594], [-119.25348, 34.2665], [-119.25342, 34.26648], [-119.25332, 34.26643], [-119.25155, 34.26523], [-119.25153, 34.26518], [-119.25194, 34.26476], [-119.25364, 34.26594]]]} | Open Access 1 | 18453 | Blanche Reynolds Park | 16156 | 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.329 | Blanche Reynolds Park | 0 | Local Park 2 | 4 | |
10311 | 10311 | 10310 | {"type": "Polygon", "coordinates": [[[-119.26385, 34.27887], [-119.26332, 34.27914], [-119.26332, 34.27914], [-119.26326, 34.27886], [-119.26355, 34.27884], [-119.26385, 34.27887]]]} | Open Access 1 | 18489 | McWherter Corner | 30405 | 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.229 | McWherter Corner | None 902 | |||
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 | |
10582 | 10582 | 10581 | {"type": "Polygon", "coordinates": [[[-119.29759, 34.27487], [-119.29711, 34.2751], [-119.29675, 34.27523], [-119.29406, 34.276], [-119.29353, 34.27611], [-119.29296, 34.27615], [-119.29296, 34.27585], [-119.29317, 34.27581], [-119.29354, 34.2757], [-119.29388, 34.27557], [-119.294, 34.27551], [-119.29421, 34.27545], [-119.29488, 34.27522], [-119.29675, 34.27469], [-119.29758, 34.27441], [-119.29759, 34.27487]]]} | Open Access 1 | 18842 | Waterfront Promenade | 30392 | 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.853 | Waterfront Promenade | 0 | None 931 | ||
12106 | 12106 | 12105 | {"type": "Polygon", "coordinates": [[[-119.25023, 34.25941], [-119.25002, 34.2595], [-119.2499, 34.25948], [-119.24973, 34.25951], [-119.24896, 34.25989], [-119.2484, 34.26019], [-119.24816, 34.26029], [-119.24733, 34.26077], [-119.24719, 34.26087], [-119.24697, 34.26109], [-119.24673, 34.26142], [-119.24659, 34.26126], [-119.24652, 34.26122], [-119.24676, 34.26088], [-119.24702, 34.26064], [-119.24719, 34.26053], [-119.24837, 34.25986], [-119.24846, 34.25996], [-119.24864, 34.26004], [-119.24863, 34.25986], [-119.24854, 34.25976], [-119.24897, 34.25951], [-119.24893, 34.25942], [-119.24922, 34.25898], [-119.24928, 34.25901], [-119.2493, 34.25898], [-119.25023, 34.25941]]]} | Open Access 1 | 25010 | Arundell Linear Park | 15643 | 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.39 | Arundell Linear Park | 0 | Local Park 2 | 4 | |
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 |
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]);