superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
602 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 17
- California Department of Fish and Wildlife 252
- California Department of Parks and Recreation 250
- Other State 29
- Santa Monica Mountains Conservancy 18
- California Department of Transportation 9
- University of California 8
- California State Lands Commission 8
- California Department of Forestry and Fire Protection 8
- California Department of Water Resources 6
- California Wildlife Conservation Board 3
- California Department of General Services 2
- California Department of Veterans Affairs 2
- Coachella Valley Mountains Conservancy 2
- California State Coastal Conservancy 2
- Napa Valley College 1
- California State University 1
- California State University Long Beach 1
ACCESS_TYP 1
- Open Access · 602 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9976 | 9976 | 9975 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.0495, 36.9493], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.0498, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | Stockton Avenue Beach | 25857 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.139 | Stockton Avenue Beach | |||
13361 | 13361 | 13360 | {"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 | State Indian Museum State Historic Park | http://www.parks.ca.gov/?page_id=486 | 30709 | 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.153 | State Indian Museum SHP | 1941 |
7916 | 7916 | 7915 | {"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 | Santa Monica Mountains Conservancy Open Space | 25119 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 0.187 | Santa Monica Mtns. Conservancy OS | ||
1467 | 1467 | 1466 | {"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 | Amarillo Beach - Coastal Conservancy | 15439 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 0.228 | Amarillo Beach - Coastal Conservancy | ||
82 | 82 | 81 | {"type": "Polygon", "coordinates": [[[-119.94847, 37.46489], [-119.94784, 37.46489], [-119.94783, 37.46473], [-119.94799, 37.46473], [-119.94799, 37.46463], [-119.94829, 37.46463], [-119.9483, 37.46472], [-119.94846, 37.46472], [-119.94847, 37.46489]]]} | Open Access 1 | California Mining & Mineral Museum | http://www.parks.ca.gov/?page_id=588 | 1457 | 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.327 | California Mining & Mineral Museum | 1999 |
13336 | 13336 | 13335 | {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} | Open Access 1 | Vallejo Fishing Pier | 32344 | 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.461 | Vallejo Fishing Pier | ||
180 | 180 | 179 | {"type": "Polygon", "coordinates": [[[-121.49995, 38.57528], [-121.49977, 38.5757], [-121.49934, 38.57558], [-121.49952, 38.57517], [-121.49995, 38.57528]]]} | Open Access 1 | Heilbron Mansion | 1561 | 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.477 | Heilbron Mansion | ||
5090 | 5090 | 5089 | {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} | Open Access 1 | Hidden Beach | 19901 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.487 | Hidden Beach | |||
265 | 265 | 264 | {"type": "MultiPolygon", "coordinates": [[[[-122.51877, 37.53612], [-122.51876, 37.53627], [-122.5183, 37.53627], [-122.51828, 37.53634], [-122.51809, 37.53633], [-122.51811, 37.53611], [-122.51877, 37.53612]]], [[[-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.53635], [-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 | Point Montara Light Station | http://www.lighthousefriends.com/light.asp?ID=78 | 1691 | 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.513 | Point Montara Light Station | 1982 |
13663 | 13663 | 13662 | {"type": "Polygon", "coordinates": [[[-122.39127, 37.75408], [-122.39097, 37.75409], [-122.39088, 37.75351], [-122.39082, 37.75346], [-122.39076, 37.75345], [-122.39076, 37.7531], [-122.39079, 37.7531], [-122.39096, 37.75334], [-122.39112, 37.75365], [-122.39126, 37.75395], [-122.39127, 37.75408]]]} | Open Access 1 | Progress Park | https://www.sfparksalliance.org/our-work/park-partners/progress-park | 33456 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.522 | Progress Park | |
92 | 92 | 91 | {"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 | Drum Barracks | http://ohp.parks.ca.gov/ListedResources/Detail/169 | 1504 | 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.539 | Drum Barracks | |
128 | 128 | 127 | {"type": "Polygon", "coordinates": [[[-118.68178, 34.0414], [-118.68173, 34.04177], [-118.68116, 34.04174], [-118.68115, 34.04127], [-118.68129, 34.04127], [-118.68146, 34.04138], [-118.68178, 34.0414]]]} | Open Access 1 | Hendler Open Space | 19816 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 0.62 | Hendler OS | ||
13471 | 13471 | 13470 | {"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.51289, 37.9125], [-122.51288, 37.91262], [-122.51293, 37.91302], [-122.51293, 37.91326], [-122.51289, 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 | Alto Path | 30886 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.756 | Alto Path | ||
59 | 59 | 58 | {"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 | Benicia Capitol State Historic Park | http://www.parks.ca.gov/?page_id=475 | 1431 | 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.863 | Benicia Capitol SHP | 1951 |
7803 | 7803 | 7802 | {"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 | Other State 26 | 23258 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.864 | Other State 26 | |||
15196 | 15196 | 15195 | {"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 | Leland Stanford Mansion State Historic Park | http://www.parks.ca.gov/?page_id=489 | 1600 | 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.881 | Leland Stanford Mansion SHP | 1978 |
85 | 85 | 84 | {"type": "Polygon", "coordinates": [[[-122.5099, 38.54123], [-122.50953, 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 | Bale Grist Mill State Historic Park | http://www.parks.ca.gov/?page_id=482 | 1428 | 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.893 | Bale Grist Mill SHP | 1974 |
8537 | 8537 | 8536 | {"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 | Rancho San Andreas | 24168 | 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.998 | Rancho San Andreas | 2002 | |
6402 | 6402 | 6401 | {"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 | 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 | 1.086 | Shasta River FA | ||
801 | 801 | 800 | {"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 | 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 | 1.1 | Deer Creek FA |
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]);