units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
159 rows where DES_TP = 55 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_ID, YR_EST
AGNCY_NAME 4 ✖
ACCESS_TYP 4
MNG_AGENCY 3
LAYER 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
6173 | 6173 | 6172 | {"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 | 1204 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 0.833 | Stinson Beach | 0 | State Resource Management Area 55 | 3 | |
14340 | 14340 | 14339 | {"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 | 44373 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 1.02 | Escalona Gulch | 0 | State Resource Management Area 55 | 3 | |
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 | |
3437 | 3437 | 3436 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | 25245 | Rutherford Crossroad | 32278 | 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 | Napa 11 | 1.213 | Rutherford Crossroad | 0 | State Resource Management Area 55 | 3 | |
12572 | 12572 | 12571 | {"type": "Polygon", "coordinates": [[[-117.69973, 33.97316], [-117.6997, 33.97405], [-117.6991, 33.97403], [-117.6991, 33.97333], [-117.69894, 33.97306], [-117.69971, 33.97306], [-117.69971, 33.97316], [-117.69973, 33.97316]]]} | Restricted Access 2 | 29090 | Chino Fish & Wildlife Base | 17207 | 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 | 1.585 | Chino Fish & Wildlife Base | 0 | State Resource Management Area 55 | 3 | |
12266 | 12266 | 12265 | {"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 | 25910 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Modoc 56 | 3.56 | Newell Creek Cabin Site | 0 | State Resource Management Area 55 | 3 | |
4842 | 4842 | 4841 | {"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 | 2140 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Lake 40 | 3.761 | Monitor Island | 0 | State Resource Management Area 55 | 3 | |
5245 | 5245 | 5244 | {"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 | 1341 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 4.018 | Klamathon Station | 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 | |
7673 | 7673 | 7672 | {"type": "Polygon", "coordinates": [[[-120.99914, 40.31163], [-120.99859, 40.31171], [-120.99851, 40.31129], [-120.99668, 40.31149], [-120.9969, 40.31103], [-120.99705, 40.31094], [-120.99856, 40.31086], [-120.99813, 40.31023], [-120.99861, 40.31003], [-120.99911, 40.31023], [-120.99914, 40.31163]]]} | No Public Access 3 | 7584 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Lassen 54 | 4.353 | Mtn. Meadows | 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 | |
10020 | 10020 | 10019 | {"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.28032, 37.25511], [-120.28065, 37.25511], [-120.28166, 37.25478]]]} | No Public Access 3 | 17278 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 4.88 | Le Grand | 0 | State Resource Management Area 55 | 3 | |
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-122.064, 36.98385], [-122.06366, 36.98401], [-122.06267, 36.98408], [-122.06257, 36.98463], [-122.06235, 36.98486], [-122.06189, 36.98495], [-122.06155, 36.98351], [-122.06155, 36.98317], [-122.06189, 36.98305], [-122.06343, 36.98349], [-122.06394, 36.98377], [-122.064, 36.98385]]]} | Open Access 1 | 23588 | 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 Cruz 5 | 5.72 | 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 | |
12567 | 12567 | 12566 | {"type": "Polygon", "coordinates": [[[-116.80776, 34.25506], [-116.80546, 34.25503], [-116.80552, 34.25267], [-116.80555, 34.25223], [-116.80581, 34.25222], [-116.80587, 34.25399], [-116.8077, 34.25401], [-116.80776, 34.25506]]]} | No Public Access 3 | 29074 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 7.409 | Shay Meadow | 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 | |
10442 | 10442 | 10441 | {"type": "MultiPolygon", "coordinates": [[[[-121.13401, 39.37997], [-121.1337, 39.38361], [-121.13238, 39.38371], [-121.13257, 39.38008], [-121.13401, 39.37997]]], [[[-121.59067, 39.13306], [-121.59041, 39.13391], [-121.58999, 39.13382], [-121.59013, 39.13324], [-121.59017, 39.13271], [-121.59067, 39.13306]]]]} | Open Access 1 | 18454 | 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 | 12.838 | 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 | |
13181 | 13181 | 13180 | {"type": "Polygon", "coordinates": [[[-122.92622, 38.21025], [-122.92607, 38.2121], [-122.9261, 38.21451], [-122.92537, 38.21453], [-122.92543, 38.21398], [-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.92562, 38.21043], [-122.92581, 38.21043], [-122.92581, 38.21025], [-122.92622, 38.21025]]]} | No Public Access 3 | 35164 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 13.468 | Walker Creek Marsh | 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]);