units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- None 1
- None 1
- National Forest 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 14
- City Agency 10,292
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,898
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15301 | 15301 | 15300 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | 46438 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 4.034 | Royal Oaks Trail North | None 1352 | |||
15031 | 15031 | 15030 | {"type": "Polygon", "coordinates": [[[-122.83393, 41.61987], [-122.83324, 41.62052], [-122.83325, 41.62054], [-122.83331, 41.62054], [-122.83314, 41.62075], [-122.83212, 41.62027], [-122.83205, 41.62032], [-122.83181, 41.62017], [-122.83282, 41.61921], [-122.83393, 41.61987]]]} | Open Access 1 | 45683 | Walker Field | 28497 | 1701 | Fort Jones, City of 1135 | City 2 | City Agency 2 | City 2 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | Siskiyou 28 | 3.716 | Walker Field | 0 | Local Recreation Area 3 | 4 | ||
14926 | 14926 | 14925 | {"type": "Polygon", "coordinates": [[[-122.27139, 41.21224], [-122.27137, 41.21239], [-122.27096, 41.21242], [-122.27099, 41.2122], [-122.27139, 41.21224]]]} | Open Access 1 | 45500 | Children's Park | 28333 | 1700 | Dunsmuir, City of 1127 | City 2 | City Agency 2 | http://ci.dunsmuir.ca.us/ | City 2 | 1700 | Dunsmuir, City of 1082 | City 2 | City Agency 2 | Siskiyou 28 | 0.166 | Children's Park | 0 | Local Park 2 | 4 | |
14742 | 14742 | 14741 | {"type": "Polygon", "coordinates": [[[-115.61857, 33.0338], [-115.61857, 33.035], [-115.6174, 33.035], [-115.6174, 33.0338], [-115.61857, 33.0338]]]} | Open Access 1 | 45123 | Jake James Municipal Sports Park Development | 28025 | 1678 | Westmorland, City of 1121 | City 2 | City Agency 2 | http://www.cityofwestmorland.net/ | City 2 | 1678 | Westmorland, City of 1076 | City 2 | City Agency 2 | Imperial 20 | 3.592 | Jake James Municipal Sports Park Development | None 1263 | |||
14688 | 14688 | 14687 | {"type": "Polygon", "coordinates": [[[-117.93807, 34.01787], [-117.9369, 34.02264], [-117.93682, 34.02264], [-117.9367, 34.02287], [-117.93573, 34.02327], [-117.93478, 34.02326], [-117.93448, 34.02322], [-117.93398, 34.02336], [-117.93332, 34.02341], [-117.93268, 34.02377], [-117.93232, 34.02429], [-117.93221, 34.02464], [-117.93236, 34.02535], [-117.93261, 34.02577], [-117.9329, 34.02604], [-117.93359, 34.02641], [-117.93493, 34.02691], [-117.93511, 34.02717], [-117.93532, 34.02753], [-117.93534, 34.02768], [-117.93528, 34.02789], [-117.93341, 34.02785], [-117.93283, 34.02778], [-117.93226, 34.02768], [-117.92284, 34.02511], [-117.92244, 34.02505], [-117.91796, 34.02461], [-117.91792, 34.02459], [-117.9179, 34.02456], [-117.9179, 34.02452], [-117.92008, 34.01904], [-117.92158, 34.01919], [-117.92157, 34.01914], [-117.9201, 34.01899], [-117.92078, 34.01727], [-117.92095, 34.0169], [-117.92116, 34.01651], [-117.92171, 34.01558], [-117.9217, 34.01556], [-117.9221, 34.01491], [-117.93046, 34.01574], [-117.9371, 34.0177], [-117.93807, 34.01787]]]} | Restricted Access 2 | 45010 | Industry Hills Golf Club | 29719 | 1146 | Industry, City of 1119 | City 2 | City Agency 2 | http://www.cityofindustry.org/ | City 2 | 6108 | Los Angeles Golf Club 1073 | Private 7 | Commercial 18 | http://www.ihgolfclub.com/ | Los Angeles 6 | 430.082 | Industry Hills Golf Club | None 1257 | ||
14605 | 14605 | 14604 | {"type": "MultiPolygon", "coordinates": [[[[-118.99513, 34.22522], [-118.99416, 34.22587], [-118.99396, 34.22605], [-118.99375, 34.22591], [-118.99349, 34.22579], [-118.99331, 34.22595], [-118.99269, 34.2257], [-118.99252, 34.22559], [-118.99243, 34.22558], [-118.99226, 34.2257], [-118.99199, 34.22553], [-118.99167, 34.2255], [-118.99095, 34.22567], [-118.99104, 34.22594], [-118.99101, 34.22595], [-118.9909, 34.22569], [-118.99066, 34.22576], [-118.99043, 34.22585], [-118.99, 34.22607], [-118.9896, 34.22634], [-118.98943, 34.2265], [-118.98911, 34.22683], [-118.98885, 34.22722], [-118.98877, 34.22744], [-118.98843, 34.22754], [-118.98849, 34.22787], [-118.98887, 34.22801], [-118.98902, 34.2282], [-118.98929, 34.22802], [-118.98931, 34.22804], [-118.98905, 34.22823], [-118.98924, 34.22838], [-118.98923, 34.22874], [-118.98912, 34.22905], [-118.98914, 34.22921], [-118.9893, 34.22938], [-118.9895, 34.22947], [-118.98983, 34.22948], [-118.99003, 34.22936], [-118.9921, 34.22992], [-118.99219, 34.22962], [-118.99222, 34.22963], [-118.99214, 34.22993], [-118.99272, 34.23009], [-118.99293, 34.23008], [-118.99093, 34.23081], [-118.9907, 34.23038], [-118.98808, 34.2303], [-118.988, 34.22995], [-118.98796, 34.22918], [-118.98793, 34.22897], [-118.98784, 34.22871], [-118.98762, 34.22825], [-118.9882, 34.22881], [-118.9887, 34.22844], [-118.98783, 34.22762], [-118.98744, 34.2279], [-118.98729, 34.22759], [-118.98807, 34.22714], [-118.98771, 34.22668], [-118.99037, 34.22519], [-118.991, 34.22491], [-118.99138, 34.22482], [-118.99334, 34.22503], [-118.9945, 34.22449], [-118.99463, 34.22466], [-118.99491, 34.22495], [-118.99513, 34.22522]]], [[[-118.99869, 34.2319], [-118.99551, 34.23195], [-118.99551, 34.23225], [-118.99501, 34.23226], [-118.99474, 34.23228], [-118.99444, 34.23234], [-118.99414, 34.23243], [-118.99398, 34.23211], [-118.99401, 34.2316], [-118.99351, 34.23109], [-118.99307, 34.23094], [-118.99266, 34.23108], [-118.99251, 34.23148], [-118.99273, 34.2318], [-118.99282, 34.2321], [-118.99313, 34.23256], [-118.99255, 34.23317], [-118.9928, 34.23352], [-118.99239, 34.23411], [-118.9921, 34.23297], [-118.99215, 34.23248], [-118.99151, 34.23088], [-118.99461, 34.22975], [-118.99494, 34.23038], [-118.99559, 34.2306], [-118.99549, 34.23078], [-118.99589, 34.23105], [-118.99579, 34.23124], [-118.996, 34.23123], [-118.99817, 34.23176], [-118.99866, 34.23174], [-118.99869, 34.2319]]], [[[-119.03767, 34.24169], [-119.03769, 34.24188], [-119.03766, 34.24206], [-119.03755, 34.24226], [-119.03741, 34.2424], [-119.03726, 34.24249], [-119.03712, 34.24254], [-119.03626, 34.24276], [-119.0357, 34.24116], [-119.03624, 34.24102], [-119.0361, 34.24063], [-119.03575, 34.24066], [-119.03573, 34.2406], [-119.03607, 34.24057], [-119.03608, 34.24056], [-119.03505, 34.23759], [-119.03521, 34.23755], [-119.03562, 34.23873], [-119.03601, 34.23864], [-119.03603, 34.23869], [-119.03564, 34.2388], [-119.03622, 34.24044], [-119.03662, 34.24035], [-119.03665, 34.24043], [-119.03625, 34.24054], [-119.03673, 34.24192], [-119.03767, 34.24169]]]]} | Open Access 1 | 48297 | Mission Verde Park | 32869 | 1708 | Camarillo, City of 1117 | City 2 | City Agency 2 | http://www.ci.camarillo.ca.us/ | City 2 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 57.518 | Mission Verde Park | 0 | Local Park 2 | 4 | |
13089 | 13089 | 13088 | {"type": "Polygon", "coordinates": [[[-121.05633, 39.21384], [-121.05624, 39.2148], [-121.05553, 39.21478], [-121.05558, 39.21505], [-121.05434, 39.21508], [-121.05425, 39.21443], [-121.0543, 39.21412], [-121.05428, 39.21375], [-121.05416, 39.21327], [-121.05422, 39.21324], [-121.05475, 39.21318], [-121.055, 39.21318], [-121.05574, 39.21354], [-121.05609, 39.21357], [-121.05608, 39.21382], [-121.05633, 39.21384]]]} | Open Access 1 | 35006 | Memorial Park | 22141 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 7.576 | Memorial Park | 0 | Local Park 2 | 4 | |
13107 | 13107 | 13106 | {"type": "Polygon", "coordinates": [[[-121.08051, 39.21484], [-121.07948, 39.21911], [-121.079, 39.21958], [-121.07426, 39.21962], [-121.07422, 39.21856], [-121.07364, 39.2184], [-121.07337, 39.21828], [-121.07315, 39.21815], [-121.07263, 39.21792], [-121.07203, 39.21758], [-121.07158, 39.21846], [-121.07066, 39.21733], [-121.07041, 39.2173], [-121.0703, 39.21726], [-121.06975, 39.21716], [-121.06983, 39.21701], [-121.06969, 39.21698], [-121.06975, 39.21679], [-121.06907, 39.21666], [-121.06909, 39.21661], [-121.06981, 39.21672], [-121.06983, 39.21661], [-121.06921, 39.2165], [-121.06922, 39.2164], [-121.06988, 39.2165], [-121.06998, 39.21629], [-121.07018, 39.21633], [-121.07029, 39.21636], [-121.07032, 39.21621], [-121.07108, 39.2163], [-121.07093, 39.21613], [-121.07093, 39.21604], [-121.07087, 39.21589], [-121.07093, 39.21578], [-121.07093, 39.21568], [-121.07101, 39.21568], [-121.07102, 39.21567], [-121.07055, 39.21477], [-121.07074, 39.21497], [-121.07089, 39.21518], [-121.07154, 39.21486], [-121.07188, 39.21488], [-121.07218, 39.21487], [-121.07218, 39.21524], [-121.07229, 39.21523], [-121.07263, 39.21526], [-121.07305, 39.21534], [-121.073, 39.21539], [-121.07301, 39.21541], [-121.074, 39.21536], [-121.07443, 39.21526], [-121.07459, 39.21506], [-121.07525, 39.215], [-121.07581, 39.21497], [-121.07609, 39.21494], [-121.07654, 39.21495], [-121.0766, 39.21591], [-121.07869, 39.21589], [-121.07868, 39.21527], [-121.07931, 39.2153], [-121.0792, 39.21489], [-121.08051, 39.21484]]]} | Open Access 1 | 35025 | Condon Park | 17580 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 83.068 | Condon Park | 0 | Local Park 2 | 4 | |
13108 | 13108 | 13107 | {"type": "Polygon", "coordinates": [[[-121.07218, 39.21473], [-121.07194, 39.21477], [-121.07179, 39.21476], [-121.07153, 39.2147], [-121.07127, 39.21456], [-121.07117, 39.21456], [-121.07145, 39.21433], [-121.07113, 39.21408], [-121.07115, 39.21401], [-121.07109, 39.21397], [-121.07094, 39.21396], [-121.07073, 39.21399], [-121.07056, 39.21411], [-121.07051, 39.21404], [-121.07053, 39.21399], [-121.07098, 39.21389], [-121.07206, 39.21396], [-121.07218, 39.21473]]]} | Open Access 1 | 35026 | Minnie Park | 22268 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 1.677 | Minnie Park | 0 | Local Park 2 | 4 | |
14281 | 14281 | 14280 | {"type": "Polygon", "coordinates": [[[-121.07036, 39.22802], [-121.06963, 39.22835], [-121.07019, 39.22913], [-121.06979, 39.22933], [-121.07021, 39.22992], [-121.07021, 39.22996], [-121.0703, 39.22994], [-121.0702, 39.23017], [-121.07018, 39.23007], [-121.07008, 39.22999], [-121.06941, 39.23031], [-121.06873, 39.2306], [-121.06891, 39.23093], [-121.0685, 39.23105], [-121.06789, 39.23117], [-121.06728, 39.23008], [-121.0669, 39.22946], [-121.0669, 39.22935], [-121.0671, 39.22932], [-121.06727, 39.22922], [-121.06745, 39.22784], [-121.06751, 39.22721], [-121.06752, 39.22688], [-121.06839, 39.22691], [-121.0684, 39.22791], [-121.06981, 39.22726], [-121.07036, 39.22802]]]} | Open Access 1 | 44208 | DeVere Mautino Park | 18126 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 21.376 | DeVere Mautino Park | 0 | Local Park 2 | 4 | |
14854 | 14854 | 14853 | {"type": "Polygon", "coordinates": [[[-121.05875, 39.21793], [-121.0585, 39.21826], [-121.05842, 39.21828], [-121.05813, 39.21785], [-121.0587, 39.21786], [-121.05875, 39.21793]]]} | Open Access 1 | 45357 | Dow Alexander Park | 18253 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 0.356 | Dow Alexander Park | 0 | Local Park 2 | 4 | |
13052 | 13052 | 13051 | {"type": "Polygon", "coordinates": [[[-120.24958, 39.68178], [-120.24797, 39.68179], [-120.24795, 39.68118], [-120.24692, 39.68118], [-120.24691, 39.68182], [-120.24567, 39.68182], [-120.24567, 39.68073], [-120.24958, 39.68072], [-120.24958, 39.68178]]]} | Open Access 1 | 34905 | Loyalton Park | 21571 | 1669 | Loyalton, City of 1040 | City 2 | City Agency 2 | http://www.cityofloyalton.com/ | City 2 | 1669 | Loyalton, City of 1002 | City 2 | City Agency 2 | Sierra 58 | 8.349 | Loyalton Park | 0 | Local Park 2 | 4 | |
13023 | 13023 | 13022 | {"type": "Polygon", "coordinates": [[[-122.1377, 37.6311], [-122.13721, 37.63171], [-122.13632, 37.63217], [-122.13453, 37.63218], [-122.1377, 37.6311]]]} | No Public Access 3 | 46960 | Hayward Regional Shoreline | 19761 | 1685 | Hayward, City of 1038 | City 2 | City Agency 2 | http://www.ci.hayward.ca.us/ | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 2.662 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
12722 | 12722 | 12721 | {"type": "MultiPolygon", "coordinates": [[[[-118.39518, 37.3677], [-118.39443, 37.36771], [-118.39444, 37.36867], [-118.39296, 37.36869], [-118.39296, 37.36913], [-118.39235, 37.36914], [-118.39235, 37.36952], [-118.39077, 37.36954], [-118.39079, 37.36747], [-118.39075, 37.36733], [-118.39065, 37.36722], [-118.39056, 37.36716], [-118.39045, 37.36712], [-118.39024, 37.36712], [-118.39011, 37.36715], [-118.38999, 37.36721], [-118.3899, 37.36729], [-118.38971, 37.3675], [-118.38957, 37.36758], [-118.38942, 37.3676], [-118.38865, 37.3676], [-118.38863, 37.36759], [-118.38861, 37.36726], [-118.38856, 37.36687], [-118.38826, 37.3655], [-118.38822, 37.36523], [-118.38821, 37.36502], [-118.39085, 37.36498], [-118.39086, 37.36628], [-118.3933, 37.36627], [-118.39331, 37.36654], [-118.39517, 37.36652], [-118.39518, 37.3677]]], [[[-118.39051, 37.36954], [-118.38862, 37.36958], [-118.3886, 37.36772], [-118.38935, 37.36771], [-118.38948, 37.36769], [-118.38959, 37.36764], [-118.38969, 37.36757], [-118.38992, 37.36732], [-118.39001, 37.36727], [-118.39012, 37.36724], [-118.39029, 37.36723], [-118.39038, 37.36727], [-118.39046, 37.36732], [-118.3905, 37.36739], [-118.39052, 37.36747], [-118.39051, 37.36954]]]]} | Open Access 1 | 29743 | Bishop Park | 16127 | 1466 | Bishop, City of 1033 | City 2 | City Agency 2 | http://www.ca-bishop.us/departments/parks-and-recreation/ | City 2 | 1466 | Bishop, City of 995 | City 2 | City Agency 2 | Inyo 43 | 50.11 | Bishop Park | 0 | Local Park 2 | 4 | |
12635 | 12635 | 12634 | {"type": "Polygon", "coordinates": [[[-117.36926, 34.42046], [-117.36922, 34.42053], [-117.36874, 34.42025], [-117.36926, 34.42025], [-117.36926, 34.42046]]]} | Open Access 1 | 48796 | Dogwood Park | 33517 | 1687 | Hesperia, City of 1032 | City 2 | City Agency 2 | http://cityofhesperia.us/ | City 2 | 1687 | Hesperia, City of 993 | City 2 | City Agency 2 | San Bernardino 22 | 0.193 | Dogwood Park | 0 | Local Park 2 | 4 | |
14569 | 14569 | 14568 | {"type": "Polygon", "coordinates": [[[-117.34807, 34.39252], [-117.34644, 34.39297], [-117.34644, 34.39241], [-117.34645, 34.3924], [-117.34645, 34.39224], [-117.34644, 34.39223], [-117.34643, 34.39087], [-117.34807, 34.39088], [-117.34807, 34.39252]]]} | Open Access 1 | 44713 | Maple Park | 21781 | 1687 | Hesperia, City of 1032 | City 2 | City Agency 2 | http://cityofhesperia.us/ | City 2 | 1687 | Hesperia, City of 993 | City 2 | City Agency 2 | San Bernardino 22 | 7.717 | Maple Park | 0 | Local Park 2 | 4 | |
12424 | 12424 | 12423 | {"type": "Polygon", "coordinates": [[[-120.46646, 39.8064], [-120.4655, 39.80642], [-120.46531, 39.80634], [-120.46485, 39.8061], [-120.46454, 39.80602], [-120.4642, 39.80597], [-120.46385, 39.80599], [-120.46339, 39.80605], [-120.46378, 39.80554], [-120.46349, 39.80538], [-120.46379, 39.80504], [-120.46357, 39.80482], [-120.46349, 39.80484], [-120.46315, 39.80507], [-120.46279, 39.80499], [-120.46276, 39.80495], [-120.46377, 39.80408], [-120.46384, 39.80406], [-120.46403, 39.80426], [-120.46435, 39.80441], [-120.46472, 39.80457], [-120.46496, 39.80483], [-120.46646, 39.8064]]]} | Open Access 1 | 27030 | Portola City Park | 23905 | 1457 | Portola, City of 1024 | City 2 | City Agency 2 | http://www.ci.portola.ca.us/parks-and-recreation.htm | City 2 | 1457 | Portola, City of 986 | City 2 | City Agency 2 | Plumas 57 | 8.545 | Portola 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]);