units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
216 rows where ACCESS_TYP = 1 and MNG_AGENCY = 534 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 216 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10962 | 10962 | 10961 | {"type": "Polygon", "coordinates": [[[-121.51585, 38.68321], [-121.51542, 38.68328], [-121.51542, 38.68332], [-121.51446, 38.68333], [-121.5144, 38.68326], [-121.51447, 38.68323], [-121.51447, 38.68257], [-121.51539, 38.68237], [-121.51546, 38.68238], [-121.51551, 38.68242], [-121.51575, 38.68292], [-121.51585, 38.68321]]]} | Open Access 1 | 21029 | Willow Park | 27584 | 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.516 | Willow Park | 0 | Local Park 2 | 4 | |
10963 | 10963 | 10962 | {"type": "Polygon", "coordinates": [[[-121.53484, 38.68257], [-121.53481, 38.68262], [-121.53481, 38.68311], [-121.53416, 38.68311], [-121.53411, 38.68309], [-121.53409, 38.68305], [-121.53409, 38.68196], [-121.5341, 38.68193], [-121.53416, 38.68191], [-121.53472, 38.68191], [-121.53477, 38.68193], [-121.53479, 38.68197], [-121.53479, 38.68236], [-121.53476, 38.68247], [-121.53479, 38.68254], [-121.53484, 38.68257]]]} | Open Access 1 | 21030 | Golden Poppy Park Site | 19370 | 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.034 | Golden Poppy Park Site | 0 | Local Park 2 | 4 | |
10964 | 10964 | 10963 | {"type": "Polygon", "coordinates": [[[-121.49616, 38.68143], [-121.4964, 38.68163], [-121.49674, 38.68182], [-121.49676, 38.68185], [-121.49676, 38.68189], [-121.49665, 38.68204], [-121.49654, 38.68216], [-121.49628, 38.68236], [-121.49596, 38.6825], [-121.49562, 38.68257], [-121.49562, 38.68167], [-121.49581, 38.6816], [-121.49608, 38.68144], [-121.49616, 38.68143]]]} | Open Access 1 | 21031 | Alder Park | 15347 | 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.029 | Alder Park | 0 | Local Park 2 | 4 | |
10966 | 10966 | 10965 | {"type": "Polygon", "coordinates": [[[-121.50463, 38.68061], [-121.50466, 38.68062], [-121.50497, 38.68094], [-121.50508, 38.68109], [-121.50517, 38.68124], [-121.50526, 38.68148], [-121.50529, 38.68168], [-121.5053, 38.68184], [-121.50525, 38.6819], [-121.5019, 38.6819], [-121.5019, 38.68069], [-121.50087, 38.67955], [-121.50079, 38.67953], [-121.50078, 38.67947], [-121.50075, 38.67942], [-121.5004, 38.67903], [-121.50029, 38.67898], [-121.5003, 38.67889], [-121.49989, 38.67843], [-121.49979, 38.67841], [-121.49979, 38.67835], [-121.49975, 38.67829], [-121.49891, 38.67736], [-121.49884, 38.6773], [-121.49886, 38.67726], [-121.49838, 38.67673], [-121.49843, 38.67667], [-121.49843, 38.67659], [-121.4982, 38.6761], [-121.49821, 38.67603], [-121.49825, 38.676], [-121.49832, 38.67598], [-121.4985, 38.6759], [-121.50349, 38.67332], [-121.50355, 38.67331], [-121.5036, 38.67333], [-121.50376, 38.67347], [-121.50393, 38.67368], [-121.50408, 38.67393], [-121.50416, 38.67417], [-121.50419, 38.67444], [-121.5042, 38.67599], [-121.50418, 38.67602], [-121.50413, 38.67604], [-121.50041, 38.67607], [-121.50016, 38.67611], [-121.50002, 38.67615], [-121.49993, 38.67621], [-121.49989, 38.6763], [-121.49985, 38.6763], [-121.49954, 38.67644], [-121.50094, 38.67846], [-121.50092, 38.67851], [-121.50094, 38.67856], [-121.50098, 38.67859], [-121.50104, 38.67861], [-121.50137, 38.67913], [-121.50148, 38.67917], [-121.50147, 38.67923], [-121.5015, 38.67929], [-121.50209, 38.68015], [-121.50219, 38.68036], [-121.50223, 38.68041], [-121.5023, 38.68044], [-121.50245, 38.68044], [-121.50245, 38.68074], [-121.50422, 38.68071], [-121.50463, 38.68061]]]} | Open Access 1 | 21032 | Regency Community Park | 24270 | 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 | 42.127 | Regency Community Park | 0 | Local Park 2 | 4 | |
10967 | 10967 | 10966 | {"type": "Polygon", "coordinates": [[[-121.52975, 38.6801], [-121.52978, 38.68015], [-121.52975, 38.68021], [-121.52977, 38.6803], [-121.52982, 38.68044], [-121.52996, 38.68062], [-121.53006, 38.68072], [-121.53014, 38.68075], [-121.53015, 38.68079], [-121.53013, 38.68082], [-121.52984, 38.68094], [-121.52942, 38.68102], [-121.52881, 38.68103], [-121.52866, 38.68106], [-121.52849, 38.68076], [-121.52848, 38.6801], [-121.52975, 38.6801]]]} | Open Access 1 | 21033 | Dogwood Park Site | 18186 | 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.016 | Dogwood Park Site | 0 | Local Park 2 | 4 | |
10968 | 10968 | 10967 | {"type": "Polygon", "coordinates": [[[-121.53719, 38.67975], [-121.53719, 38.68044], [-121.53664, 38.68044], [-121.53429, 38.68025], [-121.53425, 38.68023], [-121.53422, 38.6802], [-121.53426, 38.67993], [-121.53434, 38.67958], [-121.53627, 38.67975], [-121.53719, 38.67975]]]} | Open Access 1 | 21034 | Magnolia Park Site | 21684 | 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.681 | Magnolia Park Site | 0 | Local Park 2 | 4 | |
10969 | 10969 | 10968 | {"type": "Polygon", "coordinates": [[[-121.52433, 38.67886], [-121.52475, 38.67888], [-121.52521, 38.67888], [-121.52527, 38.67891], [-121.52528, 38.67894], [-121.52528, 38.67945], [-121.52525, 38.67979], [-121.52524, 38.67981], [-121.52518, 38.67983], [-121.5248, 38.67981], [-121.52421, 38.67972], [-121.52433, 38.67886]]]} | Open Access 1 | 21035 | Elderberry Park | 18550 | 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.183 | Elderberry Park | 0 | Local Park 2 | 4 | |
10970 | 10970 | 10969 | {"type": "Polygon", "coordinates": [[[-121.51727, 38.6794], [-121.51682, 38.67957], [-121.51652, 38.67972], [-121.51614, 38.67998], [-121.51586, 38.68024], [-121.5158, 38.68025], [-121.51564, 38.68016], [-121.5155, 38.68003], [-121.5148, 38.67896], [-121.51483, 38.67892], [-121.51502, 38.67885], [-121.51578, 38.67857], [-121.51596, 38.67854], [-121.5167, 38.67847], [-121.51727, 38.6794]]]} | Open Access 1 | 21036 | Autumn Meadow Park | 15717 | 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.067 | Autumn Meadow Park | 0 | Local Park 2 | 4 | |
10971 | 10971 | 10970 | {"type": "Polygon", "coordinates": [[[-121.53611, 38.67582], [-121.53603, 38.67614], [-121.53603, 38.67671], [-121.53601, 38.6768], [-121.53598, 38.67683], [-121.53431, 38.67655], [-121.53417, 38.67651], [-121.53405, 38.67645], [-121.53405, 38.67643], [-121.5343, 38.67605], [-121.53449, 38.67571], [-121.53461, 38.67554], [-121.53465, 38.67552], [-121.53478, 38.67558], [-121.53493, 38.67563], [-121.53601, 38.67579], [-121.5361, 38.6758], [-121.53611, 38.67582]]]} | Open Access 1 | 21037 | Westhampton Park | 27398 | 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.317 | Westhampton Park | 0 | Local Park 2 | 4 | |
10972 | 10972 | 10971 | {"type": "Polygon", "coordinates": [[[-121.51729, 38.67262], [-121.51766, 38.67279], [-121.51799, 38.67289], [-121.51843, 38.67298], [-121.51893, 38.67301], [-121.51897, 38.67304], [-121.51896, 38.67377], [-121.51898, 38.67406], [-121.51905, 38.67455], [-121.51929, 38.67547], [-121.51929, 38.67551], [-121.51927, 38.67554], [-121.51923, 38.67555], [-121.51859, 38.67566], [-121.51808, 38.6758], [-121.51802, 38.67579], [-121.51799, 38.67577], [-121.51793, 38.67564], [-121.51786, 38.67546], [-121.51772, 38.67469], [-121.51768, 38.67457], [-121.51756, 38.67438], [-121.51739, 38.67423], [-121.51718, 38.67412], [-121.51691, 38.67406], [-121.51659, 38.67406], [-121.51653, 38.67403], [-121.51653, 38.67391], [-121.51658, 38.67379], [-121.51691, 38.67323], [-121.51705, 38.67309], [-121.51706, 38.67302], [-121.51701, 38.67294], [-121.51708, 38.67287], [-121.51713, 38.67286], [-121.51715, 38.67284], [-121.51715, 38.67283], [-121.51711, 38.6728], [-121.51729, 38.67262]]]} | Open Access 1 | 21038 | Burberry Community Park | 16512 | 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 | 11.799 | Burberry Community Park | 0 | Local Park 2 | 4 | |
10973 | 10973 | 10972 | {"type": "Polygon", "coordinates": [[[-121.5295, 38.67417], [-121.5292, 38.67444], [-121.52894, 38.67464], [-121.5276, 38.67551], [-121.52658, 38.67386], [-121.52689, 38.67393], [-121.5271, 38.67397], [-121.52771, 38.67398], [-121.52773, 38.67372], [-121.52779, 38.67344], [-121.52787, 38.67331], [-121.52799, 38.67317], [-121.52817, 38.67307], [-121.52869, 38.67285], [-121.52894, 38.67281], [-121.5292, 38.67281], [-121.5295, 38.67289], [-121.52986, 38.67308], [-121.53012, 38.67317], [-121.53014, 38.67319], [-121.53005, 38.6734], [-121.52989, 38.67369], [-121.5297, 38.67394], [-121.5295, 38.67417]]]} | Open Access 1 | 21039 | Valley Oak Park Site | 26795 | 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 | 11.185 | Valley Oak Park Site | 0 | Local Park 2 | 4 | |
10974 | 10974 | 10973 | {"type": "Polygon", "coordinates": [[[-121.51064, 38.67132], [-121.51064, 38.67156], [-121.51061, 38.67177], [-121.51045, 38.67217], [-121.5104, 38.67237], [-121.51039, 38.67252], [-121.51039, 38.67298], [-121.50966, 38.67298], [-121.50959, 38.67305], [-121.50953, 38.67303], [-121.50944, 38.67305], [-121.50937, 38.67298], [-121.50865, 38.67298], [-121.50858, 38.67305], [-121.50851, 38.67303], [-121.50843, 38.67305], [-121.50836, 38.67297], [-121.50796, 38.67298], [-121.50796, 38.67234], [-121.50922, 38.67233], [-121.50934, 38.67231], [-121.50949, 38.67226], [-121.5096, 38.67221], [-121.50972, 38.67212], [-121.50982, 38.67201], [-121.50988, 38.6719], [-121.50992, 38.67174], [-121.50991, 38.67116], [-121.5104, 38.67115], [-121.51041, 38.67122], [-121.51047, 38.67128], [-121.51055, 38.67131], [-121.51064, 38.67132]]]} | Open Access 1 | 21041 | Sycamore Park | 26138 | 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.836 | Sycamore Park | 0 | Local Park 2 | 4 | |
10975 | 10975 | 10974 | {"type": "Polygon", "coordinates": [[[-121.49698, 38.67214], [-121.49581, 38.67215], [-121.49575, 38.6712], [-121.49575, 38.67097], [-121.49576, 38.67093], [-121.49582, 38.67091], [-121.49682, 38.67091], [-121.49682, 38.67126], [-121.49686, 38.6716], [-121.49692, 38.67192], [-121.49698, 38.67214]]]} | Open Access 1 | 21042 | California Lilac Park | 16718 | 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.244 | California Lilac Park | 0 | Local Park 2 | 4 | |
10976 | 10976 | 10975 | {"type": "Polygon", "coordinates": [[[-121.5211, 38.67146], [-121.52034, 38.6716], [-121.52019, 38.6711], [-121.52096, 38.67095], [-121.5211, 38.67146]]]} | Open Access 1 | 21043 | Blue Oak Park | 16180 | 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.981 | Blue Oak Park | 0 | Local Park 2 | 4 | |
10977 | 10977 | 10976 | {"type": "Polygon", "coordinates": [[[-121.5177, 38.66983], [-121.5169, 38.67021], [-121.51642, 38.67058], [-121.51606, 38.6706], [-121.51578, 38.67086], [-121.51571, 38.67089], [-121.51567, 38.67096], [-121.51566, 38.67096], [-121.5154, 38.6712], [-121.51514, 38.67108], [-121.51483, 38.67095], [-121.51503, 38.66995], [-121.5151, 38.66999], [-121.51521, 38.66999], [-121.51528, 38.67012], [-121.51605, 38.6701], [-121.5161, 38.67013], [-121.51617, 38.67013], [-121.51626, 38.67008], [-121.51669, 38.66998], [-121.51698, 38.6698], [-121.51699, 38.66974], [-121.51708, 38.66972], [-121.51714, 38.66967], [-121.51748, 38.66951], [-121.5177, 38.66983]]]} | Open Access 1 | 21044 | Northborough Park | 22866 | 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.034 | Northborough Park | 0 | Local Park 2 | 4 | |
10978 | 10978 | 10977 | {"type": "Polygon", "coordinates": [[[-121.47543, 38.66991], [-121.46604, 38.66983], [-121.46605, 38.66945], [-121.46608, 38.66228], [-121.4661, 38.66], [-121.46631, 38.6599], [-121.4664, 38.65943], [-121.46793, 38.65892], [-121.4686, 38.65854], [-121.47094, 38.65833], [-121.4715, 38.65781], [-121.47227, 38.6578], [-121.47285, 38.65813], [-121.4737, 38.65896], [-121.47466, 38.65919], [-121.47541, 38.66402], [-121.47543, 38.66991]]]} | Open Access 1 | 21045 | Hansen Ranch Park Site | 19651 | 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 | 245.789 | Hansen Ranch Park Site | 0 | Local Park 2 | 4 | |
10979 | 10979 | 10978 | {"type": "Polygon", "coordinates": [[[-121.51362, 38.66933], [-121.51356, 38.66936], [-121.51352, 38.66965], [-121.51202, 38.66965], [-121.51203, 38.66902], [-121.51201, 38.66897], [-121.51196, 38.66892], [-121.51187, 38.66888], [-121.51187, 38.66863], [-121.51362, 38.66862], [-121.51363, 38.66917], [-121.5136, 38.66928], [-121.51362, 38.66933]]]} | Open Access 1 | 21046 | Heron Park | 19879 | 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.956 | Heron Park | 0 | Local Park 2 | 4 | |
10980 | 10980 | 10979 | {"type": "Polygon", "coordinates": [[[-121.52709, 38.66822], [-121.52709, 38.6697], [-121.52707, 38.66974], [-121.52471, 38.66974], [-121.52471, 38.66822], [-121.52709, 38.66822]]]} | Open Access 1 | 21047 | Wild Rose Park Site | 27498 | 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 | 8.621 | Wild Rose Park Site | 0 | Local Park 2 | 4 | |
10981 | 10981 | 10980 | {"type": "Polygon", "coordinates": [[[-121.5243, 38.66653], [-121.52401, 38.66704], [-121.52394, 38.66723], [-121.52389, 38.66739], [-121.52387, 38.66762], [-121.52387, 38.66868], [-121.52378, 38.66864], [-121.52361, 38.66866], [-121.52351, 38.66861], [-121.5234, 38.66853], [-121.5231, 38.66825], [-121.52309, 38.6682], [-121.52346, 38.66791], [-121.52371, 38.66763], [-121.52385, 38.66741], [-121.52394, 38.6672], [-121.52407, 38.66657], [-121.52413, 38.66653], [-121.5243, 38.66653]]]} | Open Access 1 | 21048 | Redbud Park | 24230 | 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.442 | Redbud Park | 0 | Local Park 2 | 4 | |
10985 | 10985 | 10984 | {"type": "Polygon", "coordinates": [[[-121.50201, 38.662], [-121.50189, 38.662], [-121.50175, 38.66197], [-121.50167, 38.66199], [-121.50162, 38.66203], [-121.5016, 38.66208], [-121.50159, 38.66218], [-121.50089, 38.66306], [-121.50086, 38.66311], [-121.50086, 38.66319], [-121.50079, 38.6632], [-121.50039, 38.6637], [-121.50032, 38.6637], [-121.50024, 38.66375], [-121.50023, 38.66382], [-121.50027, 38.66388], [-121.49934, 38.66504], [-121.49959, 38.66517], [-121.49966, 38.66517], [-121.49968, 38.66521], [-121.49972, 38.66526], [-121.49997, 38.6654], [-121.50027, 38.66551], [-121.50056, 38.66557], [-121.50093, 38.66559], [-121.50402, 38.66557], [-121.50408, 38.66559], [-121.5041, 38.66563], [-121.50412, 38.66683], [-121.50411, 38.66706], [-121.50407, 38.66733], [-121.50398, 38.66759], [-121.50383, 38.66788], [-121.50364, 38.66814], [-121.50349, 38.66829], [-121.50346, 38.66831], [-121.50341, 38.66831], [-121.50333, 38.66827], [-121.49851, 38.66569], [-121.49885, 38.66507], [-121.49883, 38.66503], [-121.4989, 38.665], [-121.4992, 38.66445], [-121.49919, 38.66438], [-121.49925, 38.66436], [-121.49955, 38.66381], [-121.49952, 38.66375], [-121.49959, 38.66372], [-121.49964, 38.66367], [-121.50021, 38.66263], [-121.50023, 38.66256], [-121.50021, 38.66249], [-121.50032, 38.66243], [-121.50046, 38.66217], [-121.50046, 38.66182], [-121.50055, 38.66182], [-121.50061, 38.66181], [-121.50066, 38.66178], [-121.50071, 38.66172], [-121.50067, 38.65979], [-121.50067, 38.65973], [-121.50069, 38.6597], [-121.50074, 38.65968], [-121.50198, 38.65967], [-121.50201, 38.662]]]} | Open Access 1 | 21050 | North Natomas Community Park | 22832 | 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 | 35.34 | North Natomas Community 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]);