units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where DES_TP = 2 and MNG_AGENCY = 297
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 29
MNG_AGENCY 1
- Pasadena, City of · 29 ✖
DES_TP 1
- Local Park · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
987 | 987 | 986 | {"type": "Polygon", "coordinates": [[[-118.16289, 34.14526], [-118.16276, 34.14539], [-118.16263, 34.14547], [-118.16238, 34.14558], [-118.16208, 34.14564], [-118.16161, 34.14564], [-118.16083, 34.1456], [-118.16078, 34.14558], [-118.1607, 34.14534], [-118.1613, 34.14533], [-118.16131, 34.14531], [-118.16126, 34.14517], [-118.16176, 34.14517], [-118.16186, 34.14542], [-118.16206, 34.14541], [-118.16201, 34.14527], [-118.16289, 34.14526]]]} | Open Access 1 | 6716 | Defenders Park | 18012 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 1.665 | Defenders Park | 0 | Local Park 2 | 4 | |
989 | 989 | 988 | {"type": "Polygon", "coordinates": [[[-118.137, 34.16884], [-118.13546, 34.16885], [-118.13545, 34.16768], [-118.13551, 34.16767], [-118.13552, 34.16743], [-118.13551, 34.16742], [-118.13551, 34.16733], [-118.13616, 34.16732], [-118.13617, 34.16735], [-118.13649, 34.16735], [-118.1365, 34.16767], [-118.13699, 34.16767], [-118.137, 34.16884]]]} | Open Access 1 | 6718 | Washington Park | 27276 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Washington_Park/ | Los Angeles 6 | 5.43 | Washington Park | 0 | Local Park 2 | 4 |
990 | 990 | 989 | {"type": "Polygon", "coordinates": [[[-118.14566, 34.12655], [-118.14418, 34.12656], [-118.14418, 34.12588], [-118.14436, 34.12587], [-118.14436, 34.12569], [-118.14566, 34.12568], [-118.14566, 34.12655]]]} | Open Access 1 | 6721 | Allendale Park | 15381 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Allendale_Park/ | Los Angeles 6 | 3.179 | Allendale Park | 0 | Local Park 2 | 4 |
991 | 991 | 990 | {"type": "Polygon", "coordinates": [[[-118.1488, 34.14937], [-118.14878, 34.1494], [-118.14875, 34.14941], [-118.14702, 34.14941], [-118.14789, 34.14777], [-118.14879, 34.14776], [-118.1488, 34.14937]]]} | Open Access 1 | 6725 | Pasadena Memorial Park | 23491 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 5.544 | Pasadena Memorial Park | 0 | Local Park 2 | 4 | |
1001 | 1001 | 1000 | {"type": "Polygon", "coordinates": [[[-118.1198, 34.15534], [-118.11782, 34.15535], [-118.11782, 34.15446], [-118.1198, 34.15446], [-118.1198, 34.15534]]]} | Open Access 1 | 6744 | Jefferson Park | 20381 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.412 | Jefferson Park | 0 | Local Park 2 | 4 | |
1145 | 1145 | 1144 | {"type": "Polygon", "coordinates": [[[-118.08726, 34.1584], [-118.08682, 34.15836], [-118.08638, 34.15829], [-118.08536, 34.15802], [-118.08542, 34.15783], [-118.08564, 34.15677], [-118.08585, 34.1568], [-118.086, 34.15604], [-118.08705, 34.15619], [-118.08703, 34.15669], [-118.08705, 34.15718], [-118.08711, 34.15767], [-118.08726, 34.1584]]]} | Open Access 1 | 6726 | Viña Vieja Park | 28118 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 7.898 | Viña Vieja Park | 0 | Local Park 2 | 4 | |
1146 | 1146 | 1145 | {"type": "Polygon", "coordinates": [[[-118.07621, 34.16419], [-118.07389, 34.1642], [-118.07385, 34.16196], [-118.07616, 34.16193], [-118.07621, 34.16419]]]} | Open Access 1 | 6729 | Hamilton Park | 19620 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 13.142 | Hamilton Park | 0 | Local Park 2 | 4 | |
1147 | 1147 | 1146 | {"type": "Polygon", "coordinates": [[[-118.08707, 34.14127], [-118.08706, 34.1421], [-118.08635, 34.14211], [-118.08635, 34.14203], [-118.08628, 34.14203], [-118.08607, 34.14179], [-118.08603, 34.14173], [-118.08594, 34.14163], [-118.08453, 34.14025], [-118.08436, 34.14002], [-118.08426, 34.13981], [-118.08387, 34.13867], [-118.08386, 34.13849], [-118.08413, 34.13849], [-118.08413, 34.1389], [-118.08447, 34.1389], [-118.08445, 34.13992], [-118.08449, 34.14005], [-118.08458, 34.14016], [-118.0847, 34.14024], [-118.08486, 34.14028], [-118.08596, 34.14027], [-118.08594, 34.14115], [-118.0861, 34.14128], [-118.08707, 34.14127]]]} | Open Access 1 | 6731 | Eaton Blanche Park | 18406 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Eaton_Blanche_Park/ | Los Angeles 6 | 5.782 | Eaton Blanche Park | 0 | Local Park 2 | 4 |
1148 | 1148 | 1147 | {"type": "Polygon", "coordinates": [[[-118.17776, 34.14042], [-118.17776, 34.14045], [-118.17758, 34.14079], [-118.17755, 34.14081], [-118.17673, 34.14085], [-118.1767, 34.14083], [-118.17661, 34.14069], [-118.17742, 34.14033], [-118.17773, 34.14039], [-118.17776, 34.14042]]]} | Open Access 1 | 6733 | San Rafael Park | 24983 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/San_Rafael_Park/ | Los Angeles 6 | 0.948 | San Rafael Park | 0 | Local Park 2 | 4 |
1151 | 1151 | 1150 | {"type": "Polygon", "coordinates": [[[-118.16869, 34.15351], [-118.16865, 34.15354], [-118.16836, 34.15333], [-118.16826, 34.15332], [-118.16819, 34.15335], [-118.16814, 34.1534], [-118.16812, 34.15344], [-118.16805, 34.15383], [-118.16806, 34.15393], [-118.16779, 34.15412], [-118.16776, 34.15415], [-118.16784, 34.15438], [-118.168, 34.15465], [-118.16854, 34.15527], [-118.16857, 34.15539], [-118.16858, 34.15549], [-118.16855, 34.15561], [-118.1685, 34.15571], [-118.16843, 34.1558], [-118.16832, 34.15588], [-118.16823, 34.15592], [-118.16757, 34.15606], [-118.1676, 34.15659], [-118.16753, 34.15651], [-118.16743, 34.15645], [-118.16731, 34.15641], [-118.1672, 34.15641], [-118.16632, 34.15661], [-118.16607, 34.15669], [-118.16566, 34.15687], [-118.16435, 34.15769], [-118.16411, 34.15782], [-118.16386, 34.15734], [-118.16382, 34.15729], [-118.16343, 34.15642], [-118.16335, 34.1563], [-118.16308, 34.156], [-118.16347, 34.15577], [-118.16293, 34.15456], [-118.16303, 34.15449], [-118.16324, 34.15425], [-118.1628, 34.15332], [-118.16238, 34.15345], [-118.16284, 34.15231], [-118.1627, 34.15135], [-118.16242, 34.1512], [-118.16264, 34.15103], [-118.16247, 34.15079], [-118.16268, 34.15066], [-118.1629, 34.15045], [-118.16304, 34.15034], [-118.16357, 34.15003], [-118.16381, 34.14994], [-118.16408, 34.1497], [-118.16416, 34.14967], [-118.16448, 34.14959], [-118.16455, 34.14954], [-118.16462, 34.14942], [-118.16474, 34.1494], [-118.16452, 34.14863], [-118.16443, 34.1485], [-118.16425, 34.14833], [-118.16468, 34.14833], [-118.1652, 34.14871], [-118.1653, 34.14833], [-118.16548, 34.14832], [-118.16545, 34.14792], [-118.16543, 34.14782], [-118.16538, 34.14775], [-118.1653, 34.14766], [-118.1652, 34.14759], [-118.16509, 34.14755], [-118.16495, 34.14752], [-118.16473, 34.14742], [-118.16432, 34.14709], [-118.16448, 34.14694], [-118.16422, 34.14675], [-118.16411, 34.14655], [-118.16412, 34.14645], [-118.1651, 34.1462], [-118.165, 34.14637], [-118.165, 34.14655], [-118.16541, 34.14669], [-118.16582, 34.14675], [-118.16616, 34.14688], [-118.1662, 34.14692], [-118.1661, 34.14692], [-118.16609, 34.14693], [-118.16613, 34.14696], [-118.16626, 34.14697], [-118.16679, 34.14743], [-118.16676, 34.14781], [-118.16648, 34.14813], [-118.16642, 34.14823], [-118.16635, 34.14836], [-118.16632, 34.1485], [-118.16631, 34.14864], [-118.16632, 34.14876], [-118.16643, 34.14917], [-118.1663, 34.14923], [-118.16597, 34.14903], [-118.1658, 34.14936], [-118.16591, 34.15034], [-118.1661, 34.1504], [-118.16628, 34.15052], [-118.16633, 34.15061], [-118.16656, 34.15077], [-118.16668, 34.1509], [-118.16675, 34.1509], [-118.16678, 34.15112], [-118.16683, 34.15137], [-118.16697, 34.15176], [-118.16717, 34.15215], [-118.16734, 34.15239], [-118.1675, 34.15258], [-118.16767, 34.15276], [-118.16788, 34.15294], [-118.16869, 34.15351]]]} | Open Access 1 | 6736 | Brookside Park | 16431 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Brookside_Park1/ | Los Angeles 6 | 94.183 | Brookside Park | 0 | Local Park 2 | 4 |
1152 | 1152 | 1151 | {"type": "Polygon", "coordinates": [[[-118.15682, 34.13566], [-118.15567, 34.13566], [-118.15566, 34.13461], [-118.15619, 34.1346], [-118.1562, 34.13464], [-118.1568, 34.13463], [-118.15682, 34.13566]]]} | Open Access 1 | 6737 | Singer Park | 25517 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 3.01 | Singer Park | 0 | Local Park 2 | 4 | |
1153 | 1153 | 1152 | {"type": "Polygon", "coordinates": [[[-118.15031, 34.14345], [-118.149, 34.14346], [-118.14897, 34.14072], [-118.14899, 34.14069], [-118.15003, 34.14068], [-118.15021, 34.14071], [-118.15028, 34.14077], [-118.15031, 34.14345]]]} | Open Access 1 | 6738 | Pasadena Central Park | 23489 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Central_Park_Master_Plan/ | Los Angeles 6 | 9.154 | Pasadena Central Park | 0 | Local Park 2 | 4 |
1658 | 1658 | 1657 | {"type": "MultiPolygon", "coordinates": [[[[-118.20428, 34.26086], [-118.20289, 34.26135], [-118.19949, 34.25848], [-118.19999, 34.25788], [-118.20192, 34.2573], [-118.20428, 34.26086]]], [[[-118.20284, 34.26137], [-118.20252, 34.26149], [-118.19905, 34.25902], [-118.19947, 34.25851], [-118.20284, 34.26137]]]]} | Open Access 1 | 12550 | Pasadena City Parkland | 8444 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 27.888 | Pasadena City Parkland | 0 | Local Park 2 | 4 | |
3049 | 3049 | 3048 | {"type": "Polygon", "coordinates": [[[-118.16091, 34.13982], [-118.15954, 34.13982], [-118.15942, 34.13859], [-118.16072, 34.13858], [-118.16072, 34.13907], [-118.16084, 34.13908], [-118.16091, 34.13982]]]} | Restricted Access 2 | 24522 | Wrigley Gardens | 32656 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.163 | Wrigley Gardens | 0 | Local Park 2 | 4 | |
4382 | 4382 | 4381 | {"type": "Polygon", "coordinates": [[[-118.08827, 34.15937], [-118.08808, 34.159], [-118.08793, 34.15862], [-118.08911, 34.15861], [-118.08915, 34.15862], [-118.08915, 34.15932], [-118.08913, 34.15934], [-118.0891, 34.15936], [-118.08827, 34.15937]]]} | Open Access 1 | 45944 | Eaton Sunnyslope Park | 29051 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Eaton_Sunnyslope_Park/ | Los Angeles 6 | 2.002 | Eaton Sunnyslope Park | 0 | Local Park 2 | 4 |
4383 | 4383 | 4382 | {"type": "Polygon", "coordinates": [[[-118.08786, 34.15841], [-118.08776, 34.15803], [-118.08769, 34.15766], [-118.08912, 34.15764], [-118.08917, 34.15766], [-118.08916, 34.15835], [-118.08914, 34.15838], [-118.08786, 34.15841]]]} | Open Access 1 | 45945 | Gwinn Park | 29052 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Gwinn_Park/ | Los Angeles 6 | 2.633 | Gwinn Park | 0 | Local Park 2 | 4 |
5532 | 5532 | 5531 | {"type": "Polygon", "coordinates": [[[-118.09817, 34.14384], [-118.09793, 34.14384], [-118.09794, 34.1433], [-118.09816, 34.1433], [-118.09817, 34.14384]]]} | Open Access 1 | 48170 | Lamada Pocket Park | 32702 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 0.313 | Lamada PP | 0 | Local Park 2 | 4 | |
7339 | 7339 | 7338 | {"type": "Polygon", "coordinates": [[[-118.12814, 34.16334], [-118.12693, 34.16335], [-118.1269, 34.1617], [-118.12812, 34.16169], [-118.12814, 34.16334]]]} | Open Access 1 | 6743 | McDonald Park | 22022 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 5.065 | McDonald Park | 0 | Local Park 2 | 4 | |
7358 | 7358 | 7357 | {"type": "Polygon", "coordinates": [[[-118.17822, 34.18964], [-118.17819, 34.19263], [-118.17815, 34.193], [-118.17806, 34.19331], [-118.17775, 34.194], [-118.17757, 34.19423], [-118.17747, 34.1946], [-118.17741, 34.19469], [-118.17729, 34.19479], [-118.17719, 34.19492], [-118.17706, 34.19502], [-118.177, 34.19509], [-118.17697, 34.19517], [-118.17693, 34.19538], [-118.1769, 34.19549], [-118.17674, 34.19575], [-118.17662, 34.19598], [-118.17654, 34.19608], [-118.17642, 34.19615], [-118.17623, 34.19631], [-118.17601, 34.19645], [-118.1759, 34.19658], [-118.17584, 34.19671], [-118.17584, 34.19695], [-118.17579, 34.19709], [-118.17519, 34.19783], [-118.17511, 34.19796], [-118.17507, 34.19812], [-118.17504, 34.19844], [-118.17312, 34.19845], [-118.17367, 34.19702], [-118.17209, 34.19702], [-118.17208, 34.197], [-118.17202, 34.197], [-118.16906, 34.19982], [-118.16779, 34.20095], [-118.16663, 34.20311], [-118.16533, 34.2031], [-118.16511, 34.20251], [-118.16483, 34.2027], [-118.16472, 34.20273], [-118.16474, 34.20269], [-118.16438, 34.20224], [-118.16431, 34.20209], [-118.16426, 34.20177], [-118.16427, 34.20146], [-118.16398, 34.20148], [-118.16491, 34.20016], [-118.16581, 34.19797], [-118.16694, 34.19597], [-118.16718, 34.19568], [-118.16742, 34.1953], [-118.16788, 34.19436], [-118.1679, 34.19424], [-118.16802, 34.19402], [-118.16816, 34.19406], [-118.16841, 34.19353], [-118.16849, 34.19329], [-118.16854, 34.19304], [-118.16856, 34.19258], [-118.16924, 34.19264], [-118.16937, 34.19244], [-118.16936, 34.19242], [-118.1693, 34.19242], [-118.16975, 34.19217], [-118.17023, 34.19159], [-118.17052, 34.19113], [-118.17061, 34.19012], [-118.17151, 34.18957], [-118.17184, 34.18911], [-118.17208, 34.18782], [-118.17289, 34.18645], [-118.17297, 34.18521], [-118.17253, 34.18359], [-118.17272, 34.18369], [-118.17294, 34.18366], [-118.17316, 34.18346], [-118.1749, 34.1842], [-118.17501, 34.1843], [-118.17509, 34.18438], [-118.17517, 34.18452], [-118.17533, 34.18512], [-118.17554, 34.18545], [-118.17566, 34.18584], [-118.17571, 34.18583], [-118.17587, 34.18584], [-118.17603, 34.18584], [-118.17642, 34.18578], [-118.17659, 34.1858], [-118.17707, 34.186], [-118.17769, 34.18616], [-118.17796, 34.18638], [-118.17824, 34.18664], [-118.17848, 34.18693], [-118.17863, 34.18722], [-118.17873, 34.18752], [-118.17876, 34.18783], [-118.17874, 34.18809], [-118.17866, 34.18836], [-118.17858, 34.18854], [-118.17839, 34.18888], [-118.17828, 34.18915], [-118.17821, 34.18946], [-118.1782, 34.18963], [-118.17822, 34.18964]]]} | Open Access 1 | 6715 | Hahamongna Watershed Park | 8427 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/hahamongna/ | Los Angeles 6 | 303.369 | Hahamongna Watershed Park | 0 | Local Park 2 | 4 |
7363 | 7363 | 7362 | {"type": "Polygon", "coordinates": [[[-118.15657, 34.16124], [-118.15621, 34.16175], [-118.15485, 34.16106], [-118.15557, 34.16043], [-118.15657, 34.16124]]]} | Open Access 1 | 6739 | Brenner Park | 16353 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 2.725 | Brenner 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]);