units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
159 rows where DES_TP = 55 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST
ACCESS_TYP 4
MNG_AGENCY 3
MNG_AG_TYP 1
- State Agency 159
DES_TP 1
- State Resource Management Area · 159 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5105 | 5105 | 5104 | {"type": "Polygon", "coordinates": [[[-123.68414, 40.48042], [-123.67906, 40.48126], [-123.66993, 40.48271], [-123.67004, 40.47815], [-123.6746, 40.47741], [-123.67492, 40.47444], [-123.67959, 40.47359], [-123.67921, 40.47671], [-123.68403, 40.47602], [-123.68414, 40.48042]]]} | No Public Access 3 | 48240 | McClellan Mountain Peatland | 32798 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 180.409 | McClellan Mtn. Peatland | 2017 | State Resource Management Area 55 | 3 | |
14803 | 14803 | 14802 | {"type": "MultiPolygon", "coordinates": [[[[-116.17464, 32.69733], [-116.15733, 32.69758], [-116.15691, 32.68285], [-116.17365, 32.68294], [-116.17464, 32.69733]]], [[[-116.67842, 32.77602], [-116.67832, 32.78694], [-116.67406, 32.78701], [-116.67408, 32.77962], [-116.67412, 32.77604], [-116.67842, 32.77602]]]]} | Open Access 1 | 45219 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Diego 4 | 757.572 | SLC | 0 | State Resource Management Area 55 | 3 | |
14660 | 14660 | 14659 | {"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 | 44923 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 10.115 | Twentynine Palms - Valle Vista Road | 0 | State Resource Management Area 55 | 3 | |
14659 | 14659 | 14658 | {"type": "MultiPolygon", "coordinates": [[[[-118.941, 35.42402], [-118.94048, 35.42386], [-118.94016, 35.42372], [-118.9391, 35.42317], [-118.93871, 35.42304], [-118.93844, 35.423], [-118.93803, 35.42298], [-118.93734, 35.42304], [-118.93692, 35.42306], [-118.9365, 35.42306], [-118.93576, 35.42302], [-118.93528, 35.42301], [-118.9348, 35.42302], [-118.93432, 35.42305], [-118.93431, 35.4198], [-118.94097, 35.41976], [-118.941, 35.42402]]], [[[-118.941, 35.42419], [-118.941, 35.42531], [-118.93974, 35.42582], [-118.93948, 35.4254], [-118.93905, 35.42554], [-118.93874, 35.42561], [-118.937, 35.42582], [-118.93641, 35.42595], [-118.93585, 35.42613], [-118.93532, 35.42637], [-118.93499, 35.42656], [-118.93433, 35.42702], [-118.93432, 35.42322], [-118.9348, 35.42319], [-118.93527, 35.42317], [-118.93575, 35.42318], [-118.93649, 35.42323], [-118.93692, 35.42323], [-118.93736, 35.42321], [-118.93804, 35.42314], [-118.93829, 35.42315], [-118.93854, 35.42318], [-118.93878, 35.42323], [-118.93901, 35.42331], [-118.9399, 35.42379], [-118.94025, 35.42395], [-118.94062, 35.42408], [-118.941, 35.42419]]]]} | Restricted Access 2 | 44922 | Bakersfield | 15768 | 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 | 98.585 | Bakersfield | 0 | State Resource Management Area 55 | 3 | |
16574 | 16574 | 16573 | {"type": "MultiPolygon", "coordinates": [[[[-114.95504, 33.26685], [-114.93776, 33.26689], [-114.93775, 33.26702], [-114.93746, 33.26702], [-114.93746, 33.26668], [-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 | 44921 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Imperial 20 | 990.532 | Smoketree Valley - Chocolate Mtns. | 0 | State Resource Management Area 55 | 3 | |
14618 | 14618 | 14617 | {"type": "Polygon", "coordinates": [[[-115.71453, 35.03003], [-115.71447, 35.04386], [-115.69802, 35.04386], [-115.69803, 35.03], [-115.71453, 35.03003]]]} | Restricted Access 2 | 44845 | California State Lands Commission | 16725 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 570.632 | SLC | 0 | State Resource Management Area 55 | 3 | |
15765 | 15765 | 15764 | {"type": "MultiPolygon", "coordinates": [[[[-115.41577, 33.9071], [-115.41501, 33.90797], [-115.41501, 33.90797], [-115.41501, 33.90709], [-115.41577, 33.9071]]], [[[-115.42113, 33.90913], [-115.42096, 33.90966], [-115.42064, 33.90959], [-115.418, 33.91076], [-115.41661, 33.91075], [-115.42056, 33.909], [-115.42113, 33.90913]]], [[[-115.42044, 33.90739], [-115.41978, 33.90743], [-115.41945, 33.9035], [-115.42011, 33.90351], [-115.42044, 33.90739]]]]} | Open Access 1 | 44795 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Riverside 10 | 13.226 | SLC | 0 | State Resource Management Area 55 | 3 | |
15513 | 15513 | 15512 | {"type": "Polygon", "coordinates": [[[-121.03855, 39.55161], [-121.03816, 39.55198], [-121.0378, 39.55215], [-121.03733, 39.55232], [-121.03708, 39.55244], [-121.03705, 39.55083], [-121.03851, 39.55084], [-121.03849, 39.55098], [-121.0385, 39.5513], [-121.03855, 39.55161]]]} | Open Access 1 | 44776 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Sierra 58 | 4.373 | SLC | 0 | State Resource Management Area 55 | 3 | |
16867 | 16867 | 16866 | {"type": "Polygon", "coordinates": [[[-121.04176, 39.55452], [-121.0371, 39.55445], [-121.03708, 39.55244], [-121.03733, 39.55232], [-121.0378, 39.55215], [-121.03816, 39.55198], [-121.03855, 39.55162], [-121.0385, 39.5513], [-121.03849, 39.55097], [-121.03851, 39.55084], [-121.03854, 39.55083], [-121.04171, 39.55088], [-121.04176, 39.55452]]]} | Open Access 1 | 44775 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Yuba 25 | 35.62 | SLC | 0 | State Resource Management Area 55 | 3 | |
16863 | 16863 | 16862 | {"type": "MultiPolygon", "coordinates": [[[[-120.09215, 35.07196], [-120.08828, 35.07201], [-120.08808, 35.06832], [-120.09206, 35.06824], [-120.09215, 35.07196]]], [[[-120.10135, 35.06803], [-120.09724, 35.0681], [-120.09722, 35.06445], [-120.10124, 35.06441], [-120.10135, 35.06803]]]]} | Open Access 1 | 44774 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Barbara 7 | 73.387 | SLC | 0 | State Resource Management Area 55 | 3 | |
16862 | 16862 | 16861 | {"type": "Polygon", "coordinates": [[[-121.36711, 40.14473], [-121.3671, 40.15548], [-121.36417, 40.15546], [-121.36414, 40.14476], [-121.36711, 40.14473]]]} | Open Access 1 | 44773 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Plumas 57 | 73.975 | SLC | 0 | State Resource Management Area 55 | 3 | |
16424 | 16424 | 16423 | {"type": "Polygon", "coordinates": [[[-120.75625, 39.34502], [-120.75579, 39.34604], [-120.74658, 39.34587], [-120.74638, 39.34242], [-120.75565, 39.34249], [-120.7561, 39.34484], [-120.75625, 39.34502]]]} | Open Access 1 | 44772 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Nevada 30 | 78.319 | SLC | 0 | State Resource Management Area 55 | 3 | |
16834 | 16834 | 16833 | {"type": "Polygon", "coordinates": [[[-119.9027, 37.22836], [-119.90274, 37.22877], [-119.90272, 37.22927], [-119.90266, 37.22968], [-119.90248, 37.23018], [-119.9021, 37.23082], [-119.90181, 37.23124], [-119.9015, 37.23159], [-119.90102, 37.23201], [-119.90008, 37.2326], [-119.89985, 37.23279], [-119.89973, 37.23295], [-119.89961, 37.23347], [-119.89943, 37.23413], [-119.89898, 37.2347], [-119.89853, 37.23526], [-119.89787, 37.23589], [-119.89667, 37.23681], [-119.8961, 37.23705], [-119.89555, 37.23721], [-119.89432, 37.2372], [-119.89379, 37.23705], [-119.89303, 37.23669], [-119.89233, 37.23613], [-119.89202, 37.23595], [-119.89153, 37.23577], [-119.89115, 37.23556], [-119.89085, 37.23549], [-119.8906, 37.23546], [-119.89015, 37.23545], [-119.88983, 37.23546], [-119.88925, 37.23573], [-119.88862, 37.23611], [-119.88862, 37.23476], [-119.88945, 37.23437], [-119.89016, 37.23435], [-119.89074, 37.23437], [-119.89115, 37.23442], [-119.89175, 37.23456], [-119.8922, 37.23481], [-119.89273, 37.235], [-119.89323, 37.23531], [-119.89388, 37.23582], [-119.89438, 37.23605], [-119.89457, 37.23611], [-119.89531, 37.23611], [-119.89554, 37.23604], [-119.89585, 37.23591], [-119.89687, 37.23514], [-119.89742, 37.23461], [-119.89813, 37.23372], [-119.89826, 37.23325], [-119.89842, 37.23256], [-119.89874, 37.23213], [-119.89915, 37.23179], [-119.90008, 37.2312], [-119.90042, 37.2309], [-119.90064, 37.23066], [-119.90087, 37.23032], [-119.90119, 37.22978], [-119.90131, 37.22946], [-119.90135, 37.22919], [-119.90137, 37.22879], [-119.90132, 37.22836], [-119.9027, 37.22836]]]} | Open Access 1 | 44771 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Madera 48 | 55.076 | SLC | 0 | State Resource Management Area 55 | 3 | |
4169 | 4169 | 4168 | {"type": "Polygon", "coordinates": [[[-118.14515, 34.4821], [-118.14512, 34.48211], [-118.14511, 34.48207], [-118.14435, 34.48228], [-118.14374, 34.48241], [-118.14324, 34.48247], [-118.1425, 34.48253], [-118.14203, 34.48261], [-118.14157, 34.48276], [-118.14072, 34.48318], [-118.14071, 34.48255], [-118.14128, 34.48233], [-118.14154, 34.48224], [-118.1419, 34.48215], [-118.14259, 34.48201], [-118.14311, 34.48194], [-118.14358, 34.48191], [-118.14389, 34.48186], [-118.14452, 34.48171], [-118.14514, 34.48153], [-118.14515, 34.4821]]]} | Open Access 1 | 44770 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Los Angeles 6 | 5.937 | SLC | 0 | State Resource Management Area 55 | 3 | |
12983 | 12983 | 12982 | {"type": "Polygon", "coordinates": [[[-119.01902, 36.735], [-119.019, 36.73858], [-119.01004, 36.73851], [-119.01008, 36.73493], [-119.01902, 36.735]]]} | Open Access 1 | 44769 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 78.552 | SLC | 0 | State Resource Management Area 55 | 3 | |
4168 | 4168 | 4167 | {"type": "MultiPolygon", "coordinates": [[[[-120.63132, 38.61416], [-120.63122, 38.61777], [-120.62662, 38.61765], [-120.62672, 38.61404], [-120.63132, 38.61416]]], [[[-120.67404, 38.69789], [-120.67403, 38.70149], [-120.67175, 38.70148], [-120.67176, 38.69788], [-120.67404, 38.69789]]], [[[-120.69234, 38.70875], [-120.69234, 38.71055], [-120.69004, 38.71055], [-120.69004, 38.70966], [-120.69119, 38.70965], [-120.69119, 38.70875], [-120.69234, 38.70875]]]]} | Open Access 1 | 44768 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | El Dorado 34 | 66.735 | SLC | 0 | State Resource Management Area 55 | 3 | |
16883 | 16883 | 16882 | {"type": "Polygon", "coordinates": [[[-120.15748, 38.50084], [-120.15296, 38.5007], [-120.15273, 38.49714], [-120.15729, 38.49728], [-120.15748, 38.50084]]]} | Open Access 1 | 44767 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Amador 52 | 38.652 | SLC | 0 | State Resource Management Area 55 | 3 | |
16362 | 16362 | 16361 | {"type": "Polygon", "coordinates": [[[-119.89135, 38.76567], [-119.89129, 38.77295], [-119.88657, 38.7729], [-119.88658, 38.76567], [-119.89135, 38.76567]]]} | Open Access 1 | 44766 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Alpine 51 | 82.078 | SLC | 0 | State Resource Management Area 55 | 3 | |
16884 | 16884 | 16883 | {"type": "MultiPolygon", "coordinates": [[[[-122.47891, 39.46355], [-122.474, 39.46343], [-122.47401, 39.46002], [-122.47886, 39.45995], [-122.47891, 39.46355]]], [[[-122.52365, 39.42486], [-122.52357, 39.42844], [-122.5154, 39.42808], [-122.51541, 39.42447], [-122.52365, 39.42486]]], [[[-122.56097, 39.41438], [-122.55686, 39.41429], [-122.55682, 39.41062], [-122.55196, 39.41049], [-122.55189, 39.40698], [-122.55679, 39.40694], [-122.55683, 39.41061], [-122.56095, 39.41074], [-122.56097, 39.41438]]], [[[-122.60138, 39.4653], [-122.59646, 39.46527], [-122.59542, 39.45786], [-122.60048, 39.45797], [-122.60138, 39.4653]]]]} | Unknown Access 4 | 44765 | California State Lands Commission | 16726 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Glenn 55 | 273.89 | SLC | 0 | State Resource Management Area 55 | 3 | |
16357 | 16357 | 16356 | {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} | Open Access 1 | 44763 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 242.067 | SLC | 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]);