units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 201
- California Department of Fish and Wildlife 185
- San Diego, City of 125
- Mountains Recreation and Conservation Authority 112
- Los Angeles, City of 94
- Ventura, City of 93
- East Bay Regional Park District 78
- Los Angeles, County of 58
- United States Fish and Wildlife Service 57
- California State Lands Commission 55
- Long Beach, City of 54
- Roseville, City of 47
- Poway, City of 43
- Butte, County of 43
- United States Forest Service 37
- Midpeninsula Regional Open Space District 35
- Orange, County of 31
- El Dorado, County of 31
- San Jose, City of 30
- San Diego, County of 30
- Irvine, City of 30
- Lake, County of 30
- Torrance, City of 29
- Conejo Open Space Conservation Agency 29
- Yuba County Water Agency 28
- United States National Park Service 26
- Sunrise Recreation and Park District 26
- Valley-Wide Recreation and Park District 25
- Davis, City of 25
- Fresno Metropolitan Flood Control District 25
- …
DES_TP >30
- Local Park 1,111
- Local Recreation Area 744
- Local Other or Unknown 645
- State Conservation Area 180
- Local Conservation Area 173
- State Park 123
- Private Conservation 123
- Private Recreation or Education 119
- State Resource Management Area 65
- State Recreation Area 61
- National Wildlife Refuge 53
- National Forest 36
- State Historic or Cultural Area 31
- Recreation Management Area 18
- National Monument or Landmark 18
- State Other or Unknown 15
- National Park 11
- National Recreation Area 9
- Conservation Area 8
- Private Other or Unknown 8
- National Public Lands 6
- Local Historic or Cultural Area 5
- Private Agricultural 5
- Federal Other or Unknown 4
- Historic or Cultural Area 3
- Resource Management Area 2
- Wilderness Area 1
- Local Resource Management Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
MNG_AG_TYP 28
- City Agency 1,899
- State Agency 496
- County Agency 336
- Recreation/Parks District 313
- Federal Agency 159
- Open Space District 150
- Non Profit - Land Trust 107
- Home Owners Association 94
- County Agency - Parks 63
- Water District 59
- Non Profit - Conservation 55
- Community Services District 39
- Flood District 30
- Non Profit - Other 9
- Irrigation District 7
- Commercial 6
- School District 6
- County Agency - Other 4
- Special District - Other 4
- Transportation Agency 4
- Cemetery District 3
- Joint Powers Authority 3
- Other 3
- Port/Harbor District 2
- Sanitation District 2
- Conservation District 2
- Mitigation Bank 1
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 3,041
- Restricted Access 455
- No Public Access 218
- Unknown Access 143
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
13225 | 13225 | 13224 | {"type": "Polygon", "coordinates": [[[-117.12022, 33.25594], [-117.11798, 33.25608], [-117.11133, 33.25648], [-117.11148, 33.25634], [-117.11161, 33.25629], [-117.11177, 33.25622], [-117.11191, 33.25612], [-117.11201, 33.25602], [-117.11211, 33.256], [-117.11224, 33.25577], [-117.11221, 33.25567], [-117.11279, 33.25455], [-117.11293, 33.25435], [-117.11314, 33.25414], [-117.11321, 33.25417], [-117.11343, 33.25402], [-117.11339, 33.25397], [-117.11357, 33.25388], [-117.11582, 33.25311], [-117.1161, 33.25299], [-117.11637, 33.25284], [-117.12005, 33.2528], [-117.12022, 33.25594]]]} | No Public Access 3 | 45242 | Old Castle Mitigation Area | 23082 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 58.565 | Old Castle Mitigation Area | 0 | Local Other or Unknown 14 | 4 | |
13226 | 13226 | 13225 | {"type": "Polygon", "coordinates": [[[-117.23056, 33.28559], [-117.23055, 33.28926], [-117.23037, 33.28927], [-117.23036, 33.28955], [-117.22971, 33.28951], [-117.22837, 33.28938], [-117.22838, 33.28563], [-117.23056, 33.28559]]]} | Unknown Access 4 | 45245 | Lueng/Lowe TransNet Environmental Mitigation | 21587 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 21.401 | Lueng/Lowe TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
13227 | 13227 | 13226 | {"type": "Polygon", "coordinates": [[[-120.45638, 34.6553], [-120.45638, 34.65537], [-120.45512, 34.65556], [-120.45512, 34.65548], [-120.45638, 34.6553]]]} | Open Access 1 | 35268 | Lompoc holding 6 | 21432 | 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.235 | Lompoc holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13228 | 13228 | 13227 | {"type": "Polygon", "coordinates": [[[-119.1911, 34.28234], [-119.19107, 34.28236], [-119.19083, 34.28244], [-119.19075, 34.28238], [-119.19073, 34.28229], [-119.19076, 34.28229], [-119.19078, 34.28238], [-119.19083, 34.28242], [-119.1911, 34.28234]]]} | Open Access 1 | 35269 | Ventura holding 60 | 26941 | 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.022 | Ventura holding 60 | 0 | Local Other or Unknown 14 | 4 | |
13229 | 13229 | 13228 | {"type": "Polygon", "coordinates": [[[-119.87679, 34.42375], [-119.87675, 34.42404], [-119.87631, 34.42397], [-119.87651, 34.42342], [-119.87657, 34.42341], [-119.8767, 34.42375], [-119.87679, 34.42375]]]} | Open Access 1 | 35271 | Goleta holding 1 | 19382 | 1121 | Goleta, City of 179 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | Santa Barbara 7 | 0.437 | Goleta holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13230 | 13230 | 13229 | {"type": "Polygon", "coordinates": [[[-122.01894, 36.98092], [-122.01894, 36.98092], [-122.01864, 36.98102], [-122.01878, 36.98082], [-122.01886, 36.98067], [-122.01892, 36.98061], [-122.01894, 36.98092]]]} | Open Access 1 | 35358 | Santa Cruz holding 3 | 25073 | 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.121 | Santa Cruz holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13231 | 13231 | 13230 | {"type": "Polygon", "coordinates": [[[-119.28934, 34.29977], [-119.28906, 34.30067], [-119.2889, 34.30063], [-119.28891, 34.30058], [-119.28879, 34.30056], [-119.28877, 34.30057], [-119.28874, 34.30065], [-119.28867, 34.30065], [-119.28865, 34.30073], [-119.2887, 34.30075], [-119.2887, 34.30078], [-119.28854, 34.30075], [-119.28884, 34.30039], [-119.28897, 34.30023], [-119.28911, 34.29997], [-119.28921, 34.29974], [-119.28934, 34.29977]]]} | Open Access 1 | 35274 | Ventura holding 64 | 26945 | 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.564 | Ventura holding 64 | 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]);