units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where AGNCY_NAME = 1, DES_TP = 39 and MNG_AGENCY = 47
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME, YR_EST
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 4 ✖
DES_TP 1
- State Recreation Area · 4 ✖
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4175 | 4175 | 4174 | {"type": "MultiPolygon", "coordinates": [[[[-121.34357, 39.54165], [-121.33767, 39.54159], [-121.33769, 39.53955], [-121.34321, 39.54152], [-121.34357, 39.54165]]], [[[-121.41825, 39.56249], [-121.41422, 39.5629], [-121.41348, 39.56278], [-121.41163, 39.56256], [-121.41579, 39.55857], [-121.41747, 39.55908], [-121.41799, 39.55862], [-121.41825, 39.56249]]], [[[-121.49634, 39.67479], [-121.49548, 39.67617], [-121.49291, 39.67618], [-121.49263, 39.67617], [-121.49633, 39.6734], [-121.49634, 39.67479]]], [[[-121.52423, 39.66869], [-121.52134, 39.6687], [-121.52132, 39.66858], [-121.51759, 39.66558], [-121.51824, 39.66518], [-121.52423, 39.66869]]]]} | Open Access 1 | 44830 | Lake Oroville State Recreation Area | 13764 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=462 | Butte 42 | 83.057 | Lake Oroville SRA | 1967 | State Recreation Area 39 | 4 |
| 13005 | 13005 | 13004 | {"type": "MultiPolygon", "coordinates": [[[[-120.83322, 38.99532], [-120.83267, 39.00771], [-120.83007, 39.0056], [-120.82893, 39.00651], [-120.82912, 39.00831], [-120.82359, 39.00758], [-120.82368, 39.00413], [-120.8223, 39.0027], [-120.82037, 39.00252], [-120.81866, 39.00506], [-120.81844, 39.00705], [-120.81502, 39.0067], [-120.81502, 39.00196], [-120.80908, 39.00197], [-120.80979, 39.00145], [-120.81161, 39.0002], [-120.8118, 39.00014], [-120.81198, 39.00013], [-120.81233, 39.00003], [-120.81266, 39.00002], [-120.81318, 38.99967], [-120.81341, 38.99946], [-120.81349, 38.99935], [-120.81362, 38.99923], [-120.81382, 38.99902], [-120.8141, 38.99862], [-120.81425, 38.99819], [-120.8144, 38.99755], [-120.81441, 38.99738], [-120.81448, 38.99705], [-120.81447, 38.99644], [-120.81457, 38.99604], [-120.81469, 38.9958], [-120.81503, 38.99536], [-120.81506, 38.99893], [-120.81967, 38.99893], [-120.81968, 38.99525], [-120.81508, 38.99529], [-120.81516, 38.99514], [-120.81534, 38.99494], [-120.81779, 38.9941], [-120.81832, 38.99401], [-120.81906, 38.9941], [-120.8193, 38.99409], [-120.8196, 38.99412], [-120.81989, 38.99412], [-120.82017, 38.99407], [-120.82075, 38.99392], [-120.82101, 38.99389], [-120.82127, 38.99385], [-120.82245, 38.99359], [-120.82332, 38.99333], [-120.82377, 38.99316], [-120.82403, 38.99306], [-120.82465, 38.99275], [-120.82521, 38.99241], [-120.82662, 38.99135], [-120.82816, 38.99007], [-120.8286, 38.98954], [-120.82883, 38.98923], [-120.82941, 38.98823], [-120.82952, 38.98792], [-120.82964, 38.98775], [-120.82969, 38.99407], [-120.82505, 38.99404], [-120.82505, 38.99527], [-120.83322, 38.99532]]], [[[-120.86721, 38.95428], [-120.86608, 38.95665], [-120.85837, 38.95707], [-120.85833, 38.96013], [-120.85828, 38.96625], [-120.85541, 38.96626], [-120.85376, 38.96325], [-120.85311, 38.9619], [-120.85322, 38.96025], [-120.85553, 38.95796], [-120.85638, 38.95747], [-120.85669, 38.95735], [-120.85704, 38.95711], [-120.85718, 38.95705], [-120.85754, 38.95674], [-120.85784, 38.95636], [-120.85794, 38.95602], [-120.85804, 38.95557], [-120.85814, 38.95533], [-120.85834, 38.9549], [-120.8584, 38.95461], [-120.85845, 38.95416], [-120.85911, 38.95332], [-120.86027, 38.95273], [-120.86149, 38.95291], [-120.86206, 38.95315], [-120.86212, 38.95322], [-120.86266, 38.95351], [-120.86284, 38.95367], [-120.86304, 38.95392], [-120.86337, 38.9542], [-120.86377, 38.95439], [-120.86393, 38.95443], [-120.86464, 38.9543], [-120.86513, 38.95414], [-120.8654, 38.95408], [-120.86574, 38.95399], [-120.86606, 38.95399], [-120.86721, 38.95428]]], [[[-120.93406, 38.97107], [-120.9169, 38.96814], [-120.91662, 38.97177], [-120.91149, 38.97072], [-120.91101, 38.9743], [-120.90818, 38.97431], [-120.90848, 38.97069], [-120.89802, 38.97058], [-120.89797, 38.97415], [-120.89587, 38.9741], [-120.89405, 38.972], [-120.89404, 38.96675], [-120.8958, 38.96678], [-120.8958, 38.96323], [-120.89911, 38.96333], [-120.89806, 38.96682], [-120.89806, 38.96683], [-120.91195, 38.96713], [-120.91358, 38.95715], [-120.91357, 38.95714], [-120.89813, 38.95709], [-120.8981, 38.95975], [-120.89351, 38.95957], [-120.89353, 38.96316], [-120.89293, 38.96314], [-120.89192, 38.96039], [-120.89148, 38.9631], [-120.88858, 38.96302], [-120.88859, 38.96454], [-120.88754, 38.96453], [-120.88724, 38.96301], [-120.88668, 38.96044], [-120.88584, 38.96011], [-120.88432, 38.96298], [-120.88362, 38.96413], [-120.8851, 38.96657], [-120.87074, 38.96628], [-120.87521, 38.95643], [-120.87584, 38.95652], [-120.87605, 38.95661], [-120.87688, 38.95688], [-120.87759, 38.95706], [-120.87801, 38.95706], [-120.87893, 38.957], [-120.87948, 38.95693], [-120.88051, 38.95691], [-120.8811, 38.95685], [-120.88187, 38.95688], [-120.88262, 38.95706], [-120.88321, 38.95733], [-120.88387, 38.95779], [-120.88441, 38.95828], [-120.88497, 38.95889], [-120.88528, 38.95916], [-120.88626, 38.95954], [-120.88723, 38.95979], [-120.88777, 38.95982], [-120.88828, 38.95979], [-120.88989, 38.95978], [-120.89036, 38.95972], [-120.89085, 38.95958], [-120.89131, 38.95939], [-120.89203, 38.95898], [-120.89356, 38.95822], [-120.89413, 38.95787], [-120.89515, 38.95705], [-120.89551, 38.9567], [-120.8961, 38.95617], [-120.89675, 38.95575], [-120.8982, 38.95487], [-120.89873, 38.9545], [-120.89902, 38.95429], [-120.89964, 38.95375], [-120.89991, 38.95347], [-120.90275, 38.95347], [-120.9032, 38.95362], [-120.90373, 38.95375], [-120.90422, 38.95383], [-120.90556, 38.95391], [-120.906, 38.95398], [-120.90662, 38.95399], [-120.90711, 38.95414], [-120.90831, 38.95423], [-120.90916, 38.9544], [-120.90999, 38.95467], [-120.91086, 38.95474], [-120.91167, 38.95487], [-120.9119, 38.95494], [-120.91241, 38.955], [-120.91324, 38.95513], [-120.91352, 38.95523], [-120.91393, 38.95532], [-120.91433, 38.95557], [-120.91456, 38.95565], [-120.9151, 38.95594], [-120.91563, 38.95618], [-120.91608, 38.9565], [-120.91683, 38.95714], [-120.91772, 38.95757], [-120.91827, 38.95779], [-120.91857, 38.95794], [-120.91922, 38.95814], [-120.91982, 38.9584], [-120.92013, 38.95858], [-120.92063, 38.95882], [-120.9211, 38.95917], [-120.92136, 38.95942], [-120.92177, 38.95987], [-120.92237, 38.96045], [-120.92268, 38.96065], [-120.92308, 38.96086], [-120.92421, 38.96134], [-120.92577, 38.96181], [-120.92643, 38.96195], [-120.92691, 38.96201], [-120.9273, 38.96209], [-120.9277, 38.96212], [-120.92795, 38.96217], [-120.92826, 38.96215], [-120.92802, 38.96249], [-120.92803, 38.9625], [-120.92992, 38.96314], [-120.93074, 38.96214], [-120.93109, 38.9621], [-120.9319, 38.96206], [-120.9322, 38.96209], [-120.93244, 38.96209], [-120.93267, 38.96214], [-120.93286, 38.96229], [-120.93305, 38.96238], [-120.93313, 38.96245], [-120.93365, 38.96315], [-120.93402, 38.9635], [-120.934, 38.96407], [-120.93406, 38.97107]]], [[[-120.93197, 39.07867], [-120.9316, 39.08591], [-120.91279, 39.08611], [-120.91305, 39.07795], [-120.91326, 39.07533], [-120.91351, 39.07174], [-120.91355, 39.07061], [-120.90077, 39.07009], [-120.9016, 39.05884], [-120.8978, 39.05867], [-120.89782, 39.05833], [-120.89695, 39.05829], [-120.89717, 39.0549], [-120.89258, 39.0547], [-120.8927, 39.03953], [-120.90184, 39.03984], [-120.90191, 39.04768], [-120.9065, 39.04787], [-120.90646, 39.0402], [-120.91108, 39.04056], [-120.9146, 39.04081], [-120.91432, 39.05563], [-120.91388, 39.06455], [-120.92328, 39.06438], [-120.92301, 39.07159], [-120.92265, 39.07879], [-120.93197, 39.07867]]], [[[-120.91024, 39.08517], [-120.90788, 39.08507], [-120.90793, 39.0869], [-120.90556, 39.0868], [-120.90551, 39.08496], [-120.90544, 39.08128], [-120.91013, 39.08149], [-120.91024, 39.08517]]], [[[-120.91769, 39.01319], [-120.91754, 39.02284], [-120.91514, 39.02296], [-120.91511, 39.01323], [-120.91769, 39.01319]]], [[[-120.92084, 39.00496], [-120.91607, 39.00548], [-120.91547, 39.00384], [-120.91547, 39.00384], [-120.92084, 39.00496]]], [[[-120.92816, 39.03497], [-120.92532, 39.03845], [-120.92352, 39.03759], [-120.92086, 39.04115], [-120.91906, 39.04029], [-120.92455, 39.03325], [-120.92816, 39.03497]]], [[[-120.93138, 39.09119], [-120.93133, 39.09253], [-120.93043, 39.09316], [-120.92753, 39.09311], [-120.92973, 39.09176], [-120.92871, 39.08982], [-120.9291, 39.08656], [-120.93121, 39.08664], [-120.93082, 39.08991], [-120.93138, 39.09119]]], [[[-120.93563, 39.00199], [-120.93321, 39.00208], [-120.93321, 39.00027], [-120.93561, 39.00019], [-120.93563, 39.00199]]], [[[-120.93825, 38.94755], [-120.93765, 38.94755], [-120.93765, 38.9472], [-120.93772, 38.94664], [-120.93786, 38.94613], [-120.93787, 38.94591], [-120.93784, 38.94541], [-120.93786, 38.94514], [-120.93784, 38.94458], [-120.93786, 38.94425], [-120.93794, 38.94396], [-120.93815, 38.94344], [-120.93819, 38.94328], [-120.93825, 38.94755]]], [[[-120.94299, 38.9511], [-120.94305, 38.95649], [-120.94278, 38.96361], [-120.94086, 38.96351], [-120.94113, 38.95649], [-120.93816, 38.95646], [-120.9381, 38.9561], [-120.9381, 38.95587], [-120.93798, 38.95442], [-120.93798, 38.9536], [-120.93793, 38.95238], [-120.93803, 38.9514], [-120.93801, 38.9511], [-120.94299, 38.9511]]], [[[-120.95487, 38.99245], [-120.95481, 38.99603], [-120.95248, 38.99603], [-120.95255, 38.99245], [-120.94297, 38.99267], [-120.94304, 38.98901], [-120.93826, 38.98908], [-120.93832, 38.98625], [-120.94246, 38.98739], [-120.94313, 38.98535], [-120.95271, 38.98529], [-120.95256, 38.99244], [-120.95487, 38.99245]]], [[[-120.95264, 38.96183], [-120.95076, 38.96242], [-120.94935, 38.96008], [-120.94819, 38.96043], [-120.94745, 38.9597], [-120.95122, 38.95946], [-120.95264, 38.96183]]], [[[-120.96172, 38.94219], [-120.95232, 38.94211], [-120.95206, 38.93885], [-120.95714, 38.93886], [-120.95735, 38.93896], [-120.95748, 38.93905], [-120.95763, 38.93912], [-120.95779, 38.93917], [-120.95788, 38.93911], [-120.95803, 38.93906], [-120.95827, 38.93886], [-120.95873, 38.93886], [-120.95855, 38.93856], [-120.95871, 38.93845], [-120.95899, 38.93819], [-120.95907, 38.93812], [-120.95978, 38.93866], [-120.96015, 38.93906], [-120.96072, 38.93855], [-120.96132, 38.93855], [-120.96172, 38.94219]]], [[[-120.98946, 38.9567], [-120.97095, 38.9567], [-120.97098, 38.97104], [-120.96151, 38.97105], [-120.96161, 38.96025], [-120.96628, 38.96027], [-120.96629, 38.95668], [-120.97094, 38.9567], [-120.97099, 38.95315], [-120.9713, 38.95309], [-120.98019, 38.95308], [-120.98018, 38.94946], [-120.98479, 38.94945], [-120.98477, 38.94401], [-120.98591, 38.944], [-120.9859, 38.94232], [-120.98611, 38.94219], [-120.9882, 38.94218], [-120.98821, 38.94399], [-120.98936, 38.94399], [-120.98946, 38.9567]]], [[[-120.96787, 38.93262], [-120.96426, 38.93345], [-120.96415, 38.93361], [-120.96407, 38.93354], [-120.96432, 38.93335], [-120.96446, 38.93321], [-120.96489, 38.93293], [-120.96543, 38.93281], [-120.96567, 38.93271], [-120.9659, 38.93264], [-120.96664, 38.93249], [-120.96708, 38.93249], [-120.96749, 38.93252], [-120.96787, 38.93262]]], [[[-120.97117, 38.93864], [-120.97112, 38.94227], [-120.96642, 38.94223], [-120.96625, 38.9386], [-120.97117, 38.93864]]], [[[-120.99422, 38.92761], [-120.99417, 38.93152], [-120.98952, 38.93132], [-120.98953, 38.93013], [-120.99206, 38.92861], [-120.99215, 38.92742], [-120.99422, 38.92761]]], [[[-120.99323, 38.92394], [-120.99192, 38.92537], [-120.99192, 38.92537], [-120.99197, 38.92459], [-120.99323, 38.92394]]], [[[-121.01448, 38.92069], [-121.00901, 38.92057], [-121.00898, 38.92146], [-121.00579, 38.92141], [-121.00398, 38.92139], [-121.0135, 38.9171], [-121.01357, 38.91715], [-121.01444, 38.91753], [-121.01449, 38.92054], [-121.01448, 38.92069]]], [[[-121.02004, 38.91837], [-121.01919, 38.91836], [-121.01894, 38.91854], [-121.01856, 38.91857], [-121.01787, 38.91856], [-121.01769, 38.91854], [-121.01752, 38.91844], [-121.01736, 38.91832], [-121.01675, 38.91835], [-121.01677, 38.91796], [-121.01699, 38.91798], [-121.01724, 38.91796], [-121.01772, 38.91808], [-121.0179, 38.91809], [-121.01828, 38.91819], [-121.01843, 38.91818], [-121.01863, 38.91821], [-121.01882, 38.91821], [-121.01974, 38.91803], [-121.02003, 38.91799], [-121.02004, 38.91837]]], [[[-121.02549, 38.91907], [-121.0254, 38.92062], [-121.02398, 38.9206], [-121.02405, 38.91941], [-121.02459, 38.91944], [-121.0249, 38.91942], [-121.02505, 38.91938], [-121.0252, 38.91931], [-121.02535, 38.91921], [-121.02549, 38.91907]]], [[[-121.0256, 38.91731], [-121.02552, 38.91854], [-121.02543, 38.91863], [-121.02518, 38.91894], [-121.0251, 38.91902], [-121.0249, 38.91913], [-121.02472, 38.91916], [-121.02406, 38.91914], [-121.02417, 38.91729], [-121.0256, 38.91731]]]]} | Open Access 1 | 44838 | Auburn State Recreation Area | 13795 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=502 | Placer 35 | 5077.257 | Auburn SRA | 1966 | State Recreation Area 39 | 4 |
| 16672 | 16672 | 16671 | {"type": "MultiPolygon", "coordinates": [[[[-121.05422, 38.85549], [-121.05405, 38.86268], [-121.04941, 38.86275], [-121.04962, 38.85556], [-121.05422, 38.85549]]], [[[-121.02631, 38.89583], [-121.02625, 38.89947], [-121.02156, 38.89945], [-121.02152, 38.89581], [-121.02631, 38.89583]]], [[[-121.04358, 38.89913], [-121.04342, 38.90274], [-121.03409, 38.90298], [-121.03419, 38.89938], [-121.04358, 38.89913]]], [[[-121.02823, 38.91021], [-121.02772, 38.91022], [-121.02775, 38.91005], [-121.02774, 38.90996], [-121.02772, 38.90985], [-121.02762, 38.90958], [-121.02762, 38.90951], [-121.02775, 38.90956], [-121.02786, 38.90966], [-121.02799, 38.90979], [-121.02811, 38.90998], [-121.02823, 38.91021]]], [[[-121.02932, 38.90671], [-121.02924, 38.91061], [-121.02864, 38.91023], [-121.02843, 38.90987], [-121.02829, 38.90964], [-121.02813, 38.90948], [-121.02797, 38.90935], [-121.0277, 38.90924], [-121.02752, 38.90924], [-121.02738, 38.90929], [-121.02729, 38.9094], [-121.02726, 38.90952], [-121.02728, 38.90963], [-121.02739, 38.90999], [-121.02739, 38.91013], [-121.02737, 38.91022], [-121.02578, 38.91024], [-121.02575, 38.9068], [-121.02932, 38.90671]]], [[[-121.01444, 38.91753], [-121.01357, 38.91715], [-121.0135, 38.9171], [-121.01377, 38.91697], [-121.01376, 38.91657], [-121.01444, 38.91669], [-121.01444, 38.91753]]], [[[-121.02003, 38.9175], [-121.02003, 38.91799], [-121.01974, 38.91803], [-121.01882, 38.91821], [-121.01862, 38.91821], [-121.01843, 38.91818], [-121.01828, 38.91819], [-121.0179, 38.91809], [-121.01772, 38.91808], [-121.01724, 38.91796], [-121.01699, 38.91798], [-121.01677, 38.91796], [-121.01676, 38.91788], [-121.01677, 38.91745], [-121.02003, 38.9175]]], [[[-121.00566, 38.91748], [-121.0056, 38.91891], [-121.0015, 38.91739], [-121.00565, 38.91748], [-121.00566, 38.91748]]], [[[-120.92539, 38.92932], [-120.92519, 38.92933], [-120.9244, 38.93366], [-120.92396, 38.92642], [-120.92534, 38.92655], [-120.92546, 38.92688], [-120.92539, 38.92932]]], [[[-120.92879, 38.93417], [-120.92644, 38.93389], [-120.92729, 38.92939], [-120.92678, 38.92935], [-120.9269, 38.92708], [-120.92678, 38.92669], [-120.92843, 38.92685], [-120.92879, 38.93417]]], [[[-120.98725, 38.92119], [-120.9865, 38.9269], [-120.97313, 38.9272], [-120.97129, 38.92726], [-120.97125, 38.93139], [-120.96831, 38.93254], [-120.96787, 38.93262], [-120.96749, 38.93252], [-120.96708, 38.93249], [-120.96664, 38.93249], [-120.9659, 38.93264], [-120.96567, 38.93271], [-120.96543, 38.93281], [-120.96489, 38.93294], [-120.96446, 38.93321], [-120.96432, 38.93335], [-120.96407, 38.93354], [-120.96379, 38.93319], [-120.96102, 38.93572], [-120.95951, 38.93635], [-120.95875, 38.93785], [-120.95907, 38.93812], [-120.95899, 38.93819], [-120.95871, 38.93845], [-120.95855, 38.93856], [-120.95828, 38.93798], [-120.95196, 38.93767], [-120.95172, 38.93483], [-120.9512, 38.92755], [-120.96008, 38.92751], [-120.96886, 38.92731], [-120.96928, 38.92086], [-120.97527, 38.92114], [-120.97947, 38.92119], [-120.98042, 38.92486], [-120.98246, 38.92449], [-120.98161, 38.92115], [-120.98341, 38.9212], [-120.98725, 38.92119]]], [[[-120.92479, 38.94008], [-120.92459, 38.94799], [-120.92227, 38.94767], [-120.92236, 38.94382], [-120.92442, 38.944], [-120.92452, 38.94006], [-120.92479, 38.94008]]], [[[-120.91995, 38.94734], [-120.91962, 38.95117], [-120.91475, 38.9501], [-120.91531, 38.94669], [-120.91995, 38.94734]]], [[[-120.93819, 38.94208], [-120.93819, 38.94328], [-120.93815, 38.94344], [-120.93794, 38.94396], [-120.93786, 38.94425], [-120.93784, 38.94458], [-120.93786, 38.94514], [-120.93784, 38.94541], [-120.93787, 38.94591], [-120.93786, 38.94612], [-120.93772, 38.94665], [-120.93765, 38.9472], [-120.93765, 38.94755], [-120.93733, 38.94756], [-120.93732, 38.94757], [-120.93753, 38.9511], [-120.93801, 38.9511], [-120.93803, 38.9514], [-120.93793, 38.95238], [-120.93798, 38.95355], [-120.93798, 38.95442], [-120.9381, 38.95587], [-120.9381, 38.9561], [-120.93816, 38.95646], [-120.93406, 38.95645], [-120.93361, 38.95258], [-120.93419, 38.95258], [-120.93434, 38.94658], [-120.93447, 38.94371], [-120.93348, 38.94206], [-120.93819, 38.94208]]], [[[-120.89312, 38.95055], [-120.89318, 38.94335], [-120.89779, 38.94335], [-120.89776, 38.94689], [-120.91323, 38.94671], [-120.91344, 38.94905], [-120.91304, 38.95179], [-120.91446, 38.9518], [-120.91419, 38.95351], [-120.91914, 38.95427], [-120.92136, 38.95458], [-120.92123, 38.95168], [-120.92326, 38.95167], [-120.92354, 38.95487], [-120.92442, 38.95497], [-120.9284, 38.95552], [-120.92908, 38.94862], [-120.92913, 38.94107], [-120.93099, 38.9415], [-120.93217, 38.94374], [-120.93173, 38.94644], [-120.93079, 38.95248], [-120.93027, 38.95249], [-120.93054, 38.95607], [-120.92878, 38.95905], [-120.93028, 38.95929], [-120.92826, 38.96215], [-120.92795, 38.96217], [-120.9277, 38.96212], [-120.9273, 38.96209], [-120.92691, 38.96201], [-120.92643, 38.96195], [-120.92577, 38.96181], [-120.92421, 38.96134], [-120.92308, 38.96086], [-120.92268, 38.96065], [-120.92237, 38.96045], [-120.92177, 38.95987], [-120.92136, 38.95942], [-120.9211, 38.95917], [-120.92063, 38.95882], [-120.92013, 38.95858], [-120.91982, 38.9584], [-120.91922, 38.95814], [-120.91857, 38.95794], [-120.91827, 38.95779], [-120.91772, 38.95757], [-120.91683, 38.95714], [-120.91608, 38.9565], [-120.91563, 38.95618], [-120.9151, 38.95594], [-120.91456, 38.95565], [-120.91433, 38.95557], [-120.91393, 38.95532], [-120.91352, 38.95523], [-120.91324, 38.95513], [-120.91241, 38.955], [-120.9119, 38.95494], [-120.91167, 38.95487], [-120.91086, 38.95474], [-120.90999, 38.95467], [-120.90916, 38.9544], [-120.90831, 38.95423], [-120.90711, 38.95414], [-120.90662, 38.95399], [-120.906, 38.95398], [-120.90556, 38.95391], [-120.90422, 38.95383], [-120.90373, 38.95375], [-120.9032, 38.95362], [-120.90275, 38.95348], [-120.89991, 38.95347], [-120.89964, 38.95375], [-120.89902, 38.95429], [-120.89873, 38.9545], [-120.8982, 38.95487], [-120.89675, 38.95575], [-120.8961, 38.95617], [-120.89551, 38.9567], [-120.89515, 38.95705], [-120.89413, 38.95787], [-120.89356, 38.95822], [-120.89203, 38.95898], [-120.89131, 38.95939], [-120.89085, 38.95958], [-120.89036, 38.95972], [-120.88989, 38.95978], [-120.88828, 38.95979], [-120.88777, 38.95982], [-120.88723, 38.95979], [-120.88626, 38.95954], [-120.88528, 38.95916], [-120.88497, 38.95889], [-120.88441, 38.95828], [-120.88387, 38.95779], [-120.88321, 38.95733], [-120.88262, 38.95706], [-120.88187, 38.95688], [-120.8811, 38.95685], [-120.88051, 38.95691], [-120.87948, 38.95693], [-120.87893, 38.957], [-120.87801, 38.95706], [-120.87759, 38.95706], [-120.87688, 38.95688], [-120.87605, 38.95661], [-120.87584, 38.95652], [-120.87521, 38.95643], [-120.87827, 38.94969], [-120.88092, 38.95273], [-120.8861, 38.95268], [-120.88888, 38.95269], [-120.8889, 38.95705], [-120.8935, 38.95706], [-120.89351, 38.95346], [-120.89312, 38.95345], [-120.89312, 38.95055]]], [[[-120.93402, 38.9635], [-120.93365, 38.96315], [-120.93313, 38.96245], [-120.93305, 38.96238], [-120.93286, 38.96229], [-120.93267, 38.96214], [-120.93244, 38.96209], [-120.9322, 38.96209], [-120.9319, 38.96206], [-120.93109, 38.9621], [-120.93074, 38.96213], [-120.9313, 38.96145], [-120.9316, 38.9615], [-120.93277, 38.9597], [-120.93319, 38.95981], [-120.93396, 38.95988], [-120.93402, 38.9635]]]]} | Open Access 1 | 25870 | Auburn State Recreation Area | 13795 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=502 | El Dorado 34 | 1985.182 | Auburn SRA | 1966 | State Recreation Area 39 | 4 |
| 16691 | 16691 | 16690 | {"type": "MultiPolygon", "coordinates": [[[[-116.08108, 33.1619], [-116.06393, 33.16219], [-116.06388, 33.14767], [-116.06387, 33.14766], [-116.04723, 33.14833], [-116.04741, 33.16296], [-116.03073, 33.16383], [-116.03051, 33.15603], [-116.03035, 33.14894], [-116.01284, 33.14906], [-116.01278, 33.16004], [-116.01285, 33.16376], [-115.99557, 33.16383], [-115.99558, 33.16013], [-115.99555, 33.15639], [-115.99553, 33.14907], [-115.97819, 33.14877], [-115.97818, 33.15611], [-115.97823, 33.16375], [-115.96076, 33.16359], [-115.96086, 33.17826], [-115.97835, 33.17836], [-115.97833, 33.19276], [-115.99588, 33.19266], [-115.99572, 33.17821], [-116.01309, 33.17804], [-116.01331, 33.19248], [-116.03067, 33.19222], [-116.03092, 33.20692], [-116.01353, 33.20711], [-116.01376, 33.22175], [-116.03122, 33.22166], [-116.03154, 33.2364], [-116.04907, 33.23638], [-116.04924, 33.25104], [-116.03165, 33.25104], [-116.03153, 33.2364], [-116.01399, 33.23642], [-116.01407, 33.25103], [-115.99648, 33.25103], [-115.99646, 33.23642], [-116.01399, 33.23642], [-116.01375, 33.22176], [-115.99631, 33.22186], [-115.99638, 33.22914], [-115.97906, 33.22909], [-115.97896, 33.22196], [-115.96124, 33.22192], [-115.96145, 33.23615], [-115.97914, 33.23636], [-115.9789, 33.25103], [-115.96162, 33.25101], [-115.96144, 33.23616], [-115.94403, 33.23583], [-115.94364, 33.22077], [-115.96123, 33.22192], [-115.96112, 33.20734], [-115.94365, 33.20704], [-115.94362, 33.19249], [-115.92648, 33.19229], [-115.9265, 33.2068], [-115.91362, 33.20664], [-115.91318, 33.20568], [-115.91185, 33.20256], [-115.90916, 33.1966], [-115.90916, 33.19208], [-115.90709, 33.19205], [-115.90672, 33.19125], [-115.90609, 33.1902], [-115.90536, 33.1892], [-115.90453, 33.18825], [-115.9036, 33.18737], [-115.90258, 33.18655], [-115.90039, 33.18501], [-115.89163, 33.17875], [-115.89163, 33.17735], [-115.90919, 33.17757], [-115.90924, 33.1631], [-115.89163, 33.16305], [-115.89161, 33.14856], [-115.87415, 33.1476], [-115.87473, 33.13431], [-115.85911, 33.13419], [-115.85667, 33.12863], [-115.85661, 33.11935], [-115.87428, 33.11939], [-115.87474, 33.1343], [-115.892, 33.13427], [-115.89201, 33.11967], [-115.90082, 33.11964], [-115.90952, 33.11991], [-115.90929, 33.12707], [-115.9093, 33.13434], [-115.92662, 33.13434], [-115.9263, 33.14874], [-115.92631, 33.14875], [-115.93061, 33.14878], [-115.93068, 33.14517], [-115.93283, 33.14517], [-115.93278, 33.14879], [-115.94349, 33.14886], [-115.9438, 33.1343], [-115.95242, 33.13429], [-115.96148, 33.13461], [-115.96071, 33.14903], [-115.97818, 33.14877], [-115.97822, 33.1341], [-115.99542, 33.13419], [-115.99537, 33.12712], [-116.01257, 33.127], [-116.01266, 33.13412], [-116.02099, 33.13388], [-116.02992, 33.13391], [-116.03036, 33.14893], [-116.04722, 33.14833], [-116.04692, 33.13353], [-116.06377, 33.13307], [-116.06375, 33.12737], [-116.06433, 33.12774], [-116.06695, 33.12842], [-116.08038, 33.13209], [-116.08106, 33.13235], [-116.08106, 33.13287], [-116.06378, 33.13308], [-116.06388, 33.14766], [-116.08097, 33.14739], [-116.08108, 33.1555], [-116.08108, 33.1619]], [[-115.90901, 33.14864], [-115.90929, 33.13434], [-115.90064, 33.13434], [-115.892, 33.13427], [-115.89162, 33.14856], [-115.90901, 33.14864]], [[-115.9264, 33.16326], [-115.92641, 33.16325], [-115.9263, 33.14875], [-115.90902, 33.14864], [-115.90925, 33.16309], [-115.9264, 33.16326]], [[-115.92644, 33.17781], [-115.9092, 33.17758], [-115.90916, 33.19207], [-115.92647, 33.19228], [-115.92644, 33.17781]], [[-115.9436, 33.17803], [-115.94361, 33.17802], [-115.94358, 33.16342], [-115.92642, 33.16326], [-115.92644, 33.1778], [-115.9436, 33.17803]], [[-115.96071, 33.14904], [-115.9435, 33.14887], [-115.94359, 33.16342], [-115.96075, 33.16358], [-115.96071, 33.14904]], [[-115.96086, 33.17827], [-115.94361, 33.17803], [-115.94364, 33.19249], [-115.96096, 33.19269], [-115.96086, 33.17827]], [[-115.96098, 33.19269], [-115.96097, 33.1927], [-115.96112, 33.20733], [-115.97892, 33.20744], [-115.97832, 33.19277], [-115.96098, 33.19269]], [[-115.9963, 33.22186], [-115.99631, 33.22185], [-115.99613, 33.20728], [-115.97893, 33.20745], [-115.97897, 33.22196], [-115.9963, 33.22186]], [[-116.01265, 33.13413], [-115.99544, 33.1342], [-115.99554, 33.14906], [-116.01283, 33.14906], [-116.01265, 33.13413]], [[-116.0011, 33.19261], [-115.99588, 33.19267], [-115.99613, 33.20727], [-116.01353, 33.2071], [-116.0133, 33.19249], [-116.0011, 33.19261]]], [[[-116.08441, 33.25104], [-116.06683, 33.25104], [-116.06662, 33.23638], [-116.08416, 33.23639], [-116.08441, 33.25104]]]]} | Open Access 1 | 29203 | Ocotillo Wells State Vehicular Recreation Area | 13771 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohv.parks.ca.gov/?page_id=1217 | Imperial 20 | 21169.376 | Ocotillo Wells SVRA | 1976 | State Recreation Area 39 | 4 |
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]);