superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
124 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB, YR_EST
MNG_AGENCY 16
- California Department of Fish and Wildlife 75
- California Department of Parks and Recreation 15
- California Department of Water Resources 11
- California Department of Transportation 5
- California Department of General Services 3
- University of California 3
- California Department of Forestry and Fire Protection 2
- California Wildlife Conservation Board 2
- California State Lands Commission 1
- Other State 1
- Napa Valley College 1
- San Diego State University 1
- Coachella Valley Mountains Conservancy 1
- California State University 1
- California State Coastal Conservancy 1
- California Tahoe Conservancy 1
MNG_AG_TYP 1
- State Agency · 124 ✖
ACCESS_TYP 1
- No Public Access · 124 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3576 | 3576 | 3575 | {"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 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.163 | Dept Of Transportation/Paul Kenny | ||
8571 | 8571 | 8570 | {"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 | 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 | 0.203 | Real Estate Services Division | ||
1079 | 1079 | 1078 | {"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 | 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 | 0.209 | 575 Third St | ||
13252 | 13252 | 13251 | {"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 | 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 | 0.251 | South Branciforte | ||
3570 | 3570 | 3569 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | Department of Transportation | 18097 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.423 | Department of Transportation | ||
12232 | 12232 | 12231 | {"type": "Polygon", "coordinates": [[[-121.48533, 38.57999], [-121.48515, 38.58041], [-121.48444, 38.58023], [-121.48463, 38.57981], [-121.48533, 38.57999]]]} | No Public Access 3 | Governor's Mansion State Historic Park | http://www.parks.ca.gov/?page_id=498 | 30653 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.789 | Governor's Mansion SHP | 1903 |
6665 | 6665 | 6664 | {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} | No Public Access 3 | Stinson Beach | 32319 | 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 | 0.832 | Stinson Beach | ||
1129 | 1129 | 1128 | {"type": "Polygon", "coordinates": [[[-121.94459, 36.97664], [-121.94396, 36.97675], [-121.94326, 36.97677], [-121.94325, 36.9766], [-121.94341, 36.97632], [-121.94317, 36.97587], [-121.94331, 36.97591], [-121.94353, 36.97635], [-121.9438, 36.97644], [-121.94437, 36.97649], [-121.94459, 36.97664]]]} | No Public Access 3 | Escalona Gulch | 32161 | 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 | 1.022 | Escalona Gulch | ||
1324 | 1324 | 1323 | {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} | No Public Access 3 | Lower Box Canyon | 32208 | 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 | 1.06 | Lower Box Canyon | ||
3529 | 3529 | 3528 | {"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]} | No Public Access 3 | Del Norte Street Pier | 18042 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 1.467 | Del Norte Street Pier | ||
5312 | 5312 | 5311 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | Hwy 78 scenic corridor | 20163 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1.474 | Hwy 78 scenic corridor | ||
1533 | 1533 | 1532 | {"type": "Polygon", "coordinates": [[[-121.38053, 41.88124], [-121.37932, 41.88126], [-121.37932, 41.87996], [-121.38052, 41.87996], [-121.38053, 41.88124]]]} | No Public Access 3 | Newell Creek Cabin Site | 32244 | 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 | 3.559 | Newell Creek Cabin Site | ||
1484 | 1484 | 1483 | {"type": "Polygon", "coordinates": [[[-122.70265, 38.97554], [-122.70213, 38.97651], [-122.7016, 38.97676], [-122.7006, 38.97679], [-122.70085, 38.97617], [-122.70146, 38.9756], [-122.70265, 38.97554]]]} | No Public Access 3 | Monitor Island | 32231 | 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 | 3.761 | Monitor Island | ||
1381 | 1381 | 1380 | {"type": "Polygon", "coordinates": [[[-122.52297, 41.8958], [-122.52259, 41.89608], [-122.52198, 41.89642], [-122.5213, 41.89687], [-122.52065, 41.89629], [-122.52078, 41.89611], [-122.52229, 41.89521], [-122.52297, 41.8958]]]} | No Public Access 3 | Klamathon Station | 32197 | 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 | 4.018 | Klamathon Station | ||
426 | 426 | 425 | {"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]} | No Public Access 3 | Bodega Bay Monarch Butterfly | 32057 | 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 | 4.082 | Bodega Bay Monarch Butterfly | ||
1524 | 1524 | 1523 | {"type": "Polygon", "coordinates": [[[-120.99914, 40.31163], [-120.99859, 40.31171], [-120.9985, 40.31129], [-120.99668, 40.31149], [-120.9969, 40.31103], [-120.99705, 40.31094], [-120.99855, 40.31086], [-120.99813, 40.31023], [-120.99861, 40.31003], [-120.99911, 40.31023], [-120.99914, 40.31163]]]} | No Public Access 3 | Mountain Meadows | 32238 | 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 | 4.367 | Mtn. Meadows | ||
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.2221], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 4.799 | Department Of Water Resourses | ||
1323 | 1323 | 1322 | {"type": "Polygon", "coordinates": [[[-120.28166, 37.25478], [-120.28099, 37.25642], [-120.27927, 37.25501], [-120.27926, 37.25459], [-120.27982, 37.25436], [-120.27995, 37.25478], [-120.2801, 37.25503], [-120.28033, 37.25511], [-120.28065, 37.25511], [-120.28166, 37.25478]]]} | No Public Access 3 | Le Grand | 32200 | 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 | 4.88 | Le Grand | ||
6401 | 6401 | 6400 | {"type": "Polygon", "coordinates": [[[-116.80776, 34.25506], [-116.80546, 34.25503], [-116.80552, 34.25267], [-116.80555, 34.25223], [-116.80581, 34.25222], [-116.80588, 34.25398], [-116.8077, 34.25401], [-116.80776, 34.25506]]]} | No Public Access 3 | Shay Meadow | 32307 | 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 | 7.42 | Shay Meadow | ||
2382 | 2382 | 2381 | {"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]} | No Public Access 3 | Phoenix Field Ecological Reserve | 32261 | 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 | 8.006 | Phoenix Field ER |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);