superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
872 rows where MNG_AG_TYP = 5 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY 19
- California Department of Fish and Wildlife 380
- California Department of Parks and Recreation 276
- University of California 50
- Other State 33
- California Department of Transportation 29
- Santa Monica Mountains Conservancy 18
- California Department of Water Resources 18
- California State Lands Commission 11
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 7
- California Department of General Services 5
- Coachella Valley Mountains Conservancy 4
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Diego State University 2
- California State University 2
- California State University Sonoma 1
- California State University Long Beach 1
- California Tahoe Conservancy 1
ACCESS_TYP 4
- Open Access 593
- Restricted Access 122
- No Public Access 117
- Unknown Access 20
MNG_AG_TYP 1
- State Agency · 852 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
450 | 450 | 449 | {"type": "Polygon", "coordinates": [[[-122.179, 40.39296], [-122.17893, 40.39304], [-122.17881, 40.3933], [-122.17839, 40.39374], [-122.17821, 40.39349], [-122.1782, 40.39301], [-122.17663, 40.39309], [-122.17653, 40.3925], [-122.17678, 40.39242], [-122.177, 40.39239], [-122.17735, 40.39239], [-122.1779, 40.39233], [-122.17853, 40.39231], [-122.17893, 40.39282], [-122.179, 40.39296]]]} | Open Access 1 | Battle Creek Public Access | 32043 | 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.331 | Battle Creek PA | ||
451 | 451 | 450 | {"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]} | Open Access 1 | Bend Bridge Public Access | 32046 | 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.867 | Bend Bridge PA | ||
479 | 479 | 478 | {"type": "Polygon", "coordinates": [[[-121.614, 37.79798], [-121.61399, 37.79871], [-121.61178, 37.80234], [-121.60506, 37.80232], [-121.60511, 37.79512], [-121.60597, 37.79516], [-121.60635, 37.79514], [-121.60669, 37.7951], [-121.60708, 37.79511], [-121.6071, 37.79502], [-121.61204, 37.79505], [-121.614, 37.79798]]]} | No Public Access 3 | Byron Conservation Bank | 32076 | 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 | 139.977 | Byron Conservation Bank | ||
486 | 486 | 485 | {"type": "Polygon", "coordinates": [[[-124.10364, 40.82505], [-124.10204, 40.8308], [-124.10044, 40.83153], [-124.0966, 40.82984], [-124.08606, 40.82989], [-124.08662, 40.82863], [-124.08662, 40.82862], [-124.08651, 40.82861], [-124.08712, 40.82752], [-124.08783, 40.82593], [-124.08642, 40.82542], [-124.08641, 40.82541], [-124.08628, 40.82535], [-124.08666, 40.82496], [-124.08699, 40.82469], [-124.08887, 40.82328], [-124.08903, 40.82319], [-124.08922, 40.82304], [-124.10364, 40.82505]], [[-124.08767, 40.82431], [-124.08749, 40.82436], [-124.08737, 40.8245], [-124.08721, 40.82478], [-124.08706, 40.82492], [-124.08706, 40.82493], [-124.08714, 40.82496], [-124.08717, 40.82494], [-124.09117, 40.82586], [-124.0918, 40.8249], [-124.09179, 40.82489], [-124.08767, 40.82431]]]} | Open Access 1 | Bracut Tidelands | 32065 | 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 | 222.435 | Bracut Tidelands | ||
488 | 488 | 487 | {"type": "Polygon", "coordinates": [[[-122.3605, 40.5364], [-122.35803, 40.5383], [-122.3578, 40.53844], [-122.35758, 40.53825], [-122.35701, 40.53737], [-122.36041, 40.53623], [-122.3605, 40.5364]]]} | Open Access 1 | Bonnyview Road Fishing Access | 32064 | 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 | 6.223 | Bonnyview Road FA | ||
489 | 489 | 488 | {"type": "MultiPolygon", "coordinates": [[[[-121.68867, 38.1275], [-121.68824, 38.12823], [-121.68816, 38.12841], [-121.68798, 38.1287], [-121.68785, 38.12897], [-121.68754, 38.12941], [-121.68728, 38.1298], [-121.68701, 38.13032], [-121.68702, 38.13034], [-121.68707, 38.13034], [-121.68718, 38.13022], [-121.68731, 38.13013], [-121.68731, 38.13025], [-121.68714, 38.13082], [-121.68674, 38.13286], [-121.68666, 38.13305], [-121.68649, 38.13315], [-121.68632, 38.13314], [-121.68624, 38.1332], [-121.68621, 38.13383], [-121.686, 38.13383], [-121.68599, 38.13345], [-121.686, 38.13318], [-121.68608, 38.13262], [-121.68618, 38.13226], [-121.68662, 38.13085], [-121.68679, 38.13039], [-121.68701, 38.12992], [-121.68765, 38.12883], [-121.68771, 38.12882], [-121.68848, 38.12743], [-121.68867, 38.1275]]], [[[-121.69005, 38.12496], [-121.69001, 38.1252], [-121.68961, 38.12519], [-121.68986, 38.12492], [-121.69005, 38.12496]]]]} | Open Access 1 | Brannan Island Fishing Access | 32066 | 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 | 6.247 | Brannan Island FA | ||
503 | 503 | 502 | {"type": "Polygon", "coordinates": [[[-122.31276, 38.91619], [-122.30056, 38.91633], [-122.30018, 38.91044], [-122.30064, 38.91037], [-122.30093, 38.9103], [-122.30254, 38.90997], [-122.30296, 38.90992], [-122.30356, 38.90991], [-122.30391, 38.90996], [-122.30423, 38.91005], [-122.30598, 38.91071], [-122.30669, 38.91102], [-122.30716, 38.91107], [-122.30751, 38.91104], [-122.30762, 38.91103], [-122.30833, 38.91081], [-122.30869, 38.91064], [-122.30877, 38.91057], [-122.3089, 38.91042], [-122.30904, 38.9103], [-122.30907, 38.91024], [-122.30928, 38.90996], [-122.30929, 38.90987], [-122.3096, 38.90939], [-122.30981, 38.9092], [-122.31013, 38.90898], [-122.31036, 38.90884], [-122.31044, 38.90882], [-122.31061, 38.90873], [-122.31088, 38.90866], [-122.31144, 38.9086], [-122.312, 38.90866], [-122.31239, 38.90877], [-122.31264, 38.90888], [-122.31273, 38.90893], [-122.31276, 38.91619]]]} | Open Access 1 | Cache Creek Public Access | 32077 | 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 | 184.722 | Cache Creek PA | ||
512 | 512 | 511 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69163], [-120.44841, 34.69136], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | Burton Mesa Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | 32070 | 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 | 10.754 | Burton Mesa ER | 2004 |
515 | 515 | 514 | {"type": "Polygon", "coordinates": [[[-122.12958, 40.15278], [-122.12882, 40.15322], [-122.12754, 40.15169], [-122.1274, 40.15145], [-122.12654, 40.15098], [-122.12535, 40.1509], [-122.12416, 40.15059], [-122.12324, 40.15114], [-122.12248, 40.15109], [-122.12157, 40.15063], [-122.12095, 40.15023], [-122.12059, 40.14919], [-122.12062, 40.14922], [-122.12064, 40.14921], [-122.12017, 40.1479], [-122.11938, 40.14683], [-122.12133, 40.14572], [-122.12142, 40.14619], [-122.1217, 40.14693], [-122.1218, 40.14704], [-122.12196, 40.1471], [-122.12298, 40.14715], [-122.1234, 40.1472], [-122.12388, 40.14728], [-122.12417, 40.14734], [-122.12434, 40.14744], [-122.12451, 40.1476], [-122.12464, 40.14776], [-122.12488, 40.14831], [-122.12505, 40.14861], [-122.12526, 40.14881], [-122.12549, 40.14908], [-122.12561, 40.14917], [-122.12695, 40.14969], [-122.12665, 40.15041], [-122.12752, 40.15089], [-122.1279, 40.15016], [-122.12872, 40.15076], [-122.12883, 40.15096], [-122.12913, 40.15137], [-122.12923, 40.15229], [-122.12942, 40.15264], [-122.12958, 40.15278]]]} | Open Access 1 | Butler Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Butler-Slough-ER | 32071 | 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 | 57.898 | Butler Slough ER | 1998 |
519 | 519 | 518 | {"type": "Polygon", "coordinates": [[[-119.34169, 38.25623], [-119.34166, 38.27062], [-119.33714, 38.27071], [-119.33713, 38.27426], [-119.31879, 38.27468], [-119.31879, 38.27107], [-119.32338, 38.27095], [-119.3234, 38.26373], [-119.33256, 38.26356], [-119.33254, 38.27078], [-119.33712, 38.2707], [-119.33713, 38.25997], [-119.33941, 38.2599], [-119.33943, 38.25629], [-119.34169, 38.25623]]]} | Open Access 1 | By Day Creek Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/By-Day-Creek-ER | 32075 | 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 | 454.257 | By Day Creek ER | 1986 |
523 | 523 | 522 | {"type": "MultiPolygon", "coordinates": [[[[-119.95169, 35.34039], [-119.95158, 35.34385], [-119.94704, 35.34383], [-119.947, 35.3511], [-119.93381, 35.35103], [-119.93382, 35.34373], [-119.94282, 35.34379], [-119.94285, 35.34034], [-119.95169, 35.34039]]], [[[-119.96505, 35.33683], [-119.96502, 35.344], [-119.96043, 35.3441], [-119.96043, 35.3477], [-119.9559, 35.34767], [-119.95603, 35.34409], [-119.96042, 35.34408], [-119.96057, 35.33683], [-119.96505, 35.33683]]], [[[-119.98747, 35.33683], [-119.98735, 35.34411], [-119.96942, 35.34398], [-119.96961, 35.33682], [-119.98747, 35.33683]]], [[[-120.11221, 35.42515], [-120.11212, 35.43976], [-120.07625, 35.43965], [-120.07683, 35.425], [-120.05856, 35.4248], [-120.05868, 35.41024], [-120.04079, 35.41018], [-120.04075, 35.39937], [-120.03648, 35.39936], [-120.03645, 35.40289], [-120.03174, 35.40286], [-120.03177, 35.39558], [-120.02292, 35.39551], [-120.02283, 35.39752], [-120.01828, 35.39748], [-120.01829, 35.39549], [-120.01409, 35.39544], [-120.0141, 35.39176], [-120.01834, 35.39181], [-120.0183, 35.39547], [-120.01842, 35.39547], [-120.01842, 35.38431], [-120.01407, 35.3843], [-120.01398, 35.40632], [-120.02291, 35.40637], [-120.02291, 35.41006], [-120.01397, 35.4101], [-120.01396, 35.40745], [-119.98714, 35.40745], [-119.98723, 35.39547], [-119.98728, 35.38073], [-119.98721, 35.36616], [-120.00498, 35.36619], [-120.00533, 35.3516], [-120.03916, 35.35179], [-120.03919, 35.35942], [-120.03263, 35.35936], [-120.03223, 35.35888], [-120.03236, 35.3554], [-120.03276, 35.35491], [-120.03265, 35.35331], [-120.02691, 35.35332], [-120.02685, 35.35474], [-120.02724, 35.35502], [-120.02737, 35.38091], [-120.02717, 35.38093], [-120.02729, 35.3881], [-120.03183, 35.38814], [-120.03182, 35.38882], [-120.03184, 35.38884], [-120.03414, 35.38879], [-120.03698, 35.38817], [-120.04584, 35.38823], [-120.04588, 35.39171], [-120.04986, 35.39171], [-120.04991, 35.39568], [-120.05879, 35.39569], [-120.05897, 35.38872], [-120.06823, 35.38878], [-120.06819, 35.3957], [-120.08401, 35.39576], [-120.084, 35.40312], [-120.09426, 35.40318], [-120.09436, 35.42494], [-120.11221, 35.42515]], [[-120.0095, 35.36991], [-120.00951, 35.3699], [-120.0095, 35.36985], [-120.00509, 35.36985], [-120.00507, 35.36914], [-120.00505, 35.36914], [-120.00507, 35.3699], [-120.0095, 35.36991]], [[-120.0141, 35.38085], [-120.01412, 35.38084], [-120.0141, 35.38055], [-120.01409, 35.38084], [-120.0141, 35.38085]]], [[[-120.04067, 35.38442], [-120.03626, 35.3844], [-120.03623, 35.38094], [-120.04065, 35.38097], [-120.04067, 35.38442]]], [[[-120.09453, 35.35203], [-120.09446, 35.35604], [-120.09433, 35.35941], [-120.0943, 35.36646], [-120.08626, 35.36648], [-120.07741, 35.36647], [-120.07697, 35.36631], [-120.07702, 35.35933], [-120.07701, 35.35682], [-120.07617, 35.35678], [-120.07177, 35.35231], [-120.07016, 35.35227], [-120.07016, 35.35184], [-120.06997, 35.34965], [-120.06845, 35.34954], [-120.0685, 35.34831], [-120.0667, 35.34825], [-120.06668, 35.34663], [-120.06482, 35.34664], [-120.06478, 35.34489], [-120.06469, 35.3448], [-120.05735, 35.3449], [-120.05727, 35.34647], [-120.0543, 35.34645], [-120.05426, 35.34491], [-120.05033, 35.34496], [-120.0502, 35.34824], [-120.04715, 35.34821], [-120.04698, 35.3597], [-120.04063, 35.3597], [-120.04082, 35.33879], [-120.04089, 35.33879], [-120.05021, 35.34175], [-120.05287, 35.3416], [-120.0528, 35.33703], [-120.07704, 35.33706], [-120.07699, 35.35187], [-120.09453, 35.35203]]], [[[-120.09423, 35.37925], [-120.09423, 35.38101], [-120.09421, 35.38124], [-120.08206, 35.38118], [-120.08205, 35.38115], [-120.07786, 35.38119], [-120.0779, 35.37486], [-120.07979, 35.37486], [-120.08205, 35.37551], [-120.08204, 35.36856], [-120.08214, 35.3686], [-120.08216, 35.37614], [-120.09141, 35.37927], [-120.09423, 35.37925]]]]} | No Public Access 3 | California Valley | 32084 | 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 | 12381.101 | California Valley | ||
537 | 537 | 536 | {"type": "Polygon", "coordinates": [[[-121.52329, 38.38223], [-121.51986, 38.38421], [-121.51959, 38.38389], [-121.52311, 38.38198], [-121.52329, 38.38223]]]} | Open Access 1 | Clarksburg Fishing Access | 32116 | 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.404 | Clarksburg FA | ||
538 | 538 | 537 | {"type": "Polygon", "coordinates": [[[-120.12654, 39.80173], [-120.12649, 39.80538], [-120.1218, 39.80539], [-120.12175, 39.80901], [-120.12212, 39.80903], [-120.12208, 39.81271], [-120.11271, 39.81273], [-120.1127, 39.80904], [-120.11264, 39.80179], [-120.12654, 39.80173]]]} | No Public Access 3 | Chilcoot | 32112 | 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 | 277.451 | Chilcoot | ||
539 | 539 | 538 | {"type": "Polygon", "coordinates": [[[-121.61412, 37.7845], [-121.61412, 37.78579], [-121.61407, 37.78736], [-121.60506, 37.78748], [-121.605, 37.78452], [-121.6051, 37.78452], [-121.60511, 37.78451], [-121.61412, 37.7845]]]} | No Public Access 3 | Christensen Road Burrowing Owl Site | 32113 | 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 | 63.897 | Christensen Road Burrowing Owl Site | ||
541 | 541 | 540 | {"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.5374], [-115.54597, 33.53769], [-115.54599, 33.539]]]} | No Public Access 3 | Chuckwalla Bench | 32115 | 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 | 66.988 | Chuckwalla Bench | ||
610 | 610 | 609 | {"type": "Polygon", "coordinates": [[[-117.28817, 33.1631], [-117.28814, 33.16312], [-117.28816, 33.1691], [-117.28679, 33.16836], [-117.28617, 33.16805], [-117.28522, 33.16881], [-117.28511, 33.16913], [-117.28473, 33.16932], [-117.28468, 33.16947], [-117.28458, 33.16947], [-117.28458, 33.16955], [-117.28435, 33.16972], [-117.28386, 33.16973], [-117.28384, 33.16947], [-117.27955, 33.16947], [-117.27951, 33.16855], [-117.27085, 33.1685], [-117.27085, 33.16222], [-117.27083, 33.16221], [-117.27078, 33.16226], [-117.27078, 33.161], [-117.27075, 33.15819], [-117.27711, 33.15812], [-117.27712, 33.1581], [-117.2767, 33.1566], [-117.28385, 33.15499], [-117.2843, 33.15626], [-117.28207, 33.1577], [-117.28371, 33.15971], [-117.28404, 33.16164], [-117.28732, 33.161], [-117.28784, 33.16226], [-117.28788, 33.16309], [-117.28817, 33.1631]], [[-117.28036, 33.16048], [-117.28028, 33.16048], [-117.28019, 33.16051], [-117.28012, 33.16057], [-117.28009, 33.16065], [-117.28009, 33.16073], [-117.28012, 33.16081], [-117.28019, 33.16087], [-117.28026, 33.1609], [-117.28037, 33.16091], [-117.28048, 33.16087], [-117.28055, 33.16081], [-117.28059, 33.16073], [-117.28058, 33.16063], [-117.28054, 33.16056], [-117.28047, 33.1605], [-117.28036, 33.16048]]]} | Open Access 1 | Carlsbad Highlands Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carlsbad-Highlands-ER | 32095 | 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 | 471.805 | Carlsbad Highlands ER | 2000 |
626 | 626 | 625 | {"type": "Polygon", "coordinates": [[[-121.92008, 41.91622], [-121.91521, 41.91623], [-121.91507, 41.91209], [-121.91028, 41.91215], [-121.91043, 41.91631], [-121.9057, 41.91629], [-121.90546, 41.90908], [-121.91976, 41.90901], [-121.92008, 41.91622]]]} | No Public Access 3 | Cedar Point | 32109 | 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 | 190.719 | Cedar Point | ||
628 | 628 | 627 | {"type": "Polygon", "coordinates": [[[-122.82083, 40.70392], [-122.82082, 40.70572], [-122.81574, 40.70571], [-122.81575, 40.7039], [-122.82083, 40.70392]]]} | Open Access 1 | Cemetery Hole Fishing Access | 32111 | 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 | 21.266 | Cemetery Hole FA | ||
632 | 632 | 631 | {"type": "MultiPolygon", "coordinates": [[[[-122.47683, 40.49506], [-122.47594, 40.49555], [-122.47571, 40.49565], [-122.47441, 40.49567], [-122.47422, 40.49559], [-122.47405, 40.49549], [-122.47386, 40.49535], [-122.47371, 40.49518], [-122.47358, 40.49495], [-122.47348, 40.4946], [-122.4734, 40.49439], [-122.47327, 40.49419], [-122.47305, 40.49395], [-122.47277, 40.49375], [-122.47245, 40.49359], [-122.47209, 40.49348], [-122.4718, 40.49343], [-122.4712, 40.49339], [-122.47118, 40.49348], [-122.46964, 40.49349], [-122.46915, 40.49352], [-122.46848, 40.49362], [-122.46765, 40.49385], [-122.46753, 40.4911], [-122.47213, 40.49108], [-122.4722, 40.49201], [-122.47675, 40.49194], [-122.4768, 40.49321], [-122.47683, 40.49506]]], [[[-122.47345, 40.49569], [-122.4723, 40.49571], [-122.47227, 40.49481], [-122.4677, 40.49481], [-122.46767, 40.49414], [-122.46885, 40.49383], [-122.46916, 40.49378], [-122.46951, 40.49375], [-122.47117, 40.49375], [-122.47118, 40.49387], [-122.47173, 40.4939], [-122.47199, 40.49395], [-122.47224, 40.49403], [-122.47241, 40.49412], [-122.4726, 40.49426], [-122.47273, 40.49438], [-122.47283, 40.49452], [-122.4729, 40.49466], [-122.473, 40.49504], [-122.4731, 40.49526], [-122.47324, 40.49547], [-122.47345, 40.49569]]], [[[-122.47683, 40.49563], [-122.47683, 40.49563], [-122.47655, 40.49564], [-122.47683, 40.49548], [-122.47683, 40.49563]]]]} | No Public Access 3 | Clear Creek | 32118 | 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 | 71.617 | Clear Creek | ||
634 | 634 | 633 | {"type": "Polygon", "coordinates": [[[-121.66948, 38.16979], [-121.66941, 38.16983], [-121.66936, 38.16994], [-121.66935, 38.17035], [-121.66932, 38.17042], [-121.66873, 38.17075], [-121.66858, 38.17088], [-121.66823, 38.17112], [-121.66788, 38.17132], [-121.66746, 38.17165], [-121.66698, 38.17205], [-121.66674, 38.17196], [-121.66754, 38.1713], [-121.66837, 38.17043], [-121.66914, 38.16955], [-121.66948, 38.16979]]]} | Open Access 1 | Cliff House Fishing Access | 32119 | 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.203 | Cliff House 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]);