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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10399 | 10399 | 10398 | {"type": "MultiPolygon", "coordinates": [[[[-122.3922, 37.71559], [-122.39216, 37.71564], [-122.39203, 37.71573], [-122.39196, 37.71582], [-122.39157, 37.71566], [-122.39149, 37.71561], [-122.39132, 37.71543], [-122.3911, 37.71508], [-122.39087, 37.71479], [-122.3906, 37.71435], [-122.39054, 37.71427], [-122.39045, 37.7142], [-122.39033, 37.71413], [-122.39002, 37.71405], [-122.38985, 37.71396], [-122.38975, 37.71387], [-122.38965, 37.71367], [-122.38954, 37.71354], [-122.38943, 37.71344], [-122.38929, 37.71335], [-122.38901, 37.71325], [-122.38871, 37.71322], [-122.38788, 37.71346], [-122.38782, 37.71323], [-122.38772, 37.7127], [-122.38766, 37.71253], [-122.38758, 37.71238], [-122.38748, 37.71225], [-122.38716, 37.71196], [-122.3877, 37.71161], [-122.38883, 37.71256], [-122.38931, 37.71267], [-122.38973, 37.71285], [-122.39008, 37.71307], [-122.39023, 37.71319], [-122.39047, 37.71342], [-122.39063, 37.71353], [-122.39074, 37.7136], [-122.39116, 37.71377], [-122.39105, 37.71375], [-122.39095, 37.71377], [-122.39087, 37.71383], [-122.39083, 37.71392], [-122.3908, 37.71408], [-122.3908, 37.71427], [-122.39084, 37.71445], [-122.39091, 37.71459], [-122.39144, 37.71537], [-122.3916, 37.71553], [-122.39168, 37.71558], [-122.3918, 37.71561], [-122.3919, 37.71561], [-122.39218, 37.71556], [-122.3922, 37.71559]]], [[[-122.39544, 37.71475], [-122.39542, 37.71483], [-122.39515, 37.71539], [-122.39505, 37.71539], [-122.39498, 37.71542], [-122.39492, 37.71549], [-122.39489, 37.71561], [-122.39442, 37.71586], [-122.39434, 37.71586], [-122.39417, 37.71579], [-122.39364, 37.71572], [-122.39313, 37.71555], [-122.39252, 37.71544], [-122.39229, 37.71543], [-122.39189, 37.7155], [-122.39181, 37.7155], [-122.39169, 37.71546], [-122.39159, 37.71535], [-122.39135, 37.71498], [-122.39106, 37.7146], [-122.39098, 37.71444], [-122.39094, 37.71429], [-122.39093, 37.71418], [-122.39094, 37.71403], [-122.39098, 37.7139], [-122.39102, 37.71387], [-122.39108, 37.71386], [-122.39128, 37.71394], [-122.39153, 37.71406], [-122.39171, 37.71413], [-122.39256, 37.7143], [-122.39306, 37.71438], [-122.39348, 37.71451], [-122.39369, 37.71454], [-122.39428, 37.71451], [-122.39441, 37.71452], [-122.39499, 37.71467], [-122.39544, 37.71475]]]]} | Open Access 1 | 18378 | Bayview Park | 15903 | 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 | 20.37 | Bayview Park | 0 | Local Park 2 | 4 | |
7082 | 7082 | 7081 | {"type": "Polygon", "coordinates": [[[-122.43873, 37.78243], [-122.43853, 37.78246], [-122.4385, 37.78234], [-122.43871, 37.78232], [-122.43873, 37.78243]]]} | Open Access 1 | 6099 | Beideman/o'farrell Mini Park | 15958 | 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.059 | Beideman/o'farrell MP | 0 | Local Park 2 | 4 | |
2056 | 2056 | 2055 | {"type": "Polygon", "coordinates": [[[-122.41317, 37.74214], [-122.41315, 37.74224], [-122.41294, 37.74222], [-122.41295, 37.74212], [-122.41317, 37.74214]]]} | Open Access 1 | 15690 | Bernal Heights Community Garden | 16025 | 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.056 | Bernal Heights Community Garden | 0 | Local Park 2 | 4 | |
39 | 39 | 38 | {"type": "Polygon", "coordinates": [[[-122.41541, 37.74416], [-122.41424, 37.74386], [-122.4139, 37.74373], [-122.41307, 37.74338], [-122.41292, 37.74333], [-122.41277, 37.74333], [-122.41262, 37.74335], [-122.41236, 37.74347], [-122.41201, 37.74361], [-122.41188, 37.74363], [-122.41171, 37.74361], [-122.41023, 37.74309], [-122.41017, 37.74304], [-122.41012, 37.74297], [-122.4101, 37.74289], [-122.4101, 37.74281], [-122.41018, 37.74269], [-122.41031, 37.74257], [-122.41045, 37.74251], [-122.4106, 37.74249], [-122.41164, 37.74243], [-122.41251, 37.7423], [-122.41265, 37.7423], [-122.41416, 37.74251], [-122.41432, 37.74252], [-122.41446, 37.7425], [-122.41461, 37.74246], [-122.41479, 37.74238], [-122.41501, 37.74225], [-122.41512, 37.74222], [-122.4159, 37.74217], [-122.41629, 37.74208], [-122.41647, 37.74206], [-122.41669, 37.74209], [-122.41682, 37.74216], [-122.41689, 37.74222], [-122.41696, 37.74233], [-122.41699, 37.74242], [-122.41698, 37.74251], [-122.41693, 37.74261], [-122.4167, 37.74279], [-122.41662, 37.74291], [-122.41657, 37.74307], [-122.41659, 37.74328], [-122.41655, 37.74337], [-122.41647, 37.74345], [-122.4161, 37.74363], [-122.41597, 37.74372], [-122.41586, 37.74383], [-122.4158, 37.74393], [-122.41575, 37.74406], [-122.41568, 37.74413], [-122.41556, 37.74418], [-122.41541, 37.74416]], [[-122.41555, 37.74286], [-122.41477, 37.74286], [-122.41477, 37.74327], [-122.41556, 37.74326], [-122.41555, 37.74286]]]} | Open Access 1 | 122 | Bernal Heights Park | 16026 | 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 | 19.35 | Bernal Heights Park | 0 | Local Park 2 | 4 | |
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 | |
16229 | 16229 | 16228 | {"type": "Polygon", "coordinates": [[[-122.41218, 37.79435], [-122.41147, 37.79444], [-122.41139, 37.79407], [-122.4121, 37.79398], [-122.41218, 37.79435]]]} | Open Access 1 | 47172 | Betty Ong Recreation Center | 30863 | 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/betty-ong-rec-center/ | San Francisco 13 | 0.653 | Betty Ong Rec. Ctr. | 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 | |||
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 | |
3944 | 3944 | 3943 | {"type": "Polygon", "coordinates": [[[-122.40744, 37.74501], [-122.40737, 37.7452], [-122.40686, 37.74507], [-122.40694, 37.74488], [-122.40744, 37.74501]]]} | Open Access 1 | 5731 | Brewster Cmmunity Garden | 16369 | 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.26 | Brewster Cmmunity Garden | 0 | Local Park 2 | 4 | |
7974 | 7974 | 7973 | {"type": "Polygon", "coordinates": [[[-122.41762, 37.79648], [-122.41725, 37.79653], [-122.41722, 37.79639], [-122.4176, 37.79634], [-122.41762, 37.79648]]]} | Open Access 1 | 15950 | Broadway Tunnel West Mini Park | 16411 | 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.125 | Broadway Tunnel West MP | 0 | Local Park 2 | 4 | |
9522 | 9522 | 9521 | {"type": "Polygon", "coordinates": [[[-122.41296, 37.79709], [-122.41291, 37.7971], [-122.41288, 37.797], [-122.41284, 37.797], [-122.41282, 37.79693], [-122.41292, 37.79692], [-122.41296, 37.79709]]]} | Open Access 1 | 15958 | Broadway Tunnel east Mini Park | 16410 | 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.033 | Broadway Tunnel east MP | 0 | Local Park 2 | 4 | |
3160 | 3160 | 3159 | {"type": "Polygon", "coordinates": [[[-122.46792, 37.71714], [-122.46758, 37.71714], [-122.46758, 37.71755], [-122.46724, 37.71756], [-122.46726, 37.71785], [-122.46669, 37.71784], [-122.46667, 37.71757], [-122.46634, 37.71757], [-122.46634, 37.71784], [-122.46613, 37.71785], [-122.46612, 37.71756], [-122.46578, 37.71757], [-122.46578, 37.71695], [-122.46611, 37.71695], [-122.46612, 37.71687], [-122.46792, 37.71687], [-122.46792, 37.71714]]]} | Open Access 1 | 21835 | Brooks Park | 16429 | 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.73 | Brooks Park | 0 | Local Park 2 | 4 | |
9378 | 9378 | 9377 | {"type": "Polygon", "coordinates": [[[-122.47036, 37.7124], [-122.47027, 37.71248], [-122.47025, 37.71257], [-122.47006, 37.71256], [-122.46939, 37.71243], [-122.46939, 37.71226], [-122.47035, 37.71225], [-122.47036, 37.7124]]]} | Open Access 1 | 15676 | Brotherhood & Chester Mini Park | 16441 | 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.59 | Brotherhood & Chester MP | 0 | Local Park 2 | 4 | |
2127 | 2127 | 2126 | {"type": "MultiPolygon", "coordinates": [[[[-122.42838, 37.77801], [-122.42815, 37.77804], [-122.42806, 37.77759], [-122.42829, 37.77756], [-122.42838, 37.77801]]], [[[-122.42857, 37.77894], [-122.42834, 37.77897], [-122.42819, 37.77823], [-122.42842, 37.7782], [-122.42857, 37.77894]]], [[[-122.42876, 37.77987], [-122.42853, 37.7799], [-122.42838, 37.77916], [-122.42861, 37.77913], [-122.42876, 37.77987]]], [[[-122.42895, 37.78081], [-122.42872, 37.78084], [-122.42857, 37.78009], [-122.4288, 37.78006], [-122.42895, 37.78081]]], [[[-122.42907, 37.78141], [-122.42884, 37.78144], [-122.42875, 37.78102], [-122.42899, 37.78099], [-122.42907, 37.78141]]]]} | Open Access 1 | 15943 | Buchanan Street Mall | 16470 | 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.813 | Buchanan Street Mall | None 171 | |||
6624 | 6624 | 6623 | {"type": "Polygon", "coordinates": [[[-122.44374, 37.76757], [-122.4436, 37.76795], [-122.44361, 37.76797], [-122.44326, 37.76884], [-122.44221, 37.76949], [-122.44226, 37.76963], [-122.4424, 37.76979], [-122.44259, 37.76978], [-122.44281, 37.76981], [-122.44298, 37.76997], [-122.44309, 37.77012], [-122.44316, 37.77039], [-122.44062, 37.77072], [-122.43988, 37.77049], [-122.43983, 37.77049], [-122.43959, 37.77036], [-122.43939, 37.76998], [-122.43915, 37.7698], [-122.43906, 37.7697], [-122.43904, 37.7697], [-122.43845, 37.7691], [-122.43892, 37.76848], [-122.44027, 37.76782], [-122.44072, 37.76703], [-122.44207, 37.76601], [-122.4424, 37.76602], [-122.4427, 37.7661], [-122.44291, 37.76625], [-122.44295, 37.76637], [-122.44296, 37.76638], [-122.44298, 37.76649], [-122.44345, 37.76678], [-122.44363, 37.7671], [-122.44374, 37.76757]]]} | Open Access 1 | 4392 | Buena Vista Park | 16492 | 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 | 36.12 | Buena Vista Park | 0 | Local Park 2 | 4 | |
1116 | 1116 | 1115 | {"type": "Polygon", "coordinates": [[[-122.44267, 37.78575], [-122.44248, 37.78578], [-122.4424, 37.7854], [-122.4426, 37.78538], [-122.44267, 37.78575]]]} | Open Access 1 | 6560 | Bush & Broderick Mini Park | 33394 | 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 | https://sfrecpark.org/destination/bush-broderick-mini-park/ | San Francisco 13 | 0.182 | Bush & Broderick MP | 0 | Local Park 2 | 4 |
997 | 997 | 996 | {"type": "Polygon", "coordinates": [[[-122.49914, 37.77303], [-122.49874, 37.77305], [-122.49874, 37.77312], [-122.49832, 37.77314], [-122.49829, 37.77266], [-122.49911, 37.77262], [-122.49914, 37.77303]]]} | Open Access 1 | 6208 | Cabrillo Playground | 16643 | 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.894 | Cabrillo Playground | 0 | Local Recreation Area 3 | 4 | |
9670 | 9670 | 9669 | {"type": "MultiPolygon", "coordinates": [[[[-122.47637, 37.73917], [-122.47555, 37.73921], [-122.47543, 37.73756], [-122.47625, 37.73752], [-122.47637, 37.73917]]], [[[-122.4765, 37.74103], [-122.47568, 37.74107], [-122.47556, 37.73943], [-122.47639, 37.73939], [-122.4765, 37.74103]]]]} | Open Access 1 | 16316 | Carl Larsen Park | 16853 | 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.585 | Carl Larsen Park | 0 | Local Park 2 | 4 | |
9502 | 9502 | 9501 | {"type": "Polygon", "coordinates": [[[-122.43308, 37.73045], [-122.43291, 37.7305], [-122.4328, 37.73023], [-122.43296, 37.73017], [-122.43308, 37.73045]]]} | Open Access 1 | 15909 | Cayuga & Lamartine Mini Park | 16985 | 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.126 | Cayuga & Lamartine MP | 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]);