units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
117 rows where DES_TP = 3 and MNG_AG_TYP = 3 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 23
- Los Angeles, County of 31
- Santa Barbara, County of 19
- 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
- Riverside, County of 5
- Ventura, County of 4
- Fresno, County of 3
- Kern, County of 3
- Placer, County of 2
- San Bernardino, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Yolo, County of 2
- Lake, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Amador, County of 1
- Colusa, County of 1
- Sutter, County of 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 117 ✖
DES_TP 1
- Local Recreation Area · 117 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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 |
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04224, 34.13217], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04259, 34.13197], [-118.04251, 34.13188], [-118.04241, 34.13199], [-118.04249, 34.13208], [-118.04259, 34.13197]]]} | Restricted Access 2 | 7018 | Santa Anita Golf Course | 33023 | 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 | 130.957 | Santa Anita GC | 0 | Local Recreation Area 3 | 4 | |
7776 | 7776 | 7775 | {"type": "Polygon", "coordinates": [[[-118.60408, 34.12532], [-118.60355, 34.12532], [-118.60343, 34.12511], [-118.60322, 34.12504], [-118.60322, 34.12533], [-118.60305, 34.12533], [-118.60305, 34.12497], [-118.60288, 34.12491], [-118.6019, 34.12492], [-118.6019, 34.12487], [-118.60222, 34.12486], [-118.60221, 34.12436], [-118.60228, 34.12438], [-118.60229, 34.12486], [-118.60291, 34.12486], [-118.60349, 34.12507], [-118.6036, 34.12527], [-118.60408, 34.12526], [-118.60408, 34.12532]]]} | Open Access 1 | 6423 | Canyon Oaks Open Space Access | 16820 | 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 | 0.571 | Canyon Oaks OS Access | 0 | Local Recreation Area 3 | 4 | |
8309 | 8309 | 8308 | {"type": "Polygon", "coordinates": [[[-118.60165, 34.05301], [-118.60165, 34.05347], [-118.60118, 34.05348], [-118.60118, 34.05301], [-118.60165, 34.05301]]]} | No Public Access 3 | 12776 | Los Angeles County Open Space | 21480 | 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 | 0.548 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
8322 | 8322 | 8321 | {"type": "Polygon", "coordinates": [[[-118.60332, 34.08036], [-118.60312, 34.08066], [-118.60292, 34.08071], [-118.60319, 34.08034], [-118.60332, 34.08036]]]} | Open Access 1 | 12773 | Los Angeles County Open Space | 21481 | 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 | 0.131 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
9780 | 9780 | 9779 | {"type": "Polygon", "coordinates": [[[-118.63702, 34.45237], [-118.63703, 34.45246], [-118.63701, 34.45251], [-118.63659, 34.45296], [-118.63652, 34.45292], [-118.63652, 34.45288], [-118.63643, 34.45278], [-118.63616, 34.45261], [-118.63605, 34.45258], [-118.63601, 34.45258], [-118.63597, 34.45263], [-118.63589, 34.4526], [-118.63582, 34.45248], [-118.63576, 34.45241], [-118.63541, 34.45209], [-118.63522, 34.45196], [-118.63509, 34.45188], [-118.63491, 34.45173], [-118.63482, 34.45162], [-118.63482, 34.45156], [-118.63492, 34.45143], [-118.63508, 34.45129], [-118.63542, 34.45113], [-118.63578, 34.45131], [-118.63605, 34.45148], [-118.63627, 34.45166], [-118.63652, 34.45162], [-118.63658, 34.45164], [-118.63659, 34.45166], [-118.63663, 34.45196], [-118.63675, 34.45213], [-118.63683, 34.45227], [-118.63697, 34.45233], [-118.63702, 34.45237]]]} | Open Access 1 | 47885 | Hasley Canyon Equestrian Park | 31829 | 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/hasley-canyon-equestrian-park/ | Los Angeles 6 | 4.746 | Hasley Canyon Equestrian Park | 0 | Local Recreation Area 3 | 4 |
12112 | 12112 | 12111 | {"type": "Polygon", "coordinates": [[[-118.61656, 34.48907], [-118.6132, 34.48908], [-118.61156, 34.48447], [-118.61157, 34.48188], [-118.61217, 34.48188], [-118.61218, 34.48184], [-118.61371, 34.48184], [-118.61372, 34.4819], [-118.61391, 34.48191], [-118.61407, 34.48241], [-118.61404, 34.48241], [-118.61406, 34.48249], [-118.61412, 34.48252], [-118.61473, 34.48408], [-118.6155, 34.48581], [-118.61579, 34.48675], [-118.61601, 34.4873], [-118.61656, 34.48907]]]} | Open Access 1 | 25034 | Castaic Sports Complex | 16946 | 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 | 58.013 | Castaic Sports Complex | 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]);