units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2 and MNG_AGENCY = 32 sorted by MNG_AG_TYP
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 160
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 161
MNG_AGENCY 1
- San Jose, City of · 161 ✖
DES_TP 1
- Local Park · 161 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1236 | 1236 | 1235 | {"type": "Polygon", "coordinates": [[[-121.79176, 37.32836], [-121.79033, 37.3288], [-121.79007, 37.32825], [-121.79043, 37.32791], [-121.79028, 37.32778], [-121.79036, 37.32774], [-121.79023, 37.32751], [-121.78996, 37.32754], [-121.78992, 37.32741], [-121.79122, 37.32722], [-121.79176, 37.32836]]]} | Open Access 1 | 8978 | Norwood Creek Park | 22906 | 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 | 4.234 | Norwood Creek Park | 1992 | Local Park 2 | 4 | |
1242 | 1242 | 1241 | {"type": "MultiPolygon", "coordinates": [[[[-121.77122, 37.32389], [-121.77105, 37.32387], [-121.77102, 37.32367], [-121.77098, 37.32363], [-121.77095, 37.32344], [-121.77113, 37.32346], [-121.77115, 37.32364], [-121.77119, 37.32368], [-121.77122, 37.32389]]], [[[-121.77133, 37.32443], [-121.77116, 37.32444], [-121.77111, 37.32402], [-121.77128, 37.32402], [-121.77133, 37.32443]]], [[[-121.77142, 37.32496], [-121.77125, 37.32498], [-121.77117, 37.32458], [-121.77135, 37.32456], [-121.77142, 37.32496]]]]} | Open Access 1 | 9136 | Pocket Park No. 4 | 23834 | 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.527 | PP No. 4 | 2004 | Local Park 2 | 4 | |
1405 | 1405 | 1404 | {"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 | 9014 | Pocket Park No. 11 | 23822 | 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.329 | PP No. 11 | 2004 | Local Park 2 | 4 | |
1415 | 1415 | 1414 | {"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.76657, 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.31238], [-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.77227, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31318], [-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.77537, 37.31301], [-121.77534, 37.31303], [-121.77515, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77412, 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], [-121.77537, 37.31301]]]]} | Open Access 1 | 8906 | Cortona Park | 17666 | 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 | 5.315 | Cortona Park | 2004 | Local Park 2 | 4 | |
1417 | 1417 | 1416 | {"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 | 8957 | Michelangelo Park | 22198 | 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.844 | Michelangelo Park | 2007 | Local Park 2 | 4 | |
1423 | 1423 | 1422 | {"type": "MultiPolygon", "coordinates": [[[[-121.78009, 37.31127], [-121.77989, 37.31137], [-121.77994, 37.31162], [-121.77991, 37.31167], [-121.77993, 37.31173], [-121.77978, 37.31181], [-121.78003, 37.31291], [-121.77984, 37.31293], [-121.7796, 37.31189], [-121.77937, 37.31162], [-121.77968, 37.31144], [-121.78008, 37.31124], [-121.78009, 37.31127]]], [[[-121.78054, 37.31411], [-121.77993, 37.31421], [-121.77983, 37.31377], [-121.78044, 37.31368], [-121.78054, 37.31411]]], [[[-121.7802, 37.31358], [-121.78, 37.31361], [-121.7799, 37.31318], [-121.7801, 37.31315], [-121.7802, 37.31358]]], [[[-121.78046, 37.31471], [-121.78026, 37.31474], [-121.78016, 37.3143], [-121.78036, 37.31427], [-121.78046, 37.31471]]]]} | Open Access 1 | 9205 | Tapestry Park | 26184 | 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 | 2.08 | Tapestry Park | 1984 | Local Park 2 | 4 | |
1427 | 1427 | 1426 | {"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 | 9084 | Pocket Park No. 18 | 23827 | 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.285 | PP No. 18 | 2004 | Local Park 2 | 4 | |
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 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 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
1450 | 1450 | 1449 | {"type": "Polygon", "coordinates": [[[-121.79984, 37.29776], [-121.79995, 37.29788], [-121.80108, 37.29865], [-121.80193, 37.29927], [-121.80227, 37.29957], [-121.80229, 37.29962], [-121.80228, 37.29968], [-121.80223, 37.29972], [-121.80217, 37.29974], [-121.80167, 37.29976], [-121.80127, 37.29971], [-121.80083, 37.29959], [-121.80041, 37.29941], [-121.80028, 37.29934], [-121.79935, 37.29865], [-121.79849, 37.29807], [-121.7982, 37.29794], [-121.79762, 37.29775], [-121.79726, 37.2977], [-121.79688, 37.29768], [-121.79618, 37.29772], [-121.79586, 37.29771], [-121.79542, 37.29766], [-121.79511, 37.29759], [-121.79493, 37.29754], [-121.79489, 37.2975], [-121.79488, 37.29746], [-121.79492, 37.29733], [-121.79496, 37.2973], [-121.79501, 37.29728], [-121.79528, 37.29728], [-121.79537, 37.29731], [-121.79733, 37.29722], [-121.79798, 37.29744], [-121.79841, 37.29762], [-121.79914, 37.29778], [-121.79984, 37.29776]]]} | Open Access 1 | 9709 | Silver Creek Linear Park | 25483 | 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 | 11.638 | Silver Creek Linear Park | 1997 | Local Park 2 | 4 | |
1609 | 1609 | 1608 | {"type": "Polygon", "coordinates": [[[-121.87741, 37.32001], [-121.87733, 37.32006], [-121.8769, 37.31949], [-121.87741, 37.32001], [-121.87741, 37.32001]]]} | Open Access 1 | 13645 | Caldwallder Park | 16674 | 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.082 | Caldwallder Park | 0 | Local Park 2 | 4 | |
1790 | 1790 | 1789 | {"type": "Polygon", "coordinates": [[[-121.83645, 37.24059], [-121.83612, 37.24066], [-121.83588, 37.24074], [-121.83565, 37.24083], [-121.83516, 37.24109], [-121.83514, 37.23933], [-121.83481, 37.2392], [-121.83482, 37.23916], [-121.83514, 37.23922], [-121.83514, 37.23927], [-121.83645, 37.24059]]]} | Open Access 1 | 13489 | Comanche Park | 17557 | 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 | 2.783 | Comanche Park | 1982 | Local Park 2 | 4 | |
1803 | 1803 | 1802 | {"type": "Polygon", "coordinates": [[[-121.84745, 37.20134], [-121.84565, 37.20254], [-121.84563, 37.20249], [-121.84558, 37.20245], [-121.84551, 37.20245], [-121.84545, 37.20247], [-121.84542, 37.20251], [-121.84541, 37.20256], [-121.84544, 37.2026], [-121.84551, 37.20264], [-121.8452, 37.20285], [-121.84461, 37.20322], [-121.8433, 37.20177], [-121.84341, 37.20185], [-121.84347, 37.20186], [-121.84352, 37.20184], [-121.84355, 37.2018], [-121.84354, 37.20175], [-121.84342, 37.20169], [-121.84517, 37.20043], [-121.84539, 37.20021], [-121.84556, 37.19995], [-121.84566, 37.20001], [-121.84567, 37.20007], [-121.84573, 37.20011], [-121.84578, 37.20011], [-121.84589, 37.20008], [-121.84634, 37.20012], [-121.8466, 37.20018], [-121.84684, 37.20031], [-121.8472, 37.20066], [-121.84718, 37.20071], [-121.8472, 37.20078], [-121.84745, 37.20134]]]} | Open Access 1 | 13649 | Cathedral Oaks Park | 16975 | 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 | 16.969 | Cathedral Oaks Park | 0 | Local Park 2 | 4 | |
1804 | 1804 | 1803 | {"type": "Polygon", "coordinates": [[[-121.84341, 37.36447], [-121.84319, 37.36462], [-121.84225, 37.36365], [-121.84266, 37.36339], [-121.84316, 37.36423], [-121.84341, 37.36447]]]} | Open Access 1 | 13651 | Children of the Rainbow Park | 17197 | 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.1 | Children of the Rainbow Park | 1989 | Local Park 2 | 4 | |
1805 | 1805 | 1804 | {"type": "Polygon", "coordinates": [[[-121.88006, 37.33079], [-121.87965, 37.33098], [-121.87955, 37.33084], [-121.87991, 37.33067], [-121.87982, 37.33052], [-121.87985, 37.33051], [-121.88006, 37.33079]]]} | Open Access 1 | 13703 | O'Donnell Garden Park | 22946 | 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.201 | O'Donnell Garden Park | 1940 | Local Park 2 | 4 | |
1806 | 1806 | 1805 | {"type": "MultiPolygon", "coordinates": [[[[-121.83002, 37.34971], [-121.82992, 37.34978], [-121.82949, 37.34934], [-121.82959, 37.34928], [-121.83002, 37.34971]]], [[[-121.83066, 37.3502], [-121.83045, 37.35034], [-121.83004, 37.34991], [-121.83014, 37.34984], [-121.83034, 37.35006], [-121.83045, 37.34999], [-121.83066, 37.3502]]]]} | Open Access 1 | 13706 | Our Park | 23268 | 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.437 | Our Park | 1971 | Local Park 2 | 4 | |
1807 | 1807 | 1806 | {"type": "Polygon", "coordinates": [[[-121.90114, 37.3155], [-121.90116, 37.31561], [-121.90116, 37.31572], [-121.90114, 37.31582], [-121.9011, 37.31592], [-121.90019, 37.31569], [-121.90017, 37.31567], [-121.90019, 37.31565], [-121.90111, 37.31549], [-121.90114, 37.3155]]]} | Open Access 1 | 13708 | Palm Haven Plaza | 23339 | 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.563 | Palm Haven Plaza | 1990 | Local Park 2 | 4 | |
1810 | 1810 | 1809 | {"type": "Polygon", "coordinates": [[[-121.91563, 37.36258], [-121.91482, 37.36298], [-121.91447, 37.36254], [-121.91522, 37.36207], [-121.91563, 37.36258]]]} | Open Access 1 | 13739 | Rosemary Gardens Park | 24619 | 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.306 | Rosemary Gardens Park | 1972 | Local Park 2 | 4 | |
1811 | 1811 | 1810 | {"type": "Polygon", "coordinates": [[[-121.87893, 37.28067], [-121.87888, 37.28071], [-121.87872, 37.28064], [-121.87863, 37.28065], [-121.87791, 37.28092], [-121.87784, 37.28092], [-121.87762, 37.28056], [-121.87756, 37.28043], [-121.87735, 37.28009], [-121.87731, 37.27998], [-121.87714, 37.27971], [-121.87707, 37.27964], [-121.87688, 37.27961], [-121.87685, 37.27954], [-121.87753, 37.27925], [-121.87773, 37.27952], [-121.87841, 37.28024], [-121.87893, 37.28067]]]} | Open Access 1 | 13741 | Rubino Park | 24723 | 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.22 | Rubino Park | 2000 | Local Park 2 | 4 | |
1812 | 1812 | 1811 | {"type": "Polygon", "coordinates": [[[-121.89561, 37.25718], [-121.89547, 37.25727], [-121.89533, 37.25733], [-121.89499, 37.25756], [-121.89484, 37.2574], [-121.89484, 37.25737], [-121.89487, 37.25734], [-121.89544, 37.25705], [-121.89551, 37.25706], [-121.89561, 37.25718]]]} | Open Access 1 | 13746 | Scottsdale Park | 25216 | 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.386 | Scottsdale Park | 1997 | Local Park 2 | 4 | |
1813 | 1813 | 1812 | {"type": "Polygon", "coordinates": [[[-121.85647, 37.27809], [-121.85646, 37.2782], [-121.85641, 37.2783], [-121.85628, 37.27849], [-121.8561, 37.27863], [-121.85589, 37.27872], [-121.85573, 37.27876], [-121.85558, 37.27877], [-121.8545, 37.27877], [-121.85445, 37.27874], [-121.85445, 37.27809], [-121.85647, 37.27809]]]} | Open Access 1 | 13748 | Waterford Park | 27300 | 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 | 2.997 | Waterford Park | 2003 | 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]);