units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 496
- Los Angeles, City of 485
- San Jose, City of 249
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 121
- Irvine, City of 101
- Modesto, City of 85
- Fresno, City of 81
- Santa Rosa, City of 81
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 70
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 63
- Newport Beach, City of 63
- Clovis, City of 62
- Santa Barbara, City of 61
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,343
- Local Recreation Area 1,422
- Local Other or Unknown 661
- Local Conservation Area 142
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,761
- Restricted Access 360
- No Public Access 206
- Unknown Access 28
MNG_AG_TYP 1
- City Agency · 10,355 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
220 | 220 | 219 | {"type": "Polygon", "coordinates": [[[-116.96866, 32.783], [-116.96865, 32.78381], [-116.96863, 32.78384], [-116.96857, 32.78386], [-116.96712, 32.78386], [-116.96676, 32.78386], [-116.96671, 32.78385], [-116.9667, 32.78382], [-116.96669, 32.783], [-116.96866, 32.783]]]} | Open Access 1 | 717 | Renette Park | 24293 | 1092 | El Cajon, City of 73 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html | City 2 | 1092 | El Cajon, City of 71 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/your-government/departments/recreation/parks-playgrounds-sports-fields | San Diego 4 | 4.32 | Renette Park | 0 | Local Park 2 | 4 |
225 | 225 | 224 | {"type": "Polygon", "coordinates": [[[-117.64157, 33.50229], [-117.64232, 33.50243], [-117.64251, 33.5025], [-117.64268, 33.5026], [-117.64283, 33.50272], [-117.64301, 33.50296], [-117.64302, 33.503], [-117.64253, 33.50326], [-117.64249, 33.50326], [-117.64136, 33.5029], [-117.6415, 33.50259], [-117.64157, 33.50229]]]} | Open Access 1 | 612 | Four Oaks Park | 19025 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 2.499 | Four Oaks Park | 0 | Local Park 2 | 4 | |
226 | 226 | 225 | {"type": "MultiPolygon", "coordinates": [[[[-117.25646, 32.95494], [-117.25611, 32.95532], [-117.25612, 32.9556], [-117.25635, 32.95602], [-117.25656, 32.95614], [-117.25661, 32.95622], [-117.25649, 32.95681], [-117.25649, 32.95703], [-117.25642, 32.95756], [-117.25637, 32.9576], [-117.25631, 32.95761], [-117.25624, 32.95758], [-117.25612, 32.95735], [-117.25589, 32.95707], [-117.25589, 32.95454], [-117.25617, 32.95483], [-117.25628, 32.95489], [-117.25646, 32.95494]]], [[[-117.25742, 32.95748], [-117.2568, 32.95767], [-117.2568, 32.95816], [-117.25623, 32.95798], [-117.25632, 32.95772], [-117.25638, 32.95772], [-117.25644, 32.95769], [-117.2565, 32.95764], [-117.25655, 32.95758], [-117.25662, 32.95702], [-117.25662, 32.95682], [-117.25675, 32.95624], [-117.25682, 32.9562], [-117.25709, 32.95615], [-117.25728, 32.95715], [-117.25742, 32.95748]]], [[[-117.25711, 32.95577], [-117.25708, 32.95592], [-117.2571, 32.95609], [-117.25674, 32.95617], [-117.25665, 32.95606], [-117.25646, 32.95595], [-117.25624, 32.95557], [-117.25624, 32.95549], [-117.25711, 32.95577]]]]} | Open Access 1 | 613 | Del Mar Public Parkland | 18036 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | San Diego 4 | 6.921 | Del Mar Public Parkland | 0 | Local Park 2 | 4 | |
229 | 229 | 228 | {"type": "Polygon", "coordinates": [[[-119.7883, 36.76862], [-119.78615, 36.76863], [-119.78615, 36.76692], [-119.78829, 36.76692], [-119.7883, 36.76862]]]} | Open Access 1 | 622 | Euless Park | 18749 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.952 | Euless Park | 0 | Local Park 2 | 4 | |
230 | 230 | 229 | {"type": "Polygon", "coordinates": [[[-117.2677, 32.95839], [-117.26772, 32.95862], [-117.26771, 32.9591], [-117.26765, 32.95946], [-117.26756, 32.95978], [-117.2675, 32.95994], [-117.26699, 32.95859], [-117.2677, 32.95839]]]} | Open Access 1 | 623 | Seagrove Park | 25239 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.delmar.ca.us/Facilities/Facility/Details/Seagrove-Park-2 | San Diego 4 | 1.613 | Seagrove Park | 0 | Local Park 2 | 4 |
231 | 231 | 230 | {"type": "Polygon", "coordinates": [[[-118.3823, 33.98709], [-118.38228, 33.98732], [-118.38226, 33.98736], [-118.38222, 33.98737], [-118.38191, 33.98738], [-118.3823, 33.98709]]]} | Open Access 1 | 625 | Fox Hills Parkette | 19032 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.13 | Fox Hills Parkette | 0 | Local Park 2 | 4 | |
232 | 232 | 231 | {"type": "Polygon", "coordinates": [[[-115.55924, 32.80381], [-115.55717, 32.80381], [-115.55717, 32.80208], [-115.5575, 32.80209], [-115.5578, 32.80221], [-115.5592, 32.8022], [-115.55924, 32.80381]]]} | Open Access 1 | 627 | Fraizer Field | 19039 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 8.576 | Fraizer Field | 0 | Local Recreation Area 3 | 4 | |
233 | 233 | 232 | {"type": "Polygon", "coordinates": [[[-119.21449, 34.19396], [-119.21253, 34.19394], [-119.21254, 34.19326], [-119.2126, 34.19305], [-119.21268, 34.19293], [-119.21278, 34.19282], [-119.21347, 34.19226], [-119.21353, 34.19225], [-119.21427, 34.19287], [-119.21435, 34.19296], [-119.21442, 34.19307], [-119.21447, 34.19318], [-119.2145, 34.1933], [-119.21449, 34.19396]]]} | Open Access 1 | 751 | Seaview Park | 25272 | 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 | 6.433 | Seaview Park | 0 | Local Park 2 | 4 | |
235 | 235 | 234 | {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} | No Public Access 3 | 684 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 4.055 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
237 | 237 | 236 | {"type": "Polygon", "coordinates": [[[-119.23698, 34.4506], [-119.23695, 34.45232], [-119.23694, 34.45239], [-119.23691, 34.45246], [-119.23683, 34.45254], [-119.23606, 34.45308], [-119.23529, 34.45315], [-119.23533, 34.45069], [-119.23698, 34.4506]]]} | Open Access 1 | 638 | Sarzotti Park | 25162 | 1231 | Ojai, City of 97 | City 2 | City Agency 2 | http://www.ojairec.com/ | City 2 | 1231 | Ojai, City of 95 | City 2 | City Agency 2 | Ventura 8 | 9.473 | Sarzotti Park | 0 | Local Park 2 | 4 | |
238 | 238 | 237 | {"type": "Polygon", "coordinates": [[[-122.30466, 37.56871], [-122.3034, 37.56958], [-122.30328, 37.56965], [-122.30262, 37.56848], [-122.30364, 37.56777], [-122.30466, 37.56871]]]} | Open Access 1 | 771 | Shoreview Park | 25430 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 4.751 | Shoreview Park | 1961 | Local Park 2 | 4 | |
240 | 240 | 239 | {"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]} | Open Access 1 | 645 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.034 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
242 | 242 | 241 | {"type": "Polygon", "coordinates": [[[-119.80436, 36.7161], [-119.80433, 36.71604], [-119.80427, 36.71602], [-119.8021, 36.71603], [-119.8021, 36.71598], [-119.80207, 36.71592], [-119.80202, 36.71588], [-119.80194, 36.71586], [-119.8021, 36.71586], [-119.8021, 36.71486], [-119.80278, 36.71485], [-119.80278, 36.71423], [-119.80426, 36.71423], [-119.80426, 36.71586], [-119.80429, 36.71594], [-119.80436, 36.716], [-119.80436, 36.7161]]]} | Open Access 1 | 787 | Hinton Park | 20004 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.498 | Hinton Park | 0 | Local Park 2 | 4 | |
244 | 244 | 243 | {"type": "Polygon", "coordinates": [[[-117.19007, 34.07019], [-117.19006, 34.0736], [-117.18985, 34.0736], [-117.18986, 34.07019], [-117.19007, 34.07019]]]} | Open Access 1 | 47336 | Lugonia Garden | 31047 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/recreation/gardens | San Bernardino 22 | 1.811 | Lugonia Garden | 0 | Local Park 2 | 4 |
245 | 245 | 244 | {"type": "Polygon", "coordinates": [[[-117.17915, 34.07497], [-117.17889, 34.07497], [-117.17889, 34.07456], [-117.17873, 34.07455], [-117.17877, 34.07447], [-117.17915, 34.07447], [-117.17915, 34.07497]]]} | Open Access 1 | 47337 | Clement Garden | 31048 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/recreation/gardens | San Bernardino 22 | 0.356 | Clement Garden | 0 | Local Park 2 | 4 |
246 | 246 | 245 | {"type": "Polygon", "coordinates": [[[-117.14865, 34.08097], [-117.14842, 34.08086], [-117.14818, 34.0805], [-117.14822, 34.0787], [-117.14826, 34.07852], [-117.14847, 34.07818], [-117.14864, 34.07795], [-117.14865, 34.08097]]]} | Open Access 1 | 47338 | Granite Citrus Grove | 31049 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 2.837 | Granite Citrus Grove | 0 | Local Park 2 | 4 | |
247 | 247 | 246 | {"type": "MultiPolygon", "coordinates": [[[[-117.19099, 34.07975], [-117.18687, 34.07973], [-117.18688, 34.07746], [-117.18692, 34.07744], [-117.18906, 34.07745], [-117.18906, 34.0777], [-117.18766, 34.0777], [-117.18766, 34.07866], [-117.18812, 34.07867], [-117.18811, 34.07919], [-117.18814, 34.07928], [-117.18819, 34.07936], [-117.18831, 34.07946], [-117.18846, 34.0795], [-117.18863, 34.0795], [-117.18878, 34.07944], [-117.18886, 34.07937], [-117.18895, 34.07925], [-117.18895, 34.07902], [-117.18912, 34.07902], [-117.18912, 34.07879], [-117.19053, 34.0788], [-117.19077, 34.0789], [-117.19099, 34.07891], [-117.19099, 34.07975]]], [[[-117.19099, 34.07883], [-117.19081, 34.07881], [-117.1906, 34.07871], [-117.19051, 34.07871], [-117.19051, 34.07868], [-117.19099, 34.07868], [-117.19099, 34.07883]]]]} | Open Access 1 | 47339 | Texas Citrus Grove | 31050 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 12.156 | Texas Citrus Grove | 0 | Local Park 2 | 4 | |
248 | 248 | 247 | {"type": "Polygon", "coordinates": [[[-120.43425, 34.94713], [-120.43423, 34.94857], [-120.43412, 34.94857], [-120.43412, 34.94888], [-120.43362, 34.94888], [-120.43362, 34.94858], [-120.4336, 34.94857], [-120.4336, 34.94842], [-120.43368, 34.94841], [-120.43368, 34.94824], [-120.43331, 34.94824], [-120.4333, 34.94838], [-120.43282, 34.94838], [-120.43281, 34.94836], [-120.43157, 34.94835], [-120.43157, 34.94625], [-120.43274, 34.94627], [-120.43274, 34.94713], [-120.43425, 34.94713]]]} | Open Access 1 | 811 | Simas Basin Park | 25503 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 11.392 | Simas Basin 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]);