units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
503 rows where ACCESS_TYP = 1 and MNG_AGENCY = 4 sorted by map descending
This data as json, copyable, CSV (advanced)
DES_TP 18
- Local Park 274
- Local Recreation Area 202
- Local Other or Unknown 7
- Local Conservation Area 6
- Local Historic or Cultural Area 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 503
MNG_AGENCY 1
- San Diego, City of · 503 ✖
ACCESS_TYP 1
- Open Access · 503 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9959 | 9959 | 9958 | {"type": "Polygon", "coordinates": [[[-117.28189, 32.83958], [-117.28193, 32.83972], [-117.28192, 32.83996], [-117.28186, 32.84009], [-117.28177, 32.84012], [-117.28183, 32.84005], [-117.28187, 32.83996], [-117.28184, 32.83978], [-117.28186, 32.83966], [-117.28184, 32.8396], [-117.28166, 32.8394], [-117.28178, 32.83936], [-117.28165, 32.83905], [-117.28144, 32.83869], [-117.28137, 32.83828], [-117.28159, 32.83823], [-117.28158, 32.83837], [-117.28163, 32.83853], [-117.28161, 32.83854], [-117.28162, 32.83858], [-117.28162, 32.83871], [-117.28165, 32.83879], [-117.28166, 32.83888], [-117.28169, 32.83893], [-117.28172, 32.83915], [-117.28175, 32.83921], [-117.28179, 32.83925], [-117.2818, 32.83933], [-117.28183, 32.83939], [-117.28185, 32.83953], [-117.28189, 32.83958]]]} | Open Access 1 | 18518 | Nicholson's Point Park | 30083 | 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 | 0.516 | Nicholson's Point Park | 0 | Local Park 2 | 4 | |
30 | 30 | 29 | {"type": "Polygon", "coordinates": [[[-117.28087, 32.84301], [-117.28083, 32.8432], [-117.28076, 32.84327], [-117.28045, 32.84348], [-117.2802, 32.84361], [-117.27997, 32.8438], [-117.27941, 32.8441], [-117.27929, 32.84422], [-117.27922, 32.84424], [-117.27904, 32.84421], [-117.27907, 32.84411], [-117.27939, 32.84394], [-117.27965, 32.84375], [-117.28006, 32.84357], [-117.28036, 32.84341], [-117.28049, 32.84331], [-117.28065, 32.84315], [-117.28083, 32.8429], [-117.28087, 32.84301]]]} | Open Access 1 | 46753 | Cuvier Park | 30204 | 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 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/cuvier | San Diego 4 | 0.83 | Cuvier Park | 0 | Local Park 2 | 4 |
15435 | 15435 | 15434 | {"type": "Polygon", "coordinates": [[[-117.28052, 32.82902], [-117.28046, 32.82895], [-117.28037, 32.82891], [-117.28028, 32.82889], [-117.28018, 32.82889], [-117.27954, 32.82622], [-117.27957, 32.82621], [-117.27964, 32.82638], [-117.27975, 32.82669], [-117.27975, 32.82677], [-117.27984, 32.82694], [-117.27988, 32.82704], [-117.28, 32.8272], [-117.27998, 32.8274], [-117.28, 32.82748], [-117.28006, 32.8276], [-117.28007, 32.82775], [-117.28014, 32.82788], [-117.28025, 32.82832], [-117.28032, 32.82845], [-117.28034, 32.82855], [-117.28042, 32.82869], [-117.28042, 32.82876], [-117.28052, 32.82902]]]} | Open Access 1 | 46706 | La Jolla Strand Park | 30089 | 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 | 1.184 | La Jolla Strand Park | 0 | Local Park 2 | 4 | |
2770 | 2770 | 2769 | {"type": "Polygon", "coordinates": [[[-117.28011, 32.82509], [-117.28009, 32.82536], [-117.28002, 32.82566], [-117.27999, 32.82612], [-117.27954, 32.82622], [-117.27953, 32.82616], [-117.27953, 32.82584], [-117.27996, 32.82511], [-117.28011, 32.82509]]]} | Open Access 1 | 18505 | Hermosa Terrace Park | 30053 | 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 | 0.993 | Hermosa Terrace Park | 0 | Local Park 2 | 4 | |
5899 | 5899 | 5898 | {"type": "Polygon", "coordinates": [[[-117.27582, 32.84928], [-117.27579, 32.84932], [-117.27562, 32.84943], [-117.27548, 32.84959], [-117.27529, 32.8496], [-117.27524, 32.84962], [-117.27515, 32.8497], [-117.27499, 32.8497], [-117.27487, 32.84974], [-117.27485, 32.84976], [-117.27481, 32.84987], [-117.27466, 32.85002], [-117.27461, 32.85011], [-117.27452, 32.85017], [-117.27446, 32.85031], [-117.27437, 32.85038], [-117.27429, 32.8504], [-117.27422, 32.85045], [-117.27401, 32.85053], [-117.27394, 32.85052], [-117.27363, 32.85067], [-117.27355, 32.85067], [-117.27333, 32.85072], [-117.27323, 32.85076], [-117.27317, 32.85077], [-117.27323, 32.85063], [-117.27321, 32.85053], [-117.27301, 32.85027], [-117.27299, 32.85025], [-117.27296, 32.85026], [-117.27282, 32.85018], [-117.27299, 32.85018], [-117.2732, 32.85014], [-117.27343, 32.85007], [-117.27384, 32.84984], [-117.27417, 32.84958], [-117.27433, 32.8494], [-117.27444, 32.8492], [-117.27448, 32.84906], [-117.27519, 32.84903], [-117.27553, 32.84894], [-117.27569, 32.84889], [-117.27569, 32.84887], [-117.27577, 32.84884], [-117.27576, 32.84894], [-117.27578, 32.84897], [-117.27576, 32.84903], [-117.27578, 32.84905], [-117.27582, 32.84923], [-117.27582, 32.84928]]]} | Open Access 1 | 337 | Ellen Browning Scripps Neighborhood Park | 30159 | 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 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/ebscripps | San Diego 4 | 5.118 | Ellen Browning Scripps Neighborhood Park | 0 | Local Park 2 | 4 |
10459 | 10459 | 10458 | {"type": "Polygon", "coordinates": [[[-117.27442, 32.82285], [-117.27439, 32.82288], [-117.2744, 32.82331], [-117.27434, 32.82333], [-117.27422, 32.82306], [-117.27402, 32.8227], [-117.27427, 32.82259], [-117.27442, 32.82285]]]} | Open Access 1 | 18494 | Via Del Norte Mini Park | 27065 | 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 | 0.364 | Via Del Norte MP | 0 | Local Park 2 | 4 | |
8278 | 8278 | 8277 | {"type": "Polygon", "coordinates": [[[-117.27336, 32.83015], [-117.27336, 32.83015], [-117.27246, 32.83038], [-117.27278, 32.82957], [-117.27315, 32.8295], [-117.27336, 32.83015]]]} | Open Access 1 | 12666 | Starkey Mini-Park | 25806 | 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 | 1.169 | Starkey Mini-Park | 0 | Local Park 2 | 4 | |
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 | ||
10415 | 10415 | 10414 | {"type": "Polygon", "coordinates": [[[-117.273, 32.81695], [-117.27253, 32.81748], [-117.27252, 32.81747], [-117.27251, 32.81744], [-117.27266, 32.817], [-117.27267, 32.81695], [-117.27265, 32.81686], [-117.27285, 32.81681], [-117.27286, 32.81666], [-117.27291, 32.81663], [-117.273, 32.81695]]]} | Open Access 1 | 18421 | La Jolla Hermosa Park | 20765 | 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 | 0.383 | La Jolla Hermosa Park | 0 | Local Park 2 | 4 | |
5940 | 5940 | 5939 | {"type": "Polygon", "coordinates": [[[-117.27204, 32.82394], [-117.27142, 32.82407], [-117.27132, 32.82376], [-117.27003, 32.82349], [-117.26893, 32.82328], [-117.26882, 32.82295], [-117.26794, 32.82312], [-117.26813, 32.8227], [-117.26774, 32.82258], [-117.26743, 32.82238], [-117.2686, 32.82167], [-117.26915, 32.82235], [-117.26947, 32.82278], [-117.26976, 32.82262], [-117.27094, 32.82258], [-117.27156, 32.82298], [-117.27199, 32.8238], [-117.27204, 32.82394]]]} | Open Access 1 | 18493 | Soledad Open Space Park | 25598 | 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 | 10.299 | Soledad OS Park | 0 | Local Recreation Area 3 | 4 | |
1312 | 1312 | 1311 | {"type": "Polygon", "coordinates": [[[-117.27039, 32.84609], [-117.27014, 32.84608], [-117.26993, 32.8462], [-117.27002, 32.84597], [-117.27002, 32.84574], [-117.27016, 32.84595], [-117.27039, 32.84609]]]} | Open Access 1 | 7339 | Union Place Circle Mini-Park | 30081 | 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 | 0.154 | Union Place Circle Mini-Park | 0 | Local Park 2 | 4 | |
2334 | 2334 | 2333 | {"type": "Polygon", "coordinates": [[[-117.26968, 32.8112], [-117.26934, 32.81128], [-117.2691, 32.81048], [-117.26942, 32.81041], [-117.26968, 32.8112]]]} | Open Access 1 | 18424 | Calumet Park | 16741 | 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 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/calumet | San Diego 4 | 0.727 | Calumet Park | 0 | Local Park 2 | 4 |
7610 | 7610 | 7609 | {"type": "Polygon", "coordinates": [[[-117.26941, 32.81012], [-117.26933, 32.81014], [-117.26906, 32.8095], [-117.26872, 32.80895], [-117.26853, 32.80873], [-117.26761, 32.80787], [-117.26712, 32.80775], [-117.26642, 32.80781], [-117.26591, 32.80794], [-117.2658, 32.80803], [-117.26517, 32.80813], [-117.26497, 32.808], [-117.26421, 32.80759], [-117.2632, 32.80662], [-117.2628, 32.80601], [-117.26241, 32.80562], [-117.26225, 32.80557], [-117.26168, 32.80584], [-117.26132, 32.80617], [-117.26132, 32.8064], [-117.26108, 32.80639], [-117.26106, 32.80664], [-117.261, 32.80664], [-117.26095, 32.80666], [-117.26091, 32.80675], [-117.26066, 32.80692], [-117.26031, 32.80661], [-117.26027, 32.80665], [-117.26021, 32.80662], [-117.2602, 32.8066], [-117.26021, 32.80655], [-117.26096, 32.80596], [-117.26069, 32.80555], [-117.26186, 32.80492], [-117.26129, 32.80439], [-117.26166, 32.80431], [-117.26217, 32.80495], [-117.26218, 32.80497], [-117.26267, 32.80555], [-117.26275, 32.80571], [-117.26294, 32.80599], [-117.26314, 32.80627], [-117.26339, 32.80656], [-117.26339, 32.80658], [-117.26366, 32.80686], [-117.26367, 32.80688], [-117.26402, 32.80723], [-117.26435, 32.8075], [-117.2647, 32.80774], [-117.26506, 32.8079], [-117.26523, 32.80795], [-117.26535, 32.80797], [-117.26561, 32.80797], [-117.26574, 32.80795], [-117.26606, 32.80785], [-117.26637, 32.80772], [-117.26657, 32.80766], [-117.26693, 32.80762], [-117.26716, 32.80762], [-117.26733, 32.80764], [-117.26754, 32.80771], [-117.26771, 32.80781], [-117.26793, 32.80798], [-117.26805, 32.80812], [-117.26834, 32.80836], [-117.26853, 32.80855], [-117.26853, 32.80857], [-117.26877, 32.80883], [-117.2689, 32.80902], [-117.26893, 32.80907], [-117.26896, 32.8091], [-117.26915, 32.80943], [-117.26933, 32.80988], [-117.26941, 32.81012]]]} | Open Access 1 | 7344 | Tourmaline Surfing Park | 26479 | 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 | 8.023 | Tourmaline Surfing Park | 0 | Local Park 2 | 4 | |
16083 | 16083 | 16082 | {"type": "Polygon", "coordinates": [[[-117.26515, 32.8438], [-117.26511, 32.84397], [-117.26505, 32.84395], [-117.26498, 32.84389], [-117.26497, 32.84379], [-117.26498, 32.84377], [-117.26501, 32.84375], [-117.26509, 32.84374], [-117.26513, 32.84377], [-117.26515, 32.8438]]]} | Open Access 1 | 7341 | Ludington Heights Open Space Park West | 21584 | 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 | 0.075 | Ludington Heights OS Park West | None 1377 | |||
5765 | 5765 | 5764 | {"type": "Polygon", "coordinates": [[[-117.26413, 32.82818], [-117.26378, 32.82828], [-117.26336, 32.82802], [-117.26327, 32.82825], [-117.2632, 32.82823], [-117.26309, 32.82823], [-117.26284, 32.82833], [-117.26253, 32.82854], [-117.26228, 32.82857], [-117.26208, 32.82853], [-117.26209, 32.82838], [-117.26183, 32.82841], [-117.26175, 32.82826], [-117.26166, 32.82822], [-117.26165, 32.82805], [-117.26173, 32.82797], [-117.26163, 32.82784], [-117.26181, 32.82772], [-117.26193, 32.82775], [-117.26207, 32.82758], [-117.26227, 32.82744], [-117.26252, 32.82746], [-117.26312, 32.82771], [-117.26413, 32.82818]]]} | Open Access 1 | 18487 | La Jolla Bluebird Canyon Open Space | 20762 | 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 | 3.709 | La Jolla Bluebird Canyon OS | 0 | Local Recreation Area 3 | 4 | |
1311 | 1311 | 1310 | {"type": "Polygon", "coordinates": [[[-117.26402, 32.84939], [-117.26407, 32.8495], [-117.26406, 32.84954], [-117.26397, 32.8496], [-117.26395, 32.84966], [-117.26387, 32.84972], [-117.26384, 32.84976], [-117.26363, 32.84974], [-117.26402, 32.84939]]]} | Open Access 1 | 7338 | Charlotte Park | 17149 | 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 | 0.16 | Charlotte Park | 0 | Local Park 2 | 4 | |
335 | 335 | 334 | {"type": "Polygon", "coordinates": [[[-117.26243, 32.81163], [-117.26192, 32.81174], [-117.26174, 32.81106], [-117.26223, 32.81095], [-117.26243, 32.81163]]]} | Open Access 1 | 914 | Bird Rock Neighborhood Park | 30091 | 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 | 0.929 | Bird Rock Neighborhood Park | 0 | Local Park 2 | 4 | |
2346 | 2346 | 2345 | {"type": "Polygon", "coordinates": [[[-117.26049, 32.80372], [-117.26017, 32.80392], [-117.26018, 32.804], [-117.25938, 32.80418], [-117.25951, 32.80404], [-117.25999, 32.80376], [-117.26024, 32.80342], [-117.26049, 32.80372]]]} | Open Access 1 | 18458 | Palisades North Neighborhood Park | 30164 | 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 | 0.651 | Palisades North Neighborhood Park | 0 | Local Park 2 | 4 | |
2841 | 2841 | 2840 | {"type": "Polygon", "coordinates": [[[-117.25994, 32.80298], [-117.25981, 32.80306], [-117.25952, 32.80239], [-117.25945, 32.80228], [-117.25935, 32.80219], [-117.25919, 32.80211], [-117.2593, 32.80184], [-117.25941, 32.80193], [-117.25954, 32.80211], [-117.25969, 32.80243], [-117.2598, 32.80281], [-117.25994, 32.80298]]]} | Open Access 1 | 46743 | Palisades South Neighborhood Park | 30193 | 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 | 0.502 | Palisades South Neighborhood Park | 0 | Local Park 2 | 4 | |
16082 | 16082 | 16081 | {"type": "Polygon", "coordinates": [[[-117.25989, 32.84535], [-117.25988, 32.84542], [-117.25976, 32.84547], [-117.25976, 32.84541], [-117.25979, 32.84531], [-117.25983, 32.84528], [-117.25986, 32.84529], [-117.25988, 32.84531], [-117.25989, 32.84535]]]} | Open Access 1 | 7340 | Ludington Heights Open Space Park East | 21583 | 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 | 0.042 | Ludington Heights OS Park East | None 1376 |
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]);