units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 1, COUNTY = 23 and MNG_AGENCY = 477
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2148 | 2148 | 2147 | {"type": "Polygon", "coordinates": [[[-122.45562, 37.87341], [-122.4553, 37.87328], [-122.45521, 37.87326], [-122.45512, 37.87316], [-122.45502, 37.87312], [-122.45478, 37.87315], [-122.45449, 37.87308], [-122.45431, 37.87305], [-122.45404, 37.87304], [-122.45367, 37.87306], [-122.45342, 37.87306], [-122.45289, 37.873], [-122.45271, 37.87296], [-122.45245, 37.87285], [-122.45194, 37.87251], [-122.45148, 37.87227], [-122.45132, 37.87221], [-122.45115, 37.87218], [-122.45097, 37.87216], [-122.45081, 37.87217], [-122.45072, 37.87209], [-122.45083, 37.87205], [-122.45113, 37.87203], [-122.45149, 37.87219], [-122.45178, 37.87229], [-122.45235, 37.87243], [-122.4524, 37.87249], [-122.45241, 37.87261], [-122.45251, 37.87268], [-122.45275, 37.87272], [-122.45302, 37.87274], [-122.45325, 37.8728], [-122.45363, 37.87285], [-122.45414, 37.87291], [-122.45457, 37.87293], [-122.45485, 37.87296], [-122.45543, 37.87296], [-122.45562, 37.87341]]]} | Open Access 1 | 16015 | Point Tiburon Shoreline Park | 31724 | 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.267 | Point Tiburon Shoreline Park | 0 | Local Park 2 | 4 | |
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 | |
2164 | 2164 | 2163 | {"type": "Polygon", "coordinates": [[[-122.46072, 37.88392], [-122.46059, 37.88424], [-122.45967, 37.88345], [-122.4601, 37.88337], [-122.46015, 37.88347], [-122.46026, 37.88361], [-122.46059, 37.88387], [-122.46072, 37.88392]]]} | Open Access 1 | 16209 | Marinero Circle Park | 21855 | 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.726 | Marinero Circle Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |||
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 | |
6764 | 6764 | 6763 | {"type": "MultiPolygon", "coordinates": [[[[-122.47044, 37.88282], [-122.47137, 37.88329], [-122.47177, 37.88352], [-122.47191, 37.88361], [-122.47229, 37.88394], [-122.47228, 37.88408], [-122.47155, 37.88354], [-122.47113, 37.88331], [-122.47071, 37.88311], [-122.46655, 37.88146], [-122.46617, 37.88128], [-122.46582, 37.88107], [-122.46549, 37.88084], [-122.46519, 37.88058], [-122.46485, 37.88023], [-122.46461, 37.87994], [-122.46398, 37.87905], [-122.46375, 37.87876], [-122.46349, 37.87828], [-122.46366, 37.87841], [-122.46393, 37.87866], [-122.46418, 37.87896], [-122.46473, 37.87971], [-122.46513, 37.88021], [-122.46543, 37.88051], [-122.46589, 37.88086], [-122.46654, 37.88124], [-122.46914, 37.88228], [-122.47044, 37.88282]]], [[[-122.48493, 37.89302], [-122.48479, 37.89316], [-122.48443, 37.89294], [-122.48444, 37.89292], [-122.48369, 37.89248], [-122.48336, 37.89224], [-122.48307, 37.89199], [-122.48301, 37.8919], [-122.4828, 37.89168], [-122.48218, 37.89088], [-122.4819, 37.89053], [-122.48142, 37.89016], [-122.48098, 37.88989], [-122.48092, 37.88992], [-122.48079, 37.88983], [-122.48052, 37.8897], [-122.47978, 37.88947], [-122.47892, 37.88905], [-122.47831, 37.88872], [-122.47672, 37.88778], [-122.4767, 37.88778], [-122.47506, 37.88663], [-122.47435, 37.88604], [-122.47238, 37.88426], [-122.47239, 37.88407], [-122.47364, 37.88519], [-122.4749, 37.88627], [-122.47624, 37.88729], [-122.47681, 37.88766], [-122.47834, 37.88856], [-122.47903, 37.88892], [-122.47991, 37.88929], [-122.48072, 37.88955], [-122.48094, 37.88965], [-122.48151, 37.88999], [-122.48174, 37.89016], [-122.48195, 37.89034], [-122.48214, 37.89054], [-122.48321, 37.89188], [-122.48365, 37.89224], [-122.48392, 37.89233], [-122.48424, 37.8926], [-122.48493, 37.89302]]]]} | Open Access 1 | 5206 | Richardson Bay Lineal Park | 31740 | 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.345 | Richardson Bay Lineal Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |||
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 | |||
9545 | 9545 | 9544 | {"type": "Polygon", "coordinates": [[[-122.46118, 37.87759], [-122.45971, 37.87832], [-122.45958, 37.87819], [-122.45957, 37.87799], [-122.45885, 37.87784], [-122.45815, 37.87728], [-122.45822, 37.87699], [-122.45809, 37.87672], [-122.45816, 37.87668], [-122.45819, 37.87673], [-122.45856, 37.87686], [-122.45859, 37.87692], [-122.45916, 37.87712], [-122.45932, 37.87708], [-122.45968, 37.87719], [-122.45991, 37.87676], [-122.46026, 37.87689], [-122.46044, 37.87756], [-122.46109, 37.87757], [-122.46118, 37.87759]]]} | Open Access 1 | 16017 | Point Tiburon Marsh Open Space | 31727 | 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 | 5.403 | Point Tiburon Marsh OS | 0 | Local Recreation Area 3 | 4 | |
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 | |
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 | |
9619 | 9619 | 9618 | {"type": "Polygon", "coordinates": [[[-122.46119, 37.8907], [-122.46073, 37.89172], [-122.45801, 37.89065], [-122.45771, 37.88931], [-122.45845, 37.88865], [-122.45858, 37.88869], [-122.45861, 37.88868], [-122.45879, 37.88885], [-122.45838, 37.88911], [-122.45896, 37.88978], [-122.45957, 37.89038], [-122.4598, 37.89052], [-122.46009, 37.89063], [-122.4603, 37.89067], [-122.46077, 37.89072], [-122.46083, 37.89038], [-122.46102, 37.89049], [-122.4611, 37.89062], [-122.46119, 37.8907]]]} | Open Access 1 | 16203 | El Marinero Subdivision Open Space | 31735 | 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 | 9.298 | El Marinero Subdivision OS | 0 | Local Recreation Area 3 | 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 | |||
11298 | 11298 | 11297 | {"type": "Polygon", "coordinates": [[[-122.45841, 37.87645], [-122.45823, 37.87652], [-122.45816, 37.87667], [-122.45809, 37.87672], [-122.4576, 37.87652], [-122.45715, 37.87631], [-122.45674, 37.87606], [-122.45731, 37.87592], [-122.45747, 37.87592], [-122.45757, 37.87595], [-122.45798, 37.87625], [-122.45807, 37.87628], [-122.45822, 37.87628], [-122.45833, 37.87639], [-122.45841, 37.87645]]]} | Open Access 1 | 22044 | Point Tiburon Tennis Courts | 31725 | 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.433 | Point Tiburon Tennis Courts | 0 | Local Recreation Area 3 | 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 | |
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 |
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]);