units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,084 rows where ACCESS_TYP = 1 and DES_TP = 2 sorted by id descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 15
- City Agency 7,297
- Recreation/Parks District 659
- County Agency 641
- Community Services District 172
- County Agency - Parks 146
- Open Space District 69
- Water District 37
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
DES_TP 1
- Local Park · 9,084 ✖
ACCESS_TYP 1
- Open Access · 9,084 ✖
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 |
17029 | 17029 | 17028 | {"type": "MultiPolygon", "coordinates": [[[[-118.10512, 34.19263], [-118.10495, 34.19317], [-118.1048, 34.19329], [-118.10424, 34.19328], [-118.10399, 34.19293], [-118.10371, 34.19231], [-118.10354, 34.19237], [-118.1038, 34.193], [-118.104, 34.19328], [-118.10044, 34.19324], [-118.10041, 34.1896], [-118.10041, 34.18951], [-118.10037, 34.18595], [-118.10038, 34.18582], [-118.10173, 34.18646], [-118.10183, 34.18719], [-118.1017, 34.1876], [-118.10216, 34.18872], [-118.10269, 34.18896], [-118.10291, 34.18931], [-118.10293, 34.18951], [-118.10319, 34.19046], [-118.10314, 34.19063], [-118.10327, 34.19076], [-118.10336, 34.19121], [-118.10395, 34.19177], [-118.10426, 34.19224], [-118.10479, 34.19236], [-118.10512, 34.19263]]], [[[-118.10571, 34.19254], [-118.10563, 34.19268], [-118.10553, 34.1927], [-118.10502, 34.19312], [-118.10516, 34.19262], [-118.10481, 34.19233], [-118.10428, 34.19222], [-118.10398, 34.19175], [-118.10339, 34.1912], [-118.10331, 34.19075], [-118.10319, 34.19062], [-118.10324, 34.19046], [-118.10298, 34.18951], [-118.10295, 34.1893], [-118.10272, 34.18893], [-118.1022, 34.1887], [-118.10175, 34.18759], [-118.10186, 34.1872], [-118.10176, 34.18644], [-118.10069, 34.18594], [-118.10038, 34.18578], [-118.10038, 34.18574], [-118.10068, 34.18593], [-118.10069, 34.18592], [-118.10079, 34.18485], [-118.10155, 34.18475], [-118.101, 34.18412], [-118.10077, 34.18394], [-118.10058, 34.18376], [-118.10078, 34.1839], [-118.10092, 34.18397], [-118.10117, 34.18406], [-118.10152, 34.18424], [-118.10166, 34.18435], [-118.10214, 34.1848], [-118.10237, 34.18498], [-118.10214, 34.18519], [-118.10241, 34.18574], [-118.10243, 34.18574], [-118.10251, 34.18568], [-118.10281, 34.18591], [-118.10321, 34.18648], [-118.10296, 34.18664], [-118.10296, 34.18666], [-118.10326, 34.18664], [-118.10359, 34.18659], [-118.10361, 34.18666], [-118.10381, 34.18697], [-118.10372, 34.18768], [-118.10397, 34.18819], [-118.10412, 34.18822], [-118.10441, 34.18852], [-118.10486, 34.18921], [-118.10493, 34.18974], [-118.10492, 34.19033], [-118.10482, 34.19037], [-118.10459, 34.19071], [-118.10473, 34.19087], [-118.10491, 34.19087], [-118.10491, 34.19109], [-118.10516, 34.19141], [-118.10541, 34.19194], [-118.10545, 34.19211], [-118.10571, 34.19254]]], [[[-118.10683, 34.19331], [-118.1061, 34.19332], [-118.10604, 34.1933], [-118.1053, 34.1933], [-118.10529, 34.19326], [-118.10508, 34.1933], [-118.10505, 34.19327], [-118.10561, 34.19283], [-118.10575, 34.1928], [-118.10589, 34.19253], [-118.10561, 34.19205], [-118.10558, 34.19192], [-118.10588, 34.19227], [-118.10683, 34.19331]]]]} | Open Access 1 | 48133 | Eaton Canyon Natural Area Park and Nature Center | 32658 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.ecnca.org/index.php | Los Angeles 6 | 82.896 | Eaton Canyon Natural Area Park and Nature Ctr. | 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 | |
17017 | 17017 | 17016 | {"type": "MultiPolygon", "coordinates": [[[[-118.10156, 34.18475], [-118.1008, 34.18486], [-118.1007, 34.18593], [-118.10039, 34.18575], [-118.10038, 34.18576], [-118.10037, 34.18595], [-118.10041, 34.18951], [-118.1004, 34.1896], [-118.09806, 34.18965], [-118.09618, 34.18821], [-118.09612, 34.18598], [-118.09188, 34.186], [-118.0919, 34.17883], [-118.09425, 34.17882], [-118.09598, 34.17883], [-118.09472, 34.17564], [-118.095, 34.17563], [-118.095, 34.1751], [-118.0952, 34.17514], [-118.09529, 34.17462], [-118.09552, 34.17451], [-118.09553, 34.17441], [-118.09556, 34.17438], [-118.096, 34.17451], [-118.0963, 34.17458], [-118.0966, 34.17462], [-118.09735, 34.17467], [-118.09735, 34.17469], [-118.09724, 34.17474], [-118.0973, 34.17531], [-118.0973, 34.17546], [-118.09742, 34.17563], [-118.09812, 34.17563], [-118.09812, 34.17567], [-118.09827, 34.1761], [-118.09855, 34.17677], [-118.09828, 34.17669], [-118.09828, 34.17665], [-118.09822, 34.1766], [-118.09806, 34.17661], [-118.09803, 34.17666], [-118.09817, 34.17702], [-118.09822, 34.17749], [-118.09827, 34.1775], [-118.09829, 34.1776], [-118.09819, 34.17809], [-118.09804, 34.17842], [-118.09806, 34.17847], [-118.09814, 34.17849], [-118.09824, 34.17891], [-118.09818, 34.17925], [-118.09819, 34.1794], [-118.09817, 34.17958], [-118.09818, 34.17959], [-118.09813, 34.17978], [-118.09811, 34.17978], [-118.09805, 34.17985], [-118.09789, 34.17993], [-118.09776, 34.18009], [-118.0974, 34.18047], [-118.09716, 34.1806], [-118.09696, 34.18069], [-118.09695, 34.18097], [-118.097, 34.18107], [-118.0971, 34.18105], [-118.09726, 34.18112], [-118.09779, 34.18149], [-118.09804, 34.1817], [-118.09816, 34.18183], [-118.09834, 34.18194], [-118.09875, 34.18243], [-118.09879, 34.18251], [-118.099, 34.18272], [-118.09933, 34.18299], [-118.09947, 34.18335], [-118.09974, 34.18362], [-118.10002, 34.18381], [-118.10031, 34.18382], [-118.1005, 34.18368], [-118.10076, 34.18394], [-118.10099, 34.18413], [-118.10156, 34.18475]]], [[[-118.09392, 34.1864], [-118.0919, 34.18641], [-118.09189, 34.18612], [-118.09392, 34.18611], [-118.09392, 34.1864]]], [[[-118.09393, 34.18671], [-118.09191, 34.18672], [-118.0919, 34.18643], [-118.09392, 34.18642], [-118.09393, 34.18671]]], [[[-118.09305, 34.18714], [-118.09192, 34.18714], [-118.09191, 34.18686], [-118.09304, 34.18685], [-118.09305, 34.18714]]], [[[-118.09394, 34.18744], [-118.09193, 34.18746], [-118.09192, 34.18717], [-118.09394, 34.18716], [-118.09394, 34.18744]]], [[[-118.09395, 34.18787], [-118.09194, 34.18788], [-118.09194, 34.18759], [-118.09395, 34.18758], [-118.09395, 34.18787]]], [[[-118.09396, 34.18818], [-118.09195, 34.18819], [-118.09194, 34.18791], [-118.09395, 34.1879], [-118.09396, 34.18818]]], [[[-118.09213, 34.18861], [-118.09197, 34.18862], [-118.09196, 34.18833], [-118.09212, 34.18833], [-118.09213, 34.18861]]], [[[-118.09214, 34.18893], [-118.09198, 34.18893], [-118.09197, 34.18864], [-118.09214, 34.18864], [-118.09214, 34.18893]]], [[[-118.09273, 34.18906], [-118.09248, 34.18915], [-118.09206, 34.18926], [-118.09199, 34.1893], [-118.09198, 34.18907], [-118.09273, 34.18906]]], [[[-118.09338, 34.18967], [-118.092, 34.1897], [-118.09199, 34.18949], [-118.09206, 34.18953], [-118.09215, 34.18954], [-118.09283, 34.1894], [-118.09297, 34.18939], [-118.09306, 34.18942], [-118.09313, 34.18946], [-118.09329, 34.18962], [-118.09338, 34.18967]]], [[[-118.09245, 34.18861], [-118.09237, 34.18861], [-118.09236, 34.18833], [-118.09244, 34.18833], [-118.09245, 34.18861]]], [[[-118.09269, 34.18861], [-118.09253, 34.18861], [-118.09252, 34.18833], [-118.09268, 34.18833], [-118.09269, 34.18861]]], [[[-118.0927, 34.18892], [-118.09254, 34.18893], [-118.09253, 34.18864], [-118.09269, 34.18864], [-118.0927, 34.18892]]], [[[-118.09347, 34.18934], [-118.09327, 34.18934], [-118.09313, 34.18927], [-118.09297, 34.18923], [-118.09284, 34.18923], [-118.09268, 34.18926], [-118.09318, 34.18908], [-118.09322, 34.18911], [-118.09334, 34.18928], [-118.09347, 34.18934]]], [[[-118.09302, 34.18892], [-118.09294, 34.18892], [-118.09293, 34.18864], [-118.09301, 34.18864], [-118.09302, 34.18892]]], [[[-118.09357, 34.18861], [-118.09309, 34.18861], [-118.09308, 34.18832], [-118.09356, 34.18832], [-118.09357, 34.18861]]], [[[-118.09342, 34.18892], [-118.09318, 34.18891], [-118.09317, 34.18864], [-118.09341, 34.18863], [-118.09342, 34.18892]]], [[[-118.09329, 34.18714], [-118.09321, 34.18714], [-118.09321, 34.18685], [-118.09329, 34.18685], [-118.09329, 34.18714]]], [[[-118.09398, 34.18937], [-118.0937, 34.18954], [-118.09358, 34.18956], [-118.0935, 34.18954], [-118.09344, 34.18951], [-118.0933, 34.18937], [-118.09398, 34.18937]]], [[[-118.09368, 34.18906], [-118.09358, 34.18917], [-118.09354, 34.18918], [-118.09348, 34.18916], [-118.09342, 34.18906], [-118.09368, 34.18906]]], [[[-118.09394, 34.18713], [-118.09345, 34.18713], [-118.09345, 34.18685], [-118.09393, 34.18685], [-118.09394, 34.18713]]], [[[-118.09398, 34.18934], [-118.09398, 34.18934], [-118.0936, 34.18934], [-118.09372, 34.18928], [-118.09388, 34.1891], [-118.09395, 34.18905], [-118.09398, 34.18905], [-118.09398, 34.18934]]], [[[-118.09389, 34.1886], [-118.09365, 34.18861], [-118.09364, 34.18832], [-118.09388, 34.18832], [-118.09389, 34.1886]]], [[[-118.09399, 34.18966], [-118.09399, 34.18966], [-118.09383, 34.18966], [-118.09399, 34.18956], [-118.09399, 34.18966]]], [[[-118.09607, 34.18638], [-118.09409, 34.18639], [-118.09408, 34.18611], [-118.09607, 34.1861], [-118.09607, 34.18638]]], [[[-118.09608, 34.1867], [-118.09409, 34.18671], [-118.09409, 34.18642], [-118.09607, 34.18641], [-118.09608, 34.1867]]], [[[-118.09609, 34.18712], [-118.0941, 34.18713], [-118.0941, 34.18684], [-118.09608, 34.18683], [-118.09609, 34.18712]]], [[[-118.09609, 34.18743], [-118.09411, 34.18744], [-118.0941, 34.18716], [-118.09609, 34.18715], [-118.09609, 34.18743]]], [[[-118.0961, 34.18786], [-118.09412, 34.18787], [-118.09411, 34.18758], [-118.0961, 34.18757], [-118.0961, 34.18786]]], [[[-118.09611, 34.18817], [-118.09412, 34.18818], [-118.09412, 34.18789], [-118.0961, 34.18788], [-118.09611, 34.18817]]], [[[-118.09612, 34.18859], [-118.09413, 34.1886], [-118.09413, 34.18832], [-118.09611, 34.18831], [-118.09612, 34.18859]]], [[[-118.09612, 34.18891], [-118.09506, 34.18891], [-118.0949, 34.18883], [-118.09481, 34.18881], [-118.09451, 34.18881], [-118.0944, 34.18874], [-118.09431, 34.18872], [-118.09421, 34.18874], [-118.09414, 34.18879], [-118.09414, 34.18863], [-118.09612, 34.18862], [-118.09612, 34.18891]]], [[[-118.09509, 34.18909], [-118.09497, 34.18921], [-118.09495, 34.18927], [-118.09496, 34.18933], [-118.09415, 34.18934], [-118.09414, 34.18905], [-118.09494, 34.18905], [-118.09509, 34.18909]]], [[[-118.0942, 34.18966], [-118.09416, 34.18966], [-118.09415, 34.18951], [-118.09421, 34.18956], [-118.0942, 34.18966]]], [[[-118.09614, 34.18962], [-118.0944, 34.18965], [-118.09441, 34.18957], [-118.09439, 34.18949], [-118.09433, 34.18942], [-118.09425, 34.18937], [-118.09497, 34.18936], [-118.09506, 34.18945], [-118.09516, 34.18948], [-118.09614, 34.18951], [-118.09614, 34.18962]]], [[[-118.09435, 34.18891], [-118.09434, 34.18891], [-118.09426, 34.18892], [-118.09431, 34.18888], [-118.09435, 34.18891]]], [[[-118.09613, 34.18933], [-118.09554, 34.18933], [-118.09518, 34.18932], [-118.09515, 34.18929], [-118.09527, 34.18915], [-118.09529, 34.1891], [-118.09528, 34.18905], [-118.09613, 34.18904], [-118.09613, 34.18933]]]]} | Open Access 1 | 6970 | Eaton Canyon Natural Area and Nature Center | 32480 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Eaton_Canyon_Park_Nature_Center | Los Angeles 6 | 219.218 | Eaton Canyon Natural Area and 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]);