units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
995 rows where COUNTY = 4 and MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AGENCY 18
- San Diego, City of 533
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 57
- Oceanside, City of 45
- Carlsbad, City of 40
- San Marcos, City of 40
- Escondido, City of 34
- Coronado, City of 19
- Vista, City of 18
- El Cajon, City of 17
- La Mesa, City of 14
- Santee, City of 12
- Del Mar, City of 8
- National City, City of 7
- Lemon Grove, City of 6
- Imperial Beach, City of 5
- Solana Beach, City of 3
ACCESS_TYP 4
- Open Access 928
- No Public Access 38
- Restricted Access 28
- Unknown Access 1
MNG_AG_TYP 1
- City Agency · 995 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
192 | 192 | 191 | {"type": "Polygon", "coordinates": [[[-117.25358, 33.2577], [-117.25022, 33.25616], [-117.25015, 33.25611], [-117.25356, 33.2561], [-117.25358, 33.2577]]]} | Open Access 1 | 527 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 7.039 | San Luis Rey River | None 21 | |||
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} | Open Access 1 | 709 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.184 | Swami's Bluff Parcels | None 27 | ||
460 | 460 | 459 | {"type": "Polygon", "coordinates": [[[-117.24981, 33.2545], [-117.24943, 33.25596], [-117.245, 33.25509], [-117.245, 33.25326], [-117.24532, 33.25324], [-117.24564, 33.25323], [-117.24597, 33.25326], [-117.2464, 33.25334], [-117.24907, 33.2543], [-117.24981, 33.2545]]]} | Open Access 1 | 1842 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 21.567 | San Luis Rey River | None 48 | |||
494 | 494 | 493 | {"type": "Polygon", "coordinates": [[[-117.27317, 32.85074], [-117.27304, 32.85083], [-117.27295, 32.85079], [-117.27295, 32.85077], [-117.27298, 32.85075], [-117.273, 32.85069], [-117.27288, 32.8505], [-117.27277, 32.85041], [-117.27279, 32.85034], [-117.27292, 32.85028], [-117.27299, 32.85025], [-117.27301, 32.85027], [-117.27317, 32.85046], [-117.27323, 32.85056], [-117.27322, 32.85066], [-117.27317, 32.85074]]]} | Open Access 1 | 47473 | La Jolla Cove | 31200 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.lajollabythesea.com/la-jolla-cove | San Diego 4 | 0.357 | La Jolla Cove | None 52 | ||
3169 | 3169 | 3168 | {"type": "Polygon", "coordinates": [[[-117.25165, 32.96386], [-117.24822, 32.96383], [-117.24814, 32.96365], [-117.24879, 32.96367], [-117.24926, 32.96341], [-117.24928, 32.96339], [-117.24933, 32.96291], [-117.24872, 32.96292], [-117.24872, 32.96289], [-117.2487, 32.96287], [-117.24934, 32.96284], [-117.24898, 32.96229], [-117.24872, 32.9617], [-117.24906, 32.96147], [-117.24962, 32.96157], [-117.2502, 32.96181], [-117.25059, 32.96137], [-117.25064, 32.96139], [-117.25069, 32.96146], [-117.25073, 32.96153], [-117.25074, 32.9617], [-117.25081, 32.96191], [-117.2511, 32.96236], [-117.25122, 32.96245], [-117.25136, 32.96251], [-117.25146, 32.96252], [-117.25164, 32.96252], [-117.25165, 32.96386]]]} | Open Access 1 | 21993 | San Dieguito Lagoon | 24864 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 13.674 | San Dieguito Lagoon | None 260 | |||
3825 | 3825 | 3824 | {"type": "MultiPolygon", "coordinates": [[[[-117.26084, 32.96844], [-117.26055, 32.96864], [-117.26044, 32.96852], [-117.26074, 32.96833], [-117.26084, 32.96844]]], [[[-117.26155, 32.96919], [-117.26115, 32.96945], [-117.26112, 32.96943], [-117.26088, 32.96904], [-117.26065, 32.96877], [-117.26095, 32.96856], [-117.26155, 32.96919]]]]} | Open Access 1 | 45240 | San Diequito Lagoon | 24873 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.sdrp.org/wordpress/ | San Diego 4 | 1.046 | San Diequito Lagoon | None 322 | ||
4183 | 4183 | 4182 | {"type": "MultiPolygon", "coordinates": [[[[-117.06172, 32.93278], [-117.06122, 32.93336], [-117.06087, 32.93316], [-117.06071, 32.9331], [-117.06052, 32.93306], [-117.06016, 32.93303], [-117.05996, 32.93305], [-117.05974, 32.9331], [-117.05968, 32.93308], [-117.05965, 32.93305], [-117.05923, 32.93194], [-117.05911, 32.93166], [-117.05887, 32.93122], [-117.05859, 32.93084], [-117.05859, 32.93079], [-117.05882, 32.93064], [-117.05916, 32.93101], [-117.0608, 32.93016], [-117.06098, 32.93018], [-117.0599, 32.93081], [-117.05979, 32.93128], [-117.06026, 32.93172], [-117.0606, 32.93182], [-117.06093, 32.93184], [-117.06127, 32.93176], [-117.0615, 32.93172], [-117.06153, 32.93243], [-117.06172, 32.93278]]], [[[-117.06669, 32.93294], [-117.06648, 32.93266], [-117.06644, 32.93238], [-117.06648, 32.93208], [-117.06625, 32.932], [-117.06608, 32.9318], [-117.06621, 32.93138], [-117.06616, 32.93133], [-117.06597, 32.93138], [-117.06552, 32.93156], [-117.06489, 32.93141], [-117.06501, 32.93102], [-117.06506, 32.93069], [-117.06543, 32.93045], [-117.06548, 32.93009], [-117.0652, 32.92941], [-117.06497, 32.92918], [-117.06473, 32.929], [-117.06367, 32.92871], [-117.06354, 32.92923], [-117.0635, 32.92922], [-117.06361, 32.9287], [-117.06028, 32.92779], [-117.06534, 32.92774], [-117.06556, 32.928], [-117.06579, 32.92819], [-117.06596, 32.92829], [-117.06668, 32.92866], [-117.06669, 32.93294]]], [[[-117.06581, 32.93938], [-117.06576, 32.93969], [-117.06569, 32.93966], [-117.06569, 32.93963], [-117.06539, 32.93946], [-117.06532, 32.93947], [-117.06505, 32.93936], [-117.06446, 32.93929], [-117.06429, 32.9389], [-117.06405, 32.93887], [-117.0639, 32.93843], [-117.063, 32.93833], [-117.06287, 32.93795], [-117.06274, 32.93769], [-117.06286, 32.93761], [-117.06308, 32.93783], [-117.06349, 32.93754], [-117.06399, 32.93805], [-117.06412, 32.93807], [-117.06478, 32.93895], [-117.06507, 32.93898], [-117.06505, 32.93915], [-117.06581, 32.93938]]], [[[-117.06668, 32.92848], [-117.06592, 32.92807], [-117.06573, 32.92792], [-117.06557, 32.92774], [-117.06668, 32.92773], [-117.06668, 32.92848]]]]} | No Public Access 3 | 44864 | South Poway Cornerstone | 25675 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 37.928 | South Poway Cornerstone | None 364 | |||
4244 | 4244 | 4243 | {"type": "Polygon", "coordinates": [[[-117.0056, 32.63624], [-117.00513, 32.63582], [-117.00502, 32.63576], [-117.0046, 32.63569], [-117.00423, 32.63587], [-117.00342, 32.63602], [-117.00317, 32.63618], [-117.00295, 32.63637], [-117.0028, 32.63655], [-117.00278, 32.63652], [-117.00292, 32.63635], [-117.00312, 32.63616], [-117.0034, 32.63599], [-117.00399, 32.63587], [-117.00393, 32.63562], [-117.00387, 32.63559], [-117.00389, 32.63551], [-117.00387, 32.63546], [-117.00383, 32.63543], [-117.00384, 32.63532], [-117.00342, 32.63483], [-117.0034, 32.63476], [-117.00332, 32.6347], [-117.00288, 32.6342], [-117.00288, 32.63413], [-117.00285, 32.63409], [-117.00266, 32.63386], [-117.0024, 32.63364], [-117.00258, 32.63353], [-117.0029, 32.63337], [-117.00316, 32.63336], [-117.00324, 32.63329], [-117.00326, 32.63322], [-117.00374, 32.63319], [-117.00374, 32.6339], [-117.00368, 32.63422], [-117.00397, 32.63498], [-117.00413, 32.63517], [-117.00417, 32.63515], [-117.0042, 32.6352], [-117.00418, 32.63523], [-117.00447, 32.63557], [-117.00525, 32.63536], [-117.0056, 32.63624]]]} | Open Access 1 | 45158 | Rancho Del Rey South | 24141 | 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/rancho-del-rey-park | San Diego 4 | 5.729 | Rancho Del Rey South | None 370 | ||
4280 | 4280 | 4279 | {"type": "Polygon", "coordinates": [[[-117.24735, 32.96922], [-117.24593, 32.96921], [-117.24592, 32.96922], [-117.24638, 32.96992], [-117.2445, 32.96992], [-117.24371, 32.97056], [-117.24369, 32.97114], [-117.24394, 32.97137], [-117.24404, 32.97165], [-117.24404, 32.97187], [-117.24398, 32.97218], [-117.24382, 32.97234], [-117.24361, 32.97234], [-117.24328, 32.97225], [-117.24315, 32.97208], [-117.24317, 32.97158], [-117.24305, 32.97158], [-117.24169, 32.97116], [-117.24127, 32.97067], [-117.23964, 32.97065], [-117.23955, 32.97036], [-117.23941, 32.97006], [-117.23922, 32.96977], [-117.23904, 32.96953], [-117.23677, 32.96735], [-117.23875, 32.96737], [-117.23876, 32.96375], [-117.23968, 32.96375], [-117.24306, 32.96168], [-117.24306, 32.96378], [-117.24569, 32.96381], [-117.2457, 32.96397], [-117.24735, 32.96759], [-117.24735, 32.96922]]]} | Open Access 1 | 45239 | San Dieguito Lagoon | 24864 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 152.683 | San Dieguito Lagoon | None 374 | |||
4389 | 4389 | 4388 | {"type": "Polygon", "coordinates": [[[-117.06741, 32.94582], [-117.06611, 32.94579], [-117.06614, 32.94569], [-117.06613, 32.94558], [-117.06599, 32.94508], [-117.066, 32.94497], [-117.06604, 32.94487], [-117.0661, 32.94481], [-117.06617, 32.94477], [-117.06647, 32.94467], [-117.06665, 32.94462], [-117.06687, 32.94461], [-117.06698, 32.94458], [-117.06741, 32.94582]]]} | Open Access 1 | 45987 | The Pond | 29156 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 3.291 | The Pond | None 391 | |||
5282 | 5282 | 5281 | {"type": "Polygon", "coordinates": [[[-116.9986, 32.96095], [-116.99776, 32.96117], [-116.99758, 32.96085], [-116.99794, 32.96067], [-116.9981, 32.96063], [-116.99835, 32.96059], [-116.99841, 32.96063], [-116.9985, 32.96081], [-116.9986, 32.96095]]]} | Open Access 1 | 47639 | Sycamore Creek Neighborhood Park - East | 31380 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.91 | Sycamore Creek Neighborhood Park - East | None 426 | |||
6084 | 6084 | 6083 | {"type": "Polygon", "coordinates": [[[-117.03743, 32.96938], [-117.03742, 32.97105], [-117.03627, 32.97104], [-117.03628, 32.96938], [-117.03743, 32.96938]]]} | Open Access 1 | 890 | Old Poway Park and Railroad | 23098 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/452/Old-Poway-Park | San Diego 4 | 4.928 | Old Poway Park and Railroad | None 491 | ||
6149 | 6149 | 6148 | {"type": "Polygon", "coordinates": [[[-117.31046, 33.07653], [-117.30964, 33.07651], [-117.30962, 33.07645], [-117.31043, 33.07647], [-117.31046, 33.07653]]]} | Open Access 1 | 1160 | Grandview | 19428 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.131 | Grandview | None 495 | ||
7567 | 7567 | 7566 | {"type": "Polygon", "coordinates": [[[-116.96071, 32.7939], [-116.96071, 32.79487], [-116.96045, 32.79487], [-116.96044, 32.79491], [-116.96011, 32.79491], [-116.9601, 32.7939], [-116.96071, 32.7939]]]} | Open Access 1 | 47692 | Prescott Promenade | 31427 | 1092 | El Cajon, City of 73 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html | City 2 | 1092 | El Cajon, City of 71 | City 2 | City Agency 2 | San Diego 4 | 1.524 | Prescott Promenade | None 629 | |||
7616 | 7616 | 7615 | {"type": "Polygon", "coordinates": [[[-117.26666, 33.13637], [-117.26647, 33.13716], [-117.26627, 33.13719], [-117.26603, 33.13729], [-117.26594, 33.13735], [-117.26581, 33.13752], [-117.26568, 33.13736], [-117.26537, 33.1374], [-117.26513, 33.13702], [-117.2651, 33.13689], [-117.26567, 33.13602], [-117.26591, 33.13616], [-117.26634, 33.1363], [-117.26666, 33.13637]]]} | Open Access 1 | 47629 | Carlsbad Skatepark | 31368 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/skatepark.asp | San Diego 4 | 3.643 | Carlsbad Skatepark | None 634 | ||
7623 | 7623 | 7622 | {"type": "Polygon", "coordinates": [[[-117.00188, 32.95969], [-117.0015, 32.95981], [-117.00141, 32.95964], [-117.00186, 32.95949], [-117.00188, 32.95969]]]} | Open Access 1 | 47638 | Sycamore Creek Neighborhood Park - West | 31379 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.215 | Sycamore Creek Neighborhood Park - West | None 636 | |||
7698 | 7698 | 7697 | {"type": "Polygon", "coordinates": [[[-117.29518, 33.19613], [-117.29514, 33.19645], [-117.29493, 33.19636], [-117.29482, 33.19634], [-117.29471, 33.19633], [-117.29434, 33.19634], [-117.29392, 33.1964], [-117.29352, 33.19651], [-117.29318, 33.19664], [-117.29279, 33.19648], [-117.29342, 33.19591], [-117.2937, 33.19615], [-117.29393, 33.19577], [-117.29432, 33.19594], [-117.2945, 33.196], [-117.29487, 33.19608], [-117.29518, 33.19613]]]} | Open Access 1 | 47625 | Oceanside Open Space 1 | 31363 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 2.401 | Oceanside OS 1 | None 638 | |||
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 |
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]);