units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
260 rows where ACCESS_TYP = 2 and AGNCY_LEV = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 17
- Long Beach, City of 9
- San Diego, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Fullerton, City of 5
- Vacaville, City of 5
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- Watsonville, City of 3
- Carlsbad, City of 3
- Pomona, City of 3
- Cerritos, City of 3
- El Segundo, City of 3
- Pasadena, City of 3
- South Pasadena, City of 3
- American Canyon, City of 3
- Sacramento, City of 3
- Oakdale, City of 2
- Fresno, City of 2
- San Francisco, City and County of 2
- California Department of Fish and Wildlife 2
- Santa Barbara, City of 2
- Garden Grove, City of 2
- Glendora, City of 2
- Oceanside, City of 2
- Glendale, City of 2
- Coronado, City of 2
- …
DES_TP >30
- Local Recreation Area 140
- Local Park 60
- Local Conservation Area 12
- Local Other or Unknown 6
- State Conservation Area 2
- 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
- …
MNG_AG_TYP 9
ACCESS_TYP 1
- Restricted Access · 260 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
13775 | 13775 | 13774 | {"type": "Polygon", "coordinates": [[[-118.30569, 34.2043], [-118.30536, 34.20526], [-118.30482, 34.20631], [-118.30485, 34.20634], [-118.30447, 34.20831], [-118.3044, 34.20885], [-118.3044, 34.20905], [-118.30441, 34.20932], [-118.3045, 34.2098], [-118.30478, 34.21066], [-118.30495, 34.2113], [-118.30514, 34.21186], [-118.3048, 34.21198], [-118.30448, 34.21216], [-118.30405, 34.21258], [-118.30397, 34.21284], [-118.30396, 34.21311], [-118.30379, 34.21316], [-118.30369, 34.21305], [-118.30356, 34.21282], [-118.30369, 34.21252], [-118.30357, 34.21209], [-118.30382, 34.2116], [-118.30382, 34.21134], [-118.30349, 34.21114], [-118.30242, 34.21098], [-118.30216, 34.21137], [-118.30195, 34.21128], [-118.30288, 34.20918], [-118.30317, 34.2082], [-118.30299, 34.20777], [-118.3024, 34.2075], [-118.30183, 34.20757], [-118.30114, 34.20747], [-118.30031, 34.20799], [-118.30006, 34.20793], [-118.30033, 34.20757], [-118.30037, 34.20724], [-118.30176, 34.20593], [-118.29979, 34.20421], [-118.29844, 34.20413], [-118.29839, 34.20362], [-118.29851, 34.20278], [-118.29836, 34.20278], [-118.29863, 34.20265], [-118.29873, 34.20257], [-118.29883, 34.2025], [-118.299, 34.20235], [-118.29915, 34.20228], [-118.29922, 34.20227], [-118.29934, 34.20227], [-118.29942, 34.20229], [-118.29959, 34.20236], [-118.29994, 34.20255], [-118.30011, 34.20259], [-118.3004, 34.20259], [-118.30062, 34.20253], [-118.30087, 34.20239], [-118.30097, 34.20232], [-118.30116, 34.20207], [-118.30145, 34.20175], [-118.30165, 34.20159], [-118.30243, 34.20112], [-118.3026, 34.20114], [-118.30281, 34.20125], [-118.30292, 34.20129], [-118.30394, 34.20147], [-118.30419, 34.20148], [-118.30424, 34.20169], [-118.30453, 34.20221], [-118.30504, 34.20306], [-118.30563, 34.20399], [-118.30569, 34.20414], [-118.30569, 34.2043]]]} | Restricted Access 2 | 46258 | DeBell Golf Course | 29545 | 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.debellgolf.com/ | Los Angeles 6 | 95.759 | DeBell GC | 0 | Local Recreation Area 3 | 4 |
7285 | 7285 | 7284 | {"type": "MultiPolygon", "coordinates": [[[[-117.95983, 35.12231], [-117.95872, 35.12232], [-117.95655, 35.12177], [-117.95527, 35.12204], [-117.95512, 35.12207], [-117.95498, 35.12215], [-117.95463, 35.12234], [-117.95354, 35.12419], [-117.95339, 35.12518], [-117.95338, 35.1258], [-117.95164, 35.1258], [-117.95164, 35.12565], [-117.95169, 35.12544], [-117.95179, 35.12528], [-117.9519, 35.12516], [-117.95197, 35.12482], [-117.95181, 35.12444], [-117.95159, 35.12419], [-117.95055, 35.12353], [-117.94994, 35.12329], [-117.94971, 35.12316], [-117.94946, 35.12327], [-117.9491, 35.12355], [-117.94868, 35.12484], [-117.94847, 35.12535], [-117.94855, 35.12537], [-117.9485, 35.12583], [-117.94503, 35.12583], [-117.94502, 35.12557], [-117.94396, 35.12425], [-117.94403, 35.1234], [-117.94411, 35.123], [-117.94433, 35.12284], [-117.94497, 35.12324], [-117.94504, 35.12411], [-117.94539, 35.12444], [-117.94632, 35.12517], [-117.94734, 35.12559], [-117.94786, 35.12477], [-117.9487, 35.12354], [-117.9479, 35.12314], [-117.94735, 35.12303], [-117.94684, 35.12276], [-117.94475, 35.12249], [-117.94453, 35.12244], [-117.94455, 35.12223], [-117.94535, 35.12216], [-117.94711, 35.12197], [-117.94786, 35.12211], [-117.94949, 35.12295], [-117.94995, 35.12287], [-117.95071, 35.12241], [-117.95112, 35.12266], [-117.95203, 35.12267], [-117.95237, 35.12257], [-117.95337, 35.12203], [-117.95359, 35.12186], [-117.95369, 35.12163], [-117.95483, 35.12057], [-117.95504, 35.12008], [-117.95513, 35.11981], [-117.95503, 35.1193], [-117.95497, 35.11906], [-117.9549, 35.11863], [-117.95736, 35.11868], [-117.9566, 35.11915], [-117.9566, 35.11917], [-117.95706, 35.11977], [-117.95796, 35.12056], [-117.95832, 35.12077], [-117.95915, 35.12101], [-117.95961, 35.12121], [-117.95983, 35.12121], [-117.95983, 35.12231]]], [[[-117.96166, 35.13066], [-117.96126, 35.13091], [-117.96113, 35.13092], [-117.96104, 35.1309], [-117.96099, 35.13085], [-117.96056, 35.1304], [-117.95966, 35.13056], [-117.95925, 35.13016], [-117.95911, 35.12989], [-117.95782, 35.13009], [-117.9568, 35.13035], [-117.95606, 35.13048], [-117.95568, 35.13035], [-117.95516, 35.13034], [-117.95499, 35.13029], [-117.95449, 35.12986], [-117.95416, 35.12994], [-117.95384, 35.13031], [-117.95311, 35.1307], [-117.95258, 35.13121], [-117.95206, 35.13153], [-117.95173, 35.1316], [-117.95015, 35.13225], [-117.95013, 35.13111], [-117.95031, 35.13108], [-117.95081, 35.13083], [-117.95114, 35.13003], [-117.95113, 35.13003], [-117.95094, 35.13012], [-117.95063, 35.13023], [-117.95045, 35.13028], [-117.95022, 35.13031], [-117.95015, 35.13031], [-117.95013, 35.13014], [-117.95051, 35.13009], [-117.95062, 35.13004], [-117.9507, 35.13003], [-117.95097, 35.12992], [-117.95126, 35.12971], [-117.95141, 35.12956], [-117.95159, 35.12926], [-117.95161, 35.12918], [-117.95165, 35.12888], [-117.95164, 35.12853], [-117.95162, 35.12612], [-117.95344, 35.12612], [-117.95338, 35.12702], [-117.95347, 35.12749], [-117.95333, 35.12797], [-117.95298, 35.12825], [-117.95271, 35.1286], [-117.95263, 35.12887], [-117.95264, 35.1292], [-117.95373, 35.12922], [-117.95375, 35.12895], [-117.95428, 35.12885], [-117.95586, 35.12844], [-117.95667, 35.12839], [-117.95727, 35.12848], [-117.95813, 35.12838], [-117.95863, 35.12857], [-117.95895, 35.12859], [-117.96003, 35.12813], [-117.96003, 35.12819], [-117.96011, 35.12839], [-117.9602, 35.12869], [-117.96041, 35.12912], [-117.96055, 35.12933], [-117.96083, 35.12974], [-117.96166, 35.13066]]], [[[-117.94984, 35.13219], [-117.94919, 35.13247], [-117.9489, 35.13268], [-117.94835, 35.13286], [-117.9477, 35.13328], [-117.94715, 35.13328], [-117.94714, 35.13315], [-117.94567, 35.13316], [-117.94564, 35.13299], [-117.94471, 35.1329], [-117.94471, 35.13281], [-117.94476, 35.1327], [-117.94508, 35.1326], [-117.94504, 35.13243], [-117.94452, 35.1326], [-117.94441, 35.1326], [-117.94434, 35.13254], [-117.94422, 35.13229], [-117.94412, 35.13222], [-117.94339, 35.13198], [-117.94354, 35.13187], [-117.94361, 35.13168], [-117.94357, 35.13137], [-117.9434, 35.13101], [-117.94349, 35.13096], [-117.94351, 35.13092], [-117.94313, 35.13091], [-117.94315, 35.13046], [-117.9433, 35.13045], [-117.94332, 35.12993], [-117.94288, 35.12992], [-117.94286, 35.13016], [-117.94264, 35.13015], [-117.94268, 35.12929], [-117.94233, 35.12925], [-117.9423, 35.12918], [-117.94098, 35.12914], [-117.94092, 35.12908], [-117.94111, 35.12885], [-117.94107, 35.12882], [-117.94141, 35.12892], [-117.94214, 35.12881], [-117.94255, 35.12865], [-117.94255, 35.1284], [-117.94247, 35.12833], [-117.94236, 35.12785], [-117.94267, 35.1275], [-117.94311, 35.12732], [-117.94325, 35.12741], [-117.94311, 35.12771], [-117.94311, 35.12798], [-117.94339, 35.12807], [-117.94384, 35.12803], [-117.94422, 35.12792], [-117.94423, 35.12764], [-117.94412, 35.12743], [-117.94501, 35.12737], [-117.94523, 35.12746], [-117.94523, 35.12762], [-117.94495, 35.12785], [-117.9449, 35.1283], [-117.94442, 35.12849], [-117.94344, 35.12858], [-117.94331, 35.12869], [-117.94334, 35.12915], [-117.94311, 35.12929], [-117.94311, 35.12953], [-117.94375, 35.12968], [-117.94381, 35.12986], [-117.9437, 35.13002], [-117.9437, 35.1302], [-117.94384, 35.13032], [-117.94437, 35.13043], [-117.9447, 35.13062], [-117.94537, 35.13076], [-117.94551, 35.13094], [-117.94554, 35.13227], [-117.94545, 35.1323], [-117.94545, 35.13232], [-117.94558, 35.13232], [-117.94562, 35.13073], [-117.94666, 35.13073], [-117.94667, 35.13027], [-117.9477, 35.13027], [-117.94772, 35.13113], [-117.9478, 35.13123], [-117.9479, 35.13128], [-117.94815, 35.1313], [-117.94902, 35.13129], [-117.94923, 35.13128], [-117.94932, 35.13125], [-117.9494, 35.13119], [-117.94944, 35.13111], [-117.94945, 35.13026], [-117.94981, 35.13026], [-117.94971, 35.13033], [-117.94965, 35.13041], [-117.94966, 35.13116], [-117.94981, 35.13116], [-117.94984, 35.13219]]]]} | Restricted Access 2 | 48425 | Tierra Del Sol Golf | 33049 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 178.11 | Tierra Del Sol Golf | 0 | None 602 | ||
9493 | 9493 | 9492 | {"type": "MultiPolygon", "coordinates": [[[[-117.94979, 35.1278], [-117.94897, 35.12779], [-117.9487, 35.12788], [-117.94845, 35.1281], [-117.94846, 35.13001], [-117.94782, 35.13002], [-117.94782, 35.12984], [-117.94781, 35.12855], [-117.94753, 35.12829], [-117.94728, 35.12823], [-117.94692, 35.12838], [-117.94679, 35.12855], [-117.94677, 35.12887], [-117.94677, 35.13003], [-117.94655, 35.13003], [-117.94636, 35.12998], [-117.94627, 35.12999], [-117.9462, 35.13003], [-117.94617, 35.13008], [-117.94615, 35.13018], [-117.94619, 35.13027], [-117.94625, 35.13031], [-117.94634, 35.13033], [-117.94653, 35.13028], [-117.94667, 35.13027], [-117.94667, 35.13073], [-117.94562, 35.13074], [-117.94558, 35.13233], [-117.94541, 35.13232], [-117.94554, 35.13226], [-117.94551, 35.13094], [-117.94537, 35.13076], [-117.9447, 35.13062], [-117.94437, 35.13043], [-117.94384, 35.13032], [-117.9437, 35.1302], [-117.9437, 35.13002], [-117.94381, 35.12986], [-117.94375, 35.12968], [-117.94311, 35.12954], [-117.94311, 35.12929], [-117.94334, 35.12915], [-117.94331, 35.12869], [-117.94345, 35.12858], [-117.94442, 35.12849], [-117.94489, 35.12831], [-117.94495, 35.12785], [-117.94523, 35.12762], [-117.94523, 35.12745], [-117.94501, 35.12737], [-117.94413, 35.12743], [-117.94412, 35.12745], [-117.94423, 35.12764], [-117.94423, 35.12791], [-117.94384, 35.12803], [-117.94339, 35.12807], [-117.94311, 35.12798], [-117.94311, 35.12771], [-117.94325, 35.12741], [-117.94311, 35.12732], [-117.94267, 35.1275], [-117.94236, 35.12785], [-117.94247, 35.12833], [-117.94255, 35.1284], [-117.94255, 35.12865], [-117.94214, 35.12881], [-117.94141, 35.12892], [-117.94102, 35.12879], [-117.94103, 35.12755], [-117.94109, 35.12739], [-117.9412, 35.12699], [-117.94123, 35.12672], [-117.94124, 35.12613], [-117.94977, 35.12613], [-117.94979, 35.1278]]], [[[-117.94286, 35.13016], [-117.94286, 35.13018], [-117.94264, 35.13018], [-117.94264, 35.13015], [-117.94286, 35.13016]]], [[[-117.94567, 35.13316], [-117.94481, 35.1331], [-117.94404, 35.133], [-117.94334, 35.13283], [-117.94307, 35.13275], [-117.94334, 35.13215], [-117.94332, 35.13203], [-117.94339, 35.13198], [-117.94412, 35.13222], [-117.94422, 35.13229], [-117.94434, 35.13254], [-117.94441, 35.1326], [-117.94452, 35.1326], [-117.94504, 35.13242], [-117.94508, 35.1326], [-117.94476, 35.1327], [-117.94471, 35.13281], [-117.94471, 35.1329], [-117.94564, 35.13299], [-117.94567, 35.13316]]], [[[-117.94352, 35.13092], [-117.94349, 35.13096], [-117.9434, 35.13101], [-117.94331, 35.13102], [-117.9432, 35.13099], [-117.94313, 35.13092], [-117.94352, 35.13092]]]]} | Restricted Access 2 | 15889 | California City Central Park/Tierra Del Sol Golf | 33388 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 67.723 | California City Central Park/Tierra Del Sol Golf | None 786 | |||
13897 | 13897 | 13896 | {"type": "Polygon", "coordinates": [[[-118.03556, 34.06661], [-118.0355, 34.06666], [-118.03549, 34.0667], [-118.03547, 34.0667], [-118.03547, 34.06675], [-118.03544, 34.06676], [-118.03544, 34.06686], [-118.03528, 34.06686], [-118.03527, 34.06691], [-118.03478, 34.06691], [-118.03478, 34.06651], [-118.03525, 34.06652], [-118.03527, 34.06653], [-118.03556, 34.06654], [-118.03556, 34.06661]]]} | Restricted Access 2 | 46374 | El Monte Aquatic Center | 29652 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 0.667 | El Monte Aquatic Ctr. | 0 | Local Recreation Area 3 | 4 | |
15278 | 15278 | 15277 | {"type": "Polygon", "coordinates": [[[-118.03583, 34.06522], [-118.03583, 34.06637], [-118.03578, 34.06639], [-118.03464, 34.06639], [-118.03464, 34.06484], [-118.03578, 34.06484], [-118.0358, 34.06507], [-118.03578, 34.06508], [-118.03579, 34.06521], [-118.03583, 34.06522]]]} | Restricted Access 2 | 46369 | Community Center Complex | 29686 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 4.633 | Community Ctr. Complex | 0 | Local Recreation Area 3 | 4 | |
2998 | 2998 | 2997 | {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} | Restricted Access 2 | 20562 | Veterans Park Soccer Complex | 29804 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/84-veterans-park | Los Angeles 6 | 10.986 | Veterans Park Soccer Complex | 0 | Local Recreation Area 3 | 4 |
15711 | 15711 | 15710 | {"type": "Polygon", "coordinates": [[[-117.77156, 34.04612], [-117.76587, 34.04476], [-117.76552, 34.04462], [-117.76521, 34.04446], [-117.76488, 34.04424], [-117.7645, 34.04391], [-117.76436, 34.04383], [-117.76422, 34.04378], [-117.76445, 34.0437], [-117.76472, 34.04357], [-117.76489, 34.04352], [-117.76514, 34.0435], [-117.76538, 34.04355], [-117.76558, 34.04364], [-117.7658, 34.0438], [-117.76599, 34.04392], [-117.76629, 34.04406], [-117.76668, 34.04416], [-117.76724, 34.04422], [-117.76742, 34.04426], [-117.76758, 34.04433], [-117.76781, 34.04447], [-117.76801, 34.04463], [-117.76823, 34.04472], [-117.76833, 34.04478], [-117.76841, 34.0449], [-117.76844, 34.04503], [-117.76865, 34.04508], [-117.76889, 34.04508], [-117.76912, 34.04501], [-117.76925, 34.04493], [-117.76936, 34.04478], [-117.76944, 34.04474], [-117.76951, 34.04474], [-117.76962, 34.04477], [-117.76971, 34.04478], [-117.76984, 34.04475], [-117.76993, 34.04469], [-117.77001, 34.04466], [-117.77071, 34.04468], [-117.7708, 34.04466], [-117.77091, 34.04461], [-117.771, 34.04453], [-117.77106, 34.04446], [-117.77107, 34.04492], [-117.77111, 34.04498], [-117.77134, 34.04494], [-117.77152, 34.04494], [-117.77156, 34.04612]]]} | Restricted Access 2 | 28355 | Palm Lake Golf Course | 33090 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 15.151 | Palm Lake GC | 0 | Local Recreation Area 3 | 4 | |
17051 | 17051 | 17050 | {"type": "Polygon", "coordinates": [[[-117.74578, 34.02877], [-117.74542, 34.02878], [-117.74539, 34.02875], [-117.74539, 34.02862], [-117.74577, 34.02861], [-117.74578, 34.02877]]]} | Restricted Access 2 | 46518 | Renacimiento Community Center | 29805 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/81-renacimiento-community-center | Los Angeles 6 | 0.157 | Renacimiento Community Ctr. | 0 | Local Recreation Area 3 | 4 |
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 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 | ||
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 | |
15931 | 15931 | 15930 | {"type": "Polygon", "coordinates": [[[-122.24262, 38.17617], [-122.23981, 38.17895], [-122.23986, 38.1792], [-122.23953, 38.1794], [-122.23943, 38.17962], [-122.23897, 38.17977], [-122.2389, 38.17988], [-122.23875, 38.17999], [-122.23878, 38.18009], [-122.2392, 38.18056], [-122.23904, 38.18081], [-122.23904, 38.18115], [-122.23881, 38.18129], [-122.23872, 38.18153], [-122.23844, 38.18154], [-122.23842, 38.18192], [-122.2382, 38.18229], [-122.23791, 38.18226], [-122.23767, 38.18233], [-122.23754, 38.18257], [-122.23737, 38.18259], [-122.23706, 38.18241], [-122.23686, 38.18239], [-122.23663, 38.18253], [-122.23375, 38.18254], [-122.23285, 38.18565], [-122.22446, 38.18414], [-122.22153, 38.19229], [-122.21829, 38.19216], [-122.21145, 38.19203], [-122.20969, 38.18989], [-122.21593, 38.18833], [-122.21327, 38.18417], [-122.21376, 38.1835], [-122.21378, 38.18328], [-122.21374, 38.18232], [-122.21527, 38.1799], [-122.21507, 38.17952], [-122.21507, 38.17936], [-122.21492, 38.17912], [-122.21474, 38.1789], [-122.21463, 38.17869], [-122.21238, 38.17684], [-122.21152, 38.17477], [-122.21073, 38.1741], [-122.2161, 38.17414], [-122.22476, 38.17401], [-122.22389, 38.17619], [-122.22808, 38.17781], [-122.22869, 38.17795], [-122.23028, 38.17837], [-122.23138, 38.1786], [-122.2334, 38.17948], [-122.23328, 38.17976], [-122.23328, 38.17977], [-122.23699, 38.18098], [-122.24253, 38.1755], [-122.24262, 38.17617]]]} | Restricted Access 2 | 34999 | Newell Open Space Preserve | 22722 | 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 | 639.436 | Newell OSP | 0 | Local Conservation Area 4 | 2 | |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
15131 | 15131 | 15130 | {"type": "Polygon", "coordinates": [[[-118.17142, 34.16041], [-118.171, 34.16012], [-118.17032, 34.15985], [-118.16923, 34.15947], [-118.16932, 34.15971], [-118.16928, 34.15992], [-118.16967, 34.161], [-118.16974, 34.16109], [-118.16982, 34.16114], [-118.17003, 34.16174], [-118.16999, 34.16176], [-118.17005, 34.16195], [-118.16896, 34.16226], [-118.1689, 34.16241], [-118.16857, 34.16252], [-118.16841, 34.16264], [-118.16808, 34.16276], [-118.16778, 34.16277], [-118.16589, 34.16329], [-118.16523, 34.16349], [-118.16484, 34.16267], [-118.1643, 34.16174], [-118.16393, 34.16098], [-118.16414, 34.1607], [-118.16434, 34.16049], [-118.16452, 34.16034], [-118.16488, 34.1601], [-118.1652, 34.15989], [-118.16547, 34.15975], [-118.16635, 34.15937], [-118.16677, 34.1591], [-118.16692, 34.15898], [-118.16712, 34.15877], [-118.1673, 34.15855], [-118.16745, 34.15832], [-118.16758, 34.15807], [-118.16767, 34.15782], [-118.16772, 34.15756], [-118.16775, 34.15729], [-118.16774, 34.15703], [-118.1676, 34.15659], [-118.16757, 34.15606], [-118.16822, 34.15592], [-118.1683, 34.15589], [-118.1684, 34.15582], [-118.16848, 34.15574], [-118.16855, 34.15563], [-118.16857, 34.15553], [-118.16858, 34.15541], [-118.16854, 34.15527], [-118.168, 34.15465], [-118.16787, 34.15444], [-118.16778, 34.15421], [-118.16776, 34.15415], [-118.16779, 34.15412], [-118.16809, 34.15392], [-118.1681, 34.154], [-118.16823, 34.15427], [-118.16828, 34.15444], [-118.1688, 34.1547], [-118.1694, 34.15575], [-118.16993, 34.15661], [-118.17033, 34.1578], [-118.17055, 34.1584], [-118.17071, 34.1588], [-118.17103, 34.1592], [-118.17142, 34.16041]]]} | Restricted Access 2 | 45950 | Rose Bowl | 29069 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.rosebowlstadium.com/ | Los Angeles 6 | 74.133 | Rose Bowl | None 1318 | ||
15727 | 15727 | 15726 | {"type": "Polygon", "coordinates": [[[-118.17436, 34.1834], [-118.17431, 34.1834], [-118.17301, 34.18282], [-118.17291, 34.18254], [-118.17283, 34.18244], [-118.17273, 34.18235], [-118.17215, 34.18199], [-118.1718, 34.18194], [-118.17174, 34.18191], [-118.17206, 34.18149], [-118.17211, 34.18112], [-118.17243, 34.18106], [-118.1725, 34.18065], [-118.17248, 34.1804], [-118.17237, 34.18021], [-118.17204, 34.18005], [-118.17168, 34.1796], [-118.17145, 34.17966], [-118.17108, 34.17965], [-118.17031, 34.17951], [-118.17015, 34.17919], [-118.17008, 34.17898], [-118.17006, 34.17881], [-118.17008, 34.17861], [-118.17012, 34.17851], [-118.17025, 34.1783], [-118.17049, 34.17802], [-118.17066, 34.17777], [-118.17073, 34.17761], [-118.17076, 34.17745], [-118.17038, 34.17753], [-118.17042, 34.17743], [-118.17041, 34.17735], [-118.1702, 34.17699], [-118.17015, 34.17694], [-118.17006, 34.17688], [-118.16982, 34.17677], [-118.16947, 34.17648], [-118.16929, 34.17639], [-118.16911, 34.17625], [-118.16886, 34.17611], [-118.16866, 34.17587], [-118.16823, 34.17543], [-118.16806, 34.17524], [-118.16766, 34.17524], [-118.16765, 34.17511], [-118.16728, 34.17524], [-118.16725, 34.17511], [-118.16721, 34.17492], [-118.16711, 34.17363], [-118.16701, 34.17317], [-118.16699, 34.17299], [-118.16696, 34.17178], [-118.16689, 34.17152], [-118.16675, 34.17128], [-118.16668, 34.17114], [-118.16661, 34.17084], [-118.16664, 34.17019], [-118.16677, 34.16956], [-118.16679, 34.16932], [-118.16678, 34.16889], [-118.16679, 34.16843], [-118.16677, 34.1682], [-118.16642, 34.1671], [-118.16651, 34.1671], [-118.16652, 34.16709], [-118.16595, 34.16498], [-118.16523, 34.16349], [-118.16589, 34.16329], [-118.16778, 34.16277], [-118.16808, 34.16276], [-118.16841, 34.16264], [-118.16857, 34.16252], [-118.1689, 34.16241], [-118.16896, 34.16226], [-118.17005, 34.16195], [-118.16999, 34.16175], [-118.17002, 34.16173], [-118.16982, 34.16114], [-118.16974, 34.16109], [-118.16967, 34.161], [-118.16928, 34.15992], [-118.16932, 34.15971], [-118.16921, 34.15946], [-118.17032, 34.15985], [-118.171, 34.16012], [-118.17142, 34.16041], [-118.17165, 34.16111], [-118.17241, 34.16315], [-118.17217, 34.16322], [-118.17235, 34.16417], [-118.17242, 34.16439], [-118.17271, 34.16507], [-118.17318, 34.16645], [-118.17352, 34.16795], [-118.17399, 34.16795], [-118.17402, 34.16806], [-118.17425, 34.16914], [-118.17427, 34.16936], [-118.17447, 34.17027], [-118.17448, 34.17049], [-118.17468, 34.17142], [-118.17469, 34.17158], [-118.1748, 34.17226], [-118.17483, 34.17256], [-118.17478, 34.17312], [-118.17472, 34.17342], [-118.17456, 34.17402], [-118.1745, 34.17411], [-118.17437, 34.17417], [-118.17432, 34.17537], [-118.17339, 34.17649], [-118.17257, 34.17743], [-118.17253, 34.17803], [-118.17323, 34.17898], [-118.17357, 34.17931], [-118.1738, 34.17968], [-118.17394, 34.17995], [-118.17402, 34.18031], [-118.17366, 34.1808], [-118.17367, 34.18082], [-118.17359, 34.18105], [-118.17339, 34.18132], [-118.17345, 34.18137], [-118.17332, 34.18178], [-118.17344, 34.18248], [-118.17391, 34.18247], [-118.17394, 34.18268], [-118.17401, 34.18287], [-118.17436, 34.1834]]]} | Restricted Access 2 | 45949 | Brookside Golf Course | 29070 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/brookside_golf_course/ | Los Angeles 6 | 293.605 | Brookside GC | 0 | Local Recreation Area 3 | 4 |
2265 | 2265 | 2264 | {"type": "Polygon", "coordinates": [[[-121.80532, 36.92238], [-121.80509, 36.92259], [-121.80524, 36.92344], [-121.80501, 36.92403], [-121.80178, 36.92397], [-121.80168, 36.92488], [-121.80174, 36.92521], [-121.80015, 36.92537], [-121.7999, 36.92535], [-121.79967, 36.92527], [-121.79939, 36.92508], [-121.79917, 36.92485], [-121.79886, 36.92448], [-121.79865, 36.92435], [-121.79847, 36.92427], [-121.79754, 36.92367], [-121.79741, 36.92355], [-121.79735, 36.9234], [-121.79737, 36.92325], [-121.79743, 36.92324], [-121.79754, 36.92291], [-121.79743, 36.92286], [-121.79796, 36.92185], [-121.79855, 36.9219], [-121.80194, 36.92234], [-121.80196, 36.92219], [-121.80529, 36.92225], [-121.80532, 36.92238]]]} | Restricted Access 2 | 16755 | Harkins Slough | 28150 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 43.338 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
4215 | 4215 | 4214 | {"type": "Polygon", "coordinates": [[[-121.7549, 36.91849], [-121.7545, 36.91871], [-121.75429, 36.91848], [-121.75388, 36.91869], [-121.75349, 36.91824], [-121.75322, 36.91838], [-121.75291, 36.91799], [-121.75268, 36.91773], [-121.75158, 36.91849], [-121.75102, 36.91787], [-121.7528, 36.91657], [-121.75302, 36.91683], [-121.75341, 36.91661], [-121.7542, 36.91753], [-121.7549, 36.91849]]]} | Restricted Access 2 | 44966 | E.A. Hall School Park | 32705 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 9.82 | E.A. Hall School Park | 0 | Local Park 2 | 4 | |
9692 | 9692 | 9691 | {"type": "Polygon", "coordinates": [[[-121.82747, 36.9152], [-121.82607, 36.9168], [-121.82571, 36.91674], [-121.82537, 36.91664], [-121.82532, 36.91668], [-121.82468, 36.91634], [-121.82421, 36.91602], [-121.82368, 36.91571], [-121.82311, 36.91547], [-121.82248, 36.91531], [-121.82184, 36.91523], [-121.82145, 36.91524], [-121.82079, 36.91532], [-121.81964, 36.91555], [-121.81917, 36.91559], [-121.81862, 36.91557], [-121.81814, 36.91548], [-121.81777, 36.91537], [-121.81739, 36.91521], [-121.81705, 36.91502], [-121.81678, 36.91482], [-121.81457, 36.91299], [-121.8141, 36.91247], [-121.81373, 36.91189], [-121.81598, 36.91026], [-121.81956, 36.9132], [-121.82148, 36.91203], [-121.82242, 36.91172], [-121.82319, 36.91255], [-121.82441, 36.91278], [-121.82529, 36.91254], [-121.82747, 36.9152]]]} | Restricted Access 2 | 16377 | Gallighan Slough | 28151 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 98.834 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
2405 | 2405 | 2404 | {"type": "Polygon", "coordinates": [[[-118.40176, 34.26476], [-118.40163, 34.26535], [-118.40154, 34.26562], [-118.40143, 34.26588], [-118.40129, 34.26614], [-118.40113, 34.26638], [-118.40076, 34.26685], [-118.39988, 34.26605], [-118.39946, 34.26558], [-118.39897, 34.26483], [-118.39843, 34.26433], [-118.39782, 34.26399], [-118.39746, 34.26329], [-118.39631, 34.26249], [-118.3954, 34.26242], [-118.39351, 34.26158], [-118.39344, 34.2618], [-118.39335, 34.2618], [-118.39148, 34.26078], [-118.39103, 34.26066], [-118.39073, 34.26044], [-118.39031, 34.26113], [-118.38941, 34.26086], [-118.38925, 34.26121], [-118.38666, 34.26042], [-118.3866, 34.26035], [-118.38665, 34.259], [-118.38713, 34.25817], [-118.3865, 34.2579], [-118.38587, 34.25895], [-118.38448, 34.25843], [-118.38394, 34.2583], [-118.38325, 34.25843], [-118.38262, 34.25846], [-118.38042, 34.25817], [-118.37936, 34.25812], [-118.37816, 34.25822], [-118.37725, 34.25823], [-118.37614, 34.2584], [-118.37506, 34.25861], [-118.37403, 34.25861], [-118.37343, 34.25859], [-118.37384, 34.2578], [-118.37427, 34.25756], [-118.37765, 34.25587], [-118.37789, 34.25571], [-118.3781, 34.25552], [-118.37827, 34.25531], [-118.3784, 34.2551], [-118.38172, 34.25574], [-118.38181, 34.25558], [-118.38262, 34.25451], [-118.38266, 34.25435], [-118.38485, 34.25642], [-118.38492, 34.25637], [-118.39338, 34.25803], [-118.39555, 34.25899], [-118.39564, 34.25907], [-118.39587, 34.25891], [-118.39595, 34.25904], [-118.3961, 34.2592], [-118.39638, 34.25958], [-118.39669, 34.25992], [-118.40172, 34.26468], [-118.40173, 34.26475], [-118.40176, 34.26476]]]} | Restricted Access 2 | 45520 | Hansen Dam Golf Course | 28354 | 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 | http://golf.lacity.org/cdp_hansen.htm | Los Angeles 6 | 201.493 | Hansen Dam GC | 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]);