units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 297 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15745 | 15745 | 15744 | {"type": "Polygon", "coordinates": [[[-118.15204, 34.16217], [-118.15205, 34.16501], [-118.152, 34.16504], [-118.1508, 34.16503], [-118.15077, 34.16499], [-118.15076, 34.16218], [-118.15204, 34.16217]]]} | Open Access 1 | 6741 | Robinson Park Recreation Center | 32638 | 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 | https://www.cityofpasadena.net/human-services/parks/robinson-park-recreation-center/ | Los Angeles 6 | 9.234 | Robinson Park Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15727 | 15727 | 15726 | {"type": "Polygon", "coordinates": [[[-118.17436, 34.1834], [-118.17431, 34.1834], [-118.17301, 34.18282], [-118.17291, 34.18254], [-118.17283, 34.18244], [-118.17273, 34.18235], [-118.17215, 34.18199], [-118.1718, 34.18194], [-118.17174, 34.18191], [-118.17206, 34.18149], [-118.17211, 34.18112], [-118.17243, 34.18106], [-118.1725, 34.18065], [-118.17248, 34.1804], [-118.17237, 34.18021], [-118.17204, 34.18005], [-118.17168, 34.1796], [-118.17145, 34.17966], [-118.17108, 34.17965], [-118.17031, 34.17951], [-118.17015, 34.17919], [-118.17008, 34.17898], [-118.17006, 34.17881], [-118.17008, 34.17861], [-118.17012, 34.17851], [-118.17025, 34.1783], [-118.17049, 34.17802], [-118.17066, 34.17777], [-118.17073, 34.17761], [-118.17076, 34.17745], [-118.17038, 34.17753], [-118.17042, 34.17743], [-118.17041, 34.17735], [-118.1702, 34.17699], [-118.17015, 34.17694], [-118.17006, 34.17688], [-118.16982, 34.17677], [-118.16947, 34.17648], [-118.16929, 34.17639], [-118.16911, 34.17625], [-118.16886, 34.17611], [-118.16866, 34.17587], [-118.16823, 34.17543], [-118.16806, 34.17524], [-118.16766, 34.17524], [-118.16765, 34.17511], [-118.16728, 34.17524], [-118.16725, 34.17511], [-118.16721, 34.17492], [-118.16711, 34.17363], [-118.16701, 34.17317], [-118.16699, 34.17299], [-118.16696, 34.17178], [-118.16689, 34.17152], [-118.16675, 34.17128], [-118.16668, 34.17114], [-118.16661, 34.17084], [-118.16664, 34.17019], [-118.16677, 34.16956], [-118.16679, 34.16932], [-118.16678, 34.16889], [-118.16679, 34.16843], [-118.16677, 34.1682], [-118.16642, 34.1671], [-118.16651, 34.1671], [-118.16652, 34.16709], [-118.16595, 34.16498], [-118.16523, 34.16349], [-118.16589, 34.16329], [-118.16778, 34.16277], [-118.16808, 34.16276], [-118.16841, 34.16264], [-118.16857, 34.16252], [-118.1689, 34.16241], [-118.16896, 34.16226], [-118.17005, 34.16195], [-118.16999, 34.16175], [-118.17002, 34.16173], [-118.16982, 34.16114], [-118.16974, 34.16109], [-118.16967, 34.161], [-118.16928, 34.15992], [-118.16932, 34.15971], [-118.16921, 34.15946], [-118.17032, 34.15985], [-118.171, 34.16012], [-118.17142, 34.16041], [-118.17165, 34.16111], [-118.17241, 34.16315], [-118.17217, 34.16322], [-118.17235, 34.16417], [-118.17242, 34.16439], [-118.17271, 34.16507], [-118.17318, 34.16645], [-118.17352, 34.16795], [-118.17399, 34.16795], [-118.17402, 34.16806], [-118.17425, 34.16914], [-118.17427, 34.16936], [-118.17447, 34.17027], [-118.17448, 34.17049], [-118.17468, 34.17142], [-118.17469, 34.17158], [-118.1748, 34.17226], [-118.17483, 34.17256], [-118.17478, 34.17312], [-118.17472, 34.17342], [-118.17456, 34.17402], [-118.1745, 34.17411], [-118.17437, 34.17417], [-118.17432, 34.17537], [-118.17339, 34.17649], [-118.17257, 34.17743], [-118.17253, 34.17803], [-118.17323, 34.17898], [-118.17357, 34.17931], [-118.1738, 34.17968], [-118.17394, 34.17995], [-118.17402, 34.18031], [-118.17366, 34.1808], [-118.17367, 34.18082], [-118.17359, 34.18105], [-118.17339, 34.18132], [-118.17345, 34.18137], [-118.17332, 34.18178], [-118.17344, 34.18248], [-118.17391, 34.18247], [-118.17394, 34.18268], [-118.17401, 34.18287], [-118.17436, 34.1834]]]} | Restricted Access 2 | 45949 | Brookside Golf Course | 29070 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/brookside_golf_course/ | Los Angeles 6 | 293.605 | Brookside GC | 0 | Local Recreation Area 3 | 4 |
15204 | 15204 | 15203 | {"type": "Polygon", "coordinates": [[[-118.1837, 34.15772], [-118.18336, 34.15767], [-118.18317, 34.15828], [-118.18277, 34.15832], [-118.18247, 34.15829], [-118.18249, 34.15796], [-118.18231, 34.15786], [-118.18215, 34.15784], [-118.182, 34.15788], [-118.18186, 34.15798], [-118.18188, 34.15804], [-118.18199, 34.15824], [-118.18157, 34.1584], [-118.18128, 34.15803], [-118.18158, 34.15789], [-118.18156, 34.15771], [-118.18153, 34.15762], [-118.18145, 34.15748], [-118.18145, 34.1574], [-118.18137, 34.15739], [-118.181, 34.15752], [-118.18084, 34.15726], [-118.18116, 34.15703], [-118.18122, 34.157], [-118.18118, 34.15694], [-118.18099, 34.15682], [-118.18082, 34.15677], [-118.18064, 34.15715], [-118.18043, 34.15714], [-118.1799, 34.15721], [-118.17963, 34.15668], [-118.17998, 34.15652], [-118.18004, 34.1564], [-118.18013, 34.15629], [-118.18026, 34.15622], [-118.1805, 34.15616], [-118.18082, 34.15587], [-118.18088, 34.15575], [-118.18089, 34.15564], [-118.18086, 34.15509], [-118.18079, 34.15485], [-118.18146, 34.15487], [-118.18145, 34.15455], [-118.18171, 34.15413], [-118.18202, 34.15386], [-118.18227, 34.15372], [-118.18229, 34.15366], [-118.18235, 34.15362], [-118.18239, 34.15355], [-118.18259, 34.15358], [-118.1837, 34.15772]]]} | Open Access 1 | 46088 | Annandale Canyon Park | 29437 | 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 | 24.841 | Annandale Canyon Park | 0 | Local Park 2 | 4 | |
15131 | 15131 | 15130 | {"type": "Polygon", "coordinates": [[[-118.17142, 34.16041], [-118.171, 34.16012], [-118.17032, 34.15985], [-118.16923, 34.15947], [-118.16932, 34.15971], [-118.16928, 34.15992], [-118.16967, 34.161], [-118.16974, 34.16109], [-118.16982, 34.16114], [-118.17003, 34.16174], [-118.16999, 34.16176], [-118.17005, 34.16195], [-118.16896, 34.16226], [-118.1689, 34.16241], [-118.16857, 34.16252], [-118.16841, 34.16264], [-118.16808, 34.16276], [-118.16778, 34.16277], [-118.16589, 34.16329], [-118.16523, 34.16349], [-118.16484, 34.16267], [-118.1643, 34.16174], [-118.16393, 34.16098], [-118.16414, 34.1607], [-118.16434, 34.16049], [-118.16452, 34.16034], [-118.16488, 34.1601], [-118.1652, 34.15989], [-118.16547, 34.15975], [-118.16635, 34.15937], [-118.16677, 34.1591], [-118.16692, 34.15898], [-118.16712, 34.15877], [-118.1673, 34.15855], [-118.16745, 34.15832], [-118.16758, 34.15807], [-118.16767, 34.15782], [-118.16772, 34.15756], [-118.16775, 34.15729], [-118.16774, 34.15703], [-118.1676, 34.15659], [-118.16757, 34.15606], [-118.16822, 34.15592], [-118.1683, 34.15589], [-118.1684, 34.15582], [-118.16848, 34.15574], [-118.16855, 34.15563], [-118.16857, 34.15553], [-118.16858, 34.15541], [-118.16854, 34.15527], [-118.168, 34.15465], [-118.16787, 34.15444], [-118.16778, 34.15421], [-118.16776, 34.15415], [-118.16779, 34.15412], [-118.16809, 34.15392], [-118.1681, 34.154], [-118.16823, 34.15427], [-118.16828, 34.15444], [-118.1688, 34.1547], [-118.1694, 34.15575], [-118.16993, 34.15661], [-118.17033, 34.1578], [-118.17055, 34.1584], [-118.17071, 34.1588], [-118.17103, 34.1592], [-118.17142, 34.16041]]]} | Restricted Access 2 | 45950 | Rose Bowl | 29069 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.rosebowlstadium.com/ | Los Angeles 6 | 74.133 | Rose Bowl | None 1318 | ||
15128 | 15128 | 15127 | {"type": "Polygon", "coordinates": [[[-118.13599, 34.13887], [-118.13522, 34.13887], [-118.13522, 34.13738], [-118.13596, 34.13739], [-118.13596, 34.13773], [-118.13594, 34.13774], [-118.13595, 34.13826], [-118.13598, 34.13827], [-118.13599, 34.13887]]]} | Restricted Access 2 | 45948 | McKinley School Park | 29097 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://pasadenacsp.org/pcsp/site/joint_use/ | Los Angeles 6 | 2.802 | McKinley School Park | 0 | Local Park 2 | 4 |
15127 | 15127 | 15126 | {"type": "Polygon", "coordinates": [[[-118.17896, 34.16949], [-118.17802, 34.16949], [-118.17798, 34.1694], [-118.17765, 34.1694], [-118.17765, 34.16937], [-118.17745, 34.16924], [-118.17743, 34.16921], [-118.17744, 34.16919], [-118.17742, 34.16917], [-118.17731, 34.1689], [-118.17725, 34.16889], [-118.17724, 34.16868], [-118.17682, 34.16868], [-118.17682, 34.1686], [-118.1774, 34.1686], [-118.17741, 34.16854], [-118.17892, 34.16941], [-118.17896, 34.16949]]]} | Restricted Access 2 | 45947 | Linda Vista Park | 29095 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.lvaa.net/linda-vista-park.html | Los Angeles 6 | 2.012 | Linda Vista Park | 0 | Local Park 2 | 4 |
15126 | 15126 | 15125 | {"type": "Polygon", "coordinates": [[[-118.14136, 34.15891], [-118.14137, 34.15954], [-118.14136, 34.15957], [-118.14132, 34.15958], [-118.14069, 34.15958], [-118.14069, 34.15892], [-118.14136, 34.15891]]]} | Restricted Access 2 | 45946 | James Madison Park | 29094 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://pasadenacsp.org/pcsp/site/joint_use/ | Los Angeles 6 | 1.131 | James Madison Park | 0 | Local Park 2 | 4 |
9086 | 9086 | 9085 | {"type": "Polygon", "coordinates": [[[-118.09827, 34.16155], [-118.09753, 34.16157], [-118.09171, 34.16164], [-118.09216, 34.16152], [-118.0926, 34.16134], [-118.09299, 34.16111], [-118.09335, 34.16084], [-118.09364, 34.16055], [-118.0939, 34.16021], [-118.09409, 34.15984], [-118.09422, 34.15946], [-118.09825, 34.15941], [-118.09829, 34.15942], [-118.0983, 34.15945], [-118.09827, 34.16155]]]} | Open Access 1 | 15046 | Victory Park | 27090 | 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/Victory_Park/ | Los Angeles 6 | 26.242 | Victory Park | 0 | Local Park 2 | 4 |
8230 | 8230 | 8229 | {"type": "Polygon", "coordinates": [[[-118.18119, 34.1867], [-118.18015, 34.1874], [-118.18008, 34.18726], [-118.17997, 34.1871], [-118.17978, 34.1869], [-118.17962, 34.18678], [-118.17937, 34.18664], [-118.17911, 34.18637], [-118.17847, 34.18578], [-118.17853, 34.18566], [-118.17863, 34.18566], [-118.17891, 34.18575], [-118.17893, 34.18573], [-118.17982, 34.18602], [-118.17991, 34.18607], [-118.18036, 34.18647], [-118.18048, 34.18654], [-118.18061, 34.18658], [-118.18099, 34.18664], [-118.18119, 34.1867]]]} | Open Access 1 | 12557 | 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 | 4.108 | Pasadena City Parkland | 0 | Local Park 2 | 4 | |
8229 | 8229 | 8228 | {"type": "MultiPolygon", "coordinates": [[[[-118.17544, 34.16686], [-118.17536, 34.16689], [-118.17502, 34.16662], [-118.17488, 34.16648], [-118.17474, 34.1663], [-118.17407, 34.16531], [-118.17396, 34.1652], [-118.17383, 34.16511], [-118.1737, 34.16505], [-118.17312, 34.16488], [-118.17291, 34.16479], [-118.17263, 34.1646], [-118.17241, 34.16437], [-118.17234, 34.16412], [-118.17216, 34.16321], [-118.1724, 34.16314], [-118.17188, 34.16173], [-118.17218, 34.16164], [-118.17226, 34.1619], [-118.17235, 34.16188], [-118.17313, 34.16369], [-118.17279, 34.1638], [-118.17291, 34.1642], [-118.17256, 34.1643], [-118.1726, 34.16443], [-118.17296, 34.16433], [-118.17304, 34.16455], [-118.17357, 34.16482], [-118.17398, 34.16497], [-118.17422, 34.16537], [-118.17466, 34.16581], [-118.17498, 34.16597], [-118.17515, 34.16636], [-118.17525, 34.16672], [-118.17544, 34.16686]]], [[[-118.17631, 34.1679], [-118.17603, 34.1679], [-118.17609, 34.16786], [-118.1761, 34.16783], [-118.17608, 34.16779], [-118.1748, 34.16674], [-118.17423, 34.1661], [-118.17395, 34.16587], [-118.17362, 34.1655], [-118.1734, 34.16537], [-118.17323, 34.16533], [-118.17317, 34.1658], [-118.17349, 34.16654], [-118.17365, 34.16704], [-118.17372, 34.16733], [-118.17338, 34.16734], [-118.17318, 34.16645], [-118.17271, 34.16507], [-118.17259, 34.1648], [-118.17276, 34.1649], [-118.17295, 34.16499], [-118.17359, 34.16519], [-118.17372, 34.16525], [-118.17383, 34.16532], [-118.17391, 34.1654], [-118.17459, 34.16642], [-118.17477, 34.16663], [-118.17493, 34.16678], [-118.17631, 34.1679]]], [[[-118.17398, 34.16791], [-118.17351, 34.16792], [-118.1734, 34.16742], [-118.17381, 34.16742], [-118.17398, 34.16791]]], [[[-118.17658, 34.16789], [-118.17539, 34.16692], [-118.17539, 34.16692], [-118.17582, 34.16679], [-118.17582, 34.16676], [-118.17626, 34.16662], [-118.17638, 34.16691], [-118.17594, 34.16704], [-118.17588, 34.16691], [-118.17555, 34.16702], [-118.17642, 34.16768], [-118.17646, 34.16769], [-118.17651, 34.16769], [-118.17655, 34.16766], [-118.17657, 34.16763], [-118.17658, 34.16789]]]]} | Open Access 1 | 12553 | 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 | 10.096 | Pasadena City Parkland | 0 | Local Park 2 | 4 | |
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 | |
7365 | 7365 | 7364 | {"type": "Polygon", "coordinates": [[[-118.12585, 34.14252], [-118.1246, 34.14252], [-118.12459, 34.14175], [-118.12584, 34.14174], [-118.12585, 34.14252]]]} | Open Access 1 | 6742 | Grant Park | 19439 | 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 | 2.459 | Grant Park | 0 | Local Park 2 | 4 | |
7364 | 7364 | 7363 | {"type": "Polygon", "coordinates": [[[-118.15055, 34.17015], [-118.14969, 34.17015], [-118.14969, 34.17057], [-118.14924, 34.17058], [-118.14923, 34.16897], [-118.15054, 34.16896], [-118.15055, 34.17015]]]} | Open Access 1 | 6740 | La Pintoresca Park | 20787 | 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.403 | La Pintoresca Park | 0 | Local Park 2 | 4 | |
7363 | 7363 | 7362 | {"type": "Polygon", "coordinates": [[[-118.15657, 34.16124], [-118.15621, 34.16175], [-118.15485, 34.16106], [-118.15557, 34.16043], [-118.15657, 34.16124]]]} | Open Access 1 | 6739 | Brenner Park | 16353 | 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 | 2.725 | Brenner Park | 0 | Local Park 2 | 4 | |
7358 | 7358 | 7357 | {"type": "Polygon", "coordinates": [[[-118.17822, 34.18964], [-118.17819, 34.19263], [-118.17815, 34.193], [-118.17806, 34.19331], [-118.17775, 34.194], [-118.17757, 34.19423], [-118.17747, 34.1946], [-118.17741, 34.19469], [-118.17729, 34.19479], [-118.17719, 34.19492], [-118.17706, 34.19502], [-118.177, 34.19509], [-118.17697, 34.19517], [-118.17693, 34.19538], [-118.1769, 34.19549], [-118.17674, 34.19575], [-118.17662, 34.19598], [-118.17654, 34.19608], [-118.17642, 34.19615], [-118.17623, 34.19631], [-118.17601, 34.19645], [-118.1759, 34.19658], [-118.17584, 34.19671], [-118.17584, 34.19695], [-118.17579, 34.19709], [-118.17519, 34.19783], [-118.17511, 34.19796], [-118.17507, 34.19812], [-118.17504, 34.19844], [-118.17312, 34.19845], [-118.17367, 34.19702], [-118.17209, 34.19702], [-118.17208, 34.197], [-118.17202, 34.197], [-118.16906, 34.19982], [-118.16779, 34.20095], [-118.16663, 34.20311], [-118.16533, 34.2031], [-118.16511, 34.20251], [-118.16483, 34.2027], [-118.16472, 34.20273], [-118.16474, 34.20269], [-118.16438, 34.20224], [-118.16431, 34.20209], [-118.16426, 34.20177], [-118.16427, 34.20146], [-118.16398, 34.20148], [-118.16491, 34.20016], [-118.16581, 34.19797], [-118.16694, 34.19597], [-118.16718, 34.19568], [-118.16742, 34.1953], [-118.16788, 34.19436], [-118.1679, 34.19424], [-118.16802, 34.19402], [-118.16816, 34.19406], [-118.16841, 34.19353], [-118.16849, 34.19329], [-118.16854, 34.19304], [-118.16856, 34.19258], [-118.16924, 34.19264], [-118.16937, 34.19244], [-118.16936, 34.19242], [-118.1693, 34.19242], [-118.16975, 34.19217], [-118.17023, 34.19159], [-118.17052, 34.19113], [-118.17061, 34.19012], [-118.17151, 34.18957], [-118.17184, 34.18911], [-118.17208, 34.18782], [-118.17289, 34.18645], [-118.17297, 34.18521], [-118.17253, 34.18359], [-118.17272, 34.18369], [-118.17294, 34.18366], [-118.17316, 34.18346], [-118.1749, 34.1842], [-118.17501, 34.1843], [-118.17509, 34.18438], [-118.17517, 34.18452], [-118.17533, 34.18512], [-118.17554, 34.18545], [-118.17566, 34.18584], [-118.17571, 34.18583], [-118.17587, 34.18584], [-118.17603, 34.18584], [-118.17642, 34.18578], [-118.17659, 34.1858], [-118.17707, 34.186], [-118.17769, 34.18616], [-118.17796, 34.18638], [-118.17824, 34.18664], [-118.17848, 34.18693], [-118.17863, 34.18722], [-118.17873, 34.18752], [-118.17876, 34.18783], [-118.17874, 34.18809], [-118.17866, 34.18836], [-118.17858, 34.18854], [-118.17839, 34.18888], [-118.17828, 34.18915], [-118.17821, 34.18946], [-118.1782, 34.18963], [-118.17822, 34.18964]]]} | Open Access 1 | 6715 | Hahamongna Watershed Park | 8427 | 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/hahamongna/ | Los Angeles 6 | 303.369 | Hahamongna Watershed Park | 0 | Local Park 2 | 4 |
7339 | 7339 | 7338 | {"type": "Polygon", "coordinates": [[[-118.12814, 34.16334], [-118.12693, 34.16335], [-118.1269, 34.1617], [-118.12812, 34.16169], [-118.12814, 34.16334]]]} | Open Access 1 | 6743 | McDonald Park | 22022 | 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.065 | McDonald Park | 0 | Local Park 2 | 4 | |
5653 | 5653 | 5652 | {"type": "MultiPolygon", "coordinates": [[[[-117.89005, 34.16595], [-117.88775, 34.16722], [-117.88764, 34.16709], [-117.88749, 34.16698], [-117.88708, 34.16659], [-117.88698, 34.16655], [-117.88689, 34.16653], [-117.88675, 34.16653], [-117.88667, 34.16655], [-117.88625, 34.16672], [-117.88602, 34.16689], [-117.88573, 34.16723], [-117.88558, 34.16751], [-117.88554, 34.16767], [-117.8855, 34.16813], [-117.88554, 34.16826], [-117.88566, 34.16844], [-117.88574, 34.16867], [-117.88588, 34.16897], [-117.88613, 34.1694], [-117.88621, 34.16984], [-117.88623, 34.1701], [-117.88617, 34.17039], [-117.88613, 34.1707], [-117.88603, 34.17095], [-117.88588, 34.17111], [-117.88567, 34.17129], [-117.88529, 34.17166], [-117.88523, 34.17179], [-117.88514, 34.17211], [-117.87297, 34.17211], [-117.87246, 34.16507], [-117.88806, 34.16511], [-117.88808, 34.16594], [-117.89005, 34.16595]]], [[[-117.89007, 34.1702], [-117.89007, 34.17102], [-117.8899, 34.17093], [-117.88961, 34.17125], [-117.88901, 34.17091], [-117.88883, 34.17084], [-117.88857, 34.17079], [-117.88827, 34.17079], [-117.88802, 34.17085], [-117.88778, 34.17095], [-117.88762, 34.17107], [-117.88712, 34.1707], [-117.88699, 34.17082], [-117.88688, 34.17095], [-117.88673, 34.17119], [-117.88654, 34.17181], [-117.88638, 34.17211], [-117.88534, 34.17211], [-117.88545, 34.17174], [-117.88553, 34.17169], [-117.88582, 34.17139], [-117.88603, 34.17122], [-117.88621, 34.17102], [-117.88624, 34.17093], [-117.88632, 34.17074], [-117.88636, 34.1704], [-117.88642, 34.1701], [-117.88641, 34.16983], [-117.88633, 34.16936], [-117.88606, 34.16891], [-117.88586, 34.16845], [-117.88572, 34.1682], [-117.8857, 34.16808], [-117.88575, 34.16765], [-117.88584, 34.16741], [-117.88595, 34.16726], [-117.88623, 34.16694], [-117.88635, 34.16686], [-117.88644, 34.16681], [-117.88678, 34.16669], [-117.88691, 34.1667], [-117.88701, 34.16675], [-117.88734, 34.1671], [-117.88751, 34.16722], [-117.88757, 34.16728], [-117.88783, 34.1677], [-117.88812, 34.16801], [-117.88819, 34.16814], [-117.88823, 34.16827], [-117.88832, 34.16845], [-117.88974, 34.1701], [-117.89007, 34.1702]]], [[[-117.89007, 34.17212], [-117.89007, 34.17212], [-117.8878, 34.17211], [-117.88791, 34.17183], [-117.88795, 34.17163], [-117.88802, 34.1715], [-117.88816, 34.17139], [-117.88826, 34.17135], [-117.88835, 34.17134], [-117.88851, 34.17133], [-117.88866, 34.17138], [-117.88974, 34.17198], [-117.89007, 34.17208], [-117.89007, 34.17212]]], [[[-117.89007, 34.17002], [-117.88986, 34.16996], [-117.88854, 34.16846], [-117.88847, 34.16834], [-117.88842, 34.16824], [-117.8884, 34.16814], [-117.88832, 34.16798], [-117.888, 34.16762], [-117.88789, 34.16744], [-117.88792, 34.16729], [-117.89005, 34.16611], [-117.89007, 34.17002]]], [[[-117.90541, 34.15784], [-117.9054, 34.15837], [-117.90455, 34.15824], [-117.90433, 34.15825], [-117.90415, 34.15832], [-117.90399, 34.15843], [-117.90366, 34.15842], [-117.90326, 34.15845], [-117.90308, 34.15848], [-117.90126, 34.1589], [-117.90099, 34.159], [-117.90059, 34.15916], [-117.89892, 34.16013], [-117.89881, 34.16017], [-117.89842, 34.16046], [-117.89818, 34.16074], [-117.89733, 34.16194], [-117.89668, 34.16145], [-117.8966, 34.16153], [-117.8966, 34.15994], [-117.8961, 34.16015], [-117.89459, 34.16034], [-117.89442, 34.16033], [-117.89427, 34.16025], [-117.89397, 34.16011], [-117.89372, 34.16003], [-117.89325, 34.15994], [-117.89276, 34.15977], [-117.89264, 34.15949], [-117.89224, 34.15922], [-117.89127, 34.15925], [-117.89005, 34.15966], [-117.89005, 34.15775], [-117.90541, 34.15784]]], [[[-117.90541, 34.1585], [-117.9054, 34.15879], [-117.90479, 34.15856], [-117.90458, 34.15851], [-117.90421, 34.15845], [-117.90436, 34.15839], [-117.90454, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15881], [-117.90753, 34.15953], [-117.9071, 34.15944], [-117.90649, 34.15922], [-117.90649, 34.15867], [-117.90754, 34.15881]]], [[[-117.90755, 34.15786], [-117.90754, 34.15868], [-117.90649, 34.15852], [-117.9065, 34.15785], [-117.90755, 34.15786]]]]} | Open Access 1 | 12548 | Unnamed site - Pasadena, City of | 32659 | 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 | 363.946 | 0 | Local Other or Unknown 14 | 4 | ||
5532 | 5532 | 5531 | {"type": "Polygon", "coordinates": [[[-118.09817, 34.14384], [-118.09793, 34.14384], [-118.09794, 34.1433], [-118.09816, 34.1433], [-118.09817, 34.14384]]]} | Open Access 1 | 48170 | Lamada Pocket Park | 32702 | 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 | 0.313 | Lamada PP | 0 | Local Park 2 | 4 | |
4383 | 4383 | 4382 | {"type": "Polygon", "coordinates": [[[-118.08786, 34.15841], [-118.08776, 34.15803], [-118.08769, 34.15766], [-118.08912, 34.15764], [-118.08917, 34.15766], [-118.08916, 34.15835], [-118.08914, 34.15838], [-118.08786, 34.15841]]]} | Open Access 1 | 45945 | Gwinn Park | 29052 | 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/Gwinn_Park/ | Los Angeles 6 | 2.633 | Gwinn Park | 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]);