units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 494 and MNG_AG_TYP = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 34
- Local Recreation Area 5
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 41 ✖
MNG_AGENCY 1
- Southgate Recreation and Park District · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11719 | 11719 | 11718 | {"type": "Polygon", "coordinates": [[[-121.46013, 38.50773], [-121.45932, 38.50773], [-121.45933, 38.50852], [-121.45855, 38.50763], [-121.45817, 38.50721], [-121.45703, 38.50611], [-121.45794, 38.50611], [-121.4579, 38.50626], [-121.45791, 38.50632], [-121.45798, 38.5064], [-121.45808, 38.50643], [-121.45815, 38.50643], [-121.4583, 38.50639], [-121.4593, 38.50638], [-121.45931, 38.5068], [-121.46012, 38.5068], [-121.46013, 38.50773]]]} | Open Access 1 | 24015 | Bowling Green Park | 16311 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.158 | Bowling Green Park | 0 | Local Park 2 | 4 | |
2246 | 2246 | 2245 | {"type": "Polygon", "coordinates": [[[-121.33204, 38.46376], [-121.33196, 38.46381], [-121.33192, 38.46388], [-121.33192, 38.46393], [-121.33195, 38.46402], [-121.33195, 38.46443], [-121.33194, 38.46446], [-121.3319, 38.46448], [-121.33169, 38.46449], [-121.33126, 38.46455], [-121.33095, 38.46455], [-121.33077, 38.46453], [-121.33071, 38.46454], [-121.33064, 38.46459], [-121.33061, 38.46464], [-121.3306, 38.46469], [-121.33028, 38.46469], [-121.33027, 38.46527], [-121.33022, 38.46521], [-121.33022, 38.46349], [-121.33204, 38.46348], [-121.33204, 38.46376]]]} | Open Access 1 | 47905 | Bradshaw Vineyards Park | 31991 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/parks-a-facilities/parks-information.html | Sacramento 41 | 4.59 | Bradshaw Vineyards Park | 0 | Local Park 2 | 4 |
11747 | 11747 | 11746 | {"type": "MultiPolygon", "coordinates": [[[[-121.32598, 38.45603], [-121.32593, 38.45607], [-121.32592, 38.45613], [-121.32599, 38.45629], [-121.32599, 38.45681], [-121.32597, 38.45684], [-121.32593, 38.45686], [-121.32555, 38.4569], [-121.32531, 38.45695], [-121.32508, 38.45702], [-121.32483, 38.45713], [-121.32478, 38.45712], [-121.32474, 38.4571], [-121.32435, 38.45667], [-121.32427, 38.45652], [-121.3242, 38.45629], [-121.32419, 38.45585], [-121.32572, 38.45585], [-121.32572, 38.45599], [-121.32587, 38.45599], [-121.32598, 38.45603]]], [[[-121.38888, 38.45574], [-121.38855, 38.45574], [-121.38854, 38.45632], [-121.38821, 38.45632], [-121.38824, 38.45615], [-121.38823, 38.4561], [-121.38818, 38.45605], [-121.38807, 38.45602], [-121.38795, 38.45605], [-121.3878, 38.45605], [-121.38776, 38.45603], [-121.38773, 38.456], [-121.38774, 38.4555], [-121.38778, 38.45545], [-121.3883, 38.45546], [-121.38838, 38.45541], [-121.38839, 38.45534], [-121.38846, 38.45534], [-121.38887, 38.45523], [-121.38888, 38.45574]]]]} | Open Access 1 | 24040 | Calvine Station Park | 31996 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.167 | Calvine Station Park | 0 | Local Park 2 | 4 | |
11740 | 11740 | 11739 | {"type": "Polygon", "coordinates": [[[-121.36573, 38.47003], [-121.36487, 38.47003], [-121.36487, 38.46908], [-121.36488, 38.46905], [-121.36492, 38.46903], [-121.36572, 38.46903], [-121.36573, 38.47003]]]} | Open Access 1 | 24032 | Carlisle Woods Park | 16857 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.053 | Carlisle Woods Park | 0 | Local Park 2 | 4 | |
4029 | 4029 | 4028 | {"type": "Polygon", "coordinates": [[[-121.36424, 38.46455], [-121.36352, 38.46455], [-121.36364, 38.46426], [-121.36351, 38.46422], [-121.36365, 38.46387], [-121.36365, 38.46358], [-121.36401, 38.46357], [-121.36406, 38.46361], [-121.36408, 38.46382], [-121.36413, 38.46403], [-121.3643, 38.46449], [-121.36429, 38.46453], [-121.36424, 38.46455]]]} | Open Access 1 | 44161 | Caymus Park | 16983 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.303 | Caymus Park | 0 | Local Park 2 | 4 | |
14267 | 14267 | 14266 | {"type": "Polygon", "coordinates": [[[-121.35398, 38.45993], [-121.35397, 38.46027], [-121.35228, 38.46041], [-121.35222, 38.46381], [-121.35161, 38.46378], [-121.35101, 38.46378], [-121.35101, 38.46338], [-121.351, 38.46337], [-121.35101, 38.46333], [-121.35102, 38.4618], [-121.35105, 38.46135], [-121.35105, 38.45992], [-121.35398, 38.45993]]]} | Open Access 1 | 44187 | Churchill Downs Community Park | 17250 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.989 | Churchill Downs Community Park | 0 | Local Park 2 | 4 | |
14266 | 14266 | 14265 | {"type": "Polygon", "coordinates": [[[-121.35779, 38.45983], [-121.35779, 38.4599], [-121.35724, 38.45991], [-121.35723, 38.46], [-121.35685, 38.46011], [-121.3564, 38.46016], [-121.3562, 38.46001], [-121.35594, 38.46023], [-121.35562, 38.4601], [-121.35525, 38.46002], [-121.355, 38.46], [-121.35432, 38.45999], [-121.35428, 38.45996], [-121.35426, 38.45993], [-121.35428, 38.45884], [-121.35554, 38.45884], [-121.35555, 38.45888], [-121.35588, 38.45889], [-121.35588, 38.45896], [-121.35585, 38.45902], [-121.35585, 38.45907], [-121.35587, 38.45912], [-121.35591, 38.45917], [-121.35602, 38.4592], [-121.35614, 38.45918], [-121.35638, 38.45919], [-121.35638, 38.45934], [-121.3563, 38.45971], [-121.35631, 38.45983], [-121.35664, 38.45983], [-121.35667, 38.45982], [-121.35672, 38.45985], [-121.3568, 38.45987], [-121.35685, 38.45985], [-121.35691, 38.45982], [-121.35693, 38.45983], [-121.35755, 38.45983], [-121.35757, 38.45982], [-121.35762, 38.45985], [-121.35768, 38.45986], [-121.35779, 38.45983]]]} | Open Access 1 | 44186 | Cochran Park | 17471 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.249 | Cochran Park | 0 | Local Park 2 | 4 | |
11741 | 11741 | 11740 | {"type": "Polygon", "coordinates": [[[-121.38663, 38.46532], [-121.38661, 38.46533], [-121.38661, 38.46559], [-121.38657, 38.46562], [-121.38653, 38.46568], [-121.38654, 38.46574], [-121.38658, 38.46578], [-121.38641, 38.46592], [-121.38585, 38.46606], [-121.38558, 38.46532], [-121.3859, 38.46532], [-121.38648, 38.46505], [-121.38654, 38.46507], [-121.38662, 38.46507], [-121.38663, 38.46532]]]} | Open Access 1 | 24033 | Cottonwood Park | 17692 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.648 | Cottonwood Park | 0 | Local Park 2 | 4 | |
11744 | 11744 | 11743 | {"type": "Polygon", "coordinates": [[[-121.40565, 38.45943], [-121.40393, 38.45988], [-121.4039, 38.45984], [-121.40385, 38.45943], [-121.40346, 38.45942], [-121.40344, 38.45854], [-121.40239, 38.45852], [-121.40238, 38.4582], [-121.40236, 38.45803], [-121.40231, 38.45783], [-121.40222, 38.45762], [-121.40223, 38.45758], [-121.40227, 38.45755], [-121.40258, 38.45749], [-121.40277, 38.45747], [-121.40306, 38.45748], [-121.40345, 38.45755], [-121.40409, 38.45774], [-121.40427, 38.45778], [-121.40452, 38.45781], [-121.40499, 38.45781], [-121.40503, 38.45783], [-121.40507, 38.45787], [-121.40515, 38.45827], [-121.4053, 38.45873], [-121.40543, 38.45904], [-121.40565, 38.45943]]]} | Open Access 1 | 24037 | Countryside Comm. Park | 17707 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.163 | Countryside Comm. Park | 0 | Local Park 2 | 4 | |
11724 | 11724 | 11723 | {"type": "Polygon", "coordinates": [[[-121.44822, 38.49495], [-121.4482, 38.49517], [-121.44786, 38.49499], [-121.44687, 38.49483], [-121.44598, 38.49481], [-121.44504, 38.49472], [-121.44491, 38.49465], [-121.44535, 38.49428], [-121.44562, 38.49428], [-121.44583, 38.4941], [-121.44645, 38.49453], [-121.44665, 38.49463], [-121.44686, 38.49472], [-121.44727, 38.49483], [-121.44822, 38.49495]]]} | Open Access 1 | 24019 | Crowfoot Park | 17834 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.127 | Crowfoot Park | 0 | Local Park 2 | 4 | |
3502 | 3502 | 3501 | {"type": "MultiPolygon", "coordinates": [[[[-121.38155, 38.45546], [-121.38133, 38.45552], [-121.38115, 38.45563], [-121.38102, 38.45578], [-121.38096, 38.45595], [-121.38097, 38.45515], [-121.38053, 38.45511], [-121.38059, 38.45505], [-121.3806, 38.45497], [-121.38057, 38.45493], [-121.38053, 38.45491], [-121.38047, 38.4549], [-121.38041, 38.4549], [-121.38041, 38.45474], [-121.38085, 38.45497], [-121.38115, 38.45506], [-121.3814, 38.45506], [-121.38155, 38.45546]]], [[[-121.38319, 38.45988], [-121.38277, 38.45988], [-121.38264, 38.4596], [-121.38272, 38.45954], [-121.38274, 38.45948], [-121.3827, 38.45937], [-121.3827, 38.45913], [-121.38268, 38.45901], [-121.38261, 38.45886], [-121.38245, 38.45861], [-121.38238, 38.45845], [-121.38224, 38.45784], [-121.38214, 38.45762], [-121.38195, 38.4573], [-121.38188, 38.45714], [-121.38182, 38.45694], [-121.38176, 38.45661], [-121.38171, 38.45649], [-121.38156, 38.45622], [-121.38155, 38.45617], [-121.38155, 38.4561], [-121.38154, 38.45606], [-121.38149, 38.45601], [-121.3814, 38.456], [-121.38131, 38.45603], [-121.38128, 38.45611], [-121.38109, 38.45611], [-121.38109, 38.45594], [-121.38113, 38.45583], [-121.38123, 38.4557], [-121.38135, 38.45562], [-121.38148, 38.45558], [-121.38159, 38.45557], [-121.38319, 38.45988]]]]} | Open Access 1 | 36025 | Danbury Parkway | 17917 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.905 | Danbury Parkway | 0 | Local Recreation Area 3 | 4 | |
11729 | 11729 | 11728 | {"type": "Polygon", "coordinates": [[[-121.43409, 38.49084], [-121.43187, 38.49083], [-121.4318, 38.48936], [-121.43254, 38.48936], [-121.43253, 38.48901], [-121.43257, 38.48901], [-121.43256, 38.48881], [-121.434, 38.48881], [-121.43409, 38.49084]]]} | Open Access 1 | 24024 | Daylor Sports Field | 17963 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.775 | Daylor Sports Field | 0 | Local Recreation Area 3 | 4 | |
11732 | 11732 | 11731 | {"type": "Polygon", "coordinates": [[[-121.44096, 38.48746], [-121.43882, 38.48746], [-121.43884, 38.48537], [-121.44086, 38.48501], [-121.44096, 38.48746]]]} | Open Access 1 | 24027 | Florin Creek Park | 18964 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.321 | Florin Creek Park | 0 | Local Park 2 | 4 | |
11718 | 11718 | 11717 | {"type": "Polygon", "coordinates": [[[-121.44673, 38.5137], [-121.44636, 38.5137], [-121.44636, 38.51283], [-121.44672, 38.51283], [-121.44673, 38.5137]]]} | Open Access 1 | 24014 | Fountain Plaza Park | 19022 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.772 | Fountain Plaza Park | 0 | Local Park 2 | 4 | |
11715 | 11715 | 11714 | {"type": "Polygon", "coordinates": [[[-121.4614, 38.52133], [-121.46141, 38.52418], [-121.4614, 38.52477], [-121.46005, 38.52477], [-121.46005, 38.52331], [-121.45976, 38.52331], [-121.45944, 38.52306], [-121.46004, 38.52256], [-121.46004, 38.52166], [-121.46068, 38.52166], [-121.46069, 38.52133], [-121.4614, 38.52133]]]} | Open Access 1 | 24011 | Fruitridge Park | 19136 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.323 | Fruitridge Park | 0 | Local Park 2 | 4 | |
11730 | 11730 | 11729 | {"type": "Polygon", "coordinates": [[[-121.43649, 38.48885], [-121.43648, 38.49039], [-121.43428, 38.49038], [-121.43421, 38.48884], [-121.43649, 38.48885]]]} | Open Access 1 | 24025 | Hampton Park | 19633 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 8.296 | Hampton Park | 0 | Local Park 2 | 4 | |
11745 | 11745 | 11744 | {"type": "Polygon", "coordinates": [[[-121.3844, 38.45687], [-121.38428, 38.45693], [-121.38383, 38.45695], [-121.38348, 38.45707], [-121.38347, 38.45965], [-121.38194, 38.45553], [-121.38217, 38.45547], [-121.38219, 38.45568], [-121.38225, 38.4559], [-121.38258, 38.45677], [-121.38259, 38.45689], [-121.38265, 38.45695], [-121.38275, 38.45697], [-121.38285, 38.45694], [-121.38287, 38.45694], [-121.38291, 38.45691], [-121.38313, 38.45685], [-121.384, 38.45652], [-121.38405, 38.45651], [-121.38409, 38.45653], [-121.3844, 38.45687]]]} | Open Access 1 | 24038 | Hardester Park | 19674 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.804 | Hardester Park | 0 | Local Park 2 | 4 | |
11748 | 11748 | 11747 | {"type": "Polygon", "coordinates": [[[-121.38097, 38.45391], [-121.3804, 38.45392], [-121.3804, 38.45423], [-121.38019, 38.45451], [-121.38019, 38.45463], [-121.38041, 38.45474], [-121.38041, 38.4549], [-121.38034, 38.45494], [-121.38031, 38.455], [-121.38032, 38.4551], [-121.38031, 38.45516], [-121.38022, 38.45531], [-121.38011, 38.45541], [-121.37966, 38.45577], [-121.37962, 38.45578], [-121.37958, 38.45578], [-121.37905, 38.45537], [-121.37879, 38.45513], [-121.37858, 38.45486], [-121.3784, 38.45454], [-121.37829, 38.45424], [-121.37824, 38.45392], [-121.37826, 38.45279], [-121.37832, 38.45274], [-121.37857, 38.45277], [-121.379, 38.45277], [-121.37923, 38.45274], [-121.38054, 38.45275], [-121.38097, 38.45391]]]} | Open Access 1 | 24041 | Illa Collin Park | 20176 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.842 | Illa Collin Park | 0 | Local Park 2 | 4 | |
11714 | 11714 | 11713 | {"type": "Polygon", "coordinates": [[[-121.45645, 38.53704], [-121.45645, 38.53736], [-121.45555, 38.53735], [-121.45555, 38.53704], [-121.45645, 38.53704]]]} | Open Access 1 | 24010 | Jack W. Davis Park | 20312 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.684 | Jack W. Davis Park | 0 | Local Park 2 | 4 | |
11728 | 11728 | 11727 | {"type": "Polygon", "coordinates": [[[-121.43545, 38.49234], [-121.43446, 38.49233], [-121.43438, 38.4923], [-121.4343, 38.49084], [-121.43543, 38.49084], [-121.43545, 38.49234]]]} | Open Access 1 | 24023 | Jose P Rizal Comm. Center | 20492 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.915 | Jose P Rizal Comm. Ctr. | 0 | Local Recreation Area 3 | 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]);