units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
158 rows where DES_TP = 3 and MNG_AG_LEV = 3 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY
MNG_AGENCY >30
- Los Angeles, County of 31
- Santa Barbara, County of 19
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Clara County Parks and Recreation Dept., County of 10
- Sacramento, County of 9
- San Diego, County of 7
- Santa Cruz, County of 5
- San Luis Obispo, County of 5
- Monterey, County of 5
- Orange, County of 5
- Marin County Parks Department, County of 5
- Riverside, County of 5
- Ventura, County of 4
- San Mateo County Parks and Recreation Dept., County of 3
- Sonoma County Regional Parks Dept., County of 3
- Fresno, County of 3
- Kern, County of 3
- Placer, County of 2
- San Bernardino, County of 2
- Contra Costa County Public Works Dept., County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Yolo, County of 2
- Los Angeles Department of Public Works, County of 2
- Lake, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Del Norte County Parks, County of 1
- Amador, County of 1
- Colusa, County of 1
- …
ACCESS_TYP 4
MNG_AG_TYP 3
DES_TP 1
- Local Recreation Area · 158 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7478 | 7478 | 7477 | {"type": "Polygon", "coordinates": [[[-117.95999, 34.10704], [-117.9599, 34.11834], [-117.95943, 34.11891], [-117.95858, 34.11969], [-117.95755, 34.12058], [-117.95639, 34.12138], [-117.95542, 34.12235], [-117.95497, 34.12298], [-117.95388, 34.12367], [-117.95313, 34.12443], [-117.95266, 34.1252], [-117.9525, 34.12614], [-117.95196, 34.12642], [-117.95133, 34.12694], [-117.95091, 34.12769], [-117.95066, 34.12822], [-117.95053, 34.12906], [-117.95015, 34.13], [-117.94872, 34.13114], [-117.94844, 34.13138], [-117.94805, 34.1319], [-117.94765, 34.13216], [-117.94567, 34.13364], [-117.94402, 34.13482], [-117.94341, 34.13538], [-117.94279, 34.13606], [-117.94249, 34.13642], [-117.93973, 34.13462], [-117.94295, 34.13132], [-117.94585, 34.12985], [-117.9469, 34.12888], [-117.94687, 34.12161], [-117.94251, 34.12163], [-117.94262, 34.118], [-117.93818, 34.11798], [-117.93817, 34.11927], [-117.93609, 34.11925], [-117.93609, 34.11897], [-117.93615, 34.11857], [-117.93688, 34.11521], [-117.93704, 34.11478], [-117.93726, 34.11441], [-117.94023, 34.11089], [-117.9404, 34.11063], [-117.94096, 34.11063], [-117.94293, 34.10827], [-117.94297, 34.1072], [-117.95999, 34.10704]]]} | Open Access 1 | 6999 | Santa Fe Dam Recreation Area | 32698 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/santa-fe-dam-recreational-area/ | Los Angeles 6 | 912.515 | Santa Fe Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
14458 | 14458 | 14457 | {"type": "Polygon", "coordinates": [[[-122.52636, 39.31903], [-122.52637, 39.31943], [-122.5251, 39.32296], [-122.52302, 39.32853], [-122.52303, 39.32854], [-122.52363, 39.32846], [-122.52301, 39.33189], [-122.5221, 39.33213], [-122.52146, 39.33351], [-122.52147, 39.33352], [-122.52615, 39.33354], [-122.52618, 39.34106], [-122.52153, 39.34078], [-122.52151, 39.34079], [-122.52166, 39.34795], [-122.52124, 39.35165], [-122.52558, 39.35156], [-122.52505, 39.35517], [-122.51546, 39.35536], [-122.51509, 39.35543], [-122.51507, 39.35551], [-122.51507, 39.35552], [-122.52086, 39.35545], [-122.52011, 39.35957], [-122.51765, 39.35917], [-122.51725, 39.36293], [-122.51262, 39.36292], [-122.51273, 39.36466], [-122.51209, 39.36462], [-122.51208, 39.36463], [-122.51212, 39.36627], [-122.51216, 39.37706], [-122.50724, 39.37681], [-122.49639, 39.37713], [-122.49613, 39.37347], [-122.49333, 39.37343], [-122.49328, 39.36618], [-122.48982, 39.36607], [-122.48974, 39.36264], [-122.4979, 39.36258], [-122.49749, 39.35637], [-122.49597, 39.3563], [-122.49588, 39.35551], [-122.48838, 39.35532], [-122.48843, 39.34826], [-122.48842, 39.33347], [-122.48846, 39.33111], [-122.48844, 39.33083], [-122.48853, 39.31922], [-122.48858, 39.30481], [-122.48873, 39.30475], [-122.4932, 39.30468], [-122.49319, 39.30527], [-122.49324, 39.30836], [-122.49341, 39.31258], [-122.4934, 39.31363], [-122.4944, 39.31557], [-122.49816, 39.31564], [-122.49811, 39.3192], [-122.50313, 39.31914], [-122.52636, 39.31903]]]} | Open Access 1 | 47088 | East Park Reservoir | 30742 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 358 | Colusa, County of 1068 | County 3 | County Agency 3 | Colusa 49 | 4263.017 | East Park Reservoir | 0 | Local Recreation Area 3 | 4 | |
16794 | 16794 | 16793 | {"type": "MultiPolygon", "coordinates": [[[[-119.97088, 34.57189], [-119.97081, 34.57555], [-119.96345, 34.57212], [-119.96131, 34.57212], [-119.95957, 34.57273], [-119.95752, 34.57276], [-119.95604, 34.57194], [-119.95586, 34.57186], [-119.95497, 34.571], [-119.95426, 34.57048], [-119.95351, 34.56824], [-119.9528, 34.56792], [-119.95129, 34.5676], [-119.94677, 34.56768], [-119.94599, 34.56766], [-119.94512, 34.56768], [-119.94432, 34.5676], [-119.94367, 34.56748], [-119.94283, 34.5672], [-119.94202, 34.56686], [-119.94125, 34.56645], [-119.94051, 34.56597], [-119.93941, 34.56546], [-119.93902, 34.56479], [-119.937, 34.5638], [-119.93474, 34.56292], [-119.93242, 34.56224], [-119.93187, 34.56236], [-119.92686, 34.56093], [-119.92652, 34.56061], [-119.92132, 34.56097], [-119.9182, 34.55879], [-119.91682, 34.55878], [-119.91612, 34.55828], [-119.91406, 34.55809], [-119.91253, 34.55737], [-119.91134, 34.55487], [-119.91163, 34.55481], [-119.91162, 34.55397], [-119.91133, 34.55395], [-119.91108, 34.55267], [-119.91031, 34.55148], [-119.9185, 34.55565], [-119.92625, 34.5595], [-119.92637, 34.55904], [-119.92651, 34.5586], [-119.9267, 34.55816], [-119.92692, 34.55774], [-119.92718, 34.55735], [-119.92747, 34.55698], [-119.92779, 34.55663], [-119.92946, 34.55451], [-119.96358, 34.56898], [-119.97088, 34.57189]]], [[[-119.99132, 34.59119], [-119.98816, 34.59127], [-119.98659, 34.59205], [-119.98333, 34.59359], [-119.98332, 34.59811], [-119.97942, 34.59803], [-119.97811, 34.60042], [-119.97742, 34.60031], [-119.97691, 34.60042], [-119.97542, 34.60026], [-119.96854, 34.59772], [-119.96456, 34.6004], [-119.95458, 34.60706], [-119.95415, 34.60664], [-119.9519, 34.60453], [-119.95046, 34.60182], [-119.94671, 34.6002], [-119.94116, 34.60658], [-119.93649, 34.60979], [-119.93093, 34.60736], [-119.93417, 34.59869], [-119.9275, 34.59674], [-119.92304, 34.59788], [-119.9188, 34.59933], [-119.91526, 34.60181], [-119.90414, 34.59401], [-119.89889, 34.59025], [-119.89809, 34.58208], [-119.89816, 34.57735], [-119.87591, 34.5662], [-119.86647, 34.54994], [-119.86598, 34.54924], [-119.86526, 34.54889], [-119.86486, 34.54848], [-119.8648, 34.54784], [-119.86433, 34.54732], [-119.86412, 34.54695], [-119.86403, 34.5467], [-119.864, 34.54637], [-119.86427, 34.54579], [-119.86446, 34.54632], [-119.86443, 34.54657], [-119.86507, 34.54753], [-119.86558, 34.54856], [-119.8662, 34.54868], [-119.86746, 34.54549], [-119.87126, 34.54659], [-119.87386, 34.54855], [-119.87472, 34.54891], [-119.87501, 34.54896], [-119.8777, 34.55085], [-119.87901, 34.55108], [-119.8824, 34.5523], [-119.8827, 34.55351], [-119.8848, 34.55303], [-119.8848, 34.55301], [-119.88461, 34.55295], [-119.88446, 34.55287], [-119.88428, 34.55271], [-119.88415, 34.55251], [-119.88409, 34.55236], [-119.88406, 34.5522], [-119.88456, 34.5523], [-119.88556, 34.55215], [-119.88657, 34.54923], [-119.88742, 34.54922], [-119.88963, 34.54808], [-119.89002, 34.54726], [-119.89033, 34.54738], [-119.89185, 34.54716], [-119.89297, 34.54714], [-119.89334, 34.54711], [-119.89472, 34.54741], [-119.89547, 34.54734], [-119.89716, 34.54781], [-119.90053, 34.54832], [-119.89991, 34.54854], [-119.89991, 34.54971], [-119.90159, 34.55183], [-119.90243, 34.55396], [-119.90261, 34.5542], [-119.90322, 34.55452], [-119.90338, 34.55508], [-119.90311, 34.55533], [-119.90227, 34.55555], [-119.90186, 34.55611], [-119.90228, 34.55686], [-119.90294, 34.55702], [-119.90321, 34.55673], [-119.90351, 34.55661], [-119.90601, 34.5578], [-119.90873, 34.55683], [-119.9093, 34.55482], [-119.90979, 34.55299], [-119.9105, 34.55477], [-119.91025, 34.55527], [-119.91082, 34.55585], [-119.91139, 34.55834], [-119.92188, 34.56233], [-119.92257, 34.56229], [-119.92343, 34.56247], [-119.92424, 34.56208], [-119.92568, 34.56212], [-119.92645, 34.56259], [-119.92947, 34.56293], [-119.92941, 34.56307], [-119.93108, 34.56332], [-119.93221, 34.56398], [-119.93378, 34.56418], [-119.93761, 34.56551], [-119.93834, 34.5658], [-119.93881, 34.56634], [-119.93923, 34.56655], [-119.9397, 34.56654], [-119.94062, 34.56691], [-119.94138, 34.56736], [-119.94217, 34.56774], [-119.94299, 34.56806], [-119.94384, 34.56829], [-119.9447, 34.56846], [-119.94557, 34.56855], [-119.94645, 34.56856], [-119.95193, 34.56815], [-119.95271, 34.56913], [-119.95326, 34.57125], [-119.95552, 34.57279], [-119.95769, 34.57362], [-119.96073, 34.57329], [-119.96299, 34.57264], [-119.96638, 34.57395], [-119.96885, 34.57511], [-119.97082, 34.57592], [-119.97291, 34.57654], [-119.97328, 34.57693], [-119.9736, 34.57701], [-119.97388, 34.57674], [-119.97546, 34.57717], [-119.97541, 34.57729], [-119.97542, 34.57731], [-119.97587, 34.57743], [-119.97593, 34.5773], [-119.98107, 34.5787], [-119.98202, 34.58108], [-119.98497, 34.58333], [-119.9867, 34.5857], [-119.98673, 34.58669], [-119.98993, 34.58837], [-119.99126, 34.58835], [-119.99132, 34.59119]], [[-119.96003, 34.57872], [-119.96001, 34.57871], [-119.95999, 34.57874], [-119.96001, 34.57874], [-119.96003, 34.57872]], [[-119.9602, 34.57863], [-119.96019, 34.57861], [-119.96011, 34.57862], [-119.96009, 34.57865], [-119.9602, 34.57863]]]]} | Open Access 1 | 1340 | Cachuma Lake Recreation Area | 13798 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 9563.006 | Cachuma Lake Rec. Area | 0 | Local Recreation Area 3 | 4 | |
16649 | 16649 | 16648 | {"type": "MultiPolygon", "coordinates": [[[[-118.34831, 34.00313], [-118.34773, 34.00358], [-118.3476, 34.00373], [-118.34747, 34.00393], [-118.3474, 34.0041], [-118.34731, 34.00446], [-118.34727, 34.0045], [-118.34641, 34.00439], [-118.34582, 34.00436], [-118.3424, 34.00438], [-118.34203, 34.00442], [-118.34175, 34.00448], [-118.3417, 34.00434], [-118.34169, 34.00402], [-118.34342, 34.00384], [-118.34413, 34.00379], [-118.34579, 34.00333], [-118.34655, 34.0035], [-118.34712, 34.0035], [-118.34815, 34.00291], [-118.34831, 34.00313]]], [[[-118.35757, 33.99682], [-118.35756, 33.99689], [-118.35692, 33.99745], [-118.35673, 33.99772], [-118.35663, 33.99797], [-118.35659, 33.99814], [-118.35638, 33.99942], [-118.35633, 33.99965], [-118.35627, 33.99982], [-118.3561, 34.00016], [-118.35594, 34.0004], [-118.35561, 34.00076], [-118.35538, 34.00096], [-118.3546, 34.00146], [-118.35408, 34.00186], [-118.35375, 34.00217], [-118.35199, 34.00392], [-118.35175, 34.00413], [-118.35132, 34.00443], [-118.35113, 34.00452], [-118.35079, 34.00466], [-118.35042, 34.00476], [-118.35005, 34.00483], [-118.34983, 34.00485], [-118.34945, 34.00485], [-118.34902, 34.00481], [-118.34755, 34.00456], [-118.34751, 34.00452], [-118.34751, 34.00448], [-118.34758, 34.00419], [-118.34768, 34.00395], [-118.34776, 34.00384], [-118.34786, 34.00371], [-118.34801, 34.00357], [-118.34838, 34.0033], [-118.34859, 34.00348], [-118.34836, 34.00366], [-118.34859, 34.00376], [-118.34853, 34.00386], [-118.34927, 34.00403], [-118.35055, 34.00383], [-118.35158, 34.00351], [-118.35234, 34.00286], [-118.3527, 34.0022], [-118.35302, 34.00192], [-118.35409, 34.001], [-118.35517, 34.00047], [-118.35562, 34.0], [-118.35649, 33.99812], [-118.3566, 33.99764], [-118.35664, 33.99732], [-118.35661, 33.997], [-118.35729, 33.99636], [-118.35757, 33.99682]]], [[[-118.35787, 34.00675], [-118.35897, 34.00314], [-118.35972, 34.00328], [-118.36002, 34.00231], [-118.35926, 34.00215], [-118.35934, 34.00188], [-118.35937, 34.00168], [-118.35937, 34.00136], [-118.35931, 34.00106], [-118.35917, 34.00073], [-118.35898, 34.00045], [-118.35864, 33.99978], [-118.35847, 33.99934], [-118.35835, 33.99888], [-118.35823, 33.99812], [-118.35823, 33.99798], [-118.35813, 33.99742], [-118.35813, 33.99736], [-118.35817, 33.9973], [-118.3583, 33.99719], [-118.35839, 33.99715], [-118.35883, 33.99703], [-118.35919, 33.99777], [-118.35965, 33.99887], [-118.3597, 33.9989], [-118.35995, 33.99936], [-118.36004, 33.99933], [-118.3601, 33.999], [-118.36013, 33.99897], [-118.36028, 33.99899], [-118.3606, 33.99918], [-118.36063, 33.99924], [-118.36063, 33.99934], [-118.36063, 33.99945], [-118.3606, 33.99957], [-118.36053, 33.99973], [-118.36041, 33.99977], [-118.36034, 33.99984], [-118.36032, 33.9999], [-118.36032, 33.99998], [-118.36038, 34.00007], [-118.36042, 34.00011], [-118.36051, 34.00013], [-118.36052, 34.00016], [-118.36105, 34.00019], [-118.36114, 34.00035], [-118.36114, 34.00042], [-118.3611, 34.00048], [-118.36082, 34.00057], [-118.36092, 34.00077], [-118.36153, 34.00056], [-118.36155, 34.00062], [-118.36145, 34.0008], [-118.36142, 34.00091], [-118.3613, 34.00108], [-118.3613, 34.00114], [-118.36135, 34.00121], [-118.36178, 34.00149], [-118.36212, 34.00184], [-118.3623, 34.00174], [-118.36223, 34.00166], [-118.36225, 34.00157], [-118.36228, 34.00154], [-118.36235, 34.00154], [-118.36278, 34.0017], [-118.36278, 34.00298], [-118.36273, 34.00313], [-118.36273, 34.00359], [-118.36275, 34.00364], [-118.3628, 34.00367], [-118.3631, 34.00368], [-118.36316, 34.0037], [-118.36319, 34.00374], [-118.36323, 34.00383], [-118.36324, 34.00399], [-118.36319, 34.00413], [-118.3631, 34.00423], [-118.36282, 34.00437], [-118.36276, 34.00446], [-118.36273, 34.00547], [-118.36302, 34.00544], [-118.36328, 34.00596], [-118.36435, 34.00558], [-118.36468, 34.00566], [-118.36502, 34.00555], [-118.36533, 34.00575], [-118.36572, 34.00574], [-118.36598, 34.00579], [-118.36632, 34.0058], [-118.36631, 34.006], [-118.36636, 34.00605], [-118.36648, 34.00606], [-118.36656, 34.00613], [-118.36689, 34.00614], [-118.36671, 34.00951], [-118.36649, 34.00944], [-118.36567, 34.00934], [-118.36566, 34.00941], [-118.36559, 34.00955], [-118.36551, 34.00967], [-118.36542, 34.00976], [-118.3658, 34.01021], [-118.36576, 34.01079], [-118.3647, 34.01095], [-118.36353, 34.01238], [-118.36301, 34.01239], [-118.36265, 34.00988], [-118.36257, 34.00983], [-118.3624, 34.00969], [-118.36234, 34.00961], [-118.36226, 34.00946], [-118.36221, 34.00929], [-118.36216, 34.0086], [-118.36176, 34.00861], [-118.36139, 34.00885], [-118.36069, 34.00903], [-118.36059, 34.00947], [-118.36081, 34.01031], [-118.36081, 34.01046], [-118.36079, 34.01051], [-118.36071, 34.01051], [-118.36066, 34.01048], [-118.36064, 34.01035], [-118.36061, 34.0103], [-118.36053, 34.01022], [-118.36016, 34.01048], [-118.35993, 34.01057], [-118.35958, 34.01057], [-118.35944, 34.01133], [-118.35888, 34.01123], [-118.35872, 34.01176], [-118.35801, 34.01162], [-118.35746, 34.01135], [-118.35713, 34.01164], [-118.35676, 34.01253], [-118.35625, 34.01245], [-118.35572, 34.01241], [-118.3558, 34.01214], [-118.35597, 34.01181], [-118.35611, 34.01161], [-118.35636, 34.01132], [-118.35706, 34.01063], [-118.3573, 34.01034], [-118.35742, 34.01017], [-118.35752, 34.00999], [-118.35767, 34.00966], [-118.35777, 34.0093], [-118.35866, 34.00922], [-118.36114, 34.00859], [-118.36145, 34.00849], [-118.36143, 34.00833], [-118.35861, 34.00905], [-118.3578, 34.00913], [-118.35782, 34.00868], [-118.3577, 34.00777], [-118.35772, 34.00736], [-118.35787, 34.00675]], [[-118.36462, 34.00779], [-118.36456, 34.0074], [-118.36387, 34.0075], [-118.36414, 34.00882], [-118.36479, 34.00874], [-118.36462, 34.00779]], [[-118.36192, 34.0073], [-118.36187, 34.00715], [-118.36148, 34.00725], [-118.36159, 34.00757], [-118.36198, 34.00748], [-118.36197, 34.00729], [-118.36192, 34.0073]]], [[[-118.37393, 34.01466], [-118.37395, 34.01485], [-118.37394, 34.0152], [-118.37391, 34.01541], [-118.37382, 34.01581], [-118.3737, 34.01614], [-118.37359, 34.0164], [-118.37276, 34.01791], [-118.37253, 34.01802], [-118.37256, 34.01751], [-118.37183, 34.01748], [-118.3712, 34.01725], [-118.37128, 34.01706], [-118.37118, 34.01685], [-118.37109, 34.01682], [-118.37133, 34.01636], [-118.37063, 34.01611], [-118.37026, 34.01593], [-118.37033, 34.01575], [-118.36672, 34.01562], [-118.36689, 34.0123], [-118.36709, 34.01102], [-118.36736, 34.00572], [-118.36938, 34.0058], [-118.36948, 34.00592], [-118.37003, 34.00645], [-118.37011, 34.00668], [-118.37023, 34.00718], [-118.37035, 34.00732], [-118.37056, 34.00747], [-118.37077, 34.00767], [-118.37082, 34.00774], [-118.37117, 34.00874], [-118.3715, 34.00958], [-118.3719, 34.0107], [-118.37209, 34.01116], [-118.37206, 34.01121], [-118.37215, 34.01131], [-118.37228, 34.01135], [-118.37248, 34.01135], [-118.37279, 34.01143], [-118.37287, 34.01141], [-118.37285, 34.01163], [-118.37286, 34.01191], [-118.37288, 34.01215], [-118.37293, 34.01231], [-118.37293, 34.01239], [-118.37288, 34.01247], [-118.37277, 34.01254], [-118.37284, 34.01268], [-118.37296, 34.01267], [-118.37308, 34.01274], [-118.3732, 34.01294], [-118.37353, 34.01338], [-118.37362, 34.01353], [-118.37369, 34.01368], [-118.37376, 34.01387], [-118.37393, 34.01466]]], [[[-118.38515, 34.01768], [-118.38493, 34.01795], [-118.38487, 34.01797], [-118.38488, 34.01808], [-118.38482, 34.01861], [-118.38479, 34.01875], [-118.38468, 34.01905], [-118.38463, 34.01912], [-118.38483, 34.01923], [-118.38433, 34.01942], [-118.38449, 34.0198], [-118.38271, 34.02031], [-118.38222, 34.02043], [-118.38131, 34.02057], [-118.38089, 34.02012], [-118.38051, 34.01986], [-118.37953, 34.01922], [-118.3791, 34.01929], [-118.37905, 34.01924], [-118.37943, 34.01918], [-118.37944, 34.01917], [-118.37876, 34.01873], [-118.37798, 34.01802], [-118.37914, 34.0173], [-118.37917, 34.01717], [-118.37924, 34.01718], [-118.37942, 34.01713], [-118.38069, 34.01635], [-118.38063, 34.01624], [-118.38053, 34.01615], [-118.38065, 34.01613], [-118.38061, 34.01581], [-118.38068, 34.01557], [-118.38064, 34.01526], [-118.38028, 34.01448], [-118.38298, 34.01585], [-118.38295, 34.01592], [-118.38465, 34.01689], [-118.38437, 34.01723], [-118.38515, 34.01768]], [[-118.38399, 34.01729], [-118.384, 34.01727], [-118.38397, 34.01715], [-118.38387, 34.017], [-118.38379, 34.01693], [-118.38372, 34.01689], [-118.38355, 34.01685], [-118.38334, 34.01686], [-118.38317, 34.01694], [-118.38303, 34.01707], [-118.38297, 34.01723], [-118.38298, 34.01737], [-118.38304, 34.0175], [-118.38312, 34.01758], [-118.38322, 34.01764], [-118.3834, 34.0177], [-118.38362, 34.01769], [-118.38369, 34.01767], [-118.38381, 34.0176], [-118.38395, 34.01746], [-118.38399, 34.01735], [-118.38399, 34.01729]]]]} | Open Access 1 | 6297 | Kenneth Hahn State Recreation Area | 32640 | 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 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=612 | Los Angeles 6 | 396.851 | Kenneth Hahn SRA | 0 | Local Recreation Area 3 | 4 |
12095 | 12095 | 12094 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.2692, 38.03185], [-122.26868, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | 24918 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.708 | Lefty Gomez Ballfield Complex | 0 | Local Recreation Area 3 | 4 | |
15875 | 15875 | 15874 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | 15091 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.396 | Montara Bay Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
12322 | 12322 | 12321 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | 25985 | Kings river Access Park | 20661 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 7.286 | Kings river Access Park | 0 | Local Recreation Area 3 | 4 | |
15708 | 15708 | 15707 | {"type": "Polygon", "coordinates": [[[-119.91096, 36.84512], [-119.90786, 36.84617], [-119.90717, 36.84638], [-119.90647, 36.84658], [-119.90541, 36.84683], [-119.90469, 36.84697], [-119.90396, 36.8471], [-119.90287, 36.84725], [-119.90247, 36.84764], [-119.89722, 36.84425], [-119.90643, 36.84421], [-119.90626, 36.84057], [-119.90871, 36.84057], [-119.91065, 36.84027], [-119.91086, 36.84418], [-119.91096, 36.84418], [-119.91096, 36.84512]]]} | Restricted Access 2 | 25955 | Riverside Municipal Golf Course | 33087 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 107.589 | Riverside Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16711 | 16711 | 16710 | {"type": "Polygon", "coordinates": [[[-119.74048, 36.9629], [-119.74046, 36.96322], [-119.74044, 36.96339], [-119.73993, 36.96544], [-119.73943, 36.96697], [-119.73768, 36.97137], [-119.73595, 36.97372], [-119.73239, 36.97692], [-119.73129, 36.97793], [-119.73031, 36.97791], [-119.72304, 36.97794], [-119.72301, 36.97562], [-119.72458, 36.9743], [-119.72577, 36.9743], [-119.72576, 36.97335], [-119.72618, 36.97296], [-119.72661, 36.9725], [-119.727, 36.97202], [-119.72727, 36.97165], [-119.72758, 36.97113], [-119.72785, 36.9706], [-119.72803, 36.97019], [-119.72821, 36.96964], [-119.72832, 36.96922], [-119.72846, 36.96849], [-119.72876, 36.96559], [-119.72882, 36.96514], [-119.72884, 36.96481], [-119.72883, 36.96447], [-119.72878, 36.96392], [-119.72872, 36.96359], [-119.72864, 36.96326], [-119.72779, 36.96087], [-119.73636, 36.96082], [-119.73638, 36.96293], [-119.74048, 36.9629]]]} | Open Access 1 | 25929 | Lost Lake Recreation Area | 21541 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 425.466 | Lost Lake Rec. Area | 0 | Local Recreation Area 3 | 4 | |
9685 | 9685 | 9684 | {"type": "MultiPolygon", "coordinates": [[[[-119.30563, 35.2353], [-119.30545, 35.23513], [-119.30517, 35.23486], [-119.3056, 35.23496], [-119.30563, 35.2353]]], [[[-119.3058, 35.23952], [-119.30548, 35.23941], [-119.30568, 35.23894], [-119.30579, 35.23899], [-119.3058, 35.23952]]], [[[-119.30565, 35.23862], [-119.30561, 35.23877], [-119.30536, 35.23934], [-119.30517, 35.23932], [-119.30488, 35.23973], [-119.30337, 35.24084], [-119.30262, 35.24121], [-119.30201, 35.2405], [-119.3035, 35.2389], [-119.30306, 35.23859], [-119.30383, 35.23859], [-119.3029, 35.23803], [-119.30249, 35.23804], [-119.30177, 35.23774], [-119.30056, 35.2374], [-119.28883, 35.23473], [-119.28882, 35.23474], [-119.2889, 35.23849], [-119.28635, 35.23847], [-119.28635, 35.23529], [-119.28021, 35.23526], [-119.27987, 35.23525], [-119.2792, 35.23519], [-119.27852, 35.2351], [-119.27819, 35.23503], [-119.2777, 35.23492], [-119.27722, 35.23479], [-119.27629, 35.23446], [-119.27199, 35.2325], [-119.27135, 35.23225], [-119.27025, 35.23194], [-119.26938, 35.2318], [-119.26879, 35.23174], [-119.26835, 35.23173], [-119.26019, 35.23176], [-119.25927, 35.23169], [-119.25813, 35.23154], [-119.257, 35.2313], [-119.25592, 35.23098], [-119.25528, 35.23076], [-119.25486, 35.23059], [-119.25388, 35.23015], [-119.2537, 35.23003], [-119.2535, 35.22995], [-119.25269, 35.22947], [-119.25204, 35.22903], [-119.25138, 35.2285], [-119.25061, 35.22779], [-119.2495, 35.22664], [-119.23717, 35.23667], [-119.23704, 35.23659], [-119.23632, 35.2372], [-119.23611, 35.23751], [-119.23597, 35.23791], [-119.23597, 35.23797], [-119.23549, 35.23797], [-119.23557, 35.23767], [-119.23566, 35.23745], [-119.23581, 35.23719], [-119.23595, 35.23701], [-119.23616, 35.23679], [-119.23674, 35.23633], [-119.23669, 35.23625], [-119.24905, 35.22618], [-119.24654, 35.22363], [-119.23598, 35.21269], [-119.23589, 35.20903], [-119.23857, 35.20905], [-119.2527, 35.21503], [-119.27023, 35.22232], [-119.27027, 35.22295], [-119.27246, 35.22385], [-119.28807, 35.23043], [-119.28888, 35.23064], [-119.28925, 35.23044], [-119.28946, 35.23015], [-119.28949, 35.22964], [-119.28958, 35.22945], [-119.28968, 35.22936], [-119.28988, 35.22932], [-119.29037, 35.22933], [-119.29072, 35.22943], [-119.30292, 35.23352], [-119.30535, 35.23718], [-119.30536, 35.23732], [-119.30536, 35.23752], [-119.30533, 35.23775], [-119.30526, 35.23804], [-119.30512, 35.23836], [-119.30498, 35.23858], [-119.30538, 35.23862], [-119.30565, 35.23862]]]]} | Open Access 1 | 16326 | Buena Vista Aquatic Recreation Area | 4788 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/buena-vista.asp | Kern 36 | 1578.796 | Buena Vista Aquatic Rec. Area | 0 | Local Recreation Area 3 | 4 |
15718 | 15718 | 15717 | {"type": "Polygon", "coordinates": [[[-118.86048, 35.43724], [-118.86016, 35.4381], [-118.86002, 35.43895], [-118.85983, 35.4394], [-118.8594, 35.44002], [-118.85729, 35.4433], [-118.85404, 35.44375], [-118.85191, 35.44323], [-118.85136, 35.44191], [-118.85208, 35.44189], [-118.85209, 35.44188], [-118.85187, 35.44165], [-118.85179, 35.44152], [-118.8517, 35.44143], [-118.85151, 35.44114], [-118.85136, 35.4408], [-118.85127, 35.44037], [-118.85124, 35.4397], [-118.85125, 35.43952], [-118.85142, 35.43847], [-118.85168, 35.4376], [-118.85179, 35.43699], [-118.85188, 35.43672], [-118.85194, 35.43629], [-118.85201, 35.43606], [-118.85205, 35.43585], [-118.85218, 35.43553], [-118.85249, 35.43501], [-118.85257, 35.43462], [-118.85274, 35.43427], [-118.85284, 35.43411], [-118.85288, 35.4338], [-118.85293, 35.43364], [-118.85293, 35.4334], [-118.853, 35.43324], [-118.85845, 35.4332], [-118.85874, 35.43316], [-118.85964, 35.43288], [-118.86022, 35.43526], [-118.86031, 35.43629], [-118.86048, 35.43724]]]} | Restricted Access 2 | 44512 | Kern River Golf Course | 33105 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 196.033 | Kern River GC | 0 | Local Recreation Area 3 | 4 | |
16925 | 16925 | 16924 | {"type": "Polygon", "coordinates": [[[-119.02667, 35.39563], [-119.02663, 35.3959], [-119.02664, 35.39629], [-119.02662, 35.39646], [-119.02651, 35.39681], [-119.02638, 35.39701], [-119.02618, 35.39724], [-119.02598, 35.3974], [-119.02582, 35.39749], [-119.02557, 35.39761], [-119.02484, 35.39761], [-119.02316, 35.39817], [-119.02118, 35.39851], [-119.02117, 35.39894], [-119.01888, 35.39893], [-119.01891, 35.39267], [-119.01979, 35.39267], [-119.01979, 35.39195], [-119.02098, 35.39198], [-119.02096, 35.3976], [-119.02119, 35.39758], [-119.02118, 35.39217], [-119.02214, 35.39216], [-119.02667, 35.39563]]]} | Open Access 1 | 16493 | Metropolitan Recreation Center | 22188 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 93.734 | Metropolitan Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
930 | 930 | 929 | {"type": "Polygon", "coordinates": [[[-118.35399, 33.79067], [-118.35035, 33.79268], [-118.35001, 33.7929], [-118.34972, 33.79315], [-118.34952, 33.79335], [-118.34927, 33.7937], [-118.34853, 33.79307], [-118.34875, 33.79282], [-118.34783, 33.79205], [-118.34783, 33.79015], [-118.34362, 33.78659], [-118.34517, 33.78551], [-118.34559, 33.7853], [-118.34583, 33.7852], [-118.34609, 33.78513], [-118.34641, 33.78506], [-118.34996, 33.78455], [-118.35025, 33.78449], [-118.35084, 33.78427], [-118.35136, 33.78464], [-118.35157, 33.78445], [-118.3532, 33.7856], [-118.35399, 33.79067]]]} | No Public Access 3 | 5917 | South Coast Park/Peter Weber Equestrian Center | 29016 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 141.298 | South Coast Park/Peter Weber Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
1632 | 1632 | 1631 | {"type": "Polygon", "coordinates": [[[-118.00413, 33.90582], [-118.00266, 33.9058], [-118.00229, 33.90591], [-118.0005, 33.9071], [-118.00033, 33.90729], [-118.00022, 33.90737], [-118.00018, 33.90743], [-117.99885, 33.90986], [-117.99444, 33.90988], [-117.99438, 33.90984], [-117.99434, 33.90424], [-117.99435, 33.90374], [-117.99441, 33.90318], [-117.99449, 33.90284], [-117.99455, 33.9028], [-118.00302, 33.90275], [-118.00303, 33.9028], [-118.00324, 33.90281], [-118.00329, 33.90286], [-118.0033, 33.90333], [-118.00333, 33.90358], [-118.00337, 33.90378], [-118.00343, 33.90396], [-118.00405, 33.90551], [-118.00413, 33.90582]]]} | Restricted Access 2 | 45404 | La Mirada Golf Course | 33111 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/La_Mirada_Golf_Course | Los Angeles 6 | 131.179 | La Mirada GC | 0 | Local Recreation Area 3 | 4 |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 4 | |
3123 | 3123 | 3122 | {"type": "Polygon", "coordinates": [[[-118.41805, 34.31271], [-118.4166, 34.314], [-118.4166, 34.31401], [-118.41582, 34.3146], [-118.41577, 34.31471], [-118.41592, 34.31502], [-118.41611, 34.31503], [-118.41609, 34.31522], [-118.41572, 34.31521], [-118.41572, 34.31529], [-118.41544, 34.31527], [-118.41495, 34.31527], [-118.4138, 34.31568], [-118.41347, 34.31573], [-118.41317, 34.3157], [-118.411, 34.31509], [-118.41012, 34.31425], [-118.41031, 34.31237], [-118.41054, 34.3115], [-118.41012, 34.31103], [-118.41026, 34.31092], [-118.41148, 34.31205], [-118.41155, 34.31189], [-118.4113, 34.31165], [-118.41147, 34.31141], [-118.412, 34.31043], [-118.41191, 34.30973], [-118.41258, 34.3094], [-118.41299, 34.3091], [-118.41356, 34.30864], [-118.4136, 34.30864], [-118.41634, 34.31122], [-118.41805, 34.31271]]]} | Restricted Access 2 | 48023 | El Cariso Golf Course | 32460 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 85.199 | El Cariso GC | 0 | Local Recreation Area 3 | 4 | |
4892 | 4892 | 4891 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15336, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83584], [-118.15123, 33.83648], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83875], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14676, 33.83715], [-118.14799, 33.83893], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83639], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.1547, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82898], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | 45718 | Lakewood Golf Course | 33113 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | Los Angeles 6 | 176.286 | Lakewood GC | 0 | Local Recreation Area 3 | 4 |
4893 | 4893 | 4892 | {"type": "Polygon", "coordinates": [[[-118.16594, 33.93752], [-118.16221, 33.93558], [-118.16115, 33.93702], [-118.16153, 33.93723], [-118.16126, 33.93762], [-118.165, 33.9395], [-118.16218, 33.94234], [-118.16209, 33.94232], [-118.15913, 33.94078], [-118.16046, 33.93896], [-118.15653, 33.93691], [-118.15822, 33.93461], [-118.15991, 33.93242], [-118.16013, 33.93217], [-118.16097, 33.93257], [-118.16356, 33.93388], [-118.16407, 33.93321], [-118.16436, 33.9333], [-118.16477, 33.93321], [-118.16508, 33.93298], [-118.16609, 33.93537], [-118.16594, 33.93752]]]} | Restricted Access 2 | 45855 | Los Amigos Golf Course | 32491 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3D3ANNDPULsh0VAQpfACU!/ | Los Angeles 6 | 120.886 | Los Amigos GC | 0 | Local Recreation Area 3 | 4 |
4969 | 4969 | 4968 | {"type": "Polygon", "coordinates": [[[-118.52638, 34.34108], [-118.52584, 34.34096], [-118.52536, 34.34088], [-118.52304, 34.34055], [-118.52197, 34.34042], [-118.52208, 34.33992], [-118.523, 34.33996], [-118.5235, 34.33945], [-118.52521, 34.3407], [-118.52551, 34.34042], [-118.52602, 34.34081], [-118.5261, 34.34068], [-118.52638, 34.34073], [-118.52638, 34.34108]]]} | Open Access 1 | 7304 | Michael D Antonovich Open Space | 6049 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.lamountains.com/parks.asp?parkid=8 | Los Angeles 6 | 6.265 | Michael D Antonovich OS | 0 | Local Recreation Area 3 | 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]);