units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,490 rows where MNG_AG_LEV = 3 sorted by LAYER
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER
MNG_AGENCY >30
- Los Angeles, County of 175
- San Diego, County of 123
- Santa Barbara, County of 119
- Orange, County of 95
- Los Angeles - Department of Parks and Recreation, County of 65
- Lake, County of 56
- Sacramento, County of 56
- Santa Clara County Parks and Recreation Dept., County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 50
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- …
DES_TP >30
- Local Park 812
- Local Other or Unknown 221
- Local Recreation Area 158
- Local Conservation Area 117
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,324
- Restricted Access 82
- No Public Access 47
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,219
- County Agency - Parks 236
- County Agency - Other 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5408 | 5408 | 5407 | {"type": "Polygon", "coordinates": [[[-116.81981, 33.02977], [-116.8111, 33.02981], [-116.81109, 33.03475], [-116.81112, 33.03724], [-116.80247, 33.03726], [-116.80249, 33.03342], [-116.79575, 33.03337], [-116.7939, 33.03338], [-116.78948, 33.03332], [-116.7896, 33.02616], [-116.78509, 33.02618], [-116.78506, 33.0267], [-116.78495, 33.02974], [-116.78077, 33.02975], [-116.78072, 33.03206], [-116.78073, 33.03214], [-116.78051, 33.0373], [-116.77195, 33.03733], [-116.77187, 33.04415], [-116.76347, 33.04418], [-116.7635, 33.04086], [-116.76778, 33.04085], [-116.76776, 33.03734], [-116.77194, 33.03732], [-116.77212, 33.03338], [-116.77631, 33.03336], [-116.77632, 33.03302], [-116.77635, 33.03297], [-116.77634, 33.03283], [-116.77654, 33.02623], [-116.77239, 33.02624], [-116.77253, 33.02267], [-116.77191, 33.00828], [-116.77177, 33.00579], [-116.77467, 33.00636], [-116.78232, 33.01272], [-116.78474, 33.01283], [-116.78474, 33.0184], [-116.7894, 33.01824], [-116.79601, 33.0188], [-116.7999, 33.01916], [-116.79819, 33.0217], [-116.79691, 33.02514], [-116.79561, 33.02902], [-116.7956, 33.02911], [-116.80396, 33.02931], [-116.8139, 33.02775], [-116.81537, 33.0275], [-116.81616, 33.02756], [-116.81691, 33.02777], [-116.81803, 33.02843], [-116.81981, 33.02942], [-116.81981, 33.02977]]]} | Open Access 1 | 12525 | Mt. Gower Preserve | 30285 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/MtGower.html | San Diego 4 | 1522.886 | Mt. Gower Preserve | 0 | Local Conservation Area 4 | 2 |
6865 | 6865 | 6864 | {"type": "Polygon", "coordinates": [[[-116.88206, 32.9016], [-116.87735, 32.90152], [-116.87743, 32.90675], [-116.87754, 32.91269], [-116.87364, 32.91266], [-116.87363, 32.91259], [-116.86927, 32.9126], [-116.86073, 32.91264], [-116.86073, 32.91536], [-116.85906, 32.91535], [-116.85857, 32.91537], [-116.84119, 32.9155], [-116.84121, 32.91914], [-116.84126, 32.92277], [-116.83271, 32.92285], [-116.83293, 32.93288], [-116.83278, 32.93287], [-116.83277, 32.93288], [-116.83424, 32.93483], [-116.82384, 32.93501], [-116.8236, 32.92202], [-116.82359, 32.91926], [-116.8236, 32.91642], [-116.83981, 32.91648], [-116.83994, 32.90146], [-116.83993, 32.90145], [-116.82362, 32.90223], [-116.82372, 32.8874], [-116.828, 32.8874], [-116.82799, 32.89121], [-116.83615, 32.89146], [-116.84492, 32.89538], [-116.84472, 32.89861], [-116.84891, 32.89856], [-116.84889, 32.90108], [-116.8525, 32.90092], [-116.85243, 32.90479], [-116.84825, 32.9049], [-116.84828, 32.9088], [-116.85647, 32.90867], [-116.85649, 32.90782], [-116.8565, 32.90482], [-116.86949, 32.9051], [-116.86958, 32.90132], [-116.86968, 32.8984], [-116.86146, 32.89843], [-116.86208, 32.89371], [-116.87781, 32.88967], [-116.87782, 32.89258], [-116.88195, 32.89201], [-116.88202, 32.89926], [-116.88206, 32.9016]]]} | Open Access 1 | 5516 | El Capitan Preserve | 30283 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElCapitan.html | San Diego 4 | 2603.63 | El Capitan Preserve | 0 | Local Conservation Area 4 | 2 |
3601 | 3601 | 3600 | {"type": "MultiPolygon", "coordinates": [[[[-121.85226, 37.38638], [-121.8517, 37.38678], [-121.84999, 37.38813], [-121.84975, 37.38828], [-121.84945, 37.38842], [-121.84944, 37.38838], [-121.85006, 37.38798], [-121.85006, 37.38796], [-121.84987, 37.38783], [-121.85011, 37.38763], [-121.85023, 37.38778], [-121.85081, 37.38712], [-121.8512, 37.38685], [-121.85151, 37.38647], [-121.85171, 37.38635], [-121.85226, 37.38638]]], [[[-121.8717, 37.37057], [-121.87117, 37.37057], [-121.87095, 37.37043], [-121.87064, 37.37051], [-121.86992, 37.37065], [-121.86924, 37.37057], [-121.8692, 37.3705], [-121.86676, 37.37021], [-121.86657, 37.3702], [-121.86634, 37.37021], [-121.86595, 37.37028], [-121.86565, 37.37039], [-121.86544, 37.37049], [-121.86287, 37.37227], [-121.86274, 37.37237], [-121.86252, 37.3726], [-121.86243, 37.37272], [-121.86232, 37.37295], [-121.86225, 37.37319], [-121.8622, 37.37382], [-121.86203, 37.37448], [-121.86205, 37.37456], [-121.8621, 37.37463], [-121.86223, 37.3747], [-121.86221, 37.37506], [-121.86222, 37.37604], [-121.86227, 37.3762], [-121.86235, 37.37636], [-121.86312, 37.37716], [-121.86253, 37.3777], [-121.86248, 37.37771], [-121.86245, 37.37771], [-121.86128, 37.37648], [-121.86152, 37.37246], [-121.86147, 37.37241], [-121.86171, 37.37224], [-121.86176, 37.37229], [-121.86466, 37.37034], [-121.86466, 37.37032], [-121.8645, 37.37036], [-121.86575, 37.36952], [-121.86589, 37.36949], [-121.86599, 37.36949], [-121.86606, 37.3695], [-121.86615, 37.36954], [-121.86782, 37.3697], [-121.86789, 37.36974], [-121.86791, 37.36972], [-121.86851, 37.36982], [-121.86876, 37.36991], [-121.86895, 37.36995], [-121.86908, 37.37003], [-121.8692, 37.37008], [-121.8693, 37.37008], [-121.8694, 37.37001], [-121.87017, 37.37015], [-121.87028, 37.37018], [-121.87029, 37.37016], [-121.87117, 37.3698], [-121.8717, 37.37057]]]]} | Open Access 1 | 29198 | Penitencia Creek Park Chain | 23583 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 27.686 | Penitencia Creek Park Chain | None 301 | |||
3724 | 3724 | 3723 | {"type": "Polygon", "coordinates": [[[-118.20363, 36.80669], [-118.20289, 36.807], [-118.20237, 36.80627], [-118.20224, 36.80618], [-118.20303, 36.80585], [-118.20363, 36.80669]]]} | Open Access 1 | 44705 | Dehy Park | 18020 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 360 | Inyo, County of 662 | County 3 | County Agency 3 | Inyo 43 | 1.985 | Dehy Park | 0 | Local Park 2 | 4 | |
3971 | 3971 | 3970 | {"type": "Polygon", "coordinates": [[[-121.68844, 36.99391], [-121.68834, 36.99433], [-121.68829, 36.99445], [-121.6881, 36.99477], [-121.68806, 36.99491], [-121.68805, 36.99504], [-121.68808, 36.99518], [-121.68824, 36.99549], [-121.68824, 36.99564], [-121.68821, 36.99576], [-121.68799, 36.99607], [-121.68785, 36.99624], [-121.68778, 36.99632], [-121.68747, 36.99652], [-121.68723, 36.99676], [-121.68792, 36.99542], [-121.68787, 36.99477], [-121.68815, 36.99388], [-121.68844, 36.99391]]]} | Open Access 1 | 38002 | Mount Madonna County Park | 29287 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 1.998 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 0 | Local Park 2 | 4 | |
5626 | 5626 | 5625 | {"type": "Polygon", "coordinates": [[[-118.41054, 34.22709], [-118.4103, 34.22778], [-118.40776, 34.22897], [-118.40741, 34.22916], [-118.40705, 34.2294], [-118.407, 34.22941], [-118.40696, 34.22939], [-118.404, 34.22662], [-118.40712, 34.22434], [-118.40755, 34.22467], [-118.40844, 34.22521], [-118.40886, 34.2255], [-118.41022, 34.22678], [-118.41054, 34.22709]]]} | Open Access 1 | 45413 | Sheldon-Arleta Park | 28186 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.laparks.org/dos/parks/facility/devonshireArletaPk.htm | Los Angeles 6 | 45.127 | Sheldon-Arleta Park | 2016 | Local Park 2 | 4 |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
7368 | 7368 | 7367 | {"type": "Polygon", "coordinates": [[[-118.05801, 33.90814], [-118.05748, 33.90772], [-118.0555, 33.90773], [-118.05549, 33.906], [-118.05799, 33.90598], [-118.05801, 33.90814]]]} | Restricted Access 2 | 6773 | Don Knabe Golf Center and Junior Academy | 32519 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.playknabegolf.com/ | Los Angeles 6 | 11.277 | Don Knabe Golf Ctr. and Junior Academy | None 610 | ||
7371 | 7371 | 7370 | {"type": "MultiPolygon", "coordinates": [[[[-116.86639, 32.64508], [-116.85755, 32.65151], [-116.84988, 32.64452], [-116.83978, 32.6535], [-116.84011, 32.64195], [-116.84001, 32.63453], [-116.85687, 32.6339], [-116.86632, 32.63397], [-116.8663, 32.63756], [-116.86637, 32.64162], [-116.86639, 32.64508]]], [[[-116.86655, 32.61902], [-116.86648, 32.62263], [-116.85735, 32.62253], [-116.8575, 32.61887], [-116.85328, 32.61895], [-116.85341, 32.6153], [-116.85765, 32.61523], [-116.85766, 32.61522], [-116.86235, 32.61529], [-116.86229, 32.61895], [-116.86655, 32.61902]]], [[[-116.89127, 32.62103], [-116.88695, 32.62103], [-116.88698, 32.62282], [-116.88243, 32.62281], [-116.88238, 32.62103], [-116.88012, 32.62103], [-116.88014, 32.61181], [-116.88905, 32.61191], [-116.88897, 32.61919], [-116.89126, 32.61923], [-116.89127, 32.62103]]], [[[-116.89403, 32.68807], [-116.88945, 32.68809], [-116.88943, 32.68986], [-116.88507, 32.6899], [-116.88499, 32.6881], [-116.88498, 32.68628], [-116.8872, 32.68625], [-116.88718, 32.68453], [-116.894, 32.68446], [-116.89403, 32.68807]]], [[[-116.9108, 32.60449], [-116.91078, 32.61199], [-116.89349, 32.61196], [-116.8934, 32.60454], [-116.9108, 32.60449]]], [[[-116.9023, 32.67355], [-116.89805, 32.67354], [-116.89802, 32.67032], [-116.90228, 32.6703], [-116.9023, 32.67355]]], [[[-116.92781, 32.66319], [-116.91926, 32.66312], [-116.91924, 32.66405], [-116.91912, 32.66399], [-116.91867, 32.66361], [-116.91849, 32.66338], [-116.91783, 32.66291], [-116.91751, 32.66259], [-116.91698, 32.66218], [-116.91629, 32.66151], [-116.91562, 32.661], [-116.91537, 32.66092], [-116.91511, 32.66091], [-116.91485, 32.66092], [-116.91489, 32.65935], [-116.91629, 32.65938], [-116.91632, 32.65562], [-116.9278, 32.65584], [-116.92781, 32.66319]]], [[[-116.9485, 32.60875], [-116.94821, 32.60883], [-116.94815, 32.60864], [-116.94799, 32.60841], [-116.94773, 32.60837], [-116.9475, 32.6084], [-116.94739, 32.60869], [-116.94739, 32.60906], [-116.94742, 32.60929], [-116.94734, 32.60969], [-116.94734, 32.60992], [-116.94738, 32.61022], [-116.94743, 32.61044], [-116.94749, 32.61058], [-116.9478, 32.61102], [-116.94786, 32.61125], [-116.94789, 32.61154], [-116.94788, 32.61175], [-116.94781, 32.61196], [-116.9477, 32.61218], [-116.94757, 32.61233], [-116.94741, 32.61249], [-116.94719, 32.61264], [-116.94704, 32.61273], [-116.94666, 32.61303], [-116.94652, 32.61342], [-116.94644, 32.61381], [-116.94655, 32.61422], [-116.94661, 32.6148], [-116.94671, 32.61502], [-116.94664, 32.61532], [-116.94647, 32.61551], [-116.94636, 32.61556], [-116.9461, 32.61561], [-116.94598, 32.6156], [-116.94581, 32.61554], [-116.94563, 32.61541], [-116.94524, 32.61528], [-116.94507, 32.61536], [-116.9451, 32.61559], [-116.94526, 32.61583], [-116.94535, 32.61608], [-116.94537, 32.61635], [-116.94531, 32.61658], [-116.94524, 32.61655], [-116.94451, 32.61703], [-116.94436, 32.61718], [-116.94427, 32.61735], [-116.94424, 32.61754], [-116.94426, 32.61802], [-116.94422, 32.61873], [-116.94416, 32.61915], [-116.94408, 32.61957], [-116.94392, 32.62017], [-116.94323, 32.62228], [-116.94298, 32.62294], [-116.94274, 32.62345], [-116.94252, 32.62383], [-116.9422, 32.62431], [-116.94185, 32.62477], [-116.94155, 32.6251], [-116.94113, 32.62552], [-116.94067, 32.62592], [-116.94033, 32.62618], [-116.93446, 32.61192], [-116.93444, 32.61181], [-116.93431, 32.61145], [-116.9337, 32.61008], [-116.93333, 32.60918], [-116.93421, 32.60895], [-116.93327, 32.60677], [-116.93401, 32.60657], [-116.93324, 32.60469], [-116.93298, 32.60475], [-116.93164, 32.60515], [-116.92891, 32.59854], [-116.93933, 32.5955], [-116.93933, 32.59113], [-116.93937, 32.58207], [-116.94513, 32.5821], [-116.94524, 32.59383], [-116.94269, 32.59453], [-116.94534, 32.60102], [-116.94534, 32.60104], [-116.94536, 32.60105], [-116.9485, 32.60875]]], [[[-116.96532, 32.58705], [-116.96529, 32.58711], [-116.96524, 32.58746], [-116.96526, 32.5878], [-116.96532, 32.58792], [-116.96231, 32.5888], [-116.96222, 32.58619], [-116.96221, 32.58429], [-116.96433, 32.58431], [-116.96437, 32.58459], [-116.96435, 32.58468], [-116.96443, 32.58532], [-116.9643, 32.58561], [-116.96436, 32.58577], [-116.96456, 32.58587], [-116.96514, 32.58598], [-116.96514, 32.58611], [-116.96525, 32.58636], [-116.96522, 32.58656], [-116.96532, 32.58705]]], [[[-116.97937, 32.58382], [-116.96896, 32.58686], [-116.9689, 32.5868], [-116.96865, 32.58659], [-116.96838, 32.58631], [-116.96819, 32.58627], [-116.968, 32.58606], [-116.96781, 32.58604], [-116.96723, 32.58604], [-116.96664, 32.5844], [-116.96574, 32.58455], [-116.9656, 32.58432], [-116.96664, 32.58432], [-116.96664, 32.58242], [-116.97107, 32.58246], [-116.97936, 32.58251], [-116.97937, 32.58382]]], [[[-116.98618, 32.61112], [-116.98584, 32.61131], [-116.98592, 32.61153], [-116.98568, 32.61161], [-116.98543, 32.61174], [-116.98533, 32.61174], [-116.98504, 32.61199], [-116.98461, 32.61232], [-116.98453, 32.61251], [-116.98451, 32.61261], [-116.98452, 32.61225], [-116.98456, 32.61219], [-116.9847, 32.61208], [-116.9847, 32.61206], [-116.98466, 32.612], [-116.98446, 32.61187], [-116.98445, 32.61182], [-116.98446, 32.61162], [-116.98449, 32.61153], [-116.98454, 32.61144], [-116.98461, 32.61139], [-116.98463, 32.61135], [-116.98462, 32.61119], [-116.98457, 32.61095], [-116.98458, 32.61089], [-116.98461, 32.61083], [-116.98467, 32.61062], [-116.98478, 32.61049], [-116.98486, 32.61033], [-116.98489, 32.61021], [-116.98496, 32.6101], [-116.98489, 32.60999], [-116.98489, 32.60976], [-116.98502, 32.60993], [-116.98504, 32.60993], [-116.98557, 32.61058], [-116.98618, 32.61112]]], [[[-116.99061, 32.60452], [-116.99046, 32.60532], [-116.99044, 32.60553], [-116.99036, 32.60581], [-116.99001, 32.60644], [-116.98993, 32.60662], [-116.98981, 32.60704], [-116.98935, 32.60734], [-116.98925, 32.60749], [-116.98912, 32.60783], [-116.98913, 32.60813], [-116.98795, 32.60955], [-116.98722, 32.61006], [-116.98659, 32.61084], [-116.98646, 32.61097], [-116.98582, 32.61041], [-116.98531, 32.60978], [-116.98516, 32.60986], [-116.98501, 32.60967], [-116.9852, 32.60968], [-116.98536, 32.60976], [-116.98547, 32.60976], [-116.98566, 32.60973], [-116.98594, 32.60962], [-116.98608, 32.6095], [-116.98621, 32.60935], [-116.98628, 32.60932], [-116.98638, 32.60904], [-116.98655, 32.60894], [-116.98689, 32.60884], [-116.98714, 32.60871], [-116.98726, 32.60852], [-116.98723, 32.6084], [-116.98728, 32.6081], [-116.98732, 32.60803], [-116.98783, 32.60768], [-116.98802, 32.60737], [-116.98804, 32.60681], [-116.98811, 32.60674], [-116.98869, 32.60645], [-116.98882, 32.60631], [-116.98903, 32.60523], [-116.98907, 32.60495], [-116.99061, 32.60452]]]]} | No Public Access 3 | 47589 | Otay Ranch Preserve | 31316 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 3245.845 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
9944 | 9944 | 9943 | {"type": "MultiPolygon", "coordinates": [[[[-117.76222, 33.57793], [-117.76221, 33.57794], [-117.76006, 33.57795], [-117.76026, 33.57771], [-117.76114, 33.57773], [-117.76143, 33.57793], [-117.76222, 33.57793]]], [[[-117.77259, 33.55359], [-117.77256, 33.55666], [-117.77201, 33.55663], [-117.76932, 33.56064], [-117.76878, 33.56109], [-117.76727, 33.56041], [-117.7667, 33.56206], [-117.76664, 33.56205], [-117.7666, 33.56215], [-117.7658, 33.56183], [-117.76493, 33.56185], [-117.76466, 33.56149], [-117.76455, 33.56156], [-117.76453, 33.5622], [-117.76368, 33.56271], [-117.76348, 33.56293], [-117.76318, 33.56274], [-117.76278, 33.56327], [-117.76256, 33.56377], [-117.76247, 33.56426], [-117.76112, 33.5641], [-117.76072, 33.56636], [-117.76207, 33.56653], [-117.75923, 33.56645], [-117.75918, 33.56686], [-117.76061, 33.56704], [-117.76061, 33.56707], [-117.76069, 33.56713], [-117.76069, 33.56718], [-117.76067, 33.56722], [-117.76039, 33.56743], [-117.76027, 33.56759], [-117.76019, 33.56759], [-117.76035, 33.56791], [-117.76016, 33.56896], [-117.76133, 33.56911], [-117.76097, 33.56993], [-117.7611, 33.57], [-117.76118, 33.57007], [-117.7615, 33.57067], [-117.76154, 33.57078], [-117.76156, 33.5709], [-117.76155, 33.57102], [-117.76141, 33.57135], [-117.7614, 33.57142], [-117.76142, 33.57148], [-117.7615, 33.57156], [-117.76215, 33.57203], [-117.76225, 33.57214], [-117.76232, 33.57226], [-117.76235, 33.57238], [-117.76235, 33.57277], [-117.76007, 33.57278], [-117.76007, 33.57432], [-117.75934, 33.57433], [-117.7592, 33.57794], [-117.7612, 33.57802], [-117.76104, 33.57874], [-117.76203, 33.57874], [-117.76191, 33.57929], [-117.7609, 33.57931], [-117.76069, 33.58024], [-117.75555, 33.5803], [-117.75557, 33.58188], [-117.74937, 33.58194], [-117.74941, 33.5563], [-117.75694, 33.55625], [-117.75696, 33.55673], [-117.75807, 33.55671], [-117.75809, 33.55692], [-117.75932, 33.55689], [-117.75975, 33.5562], [-117.76386, 33.55613], [-117.767, 33.55632], [-117.76702, 33.555], [-117.76729, 33.555], [-117.76729, 33.55468], [-117.76928, 33.55469], [-117.76931, 33.55466], [-117.76913, 33.55443], [-117.76888, 33.55429], [-117.76859, 33.55416], [-117.76841, 33.554], [-117.76854, 33.55404], [-117.76864, 33.55404], [-117.76911, 33.55386], [-117.76921, 33.5538], [-117.76934, 33.55369], [-117.76926, 33.55357], [-117.76982, 33.5536], [-117.77029, 33.55356], [-117.77069, 33.5535], [-117.77127, 33.55354], [-117.77125, 33.55326], [-117.77142, 33.55327], [-117.77259, 33.55359]], [[-117.75922, 33.57949], [-117.75919, 33.57946], [-117.7588, 33.57963], [-117.75901, 33.57998], [-117.75941, 33.57981], [-117.75922, 33.57949]], [[-117.75533, 33.57725], [-117.75514, 33.57779], [-117.75556, 33.5779], [-117.75572, 33.57773], [-117.75573, 33.57765], [-117.75563, 33.57732], [-117.75533, 33.57725]], [[-117.75784, 33.57433], [-117.75754, 33.57433], [-117.75754, 33.57464], [-117.75784, 33.57464], [-117.75784, 33.57433]], [[-117.76033, 33.55702], [-117.76033, 33.55718], [-117.7603, 33.55734], [-117.76024, 33.55749], [-117.76015, 33.55763], [-117.76026, 33.55783], [-117.76039, 33.55798], [-117.76058, 33.55808], [-117.76073, 33.55812], [-117.76088, 33.55812], [-117.76102, 33.5581], [-117.76116, 33.55805], [-117.76128, 33.55798], [-117.76138, 33.55788], [-117.76147, 33.55771], [-117.76149, 33.55753], [-117.76143, 33.55735], [-117.76131, 33.55719], [-117.76113, 33.55708], [-117.76099, 33.55704], [-117.76084, 33.55702], [-117.76033, 33.55702]]]]} | Open Access 1 | 47960 | Aliso and Wood Canyons Wilderness Park | 8041 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/aliso | Orange 3 | 885.097 | Aliso and Wood Canyons Wilderness Park | 0 | Local Conservation Area 4 | 2 |
9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 0 | Local Park 2 | 4 |
11924 | 11924 | 11923 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | 24529 | Goose Egg Park | 19406 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.674 | Goose Egg Park | 0 | Local Park 2 | 4 | |
11927 | 11927 | 11926 | {"type": "Polygon", "coordinates": [[[-118.3351, 33.89621], [-118.33509, 33.89639], [-118.33509, 33.89752], [-118.33391, 33.89739], [-118.33393, 33.89724], [-118.33319, 33.89717], [-118.33315, 33.89718], [-118.33305, 33.89734], [-118.33158, 33.89734], [-118.33197, 33.89699], [-118.33221, 33.89672], [-118.33335, 33.89514], [-118.33409, 33.89545], [-118.33411, 33.89592], [-118.33482, 33.89592], [-118.33483, 33.8962], [-118.3351, 33.89621]]]} | Open Access 1 | 24532 | Bodger Park | 16222 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.866 | Bodger Park | 0 | Local Park 2 | 4 | |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
14043 | 14043 | 14042 | {"type": "Polygon", "coordinates": [[[-122.52894, 37.92555], [-122.5287, 37.92554], [-122.52852, 37.9251], [-122.52838, 37.92462], [-122.52834, 37.92435], [-122.52836, 37.92395], [-122.52835, 37.92375], [-122.52841, 37.9233], [-122.52841, 37.92304], [-122.52834, 37.9227], [-122.52806, 37.92203], [-122.52792, 37.92202], [-122.52785, 37.92191], [-122.52791, 37.92188], [-122.52742, 37.92065], [-122.52722, 37.92036], [-122.52676, 37.91948], [-122.52677, 37.91915], [-122.52681, 37.91931], [-122.52704, 37.91928], [-122.52728, 37.91946], [-122.52764, 37.92033], [-122.52817, 37.92153], [-122.5281, 37.92157], [-122.52821, 37.92186], [-122.52833, 37.92208], [-122.52845, 37.92237], [-122.52851, 37.92255], [-122.52861, 37.92306], [-122.52855, 37.92425], [-122.5286, 37.92467], [-122.52873, 37.92511], [-122.52882, 37.92534], [-122.52894, 37.92555]]]} | Open Access 1 | 38043 | Corte Madera Bike Path | 17658 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 4.52 | Corte Madera Bike Path | 0 | Local Recreation Area 3 | 4 | |
14860 | 14860 | 14859 | {"type": "Polygon", "coordinates": [[[-121.58753, 36.99436], [-121.58738, 36.99554], [-121.58732, 36.99577], [-121.58721, 36.996], [-121.58706, 36.99622], [-121.58583, 36.9976], [-121.58544, 36.99808], [-121.58541, 36.99807], [-121.58494, 36.99872], [-121.58458, 36.99926], [-121.58332, 36.99837], [-121.58303, 36.99813], [-121.58286, 36.99795], [-121.58272, 36.99776], [-121.58257, 36.99753], [-121.58236, 36.9971], [-121.58221, 36.99689], [-121.58205, 36.9967], [-121.58183, 36.99649], [-121.58133, 36.99607], [-121.58054, 36.99548], [-121.58128, 36.99477], [-121.58177, 36.99424], [-121.58184, 36.99425], [-121.58305, 36.99325], [-121.58319, 36.99311], [-121.58336, 36.99293], [-121.58354, 36.9927], [-121.58371, 36.99244], [-121.58384, 36.99218], [-121.58549, 36.99277], [-121.587, 36.99287], [-121.58713, 36.99346], [-121.58753, 36.99436]]]} | Open Access 1 | 45370 | Christmas Hill Park | 17228 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 68.847 | Christmas Hill Park | 0 | Local Park 2 | 4 | |
15389 | 15389 | 15388 | {"type": "Polygon", "coordinates": [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]} | Open Access 1 | 46608 | San Gabriel River Trail | 29917 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 5.002 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
16239 | 16239 | 16238 | {"type": "Polygon", "coordinates": [[[-118.43979, 34.37452], [-118.43975, 34.37721], [-118.43642, 34.3772], [-118.43641, 34.3763], [-118.4342, 34.37628], [-118.4342, 34.37538], [-118.43309, 34.37537], [-118.4331, 34.37448], [-118.43979, 34.37452]]]} | Open Access 1 | 46271 | Placerita Golden Valley Ranch Open Space | 29557 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 35.339 | Placerita Golden Valley Ranch 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]);