units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 201
- Los Angeles, City of 111
- San Francisco, City and County of 68
- Mountains Recreation and Conservation Authority 56
- Los Angeles, County of 29
- Conejo Open Space Conservation Agency 29
- Las Virgenes Municipal Water District 28
- East Bay Regional Park District 27
- San Luis Obispo, City of 24
- Davis, City of 23
- Long Beach, City of 22
- Glendale, City of 21
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 13
- San Bernardino, City of 13
- San Marcos, City of 13
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Fullerton, City of 12
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,367
- Recreation/Parks District 158
- County Agency 113
- Open Space District 86
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 11
- School District 5
- County Agency - Other 4
- Port/Harbor District 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,561
- Restricted Access 215
- No Public Access 111
- Unknown Access 15
DES_TP 1
- Local Recreation Area · 1,902 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
1140 | 1140 | 1139 | {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} | Restricted Access 2 | 6710 | Rio Hondo Golf Club | 33020 | 1088 | Downey, City of 82 | City 2 | City Agency 2 | http://www.downeyca.org/services/cs/default.asp | City 2 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 101.146 | Rio Hondo Golf Club | 0 | Local Recreation Area 3 | 4 | |
1164 | 1164 | 1163 | {"type": "Polygon", "coordinates": [[[-121.68889, 38.16495], [-121.68802, 38.16593], [-121.68697, 38.16507], [-121.68672, 38.16489], [-121.68773, 38.16406], [-121.68889, 38.16495]]]} | Open Access 1 | 44204 | Egbert Field | 18465 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 4.813 | Egbert Field | 0 | Local Recreation Area 3 | 4 | |
1166 | 1166 | 1165 | {"type": "Polygon", "coordinates": [[[-117.0572, 32.66636], [-117.05717, 32.66642], [-117.05693, 32.66652], [-117.05679, 32.66662], [-117.05658, 32.6669], [-117.0566, 32.66695], [-117.05643, 32.66694], [-117.05625, 32.667], [-117.05622, 32.66692], [-117.05646, 32.66682], [-117.0562, 32.66632], [-117.05616, 32.66621], [-117.05615, 32.66607], [-117.05618, 32.66596], [-117.05628, 32.66599], [-117.05625, 32.66613], [-117.05626, 32.66621], [-117.05629, 32.66627], [-117.05684, 32.66658], [-117.0571, 32.66631], [-117.05716, 32.66632], [-117.0572, 32.66636]]]} | Open Access 1 | 7388 | 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 | 0.709 | South Bay Terraces OS | 0 | Local Recreation Area 3 | 4 | |
1167 | 1167 | 1166 | {"type": "Polygon", "coordinates": [[[-117.95566, 34.1362], [-117.95566, 34.13715], [-117.95445, 34.13716], [-117.95444, 34.13738], [-117.95438, 34.13739], [-117.95438, 34.13752], [-117.95365, 34.13752], [-117.95365, 34.13733], [-117.9534, 34.13734], [-117.95341, 34.13659], [-117.95378, 34.13658], [-117.95379, 34.13621], [-117.95566, 34.1362]]]} | Open Access 1 | 7391 | Otis Gordon Sports Park | 23266 | 1089 | Duarte, City of 328 | City 2 | City Agency 2 | http://www.accessduarte.com/index.php?option=com_content&view=article&id=62&Itemid=72 | City 2 | 1089 | Duarte, City of 325 | City 2 | City Agency 2 | Los Angeles 6 | 5.895 | Otis Gordon Sports Park | 0 | Local Recreation Area 3 | 4 | |
1171 | 1171 | 1170 | {"type": "MultiPolygon", "coordinates": [[[[-117.12486, 32.71786], [-117.12437, 32.71786], [-117.12432, 32.71769], [-117.12428, 32.71748], [-117.12485, 32.71748], [-117.12486, 32.71786]]], [[[-117.12527, 32.7201], [-117.12493, 32.7201], [-117.12493, 32.71957], [-117.12459, 32.71956], [-117.12459, 32.71928], [-117.1244, 32.71927], [-117.1244, 32.71914], [-117.12521, 32.71913], [-117.12522, 32.71925], [-117.12525, 32.71926], [-117.12526, 32.71942], [-117.12527, 32.7201]]], [[[-117.1252, 32.71847], [-117.12449, 32.71847], [-117.12441, 32.71809], [-117.1252, 32.71808], [-117.1252, 32.71847]]], [[[-117.12521, 32.7189], [-117.12456, 32.71891], [-117.12452, 32.71853], [-117.12521, 32.71852], [-117.12521, 32.7189]]], [[[-117.12529, 32.72089], [-117.12494, 32.72089], [-117.12494, 32.72033], [-117.12528, 32.72032], [-117.12529, 32.72089]]], [[[-117.12597, 32.72046], [-117.12554, 32.72046], [-117.12554, 32.72028], [-117.12596, 32.72028], [-117.12597, 32.72046]]], [[[-117.12598, 32.72117], [-117.12554, 32.72117], [-117.12554, 32.72059], [-117.12597, 32.72059], [-117.12598, 32.72117]]], [[[-117.12644, 32.72134], [-117.12644, 32.72193], [-117.12597, 32.72192], [-117.12597, 32.72134], [-117.12644, 32.72134]]], [[[-117.12744, 32.72243], [-117.12743, 32.72304], [-117.12707, 32.72304], [-117.12707, 32.72292], [-117.12704, 32.72291], [-117.12704, 32.72269], [-117.12665, 32.72268], [-117.12666, 32.72243], [-117.12744, 32.72243]]], [[[-117.12744, 32.72221], [-117.12669, 32.72221], [-117.1267, 32.72179], [-117.12703, 32.7218], [-117.12704, 32.72207], [-117.12736, 32.72215], [-117.12743, 32.72215], [-117.12744, 32.72221]]], [[[-117.1283, 32.72411], [-117.12828, 32.72434], [-117.12792, 32.72434], [-117.12792, 32.72404], [-117.12829, 32.72404], [-117.1283, 32.72411]]], [[[-117.12829, 32.7239], [-117.12792, 32.72391], [-117.12792, 32.72377], [-117.12829, 32.72378], [-117.12829, 32.7239]]]]} | Open Access 1 | 7499 | 32nd Street Canyon | 15193 | 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 | 7.011 | 32nd Street Canyon | 0 | Local Recreation Area 3 | 4 | |
1188 | 1188 | 1187 | {"type": "Polygon", "coordinates": [[[-118.33232, 34.11518], [-118.33231, 34.11561], [-118.33188, 34.11561], [-118.33189, 34.11558], [-118.33202, 34.11557], [-118.33203, 34.11518], [-118.33232, 34.11518]]]} | Open Access 1 | 6882 | Lake Hollywood MRCA Open Space | 20946 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.322 | Lake Hollywood MRCA OS | 0 | Local Recreation Area 3 | 4 | |
1189 | 1189 | 1188 | {"type": "Polygon", "coordinates": [[[-118.34398, 34.10983], [-118.34396, 34.10986], [-118.34393, 34.10999], [-118.34395, 34.1101], [-118.34376, 34.11029], [-118.34363, 34.10997], [-118.34368, 34.10981], [-118.34398, 34.10983]]]} | Open Access 1 | 6893 | Castilian MRCA Open Space | 16949 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.278 | Castilian MRCA OS | 0 | Local Recreation Area 3 | 4 | |
1190 | 1190 | 1189 | {"type": "Polygon", "coordinates": [[[-118.3611, 34.12682], [-118.36096, 34.12699], [-118.36109, 34.12708], [-118.36098, 34.12719], [-118.36091, 34.12732], [-118.36077, 34.12724], [-118.36072, 34.12735], [-118.36057, 34.12747], [-118.36053, 34.1274], [-118.36065, 34.1273], [-118.36073, 34.12714], [-118.36079, 34.12706], [-118.36096, 34.12689], [-118.36102, 34.12679], [-118.3611, 34.12682]]]} | Open Access 1 | 6901 | Mulholland Adjacent Open Space | 22590 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.278 | Mulholland Adjacent OS | 0 | Local Recreation Area 3 | 4 | |
1205 | 1205 | 1204 | {"type": "Polygon", "coordinates": [[[-118.20232, 34.16387], [-118.20106, 34.1656], [-118.19947, 34.16766], [-118.19941, 34.16746], [-118.19749, 34.16476], [-118.19693, 34.16344], [-118.19696, 34.1634], [-118.19691, 34.16337], [-118.19799, 34.1627], [-118.19908, 34.16182], [-118.19934, 34.16179], [-118.19954, 34.16174], [-118.20232, 34.16387]]]} | Open Access 1 | 6952 | Poulsen Open Space | 23929 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 42.171 | Poulsen OS | 0 | Local Recreation Area 3 | 4 | |
1235 | 1235 | 1234 | {"type": "Polygon", "coordinates": [[[-118.17369, 33.96951], [-118.1736, 33.97012], [-118.17246, 33.97], [-118.17256, 33.96943], [-118.17258, 33.9694], [-118.17369, 33.96951]]]} | Open Access 1 | 8946 | Pritchard Field | 24012 | 1022 | Bell, City of 336 | City 2 | City Agency 2 | http://www.cityofbell.org/?navid=118 | City 2 | 1022 | Bell, City of 333 | City 2 | City Agency 2 | Los Angeles 6 | 1.763 | Pritchard Field | 0 | Local Recreation Area 3 | 4 | |
1243 | 1243 | 1242 | {"type": "Polygon", "coordinates": [[[-118.25098, 34.17212], [-118.25095, 34.17243], [-118.25087, 34.17251], [-118.25076, 34.17252], [-118.25042, 34.17245], [-118.25036, 34.17242], [-118.25034, 34.17238], [-118.25034, 34.17208], [-118.2503, 34.17197], [-118.25018, 34.17186], [-118.24999, 34.1718], [-118.24996, 34.17176], [-118.25, 34.17174], [-118.2503, 34.17172], [-118.25062, 34.1719], [-118.25084, 34.17211], [-118.25098, 34.17212]]]} | Open Access 1 | 7146 | City of Glendale Open Space | 17315 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.988 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
1248 | 1248 | 1247 | {"type": "Polygon", "coordinates": [[[-118.33325, 34.04972], [-118.33236, 34.05184], [-118.33135, 34.05158], [-118.33231, 34.04955], [-118.33325, 34.04972]]]} | Open Access 1 | 9240 | Queen Anne Recreation Center | 24060 | 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 | 5.637 | Queen Anne Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1268 | 1268 | 1267 | {"type": "Polygon", "coordinates": [[[-118.25078, 34.1714], [-118.25076, 34.17144], [-118.25067, 34.17152], [-118.25055, 34.17158], [-118.24999, 34.17163], [-118.24993, 34.17162], [-118.24985, 34.17158], [-118.24975, 34.17141], [-118.25004, 34.17087], [-118.25034, 34.17093], [-118.25056, 34.17087], [-118.25078, 34.17138], [-118.25078, 34.1714]]]} | Open Access 1 | 7144 | City of Glendale Open Space | 17315 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 1.454 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
1269 | 1269 | 1268 | {"type": "Polygon", "coordinates": [[[-118.26461, 34.17807], [-118.26461, 34.17807], [-118.26442, 34.17818], [-118.2644, 34.17805], [-118.26441, 34.17804], [-118.26459, 34.17797], [-118.26461, 34.17807]]]} | Open Access 1 | 7148 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.061 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
1274 | 1274 | 1273 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | 7201 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.02 | Compton Creek & Bike Path | 0 | Local Recreation Area 3 | 4 | |
1291 | 1291 | 1290 | {"type": "MultiPolygon", "coordinates": [[[[-117.07057, 32.94232], [-117.06677, 32.94231], [-117.06671, 32.93635], [-117.06692, 32.93607], [-117.06708, 32.93569], [-117.0672, 32.93509], [-117.06807, 32.93508], [-117.06799, 32.93563], [-117.06791, 32.93588], [-117.06782, 32.93639], [-117.0678, 32.93715], [-117.06786, 32.93741], [-117.06788, 32.93783], [-117.06779, 32.93826], [-117.06775, 32.93854], [-117.06774, 32.93882], [-117.06779, 32.93916], [-117.06791, 32.93942], [-117.06814, 32.93983], [-117.06835, 32.94028], [-117.06851, 32.941], [-117.0687, 32.94141], [-117.06878, 32.94177], [-117.06885, 32.9419], [-117.06898, 32.94201], [-117.06957, 32.9423], [-117.07052, 32.9423], [-117.07057, 32.94232]]], [[[-117.07309, 32.94149], [-117.07309, 32.94181], [-117.07273, 32.94309], [-117.07263, 32.94309], [-117.07242, 32.94272], [-117.07238, 32.94269], [-117.07231, 32.94268], [-117.07225, 32.94273], [-117.07232, 32.94296], [-117.07236, 32.94303], [-117.07236, 32.94314], [-117.0723, 32.94329], [-117.07228, 32.94341], [-117.07231, 32.9436], [-117.07231, 32.94441], [-117.07235, 32.94524], [-117.07233, 32.9453], [-117.07227, 32.94536], [-117.07225, 32.94536], [-117.07221, 32.94534], [-117.0721, 32.94517], [-117.07205, 32.94499], [-117.072, 32.94488], [-117.07193, 32.94479], [-117.07153, 32.94438], [-117.07144, 32.94432], [-117.07135, 32.94427], [-117.07108, 32.94419], [-117.07107, 32.94264], [-117.07129, 32.94258], [-117.07143, 32.94248], [-117.07143, 32.94215], [-117.07151, 32.94209], [-117.07142, 32.94171], [-117.07122, 32.94148], [-117.07069, 32.94136], [-117.07081, 32.94103], [-117.07082, 32.94054], [-117.07059, 32.93976], [-117.07073, 32.93967], [-117.07097, 32.94041], [-117.07114, 32.94067], [-117.07171, 32.94089], [-117.07232, 32.94082], [-117.07254, 32.9409], [-117.07267, 32.94103], [-117.07265, 32.94138], [-117.07309, 32.94149]]], [[[-117.07537, 32.94599], [-117.07108, 32.94596], [-117.07108, 32.94423], [-117.07139, 32.94433], [-117.07152, 32.94442], [-117.07192, 32.94485], [-117.072, 32.94498], [-117.07205, 32.94519], [-117.07217, 32.94536], [-117.07222, 32.9454], [-117.07229, 32.9454], [-117.07233, 32.94537], [-117.07238, 32.9453], [-117.07241, 32.94522], [-117.07236, 32.94441], [-117.07235, 32.9436], [-117.07233, 32.94348], [-117.07233, 32.94336], [-117.0724, 32.94317], [-117.07241, 32.94306], [-117.07231, 32.94275], [-117.07232, 32.94273], [-117.07236, 32.94273], [-117.07262, 32.94316], [-117.07261, 32.94322], [-117.07262, 32.94325], [-117.07267, 32.94331], [-117.07272, 32.94333], [-117.07286, 32.94363], [-117.07308, 32.94391], [-117.07352, 32.94431], [-117.07353, 32.94462], [-117.074, 32.94525], [-117.07404, 32.94529], [-117.07414, 32.94532], [-117.07421, 32.94531], [-117.07512, 32.94494], [-117.07522, 32.94494], [-117.07537, 32.94497], [-117.07537, 32.94599]]], [[[-117.0803, 32.94165], [-117.08027, 32.94177], [-117.08029, 32.94184], [-117.07971, 32.94233], [-117.07949, 32.94248], [-117.07929, 32.94259], [-117.07838, 32.94301], [-117.07825, 32.94304], [-117.0782, 32.94302], [-117.07808, 32.94301], [-117.07637, 32.94244], [-117.0764, 32.94232], [-117.0764, 32.94224], [-117.07638, 32.94223], [-117.07634, 32.94212], [-117.07628, 32.94204], [-117.07596, 32.9418], [-117.07566, 32.94149], [-117.07555, 32.94134], [-117.07538, 32.94116], [-117.07514, 32.94097], [-117.0747, 32.94067], [-117.07462, 32.9407], [-117.07445, 32.94049], [-117.07432, 32.94028], [-117.07424, 32.9401], [-117.07417, 32.93972], [-117.07418, 32.93951], [-117.0743, 32.93862], [-117.07452, 32.93864], [-117.07504, 32.93922], [-117.07614, 32.94008], [-117.07698, 32.94009], [-117.07758, 32.93974], [-117.07807, 32.93885], [-117.07804, 32.93869], [-117.07863, 32.93869], [-117.07892, 32.93948], [-117.07913, 32.9398], [-117.07933, 32.94001], [-117.0796, 32.94021], [-117.07991, 32.94036], [-117.08011, 32.94044], [-117.08021, 32.94058], [-117.08017, 32.94078], [-117.08017, 32.94098], [-117.0802, 32.94123], [-117.0803, 32.94165]]], [[[-117.07675, 32.94583], [-117.07666, 32.94596], [-117.0761, 32.94595], [-117.07614, 32.94552], [-117.07617, 32.94555], [-117.07632, 32.9456], [-117.0764, 32.9456], [-117.0764, 32.94557], [-117.07664, 32.9458], [-117.07675, 32.94583]]], [[[-117.07936, 32.94342], [-117.07936, 32.94348], [-117.07906, 32.9435], [-117.07851, 32.94344], [-117.07837, 32.94346], [-117.07825, 32.94352], [-117.07815, 32.94361], [-117.07787, 32.94404], [-117.07764, 32.9443], [-117.07742, 32.94458], [-117.07728, 32.9447], [-117.07679, 32.94504], [-117.07663, 32.94517], [-117.07658, 32.94527], [-117.07658, 32.94542], [-117.07641, 32.9453], [-117.07735, 32.94444], [-117.07769, 32.94403], [-117.07814, 32.94339], [-117.07825, 32.94333], [-117.07849, 32.9433], [-117.07873, 32.94332], [-117.07913, 32.94341], [-117.07936, 32.94342]]], [[[-117.08415, 32.94239], [-117.084, 32.94295], [-117.08371, 32.94308], [-117.08271, 32.94296], [-117.08251, 32.94297], [-117.08211, 32.94305], [-117.08178, 32.94318], [-117.08157, 32.94331], [-117.08066, 32.94403], [-117.08045, 32.94415], [-117.08028, 32.94422], [-117.07995, 32.9443], [-117.07898, 32.94438], [-117.07873, 32.94446], [-117.07846, 32.94457], [-117.07812, 32.94482], [-117.07714, 32.9458], [-117.07708, 32.9458], [-117.07663, 32.94546], [-117.07662, 32.94529], [-117.07667, 32.94519], [-117.07736, 32.9447], [-117.07753, 32.94453], [-117.07768, 32.94432], [-117.07791, 32.94407], [-117.0782, 32.94362], [-117.07826, 32.94357], [-117.07832, 32.94353], [-117.07839, 32.9435], [-117.07854, 32.94348], [-117.07906, 32.94354], [-117.07937, 32.94353], [-117.07967, 32.94356], [-117.07986, 32.94353], [-117.07999, 32.94347], [-117.08057, 32.94297], [-117.08082, 32.94269], [-117.08103, 32.94234], [-117.08111, 32.94226], [-117.08128, 32.94218], [-117.08185, 32.94209], [-117.08301, 32.94214], [-117.0834, 32.94221], [-117.0838, 32.94236], [-117.08415, 32.94239]]], [[[-117.08107, 32.94224], [-117.08095, 32.94237], [-117.08078, 32.94267], [-117.08053, 32.94295], [-117.07998, 32.94343], [-117.07986, 32.94349], [-117.07973, 32.94352], [-117.07962, 32.94352], [-117.07939, 32.94348], [-117.07939, 32.94342], [-117.07955, 32.94342], [-117.0797, 32.94339], [-117.07982, 32.94333], [-117.07996, 32.94322], [-117.08053, 32.94267], [-117.08081, 32.94226], [-117.08092, 32.94215], [-117.08107, 32.94224]]], [[[-117.09728, 32.93926], [-117.0965, 32.93964], [-117.09628, 32.94002], [-117.09594, 32.93984], [-117.09473, 32.93991], [-117.09392, 32.94048], [-117.09397, 32.94157], [-117.09484, 32.94215], [-117.0949, 32.94238], [-117.09408, 32.94235], [-117.09381, 32.9423], [-117.09363, 32.94224], [-117.09309, 32.94197], [-117.09299, 32.94193], [-117.09277, 32.94191], [-117.09246, 32.94179], [-117.09226, 32.94173], [-117.09202, 32.94169], [-117.09168, 32.94169], [-117.09145, 32.94162], [-117.09134, 32.94156], [-117.09118, 32.94139], [-117.09093, 32.94126], [-117.09082, 32.94123], [-117.09057, 32.94127], [-117.09024, 32.94127], [-117.09017, 32.9413], [-117.08999, 32.94142], [-117.08966, 32.94154], [-117.08895, 32.94171], [-117.08873, 32.94172], [-117.08821, 32.94187], [-117.08761, 32.94213], [-117.08753, 32.94219], [-117.08753, 32.94186], [-117.08742, 32.94171], [-117.08707, 32.94142], [-117.08693, 32.94133], [-117.08671, 32.94122], [-117.08646, 32.94125], [-117.08604, 32.94145], [-117.08554, 32.94162], [-117.08528, 32.94175], [-117.08506, 32.94183], [-117.08444, 32.94187], [-117.0843, 32.94147], [-117.0842, 32.9413], [-117.08407, 32.9411], [-117.08387, 32.9409], [-117.08365, 32.94072], [-117.0836, 32.94077], [-117.08349, 32.9407], [-117.08412, 32.93995], [-117.08412, 32.93962], [-117.0837, 32.93935], [-117.08351, 32.93904], [-117.08291, 32.93903], [-117.08262, 32.93907], [-117.08197, 32.93923], [-117.08162, 32.93922], [-117.08131, 32.93908], [-117.0807, 32.93866], [-117.0803, 32.93852], [-117.08031, 32.9383], [-117.08023, 32.93791], [-117.08033, 32.93783], [-117.08003, 32.93754], [-117.08035, 32.9373], [-117.0805, 32.93738], [-117.08057, 32.93759], [-117.08089, 32.93783], [-117.0812, 32.93782], [-117.08137, 32.93762], [-117.08153, 32.93739], [-117.08166, 32.93715], [-117.08168, 32.93689], [-117.08161, 32.93663], [-117.08104, 32.93557], [-117.08042, 32.93499], [-117.0805, 32.93502], [-117.08229, 32.93501], [-117.08237, 32.93516], [-117.08269, 32.93533], [-117.08362, 32.93521], [-117.08364, 32.9362], [-117.08383, 32.93639], [-117.08399, 32.93637], [-117.08416, 32.93638], [-117.08441, 32.93666], [-117.08453, 32.93668], [-117.08446, 32.9369], [-117.08452, 32.93714], [-117.0848, 32.93727], [-117.08524, 32.93725], [-117.08548, 32.93715], [-117.08563, 32.93698], [-117.08572, 32.93668], [-117.08578, 32.9366], [-117.08626, 32.93658], [-117.08646, 32.93649], [-117.08691, 32.93662], [-117.0871, 32.93683], [-117.08729, 32.93688], [-117.08748, 32.93683], [-117.08833, 32.93707], [-117.08884, 32.93707], [-117.08884, 32.93736], [-117.08889, 32.9377], [-117.08893, 32.93786], [-117.08914, 32.938], [-117.08945, 32.93798], [-117.08976, 32.93786], [-117.08998, 32.93773], [-117.09044, 32.93779], [-117.09069, 32.93799], [-117.09085, 32.93809], [-117.09109, 32.93815], [-117.09174, 32.93811], [-117.09202, 32.93817], [-117.09237, 32.93844], [-117.09264, 32.93841], [-117.09296, 32.93831], [-117.0931, 32.9383], [-117.0939, 32.93831], [-117.09433, 32.93828], [-117.09476, 32.93835], [-117.09512, 32.93844], [-117.09515, 32.93848], [-117.09545, 32.93855], [-117.09586, 32.9386], [-117.09652, 32.93886], [-117.09664, 32.93886], [-117.09728, 32.93926]]], [[[-117.10986, 32.93812], [-117.10981, 32.93847], [-117.10965, 32.93884], [-117.10933, 32.93927], [-117.10947, 32.9396], [-117.10848, 32.94219], [-117.10836, 32.94215], [-117.10813, 32.94274], [-117.10787, 32.94332], [-117.10756, 32.94397], [-117.10726, 32.94452], [-117.10652, 32.94523], [-117.10621, 32.94547], [-117.10592, 32.94565], [-117.10465, 32.94628], [-117.10445, 32.94608], [-117.10421, 32.94591], [-117.10393, 32.94577], [-117.10367, 32.9457], [-117.1034, 32.94566], [-117.10308, 32.94568], [-117.10267, 32.94577], [-117.10236, 32.94587], [-117.10222, 32.94577], [-117.10182, 32.94575], [-117.1016, 32.94562], [-117.10039, 32.94645], [-117.09977, 32.9466], [-117.09962, 32.94661], [-117.0995, 32.9465], [-117.09914, 32.94654], [-117.09851, 32.94674], [-117.09804, 32.94679], [-117.09787, 32.94669], [-117.09724, 32.94667], [-117.0971, 32.94684], [-117.0966, 32.94683], [-117.09653, 32.94673], [-117.0962, 32.94643], [-117.09604, 32.9464], [-117.09601, 32.9462], [-117.09595, 32.94596], [-117.09585, 32.94569], [-117.09568, 32.9454], [-117.09569, 32.94538], [-117.09565, 32.94514], [-117.09558, 32.94495], [-117.09536, 32.94465], [-117.0952, 32.94452], [-117.09508, 32.94446], [-117.09495, 32.94444], [-117.09491, 32.94449], [-117.09467, 32.9444], [-117.09442, 32.94434], [-117.09342, 32.94424], [-117.09315, 32.9442], [-117.09201, 32.94389], [-117.0913, 32.94356], [-117.09111, 32.94349], [-117.0902, 32.94322], [-117.08993, 32.94317], [-117.08963, 32.94316], [-117.08939, 32.94318], [-117.08922, 32.94322], [-117.08862, 32.94338], [-117.08838, 32.94342], [-117.08593, 32.94363], [-117.08565, 32.9436], [-117.08542, 32.94354], [-117.08476, 32.94326], [-117.08443, 32.94318], [-117.08428, 32.94307], [-117.08435, 32.94259], [-117.0844, 32.94266], [-117.08446, 32.94271], [-117.0848, 32.94283], [-117.08503, 32.94288], [-117.08586, 32.94276], [-117.08611, 32.94274], [-117.0867, 32.94257], [-117.08725, 32.94233], [-117.08754, 32.94225], [-117.08764, 32.94217], [-117.08823, 32.94191], [-117.08874, 32.94176], [-117.08895, 32.94175], [-117.08968, 32.94158], [-117.09001, 32.94146], [-117.09025, 32.94131], [-117.0905, 32.94131], [-117.09086, 32.94128], [-117.09115, 32.94143], [-117.09132, 32.9416], [-117.09142, 32.94166], [-117.09166, 32.94173], [-117.09199, 32.94173], [-117.09222, 32.94177], [-117.09247, 32.94183], [-117.09274, 32.94194], [-117.09299, 32.94197], [-117.09363, 32.94228], [-117.09382, 32.94235], [-117.09408, 32.94239], [-117.09528, 32.94243], [-117.09539, 32.94246], [-117.09279, 32.94244], [-117.09279, 32.94354], [-117.09574, 32.94357], [-117.09631, 32.94426], [-117.0964, 32.94454], [-117.09652, 32.94473], [-117.09658, 32.94496], [-117.09675, 32.94517], [-117.09686, 32.94525], [-117.09698, 32.94532], [-117.09714, 32.94536], [-117.09817, 32.94548], [-117.09828, 32.94552], [-117.09838, 32.94558], [-117.09845, 32.94564], [-117.09861, 32.94583], [-117.09877, 32.94592], [-117.09887, 32.94596], [-117.099, 32.94597], [-117.0993, 32.94594], [-117.09945, 32.94588], [-117.09956, 32.94576], [-117.09964, 32.94561], [-117.09968, 32.94549], [-117.09971, 32.94534], [-117.09972, 32.94516], [-117.09974, 32.94511], [-117.09979, 32.94504], [-117.09999, 32.9449], [-117.10006, 32.94482], [-117.10016, 32.94468], [-117.10023, 32.94451], [-117.10026, 32.94432], [-117.10025, 32.94409], [-117.10019, 32.94396], [-117.1, 32.9437], [-117.09999, 32.94361], [-117.10152, 32.94362], [-117.10148, 32.94252], [-117.10584, 32.94255], [-117.10583, 32.94153], [-117.10551, 32.94124], [-117.10518, 32.94112], [-117.10476, 32.9412], [-117.10464, 32.94114], [-117.10439, 32.94066], [-117.10381, 32.93995], [-117.10366, 32.93955], [-117.10333, 32.93906], [-117.1031, 32.93894], [-117.10203, 32.93893], [-117.10198, 32.9387], [-117.10174, 32.93837], [-117.10178, 32.93755], [-117.10358, 32.9376], [-117.10381, 32.93821], [-117.10395, 32.93843], [-117.10423, 32.93874], [-117.10436, 32.93895], [-117.10619, 32.93897], [-117.10645, 32.93877], [-117.10662, 32.93853], [-117.10667, 32.93833], [-117.10693, 32.93832], [-117.10769, 32.93796], [-117.10774, 32.9379], [-117.10763, 32.93776], [-117.10761, 32.93769], [-117.10767, 32.93768], [-117.10769, 32.93774], [-117.10779, 32.93787], [-117.10788, 32.93795], [-117.10808, 32.93802], [-117.10824, 32.93804], [-117.10834, 32.93809], [-117.10847, 32.93821], [-117.10859, 32.93829], [-117.10883, 32.93811], [-117.10909, 32.93813], [-117.10986, 32.93812]]], [[[-117.08502, 32.94215], [-117.08493, 32.94282], [-117.08481, 32.94279], [-117.08449, 32.94267], [-117.08443, 32.94262], [-117.08454, 32.94239], [-117.08456, 32.9423], [-117.08464, 32.94214], [-117.08484, 32.94211], [-117.08502, 32.94215]]], [[[-117.09994, 32.9436], [-117.09996, 32.94372], [-117.10015, 32.94398], [-117.1002, 32.94412], [-117.10021, 32.94438], [-117.10015, 32.94459], [-117.10008, 32.94472], [-117.09999, 32.94484], [-117.09976, 32.94501], [-117.09969, 32.94508], [-117.09967, 32.94516], [-117.09966, 32.94534], [-117.09962, 32.94553], [-117.09955, 32.94569], [-117.09947, 32.94581], [-117.09933, 32.94589], [-117.09901, 32.94593], [-117.09885, 32.94591], [-117.09869, 32.94583], [-117.09861, 32.94577], [-117.09844, 32.94557], [-117.09823, 32.94545], [-117.09808, 32.94542], [-117.09714, 32.94532], [-117.09702, 32.94529], [-117.09686, 32.94521], [-117.09679, 32.94514], [-117.09663, 32.94495], [-117.09656, 32.94471], [-117.09644, 32.94452], [-117.09636, 32.94424], [-117.09581, 32.94357], [-117.09711, 32.94358], [-117.09709, 32.94303], [-117.09986, 32.94305], [-117.09989, 32.94359], [-117.09994, 32.9436]]], [[[-117.09822, 32.94249], [-117.09799, 32.94249], [-117.09745, 32.94173], [-117.09743, 32.94121], [-117.09722, 32.94088], [-117.09764, 32.94089], [-117.09773, 32.94149], [-117.09822, 32.94249]]]]} | Open Access 1 | 7329 | Sabre Springs South Open Space | 10518 | 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 | 451.702 | Sabre Springs South OS | 0 | Local Recreation Area 3 | 4 | |
1306 | 1306 | 1305 | {"type": "Polygon", "coordinates": [[[-118.36933, 34.27138], [-118.36934, 34.27154], [-118.36933, 34.27158], [-118.36927, 34.27162], [-118.36916, 34.27167], [-118.36887, 34.27172], [-118.36875, 34.27177], [-118.36856, 34.2719], [-118.36845, 34.27199], [-118.36839, 34.27207], [-118.36834, 34.27218], [-118.36828, 34.2722], [-118.36823, 34.27225], [-118.3682, 34.27247], [-118.3682, 34.27267], [-118.36779, 34.27246], [-118.36555, 34.26923], [-118.36819, 34.269], [-118.36821, 34.26921], [-118.36828, 34.26945], [-118.36837, 34.2695], [-118.36848, 34.26953], [-118.36848, 34.26958], [-118.36851, 34.26964], [-118.36861, 34.26974], [-118.36871, 34.26981], [-118.36876, 34.26986], [-118.36881, 34.26999], [-118.36881, 34.2701], [-118.36878, 34.27038], [-118.36874, 34.27046], [-118.36868, 34.27055], [-118.36862, 34.27071], [-118.36862, 34.27081], [-118.36865, 34.27091], [-118.36873, 34.27105], [-118.3688, 34.27111], [-118.36919, 34.27127], [-118.36933, 34.27138]]]} | Open Access 1 | 7323 | Orcas Gabrieleno Equestrian Park | 30958 | 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 | 17.356 | Orcas Gabrieleno Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
1341 | 1341 | 1340 | {"type": "Polygon", "coordinates": [[[-117.26959, 34.11193], [-117.26877, 34.11194], [-117.26876, 34.11031], [-117.26959, 34.11031], [-117.26959, 34.11193]]]} | Open Access 1 | 7519 | Palm Field Park | 23337 | 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 | 3.376 | Palm Field Park | 0 | Local Recreation Area 3 | 4 | |
1346 | 1346 | 1345 | {"type": "Polygon", "coordinates": [[[-121.72032, 37.95387], [-121.72018, 37.95386], [-121.71935, 37.95216], [-121.71878, 37.95215], [-121.71868, 37.95125], [-121.71883, 37.9506], [-121.7191, 37.95044], [-121.71918, 37.95013], [-121.71908, 37.94982], [-121.71878, 37.94918], [-121.71903, 37.9487], [-121.71921, 37.9488], [-121.71925, 37.94937], [-121.71934, 37.94948], [-121.7194, 37.94965], [-121.7196, 37.94968], [-121.71959, 37.94986], [-121.71979, 37.94989], [-121.71995, 37.95087], [-121.71995, 37.95309], [-121.72015, 37.95329], [-121.72032, 37.95387]]]} | Open Access 1 | 11368 | Miwok Park and Trail | 22332 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 8.092 | Miwok Park and Trail | 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]);