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 126
- Los Angeles, City of 94
- Ventura, City of 93
- Long Beach, City of 54
- Roseville, City of 47
- Poway, City of 43
- San Jose, City of 30
- Irvine, City of 30
- Torrance, City of 29
- Davis, City of 25
- Encinitas, City of 23
- Stockton, City of 23
- California City, City of 23
- San Francisco, City and County of 22
- Santa Clarita, City of 21
- Murrieta, City of 21
- Rocklin, City of 21
- Napa, City of 20
- Santa Cruz, City of 19
- Glendale, City of 19
- Sacramento, City of 19
- Seaside, City of 17
- San Jacinto, City of 17
- San Luis Obispo, City of 16
- Azusa, City of 15
- Palmdale, City of 15
- Eureka, City of 15
- San Marcos, City of 14
- Manteca, City of 14
- Lompoc, City of 13
- …
DES_TP >30
- Local Park 743
- Local Recreation Area 519
- Local Other or Unknown 458
- Local Conservation Area 33
- National Monument or Landmark 5
- Local Historic or Cultural Area 3
- National Forest 1
- National Recreation Area 1
- Local Resource Management Area 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
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,675
- Restricted Access 180
- No Public Access 47
- Unknown Access 9
MNG_AG_TYP 1
- City Agency · 1,911 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13194 | 13194 | 13193 | {"type": "Polygon", "coordinates": [[[-121.53929, 36.84003], [-121.53858, 36.84054], [-121.5378, 36.8404], [-121.5373, 36.84034], [-121.53695, 36.84032], [-121.53817, 36.83949], [-121.53929, 36.84003]]]} | Open Access 1 | 35257 | Lang Street Park | 28553 | 1304 | San Juan Bautista, City of 856 | City 2 | City Agency 2 | http://www.san-juan-bautista.ca.us/ | City 2 | 1304 | San Juan Bautista, City of 834 | City 2 | City Agency 2 | San Benito 38 | 3.062 | Lang Street Park | 0 | Local Park 2 | 4 | |
13195 | 13195 | 13194 | {"type": "Polygon", "coordinates": [[[-117.19256, 32.86403], [-117.19256, 32.86403], [-117.19255, 32.8664], [-117.19248, 32.86635], [-117.19105, 32.86485], [-117.1908, 32.86416], [-117.19111, 32.86402], [-117.19256, 32.86403]]]} | Open Access 1 | 45213 | Pueblo Lands Open Space | 24025 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 6.523 | Pueblo Lands OS | 0 | Local Recreation Area 3 | 4 | |
13197 | 13197 | 13196 | {"type": "Polygon", "coordinates": [[[-122.00596, 37.00462], [-122.00509, 37.00463], [-122.00509, 37.00415], [-122.00596, 37.00415], [-122.00596, 37.00462]]]} | Open Access 1 | 35209 | Santa Cruz holding 5 | 28176 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.015 | Santa Cruz holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13199 | 13199 | 13198 | {"type": "Polygon", "coordinates": [[[-122.02701, 37.01206], [-122.02689, 37.01231], [-122.02679, 37.01235], [-122.02626, 37.01189], [-122.02641, 37.01177], [-122.02654, 37.01175], [-122.02663, 37.01179], [-122.02701, 37.01206]]]} | Open Access 1 | 35226 | Santa Cruz holding 13 | 28177 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.557 | Santa Cruz holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13200 | 13200 | 13199 | {"type": "Polygon", "coordinates": [[[-120.14624, 34.60823], [-120.14615, 34.60863], [-120.14538, 34.60859], [-120.14546, 34.60827], [-120.14599, 34.60822], [-120.14624, 34.60823]]]} | Open Access 1 | 35228 | Solvang holding 1 | 25601 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 0.735 | Solvang holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13202 | 13202 | 13201 | {"type": "Polygon", "coordinates": [[[-121.8188, 36.64408], [-121.81752, 36.645], [-121.81716, 36.64519], [-121.8167, 36.64538], [-121.81614, 36.64577], [-121.8157, 36.64624], [-121.81464, 36.64706], [-121.81306, 36.64751], [-121.81209, 36.64756], [-121.81208, 36.64729], [-121.81212, 36.64711], [-121.8122, 36.64695], [-121.81231, 36.64679], [-121.81314, 36.64588], [-121.81322, 36.64576], [-121.81327, 36.64563], [-121.81328, 36.64549], [-121.81331, 36.64427], [-121.81329, 36.64421], [-121.81326, 36.64417], [-121.81319, 36.64414], [-121.81313, 36.64413], [-121.81314, 36.64395], [-121.81695, 36.64406], [-121.8188, 36.64408]]]} | Open Access 1 | 35258 | Seaside holding 9 | 25265 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 29.165 | Seaside holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13206 | 13206 | 13205 | {"type": "Polygon", "coordinates": [[[-122.07216, 37.00872], [-122.07141, 37.00885], [-122.07125, 37.00838], [-122.07203, 37.00825], [-122.07216, 37.00872]]]} | Open Access 1 | 35234 | Santa Cruz holding 7 | 28173 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.932 | Santa Cruz holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13207 | 13207 | 13206 | {"type": "Polygon", "coordinates": [[[-121.97361, 36.96111], [-121.97328, 36.96111], [-121.97328, 36.96082], [-121.97361, 36.96083], [-121.97361, 36.96111]]]} | Open Access 1 | 35236 | Santa Cruz holding 8 | 25078 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.232 | Santa Cruz holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13208 | 13208 | 13207 | {"type": "Polygon", "coordinates": [[[-120.45602, 34.63102], [-120.45601, 34.6313], [-120.45541, 34.63129], [-120.45542, 34.63102], [-120.45602, 34.63102]]]} | Open Access 1 | 35243 | Lompoc holding 3 | 21429 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.414 | Lompoc holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13209 | 13209 | 13208 | {"type": "Polygon", "coordinates": [[[-121.80773, 36.57658], [-121.80773, 36.58183], [-121.80616, 36.58125], [-121.80561, 36.58087], [-121.80526, 36.58066], [-121.80482, 36.58044], [-121.80434, 36.58027], [-121.8037, 36.58007], [-121.80214, 36.57966], [-121.80143, 36.57949], [-121.80018, 36.57927], [-121.7979, 36.5789], [-121.79696, 36.57877], [-121.79602, 36.57867], [-121.79506, 36.57859], [-121.7945, 36.57856], [-121.7935, 36.57873], [-121.79326, 36.57873], [-121.79638, 36.57817], [-121.79781, 36.57789], [-121.80394, 36.5768], [-121.80635, 36.57633], [-121.80665, 36.57631], [-121.80695, 36.57632], [-121.80735, 36.57641], [-121.8076, 36.57651], [-121.80773, 36.57658]]]} | Open Access 1 | 35245 | Monterey holding 2 | 22422 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 77.51 | Monterey holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13210 | 13210 | 13209 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63198], [-120.45534, 34.63209], [-120.45504, 34.63209], [-120.45504, 34.63198], [-120.45534, 34.63198]]]} | Open Access 1 | 35246 | Lompoc holding 4 | 21430 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.083 | Lompoc holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13211 | 13211 | 13210 | {"type": "Polygon", "coordinates": [[[-120.65903, 35.28087], [-120.65874, 35.28105], [-120.65843, 35.2807], [-120.65888, 35.2807], [-120.65903, 35.28087]]]} | Open Access 1 | 35247 | Cheng Park | 28552 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.288 | Cheng 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 | |
13213 | 13213 | 13212 | {"type": "Polygon", "coordinates": [[[-120.45331, 34.65345], [-120.45328, 34.65553], [-120.4529, 34.65553], [-120.45289, 34.65395], [-120.45288, 34.65374], [-120.45277, 34.65345], [-120.45331, 34.65345]]]} | Open Access 1 | 35251 | Lompoc holding 5 | 21431 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 2.15 | Lompoc holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13214 | 13214 | 13213 | {"type": "Polygon", "coordinates": [[[-121.85017, 36.60253], [-121.84983, 36.60253], [-121.84975, 36.60252], [-121.85014, 36.60232], [-121.85018, 36.60235], [-121.85017, 36.60253]]]} | Open Access 1 | 35252 | Seaside holding 8 | 25264 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.116 | Seaside holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13215 | 13215 | 13214 | {"type": "Polygon", "coordinates": [[[-121.8525, 36.60939], [-121.85222, 36.60957], [-121.85222, 36.60957], [-121.85222, 36.60939], [-121.8525, 36.60939]]]} | Open Access 1 | 35253 | Seaside holding 5 | 25261 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.062 | Seaside holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13216 | 13216 | 13215 | {"type": "Polygon", "coordinates": [[[-120.41587, 34.97214], [-120.4158, 34.97224], [-120.41559, 34.97213], [-120.41511, 34.97201], [-120.41521, 34.97161], [-120.41526, 34.97159], [-120.41582, 34.9716], [-120.41587, 34.97214]]]} | Open Access 1 | 35255 | Santa Maria holding 7 | 25111 | 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 | 0.886 | Santa Maria holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13217 | 13217 | 13216 | {"type": "Polygon", "coordinates": [[[-121.8153, 36.65269], [-121.81444, 36.653], [-121.8144, 36.65172], [-121.8142, 36.65111], [-121.81379, 36.65064], [-121.8129, 36.64978], [-121.81267, 36.64929], [-121.81224, 36.6483], [-121.81216, 36.64786], [-121.8134, 36.64778], [-121.81395, 36.64798], [-121.81428, 36.64829], [-121.81433, 36.64865], [-121.81434, 36.64968], [-121.81445, 36.65052], [-121.81473, 36.65154], [-121.81503, 36.65218], [-121.8153, 36.65269]]]} | Open Access 1 | 35259 | Seaside holding 10 | 25252 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 13.836 | Seaside holding 10 | 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 |
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]);