units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
172 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AG_TYP = 17 sorted by rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 172 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16426 | 16426 | 16425 | {"type": "Polygon", "coordinates": [[[-121.09169, 38.69101], [-121.09086, 38.69117], [-121.09074, 38.69053], [-121.09067, 38.69035], [-121.09169, 38.69017], [-121.09169, 38.69101]]]} | Open Access 1 | 45332 | Regional Park | 24275 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 1.86 | RP | 0 | Local Park 2 | 4 | |
14985 | 14985 | 14984 | {"type": "Polygon", "coordinates": [[[-120.97926, 38.68508], [-120.97912, 38.68513], [-120.97897, 38.68516], [-120.97813, 38.68517], [-120.97813, 38.68492], [-120.97806, 38.68492], [-120.97796, 38.68484], [-120.97754, 38.68479], [-120.97738, 38.6848], [-120.97726, 38.6845], [-120.97699, 38.68426], [-120.97654, 38.68405], [-120.97598, 38.68382], [-120.97568, 38.68381], [-120.97569, 38.68295], [-120.97575, 38.68292], [-120.97606, 38.68291], [-120.97631, 38.68288], [-120.97652, 38.6832], [-120.97729, 38.684], [-120.97865, 38.68477], [-120.97926, 38.68508]]]} | Open Access 1 | 45619 | Northview Park | 28447 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 5.218 | Northview Park | 0 | Local Park 2 | 4 | |
14710 | 14710 | 14709 | {"type": "Polygon", "coordinates": [[[-119.63172, 36.30132], [-119.63125, 36.30132], [-119.63131, 36.30113], [-119.63134, 36.30093], [-119.63132, 36.29873], [-119.63169, 36.29874], [-119.63172, 36.30132]]]} | Open Access 1 | 45048 | Home Garden Community Park | 28022 | 2342 | Home Garden Community Services District 1120 | Special District 4 | Community Services District 19 | http://www.cset.org/ | Special District 4 | 2342 | Home Garden Community Services District 1075 | Special District 4 | Community Services District 17 | Kings 44 | 2.424 | Home Garden Community Park | 2017 | Local Park 2 | 4 | |
14654 | 14654 | 14653 | {"type": "Polygon", "coordinates": [[[-121.08918, 38.72527], [-121.08758, 38.72595], [-121.08622, 38.72426], [-121.08612, 38.72345], [-121.08776, 38.72389], [-121.08798, 38.72391], [-121.08831, 38.72386], [-121.08837, 38.72405], [-121.08844, 38.72421], [-121.08918, 38.72527]]]} | Open Access 1 | 44914 | Lake Forest Park | 20891 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 9.786 | Lake Forest Park | 0 | Local Park 2 | 4 | |
14653 | 14653 | 14652 | {"type": "Polygon", "coordinates": [[[-121.01514, 38.66851], [-121.01406, 38.66856], [-121.01397, 38.6684], [-121.01397, 38.66777], [-121.01416, 38.66778], [-121.01435, 38.66781], [-121.01455, 38.66787], [-121.01474, 38.66797], [-121.01488, 38.66808], [-121.015, 38.66821], [-121.01509, 38.66836], [-121.01514, 38.66851]]]} | Open Access 1 | 44913 | Laurel Oaks Park | 21097 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 1.627 | Laurel Oaks Park | 0 | Local Park 2 | 4 | |
14648 | 14648 | 14647 | {"type": "Polygon", "coordinates": [[[-117.58177, 33.95627], [-117.58174, 33.95682], [-117.58032, 33.95681], [-117.58008, 33.95678], [-117.57999, 33.9568], [-117.57991, 33.95683], [-117.57986, 33.95689], [-117.57983, 33.95697], [-117.57955, 33.95697], [-117.57956, 33.9568], [-117.57956, 33.95547], [-117.57923, 33.95547], [-117.57922, 33.95522], [-117.57915, 33.95499], [-117.57899, 33.95477], [-117.57878, 33.95459], [-117.57892, 33.95438], [-117.57899, 33.95416], [-117.57902, 33.95392], [-117.57902, 33.95351], [-117.58004, 33.95351], [-117.58009, 33.95354], [-117.58009, 33.95395], [-117.58013, 33.95413], [-117.58019, 33.9543], [-117.58106, 33.95575], [-117.58117, 33.95599], [-117.5812, 33.95615], [-117.58123, 33.95621], [-117.58131, 33.95629], [-117.58142, 33.95632], [-117.58177, 33.95627]]]} | Open Access 1 | 44906 | Providence Ranch Park | 24024 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 12.846 | Providence Ranch Park | 0 | Local Park 2 | 4 | |
14647 | 14647 | 14646 | {"type": "Polygon", "coordinates": [[[-117.57772, 33.98136], [-117.57675, 33.98167], [-117.57676, 33.98212], [-117.57682, 33.98212], [-117.57697, 33.98246], [-117.57673, 33.98253], [-117.576, 33.98252], [-117.57601, 33.97936], [-117.57606, 33.97929], [-117.57678, 33.97929], [-117.57718, 33.97924], [-117.57725, 33.97955], [-117.57725, 33.98002], [-117.5773, 33.98032], [-117.57737, 33.98055], [-117.57772, 33.98136]]]} | Open Access 1 | 44905 | Orchard Park | 23194 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 9.959 | Orchard Park | 0 | Local Park 2 | 4 | |
14631 | 14631 | 14630 | {"type": "Polygon", "coordinates": [[[-117.58089, 33.9671], [-117.58011, 33.96711], [-117.58008, 33.96687], [-117.57998, 33.96658], [-117.57986, 33.96636], [-117.57973, 33.96617], [-117.57955, 33.96599], [-117.57939, 33.96586], [-117.57851, 33.96525], [-117.5785, 33.96519], [-117.57898, 33.96466], [-117.57905, 33.96464], [-117.58023, 33.96463], [-117.58075, 33.96458], [-117.58085, 33.96464], [-117.58089, 33.9671]]]} | Open Access 1 | 44901 | Cedar Creek Park | 16994 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 9.521 | Cedar Creek Park | 0 | Local Park 2 | 4 | |
14609 | 14609 | 14608 | {"type": "Polygon", "coordinates": [[[-117.59087, 33.95353], [-117.59072, 33.95385], [-117.59064, 33.95409], [-117.59058, 33.95438], [-117.59056, 33.95472], [-117.59052, 33.95476], [-117.58866, 33.95476], [-117.58861, 33.95473], [-117.58855, 33.95435], [-117.58842, 33.95398], [-117.58827, 33.95371], [-117.5879, 33.95318], [-117.58935, 33.95226], [-117.58982, 33.95278], [-117.59008, 33.95302], [-117.59043, 33.95327], [-117.59085, 33.95348], [-117.59087, 33.95353]]]} | Open Access 1 | 44904 | McCune Family Park | 22018 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 11.893 | McCune Family Park | 0 | Local Park 2 | 4 | |
14484 | 14484 | 14483 | {"type": "Polygon", "coordinates": [[[-121.34161, 38.40181], [-121.34162, 38.40199], [-121.34165, 38.40214], [-121.34162, 38.40219], [-121.34122, 38.40229], [-121.34088, 38.40239], [-121.34038, 38.40259], [-121.34008, 38.40276], [-121.33979, 38.40294], [-121.33953, 38.40315], [-121.33926, 38.40339], [-121.33919, 38.40339], [-121.33885, 38.40322], [-121.33865, 38.40314], [-121.33833, 38.40307], [-121.33811, 38.40306], [-121.33791, 38.40307], [-121.33739, 38.40315], [-121.33738, 38.40318], [-121.33718, 38.40319], [-121.33692, 38.40319], [-121.33687, 38.40317], [-121.33685, 38.40314], [-121.33686, 38.40252], [-121.33696, 38.40237], [-121.33696, 38.40234], [-121.33693, 38.40229], [-121.33703, 38.40223], [-121.33703, 38.40179], [-121.34161, 38.40181]]]} | Open Access 1 | 47139 | Derr-Okamoto Park | 30816 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/590/Derr-Okamoto-Park | Sacramento 41 | 12.378 | Derr-Okamoto Park | 0 | Local Park 2 | 4 |
14483 | 14483 | 14482 | {"type": "Polygon", "coordinates": [[[-121.38091, 38.42364], [-121.38089, 38.42712], [-121.37995, 38.42794], [-121.37993, 38.42791], [-121.37994, 38.42787], [-121.3803, 38.42755], [-121.3804, 38.42743], [-121.38049, 38.42726], [-121.38053, 38.42709], [-121.38051, 38.42689], [-121.38048, 38.42677], [-121.38042, 38.42667], [-121.38027, 38.42648], [-121.38006, 38.42633], [-121.37988, 38.42625], [-121.37968, 38.4262], [-121.37949, 38.42618], [-121.3793, 38.42618], [-121.37851, 38.42554], [-121.37825, 38.42573], [-121.37824, 38.42591], [-121.3782, 38.42596], [-121.37803, 38.42594], [-121.37783, 38.42625], [-121.37768, 38.42655], [-121.37773, 38.42659], [-121.37769, 38.42664], [-121.37769, 38.4267], [-121.37759, 38.42673], [-121.37744, 38.42733], [-121.3774, 38.42733], [-121.37733, 38.4273], [-121.37726, 38.42724], [-121.37723, 38.42717], [-121.37722, 38.4271], [-121.37764, 38.42617], [-121.37768, 38.42597], [-121.37768, 38.42575], [-121.37763, 38.42553], [-121.37751, 38.42529], [-121.37735, 38.42508], [-121.37717, 38.42493], [-121.37687, 38.42474], [-121.37671, 38.42466], [-121.37645, 38.42456], [-121.37621, 38.42452], [-121.37592, 38.42451], [-121.37563, 38.42454], [-121.37539, 38.4246], [-121.37511, 38.42472], [-121.37481, 38.42451], [-121.37455, 38.42455], [-121.37367, 38.42449], [-121.37368, 38.42362], [-121.3741, 38.42362], [-121.37519, 38.4237], [-121.37598, 38.4237], [-121.3767, 38.42365], [-121.3783, 38.42363], [-121.38091, 38.42364]]]} | Open Access 1 | 47138 | Underwood Park | 30815 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/646/Underwood-Park | Sacramento 41 | 30.458 | Underwood Park | 0 | Local Park 2 | 4 |
14482 | 14482 | 14481 | {"type": "Polygon", "coordinates": [[[-121.41372, 38.3969], [-121.413, 38.3969], [-121.41289, 38.39639], [-121.41285, 38.39595], [-121.41278, 38.39567], [-121.41277, 38.395], [-121.41268, 38.39489], [-121.41259, 38.39483], [-121.41242, 38.39477], [-121.4123, 38.39476], [-121.41288, 38.39476], [-121.41314, 38.39496], [-121.41369, 38.39496], [-121.4136, 38.39504], [-121.41353, 38.39518], [-121.41351, 38.39527], [-121.41351, 38.3956], [-121.41354, 38.39587], [-121.41372, 38.3969]]]} | Open Access 1 | 47137 | Promenade Park | 30814 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/621/Promenade-Park | Sacramento 41 | 3.631 | Promenade Park | 0 | Local Park 2 | 4 |
14481 | 14481 | 14480 | {"type": "Polygon", "coordinates": [[[-121.4142, 38.3979], [-121.41422, 38.39797], [-121.41419, 38.39807], [-121.41414, 38.39816], [-121.41406, 38.39824], [-121.41396, 38.39831], [-121.41384, 38.39835], [-121.41365, 38.39839], [-121.41344, 38.39836], [-121.41326, 38.39828], [-121.41313, 38.39816], [-121.41307, 38.39807], [-121.41304, 38.39796], [-121.41306, 38.3979], [-121.41333, 38.39793], [-121.41363, 38.39795], [-121.41394, 38.39793], [-121.4142, 38.3979]]]} | Open Access 1 | 47136 | Rose Garden Park | 30813 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/624/Rose-Garden-Park | Sacramento 41 | 0.996 | Rose Garden Park | 0 | Local Park 2 | 4 |
14479 | 14479 | 14478 | {"type": "Polygon", "coordinates": [[[-121.40288, 38.397], [-121.40292, 38.39684], [-121.40298, 38.39674], [-121.40307, 38.39665], [-121.40318, 38.39659], [-121.40331, 38.39654], [-121.40351, 38.39651], [-121.40372, 38.39654], [-121.40385, 38.39659], [-121.40396, 38.39666], [-121.40408, 38.39679], [-121.40412, 38.3969], [-121.40414, 38.39701], [-121.4041, 38.39717], [-121.40404, 38.39727], [-121.40395, 38.39736], [-121.40384, 38.39743], [-121.40371, 38.39747], [-121.40351, 38.3975], [-121.4033, 38.39747], [-121.40317, 38.39742], [-121.40306, 38.39735], [-121.40294, 38.39722], [-121.4029, 38.39711], [-121.40288, 38.397]]]} | Open Access 1 | 47134 | Island Park | 30811 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/631/Island-Park | Sacramento 41 | 2.307 | Island Park | 0 | Local Park 2 | 4 |
14474 | 14474 | 14473 | {"type": "Polygon", "coordinates": [[[-121.40937, 38.39491], [-121.40933, 38.39492], [-121.40931, 38.39494], [-121.40931, 38.39518], [-121.40915, 38.39516], [-121.40907, 38.39518], [-121.40901, 38.39524], [-121.409, 38.39531], [-121.40903, 38.39538], [-121.40903, 38.39545], [-121.40856, 38.39544], [-121.40857, 38.39481], [-121.40908, 38.39481], [-121.40937, 38.39491]]]} | Open Access 1 | 47132 | Bridgeview Park | 30809 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/595/Bridgeview-Park | Sacramento 41 | 0.925 | Bridgeview Park | 0 | Local Park 2 | 4 |
14473 | 14473 | 14472 | {"type": "Polygon", "coordinates": [[[-121.40982, 38.39728], [-121.40982, 38.39787], [-121.40853, 38.39786], [-121.40854, 38.39727], [-121.40982, 38.39728]]]} | Open Access 1 | 47131 | Storybook Woods Park | 30808 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/639/Storybook-Woods-Park | Sacramento 41 | 1.816 | Storybook Woods Park | 0 | Local Park 2 | 4 |
14470 | 14470 | 14469 | {"type": "Polygon", "coordinates": [[[-121.42642, 38.41883], [-121.42666, 38.41894], [-121.42668, 38.41897], [-121.42668, 38.419], [-121.42651, 38.4192], [-121.4264, 38.41936], [-121.42482, 38.42184], [-121.42471, 38.4221], [-121.42464, 38.42236], [-121.42462, 38.42256], [-121.4246, 38.42314], [-121.42434, 38.42314], [-121.42434, 38.42289], [-121.42429, 38.42284], [-121.42432, 38.4228], [-121.42434, 38.42274], [-121.42428, 38.42267], [-121.42434, 38.42261], [-121.42436, 38.42235], [-121.42441, 38.42214], [-121.42439, 38.4221], [-121.42444, 38.42207], [-121.42447, 38.42201], [-121.42446, 38.42197], [-121.42443, 38.42193], [-121.4245, 38.42189], [-121.4246, 38.42168], [-121.42474, 38.42145], [-121.42473, 38.42139], [-121.42479, 38.42137], [-121.42483, 38.42133], [-121.42484, 38.42128], [-121.42483, 38.42123], [-121.4249, 38.4212], [-121.42642, 38.41883]]]} | Open Access 1 | 47112 | Green Belt Park | 30783 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 3.174 | Green Belt Park | 0 | Local Park 2 | 4 | |
14311 | 14311 | 14310 | {"type": "Polygon", "coordinates": [[[-120.72844, 35.55287], [-120.72827, 35.55316], [-120.72778, 35.55359], [-120.72729, 35.55371], [-120.72737, 35.55458], [-120.72673, 35.55439], [-120.72763, 35.55225], [-120.72828, 35.55244], [-120.72844, 35.55287]]]} | Open Access 1 | 44274 | Tom Jermin Senior Community Park | 26393 | 2289 | Templeton Community Services District 1039 | Special District 4 | Community Services District 19 | http://templetoncsd.org | Special District 4 | 2289 | Templeton Community Services District 1000 | Special District 4 | Community Services District 17 | San Luis Obispo 1 | 3.882 | Tom Jermin Senior Community Park | 0 | Local Park 2 | 4 | |
14284 | 14284 | 14283 | {"type": "Polygon", "coordinates": [[[-123.61908, 40.943], [-123.61907, 40.94719], [-123.61674, 40.94722], [-123.61678, 40.94593], [-123.61735, 40.9457], [-123.61739, 40.94308], [-123.61908, 40.943]], [[-123.6174, 40.9457], [-123.61739, 40.94571], [-123.61741, 40.94648], [-123.61868, 40.94646], [-123.61866, 40.94568], [-123.6174, 40.9457]]]} | Open Access 1 | 44214 | Veterans Park | 27057 | 2270 | Willow Creek Community Services District 1105 | Special District 4 | Community Services District 19 | http://www.willowcreekcsd.com/ | Special District 4 | 2270 | Willow Creek Community Services District 1059 | Special District 4 | Community Services District 17 | Humboldt 45 | 16.172 | Veterans Park | 0 | Local Park 2 | 4 | |
14251 | 14251 | 14250 | {"type": "Polygon", "coordinates": [[[-121.42746, 38.41856], [-121.42711, 38.41877], [-121.42686, 38.41896], [-121.42672, 38.41887], [-121.42648, 38.41876], [-121.42649, 38.41867], [-121.4262, 38.41859], [-121.42594, 38.41855], [-121.42562, 38.41854], [-121.42533, 38.41857], [-121.42511, 38.41862], [-121.4248, 38.41873], [-121.42474, 38.41873], [-121.4247, 38.41871], [-121.42453, 38.41851], [-121.42447, 38.41837], [-121.42479, 38.41839], [-121.42512, 38.41828], [-121.42529, 38.41827], [-121.42576, 38.41831], [-121.42592, 38.41809], [-121.42598, 38.41807], [-121.42603, 38.41803], [-121.42605, 38.41798], [-121.42602, 38.41792], [-121.42644, 38.41746], [-121.42644, 38.41728], [-121.42651, 38.4173], [-121.42661, 38.41729], [-121.42667, 38.41726], [-121.42671, 38.41721], [-121.42671, 38.41714], [-121.42668, 38.41706], [-121.42668, 38.4167], [-121.42671, 38.41658], [-121.42669, 38.41652], [-121.42663, 38.41647], [-121.42668, 38.41641], [-121.42668, 38.41619], [-121.4271, 38.41619], [-121.42711, 38.41661], [-121.42724, 38.41698], [-121.42714, 38.41703], [-121.42715, 38.41802], [-121.42718, 38.41815], [-121.42724, 38.41828], [-121.42746, 38.41856]]]} | Open Access 1 | 44169 | Lichtenberger Park | 21225 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.116 | Lichtenberger 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]);