units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
168 rows where ACCESS_TYP = 2, DES_TP = 3 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER
MNG_AGENCY >30
- Los Angeles, City of 10
- Santa Cruz, City of 7
- San Diego, City of 5
- San Jose, City of 5
- Long Beach, City of 5
- Santa Ana, City of 4
- San Bernardino, City of 4
- San Luis Obispo, City of 3
- Carlsbad, City of 3
- Pomona, City of 3
- Needles, City of 3
- Torrance, City of 3
- El Segundo, City of 3
- Stockton, City of 3
- Modesto, City of 3
- Roseville, City of 3
- San Gabriel, City of 3
- San Francisco, City and County of 2
- Santa Barbara, City of 2
- Glendale, City of 2
- Coronado, City of 2
- Ventura, City of 2
- Burbank, City of 2
- Riverside, City of 2
- Hollister, City of 2
- El Monte, City of 2
- South Pasadena, City of 2
- Gilroy, City of 2
- Sunnyvale, City of 2
- South El Monte, City of 2
- …
MNG_AG_TYP 1
- City Agency · 168 ✖
DES_TP 1
- Local Recreation Area · 168 ✖
ACCESS_TYP 1
- Restricted Access · 168 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
8257 | 8257 | 8256 | {"type": "Polygon", "coordinates": [[[-118.11967, 34.09049], [-118.11966, 34.09074], [-118.11234, 34.09388], [-118.10973, 34.0882], [-118.10992, 34.08814], [-118.10934, 34.08688], [-118.1091, 34.08626], [-118.10941, 34.08615], [-118.10899, 34.08523], [-118.10881, 34.08475], [-118.11269, 34.08456], [-118.11268, 34.08483], [-118.11269, 34.0859], [-118.11273, 34.08679], [-118.11276, 34.08697], [-118.11298, 34.08739], [-118.1137, 34.08774], [-118.11393, 34.08771], [-118.11418, 34.08766], [-118.11449, 34.08765], [-118.11449, 34.08813], [-118.11461, 34.08814], [-118.11486, 34.08831], [-118.11491, 34.08836], [-118.11491, 34.08858], [-118.11575, 34.08939], [-118.11563, 34.08939], [-118.11563, 34.0896], [-118.11567, 34.08964], [-118.1157, 34.08965], [-118.11577, 34.08965], [-118.11578, 34.08941], [-118.11591, 34.08929], [-118.11685, 34.08929], [-118.11686, 34.09051], [-118.11967, 34.09049]]]} | Restricted Access 2 | 45406 | Alhambra Municipal Golf Course | 33112 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://alhambragolf.com/ag/ | Los Angeles 6 | 107.021 | Alhambra Municipal GC | 0 | Local Recreation Area 3 | 4 |
15669 | 15669 | 15668 | {"type": "MultiPolygon", "coordinates": [[[[-118.02002, 34.10015], [-118.01922, 34.10279], [-118.01789, 34.10253], [-118.0166, 34.10528], [-118.01621, 34.10549], [-118.01575, 34.10339], [-118.01574, 34.10313], [-118.01578, 34.1029], [-118.0159, 34.10259], [-118.01597, 34.10246], [-118.01711, 34.10129], [-118.01857, 34.10015], [-118.01908, 34.09991], [-118.02002, 34.10015]]], [[[-118.01617, 34.10551], [-118.01607, 34.10557], [-118.01603, 34.10544], [-118.01577, 34.10423], [-118.01587, 34.10418], [-118.01617, 34.10551]]]]} | Restricted Access 2 | 7036 | Arcadia Par-3 Golf Course | 33024 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 25.879 | Arcadia Par-3 GC | 0 | Local Recreation Area 3 | 4 | |
7233 | 7233 | 7232 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17064, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11715], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.16631, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | 6930 | Arroyo Seco Golf Course | 29411 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.arroyosecogolf.com/Home.html | Los Angeles 6 | 31.16 | Arroyo Seco GC | 0 | Local Recreation Area 3 | 4 |
15196 | 15196 | 15195 | {"type": "Polygon", "coordinates": [[[-118.17123, 34.11541], [-118.16918, 34.11752], [-118.16899, 34.11733], [-118.16859, 34.11755], [-118.16857, 34.11757], [-118.16862, 34.11762], [-118.16806, 34.11775], [-118.168, 34.11744], [-118.16778, 34.11722], [-118.1684, 34.11659], [-118.1687, 34.11633], [-118.16957, 34.11604], [-118.1699, 34.11588], [-118.17023, 34.11568], [-118.17064, 34.11524], [-118.17123, 34.11541]]]} | Restricted Access 2 | 46069 | Arroyo Seco Racquet Center | 29412 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/index.aspx?page=66 | Los Angeles 6 | 7.411 | Arroyo Seco Racquet Ctr. | 0 | Local Recreation Area 3 | 4 |
6254 | 6254 | 6253 | {"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]} | Restricted Access 2 | 1327 | Barrett Reservoir | 15833 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/water/recreation/reservoirs/barrett | San Diego 4 | 4177.221 | Barrett Reservoir | 0 | Local Recreation Area 3 | 4 |
9447 | 9447 | 9446 | {"type": "Polygon", "coordinates": [[[-121.82991, 36.63229], [-121.82592, 36.63574], [-121.82568, 36.63592], [-121.82546, 36.63603], [-121.82507, 36.63615], [-121.82474, 36.63618], [-121.81961, 36.63593], [-121.81935, 36.63593], [-121.81911, 36.63596], [-121.81872, 36.63606], [-121.81842, 36.6362], [-121.8183, 36.63628], [-121.81716, 36.63727], [-121.81692, 36.63709], [-121.81597, 36.63671], [-121.81592, 36.63661], [-121.81575, 36.63637], [-121.81533, 36.63587], [-121.81503, 36.63572], [-121.81455, 36.63544], [-121.81353, 36.63481], [-121.8128, 36.63419], [-121.81388, 36.63201], [-121.81361, 36.63084], [-121.81575, 36.62643], [-121.81895, 36.62681], [-121.82132, 36.62198], [-121.82148, 36.62204], [-121.82208, 36.62234], [-121.82269, 36.62251], [-121.82291, 36.6226], [-121.82351, 36.62312], [-121.82385, 36.6233], [-121.82411, 36.62337], [-121.82463, 36.62366], [-121.82508, 36.62391], [-121.82592, 36.62448], [-121.82574, 36.62606], [-121.82589, 36.62664], [-121.82609, 36.62719], [-121.82662, 36.62852], [-121.82696, 36.62899], [-121.82756, 36.62939], [-121.82804, 36.62959], [-121.82889, 36.62973], [-121.82916, 36.63084], [-121.82912, 36.6309], [-121.82991, 36.63229]]]} | Restricted Access 2 | 17283 | Bayonet Black Horse Golf Course | 33056 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 373.525 | Bayonet Black Horse GC | 0 | Local Recreation Area 3 | 4 | |
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 4 | |
15705 | 15705 | 15704 | {"type": "Polygon", "coordinates": [[[-119.96788, 38.93696], [-119.96716, 38.93808], [-119.96692, 38.93882], [-119.96734, 38.93893], [-119.96695, 38.93973], [-119.96669, 38.94016], [-119.9666, 38.94043], [-119.9664, 38.94068], [-119.96631, 38.94081], [-119.96625, 38.94096], [-119.96611, 38.94122], [-119.96603, 38.94149], [-119.96602, 38.94177], [-119.96604, 38.94205], [-119.96572, 38.94257], [-119.96554, 38.94452], [-119.96536, 38.94453], [-119.96523, 38.94455], [-119.96498, 38.94464], [-119.96485, 38.94474], [-119.96423, 38.94526], [-119.9642, 38.94528], [-119.96415, 38.94528], [-119.964, 38.94391], [-119.96426, 38.94258], [-119.96414, 38.94251], [-119.96435, 38.94196], [-119.96434, 38.9418], [-119.96449, 38.94166], [-119.96448, 38.94092], [-119.96347, 38.94023], [-119.96245, 38.94032], [-119.96204, 38.93986], [-119.962, 38.93969], [-119.96214, 38.93955], [-119.96216, 38.93944], [-119.9634, 38.93944], [-119.9643, 38.93877], [-119.96429, 38.93697], [-119.96662, 38.93695], [-119.96788, 38.93696]]]} | Restricted Access 2 | 24106 | Bijou Municipal Golf Course | 33083 | 1411 | South Lake Tahoe, City of 990 | City 2 | City Agency 2 | http://www.cityofslt.us/index.aspx?nid=196 | City 2 | 1411 | South Lake Tahoe, City of 954 | City 2 | City Agency 2 | El Dorado 34 | 46.201 | Bijou Municipal GC | 1920 | Local Recreation Area 3 | 4 | |
15681 | 15681 | 15680 | {"type": "Polygon", "coordinates": [[[-122.06149, 37.31998], [-122.06122, 37.32014], [-122.061, 37.32033], [-122.06093, 37.32047], [-122.06052, 37.32091], [-122.0604, 37.32111], [-122.06035, 37.32174], [-122.06037, 37.32207], [-122.06071, 37.32234], [-122.06046, 37.32243], [-122.06041, 37.32289], [-122.05932, 37.32293], [-122.05955, 37.32208], [-122.05953, 37.32183], [-122.05959, 37.32144], [-122.05951, 37.3212], [-122.05948, 37.32082], [-122.05925, 37.32048], [-122.05923, 37.32027], [-122.05923, 37.3198], [-122.05918, 37.31952], [-122.05906, 37.31943], [-122.05906, 37.31811], [-122.05955, 37.31789], [-122.05996, 37.31769], [-122.06007, 37.31768], [-122.06043, 37.3185], [-122.06149, 37.31998]]]} | Restricted Access 2 | 14518 | Blackberry Farm Golf Course | 33038 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 16.747 | Blackberry Farm GC | 0 | Local Recreation Area 3 | 4 | |
15716 | 15716 | 15715 | {"type": "MultiPolygon", "coordinates": [[[[-114.63174, 33.67102], [-114.63136, 33.67121], [-114.6317, 33.67154], [-114.63029, 33.67213], [-114.63019, 33.67219], [-114.63007, 33.67228], [-114.6296, 33.67245], [-114.62854, 33.67242], [-114.62864, 33.67508], [-114.62905, 33.67656], [-114.62821, 33.67876], [-114.62699, 33.67877], [-114.62693, 33.6753], [-114.62717, 33.67529], [-114.6272, 33.67448], [-114.62636, 33.67318], [-114.62583, 33.67137], [-114.62548, 33.67142], [-114.62456, 33.67023], [-114.62454, 33.66908], [-114.62451, 33.66883], [-114.62548, 33.66835], [-114.6257, 33.66763], [-114.62713, 33.66792], [-114.62832, 33.66823], [-114.62876, 33.6679], [-114.62888, 33.66803], [-114.63117, 33.66975], [-114.63115, 33.6698], [-114.63174, 33.67102]]], [[[-114.63716, 33.67426], [-114.63696, 33.67444], [-114.63682, 33.67451], [-114.63668, 33.67455], [-114.63645, 33.67455], [-114.63559, 33.6742], [-114.63489, 33.67416], [-114.63305, 33.67433], [-114.63279, 33.67471], [-114.6315, 33.67464], [-114.63103, 33.67444], [-114.63066, 33.67398], [-114.63014, 33.67242], [-114.63027, 33.6723], [-114.63047, 33.6722], [-114.63079, 33.67252], [-114.63152, 33.67319], [-114.63294, 33.67412], [-114.63313, 33.67408], [-114.63518, 33.67316], [-114.63529, 33.67325], [-114.63554, 33.67304], [-114.63716, 33.67426]]], [[[-114.64176, 33.67399], [-114.63934, 33.6741], [-114.63888, 33.67414], [-114.63811, 33.67413], [-114.63771, 33.6741], [-114.63726, 33.67411], [-114.63626, 33.67336], [-114.6365, 33.673], [-114.63751, 33.67202], [-114.63838, 33.67164], [-114.63896, 33.67179], [-114.63921, 33.67018], [-114.63754, 33.66906], [-114.63541, 33.67002], [-114.63533, 33.66989], [-114.63508, 33.67003], [-114.63435, 33.66982], [-114.63367, 33.66935], [-114.63305, 33.6692], [-114.63206, 33.66938], [-114.63129, 33.66962], [-114.63066, 33.66915], [-114.63182, 33.66854], [-114.63309, 33.66838], [-114.63342, 33.66849], [-114.6353, 33.66929], [-114.63741, 33.66898], [-114.63762, 33.66854], [-114.63918, 33.66905], [-114.64069, 33.66844], [-114.64168, 33.6684], [-114.64171, 33.66936], [-114.64067, 33.66973], [-114.64033, 33.67008], [-114.64011, 33.6708], [-114.63953, 33.67145], [-114.63916, 33.67229], [-114.6392, 33.67231], [-114.63917, 33.67238], [-114.64052, 33.67267], [-114.64174, 33.67312], [-114.64176, 33.67399]]]]} | Restricted Access 2 | 39053 | Blythe Municipal Golf Course | 33102 | 1032 | Blythe, City of 342 | City 2 | City Agency 2 | http://www.cityofblythe.ca.gov/88/Parks-Department | City 2 | 1032 | Blythe, City of 339 | City 2 | City Agency 2 | Riverside 10 | 157.412 | Blythe Municipal GC | 0 | Local Recreation Area 3 | 4 | |
11431 | 11431 | 11430 | {"type": "Polygon", "coordinates": [[[-118.34535, 33.89046], [-118.34465, 33.89053], [-118.34471, 33.89095], [-118.34436, 33.89096], [-118.34432, 33.88985], [-118.34484, 33.88984], [-118.34485, 33.88999], [-118.34528, 33.88995], [-118.34535, 33.89046]]]} | Restricted Access 2 | 48114 | Bollinger Gymnasium | 32629 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/bollinger.pdf | Los Angeles 6 | 1.856 | Bollinger Gymnasium | 0 | Local Recreation Area 3 | 4 |
15704 | 15704 | 15703 | {"type": "Polygon", "coordinates": [[[-122.0059, 37.9266], [-122.00588, 37.92724], [-122.00532, 37.92828], [-122.0051, 37.92889], [-122.00468, 37.92966], [-122.00455, 37.92973], [-122.00424, 37.92981], [-122.00406, 37.92996], [-122.00278, 37.93026], [-122.0022, 37.9292], [-121.99905, 37.92943], [-121.99763, 37.92761], [-121.99599, 37.92776], [-121.99374, 37.92453], [-121.99457, 37.92375], [-121.99637, 37.9236], [-121.99942, 37.92264], [-122.00486, 37.92176], [-122.00508, 37.9224], [-122.0052, 37.92451], [-122.00519, 37.92546], [-122.0054, 37.9259], [-122.00549, 37.92588], [-122.00561, 37.92605], [-122.0059, 37.9266]]]} | Restricted Access 2 | 23698 | Boundary Oak Golf Course | 33081 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 159.583 | Boundary Oak GC | 0 | Local Recreation Area 3 | 4 | |
15702 | 15702 | 15701 | {"type": "MultiPolygon", "coordinates": [[[[-117.91497, 33.90831], [-117.91484, 33.90848], [-117.91467, 33.90864], [-117.91453, 33.90875], [-117.9144, 33.90883], [-117.91391, 33.90906], [-117.91312, 33.90932], [-117.91275, 33.90948], [-117.91244, 33.90963], [-117.91188, 33.90995], [-117.91038, 33.91092], [-117.90986, 33.91115], [-117.90929, 33.91152], [-117.90912, 33.91163], [-117.90869, 33.91201], [-117.90844, 33.91228], [-117.908, 33.91291], [-117.90689, 33.91291], [-117.90842, 33.91113], [-117.90921, 33.9113], [-117.90971, 33.91111], [-117.91091, 33.91015], [-117.9114, 33.90963], [-117.91173, 33.90907], [-117.91198, 33.90885], [-117.91239, 33.90854], [-117.91283, 33.90838], [-117.91293, 33.90836], [-117.91322, 33.90838], [-117.91425, 33.90836], [-117.91497, 33.90831]]], [[[-117.91559, 33.90881], [-117.91519, 33.9088], [-117.91482, 33.90887], [-117.91474, 33.90929], [-117.9144, 33.90962], [-117.91353, 33.90955], [-117.91302, 33.90979], [-117.91327, 33.91038], [-117.91303, 33.91072], [-117.912, 33.91106], [-117.91189, 33.91127], [-117.91107, 33.91127], [-117.91017, 33.91196], [-117.90906, 33.91289], [-117.90829, 33.9129], [-117.90856, 33.9125], [-117.90874, 33.91229], [-117.90888, 33.91214], [-117.90928, 33.91179], [-117.90961, 33.91157], [-117.91226, 33.90991], [-117.9127, 33.90967], [-117.91319, 33.90946], [-117.91422, 33.90912], [-117.91452, 33.90899], [-117.91468, 33.90888], [-117.91488, 33.90872], [-117.91503, 33.90857], [-117.91521, 33.90836], [-117.91559, 33.90833], [-117.91559, 33.90881]]]]} | Restricted Access 2 | 30306 | Brea Creek Municipal Golf Course | 33097 | 1033 | Brea, City of 233 | City 2 | City Agency 2 | http://www.ci.brea.ca.us/index.aspx?NID=439 | City 2 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 26.104 | Brea Creek Municipal GC | 0 | Local Recreation Area 3 | 4 | |
15727 | 15727 | 15726 | {"type": "Polygon", "coordinates": [[[-118.17436, 34.1834], [-118.17431, 34.1834], [-118.17301, 34.18282], [-118.17291, 34.18254], [-118.17283, 34.18244], [-118.17273, 34.18235], [-118.17215, 34.18199], [-118.1718, 34.18194], [-118.17174, 34.18191], [-118.17206, 34.18149], [-118.17211, 34.18112], [-118.17243, 34.18106], [-118.1725, 34.18065], [-118.17248, 34.1804], [-118.17237, 34.18021], [-118.17204, 34.18005], [-118.17168, 34.1796], [-118.17145, 34.17966], [-118.17108, 34.17965], [-118.17031, 34.17951], [-118.17015, 34.17919], [-118.17008, 34.17898], [-118.17006, 34.17881], [-118.17008, 34.17861], [-118.17012, 34.17851], [-118.17025, 34.1783], [-118.17049, 34.17802], [-118.17066, 34.17777], [-118.17073, 34.17761], [-118.17076, 34.17745], [-118.17038, 34.17753], [-118.17042, 34.17743], [-118.17041, 34.17735], [-118.1702, 34.17699], [-118.17015, 34.17694], [-118.17006, 34.17688], [-118.16982, 34.17677], [-118.16947, 34.17648], [-118.16929, 34.17639], [-118.16911, 34.17625], [-118.16886, 34.17611], [-118.16866, 34.17587], [-118.16823, 34.17543], [-118.16806, 34.17524], [-118.16766, 34.17524], [-118.16765, 34.17511], [-118.16728, 34.17524], [-118.16725, 34.17511], [-118.16721, 34.17492], [-118.16711, 34.17363], [-118.16701, 34.17317], [-118.16699, 34.17299], [-118.16696, 34.17178], [-118.16689, 34.17152], [-118.16675, 34.17128], [-118.16668, 34.17114], [-118.16661, 34.17084], [-118.16664, 34.17019], [-118.16677, 34.16956], [-118.16679, 34.16932], [-118.16678, 34.16889], [-118.16679, 34.16843], [-118.16677, 34.1682], [-118.16642, 34.1671], [-118.16651, 34.1671], [-118.16652, 34.16709], [-118.16595, 34.16498], [-118.16523, 34.16349], [-118.16589, 34.16329], [-118.16778, 34.16277], [-118.16808, 34.16276], [-118.16841, 34.16264], [-118.16857, 34.16252], [-118.1689, 34.16241], [-118.16896, 34.16226], [-118.17005, 34.16195], [-118.16999, 34.16175], [-118.17002, 34.16173], [-118.16982, 34.16114], [-118.16974, 34.16109], [-118.16967, 34.161], [-118.16928, 34.15992], [-118.16932, 34.15971], [-118.16921, 34.15946], [-118.17032, 34.15985], [-118.171, 34.16012], [-118.17142, 34.16041], [-118.17165, 34.16111], [-118.17241, 34.16315], [-118.17217, 34.16322], [-118.17235, 34.16417], [-118.17242, 34.16439], [-118.17271, 34.16507], [-118.17318, 34.16645], [-118.17352, 34.16795], [-118.17399, 34.16795], [-118.17402, 34.16806], [-118.17425, 34.16914], [-118.17427, 34.16936], [-118.17447, 34.17027], [-118.17448, 34.17049], [-118.17468, 34.17142], [-118.17469, 34.17158], [-118.1748, 34.17226], [-118.17483, 34.17256], [-118.17478, 34.17312], [-118.17472, 34.17342], [-118.17456, 34.17402], [-118.1745, 34.17411], [-118.17437, 34.17417], [-118.17432, 34.17537], [-118.17339, 34.17649], [-118.17257, 34.17743], [-118.17253, 34.17803], [-118.17323, 34.17898], [-118.17357, 34.17931], [-118.1738, 34.17968], [-118.17394, 34.17995], [-118.17402, 34.18031], [-118.17366, 34.1808], [-118.17367, 34.18082], [-118.17359, 34.18105], [-118.17339, 34.18132], [-118.17345, 34.18137], [-118.17332, 34.18178], [-118.17344, 34.18248], [-118.17391, 34.18247], [-118.17394, 34.18268], [-118.17401, 34.18287], [-118.17436, 34.1834]]]} | Restricted Access 2 | 45949 | Brookside Golf Course | 29070 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/brookside_golf_course/ | Los Angeles 6 | 293.605 | Brookside GC | 0 | Local Recreation Area 3 | 4 |
15703 | 15703 | 15702 | {"type": "Polygon", "coordinates": [[[-121.8681, 37.62662], [-121.86809, 37.62949], [-121.86746, 37.62949], [-121.86738, 37.62958], [-121.86719, 37.62974], [-121.86701, 37.62999], [-121.86704, 37.63011], [-121.86705, 37.63038], [-121.86702, 37.63046], [-121.86704, 37.63053], [-121.86733, 37.63117], [-121.86725, 37.63132], [-121.86735, 37.63136], [-121.86744, 37.63156], [-121.86696, 37.63156], [-121.86695, 37.63157], [-121.86761, 37.63321], [-121.86754, 37.63324], [-121.86752, 37.63323], [-121.86725, 37.63257], [-121.86693, 37.63267], [-121.86653, 37.63313], [-121.86542, 37.63362], [-121.86487, 37.63389], [-121.86502, 37.63417], [-121.86474, 37.63427], [-121.86444, 37.63433], [-121.86278, 37.63494], [-121.86129, 37.63491], [-121.86113, 37.63488], [-121.86098, 37.63481], [-121.86096, 37.63476], [-121.86101, 37.63462], [-121.86103, 37.6345], [-121.86102, 37.63427], [-121.86164, 37.63401], [-121.86159, 37.63348], [-121.86117, 37.63345], [-121.86142, 37.63313], [-121.86168, 37.63309], [-121.86172, 37.6331], [-121.86217, 37.63287], [-121.86227, 37.63264], [-121.86263, 37.63207], [-121.86196, 37.63105], [-121.86149, 37.6305], [-121.86094, 37.6296], [-121.8606, 37.62883], [-121.86034, 37.62882], [-121.8604, 37.62867], [-121.86042, 37.62853], [-121.86031, 37.62774], [-121.86034, 37.62758], [-121.86041, 37.6274], [-121.86028, 37.62735], [-121.8602, 37.6275], [-121.86012, 37.62748], [-121.85898, 37.62797], [-121.8579, 37.6265], [-121.85797, 37.62603], [-121.85819, 37.62589], [-121.85848, 37.62587], [-121.85881, 37.62594], [-121.85907, 37.62586], [-121.85927, 37.62573], [-121.86018, 37.62572], [-121.86054, 37.6257], [-121.86062, 37.62557], [-121.86053, 37.62523], [-121.86079, 37.62515], [-121.86085, 37.62494], [-121.86101, 37.62492], [-121.86109, 37.62488], [-121.86128, 37.62499], [-121.8615, 37.62527], [-121.86166, 37.62542], [-121.86172, 37.62559], [-121.86173, 37.62574], [-121.86216, 37.62596], [-121.86288, 37.6265], [-121.8632, 37.6266], [-121.86336, 37.62669], [-121.86347, 37.62673], [-121.86363, 37.62674], [-121.8637, 37.62672], [-121.86374, 37.62667], [-121.8637, 37.62657], [-121.86319, 37.62626], [-121.86305, 37.626], [-121.863, 37.62595], [-121.86294, 37.62586], [-121.86297, 37.62583], [-121.86306, 37.62567], [-121.86313, 37.62561], [-121.8633, 37.62559], [-121.86351, 37.62565], [-121.86358, 37.62564], [-121.86364, 37.62561], [-121.86368, 37.62557], [-121.86369, 37.6255], [-121.86372, 37.62542], [-121.86377, 37.62535], [-121.86395, 37.62528], [-121.86401, 37.62528], [-121.86409, 37.62533], [-121.86419, 37.62535], [-121.86429, 37.62545], [-121.86443, 37.62544], [-121.86454, 37.62545], [-121.86472, 37.62555], [-121.8648, 37.62584], [-121.86506, 37.62594], [-121.86516, 37.62602], [-121.86544, 37.62616], [-121.86554, 37.62628], [-121.86574, 37.62626], [-121.86579, 37.62627], [-121.86595, 37.62662], [-121.86594, 37.62664], [-121.86606, 37.6268], [-121.86624, 37.62694], [-121.86628, 37.627], [-121.86632, 37.62717], [-121.86635, 37.62719], [-121.86642, 37.6272], [-121.86662, 37.62711], [-121.8668, 37.62705], [-121.86686, 37.62702], [-121.86685, 37.62699], [-121.86696, 37.62693], [-121.86718, 37.62701], [-121.86712, 37.62739], [-121.86706, 37.62751], [-121.86716, 37.62766], [-121.86728, 37.62769], [-121.86727, 37.62785], [-121.86722, 37.62798], [-121.867, 37.62835], [-121.86685, 37.6285], [-121.86686, 37.62852], [-121.86691, 37.62854], [-121.86719, 37.6283], [-121.86731, 37.62823], [-121.86747, 37.62785], [-121.86763, 37.62771], [-121.86774, 37.62743], [-121.86791, 37.62731], [-121.868, 37.62701], [-121.86804, 37.62665], [-121.8681, 37.62662]], [[-121.86232, 37.63345], [-121.86167, 37.63343], [-121.8617, 37.63379], [-121.86179, 37.63397], [-121.8621, 37.63405], [-121.86235, 37.63398], [-121.86249, 37.6339], [-121.86248, 37.63351], [-121.86232, 37.63345]], [[-121.86638, 37.62876], [-121.86627, 37.62874], [-121.86603, 37.62888], [-121.86602, 37.62867], [-121.86589, 37.62847], [-121.86563, 37.62841], [-121.86526, 37.62842], [-121.86519, 37.62857], [-121.86521, 37.62865], [-121.86511, 37.62889], [-121.86535, 37.62917], [-121.86549, 37.6291], [-121.86562, 37.6291], [-121.86579, 37.62903], [-121.86584, 37.62932], [-121.866, 37.62918], [-121.86652, 37.62896], [-121.86638, 37.62876]]]} | Restricted Access 2 | 23675 | Callippe Preserve Golf Course | 33079 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 130.046 | Callippe Preserve GC | 0 | Local Recreation Area 3 | 4 | |
15296 | 15296 | 15295 | {"type": "Polygon", "coordinates": [[[-118.38731, 33.92481], [-118.38575, 33.92482], [-118.38546, 33.92487], [-118.38531, 33.92493], [-118.3853, 33.92375], [-118.38721, 33.92374], [-118.38725, 33.92375], [-118.38729, 33.92381], [-118.38731, 33.92481]]]} | Restricted Access 2 | 46429 | Campus El Segundo Athletic Fields | 29699 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 5.455 | Campus El Segundo Athletic Fields | 0 | Local Recreation Area 3 | 4 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
7252 | 7252 | 7251 | {"type": "Polygon", "coordinates": [[[-118.10792, 33.88199], [-118.10716, 33.882], [-118.10715, 33.88191], [-118.10454, 33.88194], [-118.10453, 33.88189], [-118.10437, 33.88189], [-118.10433, 33.88166], [-118.10432, 33.88045], [-118.10422, 33.88025], [-118.10504, 33.88024], [-118.1051, 33.87876], [-118.10616, 33.87877], [-118.10629, 33.88012], [-118.10716, 33.88009], [-118.10714, 33.87968], [-118.10709, 33.87933], [-118.10649, 33.87707], [-118.10742, 33.87714], [-118.10767, 33.87811], [-118.10775, 33.87855], [-118.10785, 33.87922], [-118.10789, 33.87966], [-118.10791, 33.88021], [-118.10771, 33.88022], [-118.10771, 33.88026], [-118.10791, 33.88027], [-118.10792, 33.88199]]]} | Restricted Access 2 | 20050 | Cerritos Iron Wood Nine Golf Course | 33069 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.cerritos.us/RESIDENTS/recreation/facilities/iron_wood_nine_golf_course.php | Los Angeles 6 | 26.76 | Cerritos Iron Wood Nine GC | 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]);