units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 297 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, PARK_URL, LABEL_NAME
DES_TP 8
- Local Park 29
- Local Recreation Area 2
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
LAYER 2 ✖
- City 34
- Special District 3
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 37
MNG_AGENCY 1
- Pasadena, City of · 37 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
988 | 988 | 987 | {"type": "Polygon", "coordinates": [[[-118.16985, 34.14278], [-118.16959, 34.14308], [-118.1692, 34.14334], [-118.16812, 34.14389], [-118.16797, 34.14398], [-118.16783, 34.14409], [-118.16766, 34.14428], [-118.16757, 34.14447], [-118.16748, 34.14453], [-118.16747, 34.14456], [-118.16743, 34.14456], [-118.16743, 34.14473], [-118.16701, 34.14491], [-118.16598, 34.14528], [-118.16486, 34.14554], [-118.16403, 34.14571], [-118.16402, 34.14556], [-118.16404, 34.14544], [-118.1641, 34.1453], [-118.16419, 34.14519], [-118.16428, 34.14512], [-118.16515, 34.14459], [-118.16533, 34.14444], [-118.16541, 34.14433], [-118.16551, 34.14411], [-118.16558, 34.14335], [-118.1656, 34.14328], [-118.16613, 34.1424], [-118.16615, 34.14233], [-118.16613, 34.14214], [-118.16591, 34.14174], [-118.16589, 34.14167], [-118.16589, 34.14157], [-118.16591, 34.14151], [-118.16606, 34.14124], [-118.16607, 34.14115], [-118.16607, 34.14105], [-118.1656, 34.13996], [-118.16556, 34.13981], [-118.16569, 34.13877], [-118.16576, 34.13856], [-118.16585, 34.13845], [-118.166, 34.13833], [-118.16666, 34.13793], [-118.16678, 34.13779], [-118.16682, 34.13771], [-118.16684, 34.13761], [-118.16684, 34.13752], [-118.16682, 34.13742], [-118.16671, 34.13726], [-118.16659, 34.13716], [-118.1661, 34.13689], [-118.16602, 34.13681], [-118.16598, 34.13671], [-118.16598, 34.13664], [-118.16611, 34.13577], [-118.16644, 34.13491], [-118.16646, 34.13481], [-118.16646, 34.13471], [-118.16642, 34.13456], [-118.16634, 34.13443], [-118.16626, 34.13433], [-118.16578, 34.13391], [-118.16573, 34.13382], [-118.16581, 34.13304], [-118.16564, 34.13214], [-118.16555, 34.1319], [-118.16536, 34.1316], [-118.16529, 34.13139], [-118.1653, 34.13116], [-118.16542, 34.13071], [-118.16542, 34.13059], [-118.1654, 34.13049], [-118.16534, 34.13039], [-118.16527, 34.1303], [-118.16518, 34.13022], [-118.16506, 34.13016], [-118.16483, 34.13011], [-118.16456, 34.13012], [-118.16442, 34.13011], [-118.16424, 34.13006], [-118.16409, 34.12997], [-118.16398, 34.12986], [-118.1639, 34.12972], [-118.16384, 34.12955], [-118.16381, 34.12933], [-118.16382, 34.12903], [-118.16402, 34.12903], [-118.16405, 34.12891], [-118.16437, 34.12886], [-118.16506, 34.12835], [-118.16531, 34.12795], [-118.16536, 34.12778], [-118.16532, 34.12752], [-118.16499, 34.12685], [-118.16502, 34.12674], [-118.16504, 34.12646], [-118.16507, 34.12645], [-118.16507, 34.12641], [-118.16505, 34.12638], [-118.1651, 34.12619], [-118.16509, 34.12614], [-118.16505, 34.12609], [-118.16513, 34.12588], [-118.16507, 34.12587], [-118.16505, 34.12581], [-118.16462, 34.12585], [-118.16484, 34.12532], [-118.16506, 34.12514], [-118.16515, 34.12512], [-118.16525, 34.12517], [-118.16544, 34.12546], [-118.16553, 34.12537], [-118.16545, 34.12525], [-118.16538, 34.12509], [-118.16537, 34.12497], [-118.1654, 34.1248], [-118.16542, 34.12479], [-118.16544, 34.12471], [-118.16553, 34.12461], [-118.16584, 34.12415], [-118.16596, 34.12389], [-118.16846, 34.12391], [-118.16826, 34.1243], [-118.16759, 34.12497], [-118.16575, 34.12557], [-118.16552, 34.12605], [-118.16541, 34.12683], [-118.16549, 34.12767], [-118.16552, 34.12776], [-118.16564, 34.128], [-118.16585, 34.12801], [-118.16587, 34.12805], [-118.16584, 34.12837], [-118.16604, 34.12835], [-118.16616, 34.12892], [-118.16595, 34.12897], [-118.16594, 34.12898], [-118.16624, 34.12913], [-118.16639, 34.13092], [-118.16639, 34.13094], [-118.16636, 34.13096], [-118.16666, 34.13196], [-118.16705, 34.13273], [-118.1671, 34.13311], [-118.16706, 34.1333], [-118.16754, 34.1338], [-118.16754, 34.13383], [-118.16723, 34.13398], [-118.16712, 34.13413], [-118.16715, 34.13414], [-118.16721, 34.13412], [-118.16724, 34.13413], [-118.16755, 34.13429], [-118.16762, 34.13446], [-118.16768, 34.13452], [-118.16766, 34.13509], [-118.16837, 34.1355], [-118.16855, 34.13571], [-118.16872, 34.13602], [-118.16884, 34.13656], [-118.16889, 34.13656], [-118.16891, 34.13668], [-118.16837, 34.13746], [-118.169, 34.13787], [-118.16919, 34.13784], [-118.16922, 34.13785], [-118.16876, 34.13917], [-118.16873, 34.13919], [-118.16877, 34.13967], [-118.1689, 34.13966], [-118.16894, 34.14009], [-118.1686, 34.14034], [-118.16919, 34.14068], [-118.16966, 34.14199], [-118.16984, 34.14255], [-118.16985, 34.14278]]]} | Open Access 1 | 6717 | Lower Arroyo Seco | 21558 | 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 | 112.416 | Lower Arroyo Seco | None 89 | |||
1154 | 1154 | 1153 | {"type": "Polygon", "coordinates": [[[-118.14408, 34.15668], [-118.14265, 34.15668], [-118.14265, 34.15622], [-118.14284, 34.15621], [-118.14285, 34.15613], [-118.14291, 34.15613], [-118.14291, 34.15598], [-118.14264, 34.15598], [-118.14215, 34.15539], [-118.14226, 34.15475], [-118.14218, 34.15474], [-118.14218, 34.15442], [-118.14162, 34.15442], [-118.14161, 34.15425], [-118.14406, 34.15423], [-118.14408, 34.15668]]]} | Open Access 1 | 6753 | Villa Parke | 27105 | 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/HumanServices/VillaParke_Community_Center/ | Los Angeles 6 | 10.546 | Villa Parke | None 103 | ||
4381 | 4381 | 4380 | {"type": "Polygon", "coordinates": [[[-118.16393, 34.16098], [-118.16379, 34.16061], [-118.16342, 34.15865], [-118.16335, 34.15813], [-118.16386, 34.15794], [-118.16423, 34.15776], [-118.16566, 34.15687], [-118.16598, 34.15672], [-118.16632, 34.15661], [-118.16677, 34.15651], [-118.16715, 34.15641], [-118.16734, 34.15642], [-118.16744, 34.15645], [-118.16752, 34.15651], [-118.1676, 34.15659], [-118.16774, 34.15703], [-118.16775, 34.1572], [-118.16774, 34.15747], [-118.16767, 34.15782], [-118.16758, 34.15807], [-118.16741, 34.1584], [-118.16725, 34.15863], [-118.16712, 34.15877], [-118.16692, 34.15898], [-118.16652, 34.15927], [-118.16623, 34.15943], [-118.16566, 34.15966], [-118.16538, 34.15979], [-118.1652, 34.15989], [-118.16452, 34.16034], [-118.1643, 34.16053], [-118.16407, 34.1608], [-118.16393, 34.16098]]]} | Open Access 1 | 45943 | Brookside Park Area H | 29050 | 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 | 27.409 | Brookside Park Area H | None 390 | |||
7372 | 7372 | 7371 | {"type": "MultiPolygon", "coordinates": [[[[-118.16562, 34.20453], [-118.16512, 34.20421], [-118.1647, 34.20441], [-118.16469, 34.20459], [-118.16449, 34.20462], [-118.16415, 34.20437], [-118.16396, 34.20489], [-118.16291, 34.20463], [-118.1636, 34.20418], [-118.16413, 34.20406], [-118.16444, 34.20406], [-118.16559, 34.20393], [-118.16562, 34.20453]]], [[[-118.18394, 34.21609], [-118.18386, 34.21709], [-118.1839, 34.2171], [-118.18375, 34.21832], [-118.18361, 34.21831], [-118.1833, 34.21852], [-118.18323, 34.21871], [-118.18306, 34.21874], [-118.18288, 34.21881], [-118.18278, 34.2188], [-118.18269, 34.21882], [-118.18265, 34.21882], [-118.18257, 34.21876], [-118.18237, 34.21875], [-118.18151, 34.21832], [-118.18112, 34.21818], [-118.18111, 34.21819], [-118.18123, 34.21936], [-118.17894, 34.21936], [-118.17872, 34.21537], [-118.17019, 34.21543], [-118.16438, 34.21525], [-118.16441, 34.21524], [-118.16442, 34.21512], [-118.16438, 34.215], [-118.1645, 34.21494], [-118.16499, 34.21503], [-118.16511, 34.21494], [-118.16511, 34.21492], [-118.165, 34.21484], [-118.16499, 34.21476], [-118.16492, 34.21461], [-118.16505, 34.21441], [-118.16514, 34.21438], [-118.16519, 34.21423], [-118.16563, 34.21397], [-118.16582, 34.2139], [-118.16595, 34.21378], [-118.16602, 34.21376], [-118.16601, 34.21372], [-118.16592, 34.21374], [-118.1658, 34.21388], [-118.16561, 34.21393], [-118.16515, 34.2142], [-118.16511, 34.21436], [-118.16502, 34.21438], [-118.16487, 34.21461], [-118.16496, 34.21476], [-118.16495, 34.21485], [-118.16506, 34.21493], [-118.16498, 34.21499], [-118.1645, 34.21492], [-118.16434, 34.21499], [-118.16438, 34.21512], [-118.16437, 34.21522], [-118.16432, 34.21525], [-118.16343, 34.21522], [-118.16422, 34.21454], [-118.16473, 34.2138], [-118.16493, 34.21327], [-118.16485, 34.21315], [-118.16487, 34.21311], [-118.16482, 34.21311], [-118.16477, 34.21303], [-118.16526, 34.2125], [-118.16524, 34.21243], [-118.16497, 34.21225], [-118.16499, 34.21222], [-118.16503, 34.2122], [-118.16535, 34.21241], [-118.16595, 34.21177], [-118.16663, 34.21178], [-118.16664, 34.21181], [-118.16699, 34.21181], [-118.16724, 34.21175], [-118.16715, 34.21119], [-118.16691, 34.21101], [-118.16605, 34.21001], [-118.16603, 34.20808], [-118.17027, 34.20819], [-118.17026, 34.20534], [-118.17077, 34.20528], [-118.17097, 34.20533], [-118.17119, 34.20528], [-118.17147, 34.20544], [-118.17168, 34.20549], [-118.17235, 34.20573], [-118.1724, 34.20611], [-118.17288, 34.20616], [-118.17353, 34.20606], [-118.17367, 34.20615], [-118.17369, 34.20626], [-118.17367, 34.20632], [-118.17371, 34.20641], [-118.1737, 34.20648], [-118.17365, 34.20653], [-118.17364, 34.2066], [-118.17362, 34.20662], [-118.17336, 34.20689], [-118.17337, 34.2069], [-118.17344, 34.20693], [-118.17386, 34.20671], [-118.17398, 34.20675], [-118.1741, 34.20684], [-118.17413, 34.2069], [-118.17419, 34.2069], [-118.17424, 34.20693], [-118.17474, 34.20652], [-118.1749, 34.20677], [-118.17491, 34.20684], [-118.17487, 34.20696], [-118.17494, 34.20713], [-118.17494, 34.2072], [-118.17487, 34.2074], [-118.17487, 34.20748], [-118.1748, 34.20758], [-118.17481, 34.20759], [-118.17495, 34.20752], [-118.17497, 34.20757], [-118.17499, 34.20757], [-118.17505, 34.20763], [-118.17515, 34.20791], [-118.17503, 34.20803], [-118.17508, 34.20807], [-118.17528, 34.20791], [-118.17527, 34.20789], [-118.17536, 34.20777], [-118.17558, 34.20773], [-118.1756, 34.2077], [-118.17579, 34.20768], [-118.17582, 34.20775], [-118.17575, 34.20777], [-118.17581, 34.2079], [-118.17579, 34.20822], [-118.1762, 34.20876], [-118.17648, 34.20932], [-118.1765, 34.21035], [-118.17613, 34.21084], [-118.17602, 34.21087], [-118.17571, 34.21084], [-118.17541, 34.21071], [-118.17533, 34.21038], [-118.17512, 34.21028], [-118.17494, 34.21108], [-118.17481, 34.21119], [-118.1746, 34.21121], [-118.1746, 34.21124], [-118.17464, 34.21126], [-118.17464, 34.21128], [-118.17482, 34.21138], [-118.17485, 34.21137], [-118.17506, 34.21151], [-118.17513, 34.21164], [-118.17542, 34.21174], [-118.17566, 34.212], [-118.17571, 34.21207], [-118.17574, 34.21208], [-118.17593, 34.21194], [-118.17597, 34.21139], [-118.17605, 34.21137], [-118.17663, 34.21177], [-118.17667, 34.21197], [-118.17666, 34.21203], [-118.1767, 34.21209], [-118.17696, 34.21211], [-118.17729, 34.21217], [-118.17759, 34.21207], [-118.17774, 34.21242], [-118.17797, 34.21278], [-118.1777, 34.21291], [-118.17792, 34.21332], [-118.17798, 34.21339], [-118.17792, 34.2137], [-118.1779, 34.21369], [-118.17775, 34.21372], [-118.1778, 34.21382], [-118.17768, 34.21416], [-118.17838, 34.21445], [-118.1792, 34.21461], [-118.17982, 34.21489], [-118.17984, 34.21533], [-118.18011, 34.21543], [-118.18142, 34.21534], [-118.18231, 34.21574], [-118.18242, 34.21575], [-118.18255, 34.21579], [-118.18394, 34.21609]], [[-118.17123, 34.20986], [-118.1712, 34.20974], [-118.17115, 34.20968], [-118.17071, 34.20923], [-118.17026, 34.20954], [-118.17026, 34.21027], [-118.17128, 34.21028], [-118.17123, 34.20986]]], [[[-118.18482, 34.22101], [-118.1848, 34.22262], [-118.1791, 34.22258], [-118.17898, 34.22018], [-118.18185, 34.22018], [-118.18482, 34.22101]]], [[[-118.18938, 34.22352], [-118.18785, 34.2249], [-118.18778, 34.22497], [-118.18771, 34.22512], [-118.18768, 34.22526], [-118.18768, 34.22539], [-118.18773, 34.22556], [-118.18781, 34.22569], [-118.18809, 34.22598], [-118.18817, 34.22613], [-118.1882, 34.22624], [-118.18819, 34.22647], [-118.18816, 34.22657], [-118.1881, 34.22668], [-118.18802, 34.22678], [-118.18784, 34.22691], [-118.18764, 34.227], [-118.1875, 34.22702], [-118.18729, 34.22703], [-118.18694, 34.22699], [-118.18699, 34.22264], [-118.18887, 34.22266], [-118.18897, 34.22279], [-118.18896, 34.22332], [-118.18907, 34.22347], [-118.18938, 34.22352]]], [[[-118.18963, 34.23825], [-118.18961, 34.23842], [-118.18953, 34.23862], [-118.18943, 34.23874], [-118.18926, 34.23887], [-118.18926, 34.23796], [-118.18677, 34.23787], [-118.18677, 34.23764], [-118.18864, 34.23751], [-118.18891, 34.23753], [-118.18912, 34.23759], [-118.18927, 34.23767], [-118.18946, 34.23783], [-118.18953, 34.23792], [-118.18958, 34.23802], [-118.18962, 34.23814], [-118.18963, 34.23825]]], [[[-118.19823, 34.23605], [-118.19821, 34.23679], [-118.19551, 34.2366], [-118.19546, 34.23975], [-118.18926, 34.23952], [-118.18926, 34.23919], [-118.18946, 34.2391], [-118.18958, 34.23901], [-118.18973, 34.23887], [-118.18987, 34.23865], [-118.18995, 34.23842], [-118.18995, 34.23817], [-118.1899, 34.23794], [-118.18979, 34.23774], [-118.18962, 34.23756], [-118.18949, 34.23746], [-118.18927, 34.23734], [-118.18909, 34.23728], [-118.18883, 34.23724], [-118.18862, 34.23724], [-118.18677, 34.23737], [-118.18677, 34.23596], [-118.18693, 34.22908], [-118.18695, 34.22727], [-118.18743, 34.2273], [-118.18762, 34.22728], [-118.18777, 34.22725], [-118.18794, 34.22718], [-118.18817, 34.22704], [-118.18826, 34.22697], [-118.18839, 34.2268], [-118.18847, 34.22667], [-118.18853, 34.22646], [-118.18854, 34.22635], [-118.18853, 34.22619], [-118.18847, 34.22601], [-118.1884, 34.22589], [-118.18828, 34.22574], [-118.18807, 34.22553], [-118.18804, 34.22547], [-118.188, 34.22532], [-118.18804, 34.22518], [-118.18812, 34.22505], [-118.18823, 34.22497], [-118.18835, 34.22492], [-118.18864, 34.22486], [-118.18874, 34.22481], [-118.18888, 34.22474], [-118.189, 34.22463], [-118.18912, 34.22448], [-118.18927, 34.22418], [-118.1894, 34.22397], [-118.1895, 34.22383], [-118.18973, 34.2236], [-118.18985, 34.22364], [-118.1901, 34.22408], [-118.1902, 34.22456], [-118.19089, 34.22522], [-118.19102, 34.22579], [-118.19124, 34.2263], [-118.19142, 34.22655], [-118.19128, 34.22689], [-118.19122, 34.22697], [-118.19087, 34.22755], [-118.19045, 34.22794], [-118.1907, 34.22869], [-118.19068, 34.22897], [-118.19049, 34.22946], [-118.19034, 34.22997], [-118.19023, 34.23063], [-118.19002, 34.23112], [-118.19052, 34.23146], [-118.19066, 34.23154], [-118.19183, 34.23195], [-118.19227, 34.2322], [-118.19305, 34.23271], [-118.19361, 34.23283], [-118.1939, 34.23294], [-118.19405, 34.23313], [-118.19429, 34.23327], [-118.19458, 34.23332], [-118.19476, 34.23338], [-118.19596, 34.23332], [-118.19682, 34.23489], [-118.19727, 34.23504], [-118.19752, 34.23521], [-118.19823, 34.23605]]], [[[-118.19542, 34.24291], [-118.19527, 34.25152], [-118.19526, 34.25152], [-118.1944, 34.25063], [-118.19425, 34.2504], [-118.19421, 34.25024], [-118.19419, 34.25013], [-118.1942, 34.24997], [-118.19427, 34.24977], [-118.19434, 34.24964], [-118.1946, 34.24935], [-118.19468, 34.24918], [-118.19471, 34.24908], [-118.19474, 34.24889], [-118.19474, 34.24875], [-118.19471, 34.24862], [-118.19463, 34.24862], [-118.19458, 34.24849], [-118.19446, 34.24831], [-118.19429, 34.24815], [-118.19412, 34.24805], [-118.19378, 34.24794], [-118.19273, 34.2478], [-118.19261, 34.24777], [-118.19246, 34.2477], [-118.19227, 34.24755], [-118.19067, 34.24564], [-118.19059, 34.24547], [-118.19058, 34.24527], [-118.19062, 34.24508], [-118.1907, 34.24486], [-118.19073, 34.24469], [-118.19073, 34.24452], [-118.19068, 34.24431], [-118.19058, 34.24411], [-118.19048, 34.24397], [-118.19039, 34.24388], [-118.19026, 34.24377], [-118.18997, 34.24358], [-118.18981, 34.24342], [-118.18972, 34.24323], [-118.18971, 34.24299], [-118.18977, 34.24282], [-118.18988, 34.24281], [-118.1899, 34.24273], [-118.18989, 34.2425], [-118.19542, 34.24291]]]]} | Open Access 1 | 6720 | Upper Arroyo Seco | 8449 | 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/Arroyo_Trails/ | Los Angeles 6 | 616.146 | Upper Arroyo Seco | 0 | None 611 | |
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 | ||
987 | 987 | 986 | {"type": "Polygon", "coordinates": [[[-118.16289, 34.14526], [-118.16276, 34.14539], [-118.16263, 34.14547], [-118.16238, 34.14558], [-118.16208, 34.14564], [-118.16161, 34.14564], [-118.16083, 34.1456], [-118.16078, 34.14558], [-118.1607, 34.14534], [-118.1613, 34.14533], [-118.16131, 34.14531], [-118.16126, 34.14517], [-118.16176, 34.14517], [-118.16186, 34.14542], [-118.16206, 34.14541], [-118.16201, 34.14527], [-118.16289, 34.14526]]]} | Open Access 1 | 6716 | Defenders Park | 18012 | 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 | 1.665 | Defenders Park | 0 | Local Park 2 | 4 | |
989 | 989 | 988 | {"type": "Polygon", "coordinates": [[[-118.137, 34.16884], [-118.13546, 34.16885], [-118.13545, 34.16768], [-118.13551, 34.16767], [-118.13552, 34.16743], [-118.13551, 34.16742], [-118.13551, 34.16733], [-118.13616, 34.16732], [-118.13617, 34.16735], [-118.13649, 34.16735], [-118.1365, 34.16767], [-118.13699, 34.16767], [-118.137, 34.16884]]]} | Open Access 1 | 6718 | Washington Park | 27276 | 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/Washington_Park/ | Los Angeles 6 | 5.43 | Washington Park | 0 | Local Park 2 | 4 |
990 | 990 | 989 | {"type": "Polygon", "coordinates": [[[-118.14566, 34.12655], [-118.14418, 34.12656], [-118.14418, 34.12588], [-118.14436, 34.12587], [-118.14436, 34.12569], [-118.14566, 34.12568], [-118.14566, 34.12655]]]} | Open Access 1 | 6721 | Allendale Park | 15381 | 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://cityofpasadena.net/PublicWorks/Allendale_Park/ | Los Angeles 6 | 3.179 | Allendale Park | 0 | Local Park 2 | 4 |
991 | 991 | 990 | {"type": "Polygon", "coordinates": [[[-118.1488, 34.14937], [-118.14878, 34.1494], [-118.14875, 34.14941], [-118.14702, 34.14941], [-118.14789, 34.14777], [-118.14879, 34.14776], [-118.1488, 34.14937]]]} | Open Access 1 | 6725 | Pasadena Memorial Park | 23491 | 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 | 5.544 | Pasadena Memorial Park | 0 | Local Park 2 | 4 | |
1001 | 1001 | 1000 | {"type": "Polygon", "coordinates": [[[-118.1198, 34.15534], [-118.11782, 34.15535], [-118.11782, 34.15446], [-118.1198, 34.15446], [-118.1198, 34.15534]]]} | Open Access 1 | 6744 | Jefferson Park | 20381 | 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.412 | Jefferson Park | 0 | Local Park 2 | 4 | |
1145 | 1145 | 1144 | {"type": "Polygon", "coordinates": [[[-118.08726, 34.1584], [-118.08682, 34.15836], [-118.08638, 34.15829], [-118.08536, 34.15802], [-118.08542, 34.15783], [-118.08564, 34.15677], [-118.08585, 34.1568], [-118.086, 34.15604], [-118.08705, 34.15619], [-118.08703, 34.15669], [-118.08705, 34.15718], [-118.08711, 34.15767], [-118.08726, 34.1584]]]} | Open Access 1 | 6726 | Viña Vieja Park | 28118 | 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 | 7.898 | Viña Vieja Park | 0 | Local Park 2 | 4 | |
1146 | 1146 | 1145 | {"type": "Polygon", "coordinates": [[[-118.07621, 34.16419], [-118.07389, 34.1642], [-118.07385, 34.16196], [-118.07616, 34.16193], [-118.07621, 34.16419]]]} | Open Access 1 | 6729 | Hamilton Park | 19620 | 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 | 13.142 | Hamilton Park | 0 | Local Park 2 | 4 | |
1147 | 1147 | 1146 | {"type": "Polygon", "coordinates": [[[-118.08707, 34.14127], [-118.08706, 34.1421], [-118.08635, 34.14211], [-118.08635, 34.14203], [-118.08628, 34.14203], [-118.08607, 34.14179], [-118.08603, 34.14173], [-118.08594, 34.14163], [-118.08453, 34.14025], [-118.08436, 34.14002], [-118.08426, 34.13981], [-118.08387, 34.13867], [-118.08386, 34.13849], [-118.08413, 34.13849], [-118.08413, 34.1389], [-118.08447, 34.1389], [-118.08445, 34.13992], [-118.08449, 34.14005], [-118.08458, 34.14016], [-118.0847, 34.14024], [-118.08486, 34.14028], [-118.08596, 34.14027], [-118.08594, 34.14115], [-118.0861, 34.14128], [-118.08707, 34.14127]]]} | Open Access 1 | 6731 | Eaton Blanche Park | 18406 | 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/Eaton_Blanche_Park/ | Los Angeles 6 | 5.782 | Eaton Blanche Park | 0 | Local Park 2 | 4 |
1148 | 1148 | 1147 | {"type": "Polygon", "coordinates": [[[-118.17776, 34.14042], [-118.17776, 34.14045], [-118.17758, 34.14079], [-118.17755, 34.14081], [-118.17673, 34.14085], [-118.1767, 34.14083], [-118.17661, 34.14069], [-118.17742, 34.14033], [-118.17773, 34.14039], [-118.17776, 34.14042]]]} | Open Access 1 | 6733 | San Rafael Park | 24983 | 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/San_Rafael_Park/ | Los Angeles 6 | 0.948 | San Rafael Park | 0 | Local Park 2 | 4 |
1151 | 1151 | 1150 | {"type": "Polygon", "coordinates": [[[-118.16869, 34.15351], [-118.16865, 34.15354], [-118.16836, 34.15333], [-118.16826, 34.15332], [-118.16819, 34.15335], [-118.16814, 34.1534], [-118.16812, 34.15344], [-118.16805, 34.15383], [-118.16806, 34.15393], [-118.16779, 34.15412], [-118.16776, 34.15415], [-118.16784, 34.15438], [-118.168, 34.15465], [-118.16854, 34.15527], [-118.16857, 34.15539], [-118.16858, 34.15549], [-118.16855, 34.15561], [-118.1685, 34.15571], [-118.16843, 34.1558], [-118.16832, 34.15588], [-118.16823, 34.15592], [-118.16757, 34.15606], [-118.1676, 34.15659], [-118.16753, 34.15651], [-118.16743, 34.15645], [-118.16731, 34.15641], [-118.1672, 34.15641], [-118.16632, 34.15661], [-118.16607, 34.15669], [-118.16566, 34.15687], [-118.16435, 34.15769], [-118.16411, 34.15782], [-118.16386, 34.15734], [-118.16382, 34.15729], [-118.16343, 34.15642], [-118.16335, 34.1563], [-118.16308, 34.156], [-118.16347, 34.15577], [-118.16293, 34.15456], [-118.16303, 34.15449], [-118.16324, 34.15425], [-118.1628, 34.15332], [-118.16238, 34.15345], [-118.16284, 34.15231], [-118.1627, 34.15135], [-118.16242, 34.1512], [-118.16264, 34.15103], [-118.16247, 34.15079], [-118.16268, 34.15066], [-118.1629, 34.15045], [-118.16304, 34.15034], [-118.16357, 34.15003], [-118.16381, 34.14994], [-118.16408, 34.1497], [-118.16416, 34.14967], [-118.16448, 34.14959], [-118.16455, 34.14954], [-118.16462, 34.14942], [-118.16474, 34.1494], [-118.16452, 34.14863], [-118.16443, 34.1485], [-118.16425, 34.14833], [-118.16468, 34.14833], [-118.1652, 34.14871], [-118.1653, 34.14833], [-118.16548, 34.14832], [-118.16545, 34.14792], [-118.16543, 34.14782], [-118.16538, 34.14775], [-118.1653, 34.14766], [-118.1652, 34.14759], [-118.16509, 34.14755], [-118.16495, 34.14752], [-118.16473, 34.14742], [-118.16432, 34.14709], [-118.16448, 34.14694], [-118.16422, 34.14675], [-118.16411, 34.14655], [-118.16412, 34.14645], [-118.1651, 34.1462], [-118.165, 34.14637], [-118.165, 34.14655], [-118.16541, 34.14669], [-118.16582, 34.14675], [-118.16616, 34.14688], [-118.1662, 34.14692], [-118.1661, 34.14692], [-118.16609, 34.14693], [-118.16613, 34.14696], [-118.16626, 34.14697], [-118.16679, 34.14743], [-118.16676, 34.14781], [-118.16648, 34.14813], [-118.16642, 34.14823], [-118.16635, 34.14836], [-118.16632, 34.1485], [-118.16631, 34.14864], [-118.16632, 34.14876], [-118.16643, 34.14917], [-118.1663, 34.14923], [-118.16597, 34.14903], [-118.1658, 34.14936], [-118.16591, 34.15034], [-118.1661, 34.1504], [-118.16628, 34.15052], [-118.16633, 34.15061], [-118.16656, 34.15077], [-118.16668, 34.1509], [-118.16675, 34.1509], [-118.16678, 34.15112], [-118.16683, 34.15137], [-118.16697, 34.15176], [-118.16717, 34.15215], [-118.16734, 34.15239], [-118.1675, 34.15258], [-118.16767, 34.15276], [-118.16788, 34.15294], [-118.16869, 34.15351]]]} | Open Access 1 | 6736 | Brookside Park | 16431 | 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_Park1/ | Los Angeles 6 | 94.183 | Brookside Park | 0 | Local Park 2 | 4 |
1152 | 1152 | 1151 | {"type": "Polygon", "coordinates": [[[-118.15682, 34.13566], [-118.15567, 34.13566], [-118.15566, 34.13461], [-118.15619, 34.1346], [-118.1562, 34.13464], [-118.1568, 34.13463], [-118.15682, 34.13566]]]} | Open Access 1 | 6737 | Singer Park | 25517 | 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 | 3.01 | Singer Park | 0 | Local Park 2 | 4 | |
1153 | 1153 | 1152 | {"type": "Polygon", "coordinates": [[[-118.15031, 34.14345], [-118.149, 34.14346], [-118.14897, 34.14072], [-118.14899, 34.14069], [-118.15003, 34.14068], [-118.15021, 34.14071], [-118.15028, 34.14077], [-118.15031, 34.14345]]]} | Open Access 1 | 6738 | Pasadena Central Park | 23489 | 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/Central_Park_Master_Plan/ | Los Angeles 6 | 9.154 | Pasadena Central Park | 0 | Local Park 2 | 4 |
1658 | 1658 | 1657 | {"type": "MultiPolygon", "coordinates": [[[[-118.20428, 34.26086], [-118.20289, 34.26135], [-118.19949, 34.25848], [-118.19999, 34.25788], [-118.20192, 34.2573], [-118.20428, 34.26086]]], [[[-118.20284, 34.26137], [-118.20252, 34.26149], [-118.19905, 34.25902], [-118.19947, 34.25851], [-118.20284, 34.26137]]]]} | Open Access 1 | 12550 | Pasadena City Parkland | 8444 | 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 | 27.888 | Pasadena City Parkland | 0 | Local Park 2 | 4 | |
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 | |
4382 | 4382 | 4381 | {"type": "Polygon", "coordinates": [[[-118.08827, 34.15937], [-118.08808, 34.159], [-118.08793, 34.15862], [-118.08911, 34.15861], [-118.08915, 34.15862], [-118.08915, 34.15932], [-118.08913, 34.15934], [-118.0891, 34.15936], [-118.08827, 34.15937]]]} | Open Access 1 | 45944 | Eaton Sunnyslope Park | 29051 | 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/Eaton_Sunnyslope_Park/ | Los Angeles 6 | 2.002 | Eaton Sunnyslope 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]);