units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where LAYER = 10, MNG_AGENCY = 358 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
ACCESS_TYP 3
DES_TP 2
MNG_AG_TYP 1
- Non Profit - Land Trust · 8 ✖
MNG_AGENCY 1
- Solano Land Trust · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1404 | 1404 | 1403 | {"type": "Polygon", "coordinates": [[[-122.19364, 38.14035], [-122.19255, 38.14085], [-122.19094, 38.14174], [-122.18499, 38.14511], [-122.18197, 38.14671], [-122.181, 38.14603], [-122.18073, 38.14577], [-122.17709, 38.14318], [-122.17439, 38.14115], [-122.17323, 38.14032], [-122.17291, 38.14042], [-122.17248, 38.14069], [-122.17242, 38.1407], [-122.17245, 38.14065], [-122.17237, 38.14024], [-122.17271, 38.14009], [-122.17271, 38.14007], [-122.1676, 38.13214], [-122.16758, 38.13205], [-122.1682, 38.13241], [-122.17857, 38.12654], [-122.18461, 38.12402], [-122.18657, 38.12318], [-122.18795, 38.12517], [-122.18982, 38.12792], [-122.18862, 38.12856], [-122.18862, 38.12858], [-122.18901, 38.1289], [-122.18938, 38.12931], [-122.18977, 38.1297], [-122.19033, 38.13018], [-122.19068, 38.13063], [-122.19095, 38.13094], [-122.19139, 38.13124], [-122.19179, 38.13148], [-122.19208, 38.13161], [-122.19238, 38.13177], [-122.19408, 38.13497], [-122.19423, 38.13573], [-122.19448, 38.13723], [-122.19412, 38.13869], [-122.19364, 38.14035]], [[-122.19099, 38.1342], [-122.19123, 38.13468], [-122.19131, 38.13478], [-122.19157, 38.13526], [-122.19183, 38.13515], [-122.19156, 38.13457], [-122.19133, 38.13422], [-122.1909, 38.13352], [-122.19067, 38.13331], [-122.19034, 38.13316], [-122.18936, 38.13246], [-122.18847, 38.13188], [-122.18796, 38.13157], [-122.18726, 38.13108], [-122.18631, 38.13097], [-122.1859, 38.13091], [-122.18525, 38.13097], [-122.18611, 38.13175], [-122.18555, 38.13206], [-122.18555, 38.13207], [-122.18649, 38.13293], [-122.18679, 38.13315], [-122.18704, 38.13336], [-122.18772, 38.13324], [-122.18846, 38.13375], [-122.18936, 38.13477], [-122.18982, 38.1347], [-122.1903, 38.13436], [-122.19041, 38.13416], [-122.19078, 38.13407], [-122.19099, 38.1342]]]} | Restricted Access 2 | 8824 | Vallejo Swett | 26783 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 861.807 | Vallejo Swett | 1999 | Private Conservation 16 | 2 | |
2376 | 2376 | 2375 | {"type": "Polygon", "coordinates": [[[-122.14962, 38.16492], [-122.14827, 38.16492], [-122.14383, 38.16372], [-122.14268, 38.16401], [-122.14097, 38.16366], [-122.1404, 38.16353], [-122.1403, 38.16348], [-122.13817, 38.16059], [-122.13799, 38.16055], [-122.13779, 38.16009], [-122.13516, 38.15925], [-122.13438, 38.15924], [-122.1332, 38.15863], [-122.13319, 38.15864], [-122.13323, 38.15938], [-122.13347, 38.16], [-122.13346, 38.16038], [-122.1328, 38.16056], [-122.12629, 38.16307], [-122.12495, 38.16282], [-122.12063, 38.16183], [-122.12048, 38.16095], [-122.11981, 38.16003], [-122.11869, 38.16047], [-122.11495, 38.1562], [-122.12004, 38.15349], [-122.12095, 38.14364], [-122.14773, 38.14371], [-122.14962, 38.16492]]]} | Restricted Access 2 | 17191 | King Ranch | 20659 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1313.512 | King Ranch | 2002 | Private Conservation 16 | 2 | |
5596 | 5596 | 5595 | {"type": "Polygon", "coordinates": [[[-122.16317, 38.26342], [-122.16304, 38.26457], [-122.16289, 38.26488], [-122.16282, 38.26526], [-122.16275, 38.26549], [-122.16266, 38.2657], [-122.16195, 38.26717], [-122.16224, 38.2679], [-122.16257, 38.26905], [-122.16284, 38.27014], [-122.16307, 38.27081], [-122.16288, 38.27111], [-122.16026, 38.27474], [-122.15949, 38.27508], [-122.15854, 38.27538], [-122.15786, 38.27533], [-122.15697, 38.27515], [-122.15593, 38.27509], [-122.15389, 38.27474], [-122.15229, 38.27479], [-122.15135, 38.27503], [-122.15097, 38.2751], [-122.15009, 38.27511], [-122.14943, 38.27508], [-122.14882, 38.27519], [-122.14823, 38.27604], [-122.1478, 38.27661], [-122.14631, 38.27761], [-122.13521, 38.27753], [-122.12964, 38.27753], [-122.12964, 38.27358], [-122.12749, 38.27358], [-122.12613, 38.27372], [-122.12677, 38.27314], [-122.12722, 38.27235], [-122.12864, 38.27056], [-122.12997, 38.26942], [-122.13099, 38.26817], [-122.13233, 38.26904], [-122.13255, 38.26879], [-122.13276, 38.26866], [-122.13302, 38.26858], [-122.13329, 38.26857], [-122.1335, 38.26861], [-122.13368, 38.26868], [-122.13376, 38.26873], [-122.13394, 38.2689], [-122.13404, 38.26897], [-122.13452, 38.26921], [-122.13467, 38.26831], [-122.13469, 38.26791], [-122.13469, 38.26771], [-122.13465, 38.26747], [-122.1346, 38.26732], [-122.13447, 38.26712], [-122.13374, 38.26611], [-122.13321, 38.26499], [-122.13249, 38.26377], [-122.13207, 38.26273], [-122.13199, 38.26246], [-122.13191, 38.26232], [-122.13177, 38.26151], [-122.13167, 38.2608], [-122.13078, 38.26054], [-122.13299, 38.25698], [-122.13349, 38.25596], [-122.13646, 38.25362], [-122.13716, 38.25378], [-122.13767, 38.25385], [-122.1381, 38.25388], [-122.13872, 38.25387], [-122.13915, 38.25382], [-122.13974, 38.25371], [-122.14001, 38.25365], [-122.14171, 38.25305], [-122.14246, 38.25282], [-122.14343, 38.25454], [-122.14393, 38.2555], [-122.14397, 38.25573], [-122.14406, 38.25575], [-122.14825, 38.25531], [-122.14953, 38.25523], [-122.15289, 38.25406], [-122.15289, 38.25346], [-122.15461, 38.25303], [-122.15561, 38.25282], [-122.1576, 38.25255], [-122.15744, 38.25221], [-122.15741, 38.25212], [-122.15742, 38.25209], [-122.15733, 38.25189], [-122.15733, 38.25176], [-122.15735, 38.25169], [-122.15763, 38.25182], [-122.15782, 38.2522], [-122.15779, 38.25262], [-122.15788, 38.25266], [-122.15749, 38.25327], [-122.15828, 38.25467], [-122.15867, 38.25522], [-122.15877, 38.2554], [-122.15876, 38.2556], [-122.15817, 38.25561], [-122.15798, 38.25577], [-122.15808, 38.25637], [-122.15826, 38.25644], [-122.15879, 38.25637], [-122.15885, 38.25655], [-122.1589, 38.25716], [-122.159, 38.25759], [-122.15912, 38.25797], [-122.15928, 38.25874], [-122.15935, 38.25894], [-122.15937, 38.25965], [-122.15941, 38.26015], [-122.15918, 38.26085], [-122.15922, 38.26103], [-122.15916, 38.26174], [-122.15925, 38.26207], [-122.1592, 38.26243], [-122.15946, 38.26348], [-122.15969, 38.26398], [-122.15971, 38.26398], [-122.16233, 38.26243], [-122.16237, 38.26247], [-122.16206, 38.2631], [-122.1625, 38.26349], [-122.16317, 38.26342]]]} | Restricted Access 2 | 35116 | Rockville Trails Preserve | 28161 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/RockvilleTrails.aspx | Solano 26 | 1573.93 | Rockville Trails Preserve | 0 | Private Conservation 16 | 2 |
6475 | 6475 | 6474 | {"type": "Polygon", "coordinates": [[[-121.89617, 38.24991], [-121.89615, 38.24998], [-121.87929, 38.26469], [-121.87398, 38.27128], [-121.87387, 38.27167], [-121.86064, 38.27158], [-121.84224, 38.27129], [-121.8423, 38.26401], [-121.85159, 38.26407], [-121.85163, 38.25686], [-121.86065, 38.25686], [-121.87945, 38.25708], [-121.87968, 38.24283], [-121.88134, 38.24278], [-121.88895, 38.24283], [-121.88894, 38.24989], [-121.89617, 38.24991]]]} | No Public Access 3 | 2063 | Wilcox Ranch | 27495 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1547.196 | Wilcox Ranch | 0 | Private Conservation 16 | 2 | |
7795 | 7795 | 7794 | {"type": "Polygon", "coordinates": [[[-122.1729, 38.16479], [-122.14962, 38.16492], [-122.14663, 38.13128], [-122.16514, 38.13302], [-122.16508, 38.13304], [-122.16505, 38.13338], [-122.16517, 38.13339], [-122.17024, 38.14122], [-122.17098, 38.14089], [-122.17096, 38.14104], [-122.17094, 38.14109], [-122.16917, 38.14194], [-122.16924, 38.14268], [-122.1697, 38.1454], [-122.17088, 38.15287], [-122.17224, 38.16075], [-122.1729, 38.16479]]]} | Restricted Access 2 | 8836 | Eastern Swett | 18392 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 1715.026 | Eastern Swett | 2002 | Private Conservation 16 | 2 | |
10088 | 10088 | 10087 | {"type": "Polygon", "coordinates": [[[-122.21548, 38.18844], [-122.20971, 38.18989], [-122.2097, 38.1899], [-122.20972, 38.18993], [-122.20957, 38.18997], [-122.20942, 38.19007], [-122.20927, 38.19031], [-122.20939, 38.19045], [-122.20962, 38.19067], [-122.2102, 38.19107], [-122.21063, 38.19142], [-122.21102, 38.19176], [-122.21125, 38.19204], [-122.21086, 38.19191], [-122.21039, 38.1919], [-122.20803, 38.19229], [-122.2065, 38.19244], [-122.20517, 38.19253], [-122.20303, 38.195], [-122.20038, 38.19816], [-122.19827, 38.19743], [-122.18154, 38.19131], [-122.17397, 38.18864], [-122.17227, 38.18783], [-122.17294, 38.18746], [-122.17317, 38.18734], [-122.17373, 38.1871], [-122.17404, 38.187], [-122.17455, 38.18669], [-122.17517, 38.18645], [-122.17589, 38.18624], [-122.177, 38.18601], [-122.17825, 38.18569], [-122.17876, 38.18564], [-122.17926, 38.1855], [-122.18022, 38.1852], [-122.18082, 38.18493], [-122.18155, 38.18446], [-122.18212, 38.18393], [-122.18282, 38.18333], [-122.18367, 38.18248], [-122.1846, 38.18173], [-122.18525, 38.18092], [-122.18609, 38.1804], [-122.18671, 38.18021], [-122.18724, 38.17988], [-122.18769, 38.1795], [-122.18813, 38.17926], [-122.18895, 38.17876], [-122.1896, 38.17833], [-122.1904, 38.17862], [-122.19569, 38.18033], [-122.20124, 38.18226], [-122.20456, 38.18336], [-122.20852, 38.17882], [-122.20856, 38.17702], [-122.20843, 38.17334], [-122.20855, 38.17294], [-122.20885, 38.17308], [-122.20916, 38.17343], [-122.21013, 38.17418], [-122.21058, 38.17411], [-122.21097, 38.17455], [-122.211, 38.17485], [-122.21097, 38.175], [-122.21098, 38.17511], [-122.21097, 38.17545], [-122.21112, 38.17572], [-122.21146, 38.17591], [-122.21166, 38.17631], [-122.21193, 38.17662], [-122.21208, 38.17687], [-122.21289, 38.17725], [-122.21347, 38.17773], [-122.21373, 38.17806], [-122.2141, 38.17832], [-122.21444, 38.1787], [-122.21482, 38.17925], [-122.21499, 38.17946], [-122.21492, 38.17987], [-122.21465, 38.18028], [-122.21414, 38.18069], [-122.21366, 38.18093], [-122.21364, 38.18099], [-122.21359, 38.18105], [-122.21344, 38.18133], [-122.21336, 38.18173], [-122.21328, 38.18201], [-122.21335, 38.1826], [-122.21346, 38.18297], [-122.21354, 38.18331], [-122.21342, 38.18371], [-122.21326, 38.18399], [-122.21298, 38.18429], [-122.21282, 38.18454], [-122.21286, 38.18479], [-122.21325, 38.1851], [-122.21363, 38.18587], [-122.2139, 38.18631], [-122.21544, 38.18836], [-122.21548, 38.18844]]]} | Restricted Access 2 | 17506 | Lynch Canyon | 29277 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/LynchCanyon.aspx | Solano 26 | 1152.887 | Lynch Canyon | 1994 | Private Conservation 16 | 2 |
10445 | 10445 | 10444 | {"type": "Polygon", "coordinates": [[[-122.03295, 38.30875], [-122.03267, 38.31033], [-122.03235, 38.31105], [-122.03223, 38.31116], [-122.03204, 38.31066], [-122.03188, 38.31051], [-122.03182, 38.31012], [-122.03152, 38.31008], [-122.03114, 38.30986], [-122.03106, 38.31005], [-122.03062, 38.31001], [-122.0305, 38.30968], [-122.03025, 38.30968], [-122.02986, 38.30979], [-122.0296, 38.30975], [-122.02941, 38.30957], [-122.02932, 38.30886], [-122.03083, 38.30883], [-122.03086, 38.30875], [-122.03295, 38.30875]]]} | No Public Access 3 | 18482 | Paradise Valley | 23407 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | Solano 26 | 10.888 | Paradise Valley | 1992 | Private Conservation 16 | 2 | |
15972 | 15972 | 15971 | {"type": "Polygon", "coordinates": [[[-122.03205, 38.21576], [-122.03199, 38.2159], [-122.03163, 38.21621], [-122.03151, 38.21621], [-122.0312, 38.21632], [-122.02996, 38.21683], [-122.02982, 38.21715], [-122.02989, 38.21743], [-122.03, 38.21828], [-122.02988, 38.21849], [-122.03008, 38.21854], [-122.02997, 38.21896], [-122.02979, 38.21912], [-122.02965, 38.21923], [-122.0293, 38.21942], [-122.02899, 38.21912], [-122.02876, 38.21895], [-122.02842, 38.21862], [-122.02802, 38.21838], [-122.02759, 38.21816], [-122.02704, 38.218], [-122.02616, 38.21841], [-122.02546, 38.21854], [-122.02498, 38.2186], [-122.0247, 38.21905], [-122.02456, 38.21939], [-122.02449, 38.21949], [-122.02424, 38.21965], [-122.02444, 38.21995], [-122.0246, 38.22035], [-122.02464, 38.22068], [-122.02503, 38.22075], [-122.02535, 38.22074], [-122.02631, 38.2206], [-122.02662, 38.22052], [-122.02702, 38.22081], [-122.02695, 38.22124], [-122.02682, 38.22172], [-122.02666, 38.22202], [-122.02642, 38.22235], [-122.02612, 38.22229], [-122.02602, 38.22201], [-122.02602, 38.22161], [-122.02594, 38.22134], [-122.02578, 38.2212], [-122.02545, 38.22117], [-122.02506, 38.22117], [-122.02465, 38.22132], [-122.02394, 38.22167], [-122.02374, 38.22182], [-122.02316, 38.22212], [-122.02297, 38.22213], [-122.02257, 38.22221], [-122.02236, 38.22267], [-122.02214, 38.22292], [-122.02183, 38.22353], [-122.02184, 38.22393], [-122.02184, 38.22458], [-122.02197, 38.22501], [-122.02223, 38.22511], [-122.02252, 38.22533], [-122.02299, 38.22561], [-122.02322, 38.22563], [-122.02358, 38.22595], [-122.02342, 38.22609], [-122.02316, 38.22615], [-122.02292, 38.2261], [-122.02254, 38.22589], [-122.02178, 38.22575], [-122.02146, 38.22582], [-122.02121, 38.22602], [-122.02104, 38.22631], [-122.0211, 38.22692], [-122.02113, 38.22742], [-122.02102, 38.22784], [-122.02082, 38.228], [-122.02048, 38.22815], [-122.01981, 38.22829], [-122.01943, 38.22827], [-122.01908, 38.22809], [-122.01902, 38.22767], [-122.01914, 38.22729], [-122.01945, 38.22684], [-122.01948, 38.22656], [-122.01984, 38.22618], [-122.0202, 38.22587], [-122.02035, 38.22571], [-122.02052, 38.22534], [-122.01997, 38.22483], [-122.01969, 38.22454], [-122.01937, 38.22414], [-122.01921, 38.22369], [-122.01907, 38.22316], [-122.01898, 38.22308], [-122.01867, 38.22305], [-122.01791, 38.2228], [-122.01747, 38.22286], [-122.01737, 38.22295], [-122.01697, 38.22313], [-122.01672, 38.22319], [-122.01659, 38.22342], [-122.01653, 38.2236], [-122.01658, 38.22396], [-122.01683, 38.22407], [-122.01709, 38.22409], [-122.01756, 38.22419], [-122.01773, 38.22449], [-122.01769, 38.22496], [-122.01767, 38.22536], [-122.01778, 38.22552], [-122.01793, 38.22587], [-122.01795, 38.2262], [-122.01779, 38.2263], [-122.01618, 38.22606], [-122.01579, 38.22595], [-122.01546, 38.22574], [-122.0151, 38.22524], [-122.01477, 38.22523], [-122.01482, 38.22521], [-122.01484, 38.22468], [-122.01437, 38.2236], [-122.0141, 38.2234], [-122.01411, 38.22336], [-122.01403, 38.22316], [-122.0139, 38.22309], [-122.01369, 38.22307], [-122.01342, 38.22311], [-122.0126, 38.22025], [-122.01138, 38.21489], [-122.00995, 38.20984], [-122.00725, 38.2096], [-122.0092, 38.20838], [-122.01085, 38.20677], [-122.01103, 38.20618], [-122.01111, 38.20527], [-122.0107, 38.20449], [-122.01077, 38.20419], [-122.00984, 38.2012], [-122.00988, 38.20067], [-122.00984, 38.20046], [-122.00968, 38.20013], [-122.00919, 38.19981], [-122.00887, 38.19871], [-122.00914, 38.19868], [-122.01003, 38.19839], [-122.01131, 38.19751], [-122.01221, 38.1968], [-122.01242, 38.19647], [-122.01243, 38.19644], [-122.01245, 38.19643], [-122.01261, 38.19616], [-122.01264, 38.19587], [-122.01299, 38.19559], [-122.01476, 38.19522], [-122.01842, 38.19498], [-122.02227, 38.19512], [-122.02309, 38.1953], [-122.02456, 38.19596], [-122.02561, 38.1966], [-122.02651, 38.19755], [-122.02732, 38.19869], [-122.02729, 38.19956], [-122.02677, 38.2008], [-122.027, 38.20186], [-122.02653, 38.20294], [-122.02575, 38.20342], [-122.02566, 38.2037], [-122.02575, 38.20399], [-122.0261, 38.20441], [-122.02659, 38.20487], [-122.02697, 38.20519], [-122.0281, 38.20569], [-122.02938, 38.20615], [-122.02998, 38.2067], [-122.03045, 38.20725], [-122.03045, 38.20729], [-122.03074, 38.20743], [-122.03134, 38.20828], [-122.03036, 38.20808], [-122.02981, 38.20872], [-122.02978, 38.20901], [-122.02961, 38.2092], [-122.02961, 38.20931], [-122.02978, 38.20947], [-122.03013, 38.20961], [-122.03027, 38.21036], [-122.03036, 38.21048], [-122.03036, 38.21073], [-122.03065, 38.21137], [-122.03076, 38.21167], [-122.03074, 38.21201], [-122.03001, 38.21281], [-122.03001, 38.21359], [-122.03062, 38.21482], [-122.0314, 38.2149], [-122.03205, 38.21576]]]} | Open Access 1 | 308 | Rush Ranch Open Space | 12546 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/RushRanch.aspx | Solano 26 | 1177.494 | Rush Ranch OS | 1987 | Private Recreation or Education 65 | 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]);