units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,198 rows where AGNCY_LEV = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB
MNG_AGENCY >30
- California Department of Fish and Wildlife 424
- California Department of Parks and Recreation 346
- California State Lands Commission 86
- Mountains Recreation and Conservation Authority 56
- University of California 54
- Other State 43
- California Department of Transportation 27
- East Bay Regional Park District 21
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 18
- California Department of General Services 14
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- United States Fish and Wildlife Service 3
- Los Angeles - Department of Parks and Recreation, County of 3
- San Diego State University 3
- Los Angeles County Department of Beaches and Harbors, County of 3
- San Diego, City of 2
- Los Angeles, County of 2
- San Luis Obispo, City of 2
- Encinitas, City of 2
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Joaquin River Parkway and Conservation Trust 2
- Tahoe City Public Utilities District 2
- Santa Barbara Trust for Historic Preservation 2
- California State University 2
- California Tahoe Conservancy 2
- …
DES_TP >30
- State Conservation Area 356
- State Park 198
- State Resource Management Area 159
- State Recreation Area 127
- State Other or Unknown 70
- State Historic or Cultural Area 61
- Local Park 36
- Local Other or Unknown 21
- Local Recreation Area 11
- Local Conservation Area 5
- National Wildlife Refuge 4
- National Monument or Landmark 2
- State Wilderness 2
- 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
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 869
- Restricted Access 145
- No Public Access 144
- Unknown Access 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4761 | 4761 | 4760 | {"type": "Polygon", "coordinates": [[[-118.63806, 34.24154], [-118.63783, 34.24155], [-118.63783, 34.24148], [-118.63804, 34.24148], [-118.63806, 34.24154]]]} | Unknown Access 4 | 46669 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Ventura 8 | 0.038 | 0 | Local Other or Unknown 14 | 4 | ||
4625 | 4625 | 4624 | {"type": "Polygon", "coordinates": [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]]} | No Public Access 3 | 36253 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.081 | 0 | State Other or Unknown 104 | 4 | ||
7138 | 7138 | 7137 | {"type": "Polygon", "coordinates": [[[-118.24127, 33.93867], [-118.24126, 33.93886], [-118.24082, 33.93867], [-118.24091, 33.93867], [-118.24127, 33.93867]]]} | Open Access 1 | 6221 | Watts Towers of Simon Rodia State Historic Park | 30713 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.109 | Watts Towers of Simon Rodia SHP | 1978 | None 584 | ||
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]]} | No Public Access 3 | 36169 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.134 | 0 | State Other or Unknown 104 | 4 | ||
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
14451 | 14451 | 14450 | {"type": "Polygon", "coordinates": [[[-121.47196, 38.57297], [-121.4719, 38.5731], [-121.47185, 38.57309], [-121.47183, 38.57313], [-121.47145, 38.57303], [-121.4715, 38.57291], [-121.47179, 38.57299], [-121.47182, 38.57294], [-121.47196, 38.57297]]]} | Open Access 1 | 47058 | State Indian Museum State Historic Park | 30709 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=486 | Sacramento 41 | 0.153 | State Indian Museum SHP | 1941 | State Historic or Cultural Area 132 | 4 |
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 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 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
7900 | 7900 | 7899 | {"type": "Polygon", "coordinates": [[[-118.59825, 34.09687], [-118.59802, 34.09694], [-118.59782, 34.09671], [-118.59812, 34.09662], [-118.59818, 34.09676], [-118.59825, 34.09687]]]} | Open Access 1 | 12626 | Santa Monica Mountains Conservancy Open Space | 25119 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 0.187 | Santa Monica Mtns. Conservancy OS | 0 | State Recreation Area 39 | 4 | |
15360 | 15360 | 15359 | {"type": "Polygon", "coordinates": [[[-118.08168, 34.07278], [-118.08143, 34.0728], [-118.08143, 34.07246], [-118.08165, 34.07245], [-118.08168, 34.07278]]]} | Open Access 1 | 46551 | Olney Park | 29847 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.199 | Olney Park | 0 | Local Park 2 | 4 | |
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.203 | Real Estate Services Division | None 6 | |||
16255 | 16255 | 16254 | {"type": "Polygon", "coordinates": [[[-118.43531, 34.11052], [-118.4348, 34.11052], [-118.43482, 34.11034], [-118.43522, 34.11034], [-118.43531, 34.11052]]]} | Open Access 1 | 46496 | Benedict Canyon Open Space | 16009 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.203 | Benedict Canyon OS | 0 | Local Recreation Area 3 | 4 | |
13066 | 13066 | 13065 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | 34939 | Lake Del Valle SRA | 1594 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.parks.ca.gov/?page_id=537 | Alameda 17 | 0.204 | Lake Del Valle SRA | 2000 | None 1132 | |
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.21 | 575 Third St | None 604 | |||
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
4682 | 4682 | 4681 | {"type": "Polygon", "coordinates": [[[-121.68569, 36.44484], [-121.68518, 36.44573], [-121.68502, 36.44565], [-121.68518, 36.44552], [-121.68529, 36.44539], [-121.68537, 36.44527], [-121.68545, 36.44508], [-121.6855, 36.44499], [-121.68558, 36.44491], [-121.68569, 36.44484]]]} | Open Access 1 | 43073 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 0.221 | 0 | State Other or Unknown 104 | 4 | |||
10562 | 10562 | 10561 | {"type": "MultiPolygon", "coordinates": [[[[-122.51916, 37.53641], [-122.51915, 37.53651], [-122.51888, 37.5365], [-122.51888, 37.53641], [-122.51916, 37.53641]]], [[[-122.51937, 37.53613], [-122.51935, 37.53634], [-122.51927, 37.53634], [-122.51926, 37.53641], [-122.51918, 37.53641], [-122.51918, 37.53635], [-122.5191, 37.53634], [-122.5191, 37.53611], [-122.5192, 37.53612], [-122.51922, 37.53605], [-122.51927, 37.53605], [-122.51928, 37.53612], [-122.51937, 37.53613]]]]} | Open Access 1 | 18796 | Point Montara Light Station | 1691 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.lighthousefriends.com/light.asp?ID=78 | San Mateo 15 | 0.227 | Point Montara Light Station | 1982 | State Historic or Cultural Area 132 | 4 |
7378 | 7378 | 7377 | {"type": "Polygon", "coordinates": [[[-118.69926, 34.03173], [-118.69898, 34.03182], [-118.69884, 34.03153], [-118.69917, 34.03149], [-118.69926, 34.03173]]]} | Open Access 1 | 6778 | Amarillo Beach - Coastal Conservancy | 15439 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Los Angeles 6 | 0.228 | Amarillo Beach - Coastal Conservancy | None 613 | |||
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
3191 | 3191 | 3190 | {"type": "Polygon", "coordinates": [[[-122.51877, 37.53612], [-122.51876, 37.53627], [-122.51829, 37.53627], [-122.51828, 37.53634], [-122.51809, 37.53633], [-122.51811, 37.53611], [-122.51877, 37.53612]]]} | Open Access 1 | 22111 | Point Montara Light Station | 1691 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.lighthousefriends.com/light.asp?ID=78 | San Mateo 15 | 0.284 | Point Montara Light Station | 1982 | State Historic or Cultural Area 132 | 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]);