units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_ID = 2304, DES_TP = 8 and MNG_AG_ID = 201
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3112 | 3112 | 3111 | {"type": "MultiPolygon", "coordinates": [[[[-122.55075, 39.08503], [-122.5498, 39.08524], [-122.54905, 39.08484], [-122.54876, 39.085], [-122.54876, 39.08502], [-122.54925, 39.08551], [-122.54937, 39.08585], [-122.54919, 39.08598], [-122.54844, 39.08541], [-122.54752, 39.08552], [-122.54658, 39.08575], [-122.54593, 39.08606], [-122.54563, 39.08671], [-122.54603, 39.08738], [-122.54607, 39.08907], [-122.54606, 39.09069], [-122.54541, 39.0913], [-122.54496, 39.09326], [-122.54551, 39.09431], [-122.54579, 39.09444], [-122.54634, 39.09485], [-122.54581, 39.09591], [-122.54674, 39.09648], [-122.5475, 39.09635], [-122.5475, 39.09649], [-122.54608, 39.09704], [-122.54635, 39.09792], [-122.54693, 39.0979], [-122.54659, 39.09906], [-122.5474, 39.10052], [-122.54782, 39.10061], [-122.54777, 39.10081], [-122.54813, 39.10125], [-122.54853, 39.10153], [-122.54929, 39.10278], [-122.55011, 39.10295], [-122.55039, 39.10304], [-122.55045, 39.10308], [-122.55046, 39.10347], [-122.5501, 39.1035], [-122.54995, 39.10343], [-122.54985, 39.1034], [-122.54962, 39.10336], [-122.54953, 39.10335], [-122.549, 39.10359], [-122.5487, 39.10391], [-122.54862, 39.10382], [-122.54856, 39.10381], [-122.54842, 39.10363], [-122.5484, 39.10349], [-122.54845, 39.10342], [-122.54848, 39.10331], [-122.54845, 39.10323], [-122.54737, 39.10271], [-122.54718, 39.1027], [-122.54698, 39.10286], [-122.54687, 39.10292], [-122.54687, 39.10246], [-122.54663, 39.10235], [-122.54606, 39.10238], [-122.54561, 39.10269], [-122.5456, 39.10274], [-122.54545, 39.10289], [-122.54531, 39.10319], [-122.54537, 39.10333], [-122.54498, 39.10314], [-122.54512, 39.10265], [-122.54444, 39.10211], [-122.54476, 39.10169], [-122.54469, 39.10149], [-122.54446, 39.10135], [-122.54477, 39.10009], [-122.54447, 39.10016], [-122.54346, 39.10065], [-122.54316, 39.10063], [-122.54366, 39.09986], [-122.5436, 39.0997], [-122.54286, 39.0998], [-122.54267, 39.09946], [-122.54204, 39.09958], [-122.54175, 39.09956], [-122.54189, 39.09425], [-122.53648, 39.09428], [-122.53653, 39.09803], [-122.53181, 39.09829], [-122.532, 39.11025], [-122.53198, 39.11005], [-122.53199, 39.11], [-122.53172, 39.10987], [-122.5317, 39.10983], [-122.53165, 39.10977], [-122.53166, 39.10973], [-122.53134, 39.10902], [-122.53042, 39.10916], [-122.53019, 39.10889], [-122.53068, 39.10849], [-122.53068, 39.10834], [-122.53032, 39.108], [-122.53043, 39.1074], [-122.5308, 39.107], [-122.53095, 39.10631], [-122.53069, 39.10618], [-122.5294, 39.10674], [-122.52977, 39.10556], [-122.52968, 39.10544], [-122.52955, 39.10544], [-122.52728, 39.10629], [-122.52726, 39.10522], [-122.52761, 39.10496], [-122.52766, 39.10477], [-122.52846, 39.10444], [-122.5286, 39.10434], [-122.52848, 39.1041], [-122.52996, 39.1039], [-122.53056, 39.10301], [-122.53124, 39.10216], [-122.53119, 39.10199], [-122.53111, 39.10189], [-122.53029, 39.10142], [-122.53021, 39.1014], [-122.52999, 39.10142], [-122.52898, 39.10243], [-122.52836, 39.10234], [-122.52779, 39.10235], [-122.52839, 39.10177], [-122.52846, 39.1015], [-122.52844, 39.10137], [-122.52771, 39.10114], [-122.52719, 39.10111], [-122.52718, 39.10053], [-122.52795, 39.10045], [-122.52837, 39.10015], [-122.52917, 39.10026], [-122.52941, 39.09988], [-122.52933, 39.09972], [-122.52918, 39.09952], [-122.52922, 39.09937], [-122.5293, 39.09921], [-122.52922, 39.099], [-122.52898, 39.09886], [-122.52905, 39.09856], [-122.53019, 39.09867], [-122.5304, 39.09806], [-122.53016, 39.09753], [-122.52885, 39.09659], [-122.529, 39.0962], [-122.529, 39.09617], [-122.52894, 39.09612], [-122.52831, 39.09579], [-122.52742, 39.09571], [-122.5271, 39.09563], [-122.52708, 39.09452], [-122.52584, 39.09454], [-122.52571, 39.09408], [-122.52532, 39.09389], [-122.52505, 39.09349], [-122.52514, 39.09315], [-122.5261, 39.09195], [-122.52616, 39.09183], [-122.52612, 39.09171], [-122.52585, 39.09169], [-122.52497, 39.09206], [-122.52443, 39.09252], [-122.52377, 39.09306], [-122.52373, 39.09266], [-122.52381, 39.09257], [-122.5238, 39.09255], [-122.52388, 39.09245], [-122.52392, 39.09235], [-122.5239, 39.09213], [-122.52377, 39.09185], [-122.52401, 39.09159], [-122.52449, 39.09152], [-122.52456, 39.09132], [-122.52449, 39.0911], [-122.52428, 39.091], [-122.52401, 39.09102], [-122.52389, 39.09062], [-122.52417, 39.09052], [-122.52417, 39.0901], [-122.52469, 39.09008], [-122.52521, 39.08951], [-122.52585, 39.08939], [-122.52615, 39.08874], [-122.52547, 39.08841], [-122.52512, 39.08834], [-122.52492, 39.08813], [-122.52492, 39.08783], [-122.52434, 39.08757], [-122.524, 39.08757], [-122.52383, 39.08755], [-122.52381, 39.08746], [-122.52369, 39.08736], [-122.52394, 39.08693], [-122.52415, 39.08684], [-122.52419, 39.08681], [-122.52426, 39.08656], [-122.52422, 39.08645], [-122.524, 39.08624], [-122.52402, 39.08583], [-122.52401, 39.08577], [-122.5236, 39.08511], [-122.52451, 39.08485], [-122.52514, 39.08516], [-122.52698, 39.08458], [-122.52719, 39.08364], [-122.53147, 39.08352], [-122.53172, 39.09081], [-122.53636, 39.09079], [-122.53649, 39.08715], [-122.54156, 39.08709], [-122.54135, 39.08234], [-122.54262, 39.08342], [-122.54264, 39.08348], [-122.54284, 39.08361], [-122.54383, 39.08445], [-122.54421, 39.08444], [-122.54436, 39.08448], [-122.54438, 39.0845], [-122.54468, 39.08457], [-122.54571, 39.08455], [-122.54584, 39.08416], [-122.54619, 39.08399], [-122.54627, 39.08404], [-122.5465, 39.08409], [-122.54666, 39.08414], [-122.547, 39.08401], [-122.54703, 39.08409], [-122.54723, 39.08421], [-122.54726, 39.08426], [-122.54811, 39.08429], [-122.54818, 39.08396], [-122.54876, 39.08403], [-122.54962, 39.0838], [-122.54935, 39.08419], [-122.54952, 39.08434], [-122.55074, 39.08445], [-122.55075, 39.08503]]], [[[-122.55119, 39.1243], [-122.55115, 39.12435], [-122.55031, 39.12438], [-122.53694, 39.12426], [-122.537, 39.12488], [-122.53704, 39.13911], [-122.54175, 39.13911], [-122.54176, 39.14652], [-122.53359, 39.14653], [-122.53402, 39.14598], [-122.53374, 39.14575], [-122.53379, 39.14555], [-122.53338, 39.14524], [-122.5338, 39.14494], [-122.53456, 39.14495], [-122.53475, 39.14468], [-122.5347, 39.14441], [-122.53532, 39.14329], [-122.5349, 39.14294], [-122.53373, 39.14339], [-122.53301, 39.14354], [-122.53214, 39.14342], [-122.53214, 39.14324], [-122.53318, 39.14323], [-122.53444, 39.1424], [-122.53551, 39.14198], [-122.5355, 39.14112], [-122.53547, 39.14099], [-122.53549, 39.14096], [-122.53522, 39.14045], [-122.53558, 39.13948], [-122.53537, 39.13912], [-122.53522, 39.13897], [-122.53536, 39.13888], [-122.53573, 39.13837], [-122.5356, 39.13735], [-122.53543, 39.13702], [-122.5355, 39.13691], [-122.53553, 39.1369], [-122.53563, 39.13678], [-122.53569, 39.13669], [-122.53583, 39.13615], [-122.53559, 39.13602], [-122.53552, 39.13543], [-122.53563, 39.13531], [-122.53556, 39.13488], [-122.53604, 39.13464], [-122.53613, 39.13427], [-122.53601, 39.13367], [-122.5355, 39.13344], [-122.53567, 39.13341], [-122.53588, 39.13332], [-122.53639, 39.13259], [-122.53644, 39.13243], [-122.53613, 39.1321], [-122.53565, 39.12897], [-122.53561, 39.12883], [-122.53512, 39.12889], [-122.53506, 39.12879], [-122.53497, 39.12871], [-122.53487, 39.12861], [-122.53412, 39.12847], [-122.53393, 39.12852], [-122.53375, 39.12858], [-122.5334, 39.12847], [-122.5334, 39.12839], [-122.53369, 39.12836], [-122.53401, 39.12811], [-122.5347, 39.12798], [-122.53568, 39.12756], [-122.5357, 39.12733], [-122.53569, 39.12727], [-122.53546, 39.12713], [-122.53541, 39.12712], [-122.5354, 39.1271], [-122.53532, 39.12704], [-122.53494, 39.12615], [-122.53527, 39.12582], [-122.53524, 39.12552], [-122.53511, 39.12537], [-122.53508, 39.12537], [-122.53505, 39.12526], [-122.53501, 39.12487], [-122.53516, 39.12451], [-122.53485, 39.12363], [-122.53465, 39.12363], [-122.53429, 39.1238], [-122.53379, 39.12473], [-122.53329, 39.12398], [-122.53254, 39.12391], [-122.53311, 39.1233], [-122.53302, 39.12317], [-122.53207, 39.12323], [-122.53205, 39.12254], [-122.53261, 39.12232], [-122.53373, 39.12206], [-122.53383, 39.12119], [-122.532, 39.1208], [-122.53198, 39.12053], [-122.53109, 39.12054], [-122.53184, 39.12022], [-122.53214, 39.1199], [-122.53272, 39.11967], [-122.5327, 39.11916], [-122.53267, 39.11907], [-122.53224, 39.11871], [-122.53221, 39.1187], [-122.53206, 39.11855], [-122.53186, 39.11838], [-122.53116, 39.11844], [-122.5311, 39.11848], [-122.53081, 39.11852], [-122.53059, 39.11867], [-122.53053, 39.11884], [-122.53038, 39.11883], [-122.53012, 39.11891], [-122.53017, 39.11842], [-122.5292, 39.11745], [-122.5282, 39.11728], [-122.52784, 39.11749], [-122.52768, 39.11737], [-122.52772, 39.11723], [-122.5277, 39.11721], [-122.52773, 39.11718], [-122.52778, 39.11701], [-122.52777, 39.11687], [-122.52744, 39.11665], [-122.52743, 39.11572], [-122.52796, 39.11585], [-122.52851, 39.11585], [-122.52953, 39.11559], [-122.52984, 39.1156], [-122.52994, 39.11564], [-122.53028, 39.11563], [-122.53032, 39.11561], [-122.5305, 39.11562], [-122.53127, 39.11505], [-122.53195, 39.115], [-122.53185, 39.11465], [-122.53169, 39.11458], [-122.53113, 39.11436], [-122.53022, 39.11475], [-122.52992, 39.11411], [-122.53052, 39.11304], [-122.52998, 39.11248], [-122.53111, 39.11232], [-122.53154, 39.11185], [-122.53058, 39.11118], [-122.53168, 39.11067], [-122.53189, 39.1104], [-122.53191, 39.11033], [-122.532, 39.11027], [-122.53208, 39.11322], [-122.53668, 39.11312], [-122.53691, 39.1205], [-122.54617, 39.12046], [-122.54625, 39.1179], [-122.54672, 39.11824], [-122.54687, 39.11875], [-122.54722, 39.11882], [-122.54776, 39.11881], [-122.54816, 39.11866], [-122.54831, 39.11831], [-122.54818, 39.11762], [-122.54888, 39.11712], [-122.54928, 39.11678], [-122.54932, 39.11714], [-122.54907, 39.11732], [-122.54893, 39.11755], [-122.54894, 39.11822], [-122.5493, 39.11868], [-122.54968, 39.11921], [-122.54971, 39.11975], [-122.55013, 39.11961], [-122.55027, 39.12001], [-122.5503, 39.12004], [-122.55052, 39.12024], [-122.55115, 39.12055], [-122.55094, 39.12059], [-122.55085, 39.12073], [-122.55091, 39.12099], [-122.55113, 39.12128], [-122.55116, 39.12155], [-122.5507, 39.12134], [-122.55026, 39.12121], [-122.54996, 39.12129], [-122.54982, 39.12162], [-122.5496, 39.12202], [-122.54963, 39.12234], [-122.55118, 39.12329], [-122.55119, 39.1243]]], [[[-122.57836, 39.15375], [-122.57648, 39.15376], [-122.57617, 39.15298], [-122.5759, 39.15215], [-122.57521, 39.15153], [-122.57478, 39.15133], [-122.56811, 39.15367], [-122.56645, 39.15446], [-122.56473, 39.15494], [-122.56201, 39.1541], [-122.56209, 39.15386], [-122.56209, 39.15385], [-122.56043, 39.15389], [-122.56028, 39.15216], [-122.55992, 39.15219], [-122.55969, 39.15233], [-122.55948, 39.15235], [-122.55905, 39.15176], [-122.55822, 39.15167], [-122.5582, 39.15253], [-122.55806, 39.15253], [-122.55787, 39.15215], [-122.5577, 39.15205], [-122.55712, 39.15189], [-122.55667, 39.15189], [-122.55617, 39.1521], [-122.55596, 39.15246], [-122.55543, 39.15259], [-122.55457, 39.15256], [-122.55398, 39.15256], [-122.55341, 39.15267], [-122.55247, 39.15274], [-122.55218, 39.15283], [-122.55199, 39.15315], [-122.5516, 39.15325], [-122.55138, 39.15277], [-122.55083, 39.15266], [-122.55012, 39.15334], [-122.54953, 39.15336], [-122.54841, 39.1528], [-122.54752, 39.15303], [-122.54711, 39.15391], [-122.54759, 39.15525], [-122.54705, 39.15573], [-122.54687, 39.15665], [-122.54583, 39.15647], [-122.54459, 39.15751], [-122.54462, 39.15789], [-122.54188, 39.158], [-122.54183, 39.16151], [-122.53727, 39.16162], [-122.53735, 39.16409], [-122.53659, 39.16415], [-122.53617, 39.16423], [-122.53606, 39.16463], [-122.53625, 39.16516], [-122.53689, 39.16561], [-122.53735, 39.16642], [-122.5376, 39.16698], [-122.53774, 39.16809], [-122.53747, 39.16807], [-122.53708, 39.16789], [-122.53664, 39.16796], [-122.53622, 39.16832], [-122.53602, 39.16834], [-122.53507, 39.16734], [-122.53463, 39.16729], [-122.53292, 39.16798], [-122.53221, 39.16811], [-122.5316, 39.1679], [-122.52874, 39.16667], [-122.52905, 39.16647], [-122.52934, 39.16619], [-122.53008, 39.16562], [-122.53023, 39.16527], [-122.53258, 39.16518], [-122.53251, 39.15806], [-122.53723, 39.15792], [-122.53702, 39.15435], [-122.54182, 39.15428], [-122.54175, 39.15034], [-122.55099, 39.15014], [-122.55116, 39.12486], [-122.55119, 39.12439], [-122.55255, 39.12438], [-122.55268, 39.12522], [-122.55336, 39.12627], [-122.55366, 39.1264], [-122.55307, 39.1269], [-122.55258, 39.12755], [-122.55272, 39.1279], [-122.55359, 39.12786], [-122.55385, 39.1278], [-122.55433, 39.12795], [-122.55516, 39.12784], [-122.55565, 39.12831], [-122.5556, 39.12921], [-122.55522, 39.12884], [-122.55506, 39.12878], [-122.55471, 39.12876], [-122.55446, 39.12891], [-122.55327, 39.12904], [-122.55207, 39.12923], [-122.55169, 39.12948], [-122.55142, 39.12973], [-122.5516, 39.13047], [-122.55285, 39.1309], [-122.55313, 39.13086], [-122.55369, 39.1313], [-122.55261, 39.13116], [-122.55224, 39.13124], [-122.55213, 39.13144], [-122.55227, 39.13188], [-122.55239, 39.13206], [-122.55272, 39.13226], [-122.55301, 39.1325], [-122.55375, 39.1327], [-122.55354, 39.13291], [-122.55299, 39.13298], [-122.5526, 39.13315], [-122.55237, 39.13309], [-122.55187, 39.1332], [-122.55151, 39.13338], [-122.55145, 39.13368], [-122.55179, 39.13397], [-122.5528, 39.13414], [-122.55283, 39.13435], [-122.55222, 39.13464], [-122.55213, 39.13484], [-122.55371, 39.1352], [-122.55412, 39.13507], [-122.55426, 39.13536], [-122.55445, 39.13548], [-122.5549, 39.13554], [-122.55485, 39.13589], [-122.55505, 39.13631], [-122.55486, 39.13627], [-122.55464, 39.13598], [-122.55361, 39.13581], [-122.55351, 39.13582], [-122.55327, 39.13593], [-122.55314, 39.13615], [-122.55306, 39.13624], [-122.55289, 39.13634], [-122.55265, 39.13638], [-122.55258, 39.13653], [-122.5528, 39.13698], [-122.55222, 39.13708], [-122.55221, 39.13729], [-122.55289, 39.13755], [-122.55285, 39.13807], [-122.55316, 39.13827], [-122.5536, 39.13827], [-122.55386, 39.13856], [-122.55438, 39.13859], [-122.55413, 39.13937], [-122.55381, 39.13935], [-122.55358, 39.13941], [-122.55358, 39.1396], [-122.55373, 39.14035], [-122.55366, 39.14036], [-122.5536, 39.14039], [-122.55342, 39.14032], [-122.55326, 39.1403], [-122.55316, 39.14034], [-122.55245, 39.14117], [-122.55265, 39.14227], [-122.55389, 39.14234], [-122.55422, 39.14207], [-122.55559, 39.14262], [-122.55553, 39.14278], [-122.55474, 39.14287], [-122.55428, 39.14305], [-122.55404, 39.14362], [-122.55455, 39.14511], [-122.5538, 39.14484], [-122.55347, 39.14492], [-122.55341, 39.14495], [-122.55331, 39.14498], [-122.55313, 39.14493], [-122.55281, 39.14487], [-122.55267, 39.145], [-122.5535, 39.14658], [-122.55582, 39.14852], [-122.55582, 39.15015], [-122.56163, 39.1501], [-122.56244, 39.15074], [-122.56257, 39.15134], [-122.56405, 39.15265], [-122.56533, 39.15293], [-122.56802, 39.15185], [-122.57113, 39.15148], [-122.57272, 39.15079], [-122.57383, 39.15069], [-122.57431, 39.1503], [-122.57606, 39.15021], [-122.57678, 39.15045], [-122.577, 39.1506], [-122.57716, 39.1508], [-122.57787, 39.15252], [-122.57756, 39.15323], [-122.57836, 39.15375]]], [[[-122.53247, 39.15431], [-122.53147, 39.15427], [-122.53143, 39.1537], [-122.5314, 39.15361], [-122.53141, 39.15346], [-122.5314, 39.15325], [-122.53216, 39.1528], [-122.53205, 39.15246], [-122.5313, 39.15269], [-122.531, 39.15273], [-122.53092, 39.1527], [-122.53089, 39.15266], [-122.53182, 39.15087], [-122.53168, 39.15058], [-122.53148, 39.15047], [-122.53134, 39.15037], [-122.53155, 39.15029], [-122.53144, 39.14926], [-122.53038, 39.1488], [-122.53075, 39.14873], [-122.53177, 39.14798], [-122.53235, 39.14778], [-122.53247, 39.15431]]], [[[-122.55024, 39.11285], [-122.55018, 39.11285], [-122.55004, 39.11256], [-122.54981, 39.11255], [-122.54939, 39.11258], [-122.54876, 39.11287], [-122.5481, 39.113], [-122.54801, 39.11341], [-122.54832, 39.11384], [-122.54776, 39.11435], [-122.54775, 39.11453], [-122.548, 39.11503], [-122.54819, 39.11504], [-122.54841, 39.11534], [-122.54861, 39.11532], [-122.54888, 39.1154], [-122.54879, 39.11567], [-122.54861, 39.11604], [-122.54797, 39.11592], [-122.54767, 39.11604], [-122.54745, 39.11643], [-122.547, 39.1166], [-122.54676, 39.1174], [-122.54637, 39.11727], [-122.54613, 39.11758], [-122.54613, 39.1168], [-122.54166, 39.11669], [-122.54178, 39.1001], [-122.54207, 39.1005], [-122.54235, 39.10148], [-122.54272, 39.10185], [-122.54259, 39.10252], [-122.54282, 39.10272], [-122.54321, 39.10462], [-122.54297, 39.10486], [-122.54303, 39.10592], [-122.54298, 39.10696], [-122.54365, 39.10721], [-122.54373, 39.10762], [-122.54418, 39.10795], [-122.54447, 39.10844], [-122.54497, 39.10884], [-122.54594, 39.1089], [-122.54621, 39.10953], [-122.54625, 39.10979], [-122.54689, 39.1101], [-122.54721, 39.11059], [-122.54804, 39.11087], [-122.54824, 39.11109], [-122.54859, 39.11125], [-122.54914, 39.11123], [-122.54929, 39.11097], [-122.54933, 39.11052], [-122.549, 39.10995], [-122.54974, 39.11011], [-122.55004, 39.11135], [-122.55023, 39.1115], [-122.55024, 39.11285]]]]} | Open Access 1 | 25318 | Indian Valley Wildlife Area | 30458 | 2304 | Yolo County Flood Control and Water Conservation District 585 | Special District 4 | Flood District 8 | http://www.ycfcwcd.org/ | Special District 4 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Indian-Valley-WA | Lake 40 | 1882.823 | Indian Valley Wildlife Area | 1989 | State Conservation Area 8 | 2 |
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]);