units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where COUNTY = 41, MNG_AGENCY = 494 and MNG_AG_TYP = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 | |
4067 | 4067 | 4066 | {"type": "Polygon", "coordinates": [[[-121.45978, 38.51394], [-121.45866, 38.51395], [-121.45865, 38.51401], [-121.45764, 38.51401], [-121.45764, 38.5122], [-121.45977, 38.5122], [-121.45978, 38.51394]]]} | Restricted Access 2 | 44414 | Pacific Park | 23303 | 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.079 | Pacific Park | 0 | Local Park 2 | 4 | |
9785 | 9785 | 9784 | {"type": "Polygon", "coordinates": [[[-121.31037, 38.47068], [-121.31044, 38.47071], [-121.3105, 38.4709], [-121.31049, 38.47177], [-121.31046, 38.47182], [-121.31031, 38.47181], [-121.3101, 38.47176], [-121.30978, 38.47163], [-121.3095, 38.47145], [-121.30927, 38.47122], [-121.30927, 38.47117], [-121.3093, 38.47115], [-121.31037, 38.47068]]]} | Open Access 1 | 47907 | Little Hawke Park | 32000 | 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.12 | Little Hawke Park | 0 | Local Park 2 | 4 | |
9801 | 9801 | 9800 | {"type": "Polygon", "coordinates": [[[-121.37598, 38.47607], [-121.37594, 38.47623], [-121.37594, 38.47651], [-121.37591, 38.47673], [-121.3759, 38.47727], [-121.37588, 38.47732], [-121.37583, 38.47733], [-121.3749, 38.47733], [-121.37466, 38.47735], [-121.37462, 38.47733], [-121.37451, 38.47719], [-121.37432, 38.47701], [-121.37433, 38.47696], [-121.37449, 38.47679], [-121.37468, 38.47651], [-121.37478, 38.47621], [-121.3748, 38.4761], [-121.37479, 38.47602], [-121.37516, 38.47603], [-121.37546, 38.47606], [-121.37598, 38.47607]]]} | Open Access 1 | 47908 | Tamarindo Park | 32001 | 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.11 | Tamarindo Park | 0 | Local Park 2 | 4 | |
11270 | 11270 | 11269 | {"type": "MultiPolygon", "coordinates": [[[[-121.30369, 38.49136], [-121.29786, 38.49132], [-121.29784, 38.4889], [-121.30251, 38.48891], [-121.30252, 38.48894], [-121.30366, 38.48894], [-121.30369, 38.49136]]], [[[-121.31605, 38.46467], [-121.31569, 38.46467], [-121.31545, 38.46469], [-121.3152, 38.46475], [-121.31494, 38.46485], [-121.31489, 38.46486], [-121.31484, 38.46483], [-121.31425, 38.46426], [-121.31403, 38.46409], [-121.31363, 38.46387], [-121.31323, 38.46373], [-121.31249, 38.46355], [-121.31219, 38.4635], [-121.31084, 38.46343], [-121.31049, 38.46339], [-121.31015, 38.46331], [-121.30949, 38.46309], [-121.30919, 38.46302], [-121.3088, 38.463], [-121.30845, 38.46303], [-121.30718, 38.46329], [-121.30693, 38.46336], [-121.30664, 38.46347], [-121.30619, 38.46369], [-121.30545, 38.46417], [-121.30525, 38.46431], [-121.30504, 38.46452], [-121.30483, 38.46481], [-121.3041, 38.4663], [-121.30334, 38.4671], [-121.30043, 38.4671], [-121.30069, 38.4669], [-121.30202, 38.46628], [-121.30248, 38.466], [-121.30291, 38.46547], [-121.30293, 38.46503], [-121.30287, 38.4641], [-121.30299, 38.46363], [-121.30301, 38.46338], [-121.30352, 38.46257], [-121.30434, 38.46231], [-121.30737, 38.46216], [-121.30796, 38.46155], [-121.30874, 38.46128], [-121.30949, 38.46142], [-121.3106, 38.46198], [-121.31097, 38.46201], [-121.31413, 38.46142], [-121.31529, 38.46197], [-121.31604, 38.46216], [-121.31605, 38.46467]]]]} | Open Access 1 | 21745 | SOUTHGATE RECREATION/PARK DISTRICT | 25690 | 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 | 105.753 | SOUTHGATE RECREATION/PARK DISTRICT | None 985 | |||
11424 | 11424 | 11423 | {"type": "MultiPolygon", "coordinates": [[[[-121.35305, 38.45457], [-121.35307, 38.45492], [-121.35314, 38.45535], [-121.35313, 38.45538], [-121.35308, 38.45542], [-121.35289, 38.45546], [-121.3527, 38.45552], [-121.35247, 38.45564], [-121.35227, 38.45584], [-121.35217, 38.456], [-121.3521, 38.45619], [-121.35209, 38.45635], [-121.35112, 38.45635], [-121.35116, 38.45457], [-121.35305, 38.45457]]], [[[-121.35394, 38.45942], [-121.35394, 38.45908], [-121.35362, 38.45908], [-121.35348, 38.45911], [-121.35334, 38.45912], [-121.35324, 38.45921], [-121.35327, 38.45643], [-121.35348, 38.45643], [-121.35364, 38.45678], [-121.35375, 38.45705], [-121.3539, 38.4576], [-121.35396, 38.45797], [-121.35399, 38.45834], [-121.35398, 38.45938], [-121.35394, 38.45942]]]]} | Open Access 1 | 22264 | SOUTHGATE RECREATION/PARK DISTRICT | 25690 | 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 | 10.514 | SOUTHGATE RECREATION/PARK DISTRICT | None 1013 | |||
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 | |
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 | |
11717 | 11717 | 11716 | {"type": "Polygon", "coordinates": [[[-121.4637, 38.51495], [-121.46371, 38.51497], [-121.4644, 38.51497], [-121.46446, 38.515], [-121.46447, 38.51503], [-121.46448, 38.51563], [-121.46446, 38.51568], [-121.4644, 38.5157], [-121.4637, 38.51571], [-121.46369, 38.51573], [-121.4633, 38.51573], [-121.46309, 38.51534], [-121.46327, 38.51533], [-121.46327, 38.51495], [-121.4637, 38.51495]]]} | Open Access 1 | 24013 | Rainbow Park | 24091 | 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.229 | Rainbow 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 | |
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 | |
11720 | 11720 | 11719 | {"type": "Polygon", "coordinates": [[[-121.45236, 38.50609], [-121.45235, 38.50799], [-121.45071, 38.50798], [-121.4507, 38.50793], [-121.45045, 38.50745], [-121.45071, 38.50744], [-121.45071, 38.50554], [-121.45232, 38.50554], [-121.45232, 38.50584], [-121.45234, 38.50587], [-121.4523, 38.50591], [-121.45229, 38.50595], [-121.45236, 38.50609]]]} | Open Access 1 | 24016 | Nicholas Park | 22745 | 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.739 | Nicholas Park | 0 | Local Park 2 | 4 | |
11721 | 11721 | 11720 | {"type": "Polygon", "coordinates": [[[-121.41738, 38.50033], [-121.41737, 38.5009], [-121.41656, 38.50089], [-121.41623, 38.50091], [-121.41596, 38.50113], [-121.41545, 38.50113], [-121.41544, 38.50076], [-121.41547, 38.50068], [-121.41544, 38.50058], [-121.41543, 38.49992], [-121.41595, 38.49992], [-121.41596, 38.5003], [-121.41738, 38.50033]]]} | Open Access 1 | 24017 | Kennedy Park | 20603 | 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.562 | Kennedy Park | 0 | Local Park 2 | 4 | |
11723 | 11723 | 11722 | {"type": "Polygon", "coordinates": [[[-121.39517, 38.49733], [-121.39516, 38.49734], [-121.39516, 38.498], [-121.39302, 38.498], [-121.39302, 38.49675], [-121.39361, 38.49675], [-121.3946, 38.4968], [-121.39517, 38.49678], [-121.39517, 38.49733]]]} | Open Access 1 | 24018 | Olde Florintown Park | 23113 | 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.327 | Olde Florintown 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 | |
11725 | 11725 | 11724 | {"type": "Polygon", "coordinates": [[[-121.38267, 38.49379], [-121.38126, 38.49379], [-121.38125, 38.49185], [-121.38133, 38.49184], [-121.38134, 38.49171], [-121.3826, 38.4917], [-121.38261, 38.49269], [-121.38267, 38.49321], [-121.38267, 38.49379]]]} | Open Access 1 | 24020 | Sunrise Florin Park | 26019 | 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.826 | Sunrise Florin Park | 0 | Local Park 2 | 4 | |
11726 | 11726 | 11725 | {"type": "Polygon", "coordinates": [[[-121.41571, 38.48888], [-121.41487, 38.48888], [-121.41484, 38.4886], [-121.41471, 38.48829], [-121.41454, 38.48805], [-121.41424, 38.48773], [-121.41414, 38.48759], [-121.41407, 38.48744], [-121.41403, 38.48731], [-121.414, 38.48716], [-121.414, 38.48702], [-121.41403, 38.48684], [-121.41569, 38.48685], [-121.41571, 38.48888]]]} | Open Access 1 | 24021 | Rutter Park | 24756 | 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.323 | Rutter Park | 0 | Local Park 2 | 4 | |
11727 | 11727 | 11726 | {"type": "Polygon", "coordinates": [[[-121.45147, 38.49244], [-121.45145, 38.49257], [-121.4512, 38.49261], [-121.45027, 38.49262], [-121.44975, 38.49267], [-121.44968, 38.49264], [-121.44966, 38.49254], [-121.44967, 38.49243], [-121.4497, 38.49232], [-121.44982, 38.49217], [-121.44993, 38.49209], [-121.45069, 38.49164], [-121.45147, 38.49244]]]} | Open Access 1 | 24022 | Royal Park | 24717 | 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.719 | Royal 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]);