units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
77 rows where ACCESS_TYP = 1 and MNG_AGENCY = 253 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 51
- Local Recreation Area 5
- None 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Hayward Area Recreation and Park District · 57 ✖
ACCESS_TYP 1
- Open Access · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6738 | 6738 | 6737 | {"type": "Polygon", "coordinates": [[[-122.12342, 37.66871], [-122.12086, 37.66972], [-122.11967, 37.66783], [-122.12192, 37.66679], [-122.12342, 37.66871]]]} | Open Access 1 | 5071 | Kennedy Park | 20602 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.44 | Kennedy Park | 1949 | Local Park 2 | 4 | |
6743 | 6743 | 6742 | {"type": "Polygon", "coordinates": [[[-122.06367, 37.67916], [-122.06302, 37.67937], [-122.06319, 37.67989], [-122.06191, 37.6806], [-122.06121, 37.68082], [-122.06083, 37.68007], [-122.06126, 37.67992], [-122.06086, 37.67911], [-122.0635, 37.67828], [-122.06367, 37.67916]]]} | Open Access 1 | 5083 | San Felipe Park | 24884 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.766 | San Felipe Park | 1965 | Local Park 2 | 4 | |
7604 | 7604 | 7603 | {"type": "MultiPolygon", "coordinates": [[[[-122.09848, 37.6662], [-122.09842, 37.66627], [-122.09778, 37.66645], [-122.09657, 37.66695], [-122.09658, 37.66685], [-122.09655, 37.66675], [-122.09646, 37.66666], [-122.09633, 37.66659], [-122.09627, 37.66653], [-122.09624, 37.66646], [-122.09624, 37.66631], [-122.09623, 37.66623], [-122.09615, 37.66613], [-122.09604, 37.66606], [-122.0961, 37.66601], [-122.09614, 37.66592], [-122.09613, 37.66585], [-122.09609, 37.66577], [-122.09603, 37.66572], [-122.09593, 37.66568], [-122.09583, 37.66567], [-122.09573, 37.6657], [-122.09569, 37.66564], [-122.09552, 37.66571], [-122.09542, 37.66556], [-122.09598, 37.66533], [-122.09605, 37.66536], [-122.09734, 37.66483], [-122.09751, 37.6647], [-122.09754, 37.6647], [-122.09759, 37.66472], [-122.09774, 37.66485], [-122.09775, 37.66489], [-122.09774, 37.66493], [-122.09781, 37.66499], [-122.09787, 37.66498], [-122.09791, 37.665], [-122.09798, 37.66507], [-122.09796, 37.66513], [-122.09803, 37.66519], [-122.09809, 37.66518], [-122.09813, 37.6652], [-122.09832, 37.66536], [-122.09841, 37.66548], [-122.09846, 37.6656], [-122.09848, 37.66577], [-122.09848, 37.6662]]], [[[-122.09979, 37.66635], [-122.09965, 37.66634], [-122.09921, 37.66653], [-122.09921, 37.66654], [-122.09962, 37.6669], [-122.09929, 37.66705], [-122.09921, 37.66703], [-122.09892, 37.66677], [-122.09883, 37.66665], [-122.09877, 37.66653], [-122.09875, 37.66646], [-122.09873, 37.66624], [-122.09873, 37.66586], [-122.09872, 37.66572], [-122.09864, 37.66552], [-122.09851, 37.66533], [-122.09853, 37.66528], [-122.09855, 37.66527], [-122.09979, 37.66635]]]]} | Open Access 1 | 7317 | Cannery Park | 16803 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 11.102 | Cannery Park | 0 | Local Park 2 | 4 | |
7808 | 7808 | 7807 | {"type": "Polygon", "coordinates": [[[-122.0655, 37.67733], [-122.06488, 37.67742], [-122.06498, 37.67783], [-122.06458, 37.67789], [-122.06446, 37.67744], [-122.06407, 37.6775], [-122.06404, 37.67737], [-122.06336, 37.67748], [-122.06331, 37.67739], [-122.0627, 37.67759], [-122.06249, 37.67715], [-122.06307, 37.67685], [-122.06254, 37.67654], [-122.06226, 37.67652], [-122.06223, 37.67661], [-122.06162, 37.67652], [-122.06173, 37.67596], [-122.06198, 37.67596], [-122.06258, 37.67576], [-122.06269, 37.67574], [-122.06267, 37.67587], [-122.06301, 37.67588], [-122.06307, 37.6756], [-122.0631, 37.6756], [-122.06306, 37.67588], [-122.0634, 37.67589], [-122.06339, 37.67602], [-122.06462, 37.6759], [-122.06448, 37.67664], [-122.06455, 37.67667], [-122.06479, 37.67682], [-122.06493, 37.67683], [-122.06502, 37.67689], [-122.06518, 37.6769], [-122.06539, 37.67687], [-122.0655, 37.67733]]]} | Open Access 1 | 47701 | Sulphur Creek Nature Center | 31437 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.148 | Sulphur Creek Nature Ctr. | 0 | Local Park 2 | 4 | |
7823 | 7823 | 7822 | {"type": "Polygon", "coordinates": [[[-122.10017, 37.70619], [-122.09895, 37.70702], [-122.09936, 37.70782], [-122.09996, 37.70839], [-122.09962, 37.70842], [-122.0991, 37.70793], [-122.09862, 37.70791], [-122.09776, 37.70819], [-122.09758, 37.70803], [-122.09663, 37.70834], [-122.09654, 37.70826], [-122.09747, 37.70794], [-122.09748, 37.7079], [-122.09732, 37.70767], [-122.09679, 37.70718], [-122.09576, 37.70752], [-122.09571, 37.70748], [-122.09674, 37.70713], [-122.09579, 37.70625], [-122.09476, 37.70659], [-122.09461, 37.70645], [-122.09579, 37.70606], [-122.09484, 37.70517], [-122.09579, 37.70486], [-122.09591, 37.70496], [-122.09601, 37.70489], [-122.09606, 37.70451], [-122.09619, 37.7045], [-122.0963, 37.70448], [-122.09641, 37.70443], [-122.09652, 37.70436], [-122.09684, 37.70466], [-122.09724, 37.70491], [-122.09757, 37.70522], [-122.09777, 37.7051], [-122.09866, 37.70591], [-122.09903, 37.70567], [-122.09925, 37.70555], [-122.09963, 37.70589], [-122.09971, 37.70584], [-122.10017, 37.70619]]]} | Open Access 1 | 47707 | Valley View Park | 31456 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/605/Valley-View-Park---Former-EBMUD-Property | Alameda 17 | 24.129 | Valley View Park | 0 | Local Park 2 | 4 |
7835 | 7835 | 7834 | {"type": "Polygon", "coordinates": [[[-122.05746, 37.62338], [-122.05725, 37.62354], [-122.05718, 37.62354], [-122.05709, 37.62357], [-122.05704, 37.62365], [-122.0566, 37.62401], [-122.05605, 37.62357], [-122.0562, 37.62344], [-122.0556, 37.62297], [-122.05627, 37.62243], [-122.05718, 37.62315], [-122.05716, 37.62319], [-122.05736, 37.62334], [-122.05739, 37.62332], [-122.05746, 37.62338]]]} | Open Access 1 | 47703 | Silver Star Veterans Park | 31448 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.309 | Silver Star Veterans Park | 0 | Local Park 2 | 4 | |
7836 | 7836 | 7835 | {"type": "Polygon", "coordinates": [[[-122.07255, 37.69448], [-122.07245, 37.69479], [-122.07246, 37.69486], [-122.07249, 37.69495], [-122.07248, 37.69502], [-122.07212, 37.6949], [-122.07228, 37.69459], [-122.07203, 37.6945], [-122.07231, 37.69398], [-122.0723, 37.69395], [-122.07227, 37.69395], [-122.07224, 37.69382], [-122.07182, 37.69362], [-122.07168, 37.69362], [-122.07161, 37.69348], [-122.0716, 37.69294], [-122.07155, 37.69271], [-122.0719, 37.6927], [-122.0719, 37.69293], [-122.07177, 37.69294], [-122.07182, 37.69357], [-122.07188, 37.69362], [-122.07198, 37.69362], [-122.07226, 37.69375], [-122.07231, 37.69386], [-122.0724, 37.69394], [-122.07245, 37.69423], [-122.07255, 37.69448]]]} | Open Access 1 | 47704 | Castro Valley Creek Park | 31450 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.308 | Castro Valley Creek Park | 0 | Local Park 2 | 4 | |
7837 | 7837 | 7836 | {"type": "Polygon", "coordinates": [[[-122.03138, 37.67539], [-122.03177, 37.67601], [-122.03184, 37.67616], [-122.03207, 37.67648], [-122.03214, 37.67663], [-122.03216, 37.67677], [-122.0321, 37.67712], [-122.0312, 37.67848], [-122.03059, 37.67809], [-122.03035, 37.67797], [-122.03, 37.67773], [-122.02986, 37.67762], [-122.02967, 37.67737], [-122.02951, 37.67703], [-122.02949, 37.67667], [-122.02955, 37.6764], [-122.02964, 37.67619], [-122.02975, 37.676], [-122.03016, 37.67566], [-122.03045, 37.67553], [-122.03072, 37.67544], [-122.03097, 37.6754], [-122.03138, 37.67539]]]} | Open Access 1 | 47705 | Five Canyons Park | 31454 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Five-Canyons-Park-127 | Alameda 17 | 13.452 | Five Canyons Park | 0 | Local Park 2 | 4 |
7838 | 7838 | 7837 | {"type": "Polygon", "coordinates": [[[-122.11632, 37.69538], [-122.11631, 37.69594], [-122.11596, 37.69624], [-122.11544, 37.69587], [-122.11561, 37.69571], [-122.1157, 37.69577], [-122.11618, 37.69535], [-122.11623, 37.69538], [-122.11632, 37.69538]]]} | Open Access 1 | 47706 | Jack Holland Sr. Park | 31455 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Jack-Holland-Sr-Park-129 | Alameda 17 | 1.0 | Jack Holland Sr. Park | 0 | Local Park 2 | 4 |
7966 | 7966 | 7965 | {"type": "Polygon", "coordinates": [[[-122.06106, 37.63806], [-122.06102, 37.63812], [-122.06103, 37.63819], [-122.06072, 37.63834], [-122.06026, 37.63776], [-122.06057, 37.6376], [-122.06066, 37.63766], [-122.06077, 37.63765], [-122.06106, 37.63806]]]} | Open Access 1 | 15619 | Bechtel Mini Park | 15943 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.774 | Bechtel MP | 0 | Local Park 2 | 4 | |
7967 | 7967 | 7966 | {"type": "Polygon", "coordinates": [[[-122.10386, 37.66497], [-122.10343, 37.66497], [-122.10343, 37.66475], [-122.10385, 37.66475], [-122.10386, 37.66497]]]} | Open Access 1 | 15632 | La Placita Mini Park | 20788 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.229 | La Placita MP | 0 | Local Park 2 | 4 | |
8967 | 8967 | 8966 | {"type": "Polygon", "coordinates": [[[-122.08803, 37.62809], [-122.08797, 37.62953], [-122.08792, 37.62957], [-122.08779, 37.62954], [-122.08761, 37.62946], [-122.08716, 37.62916], [-122.0867, 37.62889], [-122.0861, 37.62865], [-122.0856, 37.62851], [-122.08557, 37.62847], [-122.08561, 37.62834], [-122.08803, 37.62809]]]} | Open Access 1 | 14794 | Palma Ceia Park | 23349 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.554 | Palma Ceia Park | 0 | Local Park 2 | 4 | |
8969 | 8969 | 8968 | {"type": "Polygon", "coordinates": [[[-122.08654, 37.6351], [-122.08475, 37.63514], [-122.08474, 37.63455], [-122.08469, 37.63432], [-122.08496, 37.63427], [-122.08515, 37.63417], [-122.08532, 37.63415], [-122.08538, 37.63412], [-122.0854, 37.63406], [-122.08573, 37.63402], [-122.08623, 37.63466], [-122.08654, 37.6351]]]} | Open Access 1 | 14797 | Eldridge Park | 18554 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.445 | Eldridge Park | 0 | Local Park 2 | 4 | |
8970 | 8970 | 8969 | {"type": "Polygon", "coordinates": [[[-122.06748, 37.63151], [-122.06477, 37.63297], [-122.06456, 37.63267], [-122.06425, 37.63239], [-122.06369, 37.63203], [-122.06369, 37.63199], [-122.064, 37.63169], [-122.06417, 37.63162], [-122.06715, 37.63077], [-122.06748, 37.63151]]]} | Open Access 1 | 14800 | Tennyson Park | 26245 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.408 | Tennyson Park | 0 | Local Park 2 | 4 | |
8972 | 8972 | 8971 | {"type": "Polygon", "coordinates": [[[-122.08382, 37.67039], [-122.083, 37.67089], [-122.0822, 37.67], [-122.08301, 37.66953], [-122.08382, 37.67039]]]} | Open Access 1 | 14834 | Library Park | 21224 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.683 | Library Park | 0 | Local Park 2 | 4 | |
8973 | 8973 | 8972 | {"type": "Polygon", "coordinates": [[[-122.07395, 37.64394], [-122.07177, 37.64429], [-122.07183, 37.64455], [-122.07079, 37.64457], [-122.07077, 37.64395], [-122.0707, 37.64384], [-122.0703, 37.64384], [-122.07028, 37.6426], [-122.07241, 37.64248], [-122.07395, 37.64394]]]} | Open Access 1 | 14803 | Sorensdale Park | 25624 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.217 | Sorensdale Park | 0 | Local Park 2 | 4 | |
8976 | 8976 | 8975 | {"type": "Polygon", "coordinates": [[[-122.04463, 37.6307], [-122.04385, 37.63103], [-122.04302, 37.63043], [-122.04412, 37.62993], [-122.04463, 37.6307]]]} | Open Access 1 | 14808 | Stonybrook Park | 25900 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.245 | Stonybrook Park | 0 | Local Park 2 | 4 | |
8978 | 8978 | 8977 | {"type": "Polygon", "coordinates": [[[-122.04506, 37.65547], [-122.04503, 37.65551], [-122.04411, 37.65578], [-122.04333, 37.65598], [-122.04326, 37.65535], [-122.04328, 37.65535], [-122.04327, 37.65533], [-122.04349, 37.65521], [-122.04358, 37.65514], [-122.04367, 37.65502], [-122.04374, 37.65486], [-122.04377, 37.65484], [-122.044, 37.65483], [-122.04414, 37.65481], [-122.04427, 37.65477], [-122.0445, 37.65467], [-122.04456, 37.65475], [-122.04463, 37.65514], [-122.04497, 37.65514], [-122.04499, 37.65533], [-122.04506, 37.65547]]]} | Open Access 1 | 14819 | College Heights Park | 17504 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.291 | College Heights Park | 0 | Local Park 2 | 4 | |
8980 | 8980 | 8979 | {"type": "Polygon", "coordinates": [[[-122.04961, 37.66126], [-122.04912, 37.66152], [-122.04848, 37.66153], [-122.04851, 37.66049], [-122.04931, 37.66038], [-122.04961, 37.66126]]]} | Open Access 1 | 14822 | Old Highlands Park | 23086 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.498 | Old Highlands Park | 0 | Local Park 2 | 4 | |
8981 | 8981 | 8980 | {"type": "Polygon", "coordinates": [[[-122.07821, 37.66585], [-122.07598, 37.66704], [-122.07552, 37.6665], [-122.07478, 37.66669], [-122.07467, 37.66655], [-122.07456, 37.66664], [-122.07423, 37.6668], [-122.07324, 37.66702], [-122.07297, 37.66724], [-122.07264, 37.66742], [-122.0717, 37.66742], [-122.07084, 37.66729], [-122.07057, 37.66714], [-122.07018, 37.66682], [-122.06975, 37.66721], [-122.06905, 37.66739], [-122.0688, 37.66757], [-122.06862, 37.66721], [-122.06814, 37.66732], [-122.06781, 37.66705], [-122.06729, 37.66701], [-122.06656, 37.66653], [-122.0659, 37.66675], [-122.06533, 37.66616], [-122.06483, 37.66625], [-122.06417, 37.66601], [-122.06394, 37.66589], [-122.0633, 37.66532], [-122.06317, 37.66527], [-122.06277, 37.66676], [-122.06177, 37.66641], [-122.06171, 37.66696], [-122.06142, 37.66692], [-122.06132, 37.66731], [-122.06117, 37.66728], [-122.06117, 37.66724], [-122.06031, 37.66709], [-122.0603, 37.66684], [-122.06025, 37.6667], [-122.06013, 37.66655], [-122.05996, 37.66644], [-122.05903, 37.6662], [-122.05869, 37.66614], [-122.05827, 37.6661], [-122.06242, 37.66396], [-122.0625, 37.66365], [-122.06254, 37.66365], [-122.06249, 37.66387], [-122.0631, 37.66427], [-122.06467, 37.66516], [-122.0651, 37.66556], [-122.06586, 37.66569], [-122.06636, 37.66583], [-122.06716, 37.66639], [-122.06799, 37.66656], [-122.06844, 37.66657], [-122.06918, 37.6667], [-122.0703, 37.6663], [-122.07089, 37.66705], [-122.07174, 37.66711], [-122.07231, 37.66708], [-122.07266, 37.66714], [-122.07333, 37.66685], [-122.07388, 37.66639], [-122.07487, 37.66592], [-122.07627, 37.6649], [-122.0763, 37.66492], [-122.07708, 37.66452], [-122.07821, 37.66585]]]} | Open Access 1 | 14825 | Hayward Memorial Park | 19759 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 48.356 | Hayward Memorial Park | 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]);