units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where AGNCY_LEV = 2, MNG_AGENCY = 110 and MNG_AG_TYP = 2 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 12
- Local Other or Unknown 106
- Local Park 31
- Local Recreation Area 5
- Local Conservation Area 1
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 149
- Restricted Access 2
MNG_AG_TYP 1
- City Agency · 151 ✖
MNG_AGENCY 1
- Ventura, City of · 151 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-119.30083, 34.27437], [-119.30048, 34.27445], [-119.29837, 34.27477], [-119.29821, 34.27482], [-119.29805, 34.27491], [-119.2979, 34.27501], [-119.29779, 34.27512], [-119.29779, 34.27435], [-119.29933, 34.27392], [-119.30016, 34.27382], [-119.30083, 34.27383], [-119.30083, 34.27437]]]} | Open Access 1 | 742 | Surfer's Point | 30395 | 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 | 4.99 | Surfer's Point | None 29 | |||
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 | |||
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 | |||
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 | |||
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 | ||
12690 | 12690 | 12689 | {"type": "Polygon", "coordinates": [[[-119.29927, 34.28098], [-119.29918, 34.28154], [-119.29906, 34.28154], [-119.29914, 34.28097], [-119.29927, 34.28098]]]} | Open Access 1 | 46904 | Valdez Alley | 30407 | 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.178 | Valdez Alley | None 1103 | |||
12694 | 12694 | 12693 | {"type": "Polygon", "coordinates": [[[-119.29726, 34.27814], [-119.29629, 34.27815], [-119.29628, 34.2779], [-119.29654, 34.2779], [-119.29655, 34.27783], [-119.29717, 34.27783], [-119.29718, 34.27779], [-119.29726, 34.2778], [-119.29726, 34.27814]]]} | Open Access 1 | 46905 | San Miguel Chapel Site | 30408 | 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.74 | San Miguel Chapel Site | None 1105 | |||
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 | |
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 | |
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 | |
512 | 512 | 511 | {"type": "Polygon", "coordinates": [[[-119.29298, 34.27992], [-119.29265, 34.27992], [-119.29264, 34.27961], [-119.29298, 34.27961], [-119.29298, 34.27992]]]} | Open Access 1 | 1711 | California Street Mini-Park | 16728 | 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.257 | California Street Mini-Park | 0 | Local Park 2 | 4 | |
596 | 596 | 595 | {"type": "Polygon", "coordinates": [[[-119.23927, 34.26592], [-119.23888, 34.26618], [-119.23879, 34.26665], [-119.23808, 34.26692], [-119.23803, 34.26746], [-119.23773, 34.26775], [-119.23761, 34.268], [-119.23704, 34.26825], [-119.23703, 34.26869], [-119.23653, 34.26883], [-119.23637, 34.26939], [-119.23601, 34.26984], [-119.23512, 34.2705], [-119.23444, 34.27029], [-119.23381, 34.27064], [-119.23311, 34.26734], [-119.23398, 34.26691], [-119.23433, 34.26675], [-119.23497, 34.26652], [-119.23555, 34.26637], [-119.23675, 34.26615], [-119.23927, 34.26591], [-119.23927, 34.26592]]]} | Open Access 1 | 2031 | Camino Real Park | 16769 | 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 | 38.126 | Camino Real Park | 0 | Local Park 2 | 4 | |
1091 | 1091 | 1090 | {"type": "Polygon", "coordinates": [[[-119.17671, 34.2771], [-119.1762, 34.27741], [-119.17439, 34.27532], [-119.17438, 34.27529], [-119.17439, 34.27524], [-119.17474, 34.27494], [-119.17509, 34.27471], [-119.17648, 34.27632], [-119.17619, 34.27651], [-119.17671, 34.2771]]]} | Open Access 1 | 6500 | Chumash Park | 17246 | 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.054 | Chumash Park | 0 | Local Park 2 | 4 | |
1866 | 1866 | 1865 | {"type": "Polygon", "coordinates": [[[-119.29971, 34.28152], [-119.2996, 34.28215], [-119.2993, 34.28211], [-119.29919, 34.28195], [-119.29903, 34.28195], [-119.299, 34.28177], [-119.29904, 34.28154], [-119.29917, 34.28154], [-119.29919, 34.28146], [-119.29971, 34.28152]]]} | Open Access 1 | 14310 | Eastwood Park | 18404 | 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.917 | Eastwood Park | 0 | Local Park 2 | 4 | |
2036 | 2036 | 2035 | {"type": "Polygon", "coordinates": [[[-119.19348, 34.28277], [-119.19377, 34.28303], [-119.19397, 34.28324], [-119.19409, 34.28341], [-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.19184, 34.28331], [-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]]]} | Open Access 1 | 17076 | Juanamaria Park | 20513 | 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 | Juanamaria Park | 0 | Local Park 2 | 4 | |
2171 | 2171 | 2170 | {"type": "Polygon", "coordinates": [[[-119.16005, 34.28166], [-119.15737, 34.28294], [-119.15581, 34.28113], [-119.15703, 34.28038], [-119.15823, 34.27967], [-119.15829, 34.27965], [-119.15835, 34.27968], [-119.16005, 34.28166]]]} | Open Access 1 | 16247 | Fritz Huntsinger Youth Complex | 19129 | 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.356 | Fritz Huntsinger Youth Complex | 0 | Local Recreation Area 3 | 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 | |
2203 | 2203 | 2202 | {"type": "Polygon", "coordinates": [[[-119.23018, 34.29322], [-119.22765, 34.29719], [-119.22605, 34.29799], [-119.22162, 34.29234], [-119.22187, 34.29194], [-119.22332, 34.29111], [-119.2241, 34.29092], [-119.22457, 34.29065], [-119.22425, 34.28885], [-119.22478, 34.28695], [-119.22538, 34.28594], [-119.22601, 34.28494], [-119.22648, 34.2849], [-119.22778, 34.2847], [-119.22771, 34.28481], [-119.2276, 34.28491], [-119.22697, 34.28859], [-119.22753, 34.29109], [-119.22954, 34.29246], [-119.23018, 34.29322]]]} | Open Access 1 | 16487 | Arroyo Verde Park | 15634 | 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 | 129.193 | Arroyo Verde Park | 0 | Local Park 2 | 4 | |
2297 | 2297 | 2296 | {"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 | 16915 | Hobert Park | 20017 | 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.065 | Hobert Park | 0 | Local Park 2 | 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]);