units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 192 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 3
- Local Park 30
- Local Recreation Area 1
- None 1
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Rancho Cucamonga, City of · 32 ✖
ACCESS_TYP 1
- Open Access 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14728 | 14728 | 14727 | {"type": "Polygon", "coordinates": [[[-117.61755, 34.09674], [-117.61753, 34.09759], [-117.61599, 34.09759], [-117.61599, 34.09673], [-117.61755, 34.09674]]]} | Open Access 1 | 45080 | Los Amigos Park | 32565 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parkdev/whatsnew/southwest_cucamonga_pk.asp | San Bernardino 22 | 3.359 | Los Amigos Park | 2017 | Local Park 2 | 4 |
12925 | 12925 | 12924 | {"type": "Polygon", "coordinates": [[[-117.49941, 34.14492], [-117.49907, 34.14538], [-117.499, 34.14539], [-117.49869, 34.14526], [-117.49829, 34.14513], [-117.49797, 34.14504], [-117.49755, 34.14495], [-117.49749, 34.1449], [-117.49753, 34.1447], [-117.4976, 34.14452], [-117.49759, 34.14445], [-117.49757, 34.1444], [-117.4975, 34.14434], [-117.49741, 34.14431], [-117.49713, 34.14433], [-117.49714, 34.14319], [-117.49775, 34.14287], [-117.49844, 34.14379], [-117.49915, 34.14424], [-117.49895, 34.14447], [-117.49893, 34.14454], [-117.49894, 34.14461], [-117.49899, 34.14468], [-117.49904, 34.14472], [-117.49923, 34.14478], [-117.4994, 34.14487], [-117.49941, 34.14492]]]} | Open Access 1 | 30381 | Olive Grove Park | 23123 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 7.678 | Olive Grove Park | 0 | Local Park 2 | 4 | |
12924 | 12924 | 12923 | {"type": "Polygon", "coordinates": [[[-117.5037, 34.14541], [-117.50369, 34.14676], [-117.50334, 34.14676], [-117.5033, 34.1468], [-117.50317, 34.14675], [-117.50253, 34.14677], [-117.50231, 34.14673], [-117.50211, 34.14666], [-117.50193, 34.14654], [-117.50182, 34.14643], [-117.5017, 34.14623], [-117.50167, 34.14609], [-117.50167, 34.14596], [-117.5017, 34.14584], [-117.50175, 34.14573], [-117.50181, 34.14563], [-117.50191, 34.14552], [-117.50204, 34.14543], [-117.50218, 34.14536], [-117.50233, 34.14531], [-117.50248, 34.14529], [-117.50293, 34.14529], [-117.50316, 34.14532], [-117.50324, 34.1453], [-117.5033, 34.14527], [-117.50346, 34.14541], [-117.5037, 34.14541]]]} | Open Access 1 | 30380 | Rancho Summit Park | 24180 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 6.699 | Rancho Summit Park | 0 | Local Park 2 | 4 | |
10816 | 10816 | 10815 | {"type": "Polygon", "coordinates": [[[-117.61614, 34.13634], [-117.61177, 34.13636], [-117.61176, 34.13545], [-117.61313, 34.13546], [-117.6138, 34.1355], [-117.61442, 34.13556], [-117.61596, 34.13576], [-117.61607, 34.13582], [-117.61609, 34.13584], [-117.61609, 34.13606], [-117.61614, 34.13606], [-117.61614, 34.13634]]]} | Open Access 1 | 20547 | West Beryl Park | 27351 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 8.742 | West Beryl Park | 0 | Local Park 2 | 4 | |
10812 | 10812 | 10811 | {"type": "Polygon", "coordinates": [[[-117.50032, 34.14794], [-117.50003, 34.14802], [-117.49939, 34.14812], [-117.4988, 34.14812], [-117.49881, 34.1472], [-117.49885, 34.14703], [-117.49894, 34.14688], [-117.49918, 34.14662], [-117.49925, 34.14662], [-117.49954, 34.14686], [-117.4997, 34.14719], [-117.49974, 34.14724], [-117.49981, 34.14727], [-117.49989, 34.14727], [-117.49996, 34.14724], [-117.50001, 34.14718], [-117.50014, 34.14725], [-117.50011, 34.14745], [-117.50001, 34.14751], [-117.49999, 34.14756], [-117.49999, 34.14762], [-117.50003, 34.14767], [-117.50032, 34.14794]]]} | Open Access 1 | 20544 | Legacy Park | 21139 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 3.752 | Legacy Park | 0 | Local Park 2 | 4 | |
10593 | 10593 | 10592 | {"type": "Polygon", "coordinates": [[[-117.61177, 34.13636], [-117.60738, 34.13639], [-117.60737, 34.13547], [-117.61176, 34.13545], [-117.61177, 34.13636]]]} | Open Access 1 | 18863 | East Beryl Park | 18363 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 10.114 | East Beryl Park | 0 | Local Park 2 | 4 | |
10398 | 10398 | 10397 | {"type": "Polygon", "coordinates": [[[-117.53649, 34.14524], [-117.53433, 34.14524], [-117.53433, 34.14499], [-117.53449, 34.14498], [-117.53449, 34.14328], [-117.53649, 34.1433], [-117.53649, 34.14524]]]} | Open Access 1 | 18377 | Day Creek Park | 17960 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 9.993 | Day Creek Park | 0 | Local Park 2 | 4 | |
9434 | 9434 | 9433 | {"type": "Polygon", "coordinates": [[[-117.58363, 34.1155], [-117.58255, 34.1155], [-117.58254, 34.11586], [-117.58169, 34.11586], [-117.58168, 34.11413], [-117.58362, 34.11413], [-117.58363, 34.1155]]]} | Open Access 1 | 15774 | Church Street Park | 17249 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 7.509 | Church Street Park | 0 | Local Park 2 | 4 | |
9270 | 9270 | 9269 | {"type": "Polygon", "coordinates": [[[-117.53133, 34.13041], [-117.53108, 34.13044], [-117.5309, 34.13049], [-117.53076, 34.13056], [-117.53039, 34.13032], [-117.53019, 34.13024], [-117.53009, 34.13041], [-117.52966, 34.13029], [-117.52943, 34.13018], [-117.52937, 34.13001], [-117.52928, 34.12986], [-117.52917, 34.12972], [-117.52917, 34.12847], [-117.52962, 34.12845], [-117.52987, 34.12838], [-117.53001, 34.12857], [-117.53014, 34.12872], [-117.53054, 34.12907], [-117.53089, 34.12928], [-117.53113, 34.12938], [-117.53132, 34.12944], [-117.53133, 34.13041]]]} | Open Access 1 | 15436 | Windrows Park | 27633 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 8.035 | Windrows Park | 0 | Local Park 2 | 4 | |
9181 | 9181 | 9180 | {"type": "Polygon", "coordinates": [[[-117.56307, 34.11333], [-117.56137, 34.11355], [-117.55999, 34.11337], [-117.5587, 34.11341], [-117.5587, 34.11307], [-117.55975, 34.11303], [-117.56041, 34.11281], [-117.56074, 34.11249], [-117.56208, 34.11289], [-117.56255, 34.11292], [-117.56305, 34.11322], [-117.56307, 34.11333]]]} | Open Access 1 | 15242 | West Greenway Park | 27358 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 6.092 | West Greenway Park | 0 | Local Park 2 | 4 | |
9100 | 9100 | 9099 | {"type": "Polygon", "coordinates": [[[-117.54994, 34.12662], [-117.54984, 34.12663], [-117.54975, 34.12668], [-117.54969, 34.12674], [-117.54964, 34.12685], [-117.54958, 34.12688], [-117.54963, 34.12708], [-117.54962, 34.12726], [-117.54957, 34.12741], [-117.54945, 34.12762], [-117.54942, 34.12774], [-117.54943, 34.12786], [-117.54947, 34.12797], [-117.54954, 34.12806], [-117.54973, 34.12825], [-117.54977, 34.12834], [-117.5498, 34.12844], [-117.54927, 34.1285], [-117.54833, 34.12851], [-117.54828, 34.12814], [-117.5481, 34.12757], [-117.54808, 34.12755], [-117.54788, 34.12758], [-117.5478, 34.12752], [-117.54792, 34.12745], [-117.54792, 34.12725], [-117.54819, 34.12682], [-117.54824, 34.12664], [-117.54834, 34.12661], [-117.54994, 34.12662]]]} | Open Access 1 | 15084 | Vintage Park | 27149 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 6.946 | Vintage Park | 0 | Local Park 2 | 4 | |
9082 | 9082 | 9081 | {"type": "Polygon", "coordinates": [[[-117.56414, 34.12925], [-117.56402, 34.12933], [-117.56396, 34.12944], [-117.56397, 34.12957], [-117.56407, 34.12973], [-117.56409, 34.12981], [-117.56406, 34.12991], [-117.56395, 34.13006], [-117.56393, 34.13018], [-117.56339, 34.13017], [-117.56292, 34.13034], [-117.56267, 34.13048], [-117.56224, 34.13067], [-117.56193, 34.13074], [-117.56162, 34.13072], [-117.56158, 34.13021], [-117.56161, 34.13001], [-117.56166, 34.12987], [-117.56173, 34.12976], [-117.56185, 34.12965], [-117.56197, 34.12956], [-117.56215, 34.12948], [-117.56234, 34.12943], [-117.56384, 34.12931], [-117.56414, 34.12925]]]} | Open Access 1 | 15038 | Victoria Groves Park | 27076 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 6.032 | Victoria Groves Park | 0 | Local Park 2 | 4 | |
9079 | 9079 | 9078 | {"type": "Polygon", "coordinates": [[[-117.53196, 34.11849], [-117.53188, 34.11849], [-117.53143, 34.11859], [-117.53091, 34.11881], [-117.53074, 34.11884], [-117.53055, 34.11885], [-117.53004, 34.11879], [-117.52966, 34.11909], [-117.52951, 34.11906], [-117.52948, 34.11906], [-117.52938, 34.11883], [-117.52948, 34.11883], [-117.52972, 34.11845], [-117.5302, 34.11791], [-117.53009, 34.11778], [-117.52983, 34.11777], [-117.52972, 34.11768], [-117.52972, 34.11757], [-117.52984, 34.11748], [-117.53069, 34.11748], [-117.5307, 34.11652], [-117.53183, 34.11653], [-117.53187, 34.11657], [-117.5319, 34.1178], [-117.53187, 34.11788], [-117.53177, 34.11802], [-117.53175, 34.11814], [-117.53178, 34.11826], [-117.5319, 34.11839], [-117.53196, 34.11849]]]} | Open Access 1 | 15034 | Victoria Arbors Park | 27072 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 9.498 | Victoria Arbors Park | 0 | Local Park 2 | 4 | |
7842 | 7842 | 7841 | {"type": "MultiPolygon", "coordinates": [[[[-117.56281, 34.1216], [-117.56283, 34.12193], [-117.56279, 34.12211], [-117.56269, 34.1223], [-117.56263, 34.1225], [-117.56259, 34.12278], [-117.56252, 34.12304], [-117.56237, 34.12323], [-117.56219, 34.12338], [-117.56211, 34.12352], [-117.56203, 34.1237], [-117.56198, 34.12388], [-117.56185, 34.12404], [-117.56168, 34.12419], [-117.56152, 34.1243], [-117.56122, 34.12437], [-117.56085, 34.12438], [-117.5605, 34.12442], [-117.5601, 34.12451], [-117.55978, 34.12461], [-117.55959, 34.1247], [-117.5594, 34.12471], [-117.55924, 34.12466], [-117.55858, 34.12465], [-117.55858, 34.1216], [-117.56281, 34.1216]]], [[[-117.57053, 34.12177], [-117.56857, 34.12529], [-117.55858, 34.12512], [-117.55858, 34.12485], [-117.55924, 34.12484], [-117.5594, 34.12479], [-117.55955, 34.12478], [-117.55994, 34.12463], [-117.56027, 34.12453], [-117.5606, 34.12447], [-117.56086, 34.12445], [-117.56107, 34.12445], [-117.5613, 34.12443], [-117.56155, 34.12435], [-117.56176, 34.12424], [-117.5619, 34.12411], [-117.56204, 34.12393], [-117.56217, 34.12359], [-117.56227, 34.12344], [-117.56243, 34.12326], [-117.56258, 34.12306], [-117.56267, 34.12283], [-117.56272, 34.12247], [-117.56279, 34.12228], [-117.56289, 34.1221], [-117.56305, 34.12193], [-117.56305, 34.12161], [-117.57045, 34.12161], [-117.57046, 34.12166], [-117.57053, 34.12177]]]]} | Open Access 1 | 9411 | Central Park | 17056 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 98.798 | Central Park | 0 | Local Park 2 | 4 | |
7832 | 7832 | 7831 | {"type": "Polygon", "coordinates": [[[-117.56449, 34.10877], [-117.56445, 34.10893], [-117.56447, 34.10923], [-117.56442, 34.10942], [-117.56436, 34.10943], [-117.56436, 34.10957], [-117.56384, 34.10954], [-117.56375, 34.10981], [-117.56294, 34.10965], [-117.56266, 34.10962], [-117.56257, 34.10986], [-117.56219, 34.11032], [-117.56197, 34.11016], [-117.5618, 34.10996], [-117.56169, 34.10978], [-117.56161, 34.10957], [-117.56157, 34.10937], [-117.56157, 34.10877], [-117.56158, 34.10874], [-117.56162, 34.10872], [-117.56234, 34.10868], [-117.56235, 34.10866], [-117.56326, 34.10866], [-117.56395, 34.1087], [-117.56449, 34.10877]]]} | Open Access 1 | 9315 | Ralph M. Lewis Park | 24102 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 8.007 | Ralph M. Lewis Park | 0 | Local Park 2 | 4 | |
7215 | 7215 | 7214 | {"type": "Polygon", "coordinates": [[[-117.58661, 34.0937], [-117.58559, 34.0937], [-117.58559, 34.09324], [-117.58528, 34.09323], [-117.58526, 34.0921], [-117.58661, 34.09211], [-117.58661, 34.0937]]]} | Open Access 1 | 6374 | Old Town Park | 23107 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 5.027 | Old Town Park | 0 | Local Park 2 | 4 | |
6942 | 6942 | 6941 | {"type": "Polygon", "coordinates": [[[-117.51917, 34.10877], [-117.51915, 34.1097], [-117.51866, 34.10973], [-117.51823, 34.10979], [-117.51786, 34.10987], [-117.51696, 34.11012], [-117.51698, 34.10934], [-117.51768, 34.10875], [-117.51917, 34.10877]]]} | Open Access 1 | 5843 | Garcia Park | 19192 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 5.56 | Garcia Park | 0 | Local Park 2 | 4 | |
6539 | 6539 | 6538 | {"type": "Polygon", "coordinates": [[[-117.60777, 34.09942], [-117.60777, 34.10111], [-117.60747, 34.10107], [-117.60668, 34.10107], [-117.60668, 34.09941], [-117.60777, 34.09942]]]} | Open Access 1 | 2967 | Bear Gulch Park | 15926 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 4.563 | Bear Gulch Park | 0 | Local Park 2 | 4 | |
6526 | 6526 | 6525 | {"type": "MultiPolygon", "coordinates": [[[[-117.55404, 34.1321], [-117.55402, 34.1321], [-117.55405, 34.1321], [-117.55404, 34.1321]]], [[[-117.55624, 34.13237], [-117.55629, 34.13266], [-117.5562, 34.13345], [-117.55598, 34.13391], [-117.55526, 34.13366], [-117.55459, 34.13349], [-117.5539, 34.13338], [-117.55319, 34.13332], [-117.55324, 34.13329], [-117.55328, 34.13323], [-117.55333, 34.1332], [-117.55361, 34.13321], [-117.55381, 34.13316], [-117.55396, 34.13307], [-117.55405, 34.13298], [-117.55413, 34.13281], [-117.55415, 34.13248], [-117.55422, 34.13222], [-117.55419, 34.13215], [-117.55405, 34.1321], [-117.55624, 34.13237]]]]} | Open Access 1 | 2845 | Kenyon Park | 20625 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 7.86 | Kenyon Park | 0 | Local Park 2 | 4 | |
6357 | 6357 | 6356 | {"type": "Polygon", "coordinates": [[[-117.5846, 34.13116], [-117.58458, 34.13119], [-117.58453, 34.13122], [-117.58266, 34.13123], [-117.58263, 34.12928], [-117.58458, 34.12927], [-117.5846, 34.13116]]]} | Open Access 1 | 1763 | Hermosa Park | 19870 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 9.576 | Hermosa 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]);