superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where ACCESS_TYP = 3 and MNG_AGENCY = 25 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency 75
MNG_AGENCY 1
- California Department of Fish and Wildlife · 75 ✖
ACCESS_TYP 1
- No Public Access · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
1126 | 1126 | 1125 | {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31195], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} | No Public Access 3 | Elsa Rupp Natural Area | 32160 | 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 | 9.474 | Elsa Rupp Natural Area | ||
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 | ||
13337 | 13337 | 13336 | {"type": "Polygon", "coordinates": [[[-122.92622, 38.21025], [-122.92607, 38.2121], [-122.9261, 38.21451], [-122.92537, 38.21453], [-122.92543, 38.21399], [-122.9252, 38.21396], [-122.92534, 38.21304], [-122.92489, 38.21275], [-122.92481, 38.21267], [-122.92468, 38.21246], [-122.92464, 38.21237], [-122.92459, 38.21217], [-122.92434, 38.21196], [-122.92414, 38.21165], [-122.92392, 38.21134], [-122.92379, 38.21121], [-122.92373, 38.21108], [-122.92373, 38.21095], [-122.92376, 38.21086], [-122.92383, 38.21078], [-122.92388, 38.21074], [-122.924, 38.21071], [-122.92413, 38.2107], [-122.92483, 38.21075], [-122.92503, 38.21072], [-122.92521, 38.21068], [-122.92534, 38.21057], [-122.9254, 38.2105], [-122.92561, 38.21012], [-122.92563, 38.21043], [-122.92581, 38.21043], [-122.92581, 38.21025], [-122.92622, 38.21025]]]} | No Public Access 3 | Walker Creek Marsh | 32346 | 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 | 13.477 | Walker Creek Marsh | ||
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 | ||
398 | 398 | 397 | {"type": "Polygon", "coordinates": [[[-121.45171, 37.99673], [-121.45157, 37.99753], [-121.45125, 37.99803], [-121.44772, 37.99697], [-121.449, 37.99516], [-121.45045, 37.99469], [-121.45112, 37.99482], [-121.4517, 37.99592], [-121.45175, 37.99649], [-121.45171, 37.99673]]]} | No Public Access 3 | Acker Island | 32009 | 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 | 20.964 | Acker Island | ||
14487 | 14487 | 14486 | {"type": "MultiPolygon", "coordinates": [[[[-120.61073, 39.50453], [-120.61064, 39.50618], [-120.60842, 39.50617], [-120.6085, 39.50449], [-120.61073, 39.50453]]], [[[-120.61327, 39.51192], [-120.61072, 39.51188], [-120.61068, 39.50845], [-120.6132, 39.50845], [-120.61323, 39.51019], [-120.61327, 39.51192]]]]} | No Public Access 3 | Macklin Creek Ecological Reserve | 32211 | 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.455 | Macklin Creek ER | ||
1130 | 1130 | 1129 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05444], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05364], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | Escondido Creek | 32162 | 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.517 | Escondido Creek | ||
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 |
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]);