units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where YR_EST = 2018
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, DES_TP
MNG_AG_TYP 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
409 | 409 | 408 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | 48353 | Sean Diamond Park | 32917 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | Alameda 17 | 4.986 | Sean Diamond Park | 2018 | Local Park 2 | 4 |
497 | 497 | 496 | {"type": "Polygon", "coordinates": [[[-117.31082, 33.65409], [-117.31079, 33.65427], [-117.30502, 33.65344], [-117.30504, 33.65336], [-117.30568, 33.65345], [-117.30583, 33.65264], [-117.30709, 33.65186], [-117.30779, 33.65154], [-117.30788, 33.65166], [-117.30804, 33.65157], [-117.30845, 33.65132], [-117.30899, 33.65089], [-117.31082, 33.65409]]]} | Open Access 1 | 48360 | Summerly Community Park | 32925 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/city-hall/community-services/parks-and-facilities/parks/summerly-park-2232#ad-image-3 | Riverside 10 | 24.134 | Summerly Community Park | 2018 | Local Park 2 | 4 |
1691 | 1691 | 1690 | {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80459, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.80331, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14431], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14253], [-118.8046, 34.14314], [-118.80376, 34.14324], [-118.80375, 34.14354], [-118.80397, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.14419], [-118.80576, 34.14426]]]} | Open Access 1 | 12745 | Westlake Village City Parkland | 27404 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 24.679 | Westlake Village City Parkland | 2018 | Local Park 2 | 4 | |
2818 | 2818 | 2817 | {"type": "Polygon", "coordinates": [[[-122.11574, 38.47849], [-122.11574, 38.47849], [-122.11078, 38.47847], [-122.1109, 38.47791], [-122.11112, 38.47745], [-122.11138, 38.47716], [-122.11159, 38.47699], [-122.11178, 38.47681], [-122.11211, 38.47637], [-122.11245, 38.47602], [-122.11269, 38.47575], [-122.11301, 38.4753], [-122.1131, 38.47522], [-122.11313, 38.47502], [-122.11317, 38.47487], [-122.1155, 38.47489], [-122.11574, 38.47849]]]} | Open Access 1 | 48612 | Huber Ranch | 33327 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Napa 11 | 32.139 | Huber Ranch | 2018 | Private Conservation 16 | 2 |
2819 | 2819 | 2818 | {"type": "Polygon", "coordinates": [[[-122.113, 38.47524], [-122.1129, 38.47543], [-122.11277, 38.47564], [-122.11254, 38.47593], [-122.11209, 38.4764], [-122.11176, 38.47685], [-122.11121, 38.47734], [-122.11105, 38.47756], [-122.11094, 38.47777], [-122.11086, 38.47808], [-122.11081, 38.4784], [-122.11074, 38.47867], [-122.09694, 38.47855], [-122.09695, 38.47505], [-122.113, 38.47524]]]} | Open Access 1 | 48613 | Huber Ranch | 33327 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Solano 26 | 122.632 | Huber Ranch | 2018 | Private Conservation 16 | 2 |
3100 | 3100 | 3099 | {"type": "Polygon", "coordinates": [[[-121.7493, 38.65674], [-121.7482, 38.65674], [-121.74816, 38.65671], [-121.74818, 38.65582], [-121.74873, 38.65584], [-121.7493, 38.65631], [-121.7493, 38.65674]]]} | Open Access 1 | 48688 | Spring Lake Park | 33427 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | https://www.cityofwoodland.org/Facilities/Facility/Details/Spring-Lake-Park-23 | Yolo 33 | 2.116 | Spring Lake Park | 2018 | Local Park 2 | 4 |
4166 | 4166 | 4165 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | 48291 | Margaret G Scotten School Ballfields | 32866 | 2429 | Grass Valley School District 728 | Special District 4 | School District 14 | www.gvsd.us | Special District 4 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 8.566 | Margaret G Scotten School Ballfields | 2018 | None 361 | ||
4303 | 4303 | 4302 | {"type": "Polygon", "coordinates": [[[-117.74684, 34.02858], [-117.74645, 34.02859], [-117.74644, 34.02843], [-117.74684, 34.02842], [-117.74684, 34.02858]]]} | Open Access 1 | 48156 | Esperanza y Alegria Park | 32693 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 0.165 | Esperanza y Alegria Park | 2018 | Local Park 2 | 4 | |
4982 | 4982 | 4981 | {"type": "Polygon", "coordinates": [[[-118.69531, 34.53365], [-118.68395, 34.54742], [-118.66213, 34.52116], [-118.67143, 34.51291], [-118.67786, 34.51284], [-118.67792, 34.52747], [-118.69514, 34.52747], [-118.69531, 34.53365]]]} | Open Access 1 | 48529 | Temescal Ranch Open Space | 33243 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1228.189 | Temescal Ranch OS | 2018 | Local Recreation Area 3 | 4 | |
5476 | 5476 | 5475 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80433], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | 49032 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.247 | Christine Anderson Park | 2018 | Local Park 2 | 4 | |
6186 | 6186 | 6185 | {"type": "Polygon", "coordinates": [[[-121.85783, 37.71464], [-121.85783, 37.71473], [-121.85752, 37.71497], [-121.85728, 37.71519], [-121.85684, 37.71563], [-121.85657, 37.71602], [-121.85649, 37.71603], [-121.85605, 37.71585], [-121.85602, 37.71588], [-121.85346, 37.71482], [-121.85305, 37.71458], [-121.8528, 37.71439], [-121.85265, 37.71425], [-121.85239, 37.71397], [-121.85226, 37.71378], [-121.85214, 37.71356], [-121.85206, 37.71337], [-121.85199, 37.71316], [-121.85194, 37.71283], [-121.85194, 37.71254], [-121.85207, 37.71144], [-121.85213, 37.71121], [-121.85217, 37.71065], [-121.85226, 37.71059], [-121.8536, 37.71047], [-121.85423, 37.71036], [-121.85473, 37.71025], [-121.85511, 37.71013], [-121.85563, 37.70992], [-121.85597, 37.70976], [-121.85643, 37.7095], [-121.85715, 37.70914], [-121.85726, 37.70917], [-121.85745, 37.70949], [-121.85759, 37.70985], [-121.85766, 37.71022], [-121.85766, 37.71057], [-121.85762, 37.71079], [-121.85756, 37.71101], [-121.85703, 37.71255], [-121.85698, 37.7128], [-121.85697, 37.71317], [-121.85701, 37.71341], [-121.85708, 37.71364], [-121.85725, 37.71398], [-121.85748, 37.71429], [-121.85783, 37.71464]]]} | Open Access 1 | 48347 | Fallon Sports Park | 32911 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Fallon-Sports-Park-22 | Alameda 17 | 65.297 | Fallon Sports Park | 2018 | Local Recreation Area 3 | 4 |
6187 | 6187 | 6186 | {"type": "Polygon", "coordinates": [[[-121.84712, 37.7135], [-121.84714, 37.71357], [-121.8472, 37.71362], [-121.84726, 37.71372], [-121.84732, 37.71388], [-121.84734, 37.71403], [-121.84733, 37.71419], [-121.84728, 37.71435], [-121.8472, 37.71449], [-121.84701, 37.71468], [-121.84686, 37.71478], [-121.84668, 37.71486], [-121.84649, 37.71491], [-121.84569, 37.71507], [-121.84554, 37.71508], [-121.84533, 37.71505], [-121.8452, 37.71499], [-121.84505, 37.71487], [-121.84496, 37.71472], [-121.84487, 37.71469], [-121.84546, 37.71433], [-121.84589, 37.71411], [-121.84639, 37.7139], [-121.8468, 37.71366], [-121.84707, 37.71355], [-121.84712, 37.7135]]]} | Open Access 1 | 48348 | Jordan Ranch Park | 32912 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://ca-dublin2.civicplus.com/Facilities/Facility/Details/Jordan-Ranch-Park-31 | Alameda 17 | 4.982 | Jordan Ranch Park | 2018 | Local Park 2 | 4 |
7173 | 7173 | 7172 | {"type": "Polygon", "coordinates": [[[-121.68319, 37.99308], [-121.68317, 37.99514], [-121.6831, 37.99517], [-121.68169, 37.99516], [-121.68154, 37.99513], [-121.68139, 37.99508], [-121.68127, 37.99501], [-121.68116, 37.99491], [-121.68105, 37.99475], [-121.68102, 37.99462], [-121.68104, 37.99363], [-121.68108, 37.99345], [-121.68114, 37.99333], [-121.68123, 37.99324], [-121.68141, 37.99312], [-121.68156, 37.99307], [-121.68171, 37.99305], [-121.68312, 37.99305], [-121.68319, 37.99308]]]} | Open Access 1 | 48432 | Emerson Ranch Park | 33133 | 1229 | Oakley, City of 255 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | https://www.ci.oakley.ca.us/parks-and-landscape/park-and-landscape-capital-projects/ | Contra Costa 12 | 10.497 | Emerson Ranch Park | 2018 | Local Park 2 | 4 |
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86063], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | 6600 | DeForest Park | 18015 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 34.12 | DeForest Park | 2018 | Local Park 2 | 4 | |
7402 | 7402 | 7401 | {"type": "Polygon", "coordinates": [[[-120.86774, 37.60385], [-120.86552, 37.60384], [-120.86554, 37.60217], [-120.8656, 37.60212], [-120.8669, 37.60212], [-120.86691, 37.60254], [-120.86681, 37.60254], [-120.86682, 37.60268], [-120.867, 37.60268], [-120.86701, 37.60262], [-120.86773, 37.60261], [-120.86774, 37.60385]]]} | Open Access 1 | 48438 | Lebright Fields | 33140 | 1140 | Hughson, City of 863 | City 2 | City Agency 2 | http://hughson.org/government/city-departments/parks-and-recreations/ | City 2 | 1140 | Hughson, City of 841 | City 2 | City Agency 2 | Stanislaus 2 | 8.156 | Lebright Fields | 2018 | Local Recreation Area 3 | 4 | |
7555 | 7555 | 7554 | {"type": "Polygon", "coordinates": [[[-117.02716, 32.57161], [-117.02625, 32.5719], [-117.02589, 32.5711], [-117.02577, 32.57094], [-117.02564, 32.57082], [-117.02547, 32.57071], [-117.02522, 32.5706], [-117.02501, 32.57054], [-117.02477, 32.57052], [-117.02459, 32.57053], [-117.02427, 32.5706], [-117.02399, 32.57074], [-117.02375, 32.57093], [-117.02269, 32.57021], [-117.02263, 32.56916], [-117.02312, 32.56929], [-117.0232, 32.5694], [-117.02325, 32.56944], [-117.02381, 32.56969], [-117.02395, 32.56992], [-117.02418, 32.56988], [-117.02471, 32.56986], [-117.02489, 32.56983], [-117.02503, 32.56978], [-117.02526, 32.56966], [-117.0254, 32.56956], [-117.02554, 32.56942], [-117.02626, 32.56929], [-117.02631, 32.56932], [-117.02656, 32.56937], [-117.02697, 32.56951], [-117.02698, 32.57062], [-117.02715, 32.57064], [-117.02716, 32.57161]]]} | Open Access 1 | 47618 | Cesar Solis Park | 31542 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 15.465 | Cesar Solis Park | 2018 | Local Park 2 | 4 | |
8386 | 8386 | 8385 | {"type": "Polygon", "coordinates": [[[-122.41835, 37.78009], [-122.41831, 37.78014], [-122.41724, 37.78028], [-122.41712, 37.78022], [-122.41685, 37.77889], [-122.41694, 37.77881], [-122.41802, 37.77868], [-122.41807, 37.77871], [-122.41835, 37.78009]]]} | Open Access 1 | 12974 | Helen Diller Civic Center Playgrounds | 31697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.432 | Helen Diller Civic Ctr. Playgrounds | 2018 | None 703 | ||
9417 | 9417 | 9416 | {"type": "Polygon", "coordinates": [[[-118.18057, 33.81348], [-118.18057, 33.81362], [-118.18053, 33.8138], [-118.18, 33.81378], [-118.17999, 33.81348], [-118.18057, 33.81348]]]} | Open Access 1 | 47825 | Signal Hill Dog Park | 31767 | 1334 | Signal Hill, City of 371 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/Facilities/Facility/Details/Signal-Hill-Dog-Park-27 | Los Angeles 6 | 0.441 | Signal Hill Dog Park | 2018 | Local Park 2 | 4 |
9625 | 9625 | 9624 | {"type": "MultiPolygon", "coordinates": [[[[-122.7194, 38.39457], [-122.71939, 38.39494], [-122.71929, 38.39502], [-122.7191, 38.39504], [-122.71903, 38.39508], [-122.719, 38.39512], [-122.71863, 38.39513], [-122.71863, 38.39457], [-122.71871, 38.3945], [-122.71931, 38.3945], [-122.7194, 38.39457]]], [[[-122.72084, 38.39557], [-122.72046, 38.39557], [-122.72045, 38.39548], [-122.7203, 38.39548], [-122.72019, 38.39556], [-122.71965, 38.39556], [-122.71958, 38.39553], [-122.71956, 38.39549], [-122.71957, 38.39456], [-122.71966, 38.39449], [-122.72027, 38.39449], [-122.72028, 38.39452], [-122.72083, 38.39452], [-122.72084, 38.39557]]]]} | Open Access 1 | 47845 | Andy's Unity Park | 31788 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | https://parks.sonomacounty.ca.gov/Visit/Andys-Unity-Park/ | Sonoma 16 | 4.213 | Andy's Unity Park | 2018 | Local Park 2 | 4 |
9626 | 9626 | 9625 | {"type": "Polygon", "coordinates": [[[-122.58436, 38.47825], [-122.57965, 38.47824], [-122.57935, 38.47459], [-122.58412, 38.47455], [-122.58436, 38.47825]]]} | No Public Access 3 | 47847 | Santa Rosa Creek Redwoods | 31790 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 41.704 | Santa Rosa Creek Redwoods | 2018 | Private Conservation 16 | 2 |
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]);