units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,229 rows where ACCESS_TYP = 1, AGNCY_LEV = 2 and DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 194
- Los Angeles, City of 104
- San Francisco, City and County of 77
- Glendale, City of 22
- Davis, City of 22
- San Luis Obispo, City of 21
- Santa Clarita, City of 17
- Sacramento, City of 17
- Oakland, City of 16
- Long Beach, City of 15
- Thousand Oaks, City of 15
- Fullerton, City of 14
- San Marcos, City of 13
- Tiburon, Town of 13
- San Jose, City of 12
- Vacaville, City of 12
- Poway, City of 11
- Mission Viejo, City of 11
- San Bernardino, City of 10
- Carlsbad, City of 9
- Fresno, City of 8
- South San Francisco, City of 8
- Oceanside, City of 8
- Irvine, City of 8
- Santa Cruz, City of 7
- Newport Beach, City of 7
- Riverside, City of 7
- Whittier, City of 7
- Novato, City of 7
- Richmond, City of 6
- …
MNG_AG_TYP 7
DES_TP 1
- Local Recreation Area · 1,209 ✖
ACCESS_TYP 1
- Open Access · 1,209 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
313 | 313 | 312 | {"type": "Polygon", "coordinates": [[[-119.13591, 36.29543], [-119.13588, 36.29709], [-119.13271, 36.29702], [-119.1327, 36.29541], [-119.13591, 36.29543]]]} | Open Access 1 | 1084 | Exeter City Athletic Park | 18774 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 12.899 | Exeter City Athletic Park | 0 | Local Recreation Area 3 | 4 | |
354 | 354 | 353 | {"type": "Polygon", "coordinates": [[[-117.36947, 33.17694], [-117.36912, 33.17714], [-117.36883, 33.1768], [-117.3692, 33.17658], [-117.36947, 33.17694]]]} | Open Access 1 | 976 | Buccaneer Beach Access | 16467 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 0.466 | Buccaneer Beach Access | 0 | Local Recreation Area 3 | 4 | |
371 | 371 | 370 | {"type": "Polygon", "coordinates": [[[-119.131, 36.29982], [-119.13097, 36.30053], [-119.1279, 36.30049], [-119.12801, 36.2971], [-119.13018, 36.29713], [-119.13005, 36.29768], [-119.13003, 36.29832], [-119.13033, 36.29892], [-119.13082, 36.29961], [-119.131, 36.29982]]]} | Open Access 1 | 1081 | Dobson Field | 18175 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 20.718 | Dobson Field | 0 | Local Recreation Area 3 | 4 | |
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
462 | 462 | 461 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.78834], [-119.81967, 36.78838], [-119.81975, 36.78668], [-119.82184, 36.78661], [-119.82186, 36.78834]]]} | Open Access 1 | 1856 | Quigley Playground | 24064 | 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 | 8.955 | Quigley Playground | 0 | Local Recreation Area 3 | 4 | |
466 | 466 | 465 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | 922 | Holmes Playground | 20056 | 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 | 6.725 | Holmes Playground | 0 | Local Recreation Area 3 | 4 | |
508 | 508 | 507 | {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} | Open Access 1 | 2073 | Romain Playground | 24586 | 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 | 7.876 | Romain Playground | 0 | Local Recreation Area 3 | 4 | |
559 | 559 | 558 | {"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]} | Open Access 1 | 1866 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 5.376 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
568 | 568 | 567 | {"type": "Polygon", "coordinates": [[[-118.08621, 33.93879], [-118.08597, 33.93885], [-118.08499, 33.93885], [-118.08498, 33.93814], [-118.08454, 33.938], [-118.08408, 33.93774], [-118.08394, 33.93726], [-118.08284, 33.93741], [-118.08267, 33.93673], [-118.08267, 33.93658], [-118.08466, 33.93659], [-118.08465, 33.93544], [-118.08619, 33.93545], [-118.08621, 33.93879]]]} | Open Access 1 | 3354 | Lake Center Athletic Park | 20879 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 17.226 | Lake Ctr. Athletic Park | 0 | Local Recreation Area 3 | 4 | |
574 | 574 | 573 | {"type": "Polygon", "coordinates": [[[-117.03531, 32.69994], [-117.03497, 32.70006], [-117.03488, 32.70023], [-117.03519, 32.70101], [-117.03496, 32.70097], [-117.03328, 32.701], [-117.03352, 32.70069], [-117.03386, 32.70047], [-117.03445, 32.70026], [-117.03443, 32.69981], [-117.03449, 32.69954], [-117.03449, 32.69929], [-117.03457, 32.69943], [-117.03467, 32.69969], [-117.03485, 32.69976], [-117.03517, 32.69966], [-117.03531, 32.69994]]]} | Open Access 1 | 1914 | South Bay Terraces Open Space | 25638 | 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 | San Diego 4 | 3.533 | South Bay Terraces OS | 0 | Local Recreation Area 3 | 4 | |
604 | 604 | 603 | {"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]} | Open Access 1 | 2084 | Indian Head Canyon | 20201 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 55.677 | Indian Head Canyon | 0 | Local Recreation Area 3 | 4 | |
627 | 627 | 626 | {"type": "Polygon", "coordinates": [[[-118.08436, 34.05755], [-118.08246, 34.05754], [-118.08245, 34.0555], [-118.08435, 34.05549], [-118.08436, 34.05755]]]} | Open Access 1 | 2445 | Jess Gonzales Sports Park | 20403 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 9.869 | Jess Gonzales Sports Park | 0 | Local Recreation Area 3 | 4 | |
671 | 671 | 670 | {"type": "Polygon", "coordinates": [[[-117.24681, 33.89806], [-117.24567, 33.89807], [-117.24568, 33.89692], [-117.24567, 33.89565], [-117.24678, 33.89563], [-117.24681, 33.89806]]]} | Open Access 1 | 5102 | March Field Park | 21792 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 6.91 | March Field Park | 0 | Local Recreation Area 3 | 4 | |
676 | 676 | 675 | {"type": "MultiPolygon", "coordinates": [[[[-117.13268, 33.04382], [-117.13241, 33.04442], [-117.1322, 33.04434], [-117.13203, 33.04454], [-117.13199, 33.04452], [-117.13148, 33.04487], [-117.13139, 33.04475], [-117.13113, 33.04487], [-117.13102, 33.0449], [-117.13102, 33.04538], [-117.13079, 33.0455], [-117.13057, 33.04567], [-117.13041, 33.04581], [-117.13026, 33.04601], [-117.13021, 33.04599], [-117.13013, 33.04604], [-117.13005, 33.04602], [-117.1299, 33.04621], [-117.12978, 33.04623], [-117.12952, 33.04635], [-117.12936, 33.04655], [-117.12901, 33.04663], [-117.12856, 33.0467], [-117.12837, 33.04678], [-117.12828, 33.04679], [-117.12773, 33.04681], [-117.12756, 33.04683], [-117.12736, 33.0469], [-117.12718, 33.04698], [-117.12704, 33.04706], [-117.12696, 33.04713], [-117.12684, 33.04728], [-117.12645, 33.04762], [-117.12639, 33.04764], [-117.12634, 33.04764], [-117.12597, 33.04752], [-117.12568, 33.04746], [-117.12558, 33.04746], [-117.12538, 33.0475], [-117.12518, 33.04761], [-117.12485, 33.04797], [-117.12454, 33.04839], [-117.1245, 33.04849], [-117.12447, 33.04865], [-117.12443, 33.0487], [-117.12437, 33.0487], [-117.12435, 33.04868], [-117.12419, 33.0485], [-117.12408, 33.04833], [-117.12402, 33.04827], [-117.12393, 33.04823], [-117.1238, 33.04818], [-117.12366, 33.04817], [-117.12357, 33.04819], [-117.12343, 33.04826], [-117.12329, 33.04842], [-117.12326, 33.04856], [-117.12326, 33.0487], [-117.12329, 33.04886], [-117.12339, 33.04911], [-117.12337, 33.04917], [-117.12326, 33.04929], [-117.12315, 33.04935], [-117.12271, 33.04954], [-117.12235, 33.04972], [-117.12217, 33.04988], [-117.12209, 33.05002], [-117.12195, 33.0504], [-117.1219, 33.05063], [-117.12186, 33.05083], [-117.12182, 33.05126], [-117.12175, 33.05139], [-117.12153, 33.0517], [-117.12146, 33.05184], [-117.12142, 33.05215], [-117.12134, 33.0524], [-117.12125, 33.05278], [-117.12118, 33.05304], [-117.12108, 33.05326], [-117.12065, 33.05398], [-117.12053, 33.05409], [-117.1204, 33.05414], [-117.11975, 33.05407], [-117.1194, 33.05406], [-117.1184, 33.05417], [-117.11837, 33.05417], [-117.11817, 33.05423], [-117.11807, 33.05428], [-117.11799, 33.05435], [-117.11791, 33.05444], [-117.11787, 33.05462], [-117.1179, 33.05482], [-117.11827, 33.05534], [-117.11834, 33.05549], [-117.11836, 33.05561], [-117.11834, 33.05566], [-117.11826, 33.05576], [-117.11781, 33.05594], [-117.11764, 33.05604], [-117.11754, 33.05624], [-117.11756, 33.05634], [-117.11762, 33.05647], [-117.11786, 33.05667], [-117.11794, 33.05677], [-117.11807, 33.05715], [-117.11813, 33.05727], [-117.11824, 33.0574], [-117.11837, 33.05752], [-117.11881, 33.05778], [-117.11891, 33.05789], [-117.11895, 33.05796], [-117.11899, 33.05803], [-117.119, 33.05812], [-117.11898, 33.05825], [-117.1189, 33.05837], [-117.11884, 33.05843], [-117.11859, 33.05859], [-117.11853, 33.05866], [-117.11845, 33.05878], [-117.11838, 33.05898], [-117.11838, 33.05904], [-117.11832, 33.05913], [-117.118, 33.06002], [-117.11799, 33.06014], [-117.11801, 33.06028], [-117.11805, 33.06045], [-117.1182, 33.06067], [-117.11837, 33.06081], [-117.11871, 33.061], [-117.11878, 33.06108], [-117.11881, 33.06116], [-117.11883, 33.06125], [-117.11883, 33.06134], [-117.11869, 33.06167], [-117.11867, 33.06188], [-117.11871, 33.06201], [-117.11882, 33.06216], [-117.11891, 33.06223], [-117.11911, 33.06235], [-117.11935, 33.06239], [-117.1199, 33.0624], [-117.11999, 33.06244], [-117.12004, 33.06252], [-117.12004, 33.06262], [-117.11926, 33.06391], [-117.1192, 33.06407], [-117.11919, 33.06422], [-117.11924, 33.06446], [-117.1193, 33.06457], [-117.11938, 33.06468], [-117.11952, 33.06478], [-117.11995, 33.06496], [-117.12007, 33.06506], [-117.12011, 33.06514], [-117.12013, 33.06521], [-117.12014, 33.06628], [-117.12013, 33.06637], [-117.12007, 33.06651], [-117.11954, 33.06723], [-117.11943, 33.06743], [-117.11854, 33.06991], [-117.11842, 33.07012], [-117.11822, 33.07043], [-117.11814, 33.07061], [-117.11809, 33.07075], [-117.11797, 33.07224], [-117.118, 33.07242], [-117.11816, 33.07275], [-117.11819, 33.07285], [-117.11816, 33.073], [-117.11798, 33.07342], [-117.11794, 33.07365], [-117.11795, 33.07379], [-117.1182, 33.07508], [-117.11822, 33.07535], [-117.11814, 33.07659], [-117.11811, 33.07674], [-117.11807, 33.07684], [-117.11788, 33.07718], [-117.11778, 33.07729], [-117.11762, 33.07741], [-117.11748, 33.07748], [-117.11626, 33.07787], [-117.11606, 33.07798], [-117.11591, 33.0781], [-117.11581, 33.07821], [-117.11545, 33.07875], [-117.11539, 33.07886], [-117.11536, 33.07904], [-117.1153, 33.07922], [-117.11519, 33.07944], [-117.11507, 33.07961], [-117.11497, 33.07955], [-117.11471, 33.07969], [-117.11457, 33.08006], [-117.11469, 33.08017], [-117.11465, 33.0803], [-117.11464, 33.08177], [-117.11467, 33.08201], [-117.11477, 33.08224], [-117.11479, 33.08226], [-117.1148, 33.08236], [-117.11475, 33.08252], [-117.11461, 33.08275], [-117.11456, 33.08291], [-117.11455, 33.083], [-117.11457, 33.08306], [-117.11463, 33.08393], [-117.11457, 33.08393], [-117.11457, 33.08403], [-117.11451, 33.08421], [-117.11449, 33.08434], [-117.11434, 33.08484], [-117.11431, 33.08503], [-117.11429, 33.08531], [-117.11434, 33.08556], [-117.11432, 33.08564], [-117.11432, 33.08579], [-117.1143, 33.08598], [-117.11417, 33.08671], [-117.11307, 33.08687], [-117.113, 33.0875], [-117.11051, 33.08748], [-117.11048, 33.08636], [-117.11047, 33.08471], [-117.11048, 33.08458], [-117.11046, 33.08388], [-117.10658, 33.08385], [-117.10621, 33.08339], [-117.10612, 33.08331], [-117.10518, 33.08224], [-117.10512, 33.08227], [-117.10479, 33.08185], [-117.10536, 33.07954], [-117.10657, 33.07427], [-117.10663, 33.07423], [-117.10596, 33.07399], [-117.10564, 33.07142], [-117.10372, 33.07008], [-117.1036, 33.07008], [-117.10341, 33.06992], [-117.10324, 33.06971], [-117.10304, 33.06959], [-117.10271, 33.06959], [-117.10205, 33.06942], [-117.10143, 33.06894], [-117.10116, 33.06895], [-117.10126, 33.06885], [-117.1013, 33.06878], [-117.10108, 33.06857], [-117.10089, 33.06855], [-117.1008, 33.06849], [-117.10073, 33.06823], [-117.10036, 33.06808], [-117.10014, 33.06824], [-117.10006, 33.06813], [-117.10007, 33.0681], [-117.10003, 33.06789], [-117.09995, 33.06782], [-117.09978, 33.06779], [-117.0997, 33.06775], [-117.09966, 33.06771], [-117.09942, 33.06765], [-117.09911, 33.0676], [-117.09888, 33.0676], [-117.09871, 33.06763], [-117.09868, 33.06761], [-117.0987, 33.06753], [-117.09869, 33.06746], [-117.09867, 33.06742], [-117.09859, 33.06734], [-117.09863, 33.06733], [-117.09872, 33.06737], [-117.09881, 33.06738], [-117.09894, 33.06734], [-117.09902, 33.0673], [-117.09906, 33.06724], [-117.09908, 33.06717], [-117.09908, 33.06711], [-117.09881, 33.06652], [-117.0988, 33.06612], [-117.09888, 33.06592], [-117.09887, 33.06566], [-117.0988, 33.06542], [-117.09876, 33.06536], [-117.09873, 33.06524], [-117.09869, 33.0652], [-117.09863, 33.06508], [-117.09863, 33.06495], [-117.09861, 33.06482], [-117.09858, 33.06472], [-117.0985, 33.06459], [-117.09842, 33.0645], [-117.0982, 33.06433], [-117.09805, 33.06426], [-117.09787, 33.06421], [-117.09758, 33.06421], [-117.09738, 33.06428], [-117.09726, 33.06436], [-117.09721, 33.06435], [-117.09731, 33.06392], [-117.09732, 33.06385], [-117.0973, 33.06383], [-117.09731, 33.0638], [-117.0973, 33.06374], [-117.09728, 33.06367], [-117.09721, 33.06357], [-117.09697, 33.06341], [-117.09651, 33.06334], [-117.09621, 33.06337], [-117.09593, 33.06338], [-117.09559, 33.06346], [-117.09516, 33.06349], [-117.09494, 33.06356], [-117.09478, 33.06366], [-117.09474, 33.06366], [-117.09472, 33.06364], [-117.09478, 33.06355], [-117.09479, 33.0635], [-117.09476, 33.06346], [-117.09467, 33.06342], [-117.09466, 33.06339], [-117.09469, 33.06337], [-117.09488, 33.06337], [-117.09503, 33.06331], [-117.09522, 33.06312], [-117.09531, 33.06299], [-117.09535, 33.06283], [-117.09535, 33.06269], [-117.09547, 33.06251], [-117.09549, 33.06242], [-117.09548, 33.06228], [-117.09538, 33.06216], [-117.09537, 33.0621], [-117.09538, 33.06199], [-117.09542, 33.06191], [-117.09547, 33.06184], [-117.09563, 33.06174], [-117.09572, 33.06163], [-117.09574, 33.06156], [-117.09575, 33.06149], [-117.09569, 33.06139], [-117.09559, 33.06127], [-117.09544, 33.06116], [-117.09532, 33.06111], [-117.09508, 33.06103], [-117.09456, 33.06074], [-117.09428, 33.06063], [-117.09379, 33.06047], [-117.09288, 33.06008], [-117.09286, 33.06009], [-117.09286, 33.06032], [-117.09274, 33.06028], [-117.0926, 33.06017], [-117.09239, 33.06006], [-117.09228, 33.05987], [-117.09213, 33.05976], [-117.09201, 33.05974], [-117.09184, 33.05974], [-117.09164, 33.05978], [-117.09168, 33.05958], [-117.09174, 33.05947], [-117.09172, 33.05933], [-117.09166, 33.0592], [-117.09135, 33.05904], [-117.09121, 33.05888], [-117.09103, 33.05874], [-117.09084, 33.05853], [-117.09061, 33.05832], [-117.09039, 33.058], [-117.09025, 33.05791], [-117.08988, 33.05787], [-117.08965, 33.0578], [-117.08852, 33.05762], [-117.0884, 33.05745], [-117.08825, 33.05736], [-117.08816, 33.05731], [-117.08804, 33.05729], [-117.08783, 33.05729], [-117.08773, 33.05731], [-117.08767, 33.05738], [-117.0876, 33.05758], [-117.08761, 33.0577], [-117.08767, 33.05785], [-117.08713, 33.058], [-117.08569, 33.05861], [-117.08499, 33.05989], [-117.08444, 33.06032], [-117.08432, 33.06043], [-117.08427, 33.06051], [-117.08387, 33.06082], [-117.08379, 33.06096], [-117.08378, 33.06105], [-117.08385, 33.06118], [-117.08376, 33.06128], [-117.08367, 33.0615], [-117.08335, 33.0619], [-117.08304, 33.06214], [-117.08256, 33.06263], [-117.08251, 33.06298], [-117.08242, 33.06312], [-117.0824, 33.06322], [-117.08246, 33.06348], [-117.08265, 33.06372], [-117.08265, 33.06402], [-117.08259, 33.06429], [-117.0825, 33.06439], [-117.08257, 33.06486], [-117.08253, 33.06494], [-117.08234, 33.0666], [-117.08234, 33.06622], [-117.08219, 33.06598], [-117.08207, 33.06589], [-117.08202, 33.06553], [-117.0816, 33.06539], [-117.08203, 33.06463], [-117.08189, 33.06454], [-117.08154, 33.06449], [-117.08149, 33.0644], [-117.08135, 33.06431], [-117.08112, 33.06425], [-117.08088, 33.06427], [-117.08064, 33.06414], [-117.08056, 33.06417], [-117.08056, 33.06409], [-117.08037, 33.06399], [-117.08016, 33.06407], [-117.07998, 33.06409], [-117.07985, 33.06416], [-117.0796, 33.06394], [-117.0795, 33.06388], [-117.07932, 33.06388], [-117.07931, 33.06362], [-117.07874, 33.06369], [-117.07909, 33.06342], [-117.07924, 33.06317], [-117.07915, 33.06298], [-117.0789, 33.06258], [-117.07886, 33.06228], [-117.07835, 33.06191], [-117.07819, 33.06184], [-117.07778, 33.06191], [-117.07804, 33.0616], [-117.07805, 33.06126], [-117.07803, 33.06081], [-117.07798, 33.06069], [-117.07766, 33.06059], [-117.0771, 33.06083], [-117.07684, 33.061], [-117.07674, 33.061], [-117.07665, 33.06106], [-117.07663, 33.06091], [-117.0765, 33.06083], [-117.07639, 33.06082], [-117.07631, 33.06075], [-117.07599, 33.06071], [-117.07576, 33.06059], [-117.07556, 33.06063], [-117.07549, 33.06056], [-117.07508, 33.06044], [-117.07485, 33.06045], [-117.07452, 33.06041], [-117.07416, 33.06044], [-117.0739, 33.06049], [-117.07371, 33.06057], [-117.07356, 33.06059], [-117.07326, 33.06068], [-117.07297, 33.06106], [-117.07294, 33.06119], [-117.07293, 33.06133], [-117.07282, 33.06136], [-117.0727, 33.06156], [-117.07276, 33.06197], [-117.07263, 33.06189], [-117.0722, 33.06186], [-117.07201, 33.0619], [-117.07145, 33.06184], [-117.07124, 33.06186], [-117.071, 33.06195], [-117.07073, 33.06224], [-117.07058, 33.06236], [-117.07053, 33.06247], [-117.07045, 33.06248], [-117.06984, 33.06278], [-117.06962, 33.06201], [-117.06976, 33.06174], [-117.07007, 33.06157], [-117.06989, 33.06123], [-117.07161, 33.05693], [-117.07174, 33.05675], [-117.07189, 33.05658], [-117.07198, 33.05651], [-117.07229, 33.05634], [-117.07244, 33.05628], [-117.07286, 33.05618], [-117.07316, 33.05609], [-117.07378, 33.05585], [-117.07431, 33.05562], [-117.07428, 33.05548], [-117.07454, 33.05531], [-117.07469, 33.05518], [-117.07497, 33.05489], [-117.0751, 33.05473], [-117.07609, 33.05336], [-117.07628, 33.05301], [-117.07637, 33.0528], [-117.07642, 33.05262], [-117.07648, 33.05227], [-117.07649, 33.05201], [-117.07644, 33.05164], [-117.07638, 33.05141], [-117.07623, 33.05103], [-117.07602, 33.05071], [-117.07575, 33.05041], [-117.07613, 33.04995], [-117.07686, 33.04884], [-117.07733, 33.04853], [-117.07744, 33.04827], [-117.0777, 33.04805], [-117.07778, 33.0469], [-117.07765, 33.04667], [-117.07681, 33.04619], [-117.07646, 33.04577], [-117.07581, 33.04506], [-117.07512, 33.04473], [-117.07454, 33.04485], [-117.07742, 33.04195], [-117.07767, 33.04165], [-117.07786, 33.04135], [-117.07859, 33.04164], [-117.07894, 33.04181], [-117.07964, 33.04197], [-117.07989, 33.04198], [-117.08023, 33.04196], [-117.08024, 33.04211], [-117.08027, 33.04224], [-117.08016, 33.04246], [-117.07979, 33.04262], [-117.07963, 33.04286], [-117.07966, 33.04329], [-117.07974, 33.04342], [-117.08846, 33.0445], [-117.09088, 33.04481], [-117.091, 33.04484], [-117.09044, 33.04709], [-117.09043, 33.04721], [-117.0904, 33.04726], [-117.08991, 33.04926], [-117.09485, 33.05503], [-117.1018, 33.05914], [-117.11033, 33.05917], [-117.11402, 33.04382], [-117.12244, 33.04384], [-117.13268, 33.04382]], [[-117.10946, 33.08122], [-117.10947, 33.08171], [-117.11043, 33.08171], [-117.11043, 33.08038], [-117.10945, 33.0804], [-117.10947, 33.08118], [-117.10946, 33.08122]]], [[[-117.12306, 33.04975], [-117.12293, 33.04986], [-117.12272, 33.05008], [-117.12257, 33.0503], [-117.12241, 33.05064], [-117.12235, 33.05083], [-117.12223, 33.05083], [-117.12208, 33.05144], [-117.122, 33.05185], [-117.12211, 33.05188], [-117.12205, 33.05215], [-117.12184, 33.05312], [-117.12173, 33.05311], [-117.12164, 33.05351], [-117.12168, 33.05352], [-117.12166, 33.05366], [-117.12166, 33.05397], [-117.12173, 33.05398], [-117.12179, 33.05436], [-117.12168, 33.05439], [-117.12175, 33.0546], [-117.12183, 33.05481], [-117.11808, 33.05481], [-117.11805, 33.05475], [-117.11804, 33.05468], [-117.11804, 33.05457], [-117.11806, 33.05452], [-117.11809, 33.05446], [-117.11815, 33.0544], [-117.11827, 33.05434], [-117.11882, 33.05425], [-117.11941, 33.05419], [-117.1197, 33.0542], [-117.12044, 33.05427], [-117.1206, 33.05422], [-117.1208, 33.05405], [-117.12124, 33.0533], [-117.12135, 33.05305], [-117.12147, 33.05256], [-117.12148, 33.05249], [-117.12157, 33.05221], [-117.12161, 33.05189], [-117.12168, 33.05175], [-117.12181, 33.0516], [-117.12187, 33.0515], [-117.12198, 33.05128], [-117.122, 33.0512], [-117.12203, 33.05083], [-117.1221, 33.05043], [-117.12225, 33.05005], [-117.12231, 33.04995], [-117.12244, 33.04984], [-117.12291, 33.04962], [-117.12306, 33.04975]]], [[[-117.12652, 33.04775], [-117.12629, 33.04798], [-117.12642, 33.04812], [-117.1259, 33.04856], [-117.12571, 33.04868], [-117.12557, 33.04854], [-117.12516, 33.04876], [-117.12468, 33.04887], [-117.12472, 33.04911], [-117.12407, 33.04926], [-117.124, 33.04904], [-117.1236, 33.04915], [-117.12352, 33.04901], [-117.12343, 33.04875], [-117.12342, 33.04859], [-117.12346, 33.04845], [-117.12352, 33.04838], [-117.12359, 33.04833], [-117.12366, 33.04832], [-117.12376, 33.04832], [-117.12388, 33.04835], [-117.12393, 33.0484], [-117.12411, 33.04863], [-117.12429, 33.04882], [-117.12435, 33.04884], [-117.12447, 33.04884], [-117.12454, 33.04879], [-117.12461, 33.04872], [-117.12464, 33.04865], [-117.12469, 33.04843], [-117.12492, 33.04813], [-117.12526, 33.04775], [-117.12538, 33.04766], [-117.12552, 33.04761], [-117.12568, 33.0476], [-117.12595, 33.04766], [-117.12631, 33.04777], [-117.12642, 33.04778], [-117.12652, 33.04775]]], [[[-117.12933, 33.04672], [-117.12906, 33.04683], [-117.1279, 33.04711], [-117.12762, 33.04723], [-117.12739, 33.04735], [-117.12721, 33.04748], [-117.12681, 33.0475], [-117.12695, 33.04739], [-117.12717, 33.04715], [-117.12727, 33.04708], [-117.12756, 33.04698], [-117.12781, 33.04693], [-117.12815, 33.04695], [-117.12826, 33.04694], [-117.12842, 33.0469], [-117.12857, 33.04684], [-117.12933, 33.04672]]], [[[-117.12985, 33.04642], [-117.12977, 33.04649], [-117.12959, 33.04659], [-117.12959, 33.04653], [-117.12967, 33.04644], [-117.12978, 33.04642], [-117.12985, 33.04642]]]]} | Open Access 1 | 3408 | Hodges Reservoir | 29224 | 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 | http://www.sandiego.gov/water/recreation/reservoirs/hodges.shtml | San Diego 4 | 2271.486 | Hodges Reservoir | 0 | Local Recreation Area 3 | 4 |
717 | 717 | 716 | {"type": "Polygon", "coordinates": [[[-117.92419, 33.88391], [-117.92408, 33.88412], [-117.92397, 33.88429], [-117.92354, 33.88397], [-117.92333, 33.88404], [-117.92297, 33.88442], [-117.92231, 33.88498], [-117.92231, 33.88499], [-117.92279, 33.88538], [-117.92229, 33.8858], [-117.92197, 33.88601], [-117.92171, 33.88614], [-117.92123, 33.88634], [-117.92078, 33.8865], [-117.92073, 33.8865], [-117.92066, 33.88644], [-117.9205, 33.88616], [-117.92054, 33.88613], [-117.92028, 33.88566], [-117.92023, 33.88566], [-117.92021, 33.88554], [-117.92022, 33.88548], [-117.92027, 33.88542], [-117.9204, 33.88533], [-117.92058, 33.88525], [-117.92067, 33.88517], [-117.92073, 33.88504], [-117.92073, 33.88495], [-117.92071, 33.88487], [-117.92063, 33.88477], [-117.91997, 33.88433], [-117.91994, 33.8843], [-117.91993, 33.88424], [-117.92209, 33.88471], [-117.92255, 33.88401], [-117.9228, 33.8839], [-117.92419, 33.88391]]]} | Open Access 1 | 4247 | Lions Field | 21314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 10.364 | Lions Field | 0 | Local Recreation Area 3 | 4 | |
747 | 747 | 746 | {"type": "MultiPolygon", "coordinates": [[[[-119.44573, 36.58961], [-119.44537, 36.58963], [-119.44447, 36.58892], [-119.4438, 36.58849], [-119.44338, 36.58829], [-119.43086, 36.58296], [-119.43083, 36.58271], [-119.44402, 36.58835], [-119.44453, 36.58867], [-119.44573, 36.58961]]], [[[-119.44987, 36.59354], [-119.44964, 36.59365], [-119.44551, 36.58977], [-119.44593, 36.58981], [-119.44987, 36.59354]]], [[[-119.45189, 36.59557], [-119.45174, 36.5957], [-119.45083, 36.59481], [-119.45091, 36.59472], [-119.45079, 36.59461], [-119.45068, 36.59466], [-119.44981, 36.59379], [-119.45002, 36.59366], [-119.45189, 36.59557]]], [[[-119.453, 36.59657], [-119.45277, 36.59669], [-119.45188, 36.59581], [-119.45205, 36.59566], [-119.453, 36.59657]]], [[[-119.45512, 36.59856], [-119.45491, 36.59872], [-119.45297, 36.59683], [-119.45318, 36.59667], [-119.45512, 36.59856]]], [[[-119.45728, 36.60049], [-119.4568, 36.6005], [-119.45508, 36.59886], [-119.45525, 36.59868], [-119.45728, 36.60049]]], [[[-119.45763, 36.60105], [-119.45763, 36.60105], [-119.45699, 36.60059], [-119.45759, 36.60064], [-119.45763, 36.60105]]], [[[-119.46088, 36.60239], [-119.46072, 36.60259], [-119.45776, 36.60116], [-119.45774, 36.60077], [-119.45891, 36.60144], [-119.46088, 36.60239]]]]} | Open Access 1 | 4869 | Reedley Community Parkway | 24261 | 1272 | Reedley, City of 250 | City 2 | City Agency 2 | http://www.reedley.com/ | City 2 | 1272 | Reedley, City of 246 | City 2 | City Agency 2 | Fresno 9 | 20.099 | Reedley Community Parkway | 0 | Local Recreation Area 3 | 4 | |
768 | 768 | 767 | {"type": "Polygon", "coordinates": [[[-122.42281, 37.75993], [-122.42246, 37.75995], [-122.42232, 37.75965], [-122.42215, 37.75966], [-122.42211, 37.75927], [-122.42205, 37.75923], [-122.42183, 37.75925], [-122.4218, 37.75887], [-122.4227, 37.75882], [-122.42281, 37.75993]]]} | Open Access 1 | 5666 | Mission Playground | 22307 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.793 | Mission Playground | 0 | Local Recreation Area 3 | 4 | |
785 | 785 | 784 | {"type": "Polygon", "coordinates": [[[-122.40049, 37.76481], [-122.39883, 37.76491], [-122.39873, 37.76382], [-122.40038, 37.76372], [-122.40049, 37.76481]]]} | Open Access 1 | 5773 | Jackson Playground | 20324 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.406 | Jackson Playground | 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]);