PageRenderTime 60ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 1ms

/Location/tr/com/cs/banking/infrastructure/utility/location/dbscript/alter_B_1.4.14.0_12062006.sql

https://bitbucket.org/cybersoft/test
SQL | 930 lines | 926 code | 4 blank | 0 comment | 0 complexity | c608599d90761be8d404abd6e596db07 MD5 | raw file
  1. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1932' WHERE COUNTY_CODE='06803';
  2. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '' WHERE COUNTY_CODE='08104';
  3. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1788' WHERE COUNTY_CODE='06902';
  4. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '' WHERE COUNTY_CODE='08105';
  5. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1316' WHERE COUNTY_CODE='07003';
  6. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1862' WHERE COUNTY_CODE='07004';
  7. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1884' WHERE COUNTY_CODE='07002';
  8. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1983' WHERE COUNTY_CODE='07005';
  9. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '' WHERE COUNTY_CODE='08106';
  10. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1463' WHERE COUNTY_CODE='07106';
  11. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1638' WHERE COUNTY_CODE='07107';
  12. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1880' WHERE COUNTY_CODE='07101';
  13. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1882' WHERE COUNTY_CODE='07102';
  14. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1901' WHERE COUNTY_CODE='07103';
  15. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1954' WHERE COUNTY_CODE='07105';
  16. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1992' WHERE COUNTY_CODE='07108';
  17. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1345' WHERE COUNTY_CODE='07202';
  18. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1941' WHERE COUNTY_CODE='07203';
  19. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1487' WHERE COUNTY_CODE='07204';
  20. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1607' WHERE COUNTY_CODE='07205';
  21. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1223' WHERE COUNTY_CODE='07302';
  22. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1931' WHERE COUNTY_CODE='07303';
  23. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1403' WHERE COUNTY_CODE='07304';
  24. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1623' WHERE COUNTY_CODE='07305';
  25. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1698' WHERE COUNTY_CODE='07306';
  26. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1496' WHERE COUNTY_CODE='07402';
  27. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1701' WHERE COUNTY_CODE='07403';
  28. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2008' WHERE COUNTY_CODE='07502';
  29. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1356' WHERE COUNTY_CODE='07503';
  30. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1380' WHERE COUNTY_CODE='07504';
  31. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1579' WHERE COUNTY_CODE='07505';
  32. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2011' WHERE COUNTY_CODE='07602';
  33. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1692' WHERE COUNTY_CODE='07603';
  34. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2020' WHERE COUNTY_CODE='07702';
  35. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2021' WHERE COUNTY_CODE='07703';
  36. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2022' WHERE COUNTY_CODE='07704';
  37. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2026' WHERE COUNTY_CODE='07705';
  38. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1321' WHERE COUNTY_CODE='07802';
  39. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1561' WHERE COUNTY_CODE='07803';
  40. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1856' WHERE COUNTY_CODE='07805';
  41. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1587' WHERE COUNTY_CODE='07804';
  42. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2024' WHERE COUNTY_CODE='07902';
  43. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2025' WHERE COUNTY_CODE='07903';
  44. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1329' WHERE COUNTY_CODE='00103';
  45. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1437' WHERE COUNTY_CODE='00105';
  46. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1443' WHERE COUNTY_CODE='00106';
  47. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1486' WHERE COUNTY_CODE='00107';
  48. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1580' WHERE COUNTY_CODE='00108';
  49. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1588' WHERE COUNTY_CODE='00109';
  50. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1687' WHERE COUNTY_CODE='00111';
  51. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1734' WHERE COUNTY_CODE='00112';
  52. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1757' WHERE COUNTY_CODE='00101';
  53. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1806' WHERE COUNTY_CODE='00104';
  54. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1104' WHERE COUNTY_CODE='00110';
  55. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1748' WHERE COUNTY_CODE='00113';
  56. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1246' WHERE COUNTY_CODE='00202';
  57. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1347' WHERE COUNTY_CODE='00203';
  58. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1354' WHERE COUNTY_CODE='00204';
  59. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1425' WHERE COUNTY_CODE='00205';
  60. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1592' WHERE COUNTY_CODE='00206';
  61. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1985' WHERE COUNTY_CODE='00207';
  62. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1989' WHERE COUNTY_CODE='00208';
  63. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1239' WHERE COUNTY_CODE='00304';
  64. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1267' WHERE COUNTY_CODE='00306';
  65. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1326' WHERE COUNTY_CODE='01707';
  66. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1340' WHERE COUNTY_CODE='01708';
  67. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1408' WHERE COUNTY_CODE='01709';
  68. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1503' WHERE COUNTY_CODE='01710';
  69. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1722' WHERE COUNTY_CODE='01711';
  70. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1300' WHERE COUNTY_CODE='01804';
  71. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1399' WHERE COUNTY_CODE='01805';
  72. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1494' WHERE COUNTY_CODE='01808';
  73. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1555' WHERE COUNTY_CODE='01809';
  74. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1649' WHERE COUNTY_CODE='01810';
  75. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1718' WHERE COUNTY_CODE='01811';
  76. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1765' WHERE COUNTY_CODE='01801';
  77. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1817' WHERE COUNTY_CODE='01806';
  78. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1885' WHERE COUNTY_CODE='01802';
  79. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1963' WHERE COUNTY_CODE='01807';
  80. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1177' WHERE COUNTY_CODE='01902';
  81. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1414' WHERE COUNTY_CODE='01905';
  82. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1445' WHERE COUNTY_CODE='01906';
  83. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1520' WHERE COUNTY_CODE='01908';
  84. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1556' WHERE COUNTY_CODE='01910';
  85. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1558' WHERE COUNTY_CODE='01911';
  86. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1642' WHERE COUNTY_CODE='01912';
  87. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1778' WHERE COUNTY_CODE='01903';
  88. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1850' WHERE COUNTY_CODE='01913';
  89. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1911' WHERE COUNTY_CODE='01904';
  90. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1972' WHERE COUNTY_CODE='01907';
  91. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1976' WHERE COUNTY_CODE='01909';
  92. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1214' WHERE COUNTY_CODE='02008';
  93. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1224' WHERE COUNTY_CODE='02009';
  94. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1226' WHERE COUNTY_CODE='02010';
  95. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1233' WHERE COUNTY_CODE='02011';
  96. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1257' WHERE COUNTY_CODE='02012';
  97. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1371' WHERE COUNTY_CODE='02013';
  98. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1426' WHERE COUNTY_CODE='02015';
  99. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1597' WHERE COUNTY_CODE='02016';
  100. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1670' WHERE COUNTY_CODE='02018';
  101. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1769' WHERE COUNTY_CODE='02003';
  102. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1774' WHERE COUNTY_CODE='02005';
  103. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1803' WHERE COUNTY_CODE='02014';
  104. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1840' WHERE COUNTY_CODE='02017';
  105. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1871' WHERE COUNTY_CODE='02002';
  106. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1881' WHERE COUNTY_CODE='02004';
  107. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1888' WHERE COUNTY_CODE='02006';
  108. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1889' WHERE COUNTY_CODE='02007';
  109. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1249' WHERE COUNTY_CODE='02102';
  110. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1253' WHERE COUNTY_CODE='02103';
  111. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1263' WHERE COUNTY_CODE='02104';
  112. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1278' WHERE COUNTY_CODE='02105';
  113. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1315' WHERE COUNTY_CODE='02107';
  114. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1381' WHERE COUNTY_CODE='02108';
  115. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1389' WHERE COUNTY_CODE='02109';
  116. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1490' WHERE COUNTY_CODE='02111';
  117. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1504' WHERE COUNTY_CODE='02112';
  118. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1624' WHERE COUNTY_CODE='02113';
  119. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1791' WHERE COUNTY_CODE='02106';
  120. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1962' WHERE COUNTY_CODE='02110';
  121. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1385' WHERE COUNTY_CODE='02202';
  122. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1412' WHERE COUNTY_CODE='02203';
  123. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1464' WHERE COUNTY_CODE='02204';
  124. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1502' WHERE COUNTY_CODE='02205';
  125. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1523' WHERE COUNTY_CODE='02206';
  126. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1705' WHERE COUNTY_CODE='02208';
  127. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1988' WHERE COUNTY_CODE='02207';
  128. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1173' WHERE COUNTY_CODE='02304';
  129. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1438' WHERE COUNTY_CODE='02305';
  130. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1455' WHERE COUNTY_CODE='02306';
  131. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1506' WHERE COUNTY_CODE='02308';
  132. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1566' WHERE COUNTY_CODE='02309';
  133. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1631' WHERE COUNTY_CODE='02310';
  134. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1762' WHERE COUNTY_CODE='02303';
  135. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1820' WHERE COUNTY_CODE='02307';
  136. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1873' WHERE COUNTY_CODE='02302';
  137. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1406' WHERE COUNTY_CODE='02402';
  138. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1459' WHERE COUNTY_CODE='02403';
  139. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1460' WHERE COUNTY_CODE='02404';
  140. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1583' WHERE COUNTY_CODE='02406';
  141. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1675' WHERE COUNTY_CODE='02407';
  142. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1853' WHERE COUNTY_CODE='02408';
  143. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1977' WHERE COUNTY_CODE='02405';
  144. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1235' WHERE COUNTY_CODE='02502';
  145. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1392' WHERE COUNTY_CODE='02503';
  146. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1396' WHERE COUNTY_CODE='02504';
  147. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1416' WHERE COUNTY_CODE='02506';
  148. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1444' WHERE COUNTY_CODE='02508';
  149. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1540' WHERE COUNTY_CODE='02510';
  150. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1550' WHERE COUNTY_CODE='02511';
  151. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1551' WHERE COUNTY_CODE='02512';
  152. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1567' WHERE COUNTY_CODE='02513';
  153. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1657' WHERE COUNTY_CODE='02515';
  154. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1674' WHERE COUNTY_CODE='02516';
  155. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1683' WHERE COUNTY_CODE='02517';
  156. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1812' WHERE COUNTY_CODE='02507';
  157. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1851' WHERE COUNTY_CODE='02518';
  158. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1865' WHERE COUNTY_CODE='02514';
  159. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1945' WHERE COUNTY_CODE='02505';
  160. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1559' WHERE COUNTY_CODE='01104';
  161. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1571' WHERE COUNTY_CODE='01105';
  162. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1636' WHERE COUNTY_CODE='01106';
  163. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1857' WHERE COUNTY_CODE='01107';
  164. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1948' WHERE COUNTY_CODE='01103';
  165. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1446' WHERE COUNTY_CODE='01203';
  166. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1475' WHERE COUNTY_CODE='01204';
  167. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1633' WHERE COUNTY_CODE='01205';
  168. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1750' WHERE COUNTY_CODE='01201';
  169. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1855' WHERE COUNTY_CODE='01206';
  170. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1996' WHERE COUNTY_CODE='01207';
  171. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1112' WHERE COUNTY_CODE='01302';
  172. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1394' WHERE COUNTY_CODE='01304';
  173. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1537' WHERE COUNTY_CODE='01305';
  174. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1669' WHERE COUNTY_CODE='01306';
  175. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1798' WHERE COUNTY_CODE='01303';
  176. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1346' WHERE COUNTY_CODE='01406';
  177. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1364' WHERE COUNTY_CODE='01408';
  178. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1466' WHERE COUNTY_CODE='01410';
  179. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1522' WHERE COUNTY_CODE='01411';
  180. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1531' WHERE COUNTY_CODE='01412';
  181. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1610' WHERE COUNTY_CODE='01413';
  182. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1730' WHERE COUNTY_CODE='08107';
  183. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '' WHERE COUNTY_CODE='01402';
  184. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1794' WHERE COUNTY_CODE='08108';
  185. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1905' WHERE COUNTY_CODE='08109';
  186. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1916' WHERE COUNTY_CODE='01404';
  187. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1997' WHERE COUNTY_CODE='01414';
  188. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2017' WHERE COUNTY_CODE='08110';
  189. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1211' WHERE COUNTY_CODE='01503';
  190. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1357' WHERE COUNTY_CODE='01506';
  191. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1672' WHERE COUNTY_CODE='01509';
  192. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1728' WHERE COUNTY_CODE='01510';
  193. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1813' WHERE COUNTY_CODE='01507';
  194. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1816' WHERE COUNTY_CODE='01508';
  195. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1874' WHERE COUNTY_CODE='01502';
  196. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1899' WHERE COUNTY_CODE='01504';
  197. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1903' WHERE COUNTY_CODE='01505';
  198. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1411' WHERE COUNTY_CODE='01605';
  199. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1420' WHERE COUNTY_CODE='01606';
  200. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1434' WHERE COUNTY_CODE='01607';
  201. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1457' WHERE COUNTY_CODE='01608';
  202. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1530' WHERE COUNTY_CODE='01611';
  203. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1535' WHERE COUNTY_CODE='01610';
  204. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1553' WHERE COUNTY_CODE='01613';
  205. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1554' WHERE COUNTY_CODE='01614';
  206. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1725' WHERE COUNTY_CODE='01616';
  207. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1799' WHERE COUNTY_CODE='01604';
  208. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1783' WHERE COUNTY_CODE='01601';
  209. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1935' WHERE COUNTY_CODE='01603';
  210. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1960' WHERE COUNTY_CODE='01609';
  211. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1829' WHERE COUNTY_CODE='01612';
  212. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1832' WHERE COUNTY_CODE='01615';
  213. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1859' WHERE COUNTY_CODE='01617';
  214. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1180' WHERE COUNTY_CODE='01702';
  215. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1190' WHERE COUNTY_CODE='01703';
  216. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1205' WHERE COUNTY_CODE='01704';
  217. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1229' WHERE COUNTY_CODE='01705';
  218. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1293' WHERE COUNTY_CODE='01706';
  219. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1612' WHERE COUNTY_CODE='03525';
  220. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1149' WHERE COUNTY_CODE='03602';
  221. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1101' WHERE COUNTY_CODE='03701';
  222. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1218' WHERE COUNTY_CODE='03802';
  223. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1163' WHERE COUNTY_CODE='03901';
  224. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1254' WHERE COUNTY_CODE='04004';
  225. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1338' WHERE COUNTY_CODE='04101';
  226. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1122' WHERE COUNTY_CODE='04203';
  227. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1132' WHERE COUNTY_CODE='04301';
  228. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1114' WHERE COUNTY_CODE='04401';
  229. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1118' WHERE COUNTY_CODE='04502';
  230. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1107' WHERE COUNTY_CODE='04601';
  231. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1273' WHERE COUNTY_CODE='04702';
  232. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1197' WHERE COUNTY_CODE='04801';
  233. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1213' WHERE COUNTY_CODE='04901';
  234. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1155' WHERE COUNTY_CODE='05002';
  235. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1201' WHERE COUNTY_CODE='05102';
  236. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1119' WHERE COUNTY_CODE='05201';
  237. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1146' WHERE COUNTY_CODE='05301';
  238. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1123' WHERE COUNTY_CODE='05401';
  239. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1125' WHERE COUNTY_CODE='05501';
  240. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1179' WHERE COUNTY_CODE='05602';
  241. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1156' WHERE COUNTY_CODE='05701';
  242. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1282' WHERE COUNTY_CODE='05803';
  243. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1250' WHERE COUNTY_CODE='05901';
  244. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1129' WHERE COUNTY_CODE='06001';
  245. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1113' WHERE COUNTY_CODE='06101';
  246. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1247' WHERE COUNTY_CODE='06201';
  247. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1115' WHERE COUNTY_CODE='06301';
  248. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1170' WHERE COUNTY_CODE='06401';
  249. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1175' WHERE COUNTY_CODE='06502';
  250. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1117' WHERE COUNTY_CODE='06601';
  251. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1240' WHERE COUNTY_CODE='06702';
  252. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1860' WHERE COUNTY_CODE='06801';
  253. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1767' WHERE COUNTY_CODE='06901';
  254. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1768' WHERE COUNTY_CODE='07001';
  255. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1268' WHERE COUNTY_CODE='07104';
  256. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1184' WHERE COUNTY_CODE='07201';
  257. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1189' WHERE COUNTY_CODE='07301';
  258. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1761' WHERE COUNTY_CODE='07401';
  259. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1252' WHERE COUNTY_CODE='07501';
  260. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1142' WHERE COUNTY_CODE='07601';
  261. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2019' WHERE COUNTY_CODE='07701';
  262. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1296' WHERE COUNTY_CODE='07801';
  263. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2023' WHERE COUNTY_CODE='07901';
  264. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1219' WHERE COUNTY_CODE='00102';
  265. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1182' WHERE COUNTY_CODE='00201';
  266. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1200' WHERE COUNTY_CODE='00303';
  267. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1283' WHERE COUNTY_CODE='00401';
  268. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1363' WHERE COUNTY_CODE='00501';
  269. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1130' WHERE COUNTY_CODE='00602';
  270. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1121' WHERE COUNTY_CODE='00701';
  271. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1145' WHERE COUNTY_CODE='00801';
  272. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1206' WHERE COUNTY_CODE='00901';
  273. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1161' WHERE COUNTY_CODE='01001';
  274. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1210' WHERE COUNTY_CODE='01101';
  275. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1344' WHERE COUNTY_CODE='01202';
  276. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1106' WHERE COUNTY_CODE='01301';
  277. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1116' WHERE COUNTY_CODE='08101';
  278. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1109' WHERE COUNTY_CODE='01501';
  279. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1343' WHERE COUNTY_CODE='01602';
  280. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1160' WHERE COUNTY_CODE='01701';
  281. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1248' WHERE COUNTY_CODE='01803';
  282. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1124' WHERE COUNTY_CODE='01901';
  283. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1102' WHERE COUNTY_CODE='02001';
  284. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1195' WHERE COUNTY_CODE='02101';
  285. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1307' WHERE COUNTY_CODE='02201';
  286. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1110' WHERE COUNTY_CODE='02301';
  287. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1243' WHERE COUNTY_CODE='02401';
  288. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1153' WHERE COUNTY_CODE='02501';
  289. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1255' WHERE COUNTY_CODE='02603';
  290. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1139' WHERE COUNTY_CODE='02701';
  291. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1133' WHERE COUNTY_CODE='02801';
  292. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1458' WHERE COUNTY_CODE='02901';
  293. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1261' WHERE COUNTY_CODE='03001';
  294. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1131' WHERE COUNTY_CODE='03101';
  295. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1154' WHERE COUNTY_CODE='03202';
  296. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1135' WHERE COUNTY_CODE='03301';
  297. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1103' WHERE COUNTY_CODE='03401';
  298. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1165' WHERE COUNTY_CODE='08001';
  299. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1677' WHERE COUNTY_CODE='03526';
  300. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1682' WHERE COUNTY_CODE='03527';
  301. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1703' WHERE COUNTY_CODE='03528';
  302. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1776' WHERE COUNTY_CODE='03505';
  303. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1780' WHERE COUNTY_CODE='03507';
  304. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1819' WHERE COUNTY_CODE='03519';
  305. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1826' WHERE COUNTY_CODE='03520';
  306. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1128' WHERE COUNTY_CODE='03501';
  307. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2006' WHERE COUNTY_CODE='03502';
  308. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2007' WHERE COUNTY_CODE='03509';
  309. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2009' WHERE COUNTY_CODE='03512';
  310. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2013' WHERE COUNTY_CODE='03522';
  311. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2018' WHERE COUNTY_CODE='03513';
  312. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1279' WHERE COUNTY_CODE='03603';
  313. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1424' WHERE COUNTY_CODE='03604';
  314. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1601' WHERE COUNTY_CODE='03605';
  315. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1614' WHERE COUNTY_CODE='03606';
  316. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1645' WHERE COUNTY_CODE='03607';
  317. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1756' WHERE COUNTY_CODE='03601';
  318. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1140' WHERE COUNTY_CODE='03703';
  319. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1162' WHERE COUNTY_CODE='03704';
  320. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1208' WHERE COUNTY_CODE='03705';
  321. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1221' WHERE COUNTY_CODE='03706';
  322. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1238' WHERE COUNTY_CODE='03707';
  323. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1264' WHERE COUNTY_CODE='03708';
  324. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1277' WHERE COUNTY_CODE='03709';
  325. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1410' WHERE COUNTY_CODE='03713';
  326. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1499' WHERE COUNTY_CODE='03714';
  327. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1666' WHERE COUNTY_CODE='03718';
  328. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1685' WHERE COUNTY_CODE='03719';
  329. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1805' WHERE COUNTY_CODE='03712';
  330. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1836' WHERE COUNTY_CODE='03715';
  331. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1845' WHERE COUNTY_CODE='03717';
  332. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1867' WHERE COUNTY_CODE='03702';
  333. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1915' WHERE COUNTY_CODE='03710';
  334. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1940' WHERE COUNTY_CODE='03711';
  335. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1984' WHERE COUNTY_CODE='03716';
  336. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1275' WHERE COUNTY_CODE='03803';
  337. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1330' WHERE COUNTY_CODE='03804';
  338. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1409' WHERE COUNTY_CODE='03806';
  339. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1576' WHERE COUNTY_CODE='03810';
  340. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1603' WHERE COUNTY_CODE='03811';
  341. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1605' WHERE COUNTY_CODE='03812';
  342. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1680' WHERE COUNTY_CODE='03814';
  343. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1715' WHERE COUNTY_CODE='03815';
  344. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1727' WHERE COUNTY_CODE='03816';
  345. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1752' WHERE COUNTY_CODE='03801';
  346. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1846' WHERE COUNTY_CODE='03813';
  347. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1936' WHERE COUNTY_CODE='03805';
  348. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1978' WHERE COUNTY_CODE='03809';
  349. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1863' WHERE COUNTY_CODE='03807';
  350. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1864' WHERE COUNTY_CODE='03808';
  351. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1270' WHERE COUNTY_CODE='03902';
  352. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1480' WHERE COUNTY_CODE='03903';
  353. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1505' WHERE COUNTY_CODE='03904';
  354. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1572' WHERE COUNTY_CODE='03905';
  355. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1577' WHERE COUNTY_CODE='03906';
  356. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1714' WHERE COUNTY_CODE='03907';
  357. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1429' WHERE COUNTY_CODE='04005';
  358. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1529' WHERE COUNTY_CODE='04006';
  359. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1754' WHERE COUNTY_CODE='04002';
  360. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1869' WHERE COUNTY_CODE='04001';
  361. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1890' WHERE COUNTY_CODE='04003';
  362. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1355' WHERE COUNTY_CODE='04102';
  363. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1430' WHERE COUNTY_CODE='04103';
  364. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1440' WHERE COUNTY_CODE='04104';
  365. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1821' WHERE COUNTY_CODE='04105';
  366. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1188' WHERE COUNTY_CODE='04205';
  367. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1207' WHERE COUNTY_CODE='04206';
  368. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1222' WHERE COUNTY_CODE='04207';
  369. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1262' WHERE COUNTY_CODE='04209';
  370. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1285' WHERE COUNTY_CODE='04212';
  371. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1312' WHERE COUNTY_CODE='04214';
  372. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1375' WHERE COUNTY_CODE='04216';
  373. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1400' WHERE COUNTY_CODE='04219';
  374. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1422' WHERE COUNTY_CODE='04220';
  375. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1441' WHERE COUNTY_CODE='04221';
  376. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1491' WHERE COUNTY_CODE='04223';
  377. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1598' WHERE COUNTY_CODE='04225';
  378. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1617' WHERE COUNTY_CODE='04227';
  379. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1735' WHERE COUNTY_CODE='04231';
  380. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1753' WHERE COUNTY_CODE='04202';
  381. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1760' WHERE COUNTY_CODE='04204';
  382. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1789' WHERE COUNTY_CODE='04211';
  383. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1804' WHERE COUNTY_CODE='04218';
  384. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1848' WHERE COUNTY_CODE='04228';
  385. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1868' WHERE COUNTY_CODE='04201';
  386. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1902' WHERE COUNTY_CODE='04208';
  387. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1907' WHERE COUNTY_CODE='04210';
  388. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1920' WHERE COUNTY_CODE='04213';
  389. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1933' WHERE COUNTY_CODE='04215';
  390. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1937' WHERE COUNTY_CODE='04217';
  391. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1990' WHERE COUNTY_CODE='04229';
  392. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1994' WHERE COUNTY_CODE='04230';
  393. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1814' WHERE COUNTY_CODE='04222';
  394. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1827' WHERE COUNTY_CODE='04224';
  395. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1839' WHERE COUNTY_CODE='04226';
  396. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1288' WHERE COUNTY_CODE='04304';
  397. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1304' WHERE COUNTY_CODE='04306';
  398. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1339' WHERE COUNTY_CODE='04307';
  399. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1625' WHERE COUNTY_CODE='04310';
  400. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1671' WHERE COUNTY_CODE='04312';
  401. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1764' WHERE COUNTY_CODE='04302';
  402. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1843' WHERE COUNTY_CODE='04311';
  403. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1790' WHERE COUNTY_CODE='04305';
  404. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1802' WHERE COUNTY_CODE='04308';
  405. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1898' WHERE COUNTY_CODE='04303';
  406. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1979' WHERE COUNTY_CODE='04309';
  407. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1143' WHERE COUNTY_CODE='04402';
  408. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1148' WHERE COUNTY_CODE='04403';
  409. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1265' WHERE COUNTY_CODE='04405';
  410. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1286' WHERE COUNTY_CODE='04406';
  411. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1390' WHERE COUNTY_CODE='04408';
  412. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1582' WHERE COUNTY_CODE='04411';
  413. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1729' WHERE COUNTY_CODE='04413';
  414. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1772' WHERE COUNTY_CODE='04404';
  415. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1914' WHERE COUNTY_CODE='04407';
  416. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1953' WHERE COUNTY_CODE='04409';
  417. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1969' WHERE COUNTY_CODE='04410';
  418. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1995' WHERE COUNTY_CODE='04412';
  419. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1127' WHERE COUNTY_CODE='04503';
  420. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1269' WHERE COUNTY_CODE='04504';
  421. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1362' WHERE COUNTY_CODE='04506';
  422. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1470' WHERE COUNTY_CODE='04507';
  423. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1489' WHERE COUNTY_CODE='04509';
  424. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1590' WHERE COUNTY_CODE='04510';
  425. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1600' WHERE COUNTY_CODE='04511';
  426. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1606' WHERE COUNTY_CODE='04512';
  427. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1613' WHERE COUNTY_CODE='04513';
  428. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1634' WHERE COUNTY_CODE='04514';
  429. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1689' WHERE COUNTY_CODE='04515';
  430. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1751' WHERE COUNTY_CODE='04501';
  431. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1793' WHERE COUNTY_CODE='04505';
  432. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1965' WHERE COUNTY_CODE='04508';
  433. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1136' WHERE COUNTY_CODE='04602';
  434. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1299' WHERE COUNTY_CODE='04605';
  435. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1353' WHERE COUNTY_CODE='04606';
  436. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1570' WHERE COUNTY_CODE='04608';
  437. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1694' WHERE COUNTY_CODE='04609';
  438. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1785' WHERE COUNTY_CODE='04603';
  439. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1919' WHERE COUNTY_CODE='04604';
  440. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1975' WHERE COUNTY_CODE='04607';
  441. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1474' WHERE COUNTY_CODE='04703';
  442. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1519' WHERE COUNTY_CODE='04704';
  443. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1526' WHERE COUNTY_CODE='04705';
  444. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1547' WHERE COUNTY_CODE='04706';
  445. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1564' WHERE COUNTY_CODE='04707';
  446. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1609' WHERE COUNTY_CODE='04708';
  447. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1787' WHERE COUNTY_CODE='04701';
  448. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2002' WHERE COUNTY_CODE='04709';
  449. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1266' WHERE COUNTY_CODE='04803';
  450. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1331' WHERE COUNTY_CODE='04804';
  451. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1488' WHERE COUNTY_CODE='04806';
  452. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1517' WHERE COUNTY_CODE='04807';
  453. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1528' WHERE COUNTY_CODE='04808';
  454. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1695' WHERE COUNTY_CODE='04810';
  455. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1719' WHERE COUNTY_CODE='04811';
  456. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1742' WHERE COUNTY_CODE='04802';
  457. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1831' WHERE COUNTY_CODE='04809';
  458. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1958' WHERE COUNTY_CODE='04805';
  459. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1510' WHERE COUNTY_CODE='04904';
  460. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1711' WHERE COUNTY_CODE='04905';
  461. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1801' WHERE COUNTY_CODE='04902';
  462. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1964' WHERE COUNTY_CODE='04903';
  463. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1274' WHERE COUNTY_CODE='05003';
  464. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1367' WHERE COUNTY_CODE='05004';
  465. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1374' WHERE COUNTY_CODE='05005';
  466. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1485' WHERE COUNTY_CODE='05006';
  467. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1707' WHERE COUNTY_CODE='05007';
  468. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1749' WHERE COUNTY_CODE='05001';
  469. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1225' WHERE COUNTY_CODE='05103';
  470. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1700' WHERE COUNTY_CODE='05105';
  471. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1876' WHERE COUNTY_CODE='05101';
  472. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1904' WHERE COUNTY_CODE='05104';
  473. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1158' WHERE COUNTY_CODE='05202';
  474. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1328' WHERE COUNTY_CODE='05206';
  475. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1358' WHERE COUNTY_CODE='05207';
  476. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1482' WHERE COUNTY_CODE='05213';
  477. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1493' WHERE COUNTY_CODE='05214';
  478. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1525' WHERE COUNTY_CODE='05215';
  479. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1573' WHERE COUNTY_CODE='05216';
  480. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1696' WHERE COUNTY_CODE='05217';
  481. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1706' WHERE COUNTY_CODE='05218';
  482. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1795' WHERE COUNTY_CODE='05208';
  483. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1797' WHERE COUNTY_CODE='05209';
  484. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1891' WHERE COUNTY_CODE='05203';
  485. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1897' WHERE COUNTY_CODE='05204';
  486. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1900' WHERE COUNTY_CODE='05205';
  487. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1947' WHERE COUNTY_CODE='05210';
  488. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1950' WHERE COUNTY_CODE='05211';
  489. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1951' WHERE COUNTY_CODE='05212';
  490. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1228' WHERE COUNTY_CODE='05302';
  491. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1241' WHERE COUNTY_CODE='05303';
  492. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1332' WHERE COUNTY_CODE='05305';
  493. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1405' WHERE COUNTY_CODE='05308';
  494. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1428' WHERE COUNTY_CODE='05310';
  495. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1569' WHERE COUNTY_CODE='05311';
  496. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1796' WHERE COUNTY_CODE='05306';
  497. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1908' WHERE COUNTY_CODE='05304';
  498. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1943' WHERE COUNTY_CODE='05307';
  499. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1949' WHERE COUNTY_CODE='05309';
  500. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1351' WHERE COUNTY_CODE='05403';
  501. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1391' WHERE COUNTY_CODE='05404';
  502. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1442' WHERE COUNTY_CODE='05406';
  503. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1453' WHERE COUNTY_CODE='05407';
  504. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1595' WHERE COUNTY_CODE='05410';
  505. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1818' WHERE COUNTY_CODE='05408';
  506. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1833' WHERE COUNTY_CODE='05409';
  507. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1847' WHERE COUNTY_CODE='05412';
  508. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1925' WHERE COUNTY_CODE='05402';
  509. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1955' WHERE COUNTY_CODE='05405';
  510. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1986' WHERE COUNTY_CODE='05411';
  511. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1164' WHERE COUNTY_CODE='05504';
  512. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1234' WHERE COUNTY_CODE='05505';
  513. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1386' WHERE COUNTY_CODE='05506';
  514. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1452' WHERE COUNTY_CODE='05507';
  515. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1501' WHERE COUNTY_CODE='05508';
  516. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1676' WHERE COUNTY_CODE='05512';
  517. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1712' WHERE COUNTY_CODE='05513';
  518. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1763' WHERE COUNTY_CODE='05502';
  519. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1830' WHERE COUNTY_CODE='05509';
  520. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1838' WHERE COUNTY_CODE='05510';
  521. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1849' WHERE COUNTY_CODE='05511';
  522. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1879' WHERE COUNTY_CODE='05503';
  523. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1993' WHERE COUNTY_CODE='05514';
  524. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1317' WHERE COUNTY_CODE='05603';
  525. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1495' WHERE COUNTY_CODE='05604';
  526. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1575' WHERE COUNTY_CODE='05605';
  527. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1662' WHERE COUNTY_CODE='05606';
  528. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1878' WHERE COUNTY_CODE='05601';
  529. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1204' WHERE COUNTY_CODE='05702';
  530. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1290' WHERE COUNTY_CODE='05704';
  531. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1314' WHERE COUNTY_CODE='05705';
  532. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1349' WHERE COUNTY_CODE='05706';
  533. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1693' WHERE COUNTY_CODE='05708';
  534. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1910' WHERE COUNTY_CODE='05703';
  535. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1981' WHERE COUNTY_CODE='05707';
  536. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1342' WHERE COUNTY_CODE='05805';
  537. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1373' WHERE COUNTY_CODE='05807';
  538. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1376' WHERE COUNTY_CODE='05808';
  539. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1407' WHERE COUNTY_CODE='05809';
  540. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1431' WHERE COUNTY_CODE='05810';
  541. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1484' WHERE COUNTY_CODE='05811';
  542. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1646' WHERE COUNTY_CODE='05812';
  543. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1650' WHERE COUNTY_CODE='05813';
  544. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1731' WHERE COUNTY_CODE='05815';
  545. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1738' WHERE COUNTY_CODE='05816';
  546. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1870' WHERE COUNTY_CODE='05801';
  547. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1875' WHERE COUNTY_CODE='05802';
  548. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1913' WHERE COUNTY_CODE='05804';
  549. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1927' WHERE COUNTY_CODE='05806';
  550. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1991' WHERE COUNTY_CODE='05814';
  551. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1258' WHERE COUNTY_CODE='05902';
  552. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1388' WHERE COUNTY_CODE='05903';
  553. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1511' WHERE COUNTY_CODE='05904';
  554. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1538' WHERE COUNTY_CODE='05906';
  555. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1596' WHERE COUNTY_CODE='05907';
  556. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1652' WHERE COUNTY_CODE='05908';
  557. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1825' WHERE COUNTY_CODE='05905';
  558. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1151' WHERE COUNTY_CODE='06002';
  559. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1308' WHERE COUNTY_CODE='06004';
  560. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1545' WHERE COUNTY_CODE='06005';
  561. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1584' WHERE COUNTY_CODE='06007';
  562. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1690' WHERE COUNTY_CODE='06009';
  563. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1740' WHERE COUNTY_CODE='06011';
  564. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1834' WHERE COUNTY_CODE='06006';
  565. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1858' WHERE COUNTY_CODE='06010';
  566. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1883' WHERE COUNTY_CODE='06003';
  567. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1987' WHERE COUNTY_CODE='06008';
  568. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1141' WHERE COUNTY_CODE='06102';
  569. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1150' WHERE COUNTY_CODE='06103';
  570. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1244' WHERE COUNTY_CODE='06106';
  571. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1507' WHERE COUNTY_CODE='06111';
  572. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1548' WHERE COUNTY_CODE='06112';
  573. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1647' WHERE COUNTY_CODE='06113';
  574. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1681' WHERE COUNTY_CODE='06115';
  575. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1709' WHERE COUNTY_CODE='06116';
  576. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1732' WHERE COUNTY_CODE='06117';
  577. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1775' WHERE COUNTY_CODE='06104';
  578. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1842' WHERE COUNTY_CODE='06114';
  579. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1896' WHERE COUNTY_CODE='06105';
  580. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1909' WHERE COUNTY_CODE='06107';
  581. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1917' WHERE COUNTY_CODE='06108';
  582. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1942' WHERE COUNTY_CODE='06109';
  583. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1966' WHERE COUNTY_CODE='06110';
  584. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1397' WHERE COUNTY_CODE='06202';
  585. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1518' WHERE COUNTY_CODE='06203';
  586. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1541' WHERE COUNTY_CODE='06204';
  587. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1562' WHERE COUNTY_CODE='06205';
  588. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1574' WHERE COUNTY_CODE='06206';
  589. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1581' WHERE COUNTY_CODE='06207';
  590. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1194' WHERE COUNTY_CODE='06302';
  591. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1209' WHERE COUNTY_CODE='06303';
  592. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1378' WHERE COUNTY_CODE='06305';
  593. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1393' WHERE COUNTY_CODE='06307';
  594. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1630' WHERE COUNTY_CODE='06308';
  595. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1643' WHERE COUNTY_CODE='06309';
  596. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1713' WHERE COUNTY_CODE='06310';
  597. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1220' WHERE COUNTY_CODE='06304';
  598. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1800' WHERE COUNTY_CODE='06306';
  599. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1323' WHERE COUNTY_CODE='06402';
  600. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1436' WHERE COUNTY_CODE='06403';
  601. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1629' WHERE COUNTY_CODE='06404';
  602. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1697' WHERE COUNTY_CODE='06405';
  603. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1236' WHERE COUNTY_CODE='06504';
  604. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1309' WHERE COUNTY_CODE='06506';
  605. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1350' WHERE COUNTY_CODE='06507';
  606. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1372' WHERE COUNTY_CODE='06508';
  607. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1533' WHERE COUNTY_CODE='06509';
  608. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1565' WHERE COUNTY_CODE='06510';
  609. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1770' WHERE COUNTY_CODE='06501';
  610. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1786' WHERE COUNTY_CODE='06503';
  611. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1918' WHERE COUNTY_CODE='06505';
  612. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1980' WHERE COUNTY_CODE='06511';
  613. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1198' WHERE COUNTY_CODE='06603';
  614. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1242' WHERE COUNTY_CODE='06605';
  615. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1245' WHERE COUNTY_CODE='06606';
  616. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1602' WHERE COUNTY_CODE='06609';
  617. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1635' WHERE COUNTY_CODE='06610';
  618. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1655' WHERE COUNTY_CODE='06611';
  619. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1726' WHERE COUNTY_CODE='06613';
  620. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1877' WHERE COUNTY_CODE='06602';
  621. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1895' WHERE COUNTY_CODE='06604';
  622. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1952' WHERE COUNTY_CODE='06607';
  623. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1982' WHERE COUNTY_CODE='06608';
  624. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1998' WHERE COUNTY_CODE='06612';
  625. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1784' WHERE COUNTY_CODE='08102';
  626. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1276' WHERE COUNTY_CODE='06703';
  627. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1313' WHERE COUNTY_CODE='06705';
  628. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1758' WHERE COUNTY_CODE='06701';
  629. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1926' WHERE COUNTY_CODE='06704';
  630. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2031' WHERE COUNTY_CODE='08103';
  631. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1861' WHERE COUNTY_CODE='06804';
  632. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1557' WHERE COUNTY_CODE='06805';
  633. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1866' WHERE COUNTY_CODE='06806';
  634. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1921' WHERE COUNTY_CODE='06802';
  635. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1967' WHERE COUNTY_CODE='02509';
  636. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1508' WHERE COUNTY_CODE='02607';
  637. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1527' WHERE COUNTY_CODE='02609';
  638. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1599' WHERE COUNTY_CODE='02610';
  639. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1618' WHERE COUNTY_CODE='02611';
  640. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1632' WHERE COUNTY_CODE='02612';
  641. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1759' WHERE COUNTY_CODE='02601';
  642. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1777' WHERE COUNTY_CODE='02602';
  643. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1808' WHERE COUNTY_CODE='02606';
  644. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1934' WHERE COUNTY_CODE='02604';
  645. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1939' WHERE COUNTY_CODE='02605';
  646. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1973' WHERE COUNTY_CODE='02608';
  647. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1415' WHERE COUNTY_CODE='02702';
  648. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1546' WHERE COUNTY_CODE='02704';
  649. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1549' WHERE COUNTY_CODE='02706';
  650. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1720' WHERE COUNTY_CODE='02709';
  651. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1956' WHERE COUNTY_CODE='02703';
  652. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1974' WHERE COUNTY_CODE='02705';
  653. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1841' WHERE COUNTY_CODE='02707';
  654. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1844' WHERE COUNTY_CODE='02708';
  655. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1212' WHERE COUNTY_CODE='02802';
  656. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1272' WHERE COUNTY_CODE='02805';
  657. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1320' WHERE COUNTY_CODE='02807';
  658. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1324' WHERE COUNTY_CODE='02808';
  659. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1361' WHERE COUNTY_CODE='02809';
  660. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1465' WHERE COUNTY_CODE='02811';
  661. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1654' WHERE COUNTY_CODE='02813';
  662. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1678' WHERE COUNTY_CODE='02814';
  663. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1837' WHERE COUNTY_CODE='02812';
  664. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1854' WHERE COUNTY_CODE='02815';
  665. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1894' WHERE COUNTY_CODE='02804';
  666. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1930' WHERE COUNTY_CODE='02810';
  667. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1893' WHERE COUNTY_CODE='02803';
  668. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1912' WHERE COUNTY_CODE='02806';
  669. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1660' WHERE COUNTY_CODE='02904';
  670. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1684' WHERE COUNTY_CODE='02905';
  671. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1822' WHERE COUNTY_CODE='02902';
  672. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1971' WHERE COUNTY_CODE='02903';
  673. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1656' WHERE COUNTY_CODE='03002';
  674. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1737' WHERE COUNTY_CODE='03003';
  675. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1289' WHERE COUNTY_CODE='03103';
  676. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1382' WHERE COUNTY_CODE='03105';
  677. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1413' WHERE COUNTY_CODE='03106';
  678. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1468' WHERE COUNTY_CODE='03107';
  679. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1585' WHERE COUNTY_CODE='03109';
  680. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1591' WHERE COUNTY_CODE='03110';
  681. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1721' WHERE COUNTY_CODE='03111';
  682. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1792' WHERE COUNTY_CODE='03104';
  683. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1887' WHERE COUNTY_CODE='03102';
  684. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1970' WHERE COUNTY_CODE='03108';
  685. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1297' WHERE COUNTY_CODE='03203';
  686. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1341' WHERE COUNTY_CODE='03204';
  687. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1456' WHERE COUNTY_CODE='03206';
  688. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1615' WHERE COUNTY_CODE='03207';
  689. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1648' WHERE COUNTY_CODE='03208';
  690. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1651' WHERE COUNTY_CODE='03209';
  691. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1699' WHERE COUNTY_CODE='03210';
  692. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1717' WHERE COUNTY_CODE='03211';
  693. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1755' WHERE COUNTY_CODE='03201';
  694. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1929' WHERE COUNTY_CODE='03205';
  695. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2001' WHERE COUNTY_CODE='03212';
  696. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1311' WHERE COUNTY_CODE='03305';
  697. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1366' WHERE COUNTY_CODE='03306';
  698. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1536' WHERE COUNTY_CODE='03307';
  699. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1621' WHERE COUNTY_CODE='03308';
  700. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1665' WHERE COUNTY_CODE='03309';
  701. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1766' WHERE COUNTY_CODE='03302';
  702. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1779' WHERE COUNTY_CODE='03303';
  703. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1892' WHERE COUNTY_CODE='03304';
  704. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1447' WHERE COUNTY_CODE='03600';
  705. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1166' WHERE COUNTY_CODE='03405';
  706. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1183' WHERE COUNTY_CODE='03407';
  707. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1185' WHERE COUNTY_CODE='03408';
  708. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1186' WHERE COUNTY_CODE='03409';
  709. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1305' WHERE COUNTY_CODE='03412';
  710. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1325' WHERE COUNTY_CODE='03414';
  711. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1327' WHERE COUNTY_CODE='03415';
  712. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1336' WHERE COUNTY_CODE='03416';
  713. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1421' WHERE COUNTY_CODE='03418';
  714. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1604' WHERE COUNTY_CODE='03424';
  715. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1663' WHERE COUNTY_CODE='03428';
  716. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1708' WHERE COUNTY_CODE='03431';
  717. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1739' WHERE COUNTY_CODE='03432';
  718. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1237' WHERE COUNTY_CODE='03411';
  719. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1449' WHERE COUNTY_CODE='03420';
  720. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1622' WHERE COUNTY_CODE='03425';
  721. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1659' WHERE COUNTY_CODE='03427';
  722. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1835' WHERE COUNTY_CODE='03423';
  723. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1782' WHERE COUNTY_CODE='03410';
  724. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1823' WHERE COUNTY_CODE='03421';
  725. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1810' WHERE COUNTY_CODE='03419';
  726. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1852' WHERE COUNTY_CODE='03430';
  727. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1886' WHERE COUNTY_CODE='03406';
  728. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2003' WHERE COUNTY_CODE='03402';
  729. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2004' WHERE COUNTY_CODE='03403';
  730. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2005' WHERE COUNTY_CODE='03404';
  731. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2010' WHERE COUNTY_CODE='03417';
  732. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2012' WHERE COUNTY_CODE='03422';
  733. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2014' WHERE COUNTY_CODE='03426';
  734. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2015' WHERE COUNTY_CODE='03429';
  735. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2016' WHERE COUNTY_CODE='03413';
  736. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1448' WHERE COUNTY_CODE='03515';
  737. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1178' WHERE COUNTY_CODE='03503';
  738. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1181' WHERE COUNTY_CODE='03504';
  739. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1203' WHERE COUNTY_CODE='03506';
  740. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1251' WHERE COUNTY_CODE='03508';
  741. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1280' WHERE COUNTY_CODE='03510';
  742. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1334' WHERE COUNTY_CODE='03511';
  743. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1432' WHERE COUNTY_CODE='03514';
  744. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1461' WHERE COUNTY_CODE='03516';
  745. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1467' WHERE COUNTY_CODE='03517';
  746. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1477' WHERE COUNTY_CODE='03518';
  747. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1521' WHERE COUNTY_CODE='03521';
  748. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1563' WHERE COUNTY_CODE='03523';
  749. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1611' WHERE COUNTY_CODE='03524';
  750. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1450' WHERE COUNTY_CODE='03700';
  751. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1743' WHERE COUNTY_CODE='08002';
  752. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2027' WHERE COUNTY_CODE='08003';
  753. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1423' WHERE COUNTY_CODE='08004';
  754. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2028' WHERE COUNTY_CODE='08005';
  755. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2029' WHERE COUNTY_CODE='08006';
  756. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1471' WHERE COUNTY_CODE='03900';
  757. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1472' WHERE COUNTY_CODE='04000';
  758. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1478' WHERE COUNTY_CODE='04100';
  759. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1500' WHERE COUNTY_CODE='04300';
  760. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1509' WHERE COUNTY_CODE='04400';
  761. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1513' WHERE COUNTY_CODE='04500';
  762. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1515' WHERE COUNTY_CODE='04600';
  763. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1516' WHERE COUNTY_CODE='04700';
  764. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1532' WHERE COUNTY_CODE='04800';
  765. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1534' WHERE COUNTY_CODE='04900';
  766. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1543' WHERE COUNTY_CODE='05000';
  767. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1544' WHERE COUNTY_CODE='05100';
  768. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1552' WHERE COUNTY_CODE='05200';
  769. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1586' WHERE COUNTY_CODE='05300';
  770. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1589' WHERE COUNTY_CODE='05400';
  771. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1593' WHERE COUNTY_CODE='05500';
  772. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1620' WHERE COUNTY_CODE='05600';
  773. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1627' WHERE COUNTY_CODE='05700';
  774. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1628' WHERE COUNTY_CODE='05800';
  775. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1673' WHERE COUNTY_CODE='05900';
  776. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1108' WHERE COUNTY_CODE='00300';
  777. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1111' WHERE COUNTY_CODE='00400';
  778. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1134' WHERE COUNTY_CODE='00500';
  779. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1138' WHERE COUNTY_CODE='00700';
  780. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1152' WHERE COUNTY_CODE='00800';
  781. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1159' WHERE COUNTY_CODE='00900';
  782. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1168' WHERE COUNTY_CODE='01000';
  783. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1192' WHERE COUNTY_CODE='01100';
  784. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1193' WHERE COUNTY_CODE='01200';
  785. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1196' WHERE COUNTY_CODE='01300';
  786. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1199' WHERE COUNTY_CODE='01400';
  787. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1215' WHERE COUNTY_CODE='01500';
  788. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1230' WHERE COUNTY_CODE='01700';
  789. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1232' WHERE COUNTY_CODE='01800';
  790. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1259' WHERE COUNTY_CODE='01900';
  791. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1271' WHERE COUNTY_CODE='02000';
  792. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1284' WHERE COUNTY_CODE='02100';
  793. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1295' WHERE COUNTY_CODE='02200';
  794. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1298' WHERE COUNTY_CODE='02300';
  795. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1318' WHERE COUNTY_CODE='02400';
  796. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1319' WHERE COUNTY_CODE='02500';
  797. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1322' WHERE COUNTY_CODE='02600';
  798. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1352' WHERE COUNTY_CODE='02800';
  799. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1369' WHERE COUNTY_CODE='02900';
  800. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1377' WHERE COUNTY_CODE='03000';
  801. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1383' WHERE COUNTY_CODE='03100';
  802. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1401' WHERE COUNTY_CODE='03200';
  803. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1402' WHERE COUNTY_CODE='03300';
  804. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1292' WHERE COUNTY_CODE='08100';
  805. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1679' WHERE COUNTY_CODE='06000';
  806. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1686' WHERE COUNTY_CODE='06100';
  807. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1688' WHERE COUNTY_CODE='06200';
  808. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1702' WHERE COUNTY_CODE='06300';
  809. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1704' WHERE COUNTY_CODE='06400';
  810. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1710' WHERE COUNTY_CODE='06500';
  811. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1733' WHERE COUNTY_CODE='06600';
  812. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1741' WHERE COUNTY_CODE='06700';
  813. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1120' WHERE COUNTY_CODE='06800';
  814. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1176' WHERE COUNTY_CODE='06900';
  815. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1439' WHERE COUNTY_CODE='07000';
  816. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1469' WHERE COUNTY_CODE='07100';
  817. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1174' WHERE COUNTY_CODE='07200';
  818. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1661' WHERE COUNTY_CODE='07300';
  819. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1172' WHERE COUNTY_CODE='07400';
  820. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1144' WHERE COUNTY_CODE='07500';
  821. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1398' WHERE COUNTY_CODE='07600';
  822. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1716' WHERE COUNTY_CODE='07700';
  823. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1433' WHERE COUNTY_CODE='07800';
  824. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1476' WHERE COUNTY_CODE='07900';
  825. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1560' WHERE COUNTY_CODE='08000';
  826. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1105' WHERE COUNTY_CODE='00200';
  827. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1281' WHERE COUNTY_CODE='00307';
  828. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1306' WHERE COUNTY_CODE='00308';
  829. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1404' WHERE COUNTY_CODE='00311';
  830. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1594' WHERE COUNTY_CODE='00314';
  831. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '' WHERE COUNTY_CODE='00315';
  832. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1639' WHERE COUNTY_CODE='00316';
  833. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1664' WHERE COUNTY_CODE='00317';
  834. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1771' WHERE COUNTY_CODE='00301';
  835. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1773' WHERE COUNTY_CODE='00302';
  836. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1809' WHERE COUNTY_CODE='00312';
  837. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1906' WHERE COUNTY_CODE='00305';
  838. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1923' WHERE COUNTY_CODE='00309';
  839. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1944' WHERE COUNTY_CODE='00310';
  840. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1961' WHERE COUNTY_CODE='00313';
  841. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1287' WHERE COUNTY_CODE='00402';
  842. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1301' WHERE COUNTY_CODE='00403';
  843. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1379' WHERE COUNTY_CODE='00404';
  844. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1568' WHERE COUNTY_CODE='00405';
  845. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1667' WHERE COUNTY_CODE='00406';
  846. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1691' WHERE COUNTY_CODE='00407';
  847. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1368' WHERE COUNTY_CODE='00502';
  848. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1524' WHERE COUNTY_CODE='00504';
  849. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1641' WHERE COUNTY_CODE='00505';
  850. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1668' WHERE COUNTY_CODE='00506';
  851. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1938' WHERE COUNTY_CODE='00503';
  852. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1231' WHERE COUNTY_CODE='00607';
  853. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1723' WHERE COUNTY_CODE='00624';
  854. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1157' WHERE COUNTY_CODE='00603';
  855. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1167' WHERE COUNTY_CODE='00604';
  856. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1187' WHERE COUNTY_CODE='00605';
  857. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1227' WHERE COUNTY_CODE='00606';
  858. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1260' WHERE COUNTY_CODE='00608';
  859. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1302' WHERE COUNTY_CODE='00609';
  860. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1365' WHERE COUNTY_CODE='00613';
  861. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1387' WHERE COUNTY_CODE='00614';
  862. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1427' WHERE COUNTY_CODE='00615';
  863. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1473' WHERE COUNTY_CODE='00618';
  864. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1539' WHERE COUNTY_CODE='00620';
  865. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1578' WHERE COUNTY_CODE='00621';
  866. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1658' WHERE COUNTY_CODE='00623';
  867. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1744' WHERE COUNTY_CODE='00612';
  868. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1745' WHERE COUNTY_CODE='00617';
  869. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1746' WHERE COUNTY_CODE='00619';
  870. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1747' WHERE COUNTY_CODE='00622';
  871. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1815' WHERE COUNTY_CODE='00616';
  872. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1872' WHERE COUNTY_CODE='00601';
  873. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1922' WHERE COUNTY_CODE='00610';
  874. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1924' WHERE COUNTY_CODE='00611';
  875. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1126' WHERE COUNTY_CODE='00702';
  876. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1303' WHERE COUNTY_CODE='00703';
  877. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1333' WHERE COUNTY_CODE='00704';
  878. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1337' WHERE COUNTY_CODE='00705';
  879. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1370' WHERE COUNTY_CODE='00706';
  880. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1451' WHERE COUNTY_CODE='00709';
  881. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1483' WHERE COUNTY_CODE='00711';
  882. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1492' WHERE COUNTY_CODE='00712';
  883. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1512' WHERE COUNTY_CODE='00713';
  884. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1616' WHERE COUNTY_CODE='00714';
  885. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1811' WHERE COUNTY_CODE='00708';
  886. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1946' WHERE COUNTY_CODE='00707';
  887. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1959' WHERE COUNTY_CODE='00710';
  888. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1147' WHERE COUNTY_CODE='00802';
  889. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1202' WHERE COUNTY_CODE='00803';
  890. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1395' WHERE COUNTY_CODE='00804';
  891. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1653' WHERE COUNTY_CODE='00806';
  892. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1736' WHERE COUNTY_CODE='00807';
  893. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1828' WHERE COUNTY_CODE='00805';
  894. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1256' WHERE COUNTY_CODE='00903';
  895. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1348' WHERE COUNTY_CODE='00904';
  896. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1435' WHERE COUNTY_CODE='00906';
  897. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1479' WHERE COUNTY_CODE='00908';
  898. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1497' WHERE COUNTY_CODE='00910';
  899. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1498' WHERE COUNTY_CODE='00911';
  900. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1542' WHERE COUNTY_CODE='00912';
  901. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1637' WHERE COUNTY_CODE='00913';
  902. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1640' WHERE COUNTY_CODE='00914';
  903. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1724' WHERE COUNTY_CODE='00916';
  904. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1781' WHERE COUNTY_CODE='00902';
  905. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1807' WHERE COUNTY_CODE='00905';
  906. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1957' WHERE COUNTY_CODE='00907';
  907. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1968' WHERE COUNTY_CODE='00909';
  908. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '2000' WHERE COUNTY_CODE='00915';
  909. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1169' WHERE COUNTY_CODE='01002';
  910. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1171' WHERE COUNTY_CODE='01003';
  911. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1191' WHERE COUNTY_CODE='01004';
  912. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1216' WHERE COUNTY_CODE='01005';
  913. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1291' WHERE COUNTY_CODE='01006';
  914. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1294' WHERE COUNTY_CODE='01007';
  915. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1310' WHERE COUNTY_CODE='01008';
  916. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1360' WHERE COUNTY_CODE='01010';
  917. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1384' WHERE COUNTY_CODE='01011';
  918. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1418' WHERE COUNTY_CODE='01012';
  919. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1462' WHERE COUNTY_CODE='01013';
  920. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1514' WHERE COUNTY_CODE='01014';
  921. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1608' WHERE COUNTY_CODE='01016';
  922. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1619' WHERE COUNTY_CODE='01017';
  923. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1644' WHERE COUNTY_CODE='01018';
  924. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1824' WHERE COUNTY_CODE='01015';
  925. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1928' WHERE COUNTY_CODE='01009';
  926. UPDATE INFRA.LOCATION_COUNTY SET MKK_COUNTY_CODE = '1359' WHERE COUNTY_CODE='01102';