units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7,352 rows where AGNCY_LEV = 2 and DES_TP = 2 sorted by id descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 310
- San Diego, City of 277
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 117
- Oakland, City of 99
- Long Beach, City of 99
- Fresno, City of 78
- Modesto, City of 76
- Huntington Beach, City of 74
- Tracy, City of 69
- Santa Rosa, City of 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Bakersfield, City of 56
- Irvine, City of 56
- Manteca, City of 54
- Clovis, City of 52
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- Napa, City of 46
- Fremont, City of 44
- Berkeley, City of 43
- Fullerton, City of 41
- Murrieta, City of 41
- Redding, City of 41
- Corona, City of 40
- …
MNG_AG_TYP 6
ACCESS_TYP 3
- Open Access 7,254
- Restricted Access 60
- No Public Access 38
DES_TP 1
- Local Park · 7,352 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17068 | 17068 | 17067 | {"type": "Polygon", "coordinates": [[[-118.41271, 34.21563], [-118.41251, 34.21562], [-118.41224, 34.21561], [-118.41271, 34.21543], [-118.41278, 34.21558], [-118.41276, 34.21562], [-118.41271, 34.21563]]]} | Open Access 1 | 45531 | Bellaire Avenue Pocket Park | 28362 | 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://cd2.lacity.org/DISTRICT2/CD2Resources/index.htm | Los Angeles 6 | 0.138 | Bellaire Avenue PP | 0 | Local Park 2 | 4 |
17067 | 17067 | 17066 | {"type": "Polygon", "coordinates": [[[-121.76791, 37.22188], [-121.7678, 37.22199], [-121.76752, 37.22184], [-121.76754, 37.22178], [-121.76753, 37.22174], [-121.76718, 37.22154], [-121.76716, 37.22149], [-121.7669, 37.22132], [-121.76693, 37.22126], [-121.76691, 37.2212], [-121.76669, 37.22107], [-121.76666, 37.22107], [-121.76662, 37.22102], [-121.76656, 37.221], [-121.76657, 37.22092], [-121.7663, 37.22076], [-121.7664, 37.22065], [-121.76639, 37.2206], [-121.76615, 37.22045], [-121.76608, 37.22047], [-121.76604, 37.22044], [-121.766, 37.22042], [-121.76602, 37.22032], [-121.76575, 37.22015], [-121.76575, 37.22011], [-121.76572, 37.22006], [-121.76555, 37.21996], [-121.76557, 37.21992], [-121.76558, 37.21988], [-121.76554, 37.21981], [-121.76547, 37.21978], [-121.7655, 37.21972], [-121.76505, 37.21929], [-121.76511, 37.21924], [-121.76512, 37.21917], [-121.7651, 37.21912], [-121.76504, 37.21908], [-121.76508, 37.21899], [-121.76499, 37.2189], [-121.76516, 37.21858], [-121.7651, 37.21845], [-121.76515, 37.21837], [-121.76515, 37.21833], [-121.76513, 37.21829], [-121.76531, 37.21817], [-121.76532, 37.21813], [-121.7652, 37.218], [-121.76492, 37.21776], [-121.76511, 37.21764], [-121.76526, 37.21758], [-121.76544, 37.21754], [-121.7656, 37.21754], [-121.76578, 37.21757], [-121.76662, 37.21783], [-121.76665, 37.21786], [-121.76666, 37.2179], [-121.76663, 37.21795], [-121.76646, 37.2181], [-121.76624, 37.21789], [-121.76568, 37.21816], [-121.76524, 37.21843], [-121.76521, 37.21848], [-121.76521, 37.21852], [-121.76537, 37.21871], [-121.76527, 37.21878], [-121.76516, 37.21883], [-121.76513, 37.21888], [-121.76514, 37.21894], [-121.76518, 37.21899], [-121.76524, 37.21901], [-121.76524, 37.21916], [-121.76537, 37.21936], [-121.7656, 37.21952], [-121.76558, 37.2196], [-121.76562, 37.21966], [-121.76572, 37.21969], [-121.76568, 37.21978], [-121.76593, 37.21995], [-121.76587, 37.22002], [-121.76587, 37.22007], [-121.76613, 37.22022], [-121.76617, 37.22028], [-121.76656, 37.22048], [-121.76652, 37.22054], [-121.76653, 37.2206], [-121.76673, 37.22071], [-121.76668, 37.22075], [-121.76666, 37.22079], [-121.76666, 37.22084], [-121.76669, 37.22089], [-121.76676, 37.22092], [-121.7668, 37.22098], [-121.76706, 37.22114], [-121.76703, 37.22119], [-121.76704, 37.22125], [-121.76727, 37.22139], [-121.76732, 37.22146], [-121.76742, 37.22148], [-121.76741, 37.22151], [-121.76769, 37.22166], [-121.76767, 37.2217], [-121.76768, 37.22174], [-121.76791, 37.22188]]]} | Open Access 1 | 38003 | Pocket Park No. 22 | 23832 | 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 | 3.747 | PP No. 22 | 0 | Local Park 2 | 4 | |
17066 | 17066 | 17065 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75035, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-121.75016, 38.57367], [-121.75028, 38.57367], [-121.75032, 38.57366], [-121.75035, 38.57362], [-121.75065, 38.57367], [-121.75065, 38.57373], [-121.75072, 38.57381]]]} | Open Access 1 | 20971 | Northstar Pocket Park | 22894 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.474 | Northstar PP | 0 | Local Park 2 | 4 | |
17065 | 17065 | 17064 | {"type": "Polygon", "coordinates": [[[-121.7242, 37.95297], [-121.72419, 37.95332], [-121.72412, 37.95332], [-121.72407, 37.9533], [-121.72405, 37.95326], [-121.72406, 37.95297], [-121.7242, 37.95297]]]} | Open Access 1 | 47939 | Giotto Pocket Park | 32097 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 0.112 | Giotto PP | 0 | Local Park 2 | 4 | |
17064 | 17064 | 17063 | {"type": "Polygon", "coordinates": [[[-121.76669, 37.22574], [-121.76663, 37.22596], [-121.76591, 37.22583], [-121.76587, 37.22585], [-121.76581, 37.22583], [-121.76573, 37.22582], [-121.76565, 37.22586], [-121.7653, 37.2258], [-121.76528, 37.22575], [-121.76496, 37.22569], [-121.76491, 37.22572], [-121.76483, 37.22569], [-121.76475, 37.22571], [-121.76399, 37.22558], [-121.76395, 37.22554], [-121.76389, 37.22553], [-121.76383, 37.22553], [-121.76377, 37.22556], [-121.76341, 37.22549], [-121.76336, 37.2254], [-121.76308, 37.22534], [-121.76301, 37.22529], [-121.76293, 37.22528], [-121.76287, 37.2253], [-121.76288, 37.22524], [-121.76284, 37.22519], [-121.7625, 37.22512], [-121.76196, 37.22487], [-121.76201, 37.22481], [-121.76254, 37.22507], [-121.76289, 37.22513], [-121.76293, 37.22519], [-121.76298, 37.22521], [-121.76305, 37.22522], [-121.76311, 37.2252], [-121.76347, 37.22527], [-121.76346, 37.22534], [-121.76349, 37.22538], [-121.76378, 37.22543], [-121.76383, 37.22542], [-121.76391, 37.22546], [-121.764, 37.22546], [-121.76438, 37.22554], [-121.76438, 37.2256], [-121.7647, 37.22566], [-121.76481, 37.2256], [-121.76486, 37.22562], [-121.76494, 37.22562], [-121.76496, 37.22566], [-121.76532, 37.22572], [-121.76535, 37.22577], [-121.76564, 37.22582], [-121.76579, 37.22574], [-121.76585, 37.22575], [-121.76591, 37.22574], [-121.76593, 37.22576], [-121.76628, 37.22582], [-121.76633, 37.22568], [-121.76669, 37.22574]]]} | Open Access 1 | 13735 | Pocket Park No. 23 | 23833 | 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 | 1.085 | PP No. 23 | 0 | Local Park 2 | 4 | |
17063 | 17063 | 17062 | {"type": "Polygon", "coordinates": [[[-121.76351, 37.30514], [-121.76338, 37.30509], [-121.76282, 37.30517], [-121.76274, 37.30486], [-121.76297, 37.30491], [-121.76349, 37.30511], [-121.76351, 37.30514]]]} | Open Access 1 | 13733 | Pocket Park No. 20 | 23830 | 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 | 0.259 | PP No. 20 | 1984 | Local Park 2 | 4 | |
17062 | 17062 | 17061 | {"type": "MultiPolygon", "coordinates": [[[[-121.76611, 37.32191], [-121.76591, 37.32205], [-121.76582, 37.32206], [-121.76254, 37.32081], [-121.7625, 37.32079], [-121.76248, 37.32075], [-121.76251, 37.32068], [-121.76255, 37.32069], [-121.76252, 37.32071], [-121.76252, 37.32075], [-121.76264, 37.3208], [-121.76275, 37.32081], [-121.76562, 37.32189], [-121.76566, 37.32193], [-121.76575, 37.32197], [-121.76579, 37.32197], [-121.76581, 37.32196], [-121.76581, 37.32191], [-121.76595, 37.32167], [-121.76592, 37.32153], [-121.76602, 37.32154], [-121.76611, 37.32191]]], [[[-121.76598, 37.32139], [-121.76582, 37.32138], [-121.76585, 37.32123], [-121.76577, 37.32089], [-121.7656, 37.32091], [-121.76564, 37.32082], [-121.76572, 37.32075], [-121.76571, 37.32068], [-121.76566, 37.32065], [-121.76561, 37.32064], [-121.76556, 37.32066], [-121.76552, 37.3207], [-121.76566, 37.32037], [-121.76558, 37.3201], [-121.76539, 37.32005], [-121.76543, 37.32002], [-121.76552, 37.31999], [-121.76554, 37.31993], [-121.76513, 37.3182], [-121.76416, 37.31835], [-121.76396, 37.31844], [-121.76385, 37.31855], [-121.7638, 37.31837], [-121.76521, 37.31816], [-121.76598, 37.32139]]]]} | Open Access 1 | 9194 | Pocket Park No. 9 | 23839 | 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 | 1.933 | PP No. 9 | 0 | Local Park 2 | 4 | |
17047 | 17047 | 17046 | {"type": "Polygon", "coordinates": [[[-118.343, 33.82914], [-118.34294, 33.82915], [-118.34283, 33.82924], [-118.34276, 33.82926], [-118.34152, 33.82927], [-118.3415, 33.82825], [-118.34253, 33.82892], [-118.343, 33.82914]]]} | Open Access 1 | 46012 | Madrona Marsh Nature Center | 29332 | 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 | http://www.friendsofmadronamarsh.com/index.shtml | Los Angeles 6 | 1.986 | Madrona Marsh Nature Ctr. | 0 | Local Park 2 | 4 |
17046 | 17046 | 17045 | {"type": "Polygon", "coordinates": [[[-116.98325, 32.84955], [-116.98119, 32.84949], [-116.98023, 32.84953], [-116.97857, 32.8501], [-116.97773, 32.85014], [-116.97767, 32.85017], [-116.97709, 32.85032], [-116.97637, 32.85047], [-116.97628, 32.8506], [-116.97625, 32.85068], [-116.97623, 32.85157], [-116.97585, 32.85156], [-116.97579, 32.85151], [-116.97578, 32.8514], [-116.9757, 32.8514], [-116.97573, 32.85042], [-116.97586, 32.85043], [-116.97598, 32.85036], [-116.97605, 32.85025], [-116.9761, 32.85025], [-116.97612, 32.85003], [-116.97621, 32.85], [-116.97672, 32.84995], [-116.97693, 32.84991], [-116.9771, 32.84977], [-116.97717, 32.84964], [-116.97719, 32.84952], [-116.97714, 32.8494], [-116.97705, 32.84933], [-116.97693, 32.84934], [-116.97673, 32.84939], [-116.97602, 32.84946], [-116.97575, 32.84945], [-116.97576, 32.84927], [-116.97623, 32.84927], [-116.97646, 32.84925], [-116.97669, 32.84921], [-116.97701, 32.84909], [-116.9772, 32.84899], [-116.97738, 32.84886], [-116.97816, 32.84818], [-116.97844, 32.84802], [-116.97876, 32.84791], [-116.97914, 32.84784], [-116.98231, 32.84759], [-116.98263, 32.84759], [-116.9832, 32.84764], [-116.98324, 32.84766], [-116.98326, 32.84771], [-116.98325, 32.84955]]]} | Open Access 1 | 45977 | Town Center Community Park | 29131 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=229 | San Diego 4 | 32.677 | Town Ctr. Community Park | 0 | Local Park 2 | 4 |
17045 | 17045 | 17044 | {"type": "Polygon", "coordinates": [[[-117.15886, 33.14153], [-117.15831, 33.14154], [-117.1577, 33.14159], [-117.15768, 33.14153], [-117.1584, 33.14106], [-117.15849, 33.1412], [-117.15861, 33.14133], [-117.15886, 33.14153]]]} | Open Access 1 | 45970 | Civic Center Park | 29119 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/150/1081 | San Diego 4 | 0.729 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
17044 | 17044 | 17043 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24459, 34.05443], [-118.24454, 34.05449], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 45773 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 2.682 | 1st and Broadway Civic Ctr. Park | 0 | Local Park 2 | 4 | |
17037 | 17037 | 17036 | {"type": "Polygon", "coordinates": [[[-122.049, 38.2523], [-122.04898, 38.25324], [-122.04829, 38.25323], [-122.04829, 38.25341], [-122.04822, 38.25341], [-122.04799, 38.2534], [-122.04772, 38.25335], [-122.04706, 38.25312], [-122.04688, 38.25309], [-122.04657, 38.25308], [-122.04598, 38.25321], [-122.04557, 38.25337], [-122.04533, 38.25348], [-122.04532, 38.25288], [-122.04554, 38.25289], [-122.04567, 38.25287], [-122.04568, 38.25245], [-122.04566, 38.25234], [-122.04575, 38.25233], [-122.04575, 38.25227], [-122.04584, 38.25215], [-122.04589, 38.25212], [-122.04666, 38.25213], [-122.0467, 38.2522], [-122.0473, 38.25219], [-122.04727, 38.25226], [-122.04764, 38.25227], [-122.04806, 38.25237], [-122.04832, 38.2524], [-122.04853, 38.25236], [-122.04867, 38.2523], [-122.04873, 38.25226], [-122.04875, 38.25228], [-122.049, 38.2523]]]} | Open Access 1 | 28312 | Civic Center Park | 17356 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 8.233 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
17030 | 17030 | 17029 | {"type": "Polygon", "coordinates": [[[-117.75231, 34.05415], [-117.75118, 34.05418], [-117.75115, 34.05336], [-117.75228, 34.05333], [-117.75231, 34.05415]]]} | Open Access 1 | 48157 | Civic Center Plaza | 32695 | 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/visitors/park-directory/306-no-menu-articles/1798-park-directory-no-menu | Los Angeles 6 | 2.339 | Civic Ctr. Plaza | 0 | Local Park 2 | 4 |
17025 | 17025 | 17024 | {"type": "Polygon", "coordinates": [[[-121.75428, 37.67606], [-121.75112, 37.67601], [-121.75112, 37.67523], [-121.75124, 37.67524], [-121.75125, 37.67523], [-121.75128, 37.67397], [-121.75353, 37.67399], [-121.75398, 37.67351], [-121.75428, 37.67606]]]} | Open Access 1 | 12996 | Civic Center Park | 17360 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 14.935 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
17024 | 17024 | 17023 | {"type": "Polygon", "coordinates": [[[-121.99179, 37.55472], [-121.9905, 37.55623], [-121.9886, 37.55525], [-121.98988, 37.55374], [-121.99179, 37.55472]]]} | Open Access 1 | 12994 | Centerville Community Park | 17042 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 10.034 | Centerville Community Park | 1973 | Local Park 2 | 4 | |
17023 | 17023 | 17022 | {"type": "Polygon", "coordinates": [[[-117.23516, 33.20398], [-117.2347, 33.20423], [-117.23438, 33.20391], [-117.23431, 33.20367], [-117.23415, 33.20336], [-117.23382, 33.20317], [-117.23319, 33.20309], [-117.23308, 33.20329], [-117.23293, 33.20312], [-117.23259, 33.20288], [-117.2323, 33.20278], [-117.23192, 33.20276], [-117.2321, 33.20221], [-117.23237, 33.20244], [-117.23319, 33.20271], [-117.2334, 33.20269], [-117.23376, 33.20281], [-117.23402, 33.20279], [-117.23406, 33.20295], [-117.2342, 33.20294], [-117.23423, 33.20304], [-117.23436, 33.20302], [-117.23441, 33.20304], [-117.23458, 33.20312], [-117.2347, 33.20322], [-117.23465, 33.20338], [-117.23464, 33.20356], [-117.23466, 33.20364], [-117.23471, 33.20374], [-117.23483, 33.2037], [-117.23486, 33.20375], [-117.235, 33.20369], [-117.23516, 33.20398]]]} | Open Access 1 | 12927 | Civic Center Park | 17366 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 3.873 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
17021 | 17021 | 17020 | {"type": "Polygon", "coordinates": [[[-122.03031, 37.53412], [-122.02993, 37.53459], [-122.02988, 37.5346], [-122.02984, 37.53453], [-122.02977, 37.53448], [-122.02963, 37.53446], [-122.0295, 37.5345], [-122.02943, 37.53457], [-122.02943, 37.5346], [-122.02944, 37.53463], [-122.0294, 37.53463], [-122.02782, 37.53381], [-122.02842, 37.5331], [-122.02931, 37.53356], [-122.02929, 37.5336], [-122.03031, 37.53412]]]} | Open Access 1 | 12812 | Civic Center Park | 17361 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 4.39 | Civic Ctr. Park | 1973 | Local Park 2 | 4 | |
17020 | 17020 | 17019 | {"type": "Polygon", "coordinates": [[[-118.35353, 34.02459], [-118.34938, 34.02421], [-118.34938, 34.02163], [-118.35353, 34.02166], [-118.35353, 34.02459]]]} | Open Access 1 | 9393 | Rancho Cienega Sports Center Park | 24134 | 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 | 28.966 | Rancho Cienega Sports Ctr. Park | 0 | Local Park 2 | 4 | |
16980 | 16980 | 16979 | {"type": "Polygon", "coordinates": [[[-121.74766, 38.54637], [-121.74766, 38.54705], [-121.74714, 38.54705], [-121.74712, 38.54786], [-121.74715, 38.54787], [-121.74714, 38.54863], [-121.74764, 38.54864], [-121.74764, 38.54923], [-121.74653, 38.54925], [-121.74642, 38.54856], [-121.74605, 38.54859], [-121.74588, 38.54762], [-121.74559, 38.54661], [-121.7456, 38.54661], [-121.74561, 38.54647], [-121.74565, 38.54641], [-121.74597, 38.54636], [-121.74766, 38.54637]]]} | Open Access 1 | 21021 | Civic Center Park | 17355 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 9.582 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
16939 | 16939 | 16938 | {"type": "Polygon", "coordinates": [[[-117.75925, 33.83512], [-117.75902, 33.83501], [-117.75905, 33.83527], [-117.75901, 33.83542], [-117.75876, 33.83587], [-117.75867, 33.83597], [-117.75863, 33.83596], [-117.75855, 33.83612], [-117.7584, 33.83617], [-117.75822, 33.83657], [-117.75777, 33.83667], [-117.75783, 33.8369], [-117.75747, 33.83742], [-117.75797, 33.83775], [-117.75844, 33.83779], [-117.75899, 33.8384], [-117.7588, 33.83852], [-117.75838, 33.83852], [-117.75767, 33.83848], [-117.75766, 33.83877], [-117.75741, 33.83883], [-117.75722, 33.83893], [-117.75708, 33.83899], [-117.75678, 33.83919], [-117.7564, 33.83885], [-117.75604, 33.83904], [-117.75625, 33.83918], [-117.75575, 33.83918], [-117.75561, 33.83901], [-117.75552, 33.83882], [-117.75549, 33.83868], [-117.75555, 33.83836], [-117.75555, 33.83827], [-117.75551, 33.83816], [-117.75537, 33.83814], [-117.75402, 33.83827], [-117.75383, 33.83834], [-117.7536, 33.83821], [-117.75039, 33.83796], [-117.74954, 33.83782], [-117.74881, 33.83817], [-117.74873, 33.83822], [-117.74829, 33.83792], [-117.74822, 33.83784], [-117.74908, 33.83672], [-117.74895, 33.83667], [-117.74914, 33.83659], [-117.75055, 33.83685], [-117.75117, 33.83657], [-117.75182, 33.83693], [-117.75247, 33.83692], [-117.75296, 33.83669], [-117.75324, 33.83602], [-117.7534, 33.83596], [-117.75389, 33.83609], [-117.75478, 33.83609], [-117.75501, 33.83575], [-117.75632, 33.83536], [-117.75675, 33.83559], [-117.75707, 33.83506], [-117.75724, 33.83437], [-117.75849, 33.83402], [-117.75907, 33.83465], [-117.75915, 33.83478], [-117.75921, 33.83494], [-117.75925, 33.83512]]]} | Open Access 1 | 6042 | Oak Canyon Nature Center | 22958 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 58.559 | Oak Canyon Nature Ctr. | 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]);