units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
MNG_AGENCY >30
- San Diego, City of 503
- Los Angeles, City of 432
- California Department of Parks and Recreation 354
- California Department of Fish and Wildlife 293
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 216
- Mountains Recreation and Conservation Authority 191
- Los Angeles, County of 153
- Ventura, City of 149
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- United States Forest Service 109
- United States Bureau of Land Management 105
- Santa Barbara, County of 105
- San Diego, County of 105
- East Bay Regional Park District 101
- Irvine, City of 100
- Consumnes Community Services District 94
- Fresno, City of 92
- Orange, County of 88
- United States National Park Service 80
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Stockton, City of 77
- Huntington Beach, City of 76
- California State Lands Commission 75
- Tracy, City of 73
- Santa Rosa, City of 72
- …
ACCESS_TYP 1
- Open Access · 14,510 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15316 | 15316 | 15315 | {"type": "Polygon", "coordinates": [[[-118.3888, 33.86582], [-118.38873, 33.86578], [-118.38873, 33.86578], [-118.38878, 33.86576], [-118.3888, 33.86582]]]} | Open Access 1 | 46498 | Scout Park | 29783 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.004 | Scout Park | 0 | Local Park 2 | 4 | |
4443 | 4443 | 4442 | {"type": "Polygon", "coordinates": [[[-118.38594, 33.85816], [-118.38592, 33.85821], [-118.38575, 33.85816], [-118.38594, 33.85816], [-118.38594, 33.85816]]]} | Open Access 1 | 46502 | Third Street & Prospect Avenue Park | 29786 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.012 | Third Street & Prospect Avenue Park | 0 | Local Park 2 | 4 | |
461 | 461 | 460 | {"type": "Polygon", "coordinates": [[[-117.87133, 33.59796], [-117.87133, 33.59796], [-117.87119, 33.59799], [-117.8713, 33.59788], [-117.87133, 33.59796]]]} | Open Access 1 | 47411 | Corona del Mar Pocket Park | 31210 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.015 | Corona del Mar PP | 0 | Local Park 2 | 4 | |
5711 | 5711 | 5710 | {"type": "Polygon", "coordinates": [[[-118.46109, 33.99128], [-118.46109, 33.99132], [-118.46107, 33.99134], [-118.46103, 33.99134], [-118.461, 33.99132], [-118.461, 33.99129], [-118.46103, 33.99127], [-118.46106, 33.99127], [-118.46109, 33.99128]]]} | Open Access 1 | 45791 | Crescent Place Triangle | 28810 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.015 | Crescent Place Triangle | 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 | |
1274 | 1274 | 1273 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | 7201 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.02 | Compton Creek & Bike Path | 0 | Local Recreation Area 3 | 4 | |
7492 | 7492 | 7491 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | Open Access 1 | 48943 | Triangle Park | 33659 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.02 | Triangle Park | 0 | Local Park 2 | 4 | |
13576 | 13576 | 13575 | {"type": "Polygon", "coordinates": [[[-118.88253, 34.28657], [-118.88237, 34.28657], [-118.88234, 34.28652], [-118.88242, 34.28649], [-118.88245, 34.28654], [-118.88247, 34.28653], [-118.88253, 34.28657]]]} | Open Access 1 | 35905 | Moorpark holding 2 | 22464 | 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 | 0.02 | Moorpark holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13317 | 13317 | 13316 | {"type": "Polygon", "coordinates": [[[-119.19475, 34.28398], [-119.19474, 34.28399], [-119.19465, 34.28374], [-119.19455, 34.28353], [-119.19455, 34.2835], [-119.19456, 34.28346], [-119.19456, 34.2835], [-119.19469, 34.28379], [-119.19475, 34.28398]]]} | Open Access 1 | 35384 | Ventura holding 22 | 26899 | 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.021 | Ventura holding 22 | 0 | Local Other or Unknown 14 | 4 | |
5027 | 5027 | 5026 | {"type": "Polygon", "coordinates": [[[-119.80571, 36.72831], [-119.8057, 36.72842], [-119.80555, 36.72842], [-119.80571, 36.72831], [-119.80571, 36.72831]]]} | Open Access 1 | 47319 | Merced and Pickford Pocket Park | 31025 | 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 | 0.022 | Merced and Pickford PP | 0 | Local Park 2 | 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 | |
13346 | 13346 | 13345 | {"type": "Polygon", "coordinates": [[[-121.82508, 36.6128], [-121.82474, 36.61287], [-121.82474, 36.61287], [-121.82474, 36.61284], [-121.82507, 36.61277], [-121.82508, 36.6128]]]} | Open Access 1 | 35425 | Seaside holding 7 | 25263 | 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.023 | Seaside holding 7 | 0 | Local Other or Unknown 14 | 4 | |
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.025 | Pleasant Valley Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
13754 | 13754 | 13753 | {"type": "Polygon", "coordinates": [[[-122.87408, 39.00329], [-122.87407, 39.0034], [-122.87395, 39.0034], [-122.874, 39.00329], [-122.87408, 39.00329]]]} | Open Access 1 | 36266 | Lake holding 44 | 20933 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.025 | Lake holding 44 | 0 | Local Other or Unknown 14 | 4 | |
13321 | 13321 | 13320 | {"type": "Polygon", "coordinates": [[[-119.17309, 34.26527], [-119.17306, 34.26529], [-119.17283, 34.26503], [-119.17286, 34.26501], [-119.17309, 34.26527]]]} | Open Access 1 | 35388 | Ventura holding 20 | 26897 | 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.027 | Ventura holding 20 | 0 | Local Other or Unknown 14 | 4 | |
15001 | 15001 | 15000 | {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} | Open Access 1 | 45786 | Amoroso Triangle | 28805 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.027 | Amoroso Triangle | 0 | Local Other or Unknown 14 | 4 | |
15056 | 15056 | 15055 | {"type": "Polygon", "coordinates": [[[-118.46102, 33.99278], [-118.46095, 33.99287], [-118.46087, 33.99283], [-118.46093, 33.99274], [-118.46102, 33.99278]]]} | Open Access 1 | 45814 | Nowita Triangle | 28834 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.027 | Nowita Triangle | 0 | Local Other or Unknown 14 | 4 | |
15921 | 15921 | 15920 | {"type": "Polygon", "coordinates": [[[-122.34943, 37.42376], [-122.34901, 37.4238], [-122.34867, 37.42379], [-122.34867, 37.42379], [-122.34943, 37.42376]]]} | Open Access 1 | 17888 | Purisima Creek Redwoods Open Space Preserve | 6528 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_purisima.asp | San Mateo 15 | 0.029 | Purisima Creek Redwoods OSP | 1982 | Local Conservation Area 4 | 2 |
13625 | 13625 | 13624 | {"type": "Polygon", "coordinates": [[[-121.53081, 39.5272], [-121.53065, 39.5272], [-121.53066, 39.52703], [-121.53072, 39.5271], [-121.53081, 39.5272]]]} | Open Access 1 | 35971 | Butte holding 35 | 16579 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.031 | Butte holding 35 | 0 | Local Other or Unknown 14 | 4 | |
5944 | 5944 | 5943 | {"type": "Polygon", "coordinates": [[[-119.74575, 36.73906], [-119.74575, 36.73914], [-119.74558, 36.73914], [-119.74558, 36.73906], [-119.74575, 36.73906]]]} | Open Access 1 | 47318 | Maple and Blach Pocket Park | 31024 | 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 | 0.032 | Maple and Blach PP | 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]);