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 ACRES descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER
AGNCY_WEB 3 ✖
MNG_AG_TYP 1
- City Agency 59
MNG_AGENCY 1
- Irvine, City of · 59 ✖
DES_TP 1
- Local Park · 59 ✖
ACCESS_TYP 1
- Open Access 59
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1606 | 1606 | 1605 | {"type": "Polygon", "coordinates": [[[-117.82591, 33.68843], [-117.82569, 33.68864], [-117.82544, 33.68883], [-117.82511, 33.68905], [-117.8249, 33.68915], [-117.82441, 33.68932], [-117.82382, 33.68946], [-117.82354, 33.6895], [-117.82297, 33.68955], [-117.82261, 33.68955], [-117.82202, 33.6895], [-117.82163, 33.68944], [-117.82136, 33.68937], [-117.821, 33.68924], [-117.82057, 33.68903], [-117.81908, 33.68801], [-117.81952, 33.68765], [-117.81976, 33.68748], [-117.82, 33.68734], [-117.82025, 33.6872], [-117.82072, 33.687], [-117.82085, 33.68701], [-117.82102, 33.68695], [-117.82109, 33.68686], [-117.8216, 33.68672], [-117.82327, 33.68646], [-117.82406, 33.68627], [-117.82456, 33.68608], [-117.82461, 33.68609], [-117.82498, 33.6867], [-117.82516, 33.68692], [-117.82537, 33.68713], [-117.82483, 33.68764], [-117.82591, 33.68843]]]} | Open Access 1 | 12277 | Colonel Bill Barber Marine Corps Memorial Park | 17526 | 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 | 37.944 | Colonel Bill Barber Marine Corps Memorial 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 | |
1717 | 1717 | 1716 | {"type": "Polygon", "coordinates": [[[-117.80767, 33.63297], [-117.80396, 33.6349], [-117.80358, 33.63422], [-117.80308, 33.63275], [-117.80412, 33.63248], [-117.80499, 33.63217], [-117.80531, 33.63203], [-117.80683, 33.63122], [-117.80767, 33.63297]]]} | Open Access 1 | 14857 | Turtle Rock Community Park | 26593 | 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 | 21.468 | Turtle Rock Community Park | 0 | Local Park 2 | 4 | |
1926 | 1926 | 1925 | {"type": "Polygon", "coordinates": [[[-117.82166, 33.65937], [-117.82142, 33.65971], [-117.82114, 33.66015], [-117.82094, 33.66052], [-117.82017, 33.66035], [-117.8199, 33.6608], [-117.81962, 33.66162], [-117.81919, 33.66163], [-117.81885, 33.66175], [-117.8187, 33.66221], [-117.81898, 33.66227], [-117.81887, 33.66268], [-117.81897, 33.66287], [-117.81931, 33.66306], [-117.81842, 33.66311], [-117.81806, 33.66311], [-117.81754, 33.6631], [-117.81747, 33.66307], [-117.81745, 33.663], [-117.81755, 33.66246], [-117.81758, 33.66159], [-117.81757, 33.66132], [-117.81747, 33.66101], [-117.81739, 33.66084], [-117.81739, 33.66079], [-117.81741, 33.66076], [-117.81771, 33.66053], [-117.81786, 33.66037], [-117.81794, 33.66025], [-117.81804, 33.65999], [-117.81813, 33.65965], [-117.82005, 33.65963], [-117.82007, 33.65938], [-117.82166, 33.65937]]]} | Open Access 1 | 14898 | University Community Park | 26678 | 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 | 19.625 | University Community 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 | |
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 | |
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 | |
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 | |
4327 | 4327 | 4326 | {"type": "Polygon", "coordinates": [[[-117.76611, 33.69081], [-117.76411, 33.69277], [-117.76228, 33.69163], [-117.76216, 33.69146], [-117.76347, 33.69013], [-117.76434, 33.69078], [-117.76503, 33.69011], [-117.76611, 33.69081]]]} | Open Access 1 | 45463 | Cypress Community Park | 28273 | 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 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cypress_community_park.asp | Orange 3 | 14.139 | Cypress Community Park | 0 | Local Park 2 | 4 |
9269 | 9269 | 9268 | {"type": "Polygon", "coordinates": [[[-117.78912, 33.67333], [-117.78882, 33.67355], [-117.78848, 33.67386], [-117.78822, 33.67413], [-117.78755, 33.67489], [-117.78743, 33.67491], [-117.78515, 33.67355], [-117.78515, 33.67348], [-117.78513, 33.67345], [-117.7861, 33.67249], [-117.78704, 33.67253], [-117.78744, 33.67264], [-117.78819, 33.67285], [-117.78912, 33.67333]]]} | Open Access 1 | 15433 | Windrow Community Park | 27632 | 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 | 13.863 | Windrow 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 | |
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 | |
4040 | 4040 | 4039 | {"type": "Polygon", "coordinates": [[[-117.76064, 33.73966], [-117.76012, 33.74012], [-117.75743, 33.73842], [-117.75801, 33.73776], [-117.75829, 33.73758], [-117.75908, 33.73774], [-117.7599, 33.7381], [-117.76039, 33.73872], [-117.76064, 33.73966]]]} | Open Access 1 | 44285 | Settlers Park | 25324 | 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.852 | Settlers Park | 0 | Local Park 2 | 4 | |
5035 | 5035 | 5034 | {"type": "Polygon", "coordinates": [[[-117.75315, 33.69738], [-117.75187, 33.69866], [-117.75179, 33.69867], [-117.75168, 33.69878], [-117.75168, 33.69884], [-117.75097, 33.69955], [-117.75091, 33.69955], [-117.74986, 33.69882], [-117.75088, 33.6978], [-117.75088, 33.69779], [-117.75082, 33.69775], [-117.75203, 33.69654], [-117.75314, 33.69732], [-117.75315, 33.69734], [-117.75315, 33.69738]]]} | Open Access 1 | 48664 | Woodbury Community Park | 33411 | 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.743 | Woodbury Community Park | 0 | Local Park 2 | 4 | |
2448 | 2448 | 2447 | {"type": "Polygon", "coordinates": [[[-117.817, 33.6335], [-117.81679, 33.63419], [-117.81524, 33.63392], [-117.81415, 33.63424], [-117.81405, 33.63482], [-117.8138, 33.63483], [-117.81329, 33.6346], [-117.81344, 33.63358], [-117.81313, 33.63353], [-117.81317, 33.63287], [-117.81436, 33.633], [-117.81478, 33.63303], [-117.81598, 33.63317], [-117.81644, 33.63328], [-117.817, 33.6335]]]} | Open Access 1 | 12179 | Chaparral Park | 17129 | 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.442 | Chaparral Park | 0 | Local Park 2 | 4 | |
12775 | 12775 | 12774 | {"type": "Polygon", "coordinates": [[[-117.77984, 33.71541], [-117.7783, 33.71699], [-117.778, 33.7168], [-117.77748, 33.71643], [-117.7774, 33.71635], [-117.77685, 33.71596], [-117.77684, 33.71585], [-117.77761, 33.7151], [-117.77826, 33.71441], [-117.77841, 33.7144], [-117.77924, 33.71497], [-117.7794, 33.715], [-117.7794, 33.7151], [-117.77984, 33.71541]]]} | Open Access 1 | 30205 | David Sills Lower Peters Canyon Park | 28280 | 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 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cparks_peters.asp | Orange 3 | 10.266 | David Sills Lower Peters Canyon Park | 0 | Local Park 2 | 4 |
2763 | 2763 | 2762 | {"type": "Polygon", "coordinates": [[[-117.79385, 33.69078], [-117.79381, 33.69084], [-117.79257, 33.69208], [-117.79239, 33.69222], [-117.79235, 33.69228], [-117.79235, 33.69234], [-117.79224, 33.69234], [-117.79206, 33.69251], [-117.79072, 33.69157], [-117.79092, 33.69136], [-117.79099, 33.69135], [-117.79104, 33.69131], [-117.79118, 33.69114], [-117.7925, 33.68983], [-117.79254, 33.68983], [-117.79257, 33.68985], [-117.79279, 33.6901], [-117.79298, 33.69025], [-117.79338, 33.69052], [-117.79383, 33.69074], [-117.79385, 33.69078]]]} | Open Access 1 | 18466 | Deerfield Community Park | 18008 | 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.245 | Deerfield Community Park | 0 | Local Park 2 | 4 | |
3013 | 3013 | 3012 | {"type": "Polygon", "coordinates": [[[-117.75861, 33.68706], [-117.75734, 33.68834], [-117.75725, 33.68835], [-117.75724, 33.68826], [-117.75719, 33.68819], [-117.7558, 33.68722], [-117.75572, 33.6872], [-117.7556, 33.6872], [-117.7556, 33.68713], [-117.75688, 33.68585], [-117.75861, 33.68706]]]} | Open Access 1 | 48662 | Cypress Grove Park | 33409 | 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 | 9.424 | Cypress Grove Park | 0 | Local Park 2 | 4 | |
4326 | 4326 | 4325 | {"type": "Polygon", "coordinates": [[[-117.74192, 33.7062], [-117.74122, 33.70692], [-117.74093, 33.70719], [-117.74067, 33.70702], [-117.74058, 33.70702], [-117.74049, 33.70706], [-117.74046, 33.70705], [-117.73924, 33.7062], [-117.73914, 33.70618], [-117.73906, 33.70623], [-117.739, 33.70619], [-117.73902, 33.70615], [-117.7402, 33.70496], [-117.74022, 33.70497], [-117.74028, 33.70492], [-117.74123, 33.70558], [-117.74119, 33.70562], [-117.74119, 33.70563], [-117.7414, 33.70581], [-117.74192, 33.70617], [-117.74191, 33.70619], [-117.74192, 33.7062]]]} | Open Access 1 | 45461 | Stonegate Park | 28267 | 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 | http://www.cityofirvine.org/cityhall/cs/commparks/nparks/default.asp | Orange 3 | 8.581 | Stonegate 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]);