{"id":1123,"date":"2015-12-13T16:36:56","date_gmt":"2015-12-13T16:36:56","guid":{"rendered":"http:\/\/62.131.51.129\/?p=1123"},"modified":"2015-12-13T16:36:56","modified_gmt":"2015-12-13T16:36:56","slug":"latitudes-and-longitudes-in-the-netherlands","status":"publish","type":"post","link":"http:\/\/archief.van-maanen.com\/?p=1123","title":{"rendered":"Latitudes and longitudes in the Netherlands"},"content":{"rendered":"<p>Getting geographical data on Holland is not a trivial matter. It took me a bit of tenacity to get the data. Hence I thought being a good idea to store my findings. I might need these data in the future. The first file that I found on the internet is  <a href=\"http:\/\/62.131.51.129\/wp-content\/uploads\/2015\/12\/Alle-gemeenten-in-Nederland.csv\">a file with longitudes\/ latitudes of municipalities.<\/a>. Then nice thing about this file is that municipalities are given with a polygon. It is possible to show the municipalities with their contours on a map. Later, I found another file with six digit postal codes. Each postal code represents about 10 different addresses. This file is <a href=\"http:\/\/62.131.51.129\/wp-content\/uploads\/2015\/12\/Book1.txt\">stored here<\/a>.<br \/>\nI use these data to display spatial information in Oracle. In Oracle such data must be stored in a special data type, SDO_Geometry. The import file on municipalities is stored  <a href=\"http:\/\/62.131.51.129\/wp-content\/uploads\/2015\/12\/gemeentes.sql\">stored here<\/a>. The import file on postal code is <a href=\"http:\/\/62.131.51.129\/wp-content\/uploads\/2015\/12\/pcodes1.sql\">provided here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Getting geographical data on Holland is not a trivial matter. It took me a bit of tenacity to get the data. Hence I thought being a good idea to store my findings. I might need these data in the future. The first file that I found on the internet is a file with longitudes\/ latitudes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1124,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-warehousing"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/1123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1123"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/1123\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1123"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}