units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST, GAP_STS
DES_TP 10
- Local Park 192
- Local Recreation Area 18
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- Sacramento, City of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14674 | 14674 | 14673 | {"type": "Polygon", "coordinates": [[[-121.5578, 38.65543], [-121.55595, 38.65546], [-121.55593, 38.65492], [-121.55599, 38.65492], [-121.55604, 38.65499], [-121.55611, 38.65503], [-121.55632, 38.65504], [-121.55638, 38.65503], [-121.55644, 38.65499], [-121.55649, 38.65494], [-121.5565, 38.65489], [-121.55648, 38.65446], [-121.55643, 38.65405], [-121.55633, 38.65365], [-121.55621, 38.65325], [-121.55595, 38.65267], [-121.55548, 38.65187], [-121.55526, 38.65142], [-121.55486, 38.65042], [-121.5548, 38.6502], [-121.55477, 38.64995], [-121.55469, 38.64975], [-121.55457, 38.64959], [-121.55441, 38.64946], [-121.55427, 38.64938], [-121.55407, 38.64929], [-121.55396, 38.64921], [-121.55387, 38.64911], [-121.55382, 38.64901], [-121.5538, 38.64891], [-121.5538, 38.6488], [-121.55395, 38.64848], [-121.55398, 38.64826], [-121.55396, 38.64769], [-121.55393, 38.64752], [-121.55384, 38.64732], [-121.55333, 38.64648], [-121.55242, 38.64482], [-121.55236, 38.64477], [-121.55228, 38.64475], [-121.5522, 38.64476], [-121.55205, 38.64481], [-121.552, 38.64485], [-121.55196, 38.6449], [-121.55196, 38.64494], [-121.55197, 38.645], [-121.55192, 38.64502], [-121.55163, 38.64479], [-121.55185, 38.64462], [-121.55194, 38.64452], [-121.55201, 38.64437], [-121.55204, 38.64422], [-121.55201, 38.64405], [-121.55187, 38.64377], [-121.55178, 38.64364], [-121.55165, 38.64352], [-121.55141, 38.6434], [-121.55044, 38.64309], [-121.55027, 38.643], [-121.55022, 38.64299], [-121.55015, 38.643], [-121.55009, 38.64304], [-121.55005, 38.64313], [-121.5499, 38.64332], [-121.54975, 38.64346], [-121.54958, 38.64358], [-121.54937, 38.64369], [-121.54921, 38.64375], [-121.549, 38.6438], [-121.5488, 38.64383], [-121.54843, 38.64384], [-121.5482, 38.64381], [-121.54801, 38.64377], [-121.54765, 38.64362], [-121.54733, 38.64343], [-121.54724, 38.64336], [-121.54713, 38.64334], [-121.54705, 38.64337], [-121.547, 38.64344], [-121.54692, 38.64351], [-121.54636, 38.64384], [-121.5459, 38.64417], [-121.54571, 38.64427], [-121.54544, 38.64432], [-121.54433, 38.64434], [-121.54408, 38.64439], [-121.54399, 38.64436], [-121.54382, 38.64412], [-121.54359, 38.6439], [-121.54336, 38.64375], [-121.54305, 38.6436], [-121.54074, 38.64294], [-121.54036, 38.64288], [-121.53986, 38.64287], [-121.53984, 38.64283], [-121.53984, 38.64233], [-121.54182, 38.643], [-121.54315, 38.64333], [-121.54372, 38.64357], [-121.54509, 38.64385], [-121.54629, 38.6436], [-121.54632, 38.64308], [-121.54656, 38.64288], [-121.54706, 38.64294], [-121.54799, 38.64325], [-121.54852, 38.64336], [-121.54913, 38.64326], [-121.54949, 38.64294], [-121.5498, 38.64235], [-121.55017, 38.64227], [-121.55094, 38.6425], [-121.5522, 38.64321], [-121.5531, 38.6451], [-121.5538, 38.64639], [-121.5547, 38.64791], [-121.5545, 38.64835], [-121.55498, 38.64935], [-121.55531, 38.65028], [-121.55584, 38.65162], [-121.55617, 38.65217], [-121.55665, 38.6529], [-121.5568, 38.65357], [-121.55703, 38.65396], [-121.5578, 38.65543]]]} | Open Access 1 | 44944 | Fisherman's Lake Parkway and Open Space | 18922 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 33.711 | Fisherman's Lake Parkway and OS | 0 | Local Recreation Area 3 | 4 | |
11079 | 11079 | 11078 | {"type": "Polygon", "coordinates": [[[-121.55006, 38.64762], [-121.5497, 38.64762], [-121.5496, 38.64772], [-121.54954, 38.6477], [-121.54901, 38.64771], [-121.54896, 38.64772], [-121.54886, 38.64763], [-121.54849, 38.64763], [-121.54847, 38.6466], [-121.5485, 38.64646], [-121.54858, 38.64634], [-121.54874, 38.6462], [-121.54891, 38.64608], [-121.54904, 38.64602], [-121.54922, 38.646], [-121.54938, 38.646], [-121.54954, 38.64605], [-121.54965, 38.6461], [-121.54987, 38.64625], [-121.54998, 38.64638], [-121.55002, 38.64645], [-121.55005, 38.64655], [-121.55006, 38.64762]]]} | Open Access 1 | 21282 | Swainson's Hawk Park Site | 26091 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.696 | Swainson's Hawk Park Site | 0 | Local Park 2 | 4 | |
16169 | 16169 | 16168 | {"type": "Polygon", "coordinates": [[[-121.55005, 38.66466], [-121.54694, 38.6659], [-121.54689, 38.66578], [-121.54685, 38.66564], [-121.54679, 38.66557], [-121.54683, 38.66554], [-121.54681, 38.66549], [-121.5491, 38.66457], [-121.55005, 38.66416], [-121.55005, 38.66466]]]} | Open Access 1 | 21125 | Egret Park Open Space | 18469 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.605 | Egret Park OS | 0 | Local Recreation Area 3 | 4 | |
11037 | 11037 | 11036 | {"type": "Polygon", "coordinates": [[[-121.54983, 38.50739], [-121.54826, 38.50827], [-121.54806, 38.50804], [-121.54828, 38.5079], [-121.54789, 38.50745], [-121.54906, 38.50678], [-121.54983, 38.50739]]]} | Open Access 1 | 21213 | Lewis Park | 21193 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.309 | Lewis Park | 0 | Local Park 2 | 4 | |
10989 | 10989 | 10988 | {"type": "Polygon", "coordinates": [[[-121.54805, 38.65366], [-121.54371, 38.65373], [-121.54371, 38.65373], [-121.54373, 38.65347], [-121.54381, 38.6532], [-121.5441, 38.65269], [-121.54414, 38.65266], [-121.54417, 38.65266], [-121.54447, 38.65269], [-121.54786, 38.65266], [-121.54803, 38.65268], [-121.54805, 38.65366]]]} | Open Access 1 | 21054 | Blackbird Park Site | 16141 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 10.178 | Blackbird Park Site | 0 | Local Park 2 | 4 | |
10992 | 10992 | 10991 | {"type": "Polygon", "coordinates": [[[-121.54774, 38.6485], [-121.5477, 38.64854], [-121.54769, 38.64858], [-121.5477, 38.64918], [-121.54773, 38.64925], [-121.54759, 38.64935], [-121.5476, 38.6497], [-121.54756, 38.64976], [-121.54748, 38.64975], [-121.54687, 38.64977], [-121.54666, 38.64982], [-121.54646, 38.64992], [-121.54643, 38.64804], [-121.54763, 38.64803], [-121.54764, 38.64837], [-121.54774, 38.6485]]]} | Open Access 1 | 21057 | Warbler Park Site | 27253 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.085 | Warbler Park Site | 0 | Local Park 2 | 4 | |
11065 | 11065 | 11064 | {"type": "Polygon", "coordinates": [[[-121.54712, 38.65619], [-121.5467, 38.65619], [-121.54661, 38.65617], [-121.54594, 38.65752], [-121.5455, 38.65742], [-121.5451, 38.65737], [-121.54468, 38.65737], [-121.54412, 38.65744], [-121.54408, 38.65743], [-121.54405, 38.65739], [-121.54394, 38.65712], [-121.54385, 38.6568], [-121.54377, 38.65637], [-121.54375, 38.65586], [-121.54377, 38.65583], [-121.54383, 38.6558], [-121.5468, 38.65578], [-121.54677, 38.65586], [-121.54711, 38.65586], [-121.54712, 38.65619]]]} | Open Access 1 | 21259 | Westlake Community Park | 27401 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 10.226 | Westlake Community Park | 0 | Local Park 2 | 4 | |
11074 | 11074 | 11073 | {"type": "Polygon", "coordinates": [[[-121.54694, 38.6659], [-121.54415, 38.66702], [-121.54415, 38.66693], [-121.54407, 38.66681], [-121.54401, 38.66683], [-121.5437, 38.66634], [-121.54462, 38.66597], [-121.54509, 38.66576], [-121.54527, 38.66603], [-121.54537, 38.66599], [-121.54548, 38.66591], [-121.54555, 38.66582], [-121.54559, 38.66571], [-121.54565, 38.66571], [-121.54566, 38.66578], [-121.54573, 38.66585], [-121.5458, 38.66587], [-121.54588, 38.66586], [-121.54632, 38.66568], [-121.54635, 38.66565], [-121.54637, 38.6656], [-121.54635, 38.66552], [-121.54673, 38.66552], [-121.54681, 38.66549], [-121.54683, 38.66554], [-121.5468, 38.66557], [-121.54685, 38.66564], [-121.54689, 38.66578], [-121.54694, 38.6659]]]} | Open Access 1 | 21275 | Egret Park | 18467 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 4.719 | Egret Park | 0 | Local Park 2 | 4 | |
2678 | 2678 | 2677 | {"type": "Polygon", "coordinates": [[[-121.54666, 38.59963], [-121.54579, 38.60083], [-121.54517, 38.60174], [-121.54517, 38.59971], [-121.54559, 38.59963], [-121.54591, 38.5996], [-121.54632, 38.5996], [-121.54666, 38.59963]]]} | Open Access 1 | 21115 | Costa Park Site | 17672 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.74 | Costa Park Site | 0 | Local Park 2 | 4 | |
11070 | 11070 | 11069 | {"type": "Polygon", "coordinates": [[[-121.54638, 38.60138], [-121.54637, 38.60333], [-121.54595, 38.60333], [-121.54563, 38.60336], [-121.54533, 38.60343], [-121.54502, 38.60353], [-121.54565, 38.60268], [-121.54556, 38.60254], [-121.54638, 38.60138]]]} | Open Access 1 | 21271 | Costa Park Site | 17672 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.0 | Costa Park Site | 0 | Local Park 2 | 4 | |
5673 | 5673 | 5672 | {"type": "Polygon", "coordinates": [[[-121.54627, 38.51423], [-121.54497, 38.5146], [-121.54474, 38.51413], [-121.54556, 38.51393], [-121.54592, 38.51391], [-121.54607, 38.51387], [-121.54627, 38.51423]]]} | Open Access 1 | 21209 | North Point Way River Access | 22847 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.532 | North Point Way River Access | 0 | Local Recreation Area 3 | 4 | |
2676 | 2676 | 2675 | {"type": "Polygon", "coordinates": [[[-121.54546, 38.59936], [-121.54545, 38.59952], [-121.54517, 38.59959], [-121.54484, 38.59969], [-121.54458, 38.59979], [-121.54429, 38.59994], [-121.54083, 38.60212], [-121.54085, 38.60157], [-121.54092, 38.60144], [-121.54138, 38.60116], [-121.54185, 38.60075], [-121.54239, 38.60014], [-121.54291, 38.59938], [-121.54318, 38.59929], [-121.54346, 38.59928], [-121.54382, 38.59914], [-121.54408, 38.59894], [-121.54425, 38.59872], [-121.54453, 38.59892], [-121.54453, 38.59899], [-121.54482, 38.5989], [-121.54506, 38.59937], [-121.54546, 38.59936]]]} | Open Access 1 | 21113 | Sand Cove Park | 25011 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 9.844 | Sand Cove Park | 0 | Local Park 2 | 4 | |
3073 | 3073 | 3072 | {"type": "Polygon", "coordinates": [[[-121.54386, 38.47907], [-121.5413, 38.48076], [-121.53988, 38.47961], [-121.53967, 38.47947], [-121.54192, 38.47755], [-121.54295, 38.47837], [-121.54336, 38.47881], [-121.54386, 38.47907]]]} | Open Access 1 | 21240 | Garcia Bend Park | 19191 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 15.601 | Garcia Bend Park | 0 | Local Park 2 | 4 | |
11047 | 11047 | 11046 | {"type": "Polygon", "coordinates": [[[-121.54356, 38.48812], [-121.54349, 38.48819], [-121.54354, 38.48845], [-121.54195, 38.4886], [-121.54191, 38.48828], [-121.54186, 38.48825], [-121.5419, 38.48819], [-121.5419, 38.48814], [-121.54187, 38.48761], [-121.54185, 38.48755], [-121.54181, 38.48751], [-121.54186, 38.48746], [-121.5418, 38.48678], [-121.54323, 38.48662], [-121.54334, 38.48721], [-121.54329, 38.48726], [-121.54329, 38.48732], [-121.54331, 38.48736], [-121.54335, 38.48739], [-121.54345, 38.48795], [-121.54354, 38.48799], [-121.54352, 38.48806], [-121.54356, 38.48812]]]} | Open Access 1 | 21229 | Reginald Renfree Park | 24274 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 6.703 | Reginald Renfree Park | 0 | Local Park 2 | 4 | |
11042 | 11042 | 11041 | {"type": "Polygon", "coordinates": [[[-121.54328, 38.50023], [-121.54324, 38.50055], [-121.54269, 38.50051], [-121.54277, 38.50022], [-121.54289, 38.50019], [-121.54328, 38.50023]]]} | Open Access 1 | 21220 | Evelyn Dutra Park | 18759 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 0.414 | Evelyn Dutra Park | 0 | Local Park 2 | 4 | |
11053 | 11053 | 11052 | {"type": "Polygon", "coordinates": [[[-121.54287, 38.48454], [-121.54187, 38.48493], [-121.54142, 38.48517], [-121.54135, 38.48511], [-121.54076, 38.48491], [-121.54058, 38.48491], [-121.54054, 38.48497], [-121.54054, 38.48505], [-121.54053, 38.48508], [-121.54043, 38.48514], [-121.54036, 38.48515], [-121.54031, 38.4851], [-121.54038, 38.48394], [-121.54034, 38.48386], [-121.54044, 38.48383], [-121.54282, 38.4844], [-121.54287, 38.48454]]]} | Open Access 1 | 21236 | Charter Pointe Park | 17152 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 4.868 | Charter Pointe Park | 0 | Local Park 2 | 4 | |
11052 | 11052 | 11051 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-121.54229, 38.48581], [-121.54226, 38.48585], [-121.54184, 38.48591], [-121.5417, 38.48591], [-121.54162, 38.48595], [-121.54159, 38.486], [-121.54102, 38.48588], [-121.54172, 38.48551], [-121.54172, 38.48543], [-121.54229, 38.48517]]]} | Open Access 1 | 21235 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.159 | Cool Wind Way Park | 0 | Local Park 2 | 4 | |
11066 | 11066 | 11065 | {"type": "Polygon", "coordinates": [[[-121.54197, 38.66281], [-121.54193, 38.66283], [-121.54147, 38.66283], [-121.54133, 38.6628], [-121.5412, 38.66285], [-121.54111, 38.66281], [-121.54111, 38.66195], [-121.54118, 38.66195], [-121.54127, 38.66193], [-121.54168, 38.66193], [-121.54181, 38.66197], [-121.54191, 38.66197], [-121.54197, 38.662], [-121.54197, 38.66281]]]} | Open Access 1 | 21260 | Sparrow Park | 25717 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.809 | Sparrow Park | 0 | Local Park 2 | 4 | |
11003 | 11003 | 11002 | {"type": "Polygon", "coordinates": [[[-121.54124, 38.62881], [-121.54371, 38.6288], [-121.54376, 38.62885], [-121.54376, 38.62959], [-121.54373, 38.62962], [-121.54368, 38.62964], [-121.54122, 38.62964], [-121.54118, 38.6296], [-121.54117, 38.62886], [-121.5412, 38.62882], [-121.54124, 38.62881]]]} | Open Access 1 | 21072 | River View Park | 24426 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.146 | River View Park | 0 | Local Park 2 | 4 | |
11021 | 11021 | 11020 | {"type": "Polygon", "coordinates": [[[-121.54063, 38.60843], [-121.5401, 38.60923], [-121.54001, 38.60923], [-121.53949, 38.61001], [-121.53938, 38.60997], [-121.53958, 38.60968], [-121.53966, 38.60952], [-121.5397, 38.60948], [-121.53976, 38.60931], [-121.53978, 38.60908], [-121.53976, 38.60886], [-121.53969, 38.60861], [-121.53954, 38.60834], [-121.53938, 38.60817], [-121.53938, 38.6081], [-121.53953, 38.608], [-121.54036, 38.60834], [-121.54039, 38.60833], [-121.54046, 38.60839], [-121.54055, 38.6084], [-121.54063, 38.60843]]]} | Open Access 1 | 21106 | River Otter Park | 24415 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.114 | River Otter 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]);