units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 218
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- San Francisco, City and County of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4090 | 4090 | 4089 | {"type": "Polygon", "coordinates": [[[-122.41577, 37.78497], [-122.41511, 37.78505], [-122.41504, 37.78468], [-122.41569, 37.78459], [-122.41577, 37.78497]]]} | Open Access 1 | 47170 | Tenderloin Recreation Center | 30859 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/tenderloin-rec-center-park/ | San Francisco 13 | 0.606 | Tenderloin Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
6299 | 6299 | 6298 | {"type": "MultiPolygon", "coordinates": [[[[-122.40683, 37.80313], [-122.40672, 37.80315], [-122.40675, 37.80308], [-122.40676, 37.803], [-122.40673, 37.80285], [-122.40655, 37.80261], [-122.40649, 37.80255], [-122.40635, 37.80231], [-122.40625, 37.8021], [-122.40613, 37.80194], [-122.40604, 37.80186], [-122.40588, 37.80179], [-122.40577, 37.80178], [-122.4056, 37.80178], [-122.40548, 37.80184], [-122.40539, 37.80192], [-122.40533, 37.802], [-122.40532, 37.80214], [-122.40537, 37.80228], [-122.40574, 37.80278], [-122.40576, 37.80288], [-122.40579, 37.80295], [-122.40591, 37.80301], [-122.40604, 37.80301], [-122.40613, 37.80296], [-122.40617, 37.80289], [-122.40617, 37.80283], [-122.40613, 37.80275], [-122.406, 37.80268], [-122.40586, 37.80269], [-122.40571, 37.80264], [-122.40543, 37.80226], [-122.40538, 37.80212], [-122.4054, 37.802], [-122.40546, 37.80192], [-122.40549, 37.80189], [-122.40556, 37.80186], [-122.40565, 37.80184], [-122.40576, 37.80183], [-122.40589, 37.80186], [-122.40597, 37.8019], [-122.4061, 37.80202], [-122.40616, 37.8021], [-122.4064, 37.80258], [-122.40663, 37.80287], [-122.40666, 37.80296], [-122.40665, 37.80306], [-122.40657, 37.80319], [-122.40636, 37.80329], [-122.40622, 37.80339], [-122.40618, 37.80349], [-122.40619, 37.80358], [-122.40508, 37.80373], [-122.40496, 37.80315], [-122.40526, 37.80311], [-122.40528, 37.80318], [-122.40545, 37.80315], [-122.40521, 37.80198], [-122.40524, 37.80192], [-122.40533, 37.80183], [-122.40544, 37.80177], [-122.40609, 37.80171], [-122.40619, 37.80181], [-122.40633, 37.80186], [-122.40641, 37.80225], [-122.40647, 37.80243], [-122.40655, 37.8026], [-122.40671, 37.80258], [-122.40667, 37.80261], [-122.40667, 37.80267], [-122.40672, 37.80272], [-122.40679, 37.80275], [-122.40676, 37.80277], [-122.40683, 37.80313]]], [[[-122.40649, 37.80355], [-122.40635, 37.80356], [-122.40633, 37.80352], [-122.40636, 37.80344], [-122.40645, 37.80336], [-122.40649, 37.80355]]]]} | Open Access 1 | 1426 | Telegraph Hill (Pioneer Park) | 26224 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.912 | Telegraph Hill (Pioneer Park) | None 511 | |||
15821 | 15821 | 15820 | {"type": "Polygon", "coordinates": [[[-122.44835, 37.76017], [-122.44827, 37.76026], [-122.44799, 37.76046], [-122.44692, 37.76053], [-122.44701, 37.76033], [-122.44722, 37.75978], [-122.44733, 37.7596], [-122.44746, 37.75945], [-122.4476, 37.75936], [-122.44774, 37.75928], [-122.44796, 37.75921], [-122.44812, 37.75918], [-122.44817, 37.75999], [-122.44833, 37.75999], [-122.44835, 37.76017]]]} | Open Access 1 | 5600 | Tank Hill Open Space | 26181 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.866 | Tank Hill OS | 0 | Local Recreation Area 3 | 4 | |
6837 | 6837 | 6836 | {"type": "Polygon", "coordinates": [[[-122.49841, 37.74932], [-122.49761, 37.74935], [-122.4976, 37.74941], [-122.49561, 37.7495], [-122.4956, 37.74928], [-122.49643, 37.74925], [-122.49633, 37.74786], [-122.49834, 37.74777], [-122.49841, 37.74932]]]} | Open Access 1 | 5460 | Sunset West Playground | 26071 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 8.05 | Sunset West Playground | 0 | Local Recreation Area 3 | 4 | |
5058 | 5058 | 5057 | {"type": "Polygon", "coordinates": [[[-122.48732, 37.75739], [-122.48649, 37.75743], [-122.48638, 37.75579], [-122.4872, 37.75575], [-122.48732, 37.75739]]]} | Open Access 1 | 1309 | Sunset Recreation Center | 30853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/sunset-rec-center-park/ | San Francisco 13 | 3.286 | Sunset Rec. Ctr. | 1940 | Local Recreation Area 3 | 4 |
6853 | 6853 | 6852 | {"type": "Polygon", "coordinates": [[[-122.44843, 37.73378], [-122.44838, 37.73378], [-122.44838, 37.73391], [-122.44828, 37.73392], [-122.44828, 37.73401], [-122.44811, 37.73401], [-122.44809, 37.73391], [-122.44667, 37.73395], [-122.44652, 37.73385], [-122.44657, 37.73374], [-122.44656, 37.73317], [-122.4467, 37.73317], [-122.44671, 37.73345], [-122.44696, 37.73345], [-122.44833, 37.73344], [-122.44834, 37.73317], [-122.44842, 37.73317], [-122.44843, 37.73378]]]} | Open Access 1 | 5480 | Sunnyside Playground | 26011 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.372 | Sunnyside Playground | 0 | Local Recreation Area 3 | 4 | |
6966 | 6966 | 6965 | {"type": "Polygon", "coordinates": [[[-122.44097, 37.73199], [-122.44063, 37.73199], [-122.44063, 37.73231], [-122.44054, 37.7323], [-122.44054, 37.73199], [-122.44057, 37.73198], [-122.44058, 37.73194], [-122.44071, 37.73193], [-122.44071, 37.73172], [-122.44097, 37.73171], [-122.44097, 37.73199]]]} | Open Access 1 | 5883 | Sunnyside Conservatory | 26009 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.258 | Sunnyside Conservatory | None 569 | |||
6922 | 6922 | 6921 | {"type": "Polygon", "coordinates": [[[-122.43856, 37.76345], [-122.43825, 37.76361], [-122.43795, 37.76371], [-122.43764, 37.76378], [-122.43735, 37.76381], [-122.43733, 37.76371], [-122.43717, 37.76371], [-122.43714, 37.76342], [-122.43803, 37.76336], [-122.43856, 37.76345]]]} | Open Access 1 | 5816 | States St. Playground | 25813 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.997 | States St. Playground | 0 | Local Recreation Area 3 | 4 | |
1054 | 1054 | 1053 | {"type": "Polygon", "coordinates": [[[-122.40559, 37.79237], [-122.40514, 37.79243], [-122.405, 37.79169], [-122.40544, 37.79163], [-122.40559, 37.79237]]]} | Open Access 1 | 6400 | St Mary's Square | 25764 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.824 | St Mary's Square | 0 | Local Park 2 | 4 | |
14511 | 14511 | 14510 | {"type": "Polygon", "coordinates": [[[-122.40686, 37.77874], [-122.40669, 37.77888], [-122.40674, 37.77894], [-122.40655, 37.77909], [-122.40582, 37.7785], [-122.40619, 37.77821], [-122.40686, 37.77874]]]} | Open Access 1 | 47169 | South of Market/ Gene Friend Recreation Center | 30858 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://www.sfparksalliance.org/our-parks/parks/south-market-gene-friend-recreation-center | San Francisco 13 | 1.019 | South of Market/ Gene Friend Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
1901 | 1901 | 1900 | {"type": "Polygon", "coordinates": [[[-122.49902, 37.73817], [-122.49804, 37.73822], [-122.49793, 37.73657], [-122.49883, 37.73653], [-122.49891, 37.73763], [-122.49898, 37.73763], [-122.49902, 37.73817]]]} | Open Access 1 | 16303 | South Sunset Playground | 25681 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 3.725 | South Sunset Playground | 0 | Local Recreation Area 3 | 4 | |
6104 | 6104 | 6103 | {"type": "Polygon", "coordinates": [[[-122.3946, 37.78122], [-122.39403, 37.78161], [-122.39339, 37.7821], [-122.39323, 37.78208], [-122.3932, 37.78198], [-122.39385, 37.78147], [-122.39436, 37.78105], [-122.39447, 37.781], [-122.3946, 37.78105], [-122.3946, 37.78122]]]} | Open Access 1 | 1023 | South Park | 25673 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.926 | South Park | 0 | Local Park 2 | 4 | |
14827 | 14827 | 14826 | {"type": "Polygon", "coordinates": [[[-122.42157, 37.77045], [-122.42131, 37.77037], [-122.4213, 37.77034], [-122.42116, 37.77034], [-122.4207, 37.77027], [-122.42032, 37.77026], [-122.42031, 37.77011], [-122.42153, 37.77003], [-122.42157, 37.77045]]]} | Open Access 1 | 47234 | SoMa West Skate Park | 30945 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.741 | SoMa West Skate Park | 0 | Local Recreation Area 3 | 4 | |
14780 | 14780 | 14779 | {"type": "Polygon", "coordinates": [[[-122.42232, 37.77085], [-122.42202, 37.77067], [-122.4217, 37.77052], [-122.42166, 37.7701], [-122.422, 37.77024], [-122.42227, 37.77039], [-122.42232, 37.77085]]]} | Open Access 1 | 47235 | SoMa West Dog Park | 30946 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.617 | SoMa West Dog Park | 0 | Local Park 2 | 4 | |
6950 | 6950 | 6949 | {"type": "Polygon", "coordinates": [[[-122.46373, 37.75952], [-122.46335, 37.75953], [-122.4635, 37.75925], [-122.46352, 37.75901], [-122.46337, 37.75867], [-122.46367, 37.75865], [-122.46373, 37.75952]]]} | Open Access 1 | 5849 | Slug's Garden For The Environment | 25560 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.507 | Slug's Garden For The Environment | None 567 | |||
929 | 929 | 928 | {"type": "Polygon", "coordinates": [[[-122.40443, 37.73299], [-122.40328, 37.7337], [-122.40308, 37.73351], [-122.40292, 37.73361], [-122.40187, 37.73255], [-122.4016, 37.7327], [-122.40156, 37.73266], [-122.40239, 37.7322], [-122.40249, 37.73242], [-122.40342, 37.73217], [-122.40356, 37.73217], [-122.40383, 37.73243], [-122.40385, 37.73242], [-122.40443, 37.73299]]]} | Open Access 1 | 5907 | Silver Terrace Playground | 25496 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 5.483 | Silver Terrace Playground | 0 | Local Recreation Area 3 | 4 | |
6067 | 6067 | 6066 | {"type": "Polygon", "coordinates": [[[-122.48187, 37.73567], [-122.48177, 37.73645], [-122.48165, 37.73647], [-122.48167, 37.73706], [-122.47545, 37.73734], [-122.4753, 37.73486], [-122.47533, 37.73482], [-122.4761, 37.73484], [-122.47852, 37.73477], [-122.48187, 37.73567]]]} | Open Access 1 | 805 | Sigmund Stern Grove | 25474 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 33.805 | Sigmund Stern Grove | 0 | Local Park 2 | 4 | |
3161 | 3161 | 3160 | {"type": "Polygon", "coordinates": [[[-122.3996, 37.79786], [-122.39863, 37.79796], [-122.39849, 37.79718], [-122.39943, 37.7971], [-122.3996, 37.79786]]]} | Open Access 1 | 21913 | Sidney Walton Park | 25439 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.816 | Sidney Walton Park | 0 | Local Park 2 | 4 | |
9381 | 9381 | 9380 | {"type": "Polygon", "coordinates": [[[-122.40064, 37.73869], [-122.40024, 37.73914], [-122.40006, 37.73904], [-122.40047, 37.73859], [-122.40064, 37.73869]]]} | Open Access 1 | 15682 | Shlby & Palou Mini Park | 25417 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.287 | Shlby & Palou MP | 0 | Local Park 2 | 4 | |
15688 | 15688 | 15687 | {"type": "MultiPolygon", "coordinates": [[[[-122.48702, 37.6263], [-122.48655, 37.62658], [-122.48643, 37.62662], [-122.48629, 37.62664], [-122.48616, 37.62664], [-122.48603, 37.62661], [-122.48592, 37.62657], [-122.48575, 37.62645], [-122.48565, 37.62631], [-122.48562, 37.6262], [-122.48558, 37.62569], [-122.48554, 37.6255], [-122.48541, 37.62524], [-122.48523, 37.62504], [-122.48501, 37.6249], [-122.48476, 37.62481], [-122.48384, 37.62463], [-122.48351, 37.62461], [-122.48332, 37.62463], [-122.48314, 37.62466], [-122.48161, 37.62511], [-122.48145, 37.62518], [-122.4813, 37.62526], [-122.4811, 37.62542], [-122.48093, 37.62562], [-122.48076, 37.62597], [-122.48052, 37.62649], [-122.48042, 37.62664], [-122.4803, 37.62675], [-122.48014, 37.62685], [-122.47997, 37.62693], [-122.47977, 37.62698], [-122.47875, 37.62705], [-122.47843, 37.6271], [-122.4688, 37.62708], [-122.46426, 37.62116], [-122.48041, 37.62146], [-122.48416, 37.62155], [-122.4842, 37.62157], [-122.48433, 37.62181], [-122.48449, 37.62195], [-122.48455, 37.62202], [-122.48465, 37.62231], [-122.48478, 37.62296], [-122.48492, 37.62338], [-122.48502, 37.6247], [-122.48516, 37.62476], [-122.48526, 37.62484], [-122.48533, 37.62493], [-122.48539, 37.62505], [-122.48659, 37.62582], [-122.48702, 37.6263]]], [[[-122.48741, 37.62712], [-122.48228, 37.62711], [-122.48228, 37.62601], [-122.48126, 37.62601], [-122.48125, 37.62656], [-122.48099, 37.62656], [-122.48098, 37.6271], [-122.48003, 37.6271], [-122.48021, 37.62703], [-122.48036, 37.62694], [-122.4805, 37.62682], [-122.48061, 37.6267], [-122.48073, 37.62653], [-122.48111, 37.6257], [-122.48124, 37.62553], [-122.48141, 37.6254], [-122.48169, 37.62527], [-122.48319, 37.62482], [-122.48338, 37.62478], [-122.48358, 37.62477], [-122.48382, 37.62479], [-122.48471, 37.62497], [-122.48493, 37.62506], [-122.4851, 37.62517], [-122.48523, 37.62533], [-122.4853, 37.62544], [-122.48535, 37.62557], [-122.48537, 37.6257], [-122.48542, 37.62622], [-122.48545, 37.62635], [-122.48556, 37.62653], [-122.48573, 37.62667], [-122.4859, 37.62675], [-122.48606, 37.62679], [-122.48625, 37.62681], [-122.48642, 37.62679], [-122.48666, 37.62672], [-122.48715, 37.62643], [-122.48726, 37.62655], [-122.48727, 37.62691], [-122.48741, 37.62712]]], [[[-122.49707, 37.62106], [-122.49634, 37.62137], [-122.49632, 37.62144], [-122.49668, 37.62221], [-122.49506, 37.62934], [-122.49503, 37.62979], [-122.49502, 37.62963], [-122.49501, 37.62962], [-122.49458, 37.62988], [-122.49433, 37.63], [-122.49411, 37.63001], [-122.49409, 37.62982], [-122.49222, 37.62982], [-122.49189, 37.62978], [-122.49148, 37.62965], [-122.49127, 37.62955], [-122.49115, 37.62947], [-122.49101, 37.62934], [-122.49083, 37.62911], [-122.49076, 37.62898], [-122.49068, 37.62876], [-122.49065, 37.62864], [-122.49057, 37.6272], [-122.48958, 37.62723], [-122.48938, 37.62671], [-122.48924, 37.62643], [-122.48908, 37.6262], [-122.48887, 37.62595], [-122.4887, 37.62578], [-122.48815, 37.62535], [-122.48786, 37.62507], [-122.48618, 37.62321], [-122.48574, 37.62275], [-122.48556, 37.62251], [-122.48553, 37.62225], [-122.48562, 37.62203], [-122.48591, 37.62164], [-122.49152, 37.62174], [-122.49152, 37.62169], [-122.49159, 37.62173], [-122.49344, 37.62181], [-122.4931, 37.62054], [-122.49707, 37.62106]]]]} | Restricted Access 2 | 15359 | Sharp Park Golf Course | 33048 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Mateo 15 | 407.344 | Sharp Park GC | 1972 | 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]);