units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where DES_TP = 2 and MNG_AGENCY = 117 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 60
MNG_AGENCY 1
- Chula Vista, City of · 60 ✖
DES_TP 1
- Local Park · 60 ✖
AGNCY_TYP 1 ✖
- City Agency 60
ACCESS_TYP 1
- Open Access 60
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1181 | 1181 | 1180 | {"type": "Polygon", "coordinates": [[[-117.03411, 32.63221], [-117.03379, 32.63231], [-117.03398, 32.63277], [-117.03397, 32.6329], [-117.03338, 32.63399], [-117.03212, 32.63339], [-117.03198, 32.63323], [-117.0318, 32.63315], [-117.0316, 32.63312], [-117.03139, 32.63304], [-117.03144, 32.63297], [-117.03154, 32.63299], [-117.03188, 32.63297], [-117.03186, 32.63281], [-117.03181, 32.63265], [-117.03178, 32.63197], [-117.03149, 32.63198], [-117.03143, 32.63206], [-117.03139, 32.63202], [-117.03143, 32.63196], [-117.03376, 32.6313], [-117.03389, 32.63163], [-117.03401, 32.63167], [-117.03398, 32.63175], [-117.03398, 32.63185], [-117.03411, 32.63221]]]} | Open Access 1 | 7779 | Undeveloped Park | 26653 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 11.205 | Undeveloped Park | 0 | Local Park 2 | 4 | |
3226 | 3226 | 3225 | {"type": "Polygon", "coordinates": [[[-116.9381, 32.62076], [-116.93597, 32.62079], [-116.93593, 32.62048], [-116.93582, 32.62021], [-116.93569, 32.61999], [-116.93473, 32.61881], [-116.93465, 32.61869], [-116.93448, 32.61839], [-116.93433, 32.61801], [-116.93424, 32.61761], [-116.93424, 32.61751], [-116.93365, 32.61192], [-116.93445, 32.61192], [-116.9381, 32.62076]]]} | Open Access 1 | 22283 | EastLake III Park | 18395 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 43.841 | EastLake III Park | 0 | Local Park 2 | 4 | |
7409 | 7409 | 7408 | {"type": "Polygon", "coordinates": [[[-116.98173, 32.65204], [-116.98153, 32.65223], [-116.98135, 32.65208], [-116.98086, 32.652], [-116.98086, 32.65186], [-116.9809, 32.65183], [-116.98124, 32.65183], [-116.98138, 32.65184], [-116.98156, 32.65191], [-116.98173, 32.65204]]]} | Open Access 1 | 7795 | Mini Park | 22266 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 0.478 | MP | 0 | Local Park 2 | 4 | |
7697 | 7697 | 7696 | {"type": "Polygon", "coordinates": [[[-117.00449, 32.64521], [-117.00273, 32.6457], [-117.00255, 32.64544], [-117.00162, 32.6439], [-117.00177, 32.64382], [-117.00188, 32.64408], [-117.00367, 32.64395], [-117.00404, 32.64384], [-117.00449, 32.64521]]]} | Open Access 1 | 7689 | RDR SPA I Phase 2 Park | 24210 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 8.404 | RDR SPA I Phase 2 Park | 0 | Local Park 2 | 4 | |
7708 | 7708 | 7707 | {"type": "Polygon", "coordinates": [[[-117.03368, 32.63514], [-117.03287, 32.63536], [-117.0321, 32.63482], [-117.03214, 32.63476], [-117.03243, 32.6349], [-117.03266, 32.63458], [-117.03359, 32.63505], [-117.03368, 32.63514]]]} | Open Access 1 | 7772 | Undeveloped Park | 26653 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 1.435 | Undeveloped Park | 0 | Local Park 2 | 4 | |
7720 | 7720 | 7719 | {"type": "Polygon", "coordinates": [[[-116.97799, 32.6467], [-116.97786, 32.64678], [-116.97765, 32.64685], [-116.97688, 32.64697], [-116.97686, 32.64694], [-116.97688, 32.64646], [-116.97685, 32.6463], [-116.97678, 32.6461], [-116.9764, 32.6454], [-116.97634, 32.64518], [-116.97799, 32.6467]]]} | Open Access 1 | 7876 | Pedestrian Park | 23560 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 2.453 | Pedestrian Park | 0 | Local Park 2 | 4 | |
14762 | 14762 | 14761 | {"type": "Polygon", "coordinates": [[[-116.97651, 32.6128], [-116.97638, 32.61287], [-116.97623, 32.61292], [-116.97566, 32.61299], [-116.97547, 32.61304], [-116.9753, 32.61311], [-116.97513, 32.6132], [-116.97499, 32.6133], [-116.97474, 32.61356], [-116.97466, 32.61359], [-116.97418, 32.61369], [-116.97406, 32.61373], [-116.97391, 32.61384], [-116.97376, 32.61399], [-116.97363, 32.61405], [-116.97357, 32.61383], [-116.97353, 32.61361], [-116.97346, 32.6126], [-116.97478, 32.61231], [-116.975, 32.61238], [-116.97625, 32.61212], [-116.97627, 32.6123], [-116.97632, 32.61248], [-116.9764, 32.61264], [-116.97651, 32.6128]]]} | Open Access 1 | 45144 | All Seasons Park | 15377 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/all-seasons-park | San Diego 4 | 7.603 | All Seasons Park | 0 | Local Park 2 | 4 |
533 | 533 | 532 | {"type": "Polygon", "coordinates": [[[-117.10061, 32.63666], [-117.10052, 32.6367], [-117.1004, 32.63657], [-117.10016, 32.63639], [-117.0999, 32.63627], [-117.09961, 32.63619], [-117.0994, 32.63601], [-117.09949, 32.63592], [-117.10024, 32.63571], [-117.10061, 32.63666]]]} | Open Access 1 | 2423 | Bay Boulevard Park | 30005 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bay-boulevard | San Diego 4 | 1.27 | Bay Boulevard Park | 0 | Local Park 2 | 4 |
7711 | 7711 | 7710 | {"type": "Polygon", "coordinates": [[[-116.99759, 32.65572], [-116.99525, 32.65807], [-116.99418, 32.65763], [-116.99362, 32.65738], [-116.99358, 32.65732], [-116.99387, 32.65684], [-116.99422, 32.65698], [-116.99435, 32.65678], [-116.9947, 32.65639], [-116.99492, 32.65576], [-116.99759, 32.65572]]]} | Open Access 1 | 7787 | Bonita Long Canyon Park | 16260 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bonita-long-canyon-park | San Diego 4 | 12.067 | Bonita Long Canyon Park | 0 | Local Park 2 | 4 |
14598 | 14598 | 14597 | {"type": "Polygon", "coordinates": [[[-116.98456, 32.63845], [-116.98455, 32.63849], [-116.98452, 32.63851], [-116.98444, 32.63854], [-116.98433, 32.63855], [-116.98428, 32.63857], [-116.98425, 32.63864], [-116.98427, 32.63871], [-116.9842, 32.63876], [-116.9841, 32.63879], [-116.984, 32.63879], [-116.98397, 32.63872], [-116.98392, 32.63869], [-116.98387, 32.63868], [-116.98381, 32.6387], [-116.98374, 32.63876], [-116.98358, 32.63881], [-116.98353, 32.63879], [-116.98341, 32.63835], [-116.9834, 32.63819], [-116.98335, 32.6381], [-116.98379, 32.63786], [-116.98375, 32.63775], [-116.9838, 32.63774], [-116.9841, 32.63775], [-116.98413, 32.63785], [-116.98426, 32.638], [-116.98456, 32.63845]]]} | Open Access 1 | 44823 | Breezewood Park | 16347 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/breezewood-park | San Diego 4 | 2.13 | Breezewood Park | 0 | Local Park 2 | 4 |
7666 | 7666 | 7665 | {"type": "Polygon", "coordinates": [[[-116.96955, 32.64393], [-116.96934, 32.64428], [-116.96888, 32.64511], [-116.96881, 32.64532], [-116.96877, 32.64554], [-116.96841, 32.64548], [-116.96795, 32.64527], [-116.96729, 32.64523], [-116.96689, 32.64515], [-116.96615, 32.64484], [-116.96612, 32.64481], [-116.96612, 32.64477], [-116.96629, 32.64451], [-116.96642, 32.64427], [-116.96659, 32.64384], [-116.96666, 32.64352], [-116.9667, 32.64326], [-116.96671, 32.64276], [-116.96805, 32.64268], [-116.96812, 32.64341], [-116.9682, 32.64359], [-116.96836, 32.64376], [-116.96857, 32.64389], [-116.96881, 32.64396], [-116.96898, 32.64397], [-116.96955, 32.64393]]]} | Open Access 1 | 7568 | Chula Vista Community Park | 17240 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/chula-vista-community-park | San Diego 4 | 14.298 | Chula Vista Community Park | 0 | Local Park 2 | 4 |
3552 | 3552 | 3551 | {"type": "Polygon", "coordinates": [[[-117.05544, 32.59946], [-117.05505, 32.59946], [-117.05504, 32.59979], [-117.05461, 32.59966], [-117.05462, 32.59923], [-117.05469, 32.59919], [-117.05504, 32.59919], [-117.05505, 32.59938], [-117.05544, 32.59939], [-117.05544, 32.59946]]]} | Open Access 1 | 7710 | Connoley Park | 17592 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/connoley-park | San Diego 4 | 0.668 | Connoley Park | 0 | Local Park 2 | 4 |
7665 | 7665 | 7664 | {"type": "Polygon", "coordinates": [[[-116.98312, 32.63302], [-116.98199, 32.63347], [-116.98175, 32.63286], [-116.98096, 32.63275], [-116.98126, 32.63152], [-116.98161, 32.63162], [-116.98244, 32.63175], [-116.98249, 32.63181], [-116.98267, 32.63184], [-116.98275, 32.63179], [-116.98298, 32.63183], [-116.98284, 32.63252], [-116.98312, 32.63302]]]} | Open Access 1 | 7566 | Cottonwood Park | 17688 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/cottonwood-park | San Diego 4 | 6.723 | Cottonwood Park | 0 | Local Park 2 | 4 |
7671 | 7671 | 7670 | {"type": "Polygon", "coordinates": [[[-117.01065, 32.64444], [-117.00899, 32.64428], [-117.00849, 32.6448], [-117.00796, 32.64427], [-117.00791, 32.6445], [-117.00773, 32.6447], [-117.00742, 32.64471], [-117.00714, 32.64442], [-117.00691, 32.64445], [-117.00663, 32.64485], [-117.0069, 32.64532], [-117.00664, 32.64565], [-117.00643, 32.64533], [-117.00618, 32.64516], [-117.00598, 32.64509], [-117.00571, 32.64508], [-117.00451, 32.64528], [-117.00403, 32.6438], [-117.00436, 32.64382], [-117.00459, 32.64382], [-117.00483, 32.64379], [-117.00506, 32.64373], [-117.00537, 32.64361], [-117.00652, 32.64301], [-117.00663, 32.64313], [-117.00682, 32.64326], [-117.00703, 32.64336], [-117.00722, 32.6434], [-117.0105, 32.64368], [-117.01055, 32.6437], [-117.01056, 32.64374], [-117.01065, 32.64444]]]} | Open Access 1 | 7619 | Discovery Park | 18165 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/discovery-park | San Diego 4 | 20.562 | Discovery Park | 0 | Local Park 2 | 4 |
7686 | 7686 | 7685 | {"type": "Polygon", "coordinates": [[[-117.09191, 32.64933], [-117.09061, 32.64971], [-117.09036, 32.64976], [-117.08898, 32.65016], [-117.08813, 32.65038], [-117.0881, 32.65037], [-117.08805, 32.65033], [-117.08745, 32.64879], [-117.0903, 32.64799], [-117.09007, 32.64737], [-117.08995, 32.64732], [-117.08993, 32.64727], [-117.09051, 32.64712], [-117.09055, 32.64719], [-117.09103, 32.64705], [-117.09191, 32.64933]]]} | Open Access 1 | 7648 | Eucalyptus Park | 18741 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/eucalyptus-park | San Diego 4 | 19.675 | Eucalyptus Park | 0 | Local Park 2 | 4 |
1174 | 1174 | 1173 | {"type": "Polygon", "coordinates": [[[-117.02598, 32.64134], [-117.02555, 32.64146], [-117.02542, 32.64136], [-117.02506, 32.64128], [-117.02482, 32.6413], [-117.02465, 32.64135], [-117.02435, 32.64151], [-117.024, 32.64158], [-117.0237, 32.64159], [-117.02338, 32.64155], [-117.02304, 32.64148], [-117.02367, 32.64097], [-117.02389, 32.64083], [-117.02416, 32.64067], [-117.02445, 32.64054], [-117.02476, 32.64043], [-117.02582, 32.64013], [-117.02586, 32.64032], [-117.02571, 32.64037], [-117.02558, 32.64047], [-117.02553, 32.64053], [-117.02549, 32.64062], [-117.02549, 32.64077], [-117.02552, 32.64086], [-117.0256, 32.641], [-117.02565, 32.64126], [-117.02597, 32.64127], [-117.02598, 32.64134]]]} | Open Access 1 | 7579 | Explorer Park | 18775 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/explorer-park | San Diego 4 | 5.227 | Explorer Park | 0 | Local Park 2 | 4 |
7679 | 7679 | 7678 | {"type": "Polygon", "coordinates": [[[-117.0842, 32.64107], [-117.08447, 32.64177], [-117.08447, 32.64181], [-117.08445, 32.64184], [-117.08276, 32.64232], [-117.08271, 32.64232], [-117.08267, 32.6423], [-117.08239, 32.64157], [-117.0842, 32.64107]]]} | Open Access 1 | 7610 | Friendship Park | 19121 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/friendship-park | San Diego 4 | 3.934 | Friendship Park | 0 | Local Park 2 | 4 |
6761 | 6761 | 6760 | {"type": "Polygon", "coordinates": [[[-117.04643, 32.63539], [-117.04591, 32.63554], [-117.04554, 32.63452], [-117.04553, 32.63446], [-117.04616, 32.63447], [-117.04643, 32.63539]]]} | Open Access 1 | 5199 | Gayle L. McCandliss Park | 30008 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/gayle-l-mccandliss-park | San Diego 4 | 1.542 | Gayle L. McCandliss Park | 0 | Local Park 2 | 4 |
7670 | 7670 | 7669 | {"type": "Polygon", "coordinates": [[[-117.03555, 32.62065], [-117.03358, 32.62121], [-117.03124, 32.61519], [-117.03171, 32.61515], [-117.03228, 32.61506], [-117.03312, 32.61489], [-117.03353, 32.61486], [-117.0336, 32.6149], [-117.03378, 32.61597], [-117.03386, 32.61638], [-117.03555, 32.62065]]]} | Open Access 1 | 7573 | Greg Rogers Park | 19498 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/greg-rogers-park | San Diego 4 | 33.478 | Greg Rogers Park | 0 | Local Park 2 | 4 |
7659 | 7659 | 7658 | {"type": "Polygon", "coordinates": [[[-117.08528, 32.60725], [-117.08416, 32.60756], [-117.08352, 32.60593], [-117.08464, 32.60562], [-117.08528, 32.60725]]]} | Open Access 1 | 7542 | Harborside Park | 19668 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/harborside-park | San Diego 4 | 5.203 | Harborside 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]);