units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
74 rows where DES_TP = 2 and MNG_AGENCY = 253 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Hayward Area Recreation and Park District · 74 ✖
DES_TP 1
- Local Park · 74 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9863 | 9863 | 9862 | {"type": "MultiPolygon", "coordinates": [[[[-122.15302, 37.6263], [-122.15283, 37.62659], [-122.1515, 37.6266], [-122.14838, 37.62665], [-122.14826, 37.62667], [-122.14763, 37.62687], [-122.14728, 37.62691], [-122.14546, 37.62688], [-122.14478, 37.62685], [-122.14441, 37.62681], [-122.144, 37.6268], [-122.14248, 37.62687], [-122.14139, 37.62687], [-122.14047, 37.62683], [-122.14027, 37.6268], [-122.13998, 37.62671], [-122.13982, 37.62673], [-122.13956, 37.62689], [-122.13937, 37.62323], [-122.13707, 37.62323], [-122.13704, 37.6234], [-122.13625, 37.62359], [-122.13581, 37.62359], [-122.13521, 37.62378], [-122.13519, 37.62365], [-122.13545, 37.623], [-122.13965, 37.6221], [-122.14706, 37.62481], [-122.14837, 37.62508], [-122.14973, 37.62515], [-122.1508, 37.62499], [-122.15138, 37.62484], [-122.15259, 37.62462], [-122.15302, 37.6263]]], [[[-122.14879, 37.65606], [-122.14479, 37.65609], [-122.14396, 37.65627], [-122.14392, 37.65609], [-122.14392, 37.65591], [-122.14433, 37.64981], [-122.14879, 37.65606]]], [[[-122.16185, 37.6312], [-122.16174, 37.64456], [-122.16171, 37.65587], [-122.16161, 37.65596], [-122.15072, 37.65604], [-122.15069, 37.65593], [-122.15098, 37.65355], [-122.14947, 37.65148], [-122.15252, 37.65117], [-122.15483, 37.65108], [-122.15483, 37.65097], [-122.15538, 37.65153], [-122.15604, 37.65308], [-122.15606, 37.65308], [-122.15555, 37.65077], [-122.15547, 37.65072], [-122.15521, 37.64933], [-122.15539, 37.64918], [-122.15538, 37.64917], [-122.15521, 37.64913], [-122.15538, 37.64891], [-122.15541, 37.64883], [-122.15518, 37.64882], [-122.15504, 37.64871], [-122.15489, 37.64814], [-122.15466, 37.64699], [-122.15488, 37.6468], [-122.15488, 37.64676], [-122.15469, 37.64672], [-122.1544, 37.64599], [-122.15437, 37.64555], [-122.15426, 37.64537], [-122.15389, 37.64384], [-122.1538, 37.64376], [-122.15348, 37.6423], [-122.15368, 37.64213], [-122.15367, 37.64208], [-122.15349, 37.64195], [-122.15351, 37.64192], [-122.15381, 37.64187], [-122.1539, 37.64184], [-122.15408, 37.64173], [-122.15408, 37.64167], [-122.15511, 37.64162], [-122.15521, 37.63118], [-122.16185, 37.6312]]]]} | Open Access 1 | 16897 | Hayward Shoreline | 4363 | 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 | 595.87 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
5221 | 5221 | 5220 | {"type": "Polygon", "coordinates": [[[-121.98774, 37.69927], [-121.987, 37.69915], [-121.98436, 37.69881], [-121.98245, 37.69859], [-121.98161, 37.69845], [-121.98091, 37.69828], [-121.98042, 37.69813], [-121.97989, 37.69799], [-121.97915, 37.69786], [-121.97787, 37.69781], [-121.97662, 37.69763], [-121.97536, 37.69737], [-121.97291, 37.69698], [-121.97296, 37.6967], [-121.97308, 37.69667], [-121.97325, 37.69658], [-121.97334, 37.69638], [-121.97349, 37.69634], [-121.97353, 37.69606], [-121.97363, 37.69594], [-121.97374, 37.69576], [-121.97373, 37.69571], [-121.97376, 37.69562], [-121.97371, 37.69553], [-121.97377, 37.69509], [-121.97355, 37.69429], [-121.97839, 37.69432], [-121.97841, 37.69486], [-121.98072, 37.69488], [-121.98068, 37.69509], [-121.98129, 37.6962], [-121.98162, 37.69661], [-121.98198, 37.697], [-121.98199, 37.69713], [-121.98773, 37.69755], [-121.98774, 37.69927]]]} | Open Access 1 | 289 | Rowell Ranch Rodeo Park | 24705 | 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 | 83.074 | Rowell Ranch Rodeo Park | 0 | Local Park 2 | 4 | |
9365 | 9365 | 9364 | {"type": "Polygon", "coordinates": [[[-122.01903, 37.65238], [-122.0182, 37.65246], [-122.01762, 37.65137], [-122.0177, 37.65132], [-122.01782, 37.65088], [-122.01797, 37.65081], [-122.01824, 37.65078], [-122.01828, 37.65093], [-122.01836, 37.65112], [-122.01892, 37.65202], [-122.01899, 37.65217], [-122.01903, 37.65238]]]} | Open Access 1 | 15642 | Jalquin Vista Park | 20339 | 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.154 | Jalquin Vista Park | 0 | Local Park 2 | 4 | |
12100 | 12100 | 12099 | {"type": "Polygon", "coordinates": [[[-122.02692, 37.71714], [-122.02691, 37.71717], [-122.02654, 37.71755], [-122.02638, 37.71747], [-122.02451, 37.71785], [-122.02432, 37.71778], [-122.02444, 37.71756], [-122.02439, 37.71745], [-122.02463, 37.71737], [-122.02484, 37.71728], [-122.02503, 37.71717], [-122.02482, 37.71695], [-122.02504, 37.7168], [-122.02517, 37.71668], [-122.02554, 37.7163], [-122.0258, 37.71608], [-122.02603, 37.71595], [-122.02615, 37.71591], [-122.02674, 37.71691], [-122.02692, 37.71714]]]} | Open Access 1 | 24934 | Palomares Hills Park | 23366 | 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 | 6.072 | Palomares Hills Park | 0 | Local Park 2 | 4 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} | Open Access 1 | 47699 | J.A. Lewis Park | 31435 | 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.57 | J.A. Lewis Park | 0 | Local Park 2 | 4 | |
9355 | 9355 | 9354 | {"type": "Polygon", "coordinates": [[[-122.02752, 37.6138], [-122.02891, 37.61502], [-122.02891, 37.61505], [-122.02889, 37.61508], [-122.02832, 37.61549], [-122.02815, 37.61565], [-122.02808, 37.61564], [-122.02768, 37.6154], [-122.0275, 37.61532], [-122.02734, 37.61528], [-122.02669, 37.61518], [-122.0265, 37.6151], [-122.02633, 37.61497], [-122.02598, 37.61449], [-122.02752, 37.6138]]]} | Restricted Access 2 | 15628 | El Rancho Verde School Park | 31953 | 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 | 6.904 | El Rancho Verde School 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 |
1912 | 1912 | 1911 | {"type": "Polygon", "coordinates": [[[-122.03644, 37.65092], [-122.03581, 37.65096], [-122.03481, 37.65153], [-122.03382, 37.65111], [-122.03393, 37.65094], [-122.03406, 37.65079], [-122.03463, 37.65028], [-122.03484, 37.65003], [-122.03481, 37.65], [-122.03496, 37.64975], [-122.035, 37.64973], [-122.03514, 37.64979], [-122.03553, 37.65008], [-122.03596, 37.65036], [-122.03605, 37.65047], [-122.03598, 37.65054], [-122.03644, 37.65092]]]} | Open Access 1 | 14813 | Canyon View Park | 16828 | 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 | 5.42 | Canyon View Park | 0 | Local Park 2 | 4 | |
1916 | 1916 | 1915 | {"type": "Polygon", "coordinates": [[[-122.03982, 37.62532], [-122.03904, 37.62569], [-122.03862, 37.62582], [-122.03843, 37.62596], [-122.03811, 37.62529], [-122.03914, 37.62488], [-122.03936, 37.62482], [-122.03964, 37.62485], [-122.03982, 37.62532]]]} | Open Access 1 | 14853 | Fairway Greens Park | 18823 | 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.548 | Fairway Greens Park | 0 | Local Park 2 | 4 | |
8995 | 8995 | 8994 | {"type": "Polygon", "coordinates": [[[-122.04353, 37.6184], [-122.04178, 37.61966], [-122.04028, 37.61836], [-122.04197, 37.61708], [-122.04353, 37.6184]]]} | Open Access 1 | 14855 | Bidwell Park | 16069 | 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.154 | Bidwell 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 | |
6735 | 6735 | 6734 | {"type": "Polygon", "coordinates": [[[-122.0458, 37.66526], [-122.04582, 37.66577], [-122.04507, 37.66859], [-122.04475, 37.66865], [-122.04361, 37.66881], [-122.0429, 37.66542], [-122.0458, 37.66526]]]} | Open Access 1 | 5067 | East Avenue Park | 18360 | 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 | 18.312 | East Avenue Park | 1961 | Local Park 2 | 4 | |
9822 | 9822 | 9821 | {"type": "Polygon", "coordinates": [[[-122.04626, 37.71955], [-122.0462, 37.72191], [-122.0393, 37.71982], [-122.03924, 37.71959], [-122.03905, 37.71948], [-122.03897, 37.71939], [-122.03888, 37.71914], [-122.0387, 37.71893], [-122.03828, 37.71899], [-122.03802, 37.71831], [-122.038, 37.71809], [-122.03802, 37.71793], [-122.03811, 37.71769], [-122.03832, 37.71738], [-122.0384, 37.7174], [-122.0385, 37.71725], [-122.0389, 37.71735], [-122.03988, 37.71744], [-122.04163, 37.71802], [-122.04248, 37.71844], [-122.04626, 37.71955]]]} | Open Access 1 | 16780 | Greenridge Park | 19483 | 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 | 45.887 | Greenridge Park | 0 | Local Park 2 | 4 | |
9359 | 9359 | 9358 | {"type": "Polygon", "coordinates": [[[-122.04919, 37.62473], [-122.0482, 37.62471], [-122.04819, 37.62468], [-122.04791, 37.62468], [-122.04788, 37.62445], [-122.0478, 37.62426], [-122.04767, 37.62406], [-122.04748, 37.62389], [-122.04746, 37.62381], [-122.04768, 37.62358], [-122.04775, 37.62353], [-122.04789, 37.62346], [-122.04801, 37.62343], [-122.04807, 37.62336], [-122.04842, 37.62324], [-122.04874, 37.62365], [-122.04836, 37.62365], [-122.04835, 37.62367], [-122.04919, 37.62473]]]} | Open Access 1 | 15635 | Twin Bridges Park | 26610 | 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.296 | Twin Bridges 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 | |
9357 | 9357 | 9356 | {"type": "Polygon", "coordinates": [[[-122.05144, 37.68537], [-122.05131, 37.68541], [-122.05103, 37.68483], [-122.05054, 37.68497], [-122.05009, 37.68402], [-122.04984, 37.68345], [-122.04983, 37.68337], [-122.04959, 37.68288], [-122.05066, 37.68269], [-122.05091, 37.68321], [-122.05088, 37.68323], [-122.05132, 37.6842], [-122.05094, 37.68432], [-122.05144, 37.68537]]]} | Open Access 1 | 15633 | Lakeridge Park | 20970 | 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 | 5.378 | Lakeridge Park | 0 | Local Park 2 | 4 | |
1914 | 1914 | 1913 | {"type": "Polygon", "coordinates": [[[-122.05238, 37.63238], [-122.05203, 37.63263], [-122.05126, 37.63194], [-122.05159, 37.63169], [-122.05238, 37.63238]]]} | Open Access 1 | 14805 | Valle Vista Park | 26774 | 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.045 | Valle Vista Park | 0 | Local Park 2 | 4 | |
9131 | 9131 | 9130 | {"type": "Polygon", "coordinates": [[[-122.05436, 37.68017], [-122.05423, 37.68062], [-122.05412, 37.68067], [-122.05414, 37.68057], [-122.0539, 37.68045], [-122.0531, 37.68083], [-122.05273, 37.68038], [-122.05255, 37.6796], [-122.05317, 37.67967], [-122.05318, 37.67971], [-122.05436, 37.68017]]]} | Open Access 1 | 15161 | Fairview Park | 18818 | 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.054 | Fairview 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]);