신도로명 우체국 우편번호﻿의 심각한 문제점...

신도로명 우체국 우편번호의 심각한 문제점... 다른 카페에 도움을 요청한 바,답신이 없는 관계루다. 나름 정리를 해 놓는 것이 상책이라 됩니다. 2014년 년월인가에 1차로 정리한 바 1.9G로총 503만개의 도로명 주소가 작성된 것을 보고,,, 한 국가 지역 정보의 기둥이 드디어 완성되어 가는 구나 하고,,,1년 반 동안 GPS 및 해당 우편번호에 신경을 쓰지 못하였답니다.......................최근 자료 업데이트 하던 중에,,,본인 또한 개인서버에 바이러스 공략으로 GPS 데이터까지 모두 삭제해야 할 운명이 있었답니다.............그래서 카페 확인 요청하고, 제가 만든 자료가 있다라면,,, 업로드부탁드리고,,, 인터넷 우정국을 방문해서,, 깔끔하게 정리된 엑셀 우편번호,,, 내려 받고,,텍스트 파일에서 엑셀로 잘 되어 있네요 하고,,.... 파일을 열어 보는 순간,,,이것은 어떤 정부의 생각의 차이인지 모르지만,향후, 접목해서 유저가 관리할 수 있는 우편번호 일은 전혀 없다라는 생각이 들었답니다.이런 세부 정보 마저도 독점을 하려고 하니,,, 해도 해도 너무하다는 생각,,밥그릇 싸움질이나 시키는 우정국~~~!!! 작년에 다운 받았던 사이트의 흔적을 찾아서,,,다행히,,2015년 7월10일 기준의 텍스트 도로명 주소 파일 503만개 주소록을 무사히 내려 받았습니다...지금은 공개되어 있지 않았지만,, 링크는 살아 있더군요..~~~해당 도로명 주로 리스트를 데이터베이스화 하는데,, 엄청난 내공이 들어갑니다. 좀 많이 달라진 것도 같고,, 먼가 프로그램 담당자가 변경된 느낌이 들더군요...... 현재는엑셀로 <table width="762" style="width: 573pt; border-collapse: collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 3865;"><colgroup><col width="150" style="width: 112pt; mso-width-source: userset; mso-width-alt: 4787;"><colgroup><col width="70" style="width: 53pt;" span="2"><colgroup><col width="281" style="width: 211pt; mso-width-source: userset; mso-width-alt: 8985;"><colgroup><col width="70" style="width: 53pt;"><tbody><tr height="46" style="height: 34.8pt;"><td width="121" height="46" style="border: 0.5pt solid windowtext; border-image: none; width: 91pt; height: 34.8pt; background-color: transparent;">우편번호 (구역번호)</td><td width="150" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 112pt; background-color: transparent;">시도</td><td width="70" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 53pt; background-color: transparent;">시군구</td><td width="70" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 53pt; background-color: transparent;">읍면</td><td width="281" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 211pt; background-color: transparent;">도로명주소</td><td width="70" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 53pt; background-color: transparent;">범위종류</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 17.4pt; background-color: transparent;">30083</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">세종특별자치시</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">　</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">금남면</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">가동길 2-3 ~ 32</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">전체</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 17.4pt; background-color: transparent;">30088</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">세종특별자치시</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">　</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">금남면</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">감성길 2 ~ 85</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">전체</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 17.4pt; background-color: transparent;">30086</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">세종특별자치시</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">　</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">금남면</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">고성길 54</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">　</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 17.4pt; background-color: transparent;">30089</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">세종특별자치시</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">　</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">금남면</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">광중새터말길 57-1 ~ 212</td><td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;">전체</td></tr></tbody></table> ............. 참 답답하더군요...... 속살은 다 빼고,, 껍데기만,,,, 기존 텍스트 파일을 개별 하나씩 하나 컨버젼... 완료..../ 아래 엑셀 형식으로 다시 만들었답니다. <table width="2643" style="width: 1985pt; border-collapse: collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2201;"><colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3174;"><colgroup><col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 3686;"><colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2278;"><colgroup><col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1740;"><colgroup><col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2662;"><colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2201;"><colgroup><col width="133" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4249;"><colgroup><col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3276;"><colgroup><col width="130" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4172;"><colgroup><col width="232" style="width: 174pt; mso-width-source: userset; mso-width-alt: 7424;"><colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2201;"><colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3174;" span="2"><colgroup><col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3276;"><colgroup><col width="282" style="width: 211pt; mso-width-source: userset; mso-width-alt: 9011;"><colgroup><col width="313" style="width: 235pt; mso-width-source: userset; mso-width-alt: 10009;"><colgroup><col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 2944;"><colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2201;"><colgroup><col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1740;" span="2"><colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2201;"><colgroup><col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 3686;"><colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2201;"><tbody><tr height="23" style="height: 17.4pt;"><td width="69" height="23" style="border: 0px black; border-image: none; width: 52pt; height: 17.4pt; background-color: transparent;">우편번호</td><td width="99" style="border: 0px black; border-image: none; width: 74pt; background-color: transparent;">우편일련번호</td><td width="115" style="border: 0px black; border-image: none; width: 86pt; background-color: transparent;">시도</td><td width="71" style="border: 0px black; border-image: none; width: 53pt; background-color: transparent;">시도영문</td><td width="54" style="border: 0px black; border-image: none; width: 41pt; background-color: transparent;">시군구</td><td width="83" style="border: 0px black; border-image: none; width: 62pt; background-color: transparent;">시군구영문</td><td width="69" style="border: 0px black; border-image: none; width: 52pt; background-color: transparent;">읍면</td><td width="133" style="border: 0px black; border-image: none; width: 100pt; background-color: transparent;">읍면영문</td><td width="102" style="border: 0px black; border-image: none; width: 77pt; background-color: transparent;">도로명코드</td><td width="130" style="border: 0px black; border-image: none; width: 98pt; background-color: transparent;">도로명</td><td width="232" style="border: 0px black; border-image: none; width: 174pt; background-color: transparent;">도로명영문</td><td width="69" style="border: 0px black; border-image: none; width: 52pt; background-color: transparent;">지하여부</td><td width="99" style="border: 0px black; border-image: none; width: 74pt; background-color: transparent;">건물번호본번</td><td width="99" style="border: 0px black; border-image: none; width: 74pt; background-color: transparent;">건물번호부번</td><td width="102" style="border: 0px black; border-image: none; width: 77pt; background-color: transparent;">건물관리번호</td><td width="282" style="border: 0px black; border-image: none; width: 211pt; background-color: transparent;">다량배달처명</td><td width="313" style="border: 0px black; border-image: none; width: 235pt; background-color: transparent;">시군구용건물명</td><td width="92" style="border: 0px black; border-image: none; width: 69pt; background-color: transparent;">법정동코드</td><td width="69" style="border: 0px black; border-image: none; width: 52pt; background-color: transparent;">법정동명</td><td width="54" style="border: 0px black; border-image: none; width: 41pt; background-color: transparent;">리</td><td width="54" style="border: 0px black; border-image: none; width: 41pt; background-color: transparent;">산여부</td><td width="69" style="border: 0px black; border-image: none; width: 52pt; background-color: transparent;">지번본번</td><td width="115" style="border: 0px black; border-image: none; width: 86pt; background-color: transparent;">읍면동일련번호</td><td width="69" style="border: 0px black; border-image: none; width: 52pt; background-color: transparent;">지번부번</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" align="right" style="border: 0px black; border-image: none; height: 17.4pt; background-color: transparent;">339001</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">11</td><td style="border: 0px black; border-image: none; background-color: transparent;">세종특별자치시</td><td style="border: 0px black; border-image: none; background-color: transparent;">Sejong-si</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61103E+11</td><td style="border: 0px black; border-image: none; background-color: transparent;">라온로</td><td style="border: 0px black; border-image: none; background-color: transparent;">Raon-ro</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">121</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61101E+24</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3611010500</td><td style="border: 0px black; border-image: none; background-color: transparent;">가람동</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">641</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">1</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" align="right" style="border: 0px black; border-image: none; height: 17.4pt; background-color: transparent;">339001</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">11</td><td style="border: 0px black; border-image: none; background-color: transparent;">세종특별자치시</td><td style="border: 0px black; border-image: none; background-color: transparent;">Sejong-si</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61103E+11</td><td style="border: 0px black; border-image: none; background-color: transparent;">금송로</td><td style="border: 0px black; border-image: none; background-color: transparent;">Geumsong-ro</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">625</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61101E+24</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3611010500</td><td style="border: 0px black; border-image: none; background-color: transparent;">가람동</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">512</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">2</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">2</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" align="right" style="border: 0px black; border-image: none; height: 17.4pt; background-color: transparent;">339001</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">11</td><td style="border: 0px black; border-image: none; background-color: transparent;">세종특별자치시</td><td style="border: 0px black; border-image: none; background-color: transparent;">Sejong-si</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61103E+11</td><td style="border: 0px black; border-image: none; background-color: transparent;">라온로</td><td style="border: 0px black; border-image: none; background-color: transparent;">Raon-ro</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">102</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61101E+24</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3611010500</td><td style="border: 0px black; border-image: none; background-color: transparent;">가람동</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">653</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">1</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td></tr><tr height="23" style="height: 17.4pt;"><td height="23" align="right" style="border: 0px black; border-image: none; height: 17.4pt; background-color: transparent;">339001</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">11</td><td style="border: 0px black; border-image: none; background-color: transparent;">세종특별자치시</td><td style="border: 0px black; border-image: none; background-color: transparent;">Sejong-si</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61103E+11</td><td style="border: 0px black; border-image: none; background-color: transparent;">금송로</td><td style="border: 0px black; border-image: none; background-color: transparent;">Geumsong-ro</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">612</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3.61101E+24</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td style="border: 0px black; border-image: none; background-color: transparent;">수질복원센터 및 크린에너지센터A</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">3611010500</td><td style="border: 0px black; border-image: none; background-color: transparent;">가람동</td><td style="border: 0px black; border-image: none; background-color: transparent;"></td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">529</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">2</td><td align="right" style="border: 0px black; border-image: none; background-color: transparent;">0</td></tr></tbody></table> 많은 차이가 있더군요.. 용어가 약간 다른 것도 있답니다.다행히 도로명 이름까지는 흔들지 않았던 모양입니다. ..............저야  우편번호 업무를 하지는 않겠지만,,, ㅎㅎㅎㅎ글쎄요 평생 이런 업무를 할 분들 참 앞으로 고생이 더 구만리 같습니다.... /////////// 신도로명 주소로,, 기존 주소로 일관 찾아서 보고 싶을 때 어떻게 해결하죠?...페키지 만들어서 주는 것도 좋지만, 데이터를 제공하는 것도 중요합니다. 정부나, 국가에서는 평생을 세울 지자체 위치부터 등등에 우편번호가 기초가 될 것인데,,,,, 가동길 2-3 ~ 32라는 것은 2~32까지 우편번호라고 합시다... ~ 표시를 하면,,, 개수가 많더라도 모든 주소록을 자세히 정리해서 제공할 필요는 있답니다...엑셀 데이터에도 구주소 및 영문주소까지 기존 우편번호 제공하였다면 좋을 것이라 생각됩니다. /////////////앞으로는 구글 어스등이 한글을 잘 지원한다고 생각하지 마시고,,, 신도로명 영문 주소 기준으로 구글 주소 검색이더 정확한 위경도 검색이 됨을 알려 드립니다.......2가지를 비교 실험한 결과, 위치가 약간씩 차이가 납니다........이유까지는....???..  ㅎㅎㅎ /////////////체계적인 우편번호 시스템이 되도록 정리를 시작합니다. 예로 테스트.. 세종시 도로명 주소를,,,, 기존 세부 도로명 주소(2만4천)에 접목하여,,, 적용한바,,, 19개의 우편번호가 없음을 알았습니다.이런 파일적인 오류가 정확한 것이 먼지는 모르지만,, 사전 수정되어야 할 것입니다.////////////