units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
210 rows where ACCESS_TYP = 2 and DES_TP = 2 sorted by LAYER
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Whittier, City of 19
- Los Angeles Unified School District 15
- San Ramon, City of 13
- East Bay Regional Park District 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Los Angeles, City of 5
- Beverly Hills, City of 5
- Fullerton, City of 4
- Hollister, City of 4
- Hayward Area Recreation and Park District 4
- Modesto, City of 4
- Azusa Unified School District 4
- Glendora, City of 3
- Carlsbad, City of 3
- Vacaville, City of 3
- Palmdale, City of 3
- Pasadena, City of 3
- Lawndale, City of 3
- Conejo Valley Unified School District 3
- San Diego, City of 2
- Los Angeles, County of 2
- Garden Grove, City of 2
- Oceanside, City of 2
- Orange, County of 2
- Lake Elsinore, City of 2
- Sierra Madre, City of 2
- Mountain View, City of 2
- Sacramento, City of 2
- South El Monte, City of 2
- …
MNG_AG_TYP 7
DES_TP 1
- Local Park · 190 ✖
ACCESS_TYP 1
- Restricted Access · 190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6425 | 6425 | 6424 | {"type": "Polygon", "coordinates": [[[-117.24324, 33.10452], [-117.24295, 33.10466], [-117.24254, 33.10499], [-117.2424, 33.10498], [-117.24176, 33.10484], [-117.24171, 33.10478], [-117.24165, 33.10475], [-117.24152, 33.10476], [-117.24146, 33.10481], [-117.24127, 33.10477], [-117.24119, 33.10472], [-117.24122, 33.10468], [-117.24122, 33.10467], [-117.24082, 33.10455], [-117.24083, 33.10447], [-117.24077, 33.10443], [-117.2408, 33.10434], [-117.24077, 33.10432], [-117.24092, 33.10403], [-117.24145, 33.10412], [-117.24144, 33.10416], [-117.24172, 33.10428], [-117.24255, 33.10361], [-117.24285, 33.10394], [-117.24324, 33.10452]]]} | Restricted Access 2 | 1929 | Fuerte Park | 31613 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.633 | Fuerte Park | 0 | Local Park 2 | 4 | |
6996 | 6996 | 6995 | {"type": "Polygon", "coordinates": [[[-118.38523, 33.79959], [-118.38522, 33.80151], [-118.38443, 33.80159], [-118.38352, 33.8016], [-118.38261, 33.80165], [-118.38171, 33.80173], [-118.38073, 33.80184], [-118.38, 33.80185], [-118.37929, 33.80181], [-118.37888, 33.80176], [-118.37748, 33.80149], [-118.37709, 33.80147], [-118.37577, 33.80148], [-118.37556, 33.80145], [-118.37535, 33.8014], [-118.37506, 33.80128], [-118.37444, 33.8009], [-118.37413, 33.80077], [-118.37303, 33.80049], [-118.37119, 33.80011], [-118.36992, 33.79979], [-118.36961, 33.79966], [-118.36941, 33.79953], [-118.36931, 33.79944], [-118.36912, 33.7992], [-118.369, 33.79895], [-118.36896, 33.79878], [-118.36893, 33.79857], [-118.36895, 33.7979], [-118.36894, 33.79757], [-118.36869, 33.79637], [-118.36868, 33.79617], [-118.36871, 33.796], [-118.3688, 33.79575], [-118.36887, 33.79561], [-118.36892, 33.79555], [-118.36904, 33.79543], [-118.36932, 33.7952], [-118.36951, 33.79508], [-118.36977, 33.79497], [-118.37001, 33.79492], [-118.37153, 33.7948], [-118.37173, 33.7948], [-118.37201, 33.79483], [-118.37259, 33.79493], [-118.37278, 33.79494], [-118.37624, 33.79506], [-118.37703, 33.79504], [-118.37749, 33.79499], [-118.37774, 33.79501], [-118.37787, 33.79506], [-118.37798, 33.79512], [-118.37919, 33.79616], [-118.37948, 33.79636], [-118.3797, 33.79647], [-118.37997, 33.79657], [-118.38047, 33.79666], [-118.38097, 33.79671], [-118.38202, 33.79672], [-118.38247, 33.79675], [-118.38274, 33.79678], [-118.3829, 33.79682], [-118.38303, 33.79689], [-118.38308, 33.79692], [-118.38306, 33.79708], [-118.38284, 33.79829], [-118.38282, 33.79837], [-118.38275, 33.79841], [-118.38267, 33.79852], [-118.38264, 33.79863], [-118.38265, 33.79871], [-118.3827, 33.79882], [-118.38277, 33.7989], [-118.38287, 33.79895], [-118.38304, 33.79899], [-118.38353, 33.79888], [-118.38369, 33.79888], [-118.38393, 33.79893], [-118.38413, 33.79904], [-118.38452, 33.79939], [-118.38468, 33.79951], [-118.38493, 33.79959], [-118.38514, 33.7996], [-118.38523, 33.79959]], [[-118.37105, 33.79608], [-118.37099, 33.79596], [-118.37086, 33.79601], [-118.37094, 33.79615], [-118.37105, 33.79608]], [[-118.37068, 33.79599], [-118.37087, 33.79592], [-118.37082, 33.79582], [-118.37061, 33.79587], [-118.37068, 33.79599]], [[-118.37741, 33.7953], [-118.37728, 33.79529], [-118.37722, 33.79531], [-118.37715, 33.79535], [-118.3771, 33.7954], [-118.37707, 33.79546], [-118.37706, 33.79554], [-118.37708, 33.79562], [-118.37715, 33.7957], [-118.37721, 33.79573], [-118.37731, 33.79576], [-118.37738, 33.79576], [-118.3775, 33.79572], [-118.3776, 33.79562], [-118.37762, 33.79556], [-118.37761, 33.79543], [-118.37754, 33.79535], [-118.37741, 33.7953]]]} | Restricted Access 2 | 5934 | Palos Verdes Golf Club and City Parkland | 23372 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 211.347 | Palos Verdes Golf Club and City Parkland | 0 | Local Park 2 | 4 | |
7057 | 7057 | 7056 | {"type": "Polygon", "coordinates": [[[-118.38032, 33.83008], [-118.38014, 33.83049], [-118.38004, 33.83074], [-118.37953, 33.83259], [-118.37946, 33.83264], [-118.37939, 33.83263], [-118.37864, 33.83203], [-118.37849, 33.83189], [-118.37858, 33.83155], [-118.37918, 33.82935], [-118.3792, 33.82933], [-118.37923, 33.82933], [-118.37961, 33.82944], [-118.37995, 33.82962], [-118.38006, 33.8297], [-118.37989, 33.82988], [-118.37983, 33.82998], [-118.38032, 33.83008]]]} | Restricted Access 2 | 6052 | Alta Vista Park | 31602 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org/depts/public_works/parks/altavista.asp | Los Angeles 6 | 8.546 | Alta Vista Park | 0 | Local Park 2 | 4 |
7199 | 7199 | 7198 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | 34894 | Legion Park | 21143 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.197 | Legion Park | 0 | Local Park 2 | 4 | |
7274 | 7274 | 7273 | {"type": "Polygon", "coordinates": [[[-118.03194, 33.98457], [-118.03194, 33.98501], [-118.03164, 33.98513], [-118.03164, 33.98457], [-118.03194, 33.98457]]]} | Restricted Access 2 | 6517 | Bailey Ranch House and Park | 29859 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.383 | Bailey Ranch House and Park | 0 | Local Park 2 | 4 | |
7375 | 7375 | 7374 | {"type": "MultiPolygon", "coordinates": [[[[-117.98765, 33.90292], [-117.98765, 33.90335], [-117.9876, 33.90368], [-117.98739, 33.90458], [-117.98734, 33.90462], [-117.98634, 33.90446], [-117.98612, 33.90441], [-117.9859, 33.90433], [-117.98565, 33.90419], [-117.98544, 33.904], [-117.98527, 33.9038], [-117.98524, 33.90364], [-117.98521, 33.9036], [-117.98511, 33.90356], [-117.98502, 33.9036], [-117.98488, 33.90349], [-117.98521, 33.90315], [-117.9855, 33.90276], [-117.98687, 33.90275], [-117.98688, 33.90286], [-117.98757, 33.90286], [-117.98762, 33.90288], [-117.98765, 33.90292]]], [[[-117.98975, 33.90265], [-117.9879, 33.90266], [-117.98554, 33.90268], [-117.98574, 33.90226], [-117.98587, 33.90182], [-117.98592, 33.90143], [-117.98593, 33.90094], [-117.98973, 33.90093], [-117.98975, 33.90265]]]]} | Restricted Access 2 | 6769 | Behringer Park | 29779 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 26.715 | Behringer Park | 0 | Local Park 2 | 4 | |
7504 | 7504 | 7503 | {"type": "MultiPolygon", "coordinates": [[[[-117.86421, 34.11739], [-117.86389, 34.11734], [-117.86388, 34.11715], [-117.8639, 34.11707], [-117.86404, 34.11685], [-117.86421, 34.11739]]], [[[-117.86747, 34.11601], [-117.86702, 34.11747], [-117.86454, 34.11747], [-117.8645, 34.11742], [-117.86414, 34.11629], [-117.86409, 34.11607], [-117.86563, 34.11606], [-117.86563, 34.11468], [-117.86708, 34.11467], [-117.86708, 34.11404], [-117.86746, 34.11404], [-117.86747, 34.11601]]]]} | Restricted Access 2 | 7039 | Glenoaks Golf Course and Park | 32648 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.cityofglendora.org/departments-services/parks-recreation-senior-services/glen-oaks-golf-course | Los Angeles 6 | 17.737 | Glenoaks GC and Park | 0 | Local Park 2 | 4 |
9066 | 9066 | 9065 | {"type": "MultiPolygon", "coordinates": [[[[-117.36226, 33.19259], [-117.3624, 33.19418], [-117.36239, 33.19436], [-117.36236, 33.1945], [-117.36229, 33.19468], [-117.36217, 33.19484], [-117.36184, 33.19519], [-117.36174, 33.19536], [-117.36168, 33.19556], [-117.36166, 33.19568], [-117.36167, 33.19787], [-117.35722, 33.19787], [-117.35719, 33.19485], [-117.3578, 33.1945], [-117.35787, 33.19463], [-117.35788, 33.19477], [-117.35789, 33.19478], [-117.35989, 33.1938], [-117.35892, 33.19244], [-117.35886, 33.1924], [-117.35923, 33.19222], [-117.36, 33.1934], [-117.36139, 33.19286], [-117.36187, 33.1922], [-117.36216, 33.19256], [-117.36226, 33.19259]]], [[[-117.36694, 33.19659], [-117.36651, 33.19688], [-117.36621, 33.19699], [-117.36599, 33.19702], [-117.3651, 33.19703], [-117.36509, 33.19795], [-117.36187, 33.19796], [-117.36185, 33.1957], [-117.36187, 33.19558], [-117.36191, 33.19546], [-117.36199, 33.19529], [-117.36232, 33.19494], [-117.36246, 33.19475], [-117.36253, 33.19461], [-117.36259, 33.19439], [-117.3626, 33.19418], [-117.36246, 33.19267], [-117.3633, 33.19295], [-117.36402, 33.19299], [-117.36569, 33.19499], [-117.36694, 33.19659]]]]} | Restricted Access 2 | 15007 | Goat Hill Park | 29108 | 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.goathillpark.com/ | San Diego 4 | 94.712 | Goat Hill Park | 0 | Local Park 2 | 4 |
9733 | 9733 | 9732 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36062], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33774], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.3488], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.1992, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} | Restricted Access 2 | 16498 | Foothills Park | 18984 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1303.372 | Foothills Park | 2000 | Local Park 2 | 4 | |
9833 | 9833 | 9832 | {"type": "MultiPolygon", "coordinates": [[[[-121.90925, 37.34333], [-121.90916, 37.3434], [-121.90913, 37.34339], [-121.90887, 37.3436], [-121.90847, 37.34388], [-121.9075, 37.34298], [-121.90857, 37.34223], [-121.90949, 37.34309], [-121.90948, 37.34314], [-121.90925, 37.34331], [-121.90925, 37.34333]]], [[[-121.9128, 37.35228], [-121.91234, 37.35264], [-121.91191, 37.3534], [-121.9114, 37.35387], [-121.91081, 37.35295], [-121.90954, 37.35053], [-121.90947, 37.35042], [-121.91082, 37.34945], [-121.91086, 37.34946], [-121.91123, 37.34978], [-121.91112, 37.34984], [-121.91122, 37.34994], [-121.91167, 37.3509], [-121.91219, 37.35054], [-121.91252, 37.35098], [-121.91199, 37.35129], [-121.91255, 37.35174], [-121.9128, 37.35228]]]]} | Restricted Access 2 | 16812 | Guadalupe Gardens | 19544 | 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 | 21.614 | Guadalupe Gardens | 0 | Local Park 2 | 4 | |
10693 | 10693 | 10692 | {"type": "Polygon", "coordinates": [[[-117.04937, 33.13247], [-117.04883, 33.13273], [-117.0484, 33.13207], [-117.04842, 33.13205], [-117.04818, 33.13167], [-117.04871, 33.13143], [-117.04937, 33.13247]]]} | Restricted Access 2 | 19848 | Oak Hill City Park | 31522 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.876 | Oak Hill City Park | 0 | Local Park 2 | 4 | |
11515 | 11515 | 11514 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | 48221 | Martin Luther King Jr. Park | 32772 | 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.547 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
12284 | 12284 | 12283 | {"type": "Polygon", "coordinates": [[[-118.53366, 34.03505], [-118.5333, 34.0359], [-118.53307, 34.0362], [-118.53297, 34.03611], [-118.5328, 34.0361], [-118.53282, 34.036], [-118.53279, 34.03592], [-118.53275, 34.03587], [-118.53261, 34.03578], [-118.53232, 34.03565], [-118.53202, 34.03557], [-118.53186, 34.03554], [-118.53161, 34.03554], [-118.53137, 34.03557], [-118.53079, 34.03574], [-118.53049, 34.03581], [-118.53031, 34.03583], [-118.52994, 34.03584], [-118.52955, 34.0358], [-118.52938, 34.03577], [-118.52913, 34.0357], [-118.52881, 34.03558], [-118.52863, 34.03548], [-118.52845, 34.03537], [-118.52837, 34.03533], [-118.52812, 34.03498], [-118.52804, 34.03454], [-118.52803, 34.03408], [-118.52811, 34.03394], [-118.52793, 34.03354], [-118.52755, 34.03327], [-118.52702, 34.03309], [-118.52664, 34.03355], [-118.52628, 34.03352], [-118.52621, 34.03414], [-118.52671, 34.03416], [-118.52669, 34.03442], [-118.52672, 34.03507], [-118.5268, 34.03551], [-118.52684, 34.03567], [-118.52638, 34.03577], [-118.52637, 34.0358], [-118.52644, 34.03597], [-118.52653, 34.03613], [-118.52676, 34.03645], [-118.5267, 34.03653], [-118.52656, 34.0365], [-118.52642, 34.03631], [-118.52627, 34.03618], [-118.52608, 34.03607], [-118.52593, 34.036], [-118.52578, 34.03596], [-118.52557, 34.03594], [-118.52538, 34.03594], [-118.52528, 34.03596], [-118.52539, 34.03581], [-118.52527, 34.03562], [-118.52498, 34.03597], [-118.52501, 34.03602], [-118.52476, 34.03616], [-118.52463, 34.03626], [-118.52454, 34.03636], [-118.52441, 34.03656], [-118.52436, 34.03671], [-118.52434, 34.03683], [-118.52434, 34.03702], [-118.52438, 34.03721], [-118.52449, 34.03748], [-118.52596, 34.03959], [-118.52609, 34.03975], [-118.52628, 34.03994], [-118.52668, 34.04025], [-118.527, 34.04042], [-118.52706, 34.04049], [-118.52704, 34.04085], [-118.52694, 34.04149], [-118.52664, 34.04146], [-118.5264, 34.0416], [-118.52632, 34.04182], [-118.52584, 34.04176], [-118.52603, 34.04073], [-118.52589, 34.04059], [-118.52501, 34.04047], [-118.52447, 34.03997], [-118.52465, 34.03924], [-118.52323, 34.03721], [-118.52313, 34.03653], [-118.52336, 34.0359], [-118.52367, 34.03554], [-118.52419, 34.03514], [-118.52423, 34.03517], [-118.52427, 34.03515], [-118.52484, 34.03422], [-118.52484, 34.03421], [-118.52478, 34.03419], [-118.52574, 34.03263], [-118.5256, 34.03206], [-118.52621, 34.03192], [-118.52648, 34.03206], [-118.52849, 34.03324], [-118.52951, 34.03374], [-118.52992, 34.03392], [-118.53077, 34.03423], [-118.53142, 34.03444], [-118.53366, 34.03505]]]} | Restricted Access 2 | 25935 | Potrero Canyon Park | 28872 | 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 | 59.924 | Potrero Canyon Park | 0 | Local Park 2 | 4 | |
12476 | 12476 | 12475 | {"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]} | Restricted Access 2 | 28306 | Alamo School Park | 31601 | 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 | 4.025 | Alamo School Park | 0 | Local Park 2 | 4 | |
12494 | 12494 | 12493 | {"type": "Polygon", "coordinates": [[[-121.95197, 38.33224], [-121.9516, 38.33235], [-121.95152, 38.33221], [-121.95135, 38.33224], [-121.95129, 38.33217], [-121.95113, 38.33221], [-121.95058, 38.3326], [-121.95066, 38.33278], [-121.95007, 38.33302], [-121.95032, 38.33339], [-121.94992, 38.33336], [-121.94998, 38.33173], [-121.9501, 38.33154], [-121.95021, 38.33142], [-121.95046, 38.33125], [-121.95048, 38.33103], [-121.95196, 38.331], [-121.95197, 38.33224]]]} | Restricted Access 2 | 28307 | Cambridge School Park | 31605 | 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 | 6.902 | Cambridge School Park | 0 | Local Park 2 | 4 | |
12497 | 12497 | 12496 | {"type": "Polygon", "coordinates": [[[-122.0039, 38.3646], [-122.00387, 38.36624], [-122.00154, 38.3662], [-122.00153, 38.36566], [-122.00163, 38.36566], [-122.00165, 38.36592], [-122.00216, 38.36593], [-122.00217, 38.36567], [-122.00267, 38.36566], [-122.00267, 38.36535], [-122.00318, 38.36535], [-122.00318, 38.36517], [-122.00274, 38.36462], [-122.00284, 38.36458], [-122.0039, 38.3646]]]} | Restricted Access 2 | 28311 | Hemlock School Park | 31596 | 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 | 5.323 | Hemlock School Park | 0 | Local Park 2 | 4 | |
12857 | 12857 | 12856 | {"type": "Polygon", "coordinates": [[[-117.92663, 33.9084], [-117.92635, 33.90978], [-117.92622, 33.90981], [-117.92598, 33.90991], [-117.92543, 33.90885], [-117.92549, 33.90833], [-117.92663, 33.9084]]]} | Restricted Access 2 | 30308 | Hermosa School Park | 31593 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.279 | Hermosa School Park | 0 | Local Park 2 | 4 | |
12868 | 12868 | 12867 | {"type": "Polygon", "coordinates": [[[-117.93319, 33.89474], [-117.93316, 33.89535], [-117.93309, 33.89568], [-117.93278, 33.89561], [-117.93269, 33.8958], [-117.93199, 33.89562], [-117.93177, 33.89614], [-117.93144, 33.89605], [-117.93131, 33.89545], [-117.93168, 33.89521], [-117.93261, 33.89468], [-117.93285, 33.89466], [-117.93289, 33.89473], [-117.93319, 33.89474]]]} | Restricted Access 2 | 30311 | Laguna Road School Park | 31597 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.908 | Laguna Road School Park | 0 | Local Park 2 | 4 | |
12890 | 12890 | 12889 | {"type": "Polygon", "coordinates": [[[-117.97433, 33.78835], [-117.97248, 33.78836], [-117.97246, 33.7879], [-117.97181, 33.78791], [-117.97177, 33.78617], [-117.9738, 33.78616], [-117.97382, 33.78667], [-117.9743, 33.78667], [-117.97433, 33.78835]]]} | Restricted Access 2 | 30348 | Hare School Park | 31617 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 12.599 | Hare School Park | 0 | Local Park 2 | 4 | |
12981 | 12981 | 12980 | {"type": "Polygon", "coordinates": [[[-117.9457, 33.79772], [-117.94256, 33.79772], [-117.9419, 33.79773], [-117.94149, 33.79777], [-117.94147, 33.79608], [-117.94155, 33.79602], [-117.94358, 33.79601], [-117.94358, 33.79701], [-117.94321, 33.79702], [-117.94321, 33.79736], [-117.94383, 33.79737], [-117.94384, 33.79745], [-117.94411, 33.79744], [-117.94411, 33.79725], [-117.94417, 33.79724], [-117.94417, 33.79719], [-117.94431, 33.79719], [-117.94432, 33.79717], [-117.94461, 33.79718], [-117.94462, 33.79709], [-117.94526, 33.79709], [-117.94527, 33.79698], [-117.94568, 33.79699], [-117.9457, 33.79772]]]} | Restricted Access 2 | 30455 | Lake School Park | 31620 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 11.739 | Lake School Park | 0 | Local Park 2 | 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]);