units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
110 rows where COUNTY = 8, DES_TP = 14 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID
MNG_AGENCY 3
MNG_AG_TYP 1
- City Agency · 110 ✖
DES_TP 1
- Local Other or Unknown · 110 ✖
ACCESS_TYP 1
- Open Access 110
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
275 | 275 | 274 | {"type": "Polygon", "coordinates": [[[-119.19704, 34.28676], [-119.1969, 34.28706], [-119.19612, 34.28715], [-119.19612, 34.28713], [-119.19635, 34.28707], [-119.19658, 34.28696], [-119.19673, 34.28683], [-119.19685, 34.28668], [-119.19704, 34.28676]]]} | Open Access 1 | 35439 | Ventura holding 73 | 26955 | 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 | Ventura holding 73 | 0 | Local Other or Unknown 14 | 4 | |
276 | 276 | 275 | {"type": "Polygon", "coordinates": [[[-119.17054, 34.28047], [-119.17066, 34.2806], [-119.17066, 34.28063], [-119.17064, 34.28066], [-119.16734, 34.28261], [-119.16727, 34.2826], [-119.16717, 34.28249], [-119.16745, 34.28232], [-119.16748, 34.28234], [-119.16892, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047]]]} | Open Access 1 | 35440 | Ventura holding 72 | 26954 | 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.844 | Ventura holding 72 | 0 | Local Other or Unknown 14 | 4 | |
3435 | 3435 | 3434 | {"type": "Polygon", "coordinates": [[[-119.16407, 34.29454], [-119.16386, 34.29466], [-119.16329, 34.294], [-119.1635, 34.29388], [-119.16407, 34.29454]]]} | Open Access 1 | 35441 | Ventura holding 78 | 26960 | 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.529 | Ventura holding 78 | 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 | |
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 | |
4584 | 4584 | 4583 | {"type": "MultiPolygon", "coordinates": [[[[-119.29299, 34.28177], [-119.29297, 34.28184], [-119.29281, 34.28191], [-119.29269, 34.28203], [-119.29249, 34.28203], [-119.29249, 34.28177], [-119.29299, 34.28177]]], [[[-119.29359, 34.28203], [-119.29355, 34.28202], [-119.2935, 34.28196], [-119.29342, 34.2819], [-119.29328, 34.28185], [-119.29326, 34.28181], [-119.29325, 34.28176], [-119.29359, 34.28175], [-119.29359, 34.28203]]]]} | Open Access 1 | 35403 | Unknown park - Ventura, City of | 30393 | 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.37 | 0 | Local Other or Unknown 14 | 4 | ||
4799 | 4799 | 4798 | {"type": "Polygon", "coordinates": [[[-118.86173, 34.28582], [-118.86002, 34.28619], [-118.85448, 34.28618], [-118.85629, 34.28478], [-118.85712, 34.28437], [-118.85736, 34.28427], [-118.85765, 34.28419], [-118.85807, 34.28414], [-118.85838, 34.28414], [-118.85869, 34.28418], [-118.85895, 34.28424], [-118.85926, 34.28436], [-118.85956, 34.28452], [-118.85984, 34.28474], [-118.85998, 34.28489], [-118.86011, 34.28504], [-118.86013, 34.28504], [-118.86021, 34.28521], [-118.86035, 34.28538], [-118.86048, 34.2855], [-118.86063, 34.28561], [-118.86086, 34.28572], [-118.86114, 34.2858], [-118.86143, 34.28584], [-118.86173, 34.28582]]]} | Open Access 1 | 48610 | Unnamed site - Moorpark, City of | 33324 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 21.958 | 0 | Local Other or Unknown 14 | 4 | ||
4929 | 4929 | 4928 | {"type": "Polygon", "coordinates": [[[-119.21579, 34.2647], [-119.21578, 34.26473], [-119.21571, 34.26474], [-119.21563, 34.26463], [-119.21548, 34.26396], [-119.21542, 34.26385], [-119.2154, 34.26375], [-119.21549, 34.26372], [-119.21534, 34.26306], [-119.21528, 34.26306], [-119.21473, 34.26051], [-119.2148, 34.26048], [-119.21485, 34.26052], [-119.21494, 34.26076], [-119.21579, 34.2647]]]} | Open Access 1 | 35381 | Ventura holding 17 | 26893 | 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.513 | Ventura holding 17 | 0 | Local Other or Unknown 14 | 4 | |
4938 | 4938 | 4937 | {"type": "Polygon", "coordinates": [[[-119.17469, 34.27817], [-119.17468, 34.27823], [-119.17464, 34.27827], [-119.17386, 34.27873], [-119.17383, 34.27873], [-119.17377, 34.27866], [-119.17467, 34.27812], [-119.17469, 34.27817]]]} | Open Access 1 | 35380 | Ventura holding 16 | 26892 | 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.296 | Ventura holding 16 | 0 | Local Other or Unknown 14 | 4 | |
4990 | 4990 | 4989 | {"type": "Polygon", "coordinates": [[[-119.19623, 34.28781], [-119.19547, 34.28778], [-119.19543, 34.28773], [-119.19535, 34.28731], [-119.19537, 34.28731], [-119.19544, 34.28773], [-119.19547, 34.28777], [-119.19623, 34.2878], [-119.19623, 34.28781]]]} | Open Access 1 | 35438 | Ventura holding 71 | 26953 | 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.047 | Ventura holding 71 | 0 | Local Other or Unknown 14 | 4 | |
7777 | 7777 | 7776 | {"type": "Polygon", "coordinates": [[[-119.19536, 34.28728], [-119.19535, 34.28728], [-119.1952, 34.28644], [-119.19521, 34.28644], [-119.19536, 34.28728]]]} | Open Access 1 | 35437 | Ventura holding 70 | 26952 | 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.035 | Ventura holding 70 | 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 | |
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 | |
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 | |
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 | |
13218 | 13218 | 13217 | {"type": "Polygon", "coordinates": [[[-119.18391, 34.16307], [-119.18388, 34.16515], [-119.18338, 34.16516], [-119.18325, 34.16511], [-119.18315, 34.16513], [-119.18312, 34.16516], [-119.18312, 34.16559], [-119.18135, 34.16558], [-119.18132, 34.16526], [-119.18123, 34.16495], [-119.18107, 34.16461], [-119.1808, 34.1642], [-119.18072, 34.16402], [-119.18067, 34.16387], [-119.18063, 34.16355], [-119.18063, 34.16304], [-119.18389, 34.16305], [-119.18391, 34.16307]]]} | Open Access 1 | 35262 | Oxnard holding 1 | 23282 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 18.2 | Oxnard holding 1 | 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 |
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]);