units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 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
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4782 | 4782 | 4781 | {"type": "MultiPolygon", "coordinates": [[[[-118.31523, 34.27262], [-118.31155, 34.27525], [-118.31209, 34.27614], [-118.31019, 34.27715], [-118.31018, 34.27759], [-118.30864, 34.278], [-118.30827, 34.27922], [-118.30683, 34.28], [-118.30504, 34.28028], [-118.30418, 34.27659], [-118.3067, 34.27613], [-118.30776, 34.27606], [-118.30797, 34.27532], [-118.30739, 34.27455], [-118.3079, 34.27436], [-118.30845, 34.27422], [-118.30878, 34.27411], [-118.30893, 34.27404], [-118.30921, 34.27384], [-118.30958, 34.27409], [-118.31025, 34.27505], [-118.31221, 34.27344], [-118.31465, 34.27267], [-118.31408, 34.27288], [-118.31389, 34.27298], [-118.31396, 34.27307], [-118.31454, 34.27284], [-118.31523, 34.27262]], [[-118.30988, 34.27535], [-118.30988, 34.27534], [-118.30953, 34.27504], [-118.30924, 34.27461], [-118.30928, 34.27454], [-118.30927, 34.27453], [-118.30885, 34.27447], [-118.3087, 34.27429], [-118.30803, 34.27437], [-118.30782, 34.27443], [-118.30784, 34.27447], [-118.30799, 34.27441], [-118.3086, 34.27434], [-118.30861, 34.27438], [-118.30817, 34.27444], [-118.30816, 34.27446], [-118.30908, 34.27567], [-118.30988, 34.27535]]], [[[-118.31018, 34.27763], [-118.31014, 34.27952], [-118.30543, 34.28199], [-118.30505, 34.28031], [-118.30684, 34.28003], [-118.30831, 34.27923], [-118.30868, 34.27803], [-118.31018, 34.27763]]], [[[-118.31695, 34.27216], [-118.31632, 34.27264], [-118.31581, 34.27301], [-118.3158, 34.27253], [-118.31583, 34.27253], [-118.31587, 34.27248], [-118.31656, 34.27226], [-118.31695, 34.27216]]]]} | Restricted Access 2 | 47252 | Unnamed site - Los Angeles, City of | 30961 | 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 | 88.776 | 0 | Local Other or Unknown 14 | 4 | ||
4793 | 4793 | 4792 | {"type": "MultiPolygon", "coordinates": [[[[-121.29204, 38.27768], [-121.29158, 38.27785], [-121.29136, 38.27788], [-121.29122, 38.27786], [-121.29102, 38.27778], [-121.29092, 38.27771], [-121.29083, 38.27761], [-121.29072, 38.27737], [-121.29065, 38.27731], [-121.29057, 38.27728], [-121.29048, 38.27726], [-121.29034, 38.27729], [-121.29026, 38.27734], [-121.2902, 38.27744], [-121.29019, 38.27802], [-121.29016, 38.27812], [-121.2901, 38.27821], [-121.28997, 38.27832], [-121.28986, 38.27837], [-121.28977, 38.27838], [-121.28944, 38.27834], [-121.28902, 38.27938], [-121.28899, 38.27942], [-121.28886, 38.27952], [-121.28876, 38.27956], [-121.28864, 38.27957], [-121.28848, 38.27966], [-121.28881, 38.28013], [-121.28882, 38.28017], [-121.28881, 38.2802], [-121.28838, 38.28045], [-121.28808, 38.28066], [-121.28721, 38.28136], [-121.28673, 38.28166], [-121.28621, 38.28191], [-121.28512, 38.28234], [-121.28459, 38.28251], [-121.28411, 38.28262], [-121.28339, 38.28269], [-121.28279, 38.28271], [-121.28274, 38.2827], [-121.28271, 38.28266], [-121.28269, 38.28233], [-121.28313, 38.28232], [-121.28319, 38.28229], [-121.28327, 38.28233], [-121.28337, 38.28234], [-121.28349, 38.28231], [-121.28387, 38.28225], [-121.28423, 38.28218], [-121.28475, 38.28203], [-121.28583, 38.28161], [-121.28631, 38.28139], [-121.28676, 38.28112], [-121.28698, 38.28096], [-121.28717, 38.28078], [-121.28725, 38.28073], [-121.2873, 38.28066], [-121.2873, 38.2806], [-121.28728, 38.28055], [-121.28734, 38.28052], [-121.2876, 38.2799], [-121.28755, 38.27979], [-121.28758, 38.27975], [-121.28758, 38.2797], [-121.28771, 38.27969], [-121.28792, 38.27918], [-121.28802, 38.27903], [-121.28816, 38.2787], [-121.28869, 38.27764], [-121.28882, 38.27746], [-121.28898, 38.27728], [-121.28916, 38.27713], [-121.28948, 38.27693], [-121.28976, 38.27682], [-121.29042, 38.2766], [-121.29066, 38.27659], [-121.2909, 38.27663], [-121.29111, 38.27672], [-121.29122, 38.27681], [-121.29131, 38.2769], [-121.29135, 38.27695], [-121.29127, 38.27699], [-121.29147, 38.27745], [-121.29155, 38.27749], [-121.29169, 38.27751], [-121.29178, 38.2775], [-121.2919, 38.27744], [-121.29204, 38.27768]]], [[[-121.30035, 38.27651], [-121.30032, 38.27682], [-121.30028, 38.277], [-121.3002, 38.27717], [-121.29942, 38.27706], [-121.2968, 38.27706], [-121.29631, 38.27711], [-121.29594, 38.27721], [-121.29553, 38.27735], [-121.29535, 38.27739], [-121.29517, 38.27739], [-121.29498, 38.27738], [-121.29385, 38.27719], [-121.29363, 38.27718], [-121.29348, 38.2772], [-121.29334, 38.27725], [-121.29323, 38.27732], [-121.29301, 38.2775], [-121.29284, 38.27761], [-121.29264, 38.2777], [-121.29243, 38.27777], [-121.29213, 38.27722], [-121.29247, 38.27708], [-121.29274, 38.27684], [-121.29348, 38.27665], [-121.29354, 38.27669], [-121.29365, 38.2767], [-121.29379, 38.27663], [-121.29424, 38.27653], [-121.29443, 38.27653], [-121.29453, 38.27646], [-121.29458, 38.27648], [-121.29523, 38.27628], [-121.29553, 38.27621], [-121.29583, 38.27618], [-121.2963, 38.27617], [-121.29753, 38.27624], [-121.29758, 38.2763], [-121.29766, 38.27632], [-121.29784, 38.2763], [-121.29934, 38.27638], [-121.29947, 38.27642], [-121.29958, 38.2764], [-121.29964, 38.27635], [-121.30035, 38.27651]]], [[[-121.30096, 38.27735], [-121.30038, 38.27726], [-121.30051, 38.27695], [-121.30056, 38.27663], [-121.30091, 38.27661], [-121.30095, 38.27685], [-121.30096, 38.27735]]]]} | Restricted Access 2 | 48279 | Unnamed Site - Galt, City of | 32849 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 35.606 | 0 | Local Other or Unknown 14 | 4 | ||
5686 | 5686 | 5685 | {"type": "MultiPolygon", "coordinates": [[[[-118.3146, 34.27718], [-118.31015, 34.27952], [-118.31012, 34.28089], [-118.30824, 34.28088], [-118.30823, 34.28248], [-118.29952, 34.28253], [-118.29956, 34.27885], [-118.29706, 34.27885], [-118.29722, 34.27856], [-118.29724, 34.27849], [-118.29738, 34.2783], [-118.29747, 34.27821], [-118.29783, 34.27791], [-118.29786, 34.27793], [-118.29789, 34.27792], [-118.29821, 34.27767], [-118.29855, 34.27746], [-118.30008, 34.27668], [-118.3003, 34.2766], [-118.30082, 34.27644], [-118.30124, 34.27638], [-118.30148, 34.27636], [-118.30179, 34.27635], [-118.30215, 34.27638], [-118.30253, 34.27644], [-118.30288, 34.27652], [-118.30345, 34.27671], [-118.30377, 34.27657], [-118.30377, 34.27655], [-118.30284, 34.27626], [-118.30232, 34.27616], [-118.30186, 34.27612], [-118.30133, 34.27613], [-118.30082, 34.2762], [-118.30049, 34.27628], [-118.3001, 34.27642], [-118.29959, 34.27575], [-118.29954, 34.27574], [-118.29962, 34.27549], [-118.29968, 34.27539], [-118.29981, 34.27528], [-118.3, 34.27521], [-118.30057, 34.27519], [-118.30046, 34.27535], [-118.30057, 34.27547], [-118.3008, 34.2755], [-118.3011, 34.27538], [-118.30106, 34.27524], [-118.30099, 34.27511], [-118.30108, 34.27507], [-118.3012, 34.27498], [-118.30129, 34.27487], [-118.30137, 34.27475], [-118.30153, 34.27463], [-118.30177, 34.27453], [-118.30201, 34.27451], [-118.30222, 34.27422], [-118.30235, 34.27419], [-118.30258, 34.27423], [-118.30327, 34.27406], [-118.30329, 34.27402], [-118.30407, 34.27408], [-118.30494, 34.27453], [-118.30407, 34.27497], [-118.30424, 34.27605], [-118.30424, 34.27608], [-118.30407, 34.27612], [-118.30544, 34.28198], [-118.31014, 34.27952], [-118.31018, 34.27715], [-118.31201, 34.27618], [-118.3146, 34.27718]]], [[[-118.29958, 34.27524], [-118.29947, 34.27538], [-118.2994, 34.27551], [-118.29898, 34.27524], [-118.29958, 34.27524]]], [[[-118.30022, 34.27503], [-118.29996, 34.27505], [-118.29981, 34.2751], [-118.29971, 34.27515], [-118.29971, 34.27511], [-118.30005, 34.27499], [-118.30022, 34.27503]]]]} | Restricted Access 2 | 47237 | Unnamed site - Los Angeles - Department of Water and Power, City of | 30960 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 138.829 | 0 | Local Other or Unknown 14 | 4 | ||
14393 | 14393 | 14392 | {"type": "MultiPolygon", "coordinates": [[[[-119.25231, 35.30226], [-119.25231, 35.30309], [-119.25223, 35.3031], [-119.25222, 35.30377], [-119.25231, 35.30378], [-119.2523, 35.30706], [-119.24691, 35.30706], [-119.24689, 35.31068], [-119.24357, 35.31069], [-119.24355, 35.31431], [-119.23467, 35.3143], [-119.23463, 35.31794], [-119.23106, 35.31795], [-119.23105, 35.31986], [-119.21949, 35.32], [-119.21947, 35.32536], [-119.21637, 35.3254], [-119.21635, 35.32721], [-119.21203, 35.32721], [-119.21196, 35.33231], [-119.21237, 35.33267], [-119.19869, 35.33266], [-119.19417, 35.33263], [-119.19407, 35.33993], [-119.18531, 35.33985], [-119.18533, 35.34355], [-119.1809, 35.34352], [-119.18092, 35.34642], [-119.17282, 35.34638], [-119.17282, 35.34627], [-119.17216, 35.3462], [-119.17025, 35.34618], [-119.16994, 35.3462], [-119.16942, 35.34631], [-119.16922, 35.34633], [-119.16921, 35.34661], [-119.16335, 35.34659], [-119.16335, 35.34614], [-119.16316, 35.34614], [-119.16314, 35.34659], [-119.1549, 35.34666], [-119.15433, 35.34673], [-119.15381, 35.34673], [-119.1538, 35.34675], [-119.14748, 35.3468], [-119.14747, 35.34678], [-119.14733, 35.34678], [-119.14702, 35.34685], [-119.14677, 35.34695], [-119.14658, 35.34707], [-119.14631, 35.34729], [-119.14553, 35.3473], [-119.14553, 35.34797], [-119.145, 35.34843], [-119.14497, 35.34841], [-119.14437, 35.34892], [-119.14412, 35.34909], [-119.1438, 35.34925], [-119.14342, 35.34939], [-119.14313, 35.34947], [-119.14132, 35.34975], [-119.14085, 35.34986], [-119.14051, 35.34998], [-119.13735, 35.3512], [-119.13734, 35.35119], [-119.13699, 35.3513], [-119.1356, 35.35161], [-119.13549, 35.35161], [-119.13497, 35.3515], [-119.13484, 35.35151], [-119.133, 35.35189], [-119.13144, 35.35085], [-119.13213, 35.35018], [-119.13545, 35.34873], [-119.1366, 35.34848], [-119.13659, 35.34756], [-119.13714, 35.3473], [-119.14146, 35.34564], [-119.14337, 35.34493], [-119.14412, 35.34462], [-119.14552, 35.34446], [-119.14552, 35.3456], [-119.14554, 35.34561], [-119.14565, 35.34507], [-119.15013, 35.34469], [-119.15125, 35.34468], [-119.15439, 35.3431], [-119.16039, 35.34305], [-119.16326, 35.34385], [-119.16327, 35.34414], [-119.16498, 35.34432], [-119.16768, 35.34402], [-119.16837, 35.34364], [-119.16913, 35.34254], [-119.16938, 35.34184], [-119.1713, 35.33983], [-119.17208, 35.33982], [-119.17212, 35.33618], [-119.17652, 35.33617], [-119.17656, 35.33253], [-119.18096, 35.33252], [-119.18107, 35.32415], [-119.18682, 35.32194], [-119.18726, 35.32181], [-119.197, 35.32044], [-119.19726, 35.32038], [-119.19748, 35.32027], [-119.19882, 35.32142], [-119.20352, 35.32537], [-119.20396, 35.32537], [-119.20396, 35.32535], [-119.19775, 35.32011], [-119.21331, 35.31076], [-119.21743, 35.30838], [-119.21775, 35.30826], [-119.21817, 35.30814], [-119.21859, 35.30805], [-119.21893, 35.30799], [-119.23869, 35.30597], [-119.2387, 35.30596], [-119.23866, 35.3057], [-119.24602, 35.30491], [-119.24784, 35.30307], [-119.25231, 35.30226]]], [[[-119.26408, 35.30353], [-119.25461, 35.30346], [-119.25393, 35.30397], [-119.25258, 35.30426], [-119.25258, 35.30378], [-119.25266, 35.30377], [-119.25266, 35.30311], [-119.25258, 35.30309], [-119.25258, 35.30216], [-119.25321, 35.30159], [-119.25464, 35.30088], [-119.25577, 35.30059], [-119.25736, 35.30052], [-119.25921, 35.30106], [-119.26113, 35.30122], [-119.26408, 35.30353]]]]} | Restricted Access 2 | 44492 | 2800 Acre Water Bank | 15189 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 3053.963 | 2800 Acre Water Bank | None 1220 | |||
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 | |
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
12253 | 12253 | 12252 | {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20166, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.2012, 34.07523], [-118.20091, 34.07524], [-118.2009, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20177, 34.07498], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} | Restricted Access 2 | 46874 | Abraham Lincoln High School Park | 31843 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.467 | Abraham Lincoln High School Park | 0 | Local Park 2 | 4 | |
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
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 | |
8257 | 8257 | 8256 | {"type": "Polygon", "coordinates": [[[-118.11967, 34.09049], [-118.11966, 34.09074], [-118.11234, 34.09388], [-118.10973, 34.0882], [-118.10992, 34.08814], [-118.10934, 34.08688], [-118.1091, 34.08626], [-118.10941, 34.08615], [-118.10899, 34.08523], [-118.10881, 34.08475], [-118.11269, 34.08456], [-118.11268, 34.08483], [-118.11269, 34.0859], [-118.11273, 34.08679], [-118.11276, 34.08697], [-118.11298, 34.08739], [-118.1137, 34.08774], [-118.11393, 34.08771], [-118.11418, 34.08766], [-118.11449, 34.08765], [-118.11449, 34.08813], [-118.11461, 34.08814], [-118.11486, 34.08831], [-118.11491, 34.08836], [-118.11491, 34.08858], [-118.11575, 34.08939], [-118.11563, 34.08939], [-118.11563, 34.0896], [-118.11567, 34.08964], [-118.1157, 34.08965], [-118.11577, 34.08965], [-118.11578, 34.08941], [-118.11591, 34.08929], [-118.11685, 34.08929], [-118.11686, 34.09051], [-118.11967, 34.09049]]]} | Restricted Access 2 | 45406 | Alhambra Municipal Golf Course | 33112 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | http://alhambragolf.com/ag/ | Los Angeles 6 | 107.021 | Alhambra Municipal GC | 0 | Local Recreation Area 3 | 4 |
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 |
11272 | 11272 | 11271 | {"type": "Polygon", "coordinates": [[[-122.28368, 38.18088], [-122.28209, 38.18427], [-122.278, 38.18424], [-122.27658, 38.18424], [-122.27681, 38.18329], [-122.2768, 38.18328], [-122.27228, 38.18322], [-122.27177, 38.1811], [-122.27824, 38.18104], [-122.28368, 38.18088]]]} | Restricted Access 2 | 21765 | American Canyon Property | 15449 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 72.744 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
3324 | 3324 | 3323 | {"type": "Polygon", "coordinates": [[[-122.27889, 38.17188], [-122.27858, 38.17195], [-122.27857, 38.17572], [-122.27872, 38.17877], [-122.27823, 38.18104], [-122.27177, 38.1811], [-122.27109, 38.17691], [-122.27079, 38.17569], [-122.27055, 38.1742], [-122.27069, 38.17415], [-122.27064, 38.17387], [-122.27063, 38.17387], [-122.27051, 38.17391], [-122.27043, 38.17342], [-122.26936, 38.17213], [-122.26887, 38.17121], [-122.26869, 38.17053], [-122.26892, 38.16862], [-122.26885, 38.16712], [-122.26865, 38.16622], [-122.2668, 38.16148], [-122.27865, 38.16144], [-122.27884, 38.17091], [-122.27889, 38.17188]], [[-122.27213, 38.16617], [-122.27245, 38.16694], [-122.27835, 38.16698], [-122.27832, 38.16431], [-122.27137, 38.16431], [-122.26809, 38.16423], [-122.26881, 38.16606], [-122.27213, 38.16617]]]} | Restricted Access 2 | 23605 | American Canyon/Fish and Game | 15450 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 375.475 | American Canyon/Fish and Game | 0 | None 271 | ||
4439 | 4439 | 4438 | {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03498, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.12981], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} | Restricted Access 2 | 46490 | Arcadia High School Park | 31846 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://ahs.ausd.net/ | Los Angeles 6 | 13.815 | Arcadia High School Park | 0 | Local Park 2 | 4 |
15669 | 15669 | 15668 | {"type": "MultiPolygon", "coordinates": [[[[-118.02002, 34.10015], [-118.01922, 34.10279], [-118.01789, 34.10253], [-118.0166, 34.10528], [-118.01621, 34.10549], [-118.01575, 34.10339], [-118.01574, 34.10313], [-118.01578, 34.1029], [-118.0159, 34.10259], [-118.01597, 34.10246], [-118.01711, 34.10129], [-118.01857, 34.10015], [-118.01908, 34.09991], [-118.02002, 34.10015]]], [[[-118.01617, 34.10551], [-118.01607, 34.10557], [-118.01603, 34.10544], [-118.01577, 34.10423], [-118.01587, 34.10418], [-118.01617, 34.10551]]]]} | Restricted Access 2 | 7036 | Arcadia Par-3 Golf Course | 33024 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | Los Angeles 6 | 25.879 | Arcadia Par-3 GC | 0 | Local Recreation Area 3 | 4 | |
7233 | 7233 | 7232 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17064, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11715], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.16631, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | 6930 | Arroyo Seco Golf Course | 29411 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.arroyosecogolf.com/Home.html | Los Angeles 6 | 31.16 | Arroyo Seco GC | 0 | Local Recreation Area 3 | 4 |
15196 | 15196 | 15195 | {"type": "Polygon", "coordinates": [[[-118.17123, 34.11541], [-118.16918, 34.11752], [-118.16899, 34.11733], [-118.16859, 34.11755], [-118.16857, 34.11757], [-118.16862, 34.11762], [-118.16806, 34.11775], [-118.168, 34.11744], [-118.16778, 34.11722], [-118.1684, 34.11659], [-118.1687, 34.11633], [-118.16957, 34.11604], [-118.1699, 34.11588], [-118.17023, 34.11568], [-118.17064, 34.11524], [-118.17123, 34.11541]]]} | Restricted Access 2 | 46069 | Arroyo Seco Racquet Center | 29412 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/index.aspx?page=66 | Los Angeles 6 | 7.411 | Arroyo Seco Racquet Ctr. | 0 | Local Recreation Area 3 | 4 |
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle 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 | |
15324 | 15324 | 15323 | {"type": "Polygon", "coordinates": [[[-118.04812, 34.11743], [-118.0462, 34.11746], [-118.04619, 34.11714], [-118.04576, 34.11714], [-118.04575, 34.11667], [-118.04763, 34.11665], [-118.04764, 34.11711], [-118.04812, 34.11711], [-118.04812, 34.11743]]]} | Restricted Access 2 | 46488 | Baldwin Stocker Elementary School Park | 31847 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://bs.ausd.net/ | Los Angeles 6 | 3.796 | Baldwin Stocker Elementary 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]);