units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,141 rows where MNG_AG_TYP = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP >30
- State Conservation Area 380
- State Park 206
- State Resource Management Area 158
- State Recreation Area 142
- State Other or Unknown 65
- State Historic or Cultural Area 58
- National Monument or Landmark 2
- National Wildlife Refuge 2
- State Wilderness 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Recreation 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
- …
MNG_AGENCY 20
- California Department of Fish and Wildlife 441
- California Department of Parks and Recreation 374
- California State Lands Commission 86
- University of California 58
- Other State 40
- California Department of Transportation 28
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 18
- California Department of Forestry and Fire Protection 10
- California Department of General Services 9
- California Wildlife Conservation Board 9
- San Diego State University 7
- California State Coastal Conservancy 6
- Coachella Valley Mountains Conservancy 5
- California Department of Veterans Affairs 2
- Napa Valley College 2
- California State University 2
- California Tahoe Conservancy 2
- California State University Sonoma 1
- California State University Long Beach 1
ACCESS_TYP 4
- Open Access 815
- Restricted Access 149
- No Public Access 129
- Unknown Access 28
MNG_AG_TYP 1
- State Agency · 1,121 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11736 | 11736 | 11735 | {"type": "Polygon", "coordinates": [[[-122.39127, 37.75408], [-122.39097, 37.75409], [-122.39088, 37.75351], [-122.39085, 37.75347], [-122.39082, 37.75346], [-122.39076, 37.75345], [-122.39076, 37.7531], [-122.39079, 37.7531], [-122.39096, 37.75335], [-122.39112, 37.75365], [-122.39126, 37.75395], [-122.39127, 37.75408]]]} | Open Access 1 | 48729 | Progress Park | 33456 | 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 | https://www.sfparksalliance.org/our-work/park-partners/progress-park | San Francisco 13 | 0.521 | Progress Park | None 1038 | ||
993 | 993 | 992 | {"type": "Polygon", "coordinates": [[[-118.25813, 33.78468], [-118.25775, 33.7847], [-118.25773, 33.78459], [-118.2574, 33.78461], [-118.25738, 33.78437], [-118.2581, 33.78433], [-118.25813, 33.78468]]]} | Open Access 1 | 6191 | Drum Barracks | 1504 | 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://ohp.parks.ca.gov/ListedResources/Detail/169 | Los Angeles 6 | 0.539 | Drum Barracks | None 90 | ||
16071 | 16071 | 16070 | {"type": "Polygon", "coordinates": [[[-118.68179, 34.0414], [-118.68173, 34.04177], [-118.68116, 34.04174], [-118.68115, 34.04127], [-118.68129, 34.04127], [-118.68146, 34.04138], [-118.68179, 34.0414]]]} | Open Access 1 | 7231 | Hendler Open Space | 19816 | 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.62 | Hendler OS | 0 | State Recreation Area 39 | 4 | |
14519 | 14519 | 14518 | {"type": "Polygon", "coordinates": [[[-122.51472, 37.90786], [-122.51472, 37.90792], [-122.51462, 37.9081], [-122.5146, 37.90818], [-122.5143, 37.9088], [-122.51347, 37.91085], [-122.51288, 37.9125], [-122.51288, 37.91262], [-122.51293, 37.91302], [-122.51293, 37.91326], [-122.5129, 37.91332], [-122.51271, 37.91352], [-122.51273, 37.91343], [-122.51285, 37.9133], [-122.51288, 37.91325], [-122.51288, 37.91302], [-122.51282, 37.91261], [-122.51284, 37.91248], [-122.51341, 37.91084], [-122.51425, 37.90878], [-122.51455, 37.90817], [-122.51457, 37.90808], [-122.51467, 37.9079], [-122.51472, 37.90786]]]} | Open Access 1 | 47192 | Alto Path | 30886 | 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 | Marin 23 | 0.756 | Alto Path | None 1236 | |||
2960 | 2960 | 2959 | {"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 | 20477 | Governor's Mansion State Historic Park | 30653 | 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=498 | Sacramento 41 | 0.789 | Governor's Mansion SHP | 1903 | State Historic or Cultural Area 132 | 4 |
6173 | 6173 | 6172 | {"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 | 1204 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 0.833 | Stinson Beach | 0 | State Resource Management Area 55 | 3 | |
13135 | 13135 | 13134 | {"type": "Polygon", "coordinates": [[[-122.15956, 38.05035], [-122.15934, 38.05064], [-122.15844, 38.05023], [-122.15866, 38.04993], [-122.15956, 38.05035]]]} | Open Access 1 | 35060 | Benicia Capitol State Historic Park | 1431 | 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=475 | Solano 26 | 0.863 | Benicia Capitol SHP | 1951 | State Historic or Cultural Area 132 | 4 |
3933 | 3933 | 3932 | {"type": "Polygon", "coordinates": [[[-119.21361, 38.30059], [-119.21338, 38.30059], [-119.21339, 38.29848], [-119.21349, 38.29872], [-119.21356, 38.29909], [-119.21361, 38.30059]]]} | Open Access 1 | 36234 | Other State 26 | 23258 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Mono 32 | 0.864 | Other State 26 | None 338 | ||||
16510 | 16510 | 16509 | {"type": "Polygon", "coordinates": [[[-121.49815, 38.57602], [-121.49797, 38.57644], [-121.49718, 38.57622], [-121.49736, 38.57581], [-121.49815, 38.57602]]]} | Open Access 1 | 20493 | Leland Stanford Mansion State Historic Park | 1600 | 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=489 | Sacramento 41 | 0.881 | Leland Stanford Mansion SHP | 1978 | State Historic or Cultural Area 132 | 4 |
13171 | 13171 | 13170 | {"type": "Polygon", "coordinates": [[[-122.5099, 38.54123], [-122.50952, 38.54126], [-122.5096, 38.54147], [-122.50894, 38.54153], [-122.50889, 38.54131], [-122.5088, 38.54108], [-122.50918, 38.54103], [-122.50948, 38.54101], [-122.50983, 38.54111], [-122.5099, 38.54123]]]} | Open Access 1 | 35129 | Bale Grist Mill State Historic Park | 1428 | 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=482 | Napa 11 | 0.89 | Bale Grist Mill SHP | 1974 | State Historic or Cultural Area 132 | 4 |
3833 | 3833 | 3832 | {"type": "Polygon", "coordinates": [[[-121.81298, 36.94641], [-121.81273, 36.94671], [-121.81211, 36.94655], [-121.81235, 36.94589], [-121.81273, 36.94612], [-121.81298, 36.94641]]]} | Open Access 1 | 45359 | Rancho San Andreas | 24168 | 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 | Santa Cruz 5 | 0.999 | Rancho San Andreas | 2002 | None 323 | ||
16460 | 16460 | 16459 | {"type": "Polygon", "coordinates": [[[-118.89209, 34.04019], [-118.89161, 34.04094], [-118.89112, 34.04087], [-118.8916, 34.04012], [-118.89209, 34.04019]]]} | Open Access 1 | 13036 | Robert H. Meyer Memorial State Beach | 1709 | 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=633 | Los Angeles 6 | 1.018 | Robert H. Meyer Memorial SB | 1978 | State Park 15 | 4 |
14340 | 14340 | 14339 | {"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 | 44373 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 1.02 | Escalona Gulch | 0 | State Resource Management Area 55 | 3 | |
545 | 545 | 544 | {"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 | 1814 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 1.061 | Lower Box Canyon | 0 | State Resource Management Area 55 | 3 | |
4964 | 4964 | 4963 | {"type": "Polygon", "coordinates": [[[-122.43108, 41.43777], [-122.43089, 41.43822], [-122.4304, 41.43783], [-122.43008, 41.43741], [-122.43055, 41.43722], [-122.43108, 41.43777]]]} | Open Access 1 | 3682 | Shasta River Fishing Access | 32306 | 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 | Siskiyou 28 | 1.086 | Shasta River FA | 0 | State Recreation Area 39 | 4 | |
12280 | 12280 | 12279 | {"type": "Polygon", "coordinates": [[[-122.01675, 39.96925], [-122.01628, 39.96961], [-122.0158, 39.96979], [-122.01445, 39.96984], [-122.01447, 39.9697], [-122.01532, 39.96964], [-122.01591, 39.96951], [-122.0165, 39.96916], [-122.01675, 39.96925]]]} | Open Access 1 | 25907 | Deer Creek Fishing Access | 32147 | 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 | Tehama 18 | 1.1 | Deer Creek FA | 0 | State Recreation Area 39 | 4 | |
3862 | 3862 | 3861 | {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} | Open Access 1 | 35608 | Other State 14 | 23252 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 1.203 | Other State 14 | None 329 | ||||
3437 | 3437 | 3436 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | 25245 | Rutherford Crossroad | 32278 | 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 | Napa 11 | 1.213 | Rutherford Crossroad | 0 | State Resource Management Area 55 | 3 | |
9569 | 9569 | 9568 | {"type": "Polygon", "coordinates": [[[-118.12039, 33.78525], [-118.12012, 33.78568], [-118.11924, 33.78524], [-118.11954, 33.78482], [-118.12039, 33.78525]]]} | Open Access 1 | 47841 | Earl Burns Miller Japanese Garden | 31783 | 237 | California State University Long Beach 915 | State 5 | State Agency 5 | https://www.csulb.edu/ | Other State 5 | 237 | California State University Long Beach 889 | State 5 | State Agency 5 | http://web.csulb.edu/~jgarden/index.html | Los Angeles 6 | 1.249 | Earl Burns Miller Japanese Garden | 1981 | None 799 | |
4771 | 4771 | 4770 | {"type": "Polygon", "coordinates": [[[-124.09931, 40.49321], [-124.09822, 40.4937], [-124.09816, 40.49283], [-124.09855, 40.49302], [-124.09884, 40.49286], [-124.09931, 40.49321]]]} | Open Access 1 | 46932 | Unnamed site - California Department of Fish and Wildlife | 30559 | 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 | Humboldt 45 | 1.271 | 0 | State Other or Unknown 104 | 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]);