units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where ACCESS_TYP = 3, AGNCY_NAME = 25, DES_TP = 55 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- State Agency 61
MNG_AGENCY 1
- California Department of Fish and Wildlife · 61 ✖
DES_TP 1
- State Resource Management Area · 61 ✖
ACCESS_TYP 1
- No Public Access · 61 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 1130 | 1130 | 1129 | {"type": "Polygon", "coordinates": [[[-118.05045, 37.26696], [-118.05032, 37.28884], [-118.04578, 37.2888], [-118.0458, 37.28518], [-118.04122, 37.28514], [-118.04125, 37.28152], [-118.03671, 37.28148], [-118.03674, 37.27786], [-118.03221, 37.27783], [-118.0323, 37.26688], [-118.05045, 37.26696]]]} | No Public Access 3 | 6619 | Deep Springs Lake | 32146 | 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 | Inyo 43 | 725.874 | Deep Springs Lake | 0 | State Resource Management Area 55 | 3 | |
| 1362 | 1362 | 1361 | {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} | No Public Access 3 | 8074 | Pilobos | 32263 | 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 | Fresno 9 | 134.36 | Pilobos | 0 | State Resource Management Area 55 | 3 | |
| 1581 | 1581 | 1580 | {"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.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]} | No Public Access 3 | 12128 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Riverside 10 | 66.962 | Chuckwalla Bench | 0 | State Resource Management Area 55 | 3 | |
| 1949 | 1949 | 1948 | {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} | No Public Access 3 | 16653 | Elk Hills | 32158 | 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 | Kern 36 | 517.552 | Elk Hills | 0 | State Resource Management Area 55 | 3 | |
| 1956 | 1956 | 1955 | {"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]} | No Public Access 3 | 16665 | Indian Wells Valley | 32190 | 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 | Kern 36 | 201.555 | Indian Wells Valley | 0 | State Resource Management Area 55 | 3 | |
| 2417 | 2417 | 2416 | {"type": "Polygon", "coordinates": [[[-120.82613, 36.92597], [-120.81978, 36.92585], [-120.82012, 36.91517], [-120.82491, 36.91943], [-120.82613, 36.92597]]]} | No Public Access 3 | 17273 | Dos Amigos | 32151 | 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 | Merced 37 | 114.925 | Dos Amigos | 0 | State Resource Management Area 55 | 3 | |
| 2428 | 2428 | 2427 | {"type": "MultiPolygon", "coordinates": [[[[-120.39692, 37.50741], [-120.39664, 37.51843], [-120.39339, 37.51813], [-120.39035, 37.51702], [-120.3889, 37.51665], [-120.38848, 37.51633], [-120.3843, 37.51606], [-120.38436, 37.5155], [-120.38449, 37.51059], [-120.38471, 37.51053], [-120.38563, 37.51016], [-120.38827, 37.50854], [-120.3895, 37.50769], [-120.39086, 37.50715], [-120.39629, 37.50707], [-120.39692, 37.50741]]], [[[-120.39693, 37.50636], [-120.39692, 37.50692], [-120.39645, 37.50666], [-120.39073, 37.50674], [-120.38921, 37.50734], [-120.38794, 37.50822], [-120.38536, 37.50981], [-120.3845, 37.51015], [-120.38462, 37.50621], [-120.39333, 37.50635], [-120.39693, 37.50636]]]]} | No Public Access 3 | 17291 | Merced River | 32217 | 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 | Merced 37 | 311.747 | Merced River | 0 | State Resource Management Area 55 | 3 | |
| 2481 | 2481 | 2480 | {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} | No Public Access 3 | 17478 | Bend Ferry Road | 32047 | 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 | 45.388 | Bend Ferry Road | 0 | State Resource Management Area 55 | 3 | |
| 3147 | 3147 | 3146 | {"type": "MultiPolygon", "coordinates": [[[[-120.81642, 38.5584], [-120.8161, 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]]]]} | No Public Access 3 | 21619 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Amador 52 | 15.616 | Upper Cosumnes River | 0 | State Resource Management Area 55 | 3 | |
| 3167 | 3167 | 3166 | {"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06235], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06235], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.6851, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10573], [-116.6938, 34.10576]]]]} | No Public Access 3 | 21980 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 2202.531 | Mission Creek | 0 | State Resource Management Area 55 | 3 | |
| 3296 | 3296 | 3295 | {"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 | 23599 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 63.899 | Christensen Road Burrowing Owl Site | 0 | State Resource Management Area 55 | 3 | |
| 3427 | 3427 | 3426 | {"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 | 25174 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
| 3439 | 3439 | 3438 | {"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 | 25252 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 115.534 | Ord Rodman | 0 | State Resource Management Area 55 | 3 | |
| 3442 | 3442 | 3441 | {"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96193, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]} | No Public Access 3 | 25256 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Del Norte 50 | 120.393 | Stoney Creek | 0 | State Resource Management Area 55 | 3 | |
| 3485 | 3485 | 3484 | {"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 | 25904 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 4.076 | Bodega Bay Monarch Butterfly | 0 | State Resource Management Area 55 | 3 | |
| 3489 | 3489 | 3488 | {"type": "Polygon", "coordinates": [[[-121.97758, 37.42901], [-121.97746, 37.43245], [-121.97438, 37.4325], [-121.97433, 37.42904], [-121.97758, 37.42901]]]} | No Public Access 3 | 25900 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Clara 19 | 26.519 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
| 3490 | 3490 | 3489 | {"type": "MultiPolygon", "coordinates": [[[[-115.13976, 33.41494], [-115.13975, 33.4189], [-115.13539, 33.41889], [-115.13545, 33.41469], [-115.13976, 33.41494]]], [[[-115.19698, 33.413], [-115.18761, 33.41303], [-115.18762, 33.40954], [-115.1968, 33.40952], [-115.19681, 33.40939], [-115.19685, 33.40941], [-115.19698, 33.413]]], [[[-115.21504, 33.39466], [-115.20553, 33.39498], [-115.20542, 33.3912], [-115.21496, 33.39121], [-115.21504, 33.39466]]]]} | No Public Access 3 | 25902 | Tabaseca | 32324 | 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 | Imperial 20 | 215.634 | Tabaseca | 0 | State Resource Management Area 55 | 3 | |
| 3491 | 3491 | 3490 | {"type": "MultiPolygon", "coordinates": [[[[-119.50998, 35.36521], [-119.50076, 35.36536], [-119.50076, 35.36145], [-119.50129, 35.36134], [-119.50218, 35.36122], [-119.50274, 35.36122], [-119.50324, 35.36126], [-119.50374, 35.36134], [-119.50422, 35.36146], [-119.50467, 35.36161], [-119.50529, 35.36191], [-119.50667, 35.36283], [-119.50706, 35.36313], [-119.50998, 35.36521]]], [[[-119.63933, 35.48483], [-119.63646, 35.48481], [-119.63652, 35.47193], [-119.63789, 35.47208], [-119.63786, 35.47474], [-119.63778, 35.47861], [-119.63933, 35.48483]]]]} | No Public Access 3 | 25905 | California Aqueduct, Region 4 | 32081 | 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 | Kern 36 | 118.425 | California Aqueduct, Region 4 | 0 | State Resource Management Area 55 | 3 | |
| 3675 | 3675 | 3674 | {"type": "Polygon", "coordinates": [[[-117.5972, 33.67495], [-117.59564, 33.67532], [-117.59561, 33.6788], [-117.59438, 33.67879], [-117.59174, 33.67873], [-117.59136, 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.59716, 33.67436], [-117.5972, 33.67495]]]} | No Public Access 3 | 44353 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Orange 3 | 112.275 | Trabuco Canyon | 0 | State Resource Management Area 55 | 3 |
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]);