<div dir="ltr"><div><div><div><br></div><div>Although I could not checked carefully,<br></div>this dataset (address of post office) might be helpful.<br><br><a href="http://www.post.japanpost.jp/zipcode/dl/jigyosyo/zip/jigyosyo.zip">http://www.post.japanpost.jp/zipcode/dl/jigyosyo/zip/jigyosyo.zip</a><br><a href="http://www.post.japanpost.jp/zipcode/dl/jigyosyo/index-zip.html">http://www.post.japanpost.jp/zipcode/dl/jigyosyo/index-zip.html</a><br><br></div>Owner "Japan Post Co." does not claim copyright to this dataset as same as their post code dataset.<br></div>(I guess almost same as CC0)<br><div><br><a href="http://www.post.japanpost.jp/zipcode/dl/jigyosyo/readme.html">http://www.post.japanpost.jp/zipcode/dl/jigyosyo/readme.html</a><br>> 大口事業所個別番号データに限っては日本郵便株式会社は著作権を主張しません。自由に配布していただいて結構です。日本郵便株式会社への許諾も必要ありません。<br><br></div><div>But this dataset do not contain coordinate.<br></div><div>So it need join using neighbourhood name column.<br></div><div><br></div><div>4th column "都道府県名" is province's name.<br></div><div>5th column "市区町村名" is city/town/village's name.<br></div>6th column "町域名" is neighbourhood name.<br><div>8th column "大口事業所個別番号" is postcode digit (7 figured).<br></div><div><div><div><div><br></div><div>I'll seek the other dataset. :)<br><br></div><div><br></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-01-30 9:06 GMT+09:00 Tom Lee <span dir="ltr"><<a href="mailto:tlee@mapbox.com" target="_blank">tlee@mapbox.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Unfortunately the school address column does not include the postal code in either of these files. Here's sample output from ogrinfo. At this point I'm afraid I don't have many good ideas about how to finish this work, unless someone else from the Japanese mapping community has a suggestion.<div><br><div><div><div>OGRFeature(P29-13):7438</div><div> P29_001 (String) = 35201</div><div> P29_002 (String) = 16</div><div> P29_003 (String) = 16002</div><div> P29_004 (String) = 16002</div><div> P29_005 (String) = 玄洋中学校</div><div> P29_006 (String) = 彦島本村町2-8-1</div><div> P29_007 (Real) = 3.000000</div><div> X (Real) = 130.906788</div><div> Y (Real) = 33.942762</div><div> No (String) = 58</div><div> FLG (String) = 1</div><div> Memo (String) = H18KSJ</div><div> Memo2 (String) = (null)</div><div> F14 (String) = (null)</div><div> F15 (String) = (null)</div><div> F16 (String) = (null)</div><div> F17 (String) = (null)</div><div> memo3 (String) = (null)</div><div> F18 (String) = (null)</div></div><div><br></div></div><div>post offices:</div><div><div>OGRFeature(P30-13):10320</div><div> P30_001 (String) = 26344</div><div> P30_002 (String) = 18</div><div> P30_003 (String) = 18002</div><div> P30_004 (String) = 18006</div><div> P30_005 (String) = 郷ノ口郵便局</div><div> P30_006 (String) = 郷之口本町16-2</div><div> P30_007 (Integer) = 0</div><div> X (Real) = 135.85202000000</div><div> Y (Real) = 34.85229400000</div><div> No (Integer) = 446</div><div> FLG (Integer) = 1</div><div> Memo (String) = H18KSJ</div><div> Memo2 (String) = (null)</div><div> memo3 (String) = (null)</div><div> 行政コード (String) = (null)</div></div></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 29, 2015 at 5:52 AM, Satoshi IIDA <span dir="ltr"><<a href="mailto:nyampire@gmail.com" target="_blank">nyampire@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div><div><div><div><span><div><br>> e-Stat has <a href="https://gist.github.com/sbma44/2805ee5c0e8dc2825631" target="_blank">confirmed</a> via email that their data, when transformed, may be used and redistributed with attribution.<br></div></span>Great!<br></div>In fact, "丁目 (neighbourhood)" polygon data is very rare (under Open License), <br></div>and I'm super happy that we could use "when transformed" terms.<br><br></div>> shapefile<br></div>What is the digits in Attribute Table?<br></div>It seems it is not post code.<br><br></div>> address data with geometory<br></div>If I understand your motivation correctly,<br></div>most famous data is Kokudo_Suuchi_Joho (KSJ2) that could use even into OSM.<br><a href="http://wiki.openstreetmap.org/wiki/Import/Catalogue/Japan_KSJ2_Import" target="_blank">http://wiki.openstreetmap.org/wiki/Import/Catalogue/Japan_KSJ2_Import</a><br><br></div>* list - <a href="http://nlftp.mlit.go.jp/ksj/" target="_blank">http://nlftp.mlit.go.jp/ksj/</a><br><div><br>e.g.<br>* post office - <a href="http://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-P30.html" target="_blank">http://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-P30.html</a><br></div><div> code "P30_006" is address column.<br></div><div>* school - <a href="http://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-P29.html" target="_blank">http://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-P29.html</a><br><div> code "P29_006" is address column.</div></div><div><div><div><div><div><br><div>But the notation for address is very messy.<br></div><div><br></div><div>Anyone knows the geometory dataset with post-code?<br>どなたか、郵便番号と住所 (と、緯度経度) が対になったOpenなデータセットをご存知ありませんか？<br><br><br></div><div><div><div><div><div><div><div><div><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2015-01-29 8:51 GMT+09:00 Tom Lee <span dir="ltr"><<a href="mailto:tlee@mapbox.com" target="_blank">tlee@mapbox.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I've made a bit more progress. First, e-Stat has <a href="https://gist.github.com/sbma44/2805ee5c0e8dc2825631" target="_blank">confirmed</a> via email that their data, when transformed, may be used and redistributed with attribution.<div><br></div><div>Second, I have successfully joined the data together using the methods I described above. Below is a link to the compressed shapefile (~240MB).</div><div><br></div><div><a href="https://www.dropbox.com/s/j9sfaogofg5tkkr/japan_estat_joined.zip?dl=0" target="_blank">https://www.dropbox.com/s/j9sfaogofg5tkkr/japan_estat_joined.zip?dl=0</a><br></div><div><br></div><div>I would be grateful for any feedback you can offer on the correctness of this geometry, suggestions for means of evaluating it, or how a postal code might be assigned to each polygon.</div><div><br></div><div>At the moment I believe I need a source of point geometry that can be used to assign postcodes to these polygons. I have working code written using some restaurant locations pulled from the web, but this only covers about 1% of the polygons. If anyone has appropriate data available under an acceptably open license, please let me know if you'd be willing to share it! I have not done much research, but I can imagine that voting locations, school locations or other public data might be appropriate to this use.</div><div><br></div><div>Thanks very much for any advice or thoughts you might have.</div><span><font color="#888888"><div><br></div><div>Tom Lee</div><div><br></div><div><br></div></font></span></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 27, 2015 at 10:25 AM, Tom Lee <span dir="ltr"><<a href="mailto:tlee@mapbox.com" target="_blank">tlee@mapbox.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thank you! This is quite encouraging. I am unable to read Japanese, but Google Translate makes your interpretation -- that distributing modified data is okay -- seem reasonable to me. I will email e-Stat for clarification, and would welcome any thoughts that others on this list might have about this.<div><br></div><div>Thank you also for the <a href="http://jamfunk.jp" target="_blank">jamfunk.jp</a> links. This is detail about the Japan Post CSV that I did not know, and which will certainly be useful. I do not believe that it contains a mapping that would allow postcodes to be connected to the geometry derived from e-Stat. However, I do have a database of zip code centroids for Japan which could be used. I will have to check the licensing and see if it can be used to create a redistributable product.</div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jan 26, 2015 at 11:14 PM, Satoshi IIDA <span dir="ltr"><<a href="mailto:nyampire@gmail.com" target="_blank">nyampire@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><br></div>Hello,<br><br></div>Amazing work!<br></div><br></div>1. source of geo-data<br><div><div><div>At first glance, e-Stats data is not "Open" as we use.<br></div><div>Data re-distribution is forbidden by Terms of Use.<br></div><div><br><a href="http://e-stat.go.jp/SG2/eStatFlex/help/content/_73.html#B007" target="_blank">http://e-stat.go.jp/SG2/eStatFlex/help/content/_73.html#B007</a><br>> Ｂ－７． 第三者に提供することを目的として、ダウンロードしたデータを利用することはできますか？<br>> 本システムからダウンロードしたデータを複製（ファイル形式を変換しての複製を含む）してそのまま第三者に譲渡することは禁じています。<br>> 詳細については、ダウンロードデータについての『使用上の注意』をご参照ください。<br></div><div><br><a href="http://e-stat.go.jp/SG2/eStatFlex/help/content/_72.html" target="_blank">http://e-stat.go.jp/SG2/eStatFlex/help/content/_72.html</a><br>> ２．利用の制限<br>> 利用者は、本システムでダウンロードしたデータ及び画像データをそのまま複製（ファイル形式を変換しての複製を含む。）して第三者に譲渡することを禁じます。<br><br>Maybe "そのまま複製 (just copied one)" in this sentence means <br>"データを付け加えるなど、加工すれば配布OK (modified data is permitted to distribute)".<br></div><div>Is my understanding same as yours? :)<br></div><div><br></div><div>2. Combination of "丁目" polygon and ZIP-code digit<br></div><div>Perfect correspondence would be difficult, but it is worth to tackle!<br><br>Famous errors in ZIP csv are summarized in this site.<br><a href="http://jamfunk.jp/wp/?page_id=356" target="_blank">http://jamfunk.jp/wp/?page_id=356</a><br><a href="http://jamfunk.jp/wp/?p=390" target="_blank">http://jamfunk.jp/wp/?p=390</a><br><a href="http://jamfunk.jp/wp/?p=417" target="_blank">http://jamfunk.jp/wp/?p=417</a><br></div><div><br><div><div><div><div>I guess most annoying is "○○の一部 (part of XXX chome)" descriptions.<br></div><div>Famous around Iwate Prefecture.<br><a href="http://www.city.morioka.iwate.jp/sumai/jukyohyoji/tsushida/008020.html" target="_blank">http://www.city.morioka.iwate.jp/sumai/jukyohyoji/tsushida/008020.html</a><br><br></div><div>In other word, I guess we could make 99% of the data (except those errors).<br></div><div><br></div><div><div><div>Best!<br></div><div><br></div></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>2015-01-27 7:10 GMT+09:00 Tom Lee <span dir="ltr"><<a href="mailto:tlee@mapbox.com" target="_blank">tlee@mapbox.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Update: I have spent some time experimenting with the Census shapefiles, and it seems as though one of their ID fields might be usable for joining census polygons into postal code polygons. Specifically:<blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><p><span>
</span></p><p><span>shp2pgsql -W SJIS h22ka13115.shp tokyo1 | psql japan</span></p><p><span>echo "create table tokyozip as select left(KEY_CODE, 10) as KEY_CODE, st_setsrid(st_union(st_buffer(geom,0)),4326) as geom from tokyo1 group by left(KEY_CODE, 10);" | psql japan</span></p></div></blockquote><div>
<div>Was used to generate the following shapefile:</div><div><br></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><a href="http://cl.ly/3p2V1p400h3b/possible_tokyo_postcode.zip" target="_blank">http://cl.ly/3p2V1p400h3b/possible_tokyo_postcode.zip</a></div></div><div><br></div></blockquote>Assigning the correct post code is still a problem to be solved. I also don't have as much data (or familiarity with Japanese post codes) as I would like to test this hypothesis. Any advice will be much appreciated.<div><br></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><a href="http://i.imgur.com/JMYR09w.jpg" target="_blank">http://i.imgur.com/JMYR09w.jpg</a></div></blockquote><span><font color="#888888"><div><div><br></div><div>Tom</div></div></font></span></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jan 26, 2015 at 3:37 PM, Tom Lee <span dir="ltr"><<a href="mailto:tlee@mapbox.com" target="_blank">tlee@mapbox.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I have been trying to find geometry that corresponds to Japanese postal codes (sometimes also called zip codes). I initially joined Japan Post's CSV download to MLIT's administrative boundary shapefile, but this has proven to be too low-resolution.<div><br></div><div>I have found the <a href="http://www.parea.jp/datebase/area_map/index.html" target="_blank">PAREA Zip product</a>, but of course an open source of data would be preferable.</div><div><br></div><div>I am particularly curious to know whether E-Stat/Census data can be used to create postal code polygons. If you visit this URL:</div><div><br></div><div><a href="http://e-stat.go.jp/SG2/eStatGIS/page/download.html" target="_blank">http://e-stat.go.jp/SG2/eStatGIS/page/download.html</a><br></div><div><br></div><div>and select "平成２２年国勢調査（小地域） 2010/10/01"</div><div><br></div><div>You can then choose a smaller area and download a high-resolution mesh as a shapefile. That file's field definitions can be found here:</div><div><br></div><div><a href="http://e-stat.go.jp/SG2/eStatFlex/help/content/downloaddata/A002005212010.pdf" target="_blank">http://e-stat.go.jp/SG2/eStatFlex/help/content/downloaddata/A002005212010.pdf</a><br></div><div><br></div><div>Here is one such shapefile in QGIS, overlaid on Bing aerial imagery: <a href="http://i.imgur.com/7z1dhn4.jpg" target="_blank">http://i.imgur.com/7z1dhn4.jpg</a></div><div><br></div><div>Although the polygons are well-indexed, they do not seem to correspond to postal codes.</div><div><br></div><div>Is anyone aware of a means of mapping the data included in this shapefile to postal codes? I would be very glad to share the results of my efforts under an open license, should I prove able to solve this problem (E-Stat's license seems to make this possible).</div><div><br></div><div>Thanks very much!</div><span><font color="#888888"><div><br></div><div>Tom Lee</div></font></span></div>
</blockquote></div><br></div>
</div></div><br></div></div>_______________________________________________<br>
Talk-ja mailing list<br>
<a href="mailto:Talk-ja@openstreetmap.org" target="_blank">Talk-ja@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ja" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ja</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br><div>Satoshi IIDA<br>mail: <a href="mailto:nyampire@gmail.com" target="_blank">nyampire@gmail.com</a><br>twitter: @nyampire</div>
</font></span></div>
<br>_______________________________________________<br>
Talk-ja mailing list<br>
<a href="mailto:Talk-ja@openstreetmap.org" target="_blank">Talk-ja@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ja" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ja</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Talk-ja mailing list<br>
<a href="mailto:Talk-ja@openstreetmap.org" target="_blank">Talk-ja@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ja" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ja</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div>Satoshi IIDA<br>mail: <a href="mailto:nyampire@gmail.com" target="_blank">nyampire@gmail.com</a><br>twitter: @nyampire</div>
</div>
</div></div><br>_______________________________________________<br>
Talk-ja mailing list<br>
<a href="mailto:Talk-ja@openstreetmap.org" target="_blank">Talk-ja@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ja" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ja</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Talk-ja mailing list<br>
<a href="mailto:Talk-ja@openstreetmap.org">Talk-ja@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ja" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ja</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature">Satoshi IIDA<br>mail: <a href="mailto:nyampire@gmail.com" target="_blank">nyampire@gmail.com</a><br>twitter: @nyampire</div>
</div>