superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where ACCESS_TYP = 3 and LAYER = 6 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7018 | 7018 | 7017 | {"type": "MultiPolygon", "coordinates": [[[[-120.81642, 38.5584], [-120.81611, 38.55859], [-120.81609, 38.55862], [-120.81611, 38.55839], [-120.81642, 38.5584]]], [[[-120.82405, 38.55808], [-120.82414, 38.55836], [-120.82417, 38.55862], [-120.82414, 38.55901], [-120.82407, 38.55919], [-120.82377, 38.55954], [-120.82358, 38.55964], [-120.82332, 38.55973], [-120.82311, 38.55974], [-120.82289, 38.55977], [-120.82264, 38.55976], [-120.82233, 38.5597], [-120.82197, 38.55968], [-120.82166, 38.55965], [-120.82129, 38.55955], [-120.82089, 38.55941], [-120.8206, 38.55925], [-120.82011, 38.55885], [-120.81942, 38.55845], [-120.81877, 38.55822], [-120.81842, 38.55813], [-120.81821, 38.55806], [-120.82405, 38.55808]]], [[[-120.8302, 38.5565], [-120.83017, 38.56176], [-120.82843, 38.56177], [-120.82839, 38.56101], [-120.82631, 38.56105], [-120.82632, 38.56177], [-120.81824, 38.5618], [-120.81869, 38.56131], [-120.81949, 38.56084], [-120.8204, 38.56047], [-120.82211, 38.55987], [-120.82276, 38.56001], [-120.82338, 38.56006], [-120.8238, 38.55998], [-120.82418, 38.55971], [-120.82433, 38.55929], [-120.82437, 38.55885], [-120.82428, 38.55844], [-120.82416, 38.55817], [-120.82547, 38.55815], [-120.82545, 38.55587], [-120.82592, 38.55581], [-120.82633, 38.55581], [-120.82678, 38.55586], [-120.82721, 38.55593], [-120.8282, 38.55613], [-120.82859, 38.55622], [-120.82896, 38.55634], [-120.8302, 38.5565]]]]} | No Public Access 3 | Upper Cosumnes River | 32342 | 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 | 106.285 | Upper Cosumnes River | ||
6948 | 6948 | 6947 | {"type": "Polygon", "coordinates": [[[-116.10145, 34.19582], [-116.10145, 34.19703], [-116.09814, 34.19705], [-116.09814, 34.19584], [-116.10145, 34.19582]]]} | No Public Access 3 | Twentynine Palms - Valle Vista Road | 32334 | 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.114 | Twentynine Palms - Valle Vista Road | ||
6754 | 6754 | 6753 | {"type": "Polygon", "coordinates": [[[-117.5972, 33.67495], [-117.59564, 33.67532], [-117.59561, 33.6788], [-117.59438, 33.67879], [-117.59174, 33.67873], [-117.59137, 33.67839], [-117.59108, 33.67825], [-117.58996, 33.67822], [-117.58984, 33.67353], [-117.58986, 33.67178], [-117.59522, 33.6718], [-117.59706, 33.67178], [-117.59708, 33.6737], [-117.59715, 33.67436], [-117.5972, 33.67495]]]} | No Public Access 3 | Trabuco Canyon | 32328 | 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 | 112.285 | Trabuco Canyon | ||
6666 | 6666 | 6665 | {"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96192, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]} | No Public Access 3 | Stoney Creek | 32321 | 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 | 120.415 | Stoney Creek | ||
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 | ||
6577 | 6577 | 6576 | {"type": "MultiPolygon", "coordinates": [[[[-114.95504, 33.26685], [-114.93777, 33.26689], [-114.93775, 33.26702], [-114.93746, 33.26702], [-114.93745, 33.26669], [-114.93718, 33.26668], [-114.93713, 33.2594], [-114.93712, 33.25216], [-114.95448, 33.25207], [-114.95504, 33.26685]]], [[[-114.98888, 33.26647], [-114.98008, 33.26656], [-114.97992, 33.25954], [-114.97989, 33.25216], [-114.98884, 33.25215], [-114.98888, 33.26647]]]]} | No Public Access 3 | Smoketree Valley - Chocolate Mountains | 32312 | 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 | 990.513 | Smoketree Valley - Chocolate Mtns. | ||
6575 | 6575 | 6574 | {"type": "Polygon", "coordinates": [[[-120.43313, 38.22238], [-120.43264, 38.23267], [-120.42823, 38.23271], [-120.42353, 38.23268], [-120.42313, 38.23598], [-120.42315, 38.236], [-120.42788, 38.23613], [-120.43269, 38.23621], [-120.43263, 38.23982], [-120.41879, 38.23951], [-120.41891, 38.23594], [-120.41446, 38.23586], [-120.4142, 38.23948], [-120.41, 38.23943], [-120.40997, 38.2395], [-120.40515, 38.2394], [-120.40549, 38.23564], [-120.40547, 38.23562], [-120.40533, 38.23562], [-120.40539, 38.233], [-120.40988, 38.23313], [-120.40991, 38.23308], [-120.41, 38.23308], [-120.4101, 38.22955], [-120.41473, 38.22964], [-120.41494, 38.22578], [-120.42846, 38.22602], [-120.42874, 38.22244], [-120.43313, 38.22238]]]} | No Public Access 3 | Sheep Ranch | 32308 | 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 | 696.936 | Sheep Ranch | ||
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 | ||
4336 | 4336 | 4335 | {"type": "MultiPolygon", "coordinates": [[[[-121.97758, 37.42901], [-121.97746, 37.43245], [-121.97438, 37.4325], [-121.97433, 37.42904], [-121.97758, 37.42901]]], [[[-122.15107, 37.66265], [-122.14971, 37.66346], [-122.14945, 37.66398], [-122.1474, 37.66495], [-122.14554, 37.66547], [-122.14345, 37.66316], [-122.139, 37.65856], [-122.13938, 37.65851], [-122.13948, 37.6586], [-122.13969, 37.65847], [-122.14042, 37.65838], [-122.14166, 37.65979], [-122.14167, 37.65974], [-122.14402, 37.65974], [-122.14683, 37.65976], [-122.15107, 37.66265]]]]} | No Public Access 3 | San Francisco Bay | 32293 | 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 | 114.348 | San Francisco Bay | 1980 | |
4334 | 4334 | 4333 | {"type": "MultiPolygon", "coordinates": [[[[-122.36595, 40.50811], [-122.36457, 40.50963], [-122.36317, 40.51062], [-122.36286, 40.51141], [-122.36171, 40.51207], [-122.36145, 40.5119], [-122.36142, 40.51191], [-122.36049, 40.5114], [-122.35933, 40.51101], [-122.35937, 40.5084], [-122.36377, 40.50797], [-122.3654, 40.50806], [-122.36595, 40.50811]]], [[[-122.37348, 40.55551], [-122.3734, 40.55565], [-122.37337, 40.55586], [-122.37338, 40.55617], [-122.37197, 40.55594], [-122.37218, 40.55527], [-122.37348, 40.55551]]]]} | No Public Access 3 | Sacramento River -- Redding | 32284 | 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 | 40.985 | Sacramento River -- Redding | ||
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 | ||
2380 | 2380 | 2379 | {"type": "MultiPolygon", "coordinates": [[[[-119.64375, 38.49138], [-119.64329, 38.49875], [-119.63428, 38.49886], [-119.63415, 38.50244], [-119.62983, 38.50247], [-119.61651, 38.50195], [-119.61647, 38.4999], [-119.61634, 38.49523], [-119.6208, 38.49526], [-119.62078, 38.49186], [-119.626, 38.49168], [-119.63001, 38.49166], [-119.63007, 38.48818], [-119.63468, 38.48808], [-119.63457, 38.49155], [-119.64375, 38.49138]]], [[[-119.6757, 38.52703], [-119.6757, 38.53059], [-119.66602, 38.53084], [-119.66597, 38.52729], [-119.67485, 38.52698], [-119.67487, 38.52705], [-119.6757, 38.52703]]]]} | No Public Access 3 | Poison Flat Creek | 32269 | 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 | 697.782 | Poison Flat Creek | ||
1606 | 1606 | 1605 | {"type": "MultiPolygon", "coordinates": [[[[-115.10424, 34.50144], [-115.10424, 34.51594], [-115.08672, 34.51599], [-115.08674, 34.50147], [-115.10424, 34.50144]]], [[[-115.22675, 34.55713], [-115.21271, 34.55713], [-115.20947, 34.55717], [-115.20945, 34.54492], [-115.21819, 34.54493], [-115.22674, 34.54496], [-115.22675, 34.55713]]], [[[-115.22005, 34.58613], [-115.21566, 34.58613], [-115.21566, 34.58265], [-115.22005, 34.58265], [-115.22005, 34.58613]]]]} | No Public Access 3 | Old Woman Mountains Bighorn Sheep Range | 32250 | 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 | 1208.987 | Old Woman Mtns. Bighorn Sheep Range | ||
1535 | 1535 | 1534 | {"type": "MultiPolygon", "coordinates": [[[[-116.27983, 35.49216], [-116.27707, 35.49572], [-116.27495, 35.49496], [-116.2776, 35.49119], [-116.27983, 35.49216]]], [[[-116.28733, 35.48445], [-116.28702, 35.48523], [-116.28511, 35.48486], [-116.28546, 35.48401], [-116.28733, 35.48445]]]]} | No Public Access 3 | Mountain Sheep Watering Area | 32241 | 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 | 29.898 | Mtn. Sheep Watering Area | ||
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 | ||
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 | ||
1485 | 1485 | 1484 | {"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]} | No Public Access 3 | Ord Rodman | 32252 | 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 | 115.52 | Ord Rodman | ||
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 | ||
1482 | 1482 | 1481 | {"type": "Polygon", "coordinates": [[[-121.32414, 38.16873], [-121.32419, 38.16888], [-121.3242, 38.16903], [-121.32407, 38.16947], [-121.32391, 38.16971], [-121.32379, 38.16982], [-121.32359, 38.16992], [-121.32342, 38.16995], [-121.32332, 38.16994], [-121.32316, 38.16995], [-121.3231, 38.17], [-121.32285, 38.17029], [-121.32276, 38.17044], [-121.32275, 38.17058], [-121.3228, 38.17069], [-121.32322, 38.17134], [-121.32325, 38.17142], [-121.32323, 38.17154], [-121.32317, 38.17165], [-121.32301, 38.1718], [-121.32293, 38.17185], [-121.32273, 38.17193], [-121.32219, 38.17208], [-121.32157, 38.17221], [-121.32149, 38.17221], [-121.32132, 38.17227], [-121.321, 38.17242], [-121.32093, 38.17249], [-121.32064, 38.17281], [-121.32037, 38.17315], [-121.32031, 38.17332], [-121.3203, 38.17346], [-121.32031, 38.17362], [-121.3204, 38.17381], [-121.32051, 38.17395], [-121.32084, 38.17416], [-121.32115, 38.17431], [-121.3212, 38.17437], [-121.32119, 38.17444], [-121.321, 38.17452], [-121.32034, 38.17474], [-121.32021, 38.17476], [-121.32008, 38.17476], [-121.31994, 38.17473], [-121.31948, 38.17456], [-121.31929, 38.17442], [-121.31919, 38.17419], [-121.31922, 38.17414], [-121.31932, 38.17405], [-121.3194, 38.17407], [-121.31945, 38.17417], [-121.31956, 38.17418], [-121.3197, 38.17405], [-121.3198, 38.17387], [-121.31977, 38.17379], [-121.31972, 38.17372], [-121.31963, 38.17368], [-121.31953, 38.17369], [-121.31937, 38.17375], [-121.31924, 38.17373], [-121.31916, 38.17369], [-121.31911, 38.17365], [-121.31899, 38.17308], [-121.31922, 38.1731], [-121.31946, 38.17269], [-121.32024, 38.17242], [-121.32033, 38.17241], [-121.32059, 38.1725], [-121.32075, 38.17234], [-121.321, 38.17241], [-121.32131, 38.17205], [-121.32184, 38.17185], [-121.3227, 38.17159], [-121.32277, 38.17144], [-121.3227, 38.17127], [-121.32253, 38.17111], [-121.32241, 38.17081], [-121.3224, 38.17059], [-121.32249, 38.17038], [-121.32264, 38.17018], [-121.32286, 38.17], [-121.32309, 38.16986], [-121.32336, 38.16973], [-121.32343, 38.16953], [-121.32338, 38.16949], [-121.32249, 38.16966], [-121.32201, 38.16966], [-121.32149, 38.1697], [-121.32108, 38.16967], [-121.32088, 38.16929], [-121.32072, 38.16927], [-121.32054, 38.16927], [-121.32008, 38.16898], [-121.31985, 38.16888], [-121.3198, 38.1688], [-121.31971, 38.16885], [-121.31955, 38.1688], [-121.31923, 38.16878], [-121.31877, 38.16894], [-121.31816, 38.16903], [-121.31734, 38.16903], [-121.31667, 38.16922], [-121.31617, 38.16947], [-121.31573, 38.16964], [-121.31536, 38.1698], [-121.31491, 38.16981], [-121.31437, 38.16958], [-121.31441, 38.16952], [-121.31473, 38.16966], [-121.31492, 38.16972], [-121.31507, 38.16975], [-121.31545, 38.16967], [-121.31564, 38.1696], [-121.31622, 38.16927], [-121.31636, 38.16916], [-121.31652, 38.169], [-121.31696, 38.16867], [-121.3173, 38.16855], [-121.31772, 38.16846], [-121.3179, 38.16843], [-121.31823, 38.16843], [-121.31837, 38.16844], [-121.31866, 38.1685], [-121.31879, 38.16862], [-121.31906, 38.16862], [-121.31944, 38.16861], [-121.3197, 38.16857], [-121.31994, 38.16851], [-121.32027, 38.16837], [-121.32037, 38.16836], [-121.32044, 38.16837], [-121.32054, 38.16842], [-121.3206, 38.16848], [-121.32064, 38.16853], [-121.32069, 38.16867], [-121.32069, 38.16884], [-121.32063, 38.16915], [-121.32079, 38.16925], [-121.32098, 38.16933], [-121.32187, 38.16946], [-121.32214, 38.16945], [-121.32247, 38.16941], [-121.32293, 38.16928], [-121.32321, 38.16915], [-121.32351, 38.16893], [-121.32385, 38.16874], [-121.32399, 38.16869], [-121.32414, 38.16873]]]} | No Public Access 3 | Mokelumne River | 32229 | 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 | 18.472 | Mokelumne River | ||
1445 | 1445 | 1444 | {"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06236], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06234], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.68509, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10572], [-116.6938, 34.10576]]]]} | No Public Access 3 | Mission Creek | 32221 | 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 | 2202.949 | Mission Creek |
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]);