units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,414 rows where AGNCY_LEV = 2 and DES_TP = 3 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 209
- Los Angeles, City of 115
- San Francisco, City and County of 80
- San Luis Obispo, City of 24
- Glendale, City of 24
- Davis, City of 23
- Long Beach, City of 23
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Santa Clarita, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Poway, City of 12
- San Bernardino, City of 12
- Carlsbad, City of 11
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- Open Access 1,214
- Restricted Access 135
- No Public Access 39
- Unknown Access 6
DES_TP 1
- Local Recreation Area · 1,394 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17051 | 17051 | 17050 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | 46518 | Renacimiento Community Center | 29805 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | Los Angeles 6 | 0.157 | Renacimiento Community Ctr. | 0 | Local Recreation Area 3 | 4 |
12828 | 12828 | 12827 | {"type": "Polygon", "coordinates": [[[-117.58625, 33.44551], [-117.58557, 33.44622], [-117.58549, 33.44617], [-117.58496, 33.44596], [-117.58428, 33.44582], [-117.58375, 33.44578], [-117.58067, 33.44586], [-117.58103, 33.44459], [-117.58195, 33.44112], [-117.58257, 33.44124], [-117.58285, 33.44132], [-117.5832, 33.44145], [-117.58339, 33.44165], [-117.58327, 33.44187], [-117.58437, 33.44285], [-117.58523, 33.44342], [-117.58538, 33.4436], [-117.5855, 33.44492], [-117.58594, 33.44501], [-117.58607, 33.44511], [-117.58625, 33.44551]]]} | Open Access 1 | 30277 | Richard T. Steed Memorial Park/ Sports Park | 24327 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | Orange 3 | 41.789 | Richard T. Steed Memorial Park/ Sports Park | 0 | Local Recreation Area 3 | 4 | |
13496 | 13496 | 13495 | {"type": "Polygon", "coordinates": [[[-117.61267, 33.45818], [-117.61235, 33.45862], [-117.61242, 33.45866], [-117.6122, 33.45896], [-117.61217, 33.45895], [-117.61187, 33.45933], [-117.61189, 33.45935], [-117.61164, 33.45962], [-117.61136, 33.45988], [-117.61091, 33.46023], [-117.61058, 33.46044], [-117.61005, 33.46072], [-117.6077, 33.46174], [-117.60716, 33.462], [-117.60666, 33.4623], [-117.60562, 33.46305], [-117.60511, 33.4634], [-117.60478, 33.4636], [-117.60468, 33.46358], [-117.60409, 33.46281], [-117.60379, 33.46232], [-117.60362, 33.46197], [-117.60347, 33.4616], [-117.60329, 33.46104], [-117.60325, 33.46083], [-117.6033, 33.46081], [-117.60311, 33.45993], [-117.60308, 33.45981], [-117.60303, 33.45981], [-117.60295, 33.45954], [-117.60303, 33.45951], [-117.60297, 33.45933], [-117.60275, 33.45878], [-117.60266, 33.4588], [-117.60234, 33.4582], [-117.61267, 33.45818]]]} | Open Access 1 | 48826 | Vista Hermosa Sports Park | 33545 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/61/2783 | Orange 3 | 80.721 | Vista Hermosa Sports Park | 0 | Local Recreation Area 3 | 4 |
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 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 | 98.229 | Bear Canyon | 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 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 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 | 0.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 4 | |
6606 | 6606 | 6605 | {"type": "Polygon", "coordinates": [[[-117.29626, 34.52451], [-117.29615, 34.52502], [-117.29604, 34.52542], [-117.29532, 34.52542], [-117.29531, 34.52452], [-117.29626, 34.52451]]]} | Open Access 1 | 4095 | Activities Center | 15251 | 1367 | Victorville, City of 40 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | San Bernardino 22 | 1.926 | Activities Ctr. | 0 | Local Recreation Area 3 | 4 | |
7931 | 7931 | 7930 | {"type": "Polygon", "coordinates": [[[-117.36804, 34.58213], [-117.36801, 34.58263], [-117.36795, 34.58274], [-117.36779, 34.58281], [-117.36523, 34.58282], [-117.36522, 34.58182], [-117.36538, 34.58181], [-117.36567, 34.58157], [-117.36589, 34.58174], [-117.36602, 34.58169], [-117.3665, 34.58162], [-117.36669, 34.58161], [-117.36678, 34.58162], [-117.36711, 34.58134], [-117.36803, 34.58208], [-117.36804, 34.58213]]]} | Open Access 1 | 12747 | Westwinds Sports Center | 27435 | 1367 | Victorville, City of 40 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | San Bernardino 22 | 8.066 | Westwinds Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
3776 | 3776 | 3775 | {"type": "Polygon", "coordinates": [[[-122.63891, 41.72279], [-122.63868, 41.72414], [-122.6381, 41.72593], [-122.63764, 41.72582], [-122.63728, 41.72581], [-122.6358, 41.72545], [-122.63636, 41.72418], [-122.63739, 41.72439], [-122.63746, 41.72265], [-122.63891, 41.72279]]]} | Open Access 1 | 25377 | Yreka Creek Greenway | 27796 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 12.69 | Yreka Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
12184 | 12184 | 12183 | {"type": "Polygon", "coordinates": [[[-122.6412, 41.73827], [-122.64065, 41.73942], [-122.63912, 41.73911], [-122.63935, 41.73893], [-122.63974, 41.73792], [-122.64018, 41.73801], [-122.64067, 41.73821], [-122.6407, 41.73814], [-122.6412, 41.73827]]]} | Open Access 1 | 25374 | Ringe Park and Pool | 24374 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 4.228 | Ringe Park and Pool | 0 | Local Recreation Area 3 | 4 | |
12609 | 12609 | 12608 | {"type": "Polygon", "coordinates": [[[-122.63702, 41.7377], [-122.63672, 41.73857], [-122.63616, 41.73845], [-122.63646, 41.73758], [-122.63702, 41.7377]]]} | Open Access 1 | 29648 | Newton Sports Complex | 22741 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 1.198 | Newton Sports Complex | 0 | Local Recreation Area 3 | 4 | |
10127 | 10127 | 10126 | {"type": "Polygon", "coordinates": [[[-122.25999, 38.18782], [-122.25802, 38.18781], [-122.25773, 38.18636], [-122.2597, 38.18619], [-122.25999, 38.18782]]]} | Open Access 1 | 17597 | Little League Complex | 21344 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 7.36 | Little League Complex | 0 | Local Recreation Area 3 | 4 | |
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
1670 | 1670 | 1669 | {"type": "Polygon", "coordinates": [[[-117.66405, 33.63016], [-117.66372, 33.63081], [-117.66359, 33.63122], [-117.66331, 33.63185], [-117.6632, 33.63188], [-117.66309, 33.63183], [-117.66243, 33.63166], [-117.66214, 33.63164], [-117.66159, 33.63169], [-117.66121, 33.63181], [-117.66094, 33.63193], [-117.66074, 33.63204], [-117.66067, 33.63205], [-117.66061, 33.63198], [-117.6605, 33.63171], [-117.66046, 33.63133], [-117.66077, 33.63135], [-117.66105, 33.6311], [-117.66117, 33.63109], [-117.66135, 33.63119], [-117.66156, 33.63117], [-117.66176, 33.63135], [-117.66205, 33.63132], [-117.66212, 33.6312], [-117.66224, 33.63121], [-117.66229, 33.63119], [-117.66239, 33.63104], [-117.66253, 33.63094], [-117.66276, 33.63114], [-117.66287, 33.63116], [-117.663, 33.63107], [-117.66312, 33.63078], [-117.66308, 33.63051], [-117.66285, 33.63037], [-117.66198, 33.63006], [-117.66115, 33.62995], [-117.66065, 33.62983], [-117.66049, 33.62976], [-117.66045, 33.62978], [-117.66033, 33.62972], [-117.66028, 33.62975], [-117.66014, 33.62969], [-117.66008, 33.6297], [-117.65998, 33.62963], [-117.65992, 33.62964], [-117.65982, 33.62954], [-117.65976, 33.62954], [-117.65956, 33.62936], [-117.65985, 33.62882], [-117.66022, 33.6284], [-117.66054, 33.62858], [-117.6605, 33.62871], [-117.66071, 33.62893], [-117.66117, 33.62888], [-117.6612, 33.62886], [-117.66132, 33.6289], [-117.6614, 33.6289], [-117.66151, 33.62889], [-117.66168, 33.62885], [-117.66183, 33.62913], [-117.66202, 33.62907], [-117.66208, 33.62899], [-117.66259, 33.62922], [-117.66265, 33.62919], [-117.66267, 33.62922], [-117.66274, 33.62923], [-117.66282, 33.62922], [-117.66322, 33.62939], [-117.66332, 33.62955], [-117.66356, 33.62972], [-117.66365, 33.62992], [-117.66372, 33.63], [-117.66405, 33.63016]]]} | Open Access 1 | 12606 | San Gabriel and Santa Lucia Open Space | 24893 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 16.445 | San Gabriel and Santa Lucia OS | 0 | Local Recreation Area 3 | 4 | |
3341 | 3341 | 3340 | {"type": "Polygon", "coordinates": [[[-117.65528, 33.59652], [-117.65529, 33.5968], [-117.65509, 33.59779], [-117.65469, 33.59824], [-117.65465, 33.59825], [-117.65436, 33.59858], [-117.65394, 33.59884], [-117.65373, 33.59894], [-117.65348, 33.5984], [-117.65365, 33.59687], [-117.65392, 33.59678], [-117.65478, 33.59657], [-117.65528, 33.59652]]]} | Open Access 1 | 30296 | World Cup Soccer Fields | 27756 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 7.416 | World Cup Soccer Fields | 0 | Local Recreation Area 3 | 4 | |
6819 | 6819 | 6818 | {"type": "Polygon", "coordinates": [[[-117.64307, 33.64045], [-117.64243, 33.64102], [-117.64226, 33.64124], [-117.64206, 33.64158], [-117.64201, 33.64172], [-117.64195, 33.64195], [-117.64189, 33.64205], [-117.64184, 33.64208], [-117.64174, 33.64208], [-117.64139, 33.64203], [-117.64119, 33.64206], [-117.64093, 33.64198], [-117.64074, 33.6419], [-117.64026, 33.64161], [-117.64004, 33.64155], [-117.63991, 33.64155], [-117.63965, 33.64159], [-117.63966, 33.64172], [-117.63894, 33.64171], [-117.63886, 33.64146], [-117.63879, 33.64134], [-117.63881, 33.64112], [-117.63876, 33.64094], [-117.63857, 33.64057], [-117.63846, 33.64043], [-117.63822, 33.64022], [-117.63802, 33.6401], [-117.63775, 33.63999], [-117.63771, 33.63994], [-117.63809, 33.63923], [-117.63882, 33.63791], [-117.63895, 33.63788], [-117.63921, 33.63806], [-117.63971, 33.6383], [-117.64059, 33.63864], [-117.64123, 33.63886], [-117.64185, 33.6392], [-117.64222, 33.63955], [-117.64243, 33.63982], [-117.64297, 33.64038], [-117.64307, 33.64045]]]} | Open Access 1 | 5393 | Mission Viejo Youth Athletic Park | 22318 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 33.172 | Mission Viejo Youth Athletic Park | 0 | Local Recreation Area 3 | 4 | |
8111 | 8111 | 8110 | {"type": "Polygon", "coordinates": [[[-117.66176, 33.62625], [-117.66156, 33.62635], [-117.66153, 33.62633], [-117.6609, 33.62665], [-117.66082, 33.62664], [-117.66071, 33.62666], [-117.66051, 33.62642], [-117.65988, 33.62679], [-117.65968, 33.62683], [-117.65966, 33.62661], [-117.6594, 33.62647], [-117.65942, 33.62642], [-117.65942, 33.62638], [-117.6594, 33.62634], [-117.65936, 33.6263], [-117.65937, 33.62627], [-117.65921, 33.62598], [-117.65899, 33.62603], [-117.65852, 33.62572], [-117.65857, 33.62569], [-117.65859, 33.62566], [-117.65891, 33.62563], [-117.65889, 33.62549], [-117.65881, 33.62536], [-117.65876, 33.62532], [-117.65862, 33.62525], [-117.65867, 33.62512], [-117.65854, 33.62507], [-117.65842, 33.62506], [-117.65825, 33.62508], [-117.65823, 33.62499], [-117.6582, 33.62496], [-117.65893, 33.62441], [-117.65868, 33.62415], [-117.65912, 33.62384], [-117.65974, 33.62351], [-117.65982, 33.62351], [-117.65994, 33.62372], [-117.65949, 33.6238], [-117.65936, 33.62389], [-117.65931, 33.62401], [-117.6594, 33.62456], [-117.65938, 33.62502], [-117.6594, 33.62509], [-117.65946, 33.62518], [-117.65937, 33.62528], [-117.65935, 33.62537], [-117.65939, 33.62547], [-117.65952, 33.62566], [-117.65962, 33.6258], [-117.65973, 33.62584], [-117.65982, 33.62585], [-117.65991, 33.62583], [-117.66, 33.62578], [-117.66006, 33.62566], [-117.66004, 33.62554], [-117.65984, 33.62524], [-117.65979, 33.62519], [-117.65968, 33.62514], [-117.65954, 33.62515], [-117.65947, 33.62506], [-117.65945, 33.62491], [-117.65948, 33.62452], [-117.65938, 33.62402], [-117.65941, 33.62393], [-117.65953, 33.62385], [-117.65996, 33.62377], [-117.66006, 33.62406], [-117.6601, 33.62412], [-117.66016, 33.62414], [-117.66026, 33.62416], [-117.66033, 33.62414], [-117.66066, 33.62404], [-117.66079, 33.62408], [-117.66127, 33.62542], [-117.6615, 33.62587], [-117.66176, 33.62625]]]} | Open Access 1 | 12276 | Colinas/Escorial Open Space | 17498 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 15.279 | Colinas/Escorial OS | 0 | Local Recreation Area 3 | 4 | |
8215 | 8215 | 8214 | {"type": "Polygon", "coordinates": [[[-117.66224, 33.63381], [-117.66181, 33.63461], [-117.66127, 33.63445], [-117.6612, 33.63449], [-117.66116, 33.63445], [-117.66111, 33.63444], [-117.661, 33.63444], [-117.66098, 33.6344], [-117.66071, 33.63435], [-117.66058, 33.6344], [-117.66005, 33.63433], [-117.65993, 33.63429], [-117.65982, 33.6342], [-117.65953, 33.63436], [-117.65946, 33.63418], [-117.65947, 33.63398], [-117.65952, 33.63381], [-117.66028, 33.6337], [-117.66049, 33.63371], [-117.66075, 33.63353], [-117.66085, 33.63357], [-117.66095, 33.63345], [-117.66139, 33.63361], [-117.66143, 33.63365], [-117.66147, 33.63368], [-117.66159, 33.63367], [-117.66168, 33.6336], [-117.66224, 33.63381]]]} | Open Access 1 | 12476 | Loyola Park Open Space | 21572 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.929 | Loyola Park OS | 0 | Local Recreation Area 3 | 4 | |
12990 | 12990 | 12989 | {"type": "Polygon", "coordinates": [[[-117.65374, 33.61332], [-117.65405, 33.61332], [-117.65414, 33.61333], [-117.65417, 33.61335], [-117.65417, 33.61349], [-117.65409, 33.61389], [-117.654, 33.6142], [-117.65393, 33.61438], [-117.65374, 33.61472], [-117.65358, 33.61495], [-117.65322, 33.61542], [-117.653, 33.61565], [-117.65163, 33.61684], [-117.65101, 33.61641], [-117.65208, 33.61526], [-117.65221, 33.61522], [-117.65247, 33.61505], [-117.65294, 33.61462], [-117.65294, 33.61461], [-117.65263, 33.61446], [-117.65328, 33.61357], [-117.65337, 33.61347], [-117.65347, 33.61341], [-117.65374, 33.61332]]]} | Open Access 1 | 30531 | Marguerite Recreation Center | 21808 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 9.232 | Marguerite Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16089 | 16089 | 16088 | {"type": "MultiPolygon", "coordinates": [[[[-117.65834, 33.63936], [-117.65791, 33.63985], [-117.65769, 33.64018], [-117.65763, 33.64016], [-117.65734, 33.64064], [-117.65714, 33.64104], [-117.65692, 33.64165], [-117.65676, 33.642], [-117.6563, 33.64312], [-117.65548, 33.64518], [-117.65519, 33.64594], [-117.65487, 33.64663], [-117.65474, 33.64681], [-117.65423, 33.64747], [-117.65398, 33.64772], [-117.65364, 33.64804], [-117.65261, 33.64895], [-117.6513, 33.64991], [-117.65043, 33.65057], [-117.64983, 33.65107], [-117.64916, 33.65179], [-117.64907, 33.65181], [-117.64887, 33.65169], [-117.64865, 33.65162], [-117.64662, 33.65054], [-117.64659, 33.65047], [-117.64694, 33.6504], [-117.64698, 33.65046], [-117.64707, 33.65054], [-117.6478, 33.65082], [-117.64882, 33.65129], [-117.64891, 33.65131], [-117.64905, 33.6513], [-117.6491, 33.65129], [-117.64919, 33.65122], [-117.64933, 33.65103], [-117.64961, 33.65077], [-117.6499, 33.65049], [-117.65011, 33.65033], [-117.65025, 33.65015], [-117.65043, 33.64997], [-117.65056, 33.64985], [-117.65071, 33.64975], [-117.6508, 33.64965], [-117.65093, 33.64945], [-117.651, 33.64928], [-117.65098, 33.64891], [-117.65144, 33.64875], [-117.65177, 33.64848], [-117.65192, 33.64838], [-117.65203, 33.64828], [-117.6521, 33.64817], [-117.65215, 33.64801], [-117.65216, 33.64787], [-117.65221, 33.64784], [-117.65234, 33.64779], [-117.65248, 33.6477], [-117.65258, 33.64761], [-117.65269, 33.64746], [-117.65278, 33.64729], [-117.65286, 33.6472], [-117.65293, 33.64714], [-117.65315, 33.64703], [-117.65333, 33.64698], [-117.65349, 33.6469], [-117.65363, 33.6468], [-117.65369, 33.64673], [-117.65376, 33.64661], [-117.65382, 33.64639], [-117.65384, 33.64619], [-117.65383, 33.646], [-117.65384, 33.64589], [-117.65388, 33.64577], [-117.65457, 33.64461], [-117.65471, 33.64442], [-117.65492, 33.64422], [-117.65504, 33.64403], [-117.65515, 33.6438], [-117.65545, 33.64338], [-117.65554, 33.6433], [-117.65569, 33.64311], [-117.6558, 33.64302], [-117.65597, 33.6427], [-117.65604, 33.64269], [-117.65616, 33.64251], [-117.65638, 33.64231], [-117.65635, 33.64198], [-117.65556, 33.64203], [-117.65548, 33.64202], [-117.65544, 33.642], [-117.65535, 33.64192], [-117.65534, 33.64185], [-117.65537, 33.64179], [-117.65585, 33.64126], [-117.65594, 33.64103], [-117.65597, 33.64092], [-117.65599, 33.64075], [-117.65596, 33.64059], [-117.65602, 33.64057], [-117.65607, 33.64058], [-117.6562, 33.64054], [-117.65643, 33.64039], [-117.65658, 33.64034], [-117.65664, 33.64028], [-117.65667, 33.6402], [-117.65667, 33.6401], [-117.65662, 33.63999], [-117.65652, 33.63986], [-117.65618, 33.6396], [-117.6559, 33.63962], [-117.65587, 33.63958], [-117.65587, 33.63955], [-117.65602, 33.63949], [-117.65621, 33.63944], [-117.65632, 33.63943], [-117.65641, 33.63952], [-117.65673, 33.63983], [-117.65678, 33.63977], [-117.65689, 33.63976], [-117.65696, 33.63986], [-117.65723, 33.63997], [-117.65726, 33.63996], [-117.65743, 33.63969], [-117.65759, 33.63946], [-117.65764, 33.63936], [-117.65832, 33.6393], [-117.65834, 33.63936]]], [[[-117.65579, 33.6409], [-117.65571, 33.64115], [-117.65559, 33.6413], [-117.65523, 33.64166], [-117.65511, 33.64185], [-117.65497, 33.64244], [-117.65489, 33.64258], [-117.6543, 33.64322], [-117.65407, 33.64341], [-117.65361, 33.64372], [-117.65329, 33.644], [-117.6532, 33.64411], [-117.65314, 33.64421], [-117.65297, 33.64456], [-117.65291, 33.64458], [-117.65286, 33.64457], [-117.65293, 33.64445], [-117.65296, 33.6443], [-117.65293, 33.64419], [-117.65271, 33.64365], [-117.65238, 33.64301], [-117.65199, 33.64317], [-117.65191, 33.64315], [-117.65185, 33.64317], [-117.6518, 33.6432], [-117.65178, 33.64323], [-117.65138, 33.64339], [-117.6513, 33.64328], [-117.65097, 33.64341], [-117.65095, 33.64348], [-117.65082, 33.6435], [-117.65053, 33.64364], [-117.65, 33.64382], [-117.64974, 33.64388], [-117.64952, 33.64388], [-117.64943, 33.64394], [-117.6494, 33.64399], [-117.64939, 33.64411], [-117.64893, 33.64404], [-117.64877, 33.64428], [-117.64872, 33.64433], [-117.64863, 33.6442], [-117.64857, 33.64416], [-117.64841, 33.64412], [-117.64842, 33.6438], [-117.64845, 33.64381], [-117.64848, 33.6438], [-117.64917, 33.64322], [-117.64918, 33.64318], [-117.64916, 33.64315], [-117.64899, 33.64299], [-117.64908, 33.643], [-117.64918, 33.64311], [-117.64925, 33.64315], [-117.64935, 33.64314], [-117.64951, 33.6431], [-117.64981, 33.64296], [-117.65008, 33.64286], [-117.65032, 33.64275], [-117.65089, 33.64259], [-117.65119, 33.64245], [-117.65135, 33.64218], [-117.65146, 33.64207], [-117.65165, 33.64202], [-117.65174, 33.64205], [-117.6518, 33.64204], [-117.6519, 33.64181], [-117.65195, 33.64183], [-117.65197, 33.64209], [-117.65244, 33.64223], [-117.65252, 33.64219], [-117.65256, 33.64211], [-117.65251, 33.64189], [-117.65252, 33.64181], [-117.65262, 33.64162], [-117.65272, 33.64149], [-117.65289, 33.64153], [-117.65302, 33.64149], [-117.6532, 33.64151], [-117.65342, 33.64151], [-117.65355, 33.64152], [-117.65359, 33.64151], [-117.6539, 33.64128], [-117.65435, 33.641], [-117.65435, 33.64099], [-117.65425, 33.6409], [-117.65398, 33.6407], [-117.65409, 33.64053], [-117.6542, 33.64059], [-117.65453, 33.64091], [-117.65455, 33.64096], [-117.65476, 33.64101], [-117.65494, 33.64102], [-117.65502, 33.64095], [-117.6551, 33.64094], [-117.65526, 33.64087], [-117.65534, 33.64082], [-117.65539, 33.64076], [-117.65579, 33.6409]]]]} | Open Access 1 | 12146 | Abanico Open Space | 15234 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 59.824 | Abanico OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);