units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where DES_TP = 39, MNG_AGENCY = 47 and YR_EST = 1974
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 6 ✖
DES_TP 1
- State Recreation Area · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4052 | 4052 | 4051 | {"type": "Polygon", "coordinates": [[[-120.62013, 35.03081], [-120.61761, 35.03273], [-120.61532, 35.03311], [-120.61364, 35.03325], [-120.61193, 35.03342], [-120.61133, 35.03435], [-120.60821, 35.03622], [-120.60821, 35.03689], [-120.60696, 35.04631], [-120.61165, 35.05697], [-120.60801, 35.057], [-120.60052, 35.05401], [-120.59852, 35.05278], [-120.59685, 35.05291], [-120.59637, 35.04946], [-120.59602, 35.04949], [-120.59405, 35.0355], [-120.59325, 35.03276], [-120.59845, 35.03437], [-120.60263, 35.0349], [-120.6082, 35.03622], [-120.60821, 35.02925], [-120.61044, 35.02376], [-120.61978, 35.03058], [-120.62013, 35.03081]]]} | Restricted Access 2 | 47022 | Oceano Dunes State Vehicular Recreation Area | 30668 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Luis Obispo 1 | 845.96 | Oceano Dunes SVRA | 1974 | State Recreation Area 39 | 4 | |
16640 | 16640 | 16639 | {"type": "MultiPolygon", "coordinates": [[[[-120.02704, 39.23573], [-120.02704, 39.23625], [-120.02691, 39.23675], [-120.02641, 39.23666], [-120.02639, 39.23733], [-120.02633, 39.23732], [-120.02629, 39.23731], [-120.02628, 39.23692], [-120.02579, 39.23684], [-120.02578, 39.23718], [-120.02543, 39.23706], [-120.02515, 39.23694], [-120.02444, 39.23657], [-120.02411, 39.23642], [-120.02378, 39.23628], [-120.02337, 39.23614], [-120.02353, 39.23576], [-120.02231, 39.2354], [-120.02251, 39.23495], [-120.02236, 39.23486], [-120.02161, 39.23465], [-120.02201, 39.23378], [-120.02223, 39.23382], [-120.02243, 39.23387], [-120.02257, 39.23393], [-120.02267, 39.23397], [-120.02281, 39.23407], [-120.02305, 39.23435], [-120.02323, 39.23467], [-120.02338, 39.23485], [-120.02352, 39.23497], [-120.02352, 39.235], [-120.02375, 39.2351], [-120.02436, 39.23528], [-120.0254, 39.23548], [-120.02608, 39.23555], [-120.0263, 39.23561], [-120.02704, 39.23573]]], [[[-120.02232, 39.23497], [-120.02215, 39.23535], [-120.02182, 39.23525], [-120.02199, 39.23487], [-120.02232, 39.23497]]]]} | Open Access 1 | 20736 | Kings Beach State Recreation Area | 1591 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=511 | Placer 35 | 16.052 | Kings Beach SRA | 1974 | State Recreation Area 39 | 4 |
16646 | 16646 | 16645 | {"type": "MultiPolygon", "coordinates": [[[[-117.17847, 33.89281], [-117.17814, 33.89402], [-117.1769, 33.89573], [-117.17682, 33.8954], [-117.17714, 33.89469], [-117.1773, 33.89349], [-117.17659, 33.893], [-117.17615, 33.89279], [-117.17464, 33.89301], [-117.1743, 33.89289], [-117.17286, 33.89362], [-117.17216, 33.89486], [-117.17205, 33.89556], [-117.17171, 33.89569], [-117.17168, 33.89608], [-117.17119, 33.89657], [-117.1703, 33.89715], [-117.16969, 33.89751], [-117.16894, 33.89778], [-117.16867, 33.89757], [-117.16833, 33.89762], [-117.16825, 33.89791], [-117.16809, 33.89821], [-117.16783, 33.89839], [-117.16708, 33.89865], [-117.16685, 33.89878], [-117.16657, 33.89875], [-117.16652, 33.89846], [-117.16619, 33.89839], [-117.16595, 33.89876], [-117.16533, 33.89929], [-117.16471, 33.90018], [-117.16376, 33.90079], [-117.16304, 33.90113], [-117.16284, 33.9015], [-117.16243, 33.90184], [-117.16184, 33.90284], [-117.16187, 33.90356], [-117.16145, 33.90426], [-117.16157, 33.90454], [-117.16131, 33.90482], [-117.16, 33.90474], [-117.15935, 33.90581], [-117.15865, 33.90602], [-117.15765, 33.9054], [-117.15578, 33.90596], [-117.15551, 33.90635], [-117.15429, 33.90616], [-117.15406, 33.90698], [-117.15255, 33.90918], [-117.15078, 33.9095], [-117.15015, 33.9102], [-117.15023, 33.90942], [-117.14969, 33.90953], [-117.14958, 33.91014], [-117.13744, 33.91018], [-117.13704, 33.91021], [-117.13648, 33.91046], [-117.13319, 33.90869], [-117.13287, 33.90769], [-117.13196, 33.90812], [-117.13158, 33.90747], [-117.13455, 33.90498], [-117.13367, 33.90293], [-117.13663, 33.89569], [-117.13481, 33.88996], [-117.13453, 33.88949], [-117.13484, 33.88948], [-117.13933, 33.89582], [-117.14318, 33.90033], [-117.1464, 33.90524], [-117.14739, 33.90585], [-117.14959, 33.90282], [-117.14994, 33.90053], [-117.15635, 33.89779], [-117.1577, 33.89462], [-117.16679, 33.89444], [-117.17471, 33.89251], [-117.1766, 33.89049], [-117.17707, 33.89068], [-117.1768, 33.89097], [-117.1768, 33.89098], [-117.17761, 33.89141], [-117.17824, 33.89204], [-117.17847, 33.89281]]], [[[-117.20824, 33.86836], [-117.20787, 33.86908], [-117.20755, 33.86948], [-117.20744, 33.8705], [-117.20745, 33.87084], [-117.20685, 33.87126], [-117.20707, 33.87182], [-117.20711, 33.87233], [-117.20682, 33.87252], [-117.20655, 33.87319], [-117.20673, 33.87345], [-117.2068, 33.87455], [-117.20673, 33.87467], [-117.206, 33.87521], [-117.2061, 33.87571], [-117.20602, 33.8758], [-117.20622, 33.87741], [-117.20611, 33.87742], [-117.20602, 33.87758], [-117.20608, 33.87769], [-117.20555, 33.87801], [-117.20495, 33.87816], [-117.20501, 33.87841], [-117.20421, 33.87866], [-117.20367, 33.87909], [-117.2035, 33.88043], [-117.20171, 33.88131], [-117.20072, 33.88086], [-117.20038, 33.88095], [-117.20041, 33.88117], [-117.20027, 33.88117], [-117.2001, 33.88106], [-117.19976, 33.88121], [-117.1998, 33.88144], [-117.1997, 33.88191], [-117.19953, 33.88192], [-117.19946, 33.88213], [-117.19946, 33.88244], [-117.19927, 33.88265], [-117.19898, 33.88248], [-117.19825, 33.88278], [-117.19821, 33.88285], [-117.19799, 33.88294], [-117.19752, 33.88367], [-117.19724, 33.88446], [-117.19695, 33.88473], [-117.1969, 33.88491], [-117.19646, 33.88491], [-117.1958, 33.88499], [-117.19561, 33.88509], [-117.19551, 33.88518], [-117.19532, 33.8853], [-117.19511, 33.88553], [-117.1949, 33.886], [-117.1934, 33.88746], [-117.19464, 33.88864], [-117.19442, 33.88895], [-117.19445, 33.88918], [-117.19424, 33.88931], [-117.19407, 33.88918], [-117.19391, 33.88925], [-117.19397, 33.88942], [-117.19383, 33.88972], [-117.19375, 33.88963], [-117.19355, 33.88978], [-117.19357, 33.88993], [-117.19317, 33.89016], [-117.19301, 33.88997], [-117.19279, 33.89002], [-117.19264, 33.88967], [-117.19234, 33.8896], [-117.19207, 33.88876], [-117.19202, 33.88844], [-117.19182, 33.8884], [-117.19176, 33.88824], [-117.1916, 33.8882], [-117.1915, 33.88836], [-117.1906, 33.88817], [-117.19005, 33.88905], [-117.18998, 33.88892], [-117.1897, 33.88917], [-117.18988, 33.88965], [-117.19006, 33.89], [-117.19003, 33.89078], [-117.18883, 33.89115], [-117.18783, 33.8907], [-117.18805, 33.89001], [-117.18775, 33.88946], [-117.18721, 33.88932], [-117.18739, 33.8888], [-117.18809, 33.8881], [-117.18763, 33.88764], [-117.18662, 33.88865], [-117.18654, 33.8892], [-117.18608, 33.88948], [-117.18569, 33.88934], [-117.18497, 33.89012], [-117.1828, 33.88902], [-117.18224, 33.88942], [-117.18169, 33.88758], [-117.18195, 33.88719], [-117.18172, 33.88693], [-117.18222, 33.88636], [-117.18206, 33.88593], [-117.18191, 33.88588], [-117.18192, 33.88576], [-117.18187, 33.88551], [-117.18143, 33.88526], [-117.1857, 33.88067], [-117.19013, 33.88114], [-117.20216, 33.87048], [-117.20438, 33.86581], [-117.20546, 33.86584], [-117.20548, 33.86557], [-117.20629, 33.86559], [-117.20631, 33.86543], [-117.20652, 33.86544], [-117.20678, 33.86544], [-117.20766, 33.86604], [-117.20777, 33.86622], [-117.20759, 33.86727], [-117.20824, 33.86836]]]]} | Open Access 1 | 3470 | Lake Perris State Recreation Area | 1834 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=651 | Riverside 10 | 1469.067 | Lake Perris SRA | 1974 | State Recreation Area 39 | 4 |
16668 | 16668 | 16667 | {"type": "Polygon", "coordinates": [[[-120.63643, 35.01784], [-120.63637, 35.01818], [-120.63622, 35.01883], [-120.63615, 35.01987], [-120.63579, 35.02097], [-120.63573, 35.02206], [-120.63521, 35.02377], [-120.63517, 35.02516], [-120.63512, 35.02605], [-120.63452, 35.02722], [-120.63466, 35.02858], [-120.63436, 35.02988], [-120.63414, 35.03142], [-120.63362, 35.0328], [-120.6336, 35.03357], [-120.63374, 35.03397], [-120.63334, 35.03491], [-120.63337, 35.03553], [-120.63356, 35.03581], [-120.63357, 35.03613], [-120.63344, 35.03684], [-120.63311, 35.0378], [-120.63306, 35.03854], [-120.63297, 35.03946], [-120.6327, 35.03996], [-120.6327, 35.04021], [-120.63264, 35.04056], [-120.63275, 35.04134], [-120.63018, 35.04128], [-120.62861, 35.05129], [-120.62808, 35.05592], [-120.6279, 35.05684], [-120.62793, 35.06078], [-120.62807, 35.06267], [-120.62825, 35.06616], [-120.62837, 35.07497], [-120.62864, 35.08087], [-120.61932, 35.08098], [-120.61917, 35.06809], [-120.61911, 35.06083], [-120.61572, 35.06084], [-120.61568, 35.05693], [-120.61165, 35.05697], [-120.60696, 35.04631], [-120.60821, 35.03689], [-120.60821, 35.03622], [-120.61133, 35.03435], [-120.61193, 35.03342], [-120.61364, 35.03325], [-120.61532, 35.03311], [-120.6176, 35.03273], [-120.62013, 35.03081], [-120.62069, 35.03088], [-120.6207, 35.03086], [-120.62007, 35.03036], [-120.62045, 35.03008], [-120.62078, 35.02939], [-120.62099, 35.02884], [-120.62148, 35.02831], [-120.62243, 35.02747], [-120.623, 35.0272], [-120.62464, 35.02677], [-120.62527, 35.02699], [-120.62589, 35.02701], [-120.62615, 35.0266], [-120.63127, 35.02843], [-120.6322, 35.02364], [-120.62112, 35.02369], [-120.61199, 35.01744], [-120.61221, 35.0171], [-120.60732, 35.01378], [-120.6001, 35.0088], [-120.63643, 35.01784]], [[-120.61375, 35.04511], [-120.61376, 35.0451], [-120.61354, 35.04414], [-120.61231, 35.04431], [-120.61254, 35.04528], [-120.61375, 35.04511]], [[-120.61406, 35.03687], [-120.61407, 35.03686], [-120.61406, 35.03588], [-120.61281, 35.03587], [-120.61282, 35.03686], [-120.61406, 35.03687]], [[-120.61452, 35.0405], [-120.61577, 35.04051], [-120.61576, 35.03953], [-120.61452, 35.03952], [-120.61452, 35.0405]], [[-120.61766, 35.03702], [-120.61891, 35.03704], [-120.6189, 35.03605], [-120.61766, 35.03604], [-120.61766, 35.03702]], [[-120.61915, 35.0565], [-120.61915, 35.05568], [-120.61818, 35.05569], [-120.6182, 35.05651], [-120.61915, 35.0565]], [[-120.62004, 35.04314], [-120.62003, 35.04315], [-120.62028, 35.04411], [-120.6215, 35.04391], [-120.62125, 35.04295], [-120.62004, 35.04314]], [[-120.62574, 35.0357], [-120.62602, 35.03474], [-120.62481, 35.03449], [-120.62454, 35.03545], [-120.62574, 35.0357]], [[-120.62597, 35.04014], [-120.62472, 35.04013], [-120.62473, 35.04111], [-120.62597, 35.04112], [-120.62597, 35.04014]], [[-120.62579, 35.0556], [-120.6258, 35.05643], [-120.62676, 35.05642], [-120.62675, 35.0556], [-120.62579, 35.0556]], [[-120.62921, 35.03568], [-120.62893, 35.03664], [-120.63014, 35.03689], [-120.63041, 35.03593], [-120.62921, 35.03568]], [[-120.62971, 35.04009], [-120.6297, 35.0401], [-120.62971, 35.04108], [-120.63096, 35.04109], [-120.63095, 35.0401], [-120.62971, 35.04009]]]} | Open Access 1 | 18256 | Oceano Dunes State Vehicular Recreation Area | 1659 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=406 | San Luis Obispo 1 | 2612.474 | Oceano Dunes SVRA | 1974 | State Recreation Area 39 | 4 |
16673 | 16673 | 16672 | {"type": "Polygon", "coordinates": [[[-117.21268, 33.84474], [-117.21262, 33.84527], [-117.20436, 33.84533], [-117.20439, 33.85874], [-117.20875, 33.86762], [-117.20875, 33.86766], [-117.20732, 33.86549], [-117.20628, 33.86504], [-117.20638, 33.86522], [-117.20411, 33.86399], [-117.20408, 33.86508], [-117.20438, 33.86581], [-117.20216, 33.87048], [-117.19012, 33.88115], [-117.1857, 33.88067], [-117.18144, 33.88525], [-117.18144, 33.88527], [-117.18187, 33.88551], [-117.18192, 33.88576], [-117.18191, 33.88588], [-117.18172, 33.88582], [-117.18148, 33.88615], [-117.18144, 33.88614], [-117.1813, 33.88604], [-117.18102, 33.88595], [-117.18092, 33.88595], [-117.18072, 33.88602], [-117.18056, 33.88602], [-117.18039, 33.88614], [-117.17988, 33.88671], [-117.18065, 33.88694], [-117.17708, 33.89068], [-117.1766, 33.89049], [-117.17471, 33.89251], [-117.16679, 33.89444], [-117.1577, 33.89462], [-117.15636, 33.89779], [-117.14994, 33.90053], [-117.14959, 33.90282], [-117.14739, 33.90585], [-117.14641, 33.90524], [-117.14318, 33.90033], [-117.13933, 33.89582], [-117.13484, 33.88948], [-117.13453, 33.88948], [-117.1299, 33.88164], [-117.13017, 33.87373], [-117.13855, 33.86702], [-117.13878, 33.86045], [-117.14801, 33.8537], [-117.15153, 33.85099], [-117.15337, 33.84523], [-117.15642, 33.84274], [-117.15642, 33.84178], [-117.15952, 33.83955], [-117.1618, 33.84036], [-117.16611, 33.83781], [-117.18056, 33.83751], [-117.17887, 33.83865], [-117.17866, 33.83994], [-117.19222, 33.85061], [-117.19702, 33.86233], [-117.20013, 33.86116], [-117.2025, 33.86005], [-117.20364, 33.85905], [-117.2038, 33.85877], [-117.20406, 33.8575], [-117.20371, 33.85291], [-117.20374, 33.85038], [-117.20398, 33.84758], [-117.20405, 33.84654], [-117.20399, 33.84571], [-117.204, 33.8448], [-117.21268, 33.84474]]]} | Open Access 1 | 28046 | Lake Perris State Recreation Area | 1834 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=651 | Riverside 10 | 7434.978 | Lake Perris SRA | 1974 | State Recreation Area 39 | 4 |
16675 | 16675 | 16674 | {"type": "Polygon", "coordinates": [[[-121.62661, 37.77936], [-121.62437, 37.78237], [-121.62412, 37.78263], [-121.62371, 37.78295], [-121.62362, 37.78308], [-121.62357, 37.78322], [-121.62256, 37.78376], [-121.62221, 37.78382], [-121.62158, 37.78416], [-121.62154, 37.7842], [-121.62153, 37.78426], [-121.62155, 37.78432], [-121.62175, 37.78441], [-121.62184, 37.78448], [-121.62197, 37.78463], [-121.62198, 37.78463], [-121.62202, 37.78472], [-121.62211, 37.78497], [-121.62217, 37.78523], [-121.62219, 37.7855], [-121.62219, 37.78568], [-121.62213, 37.78603], [-121.62205, 37.78629], [-121.62197, 37.78646], [-121.62183, 37.7867], [-121.62129, 37.78747], [-121.61941, 37.78748], [-121.61911, 37.78754], [-121.61875, 37.78757], [-121.61804, 37.78757], [-121.61803, 37.78748], [-121.61412, 37.78749], [-121.6141, 37.7845], [-121.60509, 37.78458], [-121.60511, 37.78259], [-121.60156, 37.78034], [-121.59571, 37.78053], [-121.59572, 37.77962], [-121.59561, 37.77963], [-121.59541, 37.77971], [-121.59524, 37.77983], [-121.59512, 37.77997], [-121.59503, 37.78013], [-121.59501, 37.78031], [-121.59504, 37.78147], [-121.59503, 37.78164], [-121.59498, 37.78184], [-121.5949, 37.78199], [-121.59481, 37.78214], [-121.59469, 37.78227], [-121.59446, 37.78244], [-121.5942, 37.78257], [-121.59249, 37.78314], [-121.59233, 37.78317], [-121.59214, 37.78318], [-121.59198, 37.78317], [-121.59182, 37.78313], [-121.59188, 37.78306], [-121.59214, 37.7831], [-121.59242, 37.78307], [-121.5942, 37.78248], [-121.5944, 37.78237], [-121.59461, 37.78221], [-121.59474, 37.78206], [-121.59486, 37.78185], [-121.59491, 37.7817], [-121.59493, 37.78155], [-121.5949, 37.78031], [-121.59494, 37.78009], [-121.59506, 37.77989], [-121.59524, 37.77972], [-121.59547, 37.77959], [-121.59573, 37.77951], [-121.59576, 37.77325], [-121.59932, 37.77328], [-121.5994, 37.77282], [-121.59971, 37.77252], [-121.60045, 37.7723], [-121.60083, 37.77124], [-121.6, 37.77021], [-121.59992, 37.77019], [-121.60016, 37.77006], [-121.60125, 37.77133], [-121.60165, 37.77111], [-121.6017, 37.77103], [-121.6016, 37.7709], [-121.60179, 37.77078], [-121.6016, 37.77056], [-121.6014, 37.77067], [-121.60065, 37.76979], [-121.6011, 37.76954], [-121.60165, 37.77021], [-121.60179, 37.77022], [-121.60186, 37.77029], [-121.6024, 37.77032], [-121.60311, 37.76923], [-121.60396, 37.76878], [-121.60445, 37.76939], [-121.6043, 37.7707], [-121.6037, 37.77174], [-121.60508, 37.77335], [-121.60699, 37.77189], [-121.60914, 37.77271], [-121.60939, 37.77393], [-121.61051, 37.77428], [-121.61106, 37.77586], [-121.61496, 37.77604], [-121.61591, 37.77654], [-121.61531, 37.77849], [-121.61778, 37.77972], [-121.61951, 37.77969], [-121.6195, 37.77862], [-121.62172, 37.77782], [-121.62273, 37.77715], [-121.62471, 37.77906], [-121.62661, 37.77936]], [[-121.60196, 37.77484], [-121.6018, 37.77477], [-121.60151, 37.77468], [-121.60139, 37.77463], [-121.60066, 37.77411], [-121.60051, 37.77396], [-121.60042, 37.77382], [-121.60035, 37.77367], [-121.60032, 37.77348], [-121.59994, 37.77349], [-121.59996, 37.77365], [-121.60001, 37.77382], [-121.60011, 37.77401], [-121.60022, 37.77416], [-121.60042, 37.77435], [-121.60111, 37.77484], [-121.60132, 37.77494], [-121.6016, 37.77503], [-121.60181, 37.77512], [-121.60203, 37.77489], [-121.60196, 37.77484]], [[-121.60204, 37.77482], [-121.60208, 37.77484], [-121.6023, 37.7746], [-121.602, 37.77445], [-121.60166, 37.77434], [-121.601, 37.77387], [-121.60092, 37.7738], [-121.60084, 37.7737], [-121.60079, 37.77359], [-121.60077, 37.77347], [-121.6004, 37.77348], [-121.60041, 37.77362], [-121.60048, 37.7738], [-121.60057, 37.77393], [-121.60071, 37.77407], [-121.60143, 37.77458], [-121.60155, 37.77464], [-121.60183, 37.77472], [-121.60204, 37.77482]], [[-121.60915, 37.78172], [-121.60929, 37.78188], [-121.6095, 37.78206], [-121.60973, 37.78223], [-121.61, 37.78236], [-121.61028, 37.78247], [-121.61051, 37.78253], [-121.61074, 37.78257], [-121.61105, 37.78259], [-121.61137, 37.78258], [-121.6116, 37.78254], [-121.61603, 37.78175], [-121.61592, 37.78138], [-121.61143, 37.78218], [-121.61106, 37.7822], [-121.6107, 37.78217], [-121.61052, 37.78213], [-121.61029, 37.78205], [-121.61013, 37.78198], [-121.60993, 37.78186], [-121.60971, 37.78168], [-121.60936, 37.78128], [-121.60912, 37.78106], [-121.60886, 37.78085], [-121.60857, 37.78067], [-121.60826, 37.78052], [-121.60793, 37.78038], [-121.60759, 37.78028], [-121.60735, 37.78023], [-121.60711, 37.781], [-121.60736, 37.78106], [-121.6076, 37.78114], [-121.60799, 37.78132], [-121.6082, 37.78145], [-121.60839, 37.7816], [-121.60856, 37.78176], [-121.60871, 37.78193], [-121.60915, 37.78172]], [[-121.60737, 37.78016], [-121.60738, 37.78017], [-121.60773, 37.78026], [-121.60807, 37.78038], [-121.60829, 37.78047], [-121.60861, 37.78063], [-121.6089, 37.78081], [-121.60917, 37.78102], [-121.60941, 37.78125], [-121.60976, 37.78165], [-121.60997, 37.78182], [-121.61016, 37.78193], [-121.61037, 37.78202], [-121.6106, 37.78209], [-121.61083, 37.78213], [-121.61113, 37.78215], [-121.61142, 37.78212], [-121.61591, 37.78132], [-121.6158, 37.78095], [-121.61133, 37.78175], [-121.61112, 37.78176], [-121.6109, 37.78175], [-121.61058, 37.78167], [-121.61029, 37.78152], [-121.61011, 37.78138], [-121.60971, 37.78093], [-121.60943, 37.78068], [-121.609, 37.78038], [-121.60853, 37.78013], [-121.60802, 37.77994], [-121.60749, 37.7798], [-121.60737, 37.78016]], [[-121.61836, 37.78581], [-121.61956, 37.78467], [-121.61784, 37.78353], [-121.61783, 37.78354], [-121.61769, 37.78348], [-121.61756, 37.78345], [-121.61742, 37.78346], [-121.6173, 37.7835], [-121.61722, 37.78355], [-121.61714, 37.78362], [-121.61698, 37.78382], [-121.61693, 37.78393], [-121.61693, 37.78403], [-121.61697, 37.78414], [-121.61704, 37.78423], [-121.61722, 37.78438], [-121.61727, 37.78446], [-121.61729, 37.78455], [-121.61728, 37.78465], [-121.61723, 37.78476], [-121.61715, 37.78484], [-121.61702, 37.78492], [-121.61836, 37.78581]], [[-121.6176, 37.78338], [-121.61761, 37.78336], [-121.61754, 37.78323], [-121.61751, 37.78308], [-121.61724, 37.78342], [-121.61725, 37.78343], [-121.61745, 37.78338], [-121.6176, 37.78338]], [[-121.61789, 37.78348], [-121.61789, 37.78349], [-121.61961, 37.78463], [-121.61983, 37.78442], [-121.61764, 37.78297], [-121.61761, 37.78303], [-121.61759, 37.78311], [-121.6176, 37.7832], [-121.61762, 37.78326], [-121.61772, 37.78337], [-121.61789, 37.78348]], [[-121.6206, 37.78443], [-121.61997, 37.78466], [-121.62026, 37.78515], [-121.62088, 37.78492], [-121.6206, 37.78443]]]} | Open Access 1 | 47068 | Bethany Reservoir State Recreation Area | 1434 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=562 | Alameda 17 | 613.14 | Bethany Reservoir SRA | 1974 | 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]);