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 MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
15689 | 15689 | 15688 | {"type": "Polygon", "coordinates": [[[-121.81438, 37.97557], [-121.81346, 37.97593], [-121.81013, 37.97849], [-121.80552, 37.97659], [-121.8055, 37.9766], [-121.8055, 37.97675], [-121.80486, 37.9766], [-121.80409, 37.97634], [-121.80327, 37.97567], [-121.80324, 37.9754], [-121.80326, 37.97517], [-121.80333, 37.97497], [-121.80346, 37.97479], [-121.80354, 37.9747], [-121.80373, 37.97456], [-121.80442, 37.97421], [-121.80467, 37.97405], [-121.80478, 37.97396], [-121.80496, 37.97375], [-121.80508, 37.97352], [-121.80529, 37.97278], [-121.80555, 37.97177], [-121.80558, 37.97145], [-121.80557, 37.97081], [-121.80557, 37.97013], [-121.80559, 37.96964], [-121.80559, 37.96849], [-121.81433, 37.96848], [-121.81438, 37.97557]]]} | Restricted Access 2 | 16938 | Lone Tree Golf Course | 33051 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 198.557 | Lone Tree 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 | |
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 | |
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 | |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 4 |
13775 | 13775 | 13774 | {"type": "Polygon", "coordinates": [[[-118.30569, 34.2043], [-118.30536, 34.20526], [-118.30482, 34.20631], [-118.30485, 34.20634], [-118.30447, 34.20831], [-118.3044, 34.20885], [-118.3044, 34.20905], [-118.30441, 34.20932], [-118.3045, 34.2098], [-118.30478, 34.21066], [-118.30495, 34.2113], [-118.30514, 34.21186], [-118.3048, 34.21198], [-118.30448, 34.21216], [-118.30405, 34.21258], [-118.30397, 34.21284], [-118.30396, 34.21311], [-118.30379, 34.21316], [-118.30369, 34.21305], [-118.30356, 34.21282], [-118.30369, 34.21252], [-118.30357, 34.21209], [-118.30382, 34.2116], [-118.30382, 34.21134], [-118.30349, 34.21114], [-118.30242, 34.21098], [-118.30216, 34.21137], [-118.30195, 34.21128], [-118.30288, 34.20918], [-118.30317, 34.2082], [-118.30299, 34.20777], [-118.3024, 34.2075], [-118.30183, 34.20757], [-118.30114, 34.20747], [-118.30031, 34.20799], [-118.30006, 34.20793], [-118.30033, 34.20757], [-118.30037, 34.20724], [-118.30176, 34.20593], [-118.29979, 34.20421], [-118.29844, 34.20413], [-118.29839, 34.20362], [-118.29851, 34.20278], [-118.29836, 34.20278], [-118.29863, 34.20265], [-118.29873, 34.20257], [-118.29883, 34.2025], [-118.299, 34.20235], [-118.29915, 34.20228], [-118.29922, 34.20227], [-118.29934, 34.20227], [-118.29942, 34.20229], [-118.29959, 34.20236], [-118.29994, 34.20255], [-118.30011, 34.20259], [-118.3004, 34.20259], [-118.30062, 34.20253], [-118.30087, 34.20239], [-118.30097, 34.20232], [-118.30116, 34.20207], [-118.30145, 34.20175], [-118.30165, 34.20159], [-118.30243, 34.20112], [-118.3026, 34.20114], [-118.30281, 34.20125], [-118.30292, 34.20129], [-118.30394, 34.20147], [-118.30419, 34.20148], [-118.30424, 34.20169], [-118.30453, 34.20221], [-118.30504, 34.20306], [-118.30563, 34.20399], [-118.30569, 34.20414], [-118.30569, 34.2043]]]} | Restricted Access 2 | 46258 | DeBell Golf Course | 29545 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.debellgolf.com/ | Los Angeles 6 | 95.759 | DeBell GC | 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 | |
15421 | 15421 | 15420 | {"type": "Polygon", "coordinates": [[[-117.33023, 33.15686], [-117.33022, 33.157], [-117.33015, 33.15709], [-117.33003, 33.1572], [-117.32987, 33.15728], [-117.32972, 33.1573], [-117.3295, 33.15728], [-117.3294, 33.15725], [-117.32929, 33.15717], [-117.32917, 33.15701], [-117.32785, 33.15762], [-117.32731, 33.15675], [-117.32718, 33.15651], [-117.32716, 33.15642], [-117.32727, 33.15627], [-117.3275, 33.15625], [-117.32782, 33.1562], [-117.32795, 33.15615], [-117.32929, 33.15552], [-117.33023, 33.15686]]]} | Restricted Access 2 | 46659 | Magnolia Athletic Field | 31624 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 9.19 | Magnolia Athletic Field | 0 | Local Recreation Area 3 | 4 | |
15656 | 15656 | 15655 | {"type": "MultiPolygon", "coordinates": [[[[-117.30136, 33.12431], [-117.30109, 33.12548], [-117.30099, 33.12581], [-117.3009, 33.12606], [-117.30077, 33.1263], [-117.30063, 33.12653], [-117.30041, 33.12683], [-117.30016, 33.1271], [-117.29988, 33.12736], [-117.29943, 33.12767], [-117.29912, 33.12785], [-117.29879, 33.128], [-117.29844, 33.12813], [-117.29799, 33.12825], [-117.29689, 33.12844], [-117.29653, 33.12854], [-117.29611, 33.12871], [-117.29546, 33.12906], [-117.29516, 33.12919], [-117.29485, 33.1293], [-117.29455, 33.12937], [-117.29393, 33.12948], [-117.29388, 33.12931], [-117.29366, 33.12931], [-117.29348, 33.12914], [-117.2928, 33.12894], [-117.29075, 33.12924], [-117.29021, 33.12955], [-117.29004, 33.12945], [-117.28923, 33.12912], [-117.28822, 33.12843], [-117.2879, 33.12839], [-117.29047, 33.12797], [-117.29037, 33.12753], [-117.29114, 33.12727], [-117.29117, 33.12721], [-117.29105, 33.12678], [-117.29103, 33.12657], [-117.29388, 33.12611], [-117.29434, 33.12505], [-117.29475, 33.12451], [-117.29521, 33.12385], [-117.29436, 33.1232], [-117.29415, 33.12299], [-117.29467, 33.12313], [-117.29552, 33.12331], [-117.29988, 33.12403], [-117.30074, 33.12415], [-117.30085, 33.1242], [-117.30129, 33.12426], [-117.30134, 33.12428], [-117.30136, 33.12431]]], [[[-117.30821, 33.12981], [-117.30818, 33.12985], [-117.30818, 33.12992], [-117.30821, 33.13008], [-117.30827, 33.13574], [-117.30791, 33.13835], [-117.30763, 33.13858], [-117.30741, 33.13879], [-117.30725, 33.13898], [-117.3072, 33.139], [-117.30688, 33.13882], [-117.30658, 33.13862], [-117.30647, 33.13853], [-117.30624, 33.13828], [-117.30605, 33.13801], [-117.30591, 33.13774], [-117.30568, 33.13712], [-117.30553, 33.13682], [-117.30542, 33.13664], [-117.30519, 33.13635], [-117.30492, 33.1361], [-117.30461, 33.13589], [-117.30357, 33.13528], [-117.30323, 33.13506], [-117.30163, 33.13361], [-117.30136, 33.1334], [-117.30105, 33.13321], [-117.30081, 33.13309], [-117.30039, 33.13293], [-117.30012, 33.13286], [-117.29975, 33.13279], [-117.29928, 33.13275], [-117.29891, 33.13276], [-117.29836, 33.13285], [-117.29809, 33.13292], [-117.29774, 33.13304], [-117.29674, 33.13352], [-117.29634, 33.13378], [-117.29605, 33.13401], [-117.29585, 33.1342], [-117.29567, 33.1344], [-117.2954, 33.13476], [-117.29519, 33.13514], [-117.29465, 33.13281], [-117.29201, 33.13101], [-117.29222, 33.13079], [-117.29302, 33.13088], [-117.29334, 33.13079], [-117.29375, 33.13063], [-117.29486, 33.13138], [-117.29564, 33.13095], [-117.29622, 33.13071], [-117.29622, 33.13069], [-117.29569, 33.13037], [-117.29544, 33.13028], [-117.29554, 33.12974], [-117.29521, 33.12948], [-117.29563, 33.1293], [-117.29635, 33.12892], [-117.29665, 33.1288], [-117.29689, 33.12873], [-117.29722, 33.12866], [-117.2982, 33.12849], [-117.29851, 33.12841], [-117.29881, 33.1283], [-117.2992, 33.12813], [-117.29957, 33.12794], [-117.29983, 33.12777], [-117.30012, 33.12755], [-117.30045, 33.12725], [-117.30078, 33.12687], [-117.30079, 33.12685], [-117.30095, 33.12665], [-117.30115, 33.12628], [-117.30133, 33.12584], [-117.30159, 33.1248], [-117.30164, 33.12472], [-117.30169, 33.12449], [-117.30173, 33.12437], [-117.3018, 33.12434], [-117.30193, 33.12432], [-117.30244, 33.12435], [-117.30277, 33.12434], [-117.30376, 33.12426], [-117.30415, 33.12421], [-117.30475, 33.12408], [-117.30523, 33.12395], [-117.30593, 33.12373], [-117.306, 33.12376], [-117.30601, 33.12378], [-117.30639, 33.12491], [-117.30643, 33.12505], [-117.30675, 33.12506], [-117.30722, 33.12647], [-117.30727, 33.12686], [-117.30726, 33.12705], [-117.30712, 33.12705], [-117.30698, 33.12724], [-117.30691, 33.12971], [-117.30713, 33.12967], [-117.3082, 33.12935], [-117.30821, 33.12981]]]]} | Restricted Access 2 | 804 | The Crossings Golf Course | 30002 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 391.552 | The Crossings GC | 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 |
7408 | 7408 | 7407 | {"type": "Polygon", "coordinates": [[[-117.04334, 32.65988], [-117.04285, 32.66126], [-117.0421, 32.66117], [-117.0413, 32.66018], [-117.0412, 32.66015], [-117.04094, 32.66055], [-117.04015, 32.66116], [-117.03857, 32.66186], [-117.03858, 32.66188], [-117.04059, 32.66212], [-117.0408, 32.66229], [-117.04084, 32.66253], [-117.04076, 32.6627], [-117.04062, 32.66285], [-117.04042, 32.66298], [-117.0394, 32.6633], [-117.03913, 32.66334], [-117.03859, 32.66336], [-117.03512, 32.66317], [-117.03443, 32.66331], [-117.03443, 32.66338], [-117.03373, 32.66363], [-117.03301, 32.66462], [-117.03291, 32.6647], [-117.03277, 32.66475], [-117.03263, 32.66475], [-117.0325, 32.66471], [-117.03167, 32.6642], [-117.03148, 32.66413], [-117.03126, 32.66409], [-117.03101, 32.6641], [-117.03087, 32.66414], [-117.03072, 32.66419], [-117.02943, 32.66491], [-117.02923, 32.66453], [-117.02836, 32.66501], [-117.02643, 32.66623], [-117.02661, 32.66667], [-117.02554, 32.66792], [-117.02303, 32.66863], [-117.02316, 32.66727], [-117.02417, 32.66612], [-117.02392, 32.66566], [-117.02415, 32.66546], [-117.02459, 32.66513], [-117.02715, 32.66335], [-117.0274, 32.66315], [-117.02752, 32.66308], [-117.02757, 32.66312], [-117.02804, 32.66286], [-117.0291, 32.66239], [-117.03265, 32.66094], [-117.03297, 32.66083], [-117.0334, 32.66074], [-117.03377, 32.66071], [-117.03417, 32.66071], [-117.03416, 32.66077], [-117.03466, 32.66116], [-117.03456, 32.6616], [-117.03457, 32.66161], [-117.03539, 32.66154], [-117.03567, 32.66154], [-117.03594, 32.66152], [-117.03618, 32.66147], [-117.03638, 32.66141], [-117.03682, 32.66123], [-117.03705, 32.66111], [-117.03713, 32.66119], [-117.04058, 32.65915], [-117.04032, 32.65881], [-117.04048, 32.65871], [-117.04051, 32.65874], [-117.0416, 32.65884], [-117.04165, 32.65879], [-117.04334, 32.65988]]]} | Restricted Access 2 | 7602 | Chula Vista Municipal Golf Course | 33025 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistagc.com/ | San Diego 4 | 128.631 | Chula Vista Municipal GC | 0 | Local Recreation Area 3 | 4 |
4887 | 4887 | 4886 | {"type": "Polygon", "coordinates": [[[-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.02371, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.02429, 38.01472], [-122.02586, 38.01793], [-122.02616, 38.01785], [-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685]]]} | Restricted Access 2 | 13617 | Diablo Creek Golf Course | 33034 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 150.576 | Diablo Creek GC | 0 | Local Recreation Area 3 | 4 | |
3419 | 3419 | 3418 | {"type": "Polygon", "coordinates": [[[-117.18086, 32.69355], [-117.18013, 32.69481], [-117.17921, 32.69442], [-117.17996, 32.69317], [-117.18086, 32.69355]], [[-117.18043, 32.6934], [-117.18043, 32.69338], [-117.18037, 32.69337], [-117.17965, 32.69459], [-117.17972, 32.69461], [-117.18043, 32.6934]]]} | Restricted Access 2 | 25118 | Cutler Field | 31610 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | San Diego 4 | 3.436 | Cutler Field | 0 | Local Recreation Area 3 | 4 | |
15675 | 15675 | 15674 | {"type": "Polygon", "coordinates": [[[-117.17324, 32.68306], [-117.17312, 32.6832], [-117.17308, 32.6833], [-117.17296, 32.68347], [-117.17281, 32.68359], [-117.17262, 32.68371], [-117.17251, 32.68387], [-117.17263, 32.68421], [-117.17237, 32.68428], [-117.1722, 32.68427], [-117.17191, 32.6842], [-117.17173, 32.68409], [-117.17158, 32.68394], [-117.1714, 32.68369], [-117.17111, 32.68314], [-117.17032, 32.68188], [-117.16997, 32.68153], [-117.16967, 32.68141], [-117.1694, 32.68136], [-117.16905, 32.68137], [-117.16876, 32.68144], [-117.16857, 32.68156], [-117.16831, 32.68174], [-117.16815, 32.68194], [-117.16809, 32.68217], [-117.16806, 32.6824], [-117.16807, 32.68265], [-117.16806, 32.68299], [-117.16799, 32.68333], [-117.16781, 32.68386], [-117.16782, 32.68414], [-117.16818, 32.68551], [-117.16848, 32.68627], [-117.16921, 32.68776], [-117.1693, 32.68813], [-117.16936, 32.68869], [-117.16947, 32.69001], [-117.16944, 32.69032], [-117.16939, 32.69055], [-117.16924, 32.69095], [-117.16902, 32.69135], [-117.16873, 32.69133], [-117.16859, 32.69128], [-117.1684, 32.69116], [-117.16821, 32.691], [-117.16791, 32.6907], [-117.16765, 32.69047], [-117.167, 32.69001], [-117.16625, 32.68951], [-117.1654, 32.68896], [-117.16433, 32.68832], [-117.16413, 32.6882], [-117.16395, 32.68818], [-117.16375, 32.68809], [-117.16367, 32.68794], [-117.16367, 32.6876], [-117.16362, 32.68675], [-117.16365, 32.68636], [-117.1637, 32.68595], [-117.1638, 32.6856], [-117.16383, 32.68543], [-117.16376, 32.68536], [-117.16377, 32.68528], [-117.16404, 32.68465], [-117.16416, 32.68445], [-117.16432, 32.68424], [-117.16452, 32.68409], [-117.165, 32.68395], [-117.16516, 32.68388], [-117.16524, 32.68378], [-117.16527, 32.68364], [-117.16527, 32.68334], [-117.16531, 32.68286], [-117.16541, 32.68243], [-117.16567, 32.68145], [-117.16584, 32.68066], [-117.1659, 32.68018], [-117.16628, 32.67969], [-117.16647, 32.67956], [-117.16716, 32.67928], [-117.16734, 32.67918], [-117.16765, 32.67893], [-117.16783, 32.67893], [-117.16818, 32.67905], [-117.16837, 32.67918], [-117.16868, 32.67933], [-117.169, 32.67943], [-117.16948, 32.67961], [-117.16996, 32.67982], [-117.17018, 32.67994], [-117.17036, 32.6801], [-117.17057, 32.68033], [-117.17074, 32.6806], [-117.17086, 32.68087], [-117.1709, 32.68106], [-117.17098, 32.68124], [-117.17131, 32.68156], [-117.17157, 32.68191], [-117.17185, 32.68218], [-117.17212, 32.68235], [-117.17244, 32.68242], [-117.17277, 32.68264], [-117.17314, 32.68283], [-117.17323, 32.68294], [-117.17324, 32.68306]]]} | Restricted Access 2 | 12284 | Coronado Golf Course | 33031 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.golfcoronado.com/ | San Diego 4 | 126.258 | Coronado GC | 0 | Local Recreation Area 3 | 4 |
12783 | 12783 | 12782 | {"type": "Polygon", "coordinates": [[[-117.93489, 33.66312], [-117.93485, 33.66379], [-117.93477, 33.66411], [-117.9345, 33.66461], [-117.93433, 33.66497], [-117.93425, 33.66529], [-117.93426, 33.66553], [-117.93434, 33.66577], [-117.93453, 33.666], [-117.93474, 33.66616], [-117.93478, 33.66862], [-117.92476, 33.6687], [-117.92473, 33.66822], [-117.92475, 33.66793], [-117.92484, 33.66736], [-117.92489, 33.6672], [-117.92497, 33.66701], [-117.92513, 33.66676], [-117.92522, 33.66666], [-117.92542, 33.66648], [-117.92548, 33.66643], [-117.92616, 33.66626], [-117.92641, 33.66623], [-117.92763, 33.666], [-117.92836, 33.66592], [-117.92909, 33.66525], [-117.92957, 33.66396], [-117.92835, 33.66366], [-117.92837, 33.66356], [-117.92773, 33.66339], [-117.92855, 33.66129], [-117.92855, 33.66091], [-117.92852, 33.66079], [-117.92846, 33.66068], [-117.92838, 33.66059], [-117.92826, 33.66047], [-117.92805, 33.66034], [-117.92801, 33.66028], [-117.92781, 33.66029], [-117.92391, 33.65934], [-117.92331, 33.65933], [-117.92288, 33.6595], [-117.9227, 33.65963], [-117.92122, 33.66345], [-117.92117, 33.66352], [-117.92111, 33.6636], [-117.92105, 33.66365], [-117.92095, 33.66369], [-117.92085, 33.6637], [-117.92035, 33.66362], [-117.91985, 33.66334], [-117.91972, 33.66324], [-117.91959, 33.66319], [-117.91947, 33.66318], [-117.91935, 33.6632], [-117.9193, 33.658], [-117.93043, 33.65793], [-117.93046, 33.6587], [-117.9315, 33.65867], [-117.93263, 33.66], [-117.9333, 33.65962], [-117.93389, 33.66032], [-117.93417, 33.66057], [-117.93451, 33.66076], [-117.93473, 33.66086], [-117.93476, 33.66311], [-117.93489, 33.66312]]]} | Restricted Access 2 | 30213 | Golf and Country Club | 33096 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 239.277 | Golf and Country Club | 0 | 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 | |
15720 | 15720 | 15719 | {"type": "Polygon", "coordinates": [[[-121.78192, 38.58316], [-121.7819, 38.58498], [-121.77782, 38.58494], [-121.77757, 38.58543], [-121.77653, 38.58543], [-121.77641, 38.59019], [-121.77351, 38.59018], [-121.77377, 38.58982], [-121.77414, 38.58934], [-121.77443, 38.58886], [-121.77478, 38.58821], [-121.77493, 38.58764], [-121.77499, 38.58733], [-121.77501, 38.58716], [-121.77501, 38.58649], [-121.77494, 38.5859], [-121.77483, 38.58458], [-121.77476, 38.58417], [-121.7724, 38.58485], [-121.77241, 38.58459], [-121.77222, 38.58458], [-121.77139, 38.58485], [-121.77148, 38.58517], [-121.7713, 38.5857], [-121.77016, 38.58608], [-121.7696, 38.58629], [-121.76877, 38.58668], [-121.769, 38.58699], [-121.76926, 38.58707], [-121.77016, 38.58729], [-121.77066, 38.58738], [-121.77094, 38.58749], [-121.77105, 38.58755], [-121.77148, 38.58782], [-121.77204, 38.58828], [-121.77228, 38.58854], [-121.77233, 38.5887], [-121.77233, 38.58884], [-121.77192, 38.58894], [-121.77101, 38.58876], [-121.76934, 38.58902], [-121.76875, 38.58875], [-121.76853, 38.58862], [-121.76833, 38.58848], [-121.76824, 38.5884], [-121.76808, 38.58823], [-121.76794, 38.58804], [-121.76783, 38.58785], [-121.76772, 38.5876], [-121.7677, 38.58744], [-121.76761, 38.58499], [-121.76762, 38.58292], [-121.76904, 38.58293], [-121.76904, 38.58251], [-121.76765, 38.5825], [-121.76803, 38.57833], [-121.76812, 38.57619], [-121.76813, 38.57567], [-121.77666, 38.57575], [-121.7766, 38.5831], [-121.78192, 38.58316]]]} | Restricted Access 2 | 47226 | Davis Municipal Golf Course | 33121 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 264.528 | Davis Municipal GC | 0 | Local Recreation Area 3 | 4 | |
8618 | 8618 | 8617 | {"type": "Polygon", "coordinates": [[[-119.24058, 35.75778], [-119.23631, 35.75777], [-119.23631, 35.75416], [-119.24056, 35.75415], [-119.24058, 35.75531], [-119.24055, 35.75571], [-119.24058, 35.75778]]]} | Restricted Access 2 | 13745 | Delano Golf Course | 33036 | 1084 | Delano, City of 442 | City 2 | City Agency 2 | http://www.cityofdelano.org/index.aspx?NID=90 | City 2 | 1084 | Delano, City of 436 | City 2 | City Agency 2 | Kern 36 | 38.194 | Delano GC | 0 | Local Recreation Area 3 | 4 | |
1140 | 1140 | 1139 | {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} | Restricted Access 2 | 6710 | Rio Hondo Golf Club | 33020 | 1088 | Downey, City of 82 | City 2 | City Agency 2 | http://www.downeyca.org/services/cs/default.asp | City 2 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 101.146 | Rio Hondo Golf Club | 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]);