superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
ACCESS_TYP 2
- Open Access 247
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 253
MNG_AGENCY 1
- San Jose, City of · 253 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6817 | 6817 | 6816 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | Iris Chang Park | https://www.sanjoseca.gov/Home/Components/News/News/402/5103 | 33665 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.664 | Iris Chang Park | 2019 |
7023 | 7023 | 7022 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31456], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | Tamien Park | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | 33676 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.591 | Tamien Park | 2017 |
6969 | 6969 | 6968 | {"type": "Polygon", "coordinates": [[[-121.77114, 37.31589], [-121.77046, 37.31599], [-121.77034, 37.3155], [-121.77102, 37.3154], [-121.77114, 37.31589]]]} | Open Access 1 | Michelangelo Park | 22198 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.844 | Michelangelo Park | 2007 | |
11513 | 11513 | 11512 | {"type": "Polygon", "coordinates": [[[-121.85116, 37.34628], [-121.85095, 37.34628], [-121.85075, 37.34634], [-121.85008, 37.34674], [-121.85002, 37.34676], [-121.84993, 37.34675], [-121.84958, 37.34642], [-121.85074, 37.3457], [-121.85079, 37.34575], [-121.85071, 37.34582], [-121.85116, 37.34628]]]} | Open Access 1 | Zolezzi Park | 27868 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.717 | Zolezzi Park | 2007 | |
1794 | 1794 | 1793 | {"type": "Polygon", "coordinates": [[[-121.76046, 37.24318], [-121.76012, 37.24392], [-121.75974, 37.24411], [-121.75913, 37.24423], [-121.75839, 37.24428], [-121.75777, 37.24352], [-121.75822, 37.24308], [-121.75858, 37.24246], [-121.75914, 37.24231], [-121.75924, 37.24253], [-121.75931, 37.24262], [-121.75944, 37.24273], [-121.75959, 37.24281], [-121.75981, 37.24289], [-121.76005, 37.24291], [-121.76023, 37.24287], [-121.76046, 37.24318]]]} | Open Access 1 | Basking Ridge Park | 15853 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.042 | Basking Ridge Park | 2005 | |
2593 | 2593 | 2592 | {"type": "Polygon", "coordinates": [[[-121.76924, 37.29043], [-121.76917, 37.29049], [-121.7689, 37.29058], [-121.76865, 37.29073], [-121.76858, 37.29075], [-121.76849, 37.29075], [-121.76842, 37.29071], [-121.76826, 37.29055], [-121.76792, 37.29031], [-121.76785, 37.29021], [-121.76784, 37.29013], [-121.76786, 37.29009], [-121.76798, 37.2901], [-121.76798, 37.29014], [-121.76802, 37.29016], [-121.76855, 37.29025], [-121.76872, 37.29026], [-121.76892, 37.29023], [-121.76906, 37.29024], [-121.76914, 37.29027], [-121.76919, 37.29032], [-121.76923, 37.29038], [-121.76924, 37.29043]]]} | Open Access 1 | Canyon Creek Park | 16813 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.151 | Canyon Creek Park | 2005 | |
743 | 743 | 742 | {"type": "Polygon", "coordinates": [[[-121.76995, 37.32073], [-121.76992, 37.32078], [-121.76987, 37.3208], [-121.76953, 37.32076], [-121.76868, 37.31766], [-121.76873, 37.31765], [-121.76879, 37.31791], [-121.76891, 37.31796], [-121.76892, 37.31801], [-121.76897, 37.31805], [-121.76902, 37.31823], [-121.76906, 37.31824], [-121.76911, 37.31845], [-121.76908, 37.31848], [-121.76906, 37.31852], [-121.76908, 37.31857], [-121.76911, 37.31861], [-121.76909, 37.31888], [-121.7692, 37.31889], [-121.76921, 37.31913], [-121.76928, 37.31919], [-121.76927, 37.31925], [-121.7693, 37.3193], [-121.76921, 37.31936], [-121.76936, 37.3199], [-121.76944, 37.31997], [-121.76944, 37.32001], [-121.76947, 37.32005], [-121.76953, 37.32009], [-121.7695, 37.32033], [-121.76958, 37.32035], [-121.76957, 37.32067], [-121.76995, 37.32073]]]} | Open Access 1 | Pocket Park No. 10 | 23821 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.014 | PP No. 10 | 2004 | |
744 | 744 | 743 | {"type": "Polygon", "coordinates": [[[-121.76494, 37.31564], [-121.7648, 37.3157], [-121.76466, 37.31572], [-121.7645, 37.3157], [-121.76436, 37.31564], [-121.76425, 37.31555], [-121.76419, 37.31544], [-121.76418, 37.31531], [-121.76422, 37.31518], [-121.76429, 37.3151], [-121.76435, 37.31505], [-121.76445, 37.315], [-121.76457, 37.31497], [-121.76477, 37.31498], [-121.76496, 37.31506], [-121.76504, 37.31513], [-121.76508, 37.31519], [-121.76511, 37.31526], [-121.76512, 37.31535], [-121.76511, 37.31543], [-121.76506, 37.31552], [-121.76494, 37.31564]]]} | Open Access 1 | Pocket Park No. 11 | 23822 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.328 | PP No. 11 | 2004 | |
745 | 745 | 744 | {"type": "MultiPolygon", "coordinates": [[[[-121.77933, 37.31566], [-121.7791, 37.31572], [-121.77901, 37.31526], [-121.77923, 37.31547], [-121.77933, 37.31563], [-121.77933, 37.31566]]], [[[-121.77976, 37.31553], [-121.77956, 37.31557], [-121.77951, 37.31556], [-121.77939, 37.31537], [-121.77917, 37.31515], [-121.77914, 37.3151], [-121.77915, 37.31507], [-121.77918, 37.31505], [-121.77928, 37.31503], [-121.77938, 37.31536], [-121.77966, 37.31535], [-121.77962, 37.31542], [-121.77963, 37.31547], [-121.77968, 37.31551], [-121.77976, 37.31553]]]]} | Open Access 1 | Pocket Park No. 14 | 23823 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.348 | PP No. 14 | 2004 | |
1612 | 1612 | 1611 | {"type": "MultiPolygon", "coordinates": [[[[-121.76711, 37.31382], [-121.76553, 37.31405], [-121.7655, 37.31394], [-121.76629, 37.31381], [-121.76631, 37.31384], [-121.76709, 37.31372], [-121.76708, 37.31377], [-121.76711, 37.31382]]], [[[-121.76796, 37.3137], [-121.76734, 37.31379], [-121.76734, 37.31373], [-121.76731, 37.31368], [-121.76793, 37.31359], [-121.76793, 37.31365], [-121.76796, 37.3137]]], [[[-121.7688, 37.31357], [-121.76819, 37.31366], [-121.76819, 37.31361], [-121.76816, 37.31355], [-121.76879, 37.31346], [-121.76878, 37.31352], [-121.7688, 37.31357]]], [[[-121.76968, 37.31344], [-121.76903, 37.31354], [-121.76903, 37.31348], [-121.76901, 37.31343], [-121.76966, 37.31333], [-121.76968, 37.31344]]]]} | Open Access 1 | Pocket Park No. 15 | 23824 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.923 | PP No. 15 | 2004 | |
1614 | 1614 | 1613 | {"type": "MultiPolygon", "coordinates": [[[[-121.75909, 37.31125], [-121.75908, 37.31129], [-121.75903, 37.31135], [-121.75894, 37.31143], [-121.75879, 37.3115], [-121.75881, 37.31139], [-121.7588, 37.31118], [-121.7587, 37.3111], [-121.75843, 37.31101], [-121.758, 37.31101], [-121.75767, 37.31106], [-121.75771, 37.31101], [-121.75779, 37.31097], [-121.75801, 37.31095], [-121.75802, 37.31091], [-121.75822, 37.3109], [-121.75847, 37.31091], [-121.75859, 37.31093], [-121.75879, 37.31101], [-121.75901, 37.31116], [-121.75909, 37.31125]]], [[[-121.75906, 37.31205], [-121.75896, 37.31207], [-121.75881, 37.3116], [-121.75887, 37.31158], [-121.75906, 37.31205]]], [[[-121.75984, 37.31269], [-121.75981, 37.31281], [-121.75957, 37.31279], [-121.75949, 37.31283], [-121.75915, 37.31287], [-121.75902, 37.31229], [-121.75903, 37.31224], [-121.75907, 37.31221], [-121.75914, 37.31219], [-121.75928, 37.31242], [-121.75946, 37.31246], [-121.75954, 37.31264], [-121.75984, 37.31269]]]]} | Open Access 1 | Pocket Park No. 17 | 23826 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.194 | PP No. 17 | 2004 | |
1615 | 1615 | 1614 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | Pocket Park No. 18 | 23827 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.285 | PP No. 18 | 2004 | |
1624 | 1624 | 1623 | {"type": "Polygon", "coordinates": [[[-121.92157, 37.31987], [-121.92107, 37.31987], [-121.92107, 37.31975], [-121.92153, 37.31975], [-121.92157, 37.31977], [-121.92157, 37.31987]]]} | Open Access 1 | Buena Vista Park | 16493 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.147 | Buena Vista Park | 2004 | |
1705 | 1705 | 1704 | {"type": "Polygon", "coordinates": [[[-121.75759, 37.30772], [-121.75723, 37.3079], [-121.7574, 37.30815], [-121.75736, 37.30818], [-121.7573, 37.30817], [-121.75713, 37.30796], [-121.75708, 37.30783], [-121.75703, 37.30764], [-121.75707, 37.30757], [-121.75706, 37.3075], [-121.75701, 37.30746], [-121.75694, 37.30744], [-121.75688, 37.30733], [-121.75718, 37.30743], [-121.7573, 37.30749], [-121.75744, 37.30758], [-121.75759, 37.30772]]]} | Open Access 1 | Pocket Park No. 19 | 23828 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.523 | PP No. 19 | 2004 | |
2475 | 2475 | 2474 | {"type": "Polygon", "coordinates": [[[-121.90575, 37.3289], [-121.90546, 37.32891], [-121.9054, 37.32894], [-121.90536, 37.32899], [-121.90535, 37.32904], [-121.90539, 37.32905], [-121.90543, 37.32964], [-121.90462, 37.32968], [-121.90458, 37.32909], [-121.9046, 37.32908], [-121.9046, 37.32905], [-121.90456, 37.32899], [-121.90449, 37.32896], [-121.90424, 37.32896], [-121.90419, 37.32828], [-121.90509, 37.32824], [-121.90511, 37.32842], [-121.90563, 37.3284], [-121.90573, 37.32842], [-121.90575, 37.3289]]]} | Open Access 1 | Cahill Park | 16656 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.712 | Cahill Park | 2004 | |
3014 | 3014 | 3013 | {"type": "Polygon", "coordinates": [[[-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251]]]} | Open Access 1 | Classico Park | 17392 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.476 | Classico Park | 2004 | |
3204 | 3204 | 3203 | {"type": "MultiPolygon", "coordinates": [[[[-121.76776, 37.31275], [-121.76743, 37.31279], [-121.76713, 37.31286], [-121.76708, 37.31283], [-121.767, 37.31282], [-121.76693, 37.31285], [-121.7669, 37.31289], [-121.76658, 37.31288], [-121.76656, 37.31284], [-121.76616, 37.31274], [-121.76601, 37.31272], [-121.76564, 37.31277], [-121.76555, 37.31276], [-121.76549, 37.3128], [-121.76473, 37.31291], [-121.76467, 37.31266], [-121.76469, 37.31264], [-121.76589, 37.31246], [-121.76603, 37.31245], [-121.76628, 37.31247], [-121.76657, 37.31256], [-121.76671, 37.31258], [-121.76687, 37.31258], [-121.76765, 37.31251], [-121.76772, 37.31256], [-121.76776, 37.31275]]], [[[-121.7705, 37.31315], [-121.77014, 37.31317], [-121.7698, 37.31322], [-121.76982, 37.31314], [-121.76981, 37.31309], [-121.76976, 37.31305], [-121.76967, 37.31304], [-121.76963, 37.31294], [-121.76915, 37.31273], [-121.76885, 37.31278], [-121.76885, 37.31271], [-121.7688, 37.31267], [-121.76871, 37.31265], [-121.76864, 37.31269], [-121.76856, 37.31265], [-121.76795, 37.31274], [-121.76789, 37.31251], [-121.76794, 37.31247], [-121.76849, 37.31239], [-121.76881, 37.31239], [-121.76901, 37.31242], [-121.77002, 37.31283], [-121.77043, 37.31294], [-121.77046, 37.31297], [-121.7705, 37.31315]]], [[[-121.77291, 37.31277], [-121.77226, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31317], [-121.77068, 37.31313], [-121.77067, 37.31308], [-121.77069, 37.31303], [-121.77075, 37.31301], [-121.77124, 37.31305], [-121.77155, 37.31304], [-121.77186, 37.31299], [-121.77225, 37.31288], [-121.7728, 37.31265], [-121.77284, 37.31266], [-121.77291, 37.31277]]], [[[-121.77541, 37.31297], [-121.77534, 37.31303], [-121.77514, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77413, 37.31252], [-121.77381, 37.31251], [-121.7735, 37.31255], [-121.7732, 37.31263], [-121.77317, 37.31255], [-121.77319, 37.31252], [-121.77324, 37.31249], [-121.7736, 37.31241], [-121.77378, 37.3124], [-121.77414, 37.3124], [-121.77449, 37.31245], [-121.77474, 37.31252], [-121.7749, 37.31259], [-121.7752, 37.31276], [-121.7754, 37.31291], [-121.77541, 37.31297]]]]} | Open Access 1 | Cortona Park | 17666 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.316 | Cortona Park | 2004 | |
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | Evergreen Village Park | 18768 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.805 | Evergreen Village Park | 2004 | |
4172 | 4172 | 4171 | {"type": "MultiPolygon", "coordinates": [[[[-121.76247, 37.30719], [-121.76236, 37.30725], [-121.76225, 37.30735], [-121.76221, 37.30737], [-121.76214, 37.30736], [-121.76213, 37.30711], [-121.76208, 37.30692], [-121.76216, 37.30688], [-121.76213, 37.30675], [-121.76204, 37.30675], [-121.76196, 37.30638], [-121.76204, 37.30635], [-121.762, 37.30621], [-121.76192, 37.30621], [-121.76183, 37.30585], [-121.76192, 37.30581], [-121.76188, 37.30567], [-121.76179, 37.30568], [-121.76168, 37.30523], [-121.76197, 37.3051], [-121.76208, 37.30559], [-121.76204, 37.30563], [-121.76203, 37.30569], [-121.76206, 37.30574], [-121.76214, 37.30577], [-121.76228, 37.30637], [-121.76224, 37.30642], [-121.76223, 37.30647], [-121.76227, 37.30652], [-121.76231, 37.30655], [-121.76247, 37.30719]]], [[[-121.76236, 37.30865], [-121.76236, 37.30869], [-121.76232, 37.30871], [-121.76223, 37.30854], [-121.76217, 37.30835], [-121.76199, 37.30829], [-121.76201, 37.30822], [-121.76201, 37.30816], [-121.76198, 37.30809], [-121.76194, 37.30803], [-121.76208, 37.30792], [-121.76204, 37.30773], [-121.76208, 37.3075], [-121.76212, 37.30756], [-121.76209, 37.30773], [-121.76209, 37.30788], [-121.76222, 37.30838], [-121.76227, 37.30851], [-121.76236, 37.30865]]], [[[-121.76263, 37.3073], [-121.76256, 37.30759], [-121.76243, 37.30763], [-121.7625, 37.30796], [-121.76237, 37.30797], [-121.76232, 37.30794], [-121.76229, 37.30783], [-121.76229, 37.30773], [-121.76232, 37.30763], [-121.76236, 37.30753], [-121.76243, 37.30744], [-121.76252, 37.30736], [-121.76263, 37.3073]]], [[[-121.76283, 37.30873], [-121.76266, 37.30866], [-121.7625, 37.3085], [-121.76244, 37.30841], [-121.76241, 37.30832], [-121.76241, 37.30828], [-121.76243, 37.30824], [-121.76246, 37.30822], [-121.76255, 37.3082], [-121.76263, 37.30853], [-121.76278, 37.30852], [-121.76283, 37.30873]]], [[[-121.76371, 37.31256], [-121.76359, 37.31258], [-121.76361, 37.3127], [-121.76353, 37.31271], [-121.76263, 37.30883], [-121.76275, 37.30888], [-121.76289, 37.30892], [-121.76314, 37.30895], [-121.76314, 37.30904], [-121.76312, 37.30915], [-121.76296, 37.30933], [-121.76302, 37.30961], [-121.76299, 37.30965], [-121.76298, 37.3097], [-121.76301, 37.30974], [-121.76306, 37.30977], [-121.76319, 37.31034], [-121.76316, 37.31038], [-121.76316, 37.31043], [-121.76319, 37.31047], [-121.76323, 37.3105], [-121.76336, 37.31106], [-121.76333, 37.3111], [-121.76333, 37.31116], [-121.76336, 37.3112], [-121.7634, 37.31123], [-121.76353, 37.3118], [-121.7635, 37.31184], [-121.76349, 37.31188], [-121.76352, 37.31193], [-121.76357, 37.31196], [-121.76371, 37.31256]]]]} | Open Access 1 | Falls Creek Linear Park | 18837 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.277 | Falls Creek Linear Park | 2004 | |
4350 | 4350 | 4349 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76447, 37.31478], [-121.76431, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | Fowler Creek Community Park | 19029 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 12.45 | Fowler Creek Community Park | 2004 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);