units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
271 rows where COUNTY = 13 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST, GAP_STS
DES_TP >30
- Local Park 121
- Local Recreation Area 79
- National Recreation Area 7
- Local Other or Unknown 5
- State Recreation Area 2
- Local Conservation Area 1
- State Conservation Area 1
- Private Conservation 1
- Recreation Management Area 1
- Private Recreation or Education 1
- None 1
- None 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Historic or Cultural Area 1
- None 1
- …
AGNCY_NAME 15 ✖
- San Francisco, City and County of 241
- United States National Park Service 9
- San Francisco - Public Utilities Commission, City and County of 6
- California Department of Transportation 2
- San Francisco - Office of Community Investment and Infrastructure, City and County of 2
- San Francisco, Port of 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- California Department of Parks and Recreation 1
- University of California 1
- The Nature Conservancy 1
- California State Lands Commission 1
- San Francisco, City and County of, Redevelopment Agency 1
- San Francisco Unified School District 1
- Parkmerced Owner LLC 1
MNG_AGENCY 14
- San Francisco, City and County of 239
- United States National Park Service 9
- San Francisco - Public Utilities Commission, City and County of 5
- San Francisco Parks Alliance 5
- California Department of Parks and Recreation 2
- MJM Management Group 2
- San Francisco, Port of 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- University of California 1
- The Nature Conservancy 1
- California Department of Transportation 1
- San Francisco, City and County of, Redevelopment Agency 1
- Lao Family Community Development, Inc. 1
MNG_AG_TYP 8
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4647 | 4647 | 4646 | {"type": "Polygon", "coordinates": [[[-122.38148, 37.73182], [-122.38122, 37.73211], [-122.38122, 37.73223], [-122.38105, 37.73214], [-122.38098, 37.73216], [-122.3807, 37.73205], [-122.38067, 37.73203], [-122.38065, 37.73199], [-122.38066, 37.73194], [-122.38081, 37.73176], [-122.38103, 37.73152], [-122.38108, 37.7315], [-122.38114, 37.7315], [-122.38118, 37.73152], [-122.38134, 37.73167], [-122.38138, 37.73177], [-122.38148, 37.73182]]]} | Open Access 1 | 36528 | Unnamed site - San Francisco, City of | 28697 | 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.816 | 0 | Local Other or Unknown 14 | 4 | ||
7979 | 7979 | 7978 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78188], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.4682, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 15960 | 10th Ave & Clement Mini Park | 15169 | 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.684 | 10th Ave & Clement MP | 0 | Local Park 2 | 4 | |
4899 | 4899 | 4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 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.665 | 14th & 15th Avenue OS | 0 | Local Recreation Area 3 | 4 | |
6953 | 6953 | 6952 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47241, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47227, 37.75965], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.4724, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | Open Access 1 | 5859 | 15th Avenue Steps | 15174 | 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.516 | 15th Avenue Steps | None 568 | |||
6891 | 6891 | 6890 | {"type": "Polygon", "coordinates": [[[-122.40867, 37.7532], [-122.4085, 37.75321], [-122.40848, 37.75292], [-122.40865, 37.75291], [-122.40867, 37.7532]]]} | Open Access 1 | 5720 | 24th & York Mini Park | 15185 | 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.119 | 24th & York MP | 0 | Local Park 2 | 4 | |
15709 | 15709 | 15708 | {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73971], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} | Open Access 1 | 5549 | 298 Berkeley Way Open Space | 15190 | 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.831 | 298 Berkeley Way OS | 0 | Local Recreation Area 3 | 4 | |
1919 | 1919 | 1918 | {"type": "MultiPolygon", "coordinates": [[[[-122.38471, 37.73094], [-122.38443, 37.73124], [-122.38438, 37.73135], [-122.38424, 37.73144], [-122.38424, 37.73146], [-122.38417, 37.73151], [-122.38412, 37.73152], [-122.38406, 37.73146], [-122.38408, 37.73144], [-122.38396, 37.73131], [-122.38365, 37.7315], [-122.38384, 37.7317], [-122.38371, 37.73178], [-122.38341, 37.73147], [-122.38319, 37.73141], [-122.38328, 37.73126], [-122.38329, 37.73111], [-122.38319, 37.73087], [-122.38332, 37.73074], [-122.38337, 37.73076], [-122.38341, 37.73076], [-122.38352, 37.73068], [-122.38354, 37.73064], [-122.38353, 37.7306], [-122.38345, 37.73054], [-122.38342, 37.73053], [-122.38361, 37.73031], [-122.38471, 37.73094]]], [[[-122.38538, 37.73098], [-122.38518, 37.7312], [-122.38511, 37.73116], [-122.38531, 37.73094], [-122.38538, 37.73098]]]]} | Open Access 1 | 5932 | Adam Rogers Park | 15256 | 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.806 | Adam Rogers Park | 0 | Local Park 2 | 4 | |
5452 | 5452 | 5451 | {"type": "Polygon", "coordinates": [[[-122.38674, 37.76527], [-122.38641, 37.76568], [-122.38597, 37.76658], [-122.38587, 37.76659], [-122.38593, 37.76636], [-122.38592, 37.76628], [-122.38629, 37.76569], [-122.38652, 37.76541], [-122.38654, 37.76529], [-122.38647, 37.76528], [-122.38646, 37.76523], [-122.38674, 37.76527]]]} | Open Access 1 | 24968 | Agua Vista Park | 15295 | 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.469 | Agua Vista Park | 0 | Local Park 2 | 4 | |
714 | 714 | 713 | {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} | Open Access 1 | 4091 | Alamo Square | 15322 | 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 | 12.698 | Alamo Square | 2000 | Local Park 2 | 4 | |
12701 | 12701 | 12700 | {"type": "Polygon", "coordinates": [[[-122.42467, 37.82831], [-122.42422, 37.82828], [-122.42384, 37.82818], [-122.42355, 37.82805], [-122.42275, 37.82756], [-122.42256, 37.82751], [-122.42224, 37.82746], [-122.42212, 37.82741], [-122.42194, 37.82732], [-122.42183, 37.82729], [-122.42169, 37.82729], [-122.42156, 37.82731], [-122.42141, 37.82736], [-122.42135, 37.82737], [-122.42126, 37.82735], [-122.4212, 37.82732], [-122.42088, 37.82706], [-122.42084, 37.82701], [-122.42081, 37.82694], [-122.42086, 37.82678], [-122.42084, 37.82668], [-122.42075, 37.8266], [-122.42058, 37.82653], [-122.42045, 37.82642], [-122.42033, 37.82625], [-122.42029, 37.82608], [-122.42029, 37.82597], [-122.42033, 37.82583], [-122.42044, 37.82568], [-122.42073, 37.82512], [-122.42081, 37.82505], [-122.42094, 37.82498], [-122.42106, 37.82494], [-122.4212, 37.82492], [-122.42138, 37.82493], [-122.42155, 37.82498], [-122.42185, 37.82503], [-122.42215, 37.8251], [-122.42236, 37.82518], [-122.42262, 37.82531], [-122.42295, 37.82551], [-122.42315, 37.82559], [-122.42338, 37.82565], [-122.42351, 37.82566], [-122.42364, 37.82564], [-122.42381, 37.82566], [-122.42397, 37.82572], [-122.42409, 37.82579], [-122.42417, 37.82588], [-122.42425, 37.826], [-122.42427, 37.82611], [-122.42428, 37.82634], [-122.42432, 37.82645], [-122.42439, 37.82654], [-122.42446, 37.82661], [-122.42468, 37.82674], [-122.42496, 37.82702], [-122.42513, 37.82723], [-122.42525, 37.82734], [-122.42543, 37.82747], [-122.4257, 37.82763], [-122.42578, 37.82772], [-122.42582, 37.82782], [-122.42583, 37.82794], [-122.4258, 37.82802], [-122.42574, 37.82812], [-122.42565, 37.8282], [-122.42542, 37.82828], [-122.42517, 37.82832], [-122.42492, 37.82833], [-122.42467, 37.82831]]]} | Open Access 1 | 29702 | Alcatraz Island | 14190 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/alca/index.htm | San Francisco 13 | 24.914 | Alcatraz Island | 0 | National Recreation Area 54 | 3 |
6827 | 6827 | 6826 | {"type": "Polygon", "coordinates": [[[-122.44734, 37.70991], [-122.44625, 37.71028], [-122.44596, 37.70975], [-122.44705, 37.70937], [-122.44734, 37.70991]]]} | Open Access 1 | 5435 | Alice Chalmers Playground | 15359 | 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.678 | Alice Chalmers Playground | 0 | Local Recreation Area 3 | 4 | |
887 | 887 | 886 | {"type": "Polygon", "coordinates": [[[-122.41836, 37.75902], [-122.4181, 37.75904], [-122.41808, 37.75878], [-122.41833, 37.75876], [-122.41836, 37.75902]]]} | Open Access 1 | 5743 | Alioto Mini Park | 15366 | 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.161 | Alioto MP | 0 | Local Park 2 | 4 | |
7244 | 7244 | 7243 | {"type": "Polygon", "coordinates": [[[-122.42798, 37.79764], [-122.42731, 37.79773], [-122.42722, 37.79728], [-122.42789, 37.79719], [-122.42798, 37.79764]]]} | Open Access 1 | 6447 | Allyne Park | 15385 | 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.752 | Allyne Park | 0 | Local Park 2 | 4 | |
1722 | 1722 | 1721 | {"type": "Polygon", "coordinates": [[[-122.43935, 37.79177], [-122.4363, 37.79215], [-122.43599, 37.79058], [-122.43904, 37.79019], [-122.43935, 37.79177]]]} | Open Access 1 | 14881 | Alta Plaza | 15419 | 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 | 11.905 | Alta Plaza | 0 | Local Park 2 | 4 | |
1972 | 1972 | 1971 | {"type": "MultiPolygon", "coordinates": [[[[-122.45856, 37.77926], [-122.45682, 37.77948], [-122.45662, 37.77952], [-122.45657, 37.77952], [-122.45653, 37.77948], [-122.45628, 37.77823], [-122.45689, 37.77815], [-122.45692, 37.7782], [-122.45697, 37.77824], [-122.4571, 37.77827], [-122.45847, 37.7781], [-122.45856, 37.77926]]], [[[-122.45804, 37.77801], [-122.45765, 37.77806], [-122.45759, 37.77775], [-122.45798, 37.7777], [-122.45804, 37.77801]]]]} | Open Access 1 | 6076 | Angelo J Rossi Playground | 15497 | 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 | 6.474 | Angelo J Rossi Playground | 0 | Local Recreation Area 3 | 4 | |
9673 | 9673 | 9672 | {"type": "Polygon", "coordinates": [[[-122.46755, 37.72831], [-122.46726, 37.72858], [-122.46699, 37.72888], [-122.46678, 37.72914], [-122.46657, 37.72944], [-122.46548, 37.72903], [-122.46575, 37.72864], [-122.46609, 37.72822], [-122.4664, 37.72789], [-122.46684, 37.72753], [-122.46709, 37.72775], [-122.46726, 37.72793], [-122.46755, 37.72831]]]} | Open Access 1 | 16319 | Aptos Playground | 15546 | 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.793 | Aptos Playground | 0 | Local Recreation Area 3 | 4 | |
13149 | 13149 | 13148 | {"type": "Polygon", "coordinates": [[[-122.42687, 37.8088], [-122.42684, 37.80881], [-122.42683, 37.80906], [-122.4268, 37.8093], [-122.42674, 37.80949], [-122.42667, 37.80967], [-122.42657, 37.80986], [-122.42642, 37.81007], [-122.42629, 37.81021], [-122.42615, 37.81034], [-122.42596, 37.81048], [-122.42576, 37.81058], [-122.42552, 37.81068], [-122.42532, 37.81074], [-122.42511, 37.81078], [-122.4249, 37.8108], [-122.42466, 37.81079], [-122.42446, 37.81075], [-122.42432, 37.81066], [-122.42427, 37.81059], [-122.42427, 37.81054], [-122.4243, 37.81048], [-122.42439, 37.81041], [-122.42449, 37.8104], [-122.4246, 37.81043], [-122.42466, 37.81049], [-122.42469, 37.81059], [-122.42474, 37.81063], [-122.42506, 37.81062], [-122.42535, 37.81056], [-122.42559, 37.81047], [-122.42582, 37.81035], [-122.42604, 37.81019], [-122.4262, 37.81003], [-122.42631, 37.80989], [-122.42649, 37.80957], [-122.42657, 37.80936], [-122.42661, 37.80919], [-122.42663, 37.80901], [-122.42663, 37.80883], [-122.42445, 37.8091], [-122.42439, 37.80887], [-122.42208, 37.80883], [-122.42194, 37.80818], [-122.42192, 37.80817], [-122.42162, 37.80788], [-122.42154, 37.80749], [-122.42086, 37.80757], [-122.4207, 37.80673], [-122.42249, 37.8065], [-122.42259, 37.80647], [-122.42486, 37.80619], [-122.42485, 37.80609], [-122.4257, 37.80598], [-122.4267, 37.80795], [-122.42687, 37.8088]]]} | Open Access 1 | 35096 | Aquatic Park | 14191 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/safr/planyourvisit/aquaticparkcove.htm | San Francisco 13 | 33.068 | Aquatic Park | 1972 | Recreation Management Area 49 | 4 |
6422 | 6422 | 6421 | {"type": "Polygon", "coordinates": [[[-122.47813, 37.7796], [-122.4773, 37.77964], [-122.47727, 37.77923], [-122.4781, 37.77919], [-122.47813, 37.7796]]]} | Open Access 1 | 6160 | Argonne Playground | 15583 | 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.819 | Argonne Playground | 0 | Local Recreation Area 3 | 4 | |
2124 | 2124 | 2123 | {"type": "Polygon", "coordinates": [[[-122.39829, 37.75743], [-122.39812, 37.75744], [-122.3981, 37.75726], [-122.39827, 37.75725], [-122.39829, 37.75743]]]} | Open Access 1 | 15934 | Arkansas Friendship Garden | 15586 | 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.075 | Arkansas Friendship Garden | 0 | Local Park 2 | 4 | |
9497 | 9497 | 9496 | {"type": "Polygon", "coordinates": [[[-122.42661, 37.73695], [-122.42617, 37.73724], [-122.42612, 37.73719], [-122.42652, 37.73686], [-122.42661, 37.73695]]]} | Open Access 1 | 15906 | Arlington Community Garden | 15587 | 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.129 | Arlington Community Garden | 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]);