units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
271 rows where COUNTY = 13 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP >30
- Local Park 112
- Local Recreation Area 72
- National Recreation Area 7
- Local Other or Unknown 3
- 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
- …
MNG_AGENCY 14
- San Francisco, City and County of 221
- United States National Park Service 9
- San Francisco Parks Alliance 5
- San Francisco - Public Utilities Commission, City and County of 3
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6834 | 6834 | 6833 | {"type": "MultiPolygon", "coordinates": [[[[-122.38909, 37.71702], [-122.38813, 37.71809], [-122.387, 37.71745], [-122.3879, 37.71646], [-122.38796, 37.71642], [-122.38806, 37.71643], [-122.38909, 37.71702]]], [[[-122.38859, 37.71548], [-122.38852, 37.71556], [-122.38854, 37.71568], [-122.38853, 37.71575], [-122.3884, 37.71602], [-122.38832, 37.71612], [-122.38849, 37.71638], [-122.38857, 37.71643], [-122.38856, 37.71644], [-122.38841, 37.71636], [-122.38834, 37.71628], [-122.38804, 37.71536], [-122.38827, 37.7151], [-122.3884, 37.71518], [-122.38859, 37.71548]]]]} | Open Access 1 | 5455 | Gilman Playground | 19297 | 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.205 | Gilman Playground | 0 | Local Recreation Area 3 | 4 | |
6835 | 6835 | 6834 | {"type": "Polygon", "coordinates": [[[-122.39877, 37.7096], [-122.39849, 37.71035], [-122.39758, 37.71014], [-122.39769, 37.70985], [-122.39779, 37.70987], [-122.39786, 37.70975], [-122.39877, 37.7096]]]} | Open Access 1 | 5457 | Little Hollywood Park | 21339 | 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.313 | Little Hollywood Park | 0 | Local Park 2 | 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 | |
5924 | 5924 | 5923 | {"type": "Polygon", "coordinates": [[[-122.39604, 37.71764], [-122.39553, 37.71819], [-122.39529, 37.71804], [-122.39582, 37.71752], [-122.39604, 37.71764]]]} | Open Access 1 | 5463 | Le Conte Mini Park | 21123 | 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.474 | Le Conte MP | 0 | Local Park 2 | 4 | |
838 | 838 | 837 | {"type": "Polygon", "coordinates": [[[-122.44984, 37.73813], [-122.44957, 37.73918], [-122.44952, 37.73922], [-122.44945, 37.73923], [-122.44886, 37.73921], [-122.44882, 37.7392], [-122.4488, 37.73916], [-122.44882, 37.73902], [-122.44896, 37.73851], [-122.44902, 37.7381], [-122.44907, 37.73808], [-122.44945, 37.73809], [-122.44971, 37.73804], [-122.44978, 37.73805], [-122.44983, 37.73809], [-122.44984, 37.73813]]]} | Open Access 1 | 5466 | Miraloma Playground | 22285 | 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.208 | Miraloma Playground | 0 | Local Recreation Area 3 | 4 | |
6845 | 6845 | 6844 | {"type": "Polygon", "coordinates": [[[-122.4606, 37.74202], [-122.46017, 37.74227], [-122.4602, 37.74231], [-122.4599, 37.74259], [-122.45924, 37.74241], [-122.45915, 37.74237], [-122.45931, 37.74182], [-122.45932, 37.74173], [-122.4593, 37.74167], [-122.45933, 37.7414], [-122.4596, 37.74141], [-122.45972, 37.74147], [-122.45971, 37.74151], [-122.45981, 37.74163], [-122.45974, 37.74167], [-122.45974, 37.74169], [-122.46008, 37.74186], [-122.46026, 37.74166], [-122.4606, 37.74202]]]} | Open Access 1 | 5470 | Edgehill Mountain | 18435 | 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.345 | Edgehill Mtn. | None 556 | |||
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 | |
6856 | 6856 | 6855 | {"type": "Polygon", "coordinates": [[[-122.44001, 37.74634], [-122.44, 37.7465], [-122.44, 37.74662], [-122.4394, 37.7473], [-122.43943, 37.74853], [-122.43834, 37.74853], [-122.43812, 37.74631], [-122.43913, 37.74626], [-122.43924, 37.74629], [-122.43932, 37.74625], [-122.43936, 37.74618], [-122.44001, 37.74634]]]} | Open Access 1 | 5489 | Douglass Playground | 18248 | 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 | 7.451 | Douglass Playground | 0 | Local Recreation Area 3 | 4 | |
6720 | 6720 | 6719 | {"type": "Polygon", "coordinates": [[[-122.42865, 37.74269], [-122.42692, 37.74279], [-122.42689, 37.74247], [-122.42706, 37.74246], [-122.42703, 37.74215], [-122.42859, 37.74206], [-122.42865, 37.74269]]]} | Open Access 1 | 5498 | Upper Noe Recreation Center | 30854 | 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/upper-noe-rec-center/ | San Francisco 13 | 2.511 | Upper Noe Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
735 | 735 | 734 | {"type": "Polygon", "coordinates": [[[-122.42952, 37.73851], [-122.42949, 37.73855], [-122.4295, 37.73861], [-122.42928, 37.73867], [-122.42929, 37.73892], [-122.4288, 37.73859], [-122.4288, 37.73837], [-122.42926, 37.73806], [-122.42927, 37.73835], [-122.42952, 37.73851]]]} | Open Access 1 | 5513 | Fairmount Plaza | 18812 | 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.742 | Fairmount Plaza | 0 | Local Park 2 | 4 | |
740 | 740 | 739 | {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} | Open Access 1 | 5519 | Diamond Hights Lot3 | 18142 | 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.023 | Diamond Hights Lot3 | 0 | Local Other or Unknown 14 | 4 | |
6866 | 6866 | 6865 | {"type": "Polygon", "coordinates": [[[-122.43563, 37.74024], [-122.43562, 37.74029], [-122.43553, 37.74043], [-122.43545, 37.74059], [-122.43539, 37.74077], [-122.43537, 37.7409], [-122.43485, 37.74091], [-122.43415, 37.74117], [-122.43393, 37.74107], [-122.43302, 37.74079], [-122.43317, 37.74047], [-122.43363, 37.74022], [-122.43549, 37.74013], [-122.43558, 37.74017], [-122.43563, 37.74024]]]} | Open Access 1 | 5520 | Walter Haas Playground | 27246 | 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.406 | Walter Haas Playground | 0 | Local Recreation Area 3 | 4 | |
6867 | 6867 | 6866 | {"type": "Polygon", "coordinates": [[[-122.43465, 37.74209], [-122.43433, 37.7421], [-122.4343, 37.74179], [-122.43417, 37.74157], [-122.43411, 37.74157], [-122.43407, 37.74153], [-122.434, 37.7415], [-122.43392, 37.74151], [-122.43382, 37.74159], [-122.43355, 37.74167], [-122.43253, 37.74172], [-122.43239, 37.74168], [-122.43209, 37.74148], [-122.43227, 37.74138], [-122.43249, 37.74131], [-122.43221, 37.74099], [-122.43261, 37.74078], [-122.43282, 37.74088], [-122.43396, 37.74123], [-122.43413, 37.74133], [-122.43427, 37.74146], [-122.43465, 37.74209]]]} | Open Access 1 | 5522 | Billy Goat Hill | 16115 | 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.19 | Billy Goat Hill | None 557 | |||
6874 | 6874 | 6873 | {"type": "Polygon", "coordinates": [[[-122.41643, 37.73815], [-122.41637, 37.73878], [-122.41588, 37.73874], [-122.41594, 37.73812], [-122.41643, 37.73815]]]} | Open Access 1 | 5524 | Bernal Heights Recreation Center | 30906 | 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/bernal-heights-rec-center/ | San Francisco 13 | 0.745 | Bernal Heights Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
16031 | 16031 | 16030 | {"type": "MultiPolygon", "coordinates": [[[[-122.41073, 37.74232], [-122.41072, 37.74236], [-122.41059, 37.74237], [-122.41059, 37.74232], [-122.41073, 37.74232]]], [[[-122.41136, 37.74229], [-122.41136, 37.74233], [-122.41122, 37.74234], [-122.41122, 37.74228], [-122.41136, 37.74229]]], [[[-122.41197, 37.74224], [-122.41197, 37.74227], [-122.41183, 37.74229], [-122.41184, 37.74224], [-122.41197, 37.74224]]], [[[-122.41541, 37.74416], [-122.41541, 37.74426], [-122.41446, 37.74402], [-122.41445, 37.74403], [-122.41446, 37.74416], [-122.41343, 37.74422], [-122.4134, 37.7439], [-122.41331, 37.74382], [-122.41315, 37.74375], [-122.41265, 37.7437], [-122.41245, 37.74361], [-122.41242, 37.74356], [-122.41231, 37.74349], [-122.41256, 37.74337], [-122.41267, 37.74334], [-122.41284, 37.74333], [-122.41297, 37.74334], [-122.4139, 37.74373], [-122.41424, 37.74386], [-122.41541, 37.74416]]], [[[-122.4126, 37.74215], [-122.4126, 37.74218], [-122.41246, 37.74219], [-122.41246, 37.74214], [-122.4126, 37.74215]]], [[[-122.41382, 37.74229], [-122.41382, 37.74235], [-122.41368, 37.74233], [-122.41369, 37.74229], [-122.41382, 37.74229]]], [[[-122.41572, 37.74203], [-122.41572, 37.74207], [-122.41558, 37.74208], [-122.41558, 37.74202], [-122.41572, 37.74203]]], [[[-122.41635, 37.74194], [-122.41635, 37.74195], [-122.41621, 37.74198], [-122.41621, 37.74193], [-122.41635, 37.74194]]], [[[-122.41763, 37.74237], [-122.41719, 37.74304], [-122.41667, 37.74283], [-122.41694, 37.7426], [-122.41699, 37.74248], [-122.41698, 37.74238], [-122.41689, 37.74222], [-122.41676, 37.74212], [-122.41663, 37.74207], [-122.41642, 37.74206], [-122.41641, 37.74195], [-122.41658, 37.74196], [-122.41674, 37.742], [-122.41682, 37.74186], [-122.41705, 37.74186], [-122.41721, 37.74193], [-122.41717, 37.74202], [-122.41737, 37.7421], [-122.41729, 37.74223], [-122.41763, 37.74237]]]]} | Open Access 1 | 5526 | Bernal Hts Open Space | 16027 | 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.838 | Bernal Hts OS | 0 | Local Recreation Area 3 | 4 | |
16032 | 16032 | 16031 | {"type": "Polygon", "coordinates": [[[-122.41585, 37.74445], [-122.41555, 37.74491], [-122.41512, 37.74474], [-122.4154, 37.74429], [-122.41562, 37.74437], [-122.41563, 37.74436], [-122.41585, 37.74445]]]} | Open Access 1 | 5528 | Bocana St. Open Space | 16217 | 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.604 | Bocana St. OS | 0 | Local Recreation Area 3 | 4 | |
859 | 859 | 858 | {"type": "Polygon", "coordinates": [[[-122.4154, 37.74429], [-122.41519, 37.74462], [-122.41503, 37.74455], [-122.41523, 37.74423], [-122.4154, 37.74429]]]} | Open Access 1 | 5530 | Coso St (vacated Portion) | 17671 | 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.157 | Coso St (vacated Portion) | None 77 | |||
861 | 861 | 860 | {"type": "Polygon", "coordinates": [[[-122.41555, 37.74491], [-122.41552, 37.74496], [-122.41507, 37.74482], [-122.41512, 37.74474], [-122.41555, 37.74491]]]} | Open Access 1 | 5535 | Vacated Portion Of Bocana St | 26751 | 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.089 | Vacated Portion Of Bocana St | None 78 | |||
6766 | 6766 | 6765 | {"type": "Polygon", "coordinates": [[[-122.40901, 37.74633], [-122.40895, 37.74639], [-122.40889, 37.74638], [-122.40879, 37.74632], [-122.40868, 37.74629], [-122.4085, 37.74603], [-122.40885, 37.74587], [-122.40884, 37.74564], [-122.40893, 37.74568], [-122.40901, 37.74633]]]} | Open Access 1 | 5541 | Mullen & Peralta Mini Park | 22596 | 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.456 | Mullen & Peralta MP | 0 | Local Park 2 | 4 | |
862 | 862 | 861 | {"type": "MultiPolygon", "coordinates": [[[[-122.44333, 37.73556], [-122.44313, 37.73558], [-122.44241, 37.73578], [-122.44241, 37.73539], [-122.44331, 37.73537], [-122.44333, 37.73556]]], [[[-122.44368, 37.73938], [-122.44259, 37.73944], [-122.44255, 37.73931], [-122.44256, 37.73921], [-122.44259, 37.73912], [-122.44267, 37.73868], [-122.44269, 37.73845], [-122.44264, 37.73816], [-122.44246, 37.73767], [-122.44246, 37.73757], [-122.44249, 37.73744], [-122.44257, 37.73728], [-122.44269, 37.73716], [-122.44346, 37.73669], [-122.44358, 37.7381], [-122.44349, 37.73818], [-122.44344, 37.73829], [-122.44338, 37.73885], [-122.44341, 37.73894], [-122.44347, 37.73903], [-122.44356, 37.73911], [-122.44367, 37.73917], [-122.44368, 37.73938]]], [[[-122.44373, 37.73995], [-122.44352, 37.73987], [-122.44296, 37.73975], [-122.44281, 37.73967], [-122.44271, 37.7396], [-122.4437, 37.73954], [-122.44373, 37.73995]]], [[[-122.44456, 37.74017], [-122.44413, 37.74021], [-122.44402, 37.74012], [-122.44397, 37.7396], [-122.44443, 37.73996], [-122.44456, 37.74017]]], [[[-122.44606, 37.74084], [-122.44535, 37.74089], [-122.44491, 37.74082], [-122.44474, 37.74076], [-122.44454, 37.74065], [-122.44437, 37.7405], [-122.44425, 37.74033], [-122.44464, 37.7403], [-122.4448, 37.74057], [-122.4449, 37.74061], [-122.44511, 37.74067], [-122.44576, 37.74076], [-122.44606, 37.74084]]], [[[-122.44842, 37.74265], [-122.44711, 37.74253], [-122.44681, 37.74245], [-122.44656, 37.74233], [-122.44641, 37.74222], [-122.4463, 37.74206], [-122.44626, 37.74193], [-122.44622, 37.7415], [-122.44617, 37.74137], [-122.44609, 37.74122], [-122.44609, 37.74118], [-122.4462, 37.74109], [-122.44632, 37.74106], [-122.44643, 37.74117], [-122.44652, 37.74132], [-122.44657, 37.74144], [-122.4466, 37.74158], [-122.44659, 37.74176], [-122.44665, 37.74191], [-122.44677, 37.74209], [-122.44687, 37.74219], [-122.44699, 37.74227], [-122.44714, 37.74234], [-122.4473, 37.74235], [-122.44731, 37.74229], [-122.44768, 37.74232], [-122.44765, 37.7425], [-122.44842, 37.74257], [-122.44842, 37.74265]]], [[[-122.44946, 37.74283], [-122.44941, 37.7429], [-122.44925, 37.74282], [-122.44905, 37.74275], [-122.44863, 37.74267], [-122.44863, 37.74259], [-122.44905, 37.74267], [-122.44926, 37.74274], [-122.44946, 37.74283]]], [[[-122.45165, 37.74524], [-122.45158, 37.74527], [-122.45152, 37.74525], [-122.45075, 37.74432], [-122.45075, 37.74419], [-122.45081, 37.74427], [-122.45083, 37.74426], [-122.45083, 37.74424], [-122.45093, 37.74441], [-122.45165, 37.74524]]]]} | Open Access 1 | 5544 | Reservoir Lands (Glen Park) | 24301 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 10.112 | Reservoir Lands (Glen Park) | None 79 |
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]);