units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where ACCESS_TYP = 2, DES_TP = 2 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- San Ramon, City of 13
- Los Angeles, City of 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- San Diego, City of 4
- Fullerton, City of 4
- Vacaville, City of 4
- Hollister, City of 4
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Garden Grove, City of 2
- Oceanside, City of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Sacramento, City of 2
- South El Monte, City of 2
- San Gabriel, City of 2
- Watsonville, City of 1
- Fresno, City of 1
- Santa Ana, City of 1
- …
MNG_AG_TYP 1
- City Agency · 151 ✖
DES_TP 1
- Local Park · 151 ✖
ACCESS_TYP 1
- Restricted Access · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6022 | 6022 | 6021 | {"type": "Polygon", "coordinates": [[[-118.06026, 33.87842], [-118.05959, 33.87842], [-118.05956, 33.87688], [-118.06001, 33.87688], [-118.06019, 33.87686], [-118.06024, 33.87689], [-118.06026, 33.87842]]]} | Restricted Access 2 | 729 | Frontier Park | 19131 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 2.643 | Frontier Park | 0 | Local Park 2 | 4 | |
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
6374 | 6374 | 6373 | {"type": "Polygon", "coordinates": [[[-119.77927, 36.84098], [-119.77927, 36.84288], [-119.77707, 36.84288], [-119.77708, 36.84133], [-119.77769, 36.84134], [-119.77794, 36.84127], [-119.77843, 36.84127], [-119.77869, 36.84135], [-119.77899, 36.84134], [-119.77918, 36.84111], [-119.77919, 36.84097], [-119.77927, 36.84098]]]} | Restricted Access 2 | 1738 | Harry Goorabian Park | 31253 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.566 | Harry Goorabian Park | 0 | Local Park 2 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 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 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
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 | |
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | Local Park 2 | 4 | |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship 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 |
5465 | 5465 | 5464 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | Hawthorne School District 808 | Special District 4 | School District 14 | http://www.hawthorne.k12.ca.us/ | Special District 4 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 1.201 | Zela Davis Elementary School 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 | |
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | 18441 | Pacific Beach Community Park | 33345 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.466 | Pacific Beach Community Park | 0 | Local Park 2 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 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 | 2.413 | Clay Neighborhood Park | 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 |
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]);