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)
ACCESS_TYP 4
MNG_AGENCY 3
MNG_AG_TYP 1
- State Agency 139
DES_TP 1
- State Resource Management Area · 139 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
10291 | 10291 | 10290 | {"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.32279, 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.31944, 38.17418], [-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.3206, 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.17145], [-121.3227, 38.17127], [-121.32253, 38.17112], [-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.32344, 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.31981, 38.1688], [-121.31971, 38.16885], [-121.31956, 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.31472, 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.32062, 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 | 18085 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 18.457 | Mokelumne River | 0 | State Resource Management Area 55 | 3 | |
5484 | 5484 | 5483 | {"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 | 18030 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 20.966 | Acker Island | 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 | |
7132 | 7132 | 7131 | {"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]} | Open Access 1 | 6750 | Avocado Lake | 32030 | 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 | 29.362 | Avocado Lake | 0 | State Resource Management Area 55 | 3 | |
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-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.05363], [-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 | 44356 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 29.504 | Escondido Creek | 0 | State Resource Management Area 55 | 3 | |
11553 | 11553 | 11552 | {"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 | 23604 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 29.9 | Mtn. Sheep Watering Area | 0 | State Resource Management Area 55 | 3 | |
11551 | 11551 | 11550 | {"type": "MultiPolygon", "coordinates": [[[[-120.48135, 37.664], [-120.48132, 37.6642], [-120.48125, 37.66437], [-120.4811, 37.66452], [-120.48045, 37.66487], [-120.48026, 37.66491], [-120.48014, 37.66503], [-120.48008, 37.66532], [-120.48024, 37.66591], [-120.48028, 37.66614], [-120.4798, 37.66635], [-120.47901, 37.66496], [-120.4796, 37.66459], [-120.48005, 37.664], [-120.48135, 37.664]]], [[[-120.4855, 37.66112], [-120.48408, 37.66265], [-120.48188, 37.66423], [-120.48187, 37.66342], [-120.48365, 37.66179], [-120.48456, 37.66139], [-120.4855, 37.66112]]], [[[-120.49114, 37.6524], [-120.49083, 37.65283], [-120.48841, 37.65436], [-120.48773, 37.65488], [-120.48736, 37.65553], [-120.48638, 37.65828], [-120.48687, 37.65881], [-120.48684, 37.65947], [-120.48661, 37.65996], [-120.48558, 37.66106], [-120.48505, 37.66093], [-120.48574, 37.65927], [-120.48583, 37.65912], [-120.48578, 37.65798], [-120.48685, 37.65542], [-120.48765, 37.65458], [-120.48824, 37.6535], [-120.48889, 37.65314], [-120.48929, 37.65245], [-120.49114, 37.6524]]]]} | No Public Access 3 | 23600 | Basso Bridge | 32041 | 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 | Stanislaus 2 | 31.439 | Basso Bridge | 0 | State Resource Management Area 55 | 3 | |
11554 | 11554 | 11553 | {"type": "MultiPolygon", "coordinates": [[[[-120.46637, 37.67093], [-120.46627, 37.67096], [-120.4649, 37.67043], [-120.46452, 37.67036], [-120.46422, 37.67034], [-120.46391, 37.67037], [-120.46374, 37.67043], [-120.46357, 37.67055], [-120.46341, 37.67063], [-120.46314, 37.67068], [-120.46213, 37.67076], [-120.46214, 37.67027], [-120.46115, 37.67021], [-120.46377, 37.66765], [-120.46387, 37.66767], [-120.46572, 37.66924], [-120.46572, 37.67028], [-120.46573, 37.67039], [-120.46637, 37.67093]]], [[[-120.47, 37.67073], [-120.4698, 37.67089], [-120.46926, 37.67122], [-120.46909, 37.67148], [-120.46782, 37.67211], [-120.4673, 37.67142], [-120.46658, 37.67102], [-120.46658, 37.67092], [-120.46631, 37.67072], [-120.46592, 37.67012], [-120.46593, 37.6699], [-120.46681, 37.66927], [-120.46608, 37.66859], [-120.46725, 37.6686], [-120.4673, 37.67023], [-120.4681, 37.6702], [-120.46898, 37.67032], [-120.47, 37.67073]]]]} | No Public Access 3 | 23601 | Tuolumne River Restoration Center | 32331 | 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 | Stanislaus 2 | 33.932 | Tuolumne River Restoration Ctr. | 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 | |
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 | |
3677 | 3677 | 3676 | {"type": "Polygon", "coordinates": [[[-118.24726, 36.83321], [-118.24275, 36.83325], [-118.24273, 36.82962], [-118.24642, 36.8296], [-118.24725, 36.8304], [-118.24726, 36.83321]]]} | Open Access 1 | 44355 | Mount Whitney Facility | 32237 | 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 | 39.204 | Mount Whitney Facility | 0 | State Resource Management Area 55 | 3 | |
6562 | 6562 | 6561 | {"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.55564], [-122.37337, 40.55586], [-122.37338, 40.55617], [-122.37197, 40.55594], [-122.37218, 40.55527], [-122.37348, 40.55551]]]]} | No Public Access 3 | 3435 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 40.985 | Sacramento River -- Redding | 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 | |
2853 | 2853 | 2852 | {"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]} | Open Access 1 | 22154 | Mill Creek | 32219 | 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 | Mendocino 24 | 49.861 | Mill Creek | 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 | |
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 | |
16593 | 16593 | 16592 | {"type": "MultiPolygon", "coordinates": [[[[-122.5586, 38.6838], [-122.55473, 38.68451], [-122.55398, 38.68451], [-122.55398, 38.68085], [-122.55859, 38.68086], [-122.5586, 38.6838]]], [[[-122.58595, 38.67705], [-122.58595, 38.67735], [-122.57684, 38.67946], [-122.57685, 38.67727], [-122.58595, 38.67705]]]]} | Open Access 1 | 44758 | 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 | Napa 11 | 64.112 | SLC | 0 | State Resource Management Area 55 | 3 | |
16840 | 16840 | 16839 | {"type": "MultiPolygon", "coordinates": [[[[-119.76601, 36.91962], [-119.7636, 36.92003], [-119.76289, 36.9203], [-119.76261, 36.91997], [-119.76318, 36.91981], [-119.76576, 36.919], [-119.76601, 36.91962]]], [[[-119.76278, 36.92035], [-119.76224, 36.92064], [-119.75912, 36.92058], [-119.75532, 36.92228], [-119.75435, 36.92355], [-119.75383, 36.9233], [-119.75406, 36.92285], [-119.75457, 36.92223], [-119.7565, 36.92094], [-119.7579, 36.92044], [-119.75879, 36.92034], [-119.7601, 36.91999], [-119.76219, 36.92011], [-119.76246, 36.92003], [-119.76278, 36.92035]]], [[[-119.7554, 36.93223], [-119.7545, 36.93259], [-119.75399, 36.93406], [-119.75335, 36.93405], [-119.75361, 36.93256], [-119.75229, 36.93156], [-119.75185, 36.9301], [-119.75138, 36.92834], [-119.75133, 36.92752], [-119.75223, 36.92685], [-119.75258, 36.92621], [-119.75267, 36.92492], [-119.75326, 36.92447], [-119.75379, 36.9234], [-119.75425, 36.92364], [-119.75347, 36.9264], [-119.75359, 36.92689], [-119.75403, 36.92733], [-119.75444, 36.92871], [-119.75448, 36.92903], [-119.75459, 36.92926], [-119.755, 36.92976], [-119.75507, 36.93094], [-119.7554, 36.93223]]]]} | Open Access 1 | 16689 | 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 | 65.906 | 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 |
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]);