units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 397 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, GAP_STS
DES_TP 12
- Local Park 41
- Local Recreation Area 6
- Local Conservation Area 1
- Local Other or Unknown 1
- 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 57
MNG_AGENCY 1
- Redding, City of · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8849 | 8849 | 8848 | {"type": "MultiPolygon", "coordinates": [[[[-122.36715, 40.58632], [-122.367, 40.58675], [-122.36655, 40.58706], [-122.36559, 40.58763], [-122.36512, 40.58778], [-122.36471, 40.58802], [-122.36363, 40.5889], [-122.36323, 40.58934], [-122.3622, 40.58935], [-122.36219, 40.58931], [-122.36214, 40.58929], [-122.36099, 40.58931], [-122.36127, 40.58849], [-122.36163, 40.58793], [-122.36227, 40.5875], [-122.36295, 40.5872], [-122.36329, 40.58681], [-122.36377, 40.58642], [-122.36435, 40.58629], [-122.36512, 40.58625], [-122.36517, 40.58621], [-122.36525, 40.5862], [-122.36715, 40.58632]]], [[[-122.3784, 40.58752], [-122.37836, 40.5879], [-122.37811, 40.58817], [-122.37642, 40.58984], [-122.37589, 40.58941], [-122.3756, 40.58986], [-122.37555, 40.59047], [-122.37576, 40.59099], [-122.37612, 40.59155], [-122.37386, 40.59156], [-122.37183, 40.59166], [-122.37085, 40.59163], [-122.36993, 40.59131], [-122.37021, 40.59114], [-122.37022, 40.59112], [-122.37022, 40.59111], [-122.36908, 40.5909], [-122.36762, 40.59082], [-122.36662, 40.59067], [-122.36573, 40.59012], [-122.36492, 40.58942], [-122.36553, 40.58909], [-122.36611, 40.58956], [-122.36727, 40.58982], [-122.36834, 40.58944], [-122.36907, 40.58882], [-122.36964, 40.5882], [-122.37003, 40.58784], [-122.36955, 40.58736], [-122.3694, 40.58638], [-122.37158, 40.58654], [-122.372, 40.58654], [-122.37662, 40.58685], [-122.37752, 40.58707], [-122.37802, 40.58725], [-122.37818, 40.58735], [-122.37824, 40.58742], [-122.37828, 40.58751], [-122.3784, 40.58752]]]]} | Open Access 1 | 14464 | Turtle Bay | 32808 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 118.162 | Turtle Bay | None 742 | |||
8812 | 8812 | 8811 | {"type": "MultiPolygon", "coordinates": [[[[-122.36938, 40.60315], [-122.36928, 40.60327], [-122.36919, 40.60346], [-122.36913, 40.60367], [-122.36912, 40.60377], [-122.36597, 40.6033], [-122.36513, 40.60346], [-122.36477, 40.60236], [-122.36435, 40.60213], [-122.36339, 40.60203], [-122.36335, 40.60023], [-122.36479, 40.60021], [-122.3648, 40.60143], [-122.36532, 40.60165], [-122.36574, 40.60123], [-122.36649, 40.6018], [-122.36652, 40.602], [-122.36938, 40.60315]]], [[[-122.37101, 40.60358], [-122.37056, 40.60414], [-122.37044, 40.60417], [-122.37058, 40.60455], [-122.37002, 40.60475], [-122.36978, 40.60389], [-122.36938, 40.60393], [-122.36936, 40.60386], [-122.36935, 40.6037], [-122.36938, 40.60355], [-122.36949, 40.60333], [-122.36974, 40.60301], [-122.36984, 40.60291], [-122.3701, 40.6027], [-122.37025, 40.60261], [-122.37054, 40.6029], [-122.37031, 40.60311], [-122.37101, 40.60358]]]]} | Open Access 1 | 14341 | Peppertree Park | 23599 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 24.154 | Peppertree Park | 0 | Local Park 2 | 4 | |
16199 | 16199 | 16198 | {"type": "MultiPolygon", "coordinates": [[[[-122.37586, 40.56819], [-122.37338, 40.57006], [-122.37343, 40.57181], [-122.3722, 40.5716], [-122.37067, 40.5713], [-122.37071, 40.57122], [-122.3715, 40.57134], [-122.37183, 40.57129], [-122.37237, 40.57072], [-122.37246, 40.56996], [-122.37263, 40.56997], [-122.37265, 40.5699], [-122.37283, 40.56992], [-122.37284, 40.56988], [-122.37304, 40.56989], [-122.37304, 40.56994], [-122.37322, 40.56995], [-122.37348, 40.56954], [-122.3735, 40.56933], [-122.37335, 40.56931], [-122.37334, 40.56914], [-122.37399, 40.56921], [-122.37395, 40.56774], [-122.37568, 40.56775], [-122.37586, 40.56819]]], [[[-122.37566, 40.56733], [-122.37328, 40.56735], [-122.37315, 40.56371], [-122.3746, 40.56372], [-122.37556, 40.56533], [-122.3757, 40.56594], [-122.37586, 40.5665], [-122.37583, 40.56699], [-122.37566, 40.56733]]]]} | Open Access 1 | 48814 | Henderson Open Space | 33534 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | https://www.cityofredding.org/Home/Components/FacilityDirectory/FacilityDirectory/120/626?npage=2 | Shasta 27 | 29.961 | Henderson OS | 0 | Local Recreation Area 3 | 4 |
13668 | 13668 | 13667 | {"type": "MultiPolygon", "coordinates": [[[[-122.3778, 40.56995], [-122.37773, 40.5701], [-122.3777, 40.57024], [-122.3777, 40.5704], [-122.37774, 40.57059], [-122.37773, 40.57063], [-122.37769, 40.57066], [-122.37747, 40.57077], [-122.37732, 40.57092], [-122.37711, 40.5713], [-122.37709, 40.5713], [-122.37695, 40.57161], [-122.37692, 40.57165], [-122.37685, 40.57167], [-122.37667, 40.57165], [-122.37642, 40.57167], [-122.37547, 40.57182], [-122.37535, 40.5719], [-122.37481, 40.57194], [-122.37474, 40.57197], [-122.37461, 40.57199], [-122.37458, 40.57202], [-122.37442, 40.57199], [-122.37494, 40.57155], [-122.37551, 40.57115], [-122.37577, 40.57082], [-122.37613, 40.57044], [-122.37653, 40.56986], [-122.37658, 40.56962], [-122.37723, 40.56968], [-122.3778, 40.56995]]], [[[-122.37914, 40.57064], [-122.37793, 40.57059], [-122.37788, 40.57054], [-122.37784, 40.57039], [-122.37784, 40.57023], [-122.37788, 40.57011], [-122.37793, 40.57001], [-122.37906, 40.57059], [-122.37914, 40.57064]]]]} | Open Access 1 | 36036 | Parkview Riverfront Park and Trails | 23459 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 8.943 | Parkview Riverfront Park and Trails | None 1176 | |||
9279 | 9279 | 9278 | {"type": "MultiPolygon", "coordinates": [[[[-122.39912, 40.59395], [-122.39899, 40.59436], [-122.39882, 40.59477], [-122.39859, 40.59517], [-122.39824, 40.59565], [-122.39805, 40.59561], [-122.39782, 40.59558], [-122.39746, 40.59558], [-122.3973, 40.59556], [-122.39627, 40.59528], [-122.39579, 40.59523], [-122.39524, 40.59523], [-122.39488, 40.59529], [-122.39409, 40.59549], [-122.39233, 40.59606], [-122.39216, 40.5961], [-122.39198, 40.59612], [-122.39179, 40.59612], [-122.39155, 40.59607], [-122.39141, 40.59602], [-122.39123, 40.59592], [-122.39113, 40.59583], [-122.39009, 40.59464], [-122.38985, 40.59442], [-122.38982, 40.59432], [-122.38986, 40.59425], [-122.39035, 40.59377], [-122.39062, 40.5936], [-122.39136, 40.59297], [-122.3917, 40.59262], [-122.39236, 40.59284], [-122.39379, 40.59338], [-122.39602, 40.59368], [-122.39696, 40.59382], [-122.39813, 40.59392], [-122.39912, 40.59395]]], [[[-122.39813, 40.59579], [-122.39781, 40.59613], [-122.39744, 40.59645], [-122.39618, 40.59742], [-122.39605, 40.59691], [-122.39603, 40.59675], [-122.39563, 40.59675], [-122.39543, 40.59673], [-122.39503, 40.59665], [-122.39325, 40.59616], [-122.39319, 40.59612], [-122.39317, 40.59606], [-122.39318, 40.59601], [-122.39324, 40.59597], [-122.39416, 40.59567], [-122.39456, 40.59556], [-122.39502, 40.59546], [-122.3951, 40.59547], [-122.39515, 40.59551], [-122.39525, 40.5955], [-122.39529, 40.59545], [-122.39534, 40.59543], [-122.39588, 40.59544], [-122.39626, 40.59548], [-122.39645, 40.59553], [-122.39673, 40.59561], [-122.39678, 40.59565], [-122.39678, 40.59571], [-122.39687, 40.59573], [-122.39697, 40.59568], [-122.39711, 40.59572], [-122.39742, 40.59576], [-122.39813, 40.59579]]]]} | Open Access 1 | 15460 | Caldwell Park | 16675 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 53.31 | Caldwell Park | 0 | Local Park 2 | 4 | |
8886 | 8886 | 8885 | {"type": "MultiPolygon", "coordinates": [[[[-122.40043, 40.59672], [-122.39835, 40.59669], [-122.39835, 40.59669], [-122.39867, 40.5964], [-122.39886, 40.59619], [-122.39893, 40.59622], [-122.39895, 40.59628], [-122.39902, 40.5963], [-122.39905, 40.59628], [-122.3991, 40.59627], [-122.40043, 40.59672]]], [[[-122.40163, 40.59392], [-122.40162, 40.59423], [-122.40122, 40.59516], [-122.40117, 40.59519], [-122.40111, 40.5952], [-122.40106, 40.59531], [-122.40111, 40.59534], [-122.40112, 40.59539], [-122.40067, 40.59642], [-122.40065, 40.59645], [-122.40059, 40.59647], [-122.40052, 40.59647], [-122.39906, 40.59596], [-122.3992, 40.59579], [-122.39947, 40.5954], [-122.39969, 40.595], [-122.39978, 40.59483], [-122.39996, 40.5944], [-122.40008, 40.59396], [-122.40163, 40.59392]]]]} | Open Access 1 | 14530 | Lake Redding Park | 20963 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 9.977 | Lake Redding Park | 0 | Local Park 2 | 4 | |
1900 | 1900 | 1899 | {"type": "Polygon", "coordinates": [[[-122.29578, 40.56031], [-122.29578, 40.56147], [-122.29483, 40.56147], [-122.29482, 40.56112], [-122.29503, 40.56099], [-122.29514, 40.56089], [-122.29523, 40.56078], [-122.29532, 40.56059], [-122.29533, 40.56031], [-122.29578, 40.56031]]]} | Open Access 1 | 14660 | Stillwater Heights Park | 25852 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.872 | Stillwater Heights Park | 0 | Local Park 2 | 4 | |
3349 | 3349 | 3348 | {"type": "Polygon", "coordinates": [[[-122.3076, 40.57465], [-122.30296, 40.57463], [-122.30287, 40.5745], [-122.30289, 40.57104], [-122.3076, 40.57103], [-122.3076, 40.57465]]]} | Open Access 1 | 24175 | Redding Soccer Park | 24234 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 39.524 | Redding Soccer Park | 0 | Local Recreation Area 3 | 4 | |
14345 | 14345 | 14344 | {"type": "Polygon", "coordinates": [[[-122.30999, 40.57599], [-122.30898, 40.57598], [-122.309, 40.57833], [-122.30524, 40.57832], [-122.30525, 40.57464], [-122.30759, 40.57465], [-122.3076, 40.57428], [-122.30798, 40.57427], [-122.30831, 40.57428], [-122.30864, 40.57441], [-122.30902, 40.57469], [-122.30997, 40.57466], [-122.30999, 40.57599]]]} | Open Access 1 | 44418 | Big League Dreams Sports Park | 16081 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 35.914 | Big League Dreams Sports Park | 0 | Local Recreation Area 3 | 4 | |
9065 | 9065 | 9064 | {"type": "Polygon", "coordinates": [[[-122.32063, 40.5651], [-122.32034, 40.5651], [-122.32033, 40.56473], [-122.32062, 40.56473], [-122.32063, 40.5651]]]} | Open Access 1 | 15005 | Hawn Park | 19750 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.249 | Hawn Park | 0 | Local Park 2 | 4 | |
4253 | 4253 | 4252 | {"type": "Polygon", "coordinates": [[[-122.32107, 40.56945], [-122.32105, 40.5701], [-122.32103, 40.5702], [-122.32098, 40.57029], [-122.32093, 40.57036], [-122.32089, 40.57038], [-122.3208, 40.57037], [-122.31959, 40.56979], [-122.31959, 40.56969], [-122.32107, 40.56945]]]} | Open Access 1 | 14363 | Clover Creek Park | 17435 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.875 | Clover Creek Park | 0 | Local Park 2 | 4 | |
13669 | 13669 | 13668 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55437], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.31451, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55227], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31297, 40.55162], [-122.31212, 40.55114], [-122.31165, 40.55096], [-122.31126, 40.55071], [-122.31081, 40.55051], [-122.3106, 40.55038], [-122.30834, 40.54925], [-122.31485, 40.54923], [-122.31486, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31615, 40.54982], [-122.31622, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54977], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55102], [-122.31848, 40.55103], [-122.32024, 40.552], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | 36037 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 127.579 | Clover Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
8863 | 8863 | 8862 | {"type": "Polygon", "coordinates": [[[-122.32243, 40.57834], [-122.32243, 40.57907], [-122.32199, 40.57906], [-122.32197, 40.57834], [-122.32243, 40.57834]]]} | Open Access 1 | 14489 | Ravenwood Park | 24200 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.771 | Ravenwood Park | 0 | Local Park 2 | 4 | |
1743 | 1743 | 1742 | {"type": "Polygon", "coordinates": [[[-122.3268, 40.54679], [-122.32658, 40.54734], [-122.32639, 40.54734], [-122.32571, 40.54716], [-122.32576, 40.54637], [-122.32627, 40.54648], [-122.32654, 40.54669], [-122.3268, 40.54679]]]} | Open Access 1 | 14979 | Western Oaks Park | 27393 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.712 | Western Oaks Park | 0 | Local Park 2 | 4 | |
1651 | 1651 | 1650 | {"type": "Polygon", "coordinates": [[[-122.32758, 40.5533], [-122.32754, 40.55568], [-122.32646, 40.55569], [-122.32648, 40.55333], [-122.32654, 40.55329], [-122.32758, 40.5533]]]} | Open Access 1 | 14206 | Alta Mesa park | 15417 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 6.04 | Alta Mesa park | None 134 | |||
13772 | 13772 | 13771 | {"type": "Polygon", "coordinates": [[[-122.33303, 40.65548], [-122.33271, 40.65558], [-122.33214, 40.65571], [-122.33134, 40.65671], [-122.33143, 40.65679], [-122.33162, 40.65705], [-122.33152, 40.6574], [-122.33089, 40.6578], [-122.33071, 40.65846], [-122.33013, 40.65841], [-122.3297, 40.65941], [-122.32912, 40.65953], [-122.32918, 40.65918], [-122.32917, 40.65909], [-122.32912, 40.65893], [-122.329, 40.65879], [-122.329, 40.65874], [-122.32921, 40.65848], [-122.32936, 40.65828], [-122.32941, 40.65819], [-122.32951, 40.65795], [-122.32973, 40.65777], [-122.32985, 40.65746], [-122.33022, 40.65671], [-122.33077, 40.65619], [-122.33222, 40.65514], [-122.33228, 40.65518], [-122.33261, 40.65497], [-122.33292, 40.65525], [-122.333, 40.65538], [-122.33303, 40.65548]]]} | Open Access 1 | 36313 | Redding holding 1 | 24232 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 11.159 | Redding holding 1 | 0 | Local Other or Unknown 14 | 4 | |
1903 | 1903 | 1902 | {"type": "Polygon", "coordinates": [[[-122.33749, 40.59585], [-122.33659, 40.59638], [-122.3362, 40.59601], [-122.33626, 40.59604], [-122.33632, 40.59606], [-122.33639, 40.59606], [-122.33646, 40.59603], [-122.33651, 40.59599], [-122.33653, 40.59593], [-122.33652, 40.59587], [-122.33649, 40.59584], [-122.3371, 40.59547], [-122.33749, 40.59585]]]} | Open Access 1 | 14692 | Minder Park | 22259 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.176 | Minder Park | 0 | Local Park 2 | 4 | |
9029 | 9029 | 9028 | {"type": "Polygon", "coordinates": [[[-122.34342, 40.54925], [-122.34026, 40.54929], [-122.33661, 40.5493], [-122.33662, 40.54563], [-122.33654, 40.54199], [-122.3391, 40.54199], [-122.33934, 40.54222], [-122.33967, 40.54281], [-122.33954, 40.54317], [-122.33981, 40.54565], [-122.34334, 40.54567], [-122.34342, 40.54925]]]} | Open Access 1 | 14944 | Enterprise Community Park | 18684 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 82.829 | Enterprise Community Park | 0 | Local Park 2 | 4 | |
3179 | 3179 | 3178 | {"type": "Polygon", "coordinates": [[[-122.34442, 40.56839], [-122.34442, 40.56861], [-122.34406, 40.5686], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839]]]} | Open Access 1 | 22034 | Foxtail Park | 19038 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.216 | Foxtail Park | 0 | Local Park 2 | 4 | |
2000 | 2000 | 1999 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34406, 40.5686], [-122.34441, 40.5686], [-122.34443, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | 15313 | Foxtail Park | 19038 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.593 | Foxtail 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]);