units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 208
- Los Angeles, City of 115
- San Francisco, City and County of 78
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- San Luis Obispo, City of 26
- Glendale, City of 24
- Davis, City of 23
- Long Beach, City of 22
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Sacramento, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 14
- San Bernardino, City of 14
- San Marcos, City of 14
- Los Angeles - Department of Parks and Recreation, County of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,423
- Recreation/Parks District 163
- County Agency 116
- Open Space District 88
- Water District 69
- County Agency - Parks 36
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,621
- Restricted Access 219
- No Public Access 113
- Unknown Access 16
DES_TP 1
- Local Recreation Area · 1,969 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
6148 | 6148 | 6147 | {"type": "Polygon", "coordinates": [[[-117.0747, 32.78221], [-117.07462, 32.78225], [-117.07456, 32.78235], [-117.07453, 32.78236], [-117.07449, 32.78207], [-117.07319, 32.78207], [-117.07249, 32.782], [-117.07221, 32.78175], [-117.07188, 32.78121], [-117.07462, 32.78164], [-117.0747, 32.78221]]]} | Open Access 1 | 18932 | Adobe Falls Open Space Park | 15271 | 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 | 4.003 | Adobe Falls OS Park | 0 | Local Recreation Area 3 | 4 | |
9653 | 9653 | 9652 | {"type": "Polygon", "coordinates": [[[-122.31492, 37.86324], [-122.31414, 37.86342], [-122.31398, 37.86302], [-122.31476, 37.86281], [-122.31492, 37.86324]]]} | Open Access 1 | 16277 | Adventure Playground | 15278 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.854 | Adventure Playground | 0 | Local Recreation Area 3 | 4 | |
2370 | 2370 | 2369 | {"type": "Polygon", "coordinates": [[[-120.83479, 37.08983], [-120.83269, 37.08984], [-120.83279, 37.08797], [-120.83477, 37.08796], [-120.83479, 37.08983]]]} | Open Access 1 | 17169 | Ag Sports Complex | 15283 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 9.306 | Ag Sports Complex | 0 | Local Recreation Area 3 | 4 | |
16095 | 16095 | 16094 | {"type": "Polygon", "coordinates": [[[-118.74322, 34.13739], [-118.74273, 34.13773], [-118.7424, 34.13775], [-118.74194, 34.1385], [-118.74154, 34.13874], [-118.74103, 34.13875], [-118.74075, 34.13873], [-118.74055, 34.13832], [-118.74076, 34.13825], [-118.741, 34.13822], [-118.74111, 34.13819], [-118.74123, 34.13814], [-118.74132, 34.13807], [-118.74156, 34.13795], [-118.74167, 34.13786], [-118.74175, 34.1379], [-118.74179, 34.13782], [-118.74184, 34.13753], [-118.74189, 34.13743], [-118.74195, 34.13733], [-118.74201, 34.13727], [-118.74209, 34.13723], [-118.74285, 34.13708], [-118.74295, 34.13708], [-118.74305, 34.13713], [-118.74322, 34.13739]]]} | Open Access 1 | 12512 | Agoura Hills Open Space | 29518 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.255 | Agoura Hills OS | 0 | Local Recreation Area 3 | 4 | |
16909 | 16909 | 16908 | {"type": "Polygon", "coordinates": [[[-118.77815, 34.14346], [-118.77784, 34.14376], [-118.77784, 34.14381], [-118.77752, 34.14415], [-118.77741, 34.14423], [-118.77726, 34.14428], [-118.77716, 34.14429], [-118.77696, 34.14427], [-118.77668, 34.14417], [-118.77653, 34.1441], [-118.7765, 34.14407], [-118.77656, 34.14399], [-118.77656, 34.14391], [-118.7765, 34.14383], [-118.7764, 34.1438], [-118.77667, 34.14384], [-118.7767, 34.14377], [-118.77664, 34.14368], [-118.77673, 34.14333], [-118.77709, 34.14327], [-118.77735, 34.14256], [-118.77759, 34.14262], [-118.77779, 34.14302], [-118.77815, 34.14346]]]} | Open Access 1 | 46240 | Agoura Hills Recreation and Event Center | 29519 | 3364 | Joni and Friends 1181 | Non Profit 6 | Non Profit - Other 22 | http://www.joniandfriends.org/ | Non Governmental Organization 10 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities/agoura-hills-recreation-center | Los Angeles 6 | 3.899 | Agoura Hills Rec. and Event Ctr. | 0 | Local Recreation Area 3 | 4 |
915 | 915 | 914 | {"type": "Polygon", "coordinates": [[[-118.40367, 33.76579], [-118.40172, 33.76579], [-118.40068, 33.76532], [-118.39944, 33.76548], [-118.39872, 33.76598], [-118.39851, 33.76599], [-118.39825, 33.76503], [-118.39697, 33.76527], [-118.39672, 33.76521], [-118.39662, 33.76442], [-118.39672, 33.7636], [-118.39634, 33.76316], [-118.39614, 33.76316], [-118.39577, 33.763], [-118.39552, 33.76295], [-118.39505, 33.76295], [-118.39475, 33.76286], [-118.39404, 33.76306], [-118.39345, 33.76309], [-118.39242, 33.76276], [-118.39324, 33.76159], [-118.39353, 33.76173], [-118.39386, 33.76157], [-118.394, 33.76132], [-118.39421, 33.76139], [-118.39443, 33.76143], [-118.39466, 33.76145], [-118.39504, 33.76145], [-118.3948, 33.76184], [-118.39634, 33.76183], [-118.3969, 33.7623], [-118.40024, 33.76452], [-118.40197, 33.76451], [-118.40218, 33.76489], [-118.40367, 33.76508], [-118.40367, 33.76579]]]} | Open Access 1 | 5862 | Agua Armaga Canyon Open Space | 29504 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.343 | Agua Armaga Canyon OS | 0 | Local Recreation Area 3 | 4 | |
13843 | 13843 | 13842 | {"type": "Polygon", "coordinates": [[[-118.40367, 33.76579], [-118.40367, 33.76744], [-118.40306, 33.76731], [-118.40216, 33.76783], [-118.40172, 33.76823], [-118.40097, 33.76815], [-118.40019, 33.76838], [-118.39966, 33.7686], [-118.39857, 33.76917], [-118.39808, 33.7696], [-118.39719, 33.77018], [-118.39663, 33.77052], [-118.3966, 33.77], [-118.39693, 33.76968], [-118.39706, 33.76933], [-118.39739, 33.76909], [-118.39756, 33.76889], [-118.39794, 33.76884], [-118.39804, 33.76873], [-118.39799, 33.76839], [-118.39848, 33.76821], [-118.39895, 33.7679], [-118.40049, 33.76721], [-118.40114, 33.767], [-118.40186, 33.7669], [-118.40209, 33.76681], [-118.40236, 33.76661], [-118.40236, 33.76579], [-118.40367, 33.76579]]]} | Open Access 1 | 46339 | Agua Armaga Canyon Open Space | 29504 | 3052 | Palos Verdes Peninsula Land Conservancy 846 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.pvplc.org/preserves.shtml | Non Governmental Organization 10 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.73 | Agua Armaga Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16835 | 16835 | 16834 | {"type": "Polygon", "coordinates": [[[-122.13351, 37.56302], [-122.13306, 37.56334], [-122.1327, 37.56375], [-122.13236, 37.56416], [-122.132, 37.56456], [-122.13157, 37.56495], [-122.13129, 37.56517], [-122.13101, 37.56552], [-122.13072, 37.56578], [-122.13038, 37.56613], [-122.13007, 37.56649], [-122.12981, 37.56695], [-122.12955, 37.56725], [-122.1289, 37.56823], [-122.12817, 37.56919], [-122.12787, 37.56949], [-122.12739, 37.56984], [-122.12708, 37.57017], [-122.12643, 37.57065], [-122.12634, 37.57073], [-122.12608, 37.57079], [-122.12576, 37.57103], [-122.12531, 37.57134], [-122.12415, 37.57182], [-122.12302, 37.57223], [-122.12227, 37.57238], [-122.1208, 37.57251], [-122.12026, 37.57254], [-122.11951, 37.57253], [-122.1188, 37.57236], [-122.11797, 37.57231], [-122.11684, 37.57204], [-122.1158, 37.57174], [-122.11464, 37.57126], [-122.11255, 37.57048], [-122.11149, 37.57014], [-122.1104, 37.56968], [-122.10985, 37.5695], [-122.10908, 37.56933], [-122.10854, 37.5691], [-122.10833, 37.56859], [-122.10777, 37.56845], [-122.107, 37.56819], [-122.10605, 37.56797], [-122.10518, 37.56774], [-122.10407, 37.56733], [-122.103, 37.56699], [-122.10204, 37.56671], [-122.1011, 37.5664], [-122.1003, 37.56618], [-122.09933, 37.56581], [-122.09831, 37.56551], [-122.09763, 37.56548], [-122.09696, 37.56536], [-122.09637, 37.56506], [-122.09549, 37.56475], [-122.09399, 37.56432], [-122.09177, 37.56363], [-122.0908, 37.56343], [-122.08964, 37.56329], [-122.0887, 37.56308], [-122.08761, 37.56294], [-122.08656, 37.5629], [-122.08475, 37.56261], [-122.08346, 37.56255], [-122.08236, 37.56253], [-122.08137, 37.56237], [-122.08031, 37.5623], [-122.07911, 37.56244], [-122.07799, 37.56254], [-122.07626, 37.56298], [-122.07491, 37.5632], [-122.07417, 37.56324], [-122.07248, 37.56353], [-122.07171, 37.56357], [-122.07097, 37.56376], [-122.06956, 37.5644], [-122.06886, 37.56487], [-122.06814, 37.56559], [-122.06727, 37.56654], [-122.06637, 37.56762], [-122.06566, 37.56848], [-122.06466, 37.56983], [-122.06363, 37.57109], [-122.06254, 37.57226], [-122.06099, 37.57414], [-122.05924, 37.57613], [-122.05817, 37.57731], [-122.05772, 37.57777], [-122.05702, 37.57824], [-122.05597, 37.57882], [-122.05507, 37.57925], [-122.05411, 37.5798], [-122.0533, 37.58059], [-122.05273, 37.58121], [-122.05214, 37.58196], [-122.05161, 37.58256], [-122.05102, 37.58337], [-122.05055, 37.58393], [-122.05003, 37.58472], [-122.04928, 37.5856], [-122.04764, 37.58677], [-122.04704, 37.58703], [-122.04591, 37.58745], [-122.04543, 37.58751], [-122.04491, 37.58765], [-122.04414, 37.5879], [-122.04287, 37.58816], [-122.04178, 37.58825], [-122.04036, 37.58831], [-122.03914, 37.58827], [-122.03812, 37.58815], [-122.03695, 37.58771], [-122.03536, 37.58719], [-122.0337, 37.58661], [-122.03272, 37.58618], [-122.03166, 37.58531], [-122.02989, 37.58361], [-122.02924, 37.58286], [-122.02849, 37.58207], [-122.02727, 37.58085], [-122.02625, 37.57991], [-122.02543, 37.57901], [-122.02443, 37.57806], [-122.02334, 37.57724], [-122.0217, 37.57653], [-122.02073, 37.57608], [-122.02011, 37.57567], [-122.01936, 37.57544], [-122.01811, 37.57498], [-122.01706, 37.57434], [-122.01543, 37.57351], [-122.01497, 37.57323], [-122.0139, 37.57271], [-122.01307, 37.57324], [-122.0138, 37.57248], [-122.01216, 37.57164], [-122.00991, 37.57036], [-122.00094, 37.56685], [-121.9997, 37.56635], [-121.9987, 37.56616], [-121.99784, 37.56612], [-121.99401, 37.56636], [-121.99349, 37.56643], [-121.99308, 37.56651], [-121.99246, 37.56667], [-121.99189, 37.56688], [-121.99133, 37.56712], [-121.99042, 37.5677], [-121.98945, 37.56849], [-121.98921, 37.56879], [-121.98879, 37.56914], [-121.9874, 37.57027], [-121.98649, 37.57103], [-121.98602, 37.57136], [-121.98573, 37.57156], [-121.98545, 37.57169], [-121.98453, 37.57221], [-121.98396, 37.5724], [-121.98328, 37.57253], [-121.9817, 37.57251], [-121.98058, 37.57241], [-121.98039, 37.57296], [-121.9796, 37.5728], [-121.97854, 37.57255], [-121.97635, 37.57235], [-121.97522, 37.57246], [-121.97432, 37.57253], [-121.9736, 37.57271], [-121.97292, 37.57303], [-121.97233, 37.57337], [-121.97199, 37.5737], [-121.9712, 37.57413], [-121.97072, 37.57455], [-121.97053, 37.57496], [-121.97, 37.57556], [-121.96943, 37.57627], [-121.96913, 37.57698], [-121.96901, 37.57734], [-121.96889, 37.57793], [-121.96877, 37.57841], [-121.96762, 37.57849], [-121.96761, 37.57819], [-121.96768, 37.57766], [-121.96779, 37.57725], [-121.96808, 37.5767], [-121.96837, 37.57604], [-121.96872, 37.57535], [-121.96893, 37.57479], [-121.96955, 37.57372], [-121.97004, 37.57332], [-121.97061, 37.57291], [-121.97116, 37.57248], [-121.97206, 37.57213], [-121.97278, 37.57192], [-121.97339, 37.57172], [-121.97436, 37.57146], [-121.97478, 37.57123], [-121.97547, 37.5709], [-121.97647, 37.5707], [-121.97659, 37.57096], [-121.97732, 37.57085], [-121.97776, 37.57088], [-121.97814, 37.57093], [-121.97925, 37.57118], [-121.98007, 37.57142], [-121.98053, 37.57158], [-121.9817, 37.57173], [-121.98211, 37.57174], [-121.98265, 37.57167], [-121.98356, 37.57147], [-121.98429, 37.5712], [-121.98503, 37.57079], [-121.98549, 37.57027], [-121.98586, 37.56994], [-121.98671, 37.56924], [-121.98813, 37.56831], [-121.98897, 37.56765], [-121.9895, 37.56715], [-121.99088, 37.56624], [-121.99193, 37.56588], [-121.99405, 37.56548], [-121.99645, 37.56532], [-121.9975, 37.56538], [-121.99888, 37.56535], [-121.99985, 37.56555], [-122.00039, 37.56569], [-122.00107, 37.56596], [-122.00195, 37.56616], [-122.00267, 37.56649], [-122.00373, 37.5669], [-122.00493, 37.56731], [-122.00632, 37.56793], [-122.00696, 37.56817], [-122.00788, 37.56842], [-122.0085, 37.56874], [-122.00934, 37.56906], [-122.01024, 37.56942], [-122.01111, 37.56973], [-122.01217, 37.57028], [-122.01281, 37.5707], [-122.01314, 37.57098], [-122.01368, 37.57129], [-122.0142, 37.57153], [-122.01457, 37.57177], [-122.01561, 37.57239], [-122.01618, 37.57267], [-122.0168, 37.57304], [-122.01745, 37.57339], [-122.01857, 37.57404], [-122.01909, 37.57424], [-122.01983, 37.57447], [-122.02047, 37.57471], [-122.02095, 37.57498], [-122.02131, 37.57514], [-122.02186, 37.57533], [-122.02313, 37.57586], [-122.02363, 37.57619], [-122.02428, 37.57658], [-122.02474, 37.57697], [-122.02517, 37.5773], [-122.02559, 37.57768], [-122.02708, 37.57916], [-122.02752, 37.57961], [-122.02788, 37.58004], [-122.02878, 37.58097], [-122.02913, 37.58126], [-122.02953, 37.58167], [-122.03019, 37.5824], [-122.03113, 37.58319], [-122.03174, 37.58377], [-122.03209, 37.5843], [-122.03373, 37.58525], [-122.0341, 37.58561], [-122.03538, 37.58605], [-122.03584, 37.58623], [-122.03615, 37.58636], [-122.03742, 37.58668], [-122.03792, 37.58683], [-122.03851, 37.58698], [-122.0393, 37.58715], [-122.03986, 37.58724], [-122.04072, 37.58726], [-122.04129, 37.58721], [-122.04289, 37.58699], [-122.04362, 37.58687], [-122.04416, 37.58674], [-122.04577, 37.58627], [-122.04646, 37.58601], [-122.047, 37.58577], [-122.04728, 37.58549], [-122.04792, 37.58498], [-122.04847, 37.58447], [-122.04947, 37.58344], [-122.05005, 37.58264], [-122.05054, 37.58214], [-122.05063, 37.58183], [-122.05109, 37.58132], [-122.05169, 37.58073], [-122.05227, 37.58018], [-122.05264, 37.57971], [-122.05308, 37.57899], [-122.0538, 37.57868], [-122.05443, 37.5783], [-122.05536, 37.57789], [-122.05631, 37.57721], [-122.057, 37.5766], [-122.05762, 37.57577], [-122.05858, 37.57489], [-122.05969, 37.57334], [-122.06029, 37.57263], [-122.06199, 37.57081], [-122.063, 37.56961], [-122.06438, 37.56762], [-122.06513, 37.56666], [-122.06551, 37.56636], [-122.06608, 37.56568], [-122.06653, 37.56529], [-122.06695, 37.56487], [-122.06717, 37.56456], [-122.06769, 37.56403], [-122.06849, 37.56357], [-122.06898, 37.56325], [-122.06957, 37.56293], [-122.0701, 37.56273], [-122.07155, 37.56229], [-122.07239, 37.56214], [-122.07304, 37.56205], [-122.07525, 37.56163], [-122.07645, 37.56128], [-122.07831, 37.56104], [-122.08075, 37.56064], [-122.08198, 37.5606], [-122.08349, 37.56074], [-122.08572, 37.56107], [-122.08832, 37.56133], [-122.09086, 37.56162], [-122.09238, 37.56198], [-122.09393, 37.56229], [-122.09533, 37.56276], [-122.09669, 37.56304], [-122.09686, 37.5631], [-122.09795, 37.56382], [-122.09927, 37.56422], [-122.10024, 37.56447], [-122.10169, 37.56449], [-122.10339, 37.56498], [-122.10574, 37.5658], [-122.10856, 37.56651], [-122.11091, 37.5675], [-122.11363, 37.56862], [-122.11552, 37.56899], [-122.11774, 37.56978], [-122.11877, 37.57016], [-122.11981, 37.57033], [-122.1216, 37.57], [-122.12346, 37.56932], [-122.12472, 37.56819], [-122.12658, 37.56692], [-122.12784, 37.56588], [-122.12901, 37.56474], [-122.13006, 37.56358], [-122.13084, 37.56281], [-122.13261, 37.56298], [-122.13323, 37.56284], [-122.13351, 37.56302]]]} | Open Access 1 | 3455 | Alameda Creek Regional Trail | 3205 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/trails/alameda_creek | Alameda 17 | 667.245 | Alameda Creek Reg. Trail | 1992 | Local Recreation Area 3 | 4 |
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 4 | |
4860 | 4860 | 4859 | {"type": "Polygon", "coordinates": [[[-118.8224, 34.295], [-118.82168, 34.29571], [-118.82099, 34.29626], [-118.8176, 34.29545], [-118.81217, 34.29678], [-118.80476, 34.30392], [-118.79639, 34.30984], [-118.79638, 34.3044], [-118.80047, 34.30326], [-118.80195, 34.30167], [-118.80796, 34.29721], [-118.8082, 34.29486], [-118.80973, 34.29297], [-118.81042, 34.29304], [-118.81081, 34.29253], [-118.81063, 34.29221], [-118.81146, 34.29191], [-118.81295, 34.29197], [-118.81497, 34.29179], [-118.8156, 34.29223], [-118.81725, 34.2923], [-118.81836, 34.29215], [-118.81865, 34.29188], [-118.819, 34.29232], [-118.8199, 34.292], [-118.82059, 34.29224], [-118.82079, 34.29209], [-118.82145, 34.29225], [-118.82176, 34.29316], [-118.82239, 34.2945], [-118.8224, 34.295]]]} | Open Access 1 | 48520 | Alamos Canyon Open Space | 33233 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/simi_valley/trails/alamoscanyon.php | Ventura 8 | 281.33 | Alamos Canyon OS | 2016 | Local Recreation Area 3 | 4 |
2787 | 2787 | 2786 | {"type": "MultiPolygon", "coordinates": [[[[-117.1655, 32.74559], [-117.1651, 32.7456], [-117.16509, 32.74433], [-117.1655, 32.74432], [-117.1655, 32.74559]]], [[[-117.16661, 32.74404], [-117.1661, 32.74404], [-117.16611, 32.74459], [-117.16556, 32.7446], [-117.16555, 32.74405], [-117.16556, 32.74392], [-117.16661, 32.7439], [-117.16661, 32.74404]]], [[[-117.16849, 32.74062], [-117.16808, 32.74063], [-117.16809, 32.74086], [-117.16797, 32.74096], [-117.16759, 32.74142], [-117.16751, 32.74153], [-117.16669, 32.74154], [-117.16668, 32.74105], [-117.16763, 32.74103], [-117.16764, 32.74064], [-117.16763, 32.74022], [-117.16809, 32.74021], [-117.16809, 32.73983], [-117.16848, 32.73982], [-117.16849, 32.74062]]], [[[-117.16935, 32.73926], [-117.16914, 32.73957], [-117.16907, 32.7397], [-117.169, 32.73971], [-117.16899, 32.73918], [-117.16934, 32.73918], [-117.16935, 32.73926]]]]} | Open Access 1 | 18557 | Albatross Canyon Open Space | 15332 | 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 | 5.812 | Albatross Canyon OS | 0 | Local Recreation Area 3 | 4 | |
1397 | 1397 | 1396 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.2322], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | 8689 | Albertson Parkway | 15341 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.047 | Albertson Parkway | 1998 | Local Recreation Area 3 | 4 | |
17026 | 17026 | 17025 | {"type": "Polygon", "coordinates": [[[-121.92429, 37.73448], [-121.92386, 37.73452], [-121.92261, 37.73371], [-121.92234, 37.73207], [-121.92317, 37.73206], [-121.9232, 37.7322], [-121.92324, 37.73234], [-121.92329, 37.73243], [-121.92342, 37.73259], [-121.92358, 37.73273], [-121.92376, 37.73283], [-121.92426, 37.73299], [-121.92428, 37.73302], [-121.9242, 37.73331], [-121.92418, 37.73362], [-121.92429, 37.73448]]]} | Open Access 1 | 13203 | Alcosta Senior and Community Center Park and Gardens | 31296 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 7.203 | Alcosta Senior and Community Ctr. Park and Gardens | 0 | Local Recreation Area 3 | 4 | |
9348 | 9348 | 9347 | {"type": "Polygon", "coordinates": [[[-122.08989, 37.61048], [-122.08987, 37.61053], [-122.08977, 37.61052], [-122.08967, 37.61056], [-122.08963, 37.61061], [-122.08961, 37.61069], [-122.08957, 37.61073], [-122.08562, 37.61228], [-122.08557, 37.61229], [-122.08553, 37.61227], [-122.0855, 37.61225], [-122.08428, 37.61025], [-122.08437, 37.6101], [-122.08512, 37.60981], [-122.0861, 37.60938], [-122.08619, 37.60938], [-122.08648, 37.60926], [-122.08681, 37.60932], [-122.08724, 37.60918], [-122.08742, 37.60915], [-122.08761, 37.60915], [-122.08791, 37.60919], [-122.08818, 37.60928], [-122.08836, 37.60916], [-122.08989, 37.61048]]]} | Open Access 1 | 15618 | Alden E. Oliver Sports Park | 15344 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 25.025 | Alden E. Oliver Sports Park | 0 | Local Recreation Area 3 | 4 | |
7792 | 7792 | 7791 | {"type": "Polygon", "coordinates": [[[-117.34567, 33.22133], [-117.34531, 33.22156], [-117.34498, 33.22181], [-117.34466, 33.22207], [-117.34437, 33.22235], [-117.34432, 33.2223], [-117.34451, 33.22209], [-117.34469, 33.22184], [-117.34484, 33.22158], [-117.34494, 33.22133], [-117.34501, 33.22129], [-117.34538, 33.22134], [-117.34567, 33.22133]]]} | Open Access 1 | 47674 | Alex Road Skate Park | 31416 | 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 | http://www.ci.oceanside.ca.us/gov/ns/parks/alexpark.asp | San Diego 4 | 0.81 | Alex Road Skate Park | 0 | Local Recreation Area 3 | 4 |
7130 | 7130 | 7129 | {"type": "Polygon", "coordinates": [[[-118.28686, 33.95825], [-118.28478, 33.95826], [-118.28477, 33.95515], [-118.28686, 33.95513], [-118.28685, 33.95598], [-118.28686, 33.95825]]]} | Open Access 1 | 6214 | Algin Sutton Recreation Center | 15356 | 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 | 16.444 | Algin Sutton Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
8257 | 8257 | 8256 | {"type": "Polygon", "coordinates": [[[-118.11967, 34.09049], [-118.11966, 34.09074], [-118.11234, 34.09388], [-118.10973, 34.0882], [-118.10992, 34.08814], [-118.10934, 34.08688], [-118.1091, 34.08626], [-118.10941, 34.08615], [-118.10899, 34.08523], [-118.10881, 34.08475], [-118.11269, 34.08456], [-118.11268, 34.08483], [-118.11269, 34.0859], [-118.11273, 34.08679], [-118.11276, 34.08697], [-118.11298, 34.08739], [-118.1137, 34.08774], [-118.11393, 34.08771], [-118.11418, 34.08766], [-118.11449, 34.08765], [-118.11449, 34.08813], [-118.11461, 34.08814], [-118.11486, 34.08831], [-118.11491, 34.08836], [-118.11491, 34.08858], [-118.11575, 34.08939], [-118.11563, 34.08939], [-118.11563, 34.0896], [-118.11567, 34.08964], [-118.1157, 34.08965], [-118.11577, 34.08965], [-118.11578, 34.08941], [-118.11591, 34.08929], [-118.11685, 34.08929], [-118.11686, 34.09051], [-118.11967, 34.09049]]]} | Restricted Access 2 | 45406 | Alhambra Municipal Golf Course | 33112 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://alhambragolf.com/ag/ | Los Angeles 6 | 107.021 | Alhambra Municipal GC | 0 | Local Recreation Area 3 | 4 |
6827 | 6827 | 6826 | {"type": "Polygon", "coordinates": [[[-122.44734, 37.70991], [-122.44625, 37.71028], [-122.44596, 37.70975], [-122.44705, 37.70937], [-122.44734, 37.70991]]]} | Open Access 1 | 5435 | Alice Chalmers Playground | 15359 | 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.678 | Alice Chalmers 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]);