{"id":333,"date":"2022-10-07T13:58:07","date_gmt":"2022-10-07T12:58:07","guid":{"rendered":"http:\/\/blog.c-hase.de\/?p=333"},"modified":"2022-10-07T13:58:07","modified_gmt":"2022-10-07T12:58:07","slug":"updatestreetdata","status":"publish","type":"post","link":"http:\/\/blog.c-hase.de\/?p=333","title":{"rendered":"Updatestreetdata"},"content":{"rendered":"<p>teiltabelle anlegen.<\/p>\n<pre>CREATE TABLE `streetdataUpdate` (\r\n`id` int(11) DEFAULT NULL,\r\n`Gemeindeschluessel` varchar(255) DEFAULT NULL,\r\n`gemeinde` varchar(255) DEFAULT NULL,\r\n`bundesland` varchar(255) DEFAULT NULL,\r\n`landkreis` varchar(255) DEFAULT NULL,\r\n`ort` varchar(255) DEFAULT NULL,\r\n`ortszusatz` varchar(255) DEFAULT NULL,\r\n`plz` varchar(8) DEFAULT NULL,\r\n`strasse` varchar(255) DEFAULT NULL,\r\n`von` varchar(255) DEFAULT NULL,\r\n`bis` varchar(255) DEFAULT NULL,\r\n`bezirk` varchar(255) DEFAULT NULL,\r\n`region` varchar(255) DEFAULT NULL,\r\n`ortsteil` varchar(255) DEFAULT NULL\r\n) \r\n<\/pre>\n<p>csv Daten von streetdata herunterladen<\/p>\n<p>mittels Heidisql einspielen. (erlaubt auch gro\u00dfe Dateien)<\/p>\n<p>geht auch vom Server aus.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>teiltabelle anlegen. CREATE TABLE `streetdataUpdate` ( `id` int(11) DEFAULT NULL, `Gemeindeschluessel` varchar(255) DEFAULT NULL, `gemeinde` varchar(255) DEFAULT NULL, `bundesland` varchar(255) DEFAULT NULL, `landkreis` varchar(255) DEFAULT NULL, `ort` varchar(255) DEFAULT NULL, `ortszusatz` varchar(255) DEFAULT NULL, `plz` varchar(8) DEFAULT NULL, `strasse` varchar(255) &hellip; <a href=\"http:\/\/blog.c-hase.de\/?p=333\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-333","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=333"}],"version-history":[{"count":1,"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions"}],"predecessor-version":[{"id":334,"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions\/334"}],"wp:attachment":[{"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}