units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
248 rows where ACCESS_TYP = 1 and AGNCY_NAME = 33
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74 | 74 | 73 | {"type": "Polygon", "coordinates": [[[-121.88839, 37.30077], [-121.88844, 37.30077], [-121.88849, 37.3008], [-121.88874, 37.30116], [-121.88913, 37.30175], [-121.88914, 37.3018], [-121.88912, 37.30184], [-121.88672, 37.30289], [-121.88666, 37.30289], [-121.88661, 37.30287], [-121.88592, 37.30185], [-121.88593, 37.3018], [-121.88839, 37.30077]]]} | Open Access 1 | 173 | River Glen Park | 24409 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.688 | River Glen Park | 1983 | Local Park 2 | 4 | |
119 | 119 | 118 | {"type": "Polygon", "coordinates": [[[-121.89805, 37.34221], [-121.89766, 37.34234], [-121.89763, 37.34236], [-121.89768, 37.34241], [-121.89676, 37.34271], [-121.89668, 37.34258], [-121.89615, 37.3428], [-121.8958, 37.34297], [-121.89546, 37.34252], [-121.89603, 37.34227], [-121.89719, 37.34189], [-121.89753, 37.34165], [-121.89768, 37.34174], [-121.89805, 37.34221]]]} | Open Access 1 | 332 | Ryland Park | 24761 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.418 | Ryland Park | 1986 | Local Park 2 | 4 | |
194 | 194 | 193 | {"type": "Polygon", "coordinates": [[[-121.94552, 37.31845], [-121.94347, 37.31848], [-121.94348, 37.31762], [-121.94351, 37.31759], [-121.94354, 37.31758], [-121.94357, 37.31766], [-121.94364, 37.31768], [-121.94368, 37.31766], [-121.9437, 37.31764], [-121.94369, 37.31755], [-121.94377, 37.31753], [-121.94543, 37.31734], [-121.94548, 37.31734], [-121.94551, 37.31739], [-121.94552, 37.31845]]]} | Open Access 1 | 550 | Santana Park | 25148 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.009 | Santana Park | 1978 | Local Park 2 | 4 | |
206 | 206 | 205 | {"type": "MultiPolygon", "coordinates": [[[[-121.99722, 37.29824], [-121.99724, 37.29876], [-121.99723, 37.29911], [-121.99718, 37.29963], [-121.99712, 37.29992], [-121.997, 37.30027], [-121.9964, 37.30157], [-121.9961, 37.30227], [-121.99595, 37.30272], [-121.99534, 37.30257], [-121.99527, 37.30258], [-121.9952, 37.30263], [-121.99491, 37.30257], [-121.99598, 37.30099], [-121.99615, 37.30072], [-121.99637, 37.30026], [-121.99654, 37.2998], [-121.99664, 37.29932], [-121.99675, 37.29863], [-121.99676, 37.29847], [-121.99683, 37.29818], [-121.99722, 37.29824]]], [[[-121.9971, 37.29508], [-121.99705, 37.29557], [-121.99704, 37.29596], [-121.99705, 37.29647], [-121.99709, 37.29688], [-121.99697, 37.29747], [-121.99635, 37.29738], [-121.99677, 37.29505], [-121.9971, 37.29508]]]]} | Open Access 1 | 559 | Saratoga Creek Park | 25158 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 10.274 | Saratoga Creek Park | 1982 | Local Park 2 | 4 | |
283 | 283 | 282 | {"type": "Polygon", "coordinates": [[[-121.83395, 37.28668], [-121.83326, 37.28716], [-121.83159, 37.28524], [-121.83237, 37.2848], [-121.83246, 37.28472], [-121.83255, 37.28474], [-121.83263, 37.28484], [-121.83263, 37.28489], [-121.83258, 37.28503], [-121.83268, 37.28506], [-121.83261, 37.28527], [-121.83299, 37.28536], [-121.83302, 37.2853], [-121.83308, 37.28531], [-121.83315, 37.2851], [-121.83366, 37.28521], [-121.83379, 37.28482], [-121.83386, 37.28484], [-121.83388, 37.28486], [-121.8339, 37.28555], [-121.83392, 37.28556], [-121.83395, 37.28668]]]} | Open Access 1 | 962 | Solari Park | 25596 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 7.564 | Solari Park | 1976 | Local Park 2 | 4 | |
404 | 404 | 403 | {"type": "MultiPolygon", "coordinates": [[[[-121.87633, 37.26877], [-121.87629, 37.26882], [-121.87618, 37.26884], [-121.87574, 37.26885], [-121.87552, 37.26887], [-121.87461, 37.26909], [-121.87453, 37.26908], [-121.87449, 37.26904], [-121.87439, 37.26876], [-121.87434, 37.26866], [-121.87424, 37.26856], [-121.87417, 37.26852], [-121.87404, 37.26847], [-121.87423, 37.26803], [-121.87413, 37.26777], [-121.87434, 37.26772], [-121.87445, 37.26772], [-121.87451, 37.26768], [-121.87452, 37.26763], [-121.87484, 37.26755], [-121.87519, 37.2675], [-121.87526, 37.26756], [-121.87535, 37.26757], [-121.87541, 37.26755], [-121.8755, 37.26747], [-121.87592, 37.26738], [-121.87603, 37.26737], [-121.87607, 37.26738], [-121.87612, 37.26742], [-121.87614, 37.26746], [-121.87633, 37.26877]]], [[[-121.87705, 37.26835], [-121.87652, 37.26841], [-121.87646, 37.2684], [-121.87641, 37.26836], [-121.87625, 37.26729], [-121.87626, 37.26697], [-121.87624, 37.26684], [-121.87658, 37.26676], [-121.87676, 37.26782], [-121.87699, 37.26776], [-121.87705, 37.26835]]]]} | Open Access 1 | 1546 | Thousand Oaks | 26323 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.805 | Thousand Oaks | 1985 | None 42 | ||
444 | 444 | 443 | {"type": "MultiPolygon", "coordinates": [[[[-121.88809, 37.23293], [-121.88443, 37.23292], [-121.88436, 37.2328], [-121.88432, 37.23268], [-121.88428, 37.23249], [-121.88427, 37.23234], [-121.88429, 37.23231], [-121.88433, 37.2323], [-121.88805, 37.23232], [-121.88808, 37.23234], [-121.8881, 37.23237], [-121.88809, 37.23293]]], [[[-121.8943, 37.23234], [-121.89418, 37.23251], [-121.89397, 37.23297], [-121.89231, 37.23296], [-121.89231, 37.2329], [-121.89229, 37.23286], [-121.89224, 37.23284], [-121.89219, 37.23282], [-121.89201, 37.23288], [-121.89035, 37.23287], [-121.89019, 37.23282], [-121.8901, 37.23284], [-121.89006, 37.2329], [-121.89007, 37.23301], [-121.89006, 37.23351], [-121.89005, 37.23355], [-121.89, 37.23358], [-121.88853, 37.23362], [-121.88844, 37.23359], [-121.88836, 37.23354], [-121.88832, 37.2335], [-121.88829, 37.23342], [-121.88831, 37.2323], [-121.89136, 37.23232], [-121.89157, 37.23209], [-121.89176, 37.23215], [-121.89197, 37.23217], [-121.89217, 37.23213], [-121.89241, 37.23201], [-121.89241, 37.23233], [-121.8943, 37.23234]]]]} | Open Access 1 | 1383 | T.J. Martin | 26157 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 17.459 | T.J. Martin | 1984 | None 46 | ||
578 | 578 | 577 | {"type": "Polygon", "coordinates": [[[-121.898, 37.28754], [-121.89626, 37.28829], [-121.89597, 37.28788], [-121.89477, 37.2884], [-121.89439, 37.28785], [-121.89402, 37.288], [-121.89388, 37.28779], [-121.89389, 37.28775], [-121.89394, 37.28772], [-121.89732, 37.28649], [-121.89751, 37.28681], [-121.898, 37.28754]]]} | Open Access 1 | 1926 | Wallenburg Park | 27220 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.119 | Wallenburg Park | 1961 | Local Park 2 | 4 | |
588 | 588 | 587 | {"type": "Polygon", "coordinates": [[[-121.8244, 37.32448], [-121.82588, 37.32597], [-121.82589, 37.32601], [-121.82586, 37.32606], [-121.82416, 37.3272], [-121.82262, 37.32574], [-121.82324, 37.32527], [-121.8244, 37.32448]]]} | Open Access 1 | 1999 | Welch | 27336 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 11.064 | Welch | 1995 | None 59 | ||
606 | 606 | 605 | {"type": "Polygon", "coordinates": [[[-121.86951, 37.33581], [-121.86875, 37.33619], [-121.86867, 37.33624], [-121.86862, 37.3363], [-121.86823, 37.33704], [-121.8674, 37.33676], [-121.86703, 37.33577], [-121.86697, 37.33548], [-121.86694, 37.33478], [-121.86711, 37.33392], [-121.86791, 37.33383], [-121.86822, 37.33441], [-121.8684, 37.33465], [-121.86852, 37.33479], [-121.86892, 37.33513], [-121.86918, 37.33538], [-121.86951, 37.33581]]]} | Open Access 1 | 2110 | William Street Park | 27559 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 11.685 | William Street Park | 0 | Local Park 2 | 4 | |
612 | 612 | 611 | {"type": "Polygon", "coordinates": [[[-121.82499, 37.30827], [-121.82371, 37.30909], [-121.82343, 37.3088], [-121.82334, 37.30882], [-121.82205, 37.30749], [-121.82291, 37.30696], [-121.82374, 37.30779], [-121.82412, 37.30778], [-121.82438, 37.30764], [-121.82443, 37.30767], [-121.82455, 37.30771], [-121.82492, 37.3081], [-121.82494, 37.30814], [-121.82491, 37.30819], [-121.82499, 37.30827]]]} | Open Access 1 | 2196 | Windmill Springs Park | 27629 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.859 | Windmill Springs Park | 1983 | Local Park 2 | 4 | |
620 | 620 | 619 | {"type": "Polygon", "coordinates": [[[-121.90776, 37.25402], [-121.90738, 37.25423], [-121.90704, 37.25406], [-121.90677, 37.2541], [-121.90671, 37.25396], [-121.90666, 37.2539], [-121.90622, 37.2536], [-121.90607, 37.25347], [-121.90602, 37.25341], [-121.90597, 37.25326], [-121.906, 37.2529], [-121.90599, 37.25284], [-121.90585, 37.25248], [-121.90672, 37.25225], [-121.90776, 37.25402]]]} | Open Access 1 | 2365 | Branham Park | 16332 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.919 | Branham Park | 1973 | Local Park 2 | 4 | |
665 | 665 | 664 | {"type": "Polygon", "coordinates": [[[-121.91687, 37.25892], [-121.91694, 37.25895], [-121.9176, 37.25989], [-121.9176, 37.25993], [-121.91518, 37.26101], [-121.91514, 37.26101], [-121.91509, 37.26099], [-121.91444, 37.26006], [-121.91444, 37.26002], [-121.91445, 37.25999], [-121.91687, 37.25892]]]} | Open Access 1 | 5056 | Butcher | 16545 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.116 | Butcher | 1981 | None 63 | ||
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.77 | Calabazas | 1978 | None 69 | ||
870 | 870 | 869 | {"type": "Polygon", "coordinates": [[[-121.81872, 37.23996], [-121.81869, 37.24127], [-121.8181, 37.24107], [-121.81777, 37.241], [-121.81742, 37.24099], [-121.81736, 37.24095], [-121.81724, 37.24045], [-121.81706, 37.23993], [-121.81872, 37.23996]]]} | Open Access 1 | 5610 | Calero Park | 16680 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.064 | Calero Park | 1980 | Local Park 2 | 4 | |
1009 | 1009 | 1008 | {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} | Open Access 1 | 5500 | Cahalan | 16655 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.757 | Cahalan | 1978 | None 91 | ||
1043 | 1043 | 1042 | {"type": "Polygon", "coordinates": [[[-121.86197, 37.28707], [-121.86132, 37.28748], [-121.86081, 37.28697], [-121.86146, 37.28657], [-121.86197, 37.28707]]]} | Open Access 1 | 38008 | Vieira Park | 27092 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.298 | Vieira Park | 0 | Local Park 2 | 4 | |
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123]]]} | Open Access 1 | 8894 | Classico Park | 17392 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.476 | Classico Park | 2004 | Local Park 2 | 4 | |
1232 | 1232 | 1231 | {"type": "MultiPolygon", "coordinates": [[[[-121.76247, 37.30719], [-121.76237, 37.30725], [-121.76225, 37.30735], [-121.76221, 37.30737], [-121.76214, 37.30736], [-121.76213, 37.30711], [-121.76208, 37.30692], [-121.76217, 37.30689], [-121.76213, 37.30674], [-121.76204, 37.30675], [-121.76196, 37.30638], [-121.76204, 37.30636], [-121.762, 37.3062], [-121.76192, 37.30621], [-121.76183, 37.30585], [-121.76192, 37.30582], [-121.76188, 37.30567], [-121.76179, 37.30568], [-121.76168, 37.30523], [-121.76197, 37.3051], [-121.76208, 37.30559], [-121.76204, 37.30563], [-121.76203, 37.30569], [-121.76206, 37.30574], [-121.76214, 37.30577], [-121.76228, 37.30637], [-121.76224, 37.30642], [-121.76223, 37.30647], [-121.76227, 37.30652], [-121.76231, 37.30655], [-121.76247, 37.30719]]], [[[-121.76232, 37.30871], [-121.76223, 37.30854], [-121.76217, 37.30835], [-121.76199, 37.30829], [-121.76201, 37.30822], [-121.76201, 37.30816], [-121.76199, 37.30809], [-121.76194, 37.30803], [-121.76208, 37.30793], [-121.76204, 37.30773], [-121.76208, 37.3075], [-121.76212, 37.30756], [-121.76209, 37.30773], [-121.76209, 37.30788], [-121.76222, 37.30838], [-121.76227, 37.30851], [-121.76236, 37.30865], [-121.76236, 37.30869], [-121.76232, 37.30871]]], [[[-121.76263, 37.3073], [-121.76256, 37.30759], [-121.76243, 37.30762], [-121.7625, 37.30796], [-121.76237, 37.30797], [-121.76232, 37.30794], [-121.76229, 37.30783], [-121.76229, 37.30773], [-121.76232, 37.30763], [-121.76236, 37.30753], [-121.76243, 37.30744], [-121.76252, 37.30736], [-121.76263, 37.3073]]], [[[-121.76283, 37.30873], [-121.76266, 37.30866], [-121.7625, 37.3085], [-121.76244, 37.30841], [-121.76241, 37.30832], [-121.76241, 37.30828], [-121.76243, 37.30824], [-121.76246, 37.30822], [-121.76255, 37.3082], [-121.76263, 37.30853], [-121.76278, 37.30852], [-121.76283, 37.30873]]], [[[-121.76371, 37.31256], [-121.76358, 37.31258], [-121.76361, 37.3127], [-121.76353, 37.31271], [-121.76263, 37.30883], [-121.76275, 37.30888], [-121.76289, 37.30892], [-121.76314, 37.30895], [-121.76314, 37.30904], [-121.76312, 37.30915], [-121.76296, 37.30932], [-121.76302, 37.30961], [-121.76299, 37.30965], [-121.76298, 37.3097], [-121.76301, 37.30974], [-121.76306, 37.30977], [-121.76319, 37.31034], [-121.76316, 37.31038], [-121.76316, 37.31043], [-121.76318, 37.31047], [-121.76323, 37.3105], [-121.76336, 37.31106], [-121.76333, 37.3111], [-121.76333, 37.31116], [-121.76336, 37.3112], [-121.7634, 37.31123], [-121.76353, 37.3118], [-121.7635, 37.31184], [-121.76349, 37.31188], [-121.76352, 37.31193], [-121.76357, 37.31196], [-121.76371, 37.31256]]]]} | Open Access 1 | 8918 | Falls Creek Linear Park | 18837 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.266 | Falls Creek Linear Park | 2004 | Local Park 2 | 4 | |
1234 | 1234 | 1233 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76446, 37.31478], [-121.7643, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | 8930 | Fowler Creek Community Park | 19029 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 12.449 | Fowler Creek Community Park | 2004 | 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]);