units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where DES_TP = 2 and MNG_AGENCY = 266 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 39
MNG_AGENCY 1
- Irvine, City of · 39 ✖
DES_TP 1
- Local Park · 39 ✖
ACCESS_TYP 1
- Open Access 39
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11154 | 11154 | 11153 | {"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]} | Open Access 1 | 48692 | Flagstone Park | 18936 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.248 | Flagstone Park | 0 | Local Park 2 | 4 | ||
1077 | 1077 | 1076 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.7034], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.77721, 33.70186], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.7791, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78058, 33.70006], [-117.78086, 33.70027]], [[-117.77835, 33.70067], [-117.7784, 33.70062], [-117.77849, 33.70056], [-117.77867, 33.70047], [-117.77872, 33.7004], [-117.77873, 33.70033], [-117.77872, 33.70027], [-117.77867, 33.70022], [-117.7786, 33.70018], [-117.77853, 33.70018], [-117.77843, 33.7002], [-117.77835, 33.70024], [-117.77829, 33.7003], [-117.77818, 33.70055], [-117.77812, 33.70062], [-117.77795, 33.70075], [-117.77791, 33.7008], [-117.7779, 33.70088], [-117.77797, 33.70102], [-117.77798, 33.70109], [-117.77795, 33.70119], [-117.77797, 33.70127], [-117.77801, 33.7013], [-117.77813, 33.70132], [-117.7783, 33.70128], [-117.77836, 33.70125], [-117.77847, 33.70114], [-117.77852, 33.70104], [-117.77853, 33.70097], [-117.7785, 33.7009], [-117.77834, 33.70074], [-117.77835, 33.70067]]]} | Open Access 1 | 5665 | Heritage Park | 19850 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 29.375 | Heritage Park | 0 | Local Park 2 | 4 | |
12985 | 12985 | 12984 | {"type": "Polygon", "coordinates": [[[-117.77872, 33.70027], [-117.77873, 33.70033], [-117.77872, 33.7004], [-117.77867, 33.70047], [-117.77849, 33.70056], [-117.7784, 33.70062], [-117.77835, 33.70067], [-117.77834, 33.70075], [-117.7785, 33.70091], [-117.77853, 33.70097], [-117.77852, 33.70104], [-117.77847, 33.70114], [-117.77836, 33.70125], [-117.77829, 33.70128], [-117.77813, 33.70132], [-117.77801, 33.7013], [-117.77797, 33.70127], [-117.77795, 33.70118], [-117.77798, 33.70109], [-117.77797, 33.70102], [-117.7779, 33.70088], [-117.77791, 33.7008], [-117.77795, 33.70075], [-117.77812, 33.70062], [-117.77818, 33.70055], [-117.77829, 33.7003], [-117.77835, 33.70024], [-117.77843, 33.7002], [-117.7786, 33.70018], [-117.77872, 33.70027]]]} | Open Access 1 | 30465 | Heritage Park | 19850 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 1.24 | Heritage Park | 0 | Local Park 2 | 4 | |
1613 | 1613 | 1612 | {"type": "Polygon", "coordinates": [[[-117.77216, 33.72465], [-117.77188, 33.72493], [-117.77189, 33.72518], [-117.77188, 33.7253], [-117.77184, 33.72545], [-117.77215, 33.72568], [-117.77145, 33.72639], [-117.77131, 33.72639], [-117.77106, 33.72619], [-117.77081, 33.72577], [-117.77063, 33.72553], [-117.77048, 33.72538], [-117.77025, 33.72522], [-117.7701, 33.72513], [-117.76989, 33.72504], [-117.76961, 33.72496], [-117.76876, 33.72484], [-117.76849, 33.72476], [-117.76815, 33.72458], [-117.76814, 33.72448], [-117.76855, 33.7241], [-117.76874, 33.72388], [-117.76968, 33.72299], [-117.76979, 33.72298], [-117.77216, 33.72465]]]} | Open Access 1 | 12329 | Hicks Canyon Community Park | 19899 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 15.997 | Hicks Canyon Community Park | 0 | Local Park 2 | 4 | |
8150 | 8150 | 8149 | {"type": "Polygon", "coordinates": [[[-117.77725, 33.68548], [-117.77669, 33.68604], [-117.77658, 33.68597], [-117.77641, 33.68596], [-117.77634, 33.68598], [-117.77629, 33.68606], [-117.77634, 33.68613], [-117.77641, 33.68616], [-117.77655, 33.68618], [-117.77583, 33.6869], [-117.77339, 33.68522], [-117.77379, 33.68482], [-117.77524, 33.68582], [-117.77619, 33.68487], [-117.77644, 33.68504], [-117.77653, 33.68497], [-117.77725, 33.68548]]]} | Open Access 1 | 12331 | Hoeptner Park | 20020 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 8.29 | Hoeptner Park | 0 | Local Park 2 | 4 | |
12770 | 12770 | 12769 | {"type": "Polygon", "coordinates": [[[-117.78119, 33.73044], [-117.78104, 33.7306], [-117.78064, 33.73033], [-117.78042, 33.73055], [-117.78042, 33.73057], [-117.78053, 33.73064], [-117.78014, 33.73105], [-117.78022, 33.73111], [-117.78025, 33.73115], [-117.78031, 33.73116], [-117.78044, 33.73125], [-117.7804, 33.73129], [-117.78037, 33.73128], [-117.77951, 33.73068], [-117.78034, 33.72981], [-117.78073, 33.73007], [-117.78074, 33.73012], [-117.78071, 33.7302], [-117.78071, 33.73029], [-117.78074, 33.73036], [-117.78079, 33.73042], [-117.78088, 33.73047], [-117.78098, 33.73049], [-117.78109, 33.73048], [-117.78119, 33.73044]]]} | Open Access 1 | 30202 | Homestead Park | 20063 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.07 | Homestead Park | 0 | Local Park 2 | 4 | |
1615 | 1615 | 1614 | {"type": "Polygon", "coordinates": [[[-117.77406, 33.6503], [-117.77364, 33.64968], [-117.77292, 33.64894], [-117.7726, 33.64871], [-117.77183, 33.64826], [-117.77182, 33.64821], [-117.77206, 33.64793], [-117.77233, 33.64766], [-117.77285, 33.64718], [-117.773, 33.64708], [-117.77304, 33.64713], [-117.7733, 33.64819], [-117.77335, 33.6483], [-117.77342, 33.64837], [-117.77354, 33.64844], [-117.77391, 33.64855], [-117.77403, 33.64857], [-117.77396, 33.64895], [-117.77385, 33.64918], [-117.77383, 33.64927], [-117.77388, 33.64943], [-117.77407, 33.64989], [-117.7741, 33.65009], [-117.7741, 33.65019], [-117.77406, 33.6503]]]} | Open Access 1 | 12345 | Knollcrest Park | 20699 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 6.395 | Knollcrest Park | 0 | Local Park 2 | 4 | |
12777 | 12777 | 12776 | {"type": "Polygon", "coordinates": [[[-117.83103, 33.62905], [-117.83102, 33.62906], [-117.83101, 33.62912], [-117.83073, 33.62961], [-117.83048, 33.63027], [-117.83044, 33.63047], [-117.83041, 33.63077], [-117.8304, 33.6311], [-117.83043, 33.63125], [-117.83037, 33.63131], [-117.82867, 33.63141], [-117.82856, 33.63136], [-117.82848, 33.63049], [-117.82867, 33.63048], [-117.82872, 33.63121], [-117.82922, 33.63119], [-117.82922, 33.63113], [-117.82936, 33.63111], [-117.82926, 33.63032], [-117.82813, 33.63036], [-117.82875, 33.62809], [-117.82877, 33.6279], [-117.82917, 33.62804], [-117.82975, 33.62831], [-117.82976, 33.62837], [-117.82993, 33.62847], [-117.83003, 33.62847], [-117.83103, 33.62905]]]} | Open Access 1 | 30207 | Las Lomas Community Park | 21056 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 15.412 | Las Lomas Community Park | 0 | Local Park 2 | 4 | |
1639 | 1639 | 1638 | {"type": "Polygon", "coordinates": [[[-117.75592, 33.72636], [-117.75321, 33.72576], [-117.75327, 33.72558], [-117.75337, 33.72544], [-117.75337, 33.72535], [-117.75331, 33.72529], [-117.75322, 33.72526], [-117.75313, 33.72528], [-117.75307, 33.72533], [-117.75303, 33.7253], [-117.75335, 33.72435], [-117.75588, 33.72459], [-117.75592, 33.72463], [-117.75587, 33.72478], [-117.75591, 33.72487], [-117.75592, 33.72497], [-117.75592, 33.72636]]]} | Open Access 1 | 12489 | Meadowood Park | 22092 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.895 | Meadowood Park | 0 | Local Park 2 | 4 | |
6253 | 6253 | 6252 | {"type": "Polygon", "coordinates": [[[-117.76966, 33.71137], [-117.76791, 33.7131], [-117.76493, 33.71103], [-117.76786, 33.71016], [-117.76789, 33.71016], [-117.76966, 33.71137]]]} | Open Access 1 | 5992 | Northwood Community Park | 22899 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 17.728 | Northwood Community Park | 0 | Local Park 2 | 4 | |
1688 | 1688 | 1687 | {"type": "Polygon", "coordinates": [[[-117.77315, 33.66762], [-117.77212, 33.66863], [-117.76938, 33.66672], [-117.77029, 33.66576], [-117.77079, 33.66612], [-117.77315, 33.66762]]]} | Open Access 1 | 12731 | Oak Creek Community Park | 22959 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 11.56 | Oak Creek Community Park | 0 | Local Park 2 | 4 | |
8224 | 8224 | 8223 | {"type": "Polygon", "coordinates": [[[-117.77483, 33.7005], [-117.77383, 33.70109], [-117.77349, 33.70135], [-117.77324, 33.70159], [-117.77313, 33.70161], [-117.77247, 33.70114], [-117.77246, 33.70105], [-117.77341, 33.70011], [-117.77363, 33.70005], [-117.77372, 33.7], [-117.77381, 33.69988], [-117.77382, 33.6998], [-117.7738, 33.69968], [-117.7741, 33.69938], [-117.77483, 33.7005]]]} | Open Access 1 | 12533 | Orchard Park | 23190 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 5.831 | Orchard Park | 0 | Local Park 2 | 4 | |
3011 | 3011 | 3010 | {"type": "Polygon", "coordinates": [[[-117.71297, 33.70113], [-117.71281, 33.70134], [-117.71268, 33.70136], [-117.71263, 33.70123], [-117.71255, 33.70111], [-117.71244, 33.70099], [-117.71233, 33.70091], [-117.71232, 33.70082], [-117.7124, 33.70073], [-117.71297, 33.70113]]]} | Open Access 1 | 48660 | Orchard Trail Park | 33407 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.424 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
11155 | 11155 | 11154 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | 48695 | Orchard Trail Park | 33407 | 6128 | Portola Springs Community Association 967 | Private 7 | Home Owners Association 16 | https://portolasprings.org/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.227 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
7751 | 7751 | 7750 | {"type": "Polygon", "coordinates": [[[-117.7672, 33.70657], [-117.76702, 33.70679], [-117.76688, 33.70675], [-117.76679, 33.70675], [-117.76672, 33.70678], [-117.76664, 33.70687], [-117.76658, 33.70705], [-117.76652, 33.70706], [-117.76539, 33.70628], [-117.76536, 33.70625], [-117.76535, 33.70622], [-117.76558, 33.70597], [-117.76559, 33.70591], [-117.76558, 33.70584], [-117.76581, 33.70561], [-117.7672, 33.70657]]]} | Open Access 1 | 8318 | Pepperwood Park | 23600 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 3.11 | Pepperwood Park | 0 | Local Park 2 | 4 | |
1660 | 1660 | 1659 | {"type": "Polygon", "coordinates": [[[-117.75764, 33.70435], [-117.75725, 33.70459], [-117.75723, 33.70464], [-117.75713, 33.70465], [-117.75709, 33.70469], [-117.75707, 33.70475], [-117.75701, 33.70473], [-117.75652, 33.70501], [-117.75652, 33.70506], [-117.75644, 33.70506], [-117.7564, 33.70509], [-117.75635, 33.70514], [-117.75629, 33.70514], [-117.75579, 33.7054], [-117.75576, 33.70546], [-117.75567, 33.70547], [-117.75561, 33.70553], [-117.75553, 33.70552], [-117.75708, 33.70396], [-117.75764, 33.70435]]]} | Open Access 1 | 12560 | Pinewood Park | 23693 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.052 | Pinewood Park | 0 | Local Park 2 | 4 | |
1654 | 1654 | 1653 | {"type": "Polygon", "coordinates": [[[-117.81031, 33.69008], [-117.81012, 33.69032], [-117.80993, 33.69052], [-117.80959, 33.69081], [-117.80948, 33.69084], [-117.80944, 33.69081], [-117.80937, 33.69085], [-117.8087, 33.69041], [-117.80827, 33.69084], [-117.80889, 33.69125], [-117.80878, 33.69129], [-117.80616, 33.68949], [-117.8066, 33.68956], [-117.80696, 33.68958], [-117.80853, 33.68961], [-117.80899, 33.68965], [-117.80982, 33.68985], [-117.81029, 33.69002], [-117.81031, 33.69008]]]} | Open Access 1 | 12568 | Plaza Park | 23785 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.975 | Plaza Park | 0 | Local Park 2 | 4 | |
10903 | 10903 | 10902 | {"type": "Polygon", "coordinates": [[[-117.70737, 33.69604], [-117.70643, 33.6954], [-117.70213, 33.69972], [-117.70191, 33.69964], [-117.70162, 33.69931], [-117.70047, 33.6986], [-117.70041, 33.69852], [-117.70056, 33.698], [-117.7004, 33.69787], [-117.70015, 33.69789], [-117.69959, 33.69802], [-117.69959, 33.69807], [-117.69842, 33.69803], [-117.69805, 33.69753], [-117.69777, 33.69751], [-117.69626, 33.69685], [-117.69623, 33.69676], [-117.69612, 33.6967], [-117.69603, 33.69672], [-117.69543, 33.69641], [-117.69458, 33.69585], [-117.69459, 33.6958], [-117.69451, 33.69572], [-117.69442, 33.69574], [-117.69414, 33.69555], [-117.69411, 33.69534], [-117.69409, 33.69528], [-117.69448, 33.69518], [-117.69491, 33.69511], [-117.69535, 33.69505], [-117.69579, 33.69502], [-117.69645, 33.69503], [-117.69805, 33.69516], [-117.69853, 33.69518], [-117.699, 33.69518], [-117.69948, 33.69515], [-117.69995, 33.69509], [-117.70462, 33.69436], [-117.70527, 33.69431], [-117.70591, 33.69431], [-117.70612, 33.69432], [-117.70737, 33.69604]]]} | Open Access 1 | 48665 | Portola Springs Community Park | 33412 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 85.788 | Portola Springs Community Park | 0 | Local Park 2 | 4 | |
1233 | 1233 | 1232 | {"type": "Polygon", "coordinates": [[[-117.7808, 33.69515], [-117.78058, 33.69552], [-117.78043, 33.69574], [-117.78018, 33.69602], [-117.77968, 33.69653], [-117.77962, 33.69653], [-117.77956, 33.6965], [-117.77908, 33.69618], [-117.78028, 33.69497], [-117.7808, 33.69515]]]} | Open Access 1 | 8919 | Presley Park | 23995 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.887 | Presley Park | 0 | Local Park 2 | 4 | |
8236 | 8236 | 8235 | {"type": "Polygon", "coordinates": [[[-117.7843, 33.65032], [-117.78379, 33.65149], [-117.78363, 33.65181], [-117.78346, 33.65208], [-117.78325, 33.65238], [-117.78303, 33.65265], [-117.78274, 33.65296], [-117.78199, 33.65368], [-117.78128, 33.6542], [-117.78121, 33.65417], [-117.78102, 33.65413], [-117.78085, 33.65415], [-117.78072, 33.6542], [-117.78052, 33.65405], [-117.78291, 33.64981], [-117.7829, 33.64979], [-117.78279, 33.64975], [-117.78291, 33.64957], [-117.78311, 33.64962], [-117.78352, 33.64967], [-117.78368, 33.64973], [-117.78384, 33.64986], [-117.78388, 33.64992], [-117.78393, 33.65005], [-117.78412, 33.65005], [-117.78425, 33.6503], [-117.7843, 33.65032]]]} | Open Access 1 | 12570 | Quail Hill Community Park | 24041 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 17.783 | Quail Hill Community 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]);