units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 477 sorted by map descending
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Recreation Area 13
- Local Park 9
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 30
MNG_AGENCY 1
- Tiburon, Town of · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15916 | 15916 | 15915 | {"type": "Polygon", "coordinates": [[[-122.51086, 37.90923], [-122.5069, 37.9092], [-122.50686, 37.90918], [-122.50306, 37.90921], [-122.50218, 37.90776], [-122.50302, 37.90743], [-122.50382, 37.90704], [-122.50459, 37.90659], [-122.50523, 37.90616], [-122.50608, 37.90588], [-122.50624, 37.90615], [-122.50765, 37.90465], [-122.5082, 37.905], [-122.50941, 37.90498], [-122.50947, 37.90505], [-122.50984, 37.90524], [-122.50995, 37.90525], [-122.50997, 37.90592], [-122.51064, 37.90591], [-122.51086, 37.90923]]]} | Open Access 1 | 5192 | La Cresta Open Space | 31729 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 64.864 | La Cresta OS | 0 | Local Recreation Area 3 | 4 | |
9520 | 9520 | 9519 | {"type": "Polygon", "coordinates": [[[-122.50289, 37.90165], [-122.50239, 37.90204], [-122.50187, 37.90202], [-122.50189, 37.90181], [-122.50194, 37.90176], [-122.50226, 37.90175], [-122.50289, 37.90165]]]} | Open Access 1 | 16193 | Cypress Hollow | 17874 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.527 | Cypress Hollow | None 789 | |||
9574 | 9574 | 9573 | {"type": "Polygon", "coordinates": [[[-122.4993, 37.90109], [-122.49923, 37.90188], [-122.499, 37.90181], [-122.49886, 37.90212], [-122.49882, 37.90211], [-122.49895, 37.9018], [-122.4988, 37.90175], [-122.49915, 37.90108], [-122.49924, 37.90077], [-122.49928, 37.90078], [-122.4992, 37.90108], [-122.4993, 37.90109]]]} | Open Access 1 | 16195 | Bel Aire Park | 15961 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.624 | Bel Aire Park | 0 | Local Park 2 | 4 | |
9585 | 9585 | 9584 | {"type": "Polygon", "coordinates": [[[-122.49781, 37.89952], [-122.49774, 37.89961], [-122.49721, 37.9006], [-122.49629, 37.90023], [-122.49657, 37.89917], [-122.49687, 37.89929], [-122.49723, 37.89941], [-122.49781, 37.89952]]]} | Open Access 1 | 16197 | Highlands Subdivision Open Space | 31738 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 3.057 | Highlands Subdivision OS | 0 | Local Recreation Area 3 | 4 | |
15946 | 15946 | 15945 | {"type": "Polygon", "coordinates": [[[-122.49232, 37.90311], [-122.49225, 37.90325], [-122.49196, 37.90343], [-122.49196, 37.90348], [-122.49198, 37.90352], [-122.49199, 37.90386], [-122.49192, 37.90395], [-122.49199, 37.9041], [-122.492, 37.90455], [-122.49193, 37.90467], [-122.49204, 37.90475], [-122.49206, 37.9049], [-122.49223, 37.90502], [-122.4922, 37.90522], [-122.492, 37.90539], [-122.4919, 37.90567], [-122.49166, 37.90576], [-122.49045, 37.90632], [-122.48946, 37.90655], [-122.48859, 37.90739], [-122.48821, 37.90809], [-122.48808, 37.90799], [-122.48758, 37.90775], [-122.48678, 37.9079], [-122.4841, 37.90617], [-122.48226, 37.90505], [-122.48228, 37.90351], [-122.48236, 37.90347], [-122.4834, 37.90319], [-122.48405, 37.90377], [-122.4842, 37.90472], [-122.48714, 37.9047], [-122.48831, 37.9043], [-122.48958, 37.90411], [-122.48988, 37.90429], [-122.49139, 37.90372], [-122.49135, 37.90342], [-122.4917, 37.90341], [-122.49171, 37.90309], [-122.49189, 37.90289], [-122.49232, 37.90311]]]} | Open Access 1 | 5195 | Atkinson Open Space Purchase | 31737 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 59.72 | Atkinson OS Purchase | None 1372 | |||
9408 | 9408 | 9407 | {"type": "Polygon", "coordinates": [[[-122.49207, 37.89502], [-122.49188, 37.89527], [-122.49079, 37.89555], [-122.49079, 37.89576], [-122.49092, 37.89579], [-122.49107, 37.8958], [-122.49135, 37.89577], [-122.49174, 37.89564], [-122.49186, 37.89557], [-122.49165, 37.8958], [-122.49147, 37.89584], [-122.49147, 37.89589], [-122.49077, 37.89627], [-122.49017, 37.89668], [-122.49009, 37.89668], [-122.49005, 37.89662], [-122.49015, 37.89626], [-122.49019, 37.89623], [-122.49024, 37.89622], [-122.49065, 37.89624], [-122.49071, 37.89601], [-122.49032, 37.89613], [-122.48994, 37.89615], [-122.48996, 37.89622], [-122.48981, 37.89665], [-122.48973, 37.89683], [-122.48963, 37.89702], [-122.48951, 37.89719], [-122.48936, 37.89734], [-122.48928, 37.89729], [-122.48902, 37.89749], [-122.48902, 37.8975], [-122.48907, 37.89755], [-122.48868, 37.89782], [-122.48855, 37.89788], [-122.48835, 37.89791], [-122.48817, 37.89789], [-122.48796, 37.89782], [-122.48779, 37.89769], [-122.48769, 37.89754], [-122.48766, 37.89745], [-122.48766, 37.89732], [-122.48779, 37.89686], [-122.48783, 37.89657], [-122.4878, 37.89631], [-122.48777, 37.89617], [-122.48768, 37.89598], [-122.48746, 37.89564], [-122.48724, 37.89534], [-122.487, 37.89509], [-122.48719, 37.895], [-122.48776, 37.89556], [-122.48818, 37.89532], [-122.4877, 37.89489], [-122.48822, 37.89497], [-122.48881, 37.89557], [-122.48955, 37.89554], [-122.48961, 37.89543], [-122.48971, 37.89544], [-122.49016, 37.89536], [-122.4916, 37.89498], [-122.49207, 37.89502]]]} | Open Access 1 | 47819 | Blackie's Pasture | 31743 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 15.452 | Blackie's Pasture | None 776 | |||
9618 | 9618 | 9617 | {"type": "Polygon", "coordinates": [[[-122.4896, 37.90065], [-122.48895, 37.9], [-122.48871, 37.89969], [-122.48866, 37.89959], [-122.48863, 37.89925], [-122.4886, 37.89911], [-122.48829, 37.89811], [-122.48851, 37.89808], [-122.48865, 37.89802], [-122.48898, 37.8993], [-122.48938, 37.90012], [-122.48955, 37.90034], [-122.4896, 37.90065]]]} | Open Access 1 | 16199 | Belveron Mini Park | 16001 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 2.094 | Belveron MP | 0 | Local Park 2 | 4 | |
14058 | 14058 | 14057 | {"type": "Polygon", "coordinates": [[[-122.48901, 37.89521], [-122.4888, 37.89557], [-122.48822, 37.89497], [-122.4877, 37.89489], [-122.48636, 37.89374], [-122.4861, 37.89391], [-122.48646, 37.89424], [-122.48719, 37.89499], [-122.487, 37.89509], [-122.4865, 37.89457], [-122.48594, 37.89402], [-122.48532, 37.89353], [-122.48479, 37.89316], [-122.48493, 37.89301], [-122.4846, 37.89232], [-122.48478, 37.8918], [-122.48451, 37.89148], [-122.48438, 37.89133], [-122.48415, 37.89126], [-122.4841, 37.89121], [-122.4843, 37.8909], [-122.48771, 37.89414], [-122.48858, 37.89488], [-122.48901, 37.89521]]]} | Open Access 1 | 38060 | McKegney Green | 31739 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 11.467 | McKegney Green | 0 | Local Park 2 | 4 | |
9648 | 9648 | 9647 | {"type": "Polygon", "coordinates": [[[-122.48842, 37.91763], [-122.48795, 37.91791], [-122.48781, 37.91709], [-122.48758, 37.91541], [-122.48838, 37.9154], [-122.48842, 37.91763]]]} | Open Access 1 | 16249 | Cibrian Subdivision Open Space | 31728 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 3.766 | Cibrian Subdivision OS | 0 | Local Recreation Area 3 | 4 | |
9649 | 9649 | 9648 | {"type": "Polygon", "coordinates": [[[-122.4874, 37.91851], [-122.48707, 37.91842], [-122.48695, 37.91845], [-122.48682, 37.91854], [-122.48674, 37.91869], [-122.48672, 37.91859], [-122.48665, 37.91847], [-122.48657, 37.91838], [-122.48643, 37.91829], [-122.48712, 37.91797], [-122.4874, 37.91851]]]} | Open Access 1 | 16251 | Hexan Subdivision Open Space Dedication | 19891 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.705 | Hexan Subdivision OS Dedication | None 823 | |||
9406 | 9406 | 9405 | {"type": "Polygon", "coordinates": [[[-122.48493, 37.89302], [-122.48424, 37.8926], [-122.48392, 37.89233], [-122.48365, 37.89224], [-122.48351, 37.89213], [-122.48321, 37.89188], [-122.48243, 37.89091], [-122.48254, 37.89103], [-122.48261, 37.89097], [-122.48262, 37.8908], [-122.48269, 37.89064], [-122.48315, 37.89035], [-122.4833, 37.89039], [-122.48364, 37.89071], [-122.48415, 37.89126], [-122.48438, 37.89133], [-122.48478, 37.8918], [-122.4846, 37.89232], [-122.48493, 37.89302]]]} | Open Access 1 | 47817 | South of the Knoll Park | 31741 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 6.518 | South of the Knoll Park | 0 | Local Park 2 | 4 | |
4965 | 4965 | 4964 | {"type": "Polygon", "coordinates": [[[-122.47464, 37.89116], [-122.47323, 37.89247], [-122.472, 37.89197], [-122.47116, 37.89161], [-122.4732, 37.89029], [-122.4737, 37.88994], [-122.47427, 37.89053], [-122.47464, 37.89116]]]} | Open Access 1 | 5216 | Hamon (Rock & Tree) Open Space | 31721 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 10.491 | Hamon (Rock & Tree) OS | 0 | Local Recreation Area 3 | 4 | |
3991 | 3991 | 3990 | {"type": "Polygon", "coordinates": [[[-122.47299, 37.88423], [-122.47287, 37.8843], [-122.47264, 37.88406], [-122.47257, 37.88396], [-122.47243, 37.88398], [-122.47246, 37.88381], [-122.47244, 37.88364], [-122.47251, 37.88362], [-122.47289, 37.88412], [-122.47299, 37.88423]]]} | Open Access 1 | 38063 | The Cypress Garden Park (Secred Garden) | 26280 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.299 | The Cypress Garden Park (Secred Garden) | None 347 | |||
16026 | 16026 | 16025 | {"type": "Polygon", "coordinates": [[[-122.47243, 37.89254], [-122.47257, 37.89352], [-122.47254, 37.89366], [-122.47248, 37.89376], [-122.47239, 37.89385], [-122.47204, 37.89357], [-122.46989, 37.89271], [-122.46896, 37.89222], [-122.46913, 37.89201], [-122.46947, 37.89194], [-122.4698, 37.89157], [-122.46984, 37.89147], [-122.46987, 37.89126], [-122.46985, 37.8911], [-122.46982, 37.89099], [-122.46993, 37.89073], [-122.47067, 37.89096], [-122.47116, 37.89161], [-122.472, 37.89197], [-122.47189, 37.89213], [-122.47183, 37.89229], [-122.4718, 37.89246], [-122.4718, 37.8926], [-122.47243, 37.89254]]]} | Open Access 1 | 5223 | Reed School District Open Space | 31736 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 11.783 | Reed School District OS | 0 | Local Recreation Area 3 | 4 | |
16126 | 16126 | 16125 | {"type": "Polygon", "coordinates": [[[-122.46627, 37.88243], [-122.46596, 37.8826], [-122.46576, 37.88273], [-122.46565, 37.88287], [-122.46555, 37.88303], [-122.4655, 37.88316], [-122.46552, 37.88329], [-122.46555, 37.88335], [-122.46562, 37.88343], [-122.46575, 37.88351], [-122.46532, 37.88373], [-122.46486, 37.88363], [-122.46499, 37.88319], [-122.4651, 37.8827], [-122.46546, 37.88242], [-122.4656, 37.88239], [-122.46621, 37.88245], [-122.46627, 37.88243]]]} | Open Access 1 | 16213 | Town Hall Area Open Space | 31733 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.96 | Town Hall Area OS | 0 | Local Recreation Area 3 | 4 | |
15999 | 15999 | 15998 | {"type": "Polygon", "coordinates": [[[-122.4659, 37.89032], [-122.46485, 37.89155], [-122.46381, 37.8928], [-122.46073, 37.89172], [-122.46105, 37.89101], [-122.46158, 37.89118], [-122.46276, 37.8913], [-122.46367, 37.89121], [-122.46381, 37.89117], [-122.46397, 37.89102], [-122.46408, 37.89096], [-122.46421, 37.89093], [-122.46439, 37.89093], [-122.4645, 37.89089], [-122.46457, 37.89084], [-122.46471, 37.89066], [-122.46482, 37.89063], [-122.46491, 37.89047], [-122.46501, 37.89047], [-122.46517, 37.89034], [-122.4653, 37.89028], [-122.46544, 37.89024], [-122.46559, 37.89024], [-122.46578, 37.89027], [-122.4659, 37.89032]], [[-122.46368, 37.89222], [-122.46368, 37.89224], [-122.46374, 37.89232], [-122.46391, 37.89226], [-122.46386, 37.89216], [-122.46368, 37.89222]]]} | Open Access 1 | 5229 | Mount Tiburon Subdivision Open Space | 31722 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 12.362 | Mount Tiburon Subdivision OS | 0 | Local Recreation Area 3 | 4 | |
16124 | 16124 | 16123 | {"type": "Polygon", "coordinates": [[[-122.46579, 37.89233], [-122.46575, 37.89237], [-122.46477, 37.89165], [-122.46485, 37.89155], [-122.46516, 37.89151], [-122.46534, 37.89166], [-122.46538, 37.89171], [-122.46544, 37.89207], [-122.46579, 37.89233]]]} | Open Access 1 | 16201 | Agins Subdivision Open Space Dedication | 15286 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 0.542 | Agins Subdivision OS Dedication | None 1386 | |||
2165 | 2165 | 2164 | {"type": "Polygon", "coordinates": [[[-122.46492, 37.8834], [-122.46484, 37.88369], [-122.4639, 37.88347], [-122.46345, 37.88363], [-122.46344, 37.88329], [-122.46354, 37.88316], [-122.46369, 37.88317], [-122.46398, 37.88297], [-122.46492, 37.8834]]]} | Open Access 1 | 16215 | Reed Park | 24257 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.451 | Reed Park | 0 | Local Park 2 | 4 | |
16030 | 16030 | 16029 | {"type": "Polygon", "coordinates": [[[-122.46262, 37.88628], [-122.46194, 37.88753], [-122.46228, 37.88826], [-122.46203, 37.88883], [-122.46196, 37.88881], [-122.4622, 37.88825], [-122.46187, 37.88752], [-122.46244, 37.88647], [-122.46247, 37.88632], [-122.46244, 37.88621], [-122.46238, 37.88612], [-122.46202, 37.88574], [-122.46178, 37.88559], [-122.46163, 37.88555], [-122.46145, 37.88555], [-122.46137, 37.88558], [-122.46098, 37.88576], [-122.46088, 37.88583], [-122.4608, 37.88591], [-122.46058, 37.88632], [-122.45992, 37.8867], [-122.45884, 37.88729], [-122.45859, 37.88716], [-122.45997, 37.88649], [-122.46005, 37.88643], [-122.4601, 37.88635], [-122.46014, 37.88627], [-122.46014, 37.88621], [-122.46013, 37.88612], [-122.46006, 37.88601], [-122.45998, 37.88594], [-122.45989, 37.8859], [-122.45976, 37.88587], [-122.4593, 37.88584], [-122.45902, 37.88578], [-122.45852, 37.88564], [-122.45852, 37.8856], [-122.45892, 37.88563], [-122.45893, 37.88562], [-122.45892, 37.88559], [-122.45949, 37.88556], [-122.45993, 37.88558], [-122.46045, 37.88565], [-122.46068, 37.88563], [-122.4609, 37.88557], [-122.46112, 37.88544], [-122.46123, 37.88533], [-122.46127, 37.88526], [-122.46129, 37.88515], [-122.46128, 37.88503], [-122.46124, 37.88493], [-122.46116, 37.88484], [-122.46106, 37.88476], [-122.46088, 37.88466], [-122.46073, 37.8846], [-122.46025, 37.8845], [-122.46002, 37.88441], [-122.45985, 37.88429], [-122.45966, 37.88409], [-122.45902, 37.88413], [-122.4589, 37.88426], [-122.45871, 37.88418], [-122.45883, 37.88394], [-122.45949, 37.88386], [-122.45929, 37.88352], [-122.45912, 37.8832], [-122.45898, 37.88287], [-122.46164, 37.88514], [-122.4616, 37.88539], [-122.46206, 37.8857], [-122.46262, 37.88628]]]} | Restricted Access 2 | 5233 | Marinero Owner's Association Open Space Areas | 21856 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 6.995 | Marinero Owner's Association OS Areas | None 1375 | |||
2149 | 2149 | 2148 | {"type": "Polygon", "coordinates": [[[-122.46161, 37.87736], [-122.46118, 37.87759], [-122.46109, 37.87757], [-122.46043, 37.87756], [-122.46026, 37.87689], [-122.46161, 37.87736]]]} | Open Access 1 | 16016 | Zelinksy Park | 27860 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.209 | Zelinksy 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]);