units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where MNG_AGENCY = 266 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1687 | 1687 | 1686 | {"type": "Polygon", "coordinates": [[[-117.77833, 33.73648], [-117.77833, 33.73656], [-117.77818, 33.73668], [-117.778, 33.73687], [-117.77801, 33.73689], [-117.7779, 33.73699], [-117.7776, 33.73678], [-117.7773, 33.73707], [-117.77732, 33.7372], [-117.77749, 33.73738], [-117.77721, 33.73766], [-117.77602, 33.73683], [-117.77703, 33.73585], [-117.77701, 33.73582], [-117.77704, 33.73579], [-117.77701, 33.73576], [-117.77715, 33.73562], [-117.77719, 33.73564], [-117.77737, 33.73547], [-117.77759, 33.73572], [-117.77777, 33.73598], [-117.77795, 33.73619], [-117.77833, 33.73648]]]} | Open Access 1 | 12730 | Valencia Park | 26765 | 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.851 | Valencia Park | 0 | Local Park 2 | 4 | |
8246 | 8246 | 8245 | {"type": "Polygon", "coordinates": [[[-117.82971, 33.6804], [-117.82942, 33.68094], [-117.8289, 33.68179], [-117.82811, 33.68143], [-117.82745, 33.68091], [-117.82878, 33.67987], [-117.82897, 33.68003], [-117.82921, 33.68014], [-117.82967, 33.68029], [-117.82971, 33.6804]]]} | Open Access 1 | 12589 | San Carlo Park | 24843 | 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.87 | San Carlo Park | 0 | Local Park 2 | 4 | |
1587 | 1587 | 1586 | {"type": "Polygon", "coordinates": [[[-117.77409, 33.71255], [-117.7732, 33.71343], [-117.77171, 33.71241], [-117.77169, 33.71233], [-117.77257, 33.71147], [-117.77409, 33.71255]]]} | Open Access 1 | 12163 | Brywood Park | 16463 | 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.92 | Brywood Park | 0 | Local Park 2 | 4 | |
10887 | 10887 | 10886 | {"type": "Polygon", "coordinates": [[[-117.7503, 33.71658], [-117.74985, 33.71697], [-117.74946, 33.71734], [-117.74941, 33.71732], [-117.74938, 33.71735], [-117.74772, 33.71619], [-117.74855, 33.71536], [-117.7503, 33.71658]]]} | Open Access 1 | 48663 | Eastwood Neighborhood Park | 33410 | 6129 | Irvine Community Development Company LLC 961 | Private 7 | Commercial 20 | https://www.irvinecompany.com/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 6.129 | Eastwood Neighborhood 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 | |
8282 | 8282 | 8281 | {"type": "Polygon", "coordinates": [[[-117.76768, 33.70259], [-117.7671, 33.70293], [-117.76688, 33.70316], [-117.76682, 33.70343], [-117.76653, 33.70353], [-117.76634, 33.7037], [-117.76633, 33.70385], [-117.76636, 33.704], [-117.76646, 33.70411], [-117.76663, 33.70424], [-117.76638, 33.70419], [-117.76624, 33.70418], [-117.76602, 33.70419], [-117.7657, 33.70423], [-117.76538, 33.70434], [-117.76519, 33.70443], [-117.76502, 33.70455], [-117.76534, 33.70415], [-117.76561, 33.70363], [-117.76534, 33.70351], [-117.76541, 33.70338], [-117.76568, 33.70347], [-117.76587, 33.70308], [-117.76592, 33.70249], [-117.76603, 33.70223], [-117.76621, 33.70202], [-117.76652, 33.7022], [-117.76673, 33.70199], [-117.76685, 33.70205], [-117.7673, 33.7022], [-117.7675, 33.70235], [-117.76768, 33.70259]]]} | Open Access 1 | 12671 | Sycamore Park | 26135 | 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.61 | Sycamore Park | 0 | Local Park 2 | 4 | |
8123 | 8123 | 8122 | {"type": "Polygon", "coordinates": [[[-117.78277, 33.6636], [-117.78242, 33.66392], [-117.78272, 33.66416], [-117.7826, 33.66428], [-117.78273, 33.66438], [-117.78253, 33.66457], [-117.78248, 33.66455], [-117.78175, 33.66524], [-117.78151, 33.66504], [-117.78119, 33.66474], [-117.781, 33.66452], [-117.78071, 33.66412], [-117.78148, 33.66335], [-117.78185, 33.66295], [-117.78277, 33.6636]]]} | Open Access 1 | 12295 | Dovecreek Park | 18250 | 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.676 | Dovecreek Park | 0 | Local Park 2 | 4 | |
8077 | 8077 | 8076 | {"type": "Polygon", "coordinates": [[[-117.83152, 33.67279], [-117.83133, 33.67315], [-117.83052, 33.67296], [-117.83016, 33.67265], [-117.82986, 33.67252], [-117.82273, 33.67034], [-117.823, 33.6703], [-117.82332, 33.6703], [-117.82367, 33.67033], [-117.8246, 33.67054], [-117.83152, 33.67279]]]} | Open Access 1 | 12290 | Culverdale Wilderness Park | 17856 | 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.092 | Culverdale Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
6312 | 6312 | 6311 | {"type": "Polygon", "coordinates": [[[-117.79635, 33.70627], [-117.79619, 33.70614], [-117.79467, 33.70508], [-117.79443, 33.70532], [-117.79308, 33.7044], [-117.79319, 33.70427], [-117.79187, 33.70334], [-117.79207, 33.70313], [-117.79214, 33.70311], [-117.79243, 33.70331], [-117.79264, 33.70349], [-117.79273, 33.70352], [-117.79281, 33.70351], [-117.79285, 33.70349], [-117.79292, 33.70342], [-117.79295, 33.70343], [-117.79348, 33.70381], [-117.79351, 33.70381], [-117.79358, 33.7039], [-117.7937, 33.70395], [-117.79381, 33.70402], [-117.79392, 33.7041], [-117.79402, 33.70421], [-117.79409, 33.70424], [-117.79418, 33.70425], [-117.79419, 33.70428], [-117.79472, 33.70465], [-117.79486, 33.70463], [-117.79492, 33.7047], [-117.79514, 33.70481], [-117.79662, 33.70585], [-117.79666, 33.70592], [-117.79664, 33.70598], [-117.79635, 33.70627]]]} | Open Access 1 | 1481 | College Park | 17508 | 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.415 | College Park | 0 | Local Park 2 | 4 | |
8238 | 8238 | 8237 | {"type": "Polygon", "coordinates": [[[-117.78357, 33.68538], [-117.78346, 33.68549], [-117.78247, 33.68481], [-117.78228, 33.68483], [-117.78161, 33.68437], [-117.78136, 33.68462], [-117.78153, 33.68475], [-117.78151, 33.68477], [-117.78133, 33.68466], [-117.78082, 33.68517], [-117.78099, 33.6853], [-117.78097, 33.68533], [-117.78079, 33.68521], [-117.78054, 33.68546], [-117.78197, 33.68646], [-117.782, 33.68653], [-117.78226, 33.68672], [-117.78217, 33.68682], [-117.78149, 33.68635], [-117.78146, 33.68636], [-117.78143, 33.68634], [-117.78145, 33.68632], [-117.78079, 33.68586], [-117.78076, 33.68588], [-117.78073, 33.68586], [-117.78075, 33.68583], [-117.78014, 33.6854], [-117.78011, 33.68542], [-117.78008, 33.6854], [-117.78009, 33.68538], [-117.77949, 33.68495], [-117.77946, 33.68497], [-117.77943, 33.68495], [-117.77944, 33.68492], [-117.77888, 33.68454], [-117.77898, 33.68444], [-117.77919, 33.68459], [-117.77926, 33.68459], [-117.78039, 33.68536], [-117.78065, 33.6851], [-117.78048, 33.68498], [-117.7805, 33.68495], [-117.78068, 33.68507], [-117.78119, 33.68456], [-117.78102, 33.68443], [-117.78104, 33.6844], [-117.78122, 33.68452], [-117.78147, 33.68426], [-117.78112, 33.68403], [-117.78111, 33.68385], [-117.78008, 33.68313], [-117.78006, 33.68314], [-117.78001, 33.68342], [-117.77997, 33.68341], [-117.78003, 33.68311], [-117.77961, 33.68281], [-117.77947, 33.68295], [-117.77945, 33.68293], [-117.77958, 33.68278], [-117.77898, 33.68235], [-117.77882, 33.6825], [-117.7788, 33.68248], [-117.77894, 33.68233], [-117.77833, 33.6819], [-117.77818, 33.68204], [-117.77816, 33.68202], [-117.7783, 33.68187], [-117.77777, 33.6815], [-117.7779, 33.68141], [-117.78042, 33.6832], [-117.78069, 33.68339], [-117.78073, 33.68337], [-117.78076, 33.68338], [-117.78074, 33.68342], [-117.78129, 33.6838], [-117.78148, 33.68369], [-117.78152, 33.68372], [-117.78158, 33.68374], [-117.78169, 33.68372], [-117.78172, 33.68369], [-117.78193, 33.68383], [-117.78258, 33.68318], [-117.78291, 33.6834], [-117.78225, 33.68406], [-117.78245, 33.6842], [-117.78241, 33.68426], [-117.78241, 33.68432], [-117.78244, 33.68437], [-117.78251, 33.68441], [-117.78241, 33.68457], [-117.78296, 33.68496], [-117.783, 33.68494], [-117.78302, 33.68496], [-117.78301, 33.68499], [-117.78357, 33.68538]]]} | Open Access 1 | 12573 | Ranch Park | 24124 | 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.646 | Ranch Park | 0 | Local Park 2 | 4 | |
12866 | 12866 | 12865 | {"type": "Polygon", "coordinates": [[[-117.77295, 33.68528], [-117.76975, 33.68834], [-117.76927, 33.68793], [-117.77229, 33.68487], [-117.77295, 33.68528]]]} | Open Access 1 | 35914 | Irvine holding 21 | 20251 | 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.653 | Irvine holding 21 | 0 | Local Other or Unknown 14 | 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 | |
12773 | 12773 | 12772 | {"type": "Polygon", "coordinates": [[[-117.81919, 33.69143], [-117.81815, 33.69225], [-117.81662, 33.69096], [-117.81635, 33.69067], [-117.81731, 33.68984], [-117.81919, 33.69143]]]} | Open Access 1 | 30204 | Sweet Shade Park | 26103 | 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.023 | Sweet Shade 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 | |
1591 | 1591 | 1590 | {"type": "Polygon", "coordinates": [[[-117.81112, 33.68092], [-117.81023, 33.68179], [-117.80942, 33.68122], [-117.80909, 33.681], [-117.8088, 33.68086], [-117.80842, 33.68071], [-117.80825, 33.68067], [-117.80937, 33.67938], [-117.8095, 33.67936], [-117.81039, 33.68025], [-117.81076, 33.68057], [-117.81111, 33.68083], [-117.81112, 33.68092]]]} | Open Access 1 | 12152 | Mark Daily Athletic Field | 28277 | 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/mark_daily_athletic_field_.asp | Orange 3 | 8.387 | Mark Daily Athletic Field | 0 | Local Recreation Area 3 | 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 |
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 | |
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 | |
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 |
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]);