Hi, i am a newbie to geo cordinate work. Former collegues of mine created a code to calculate the SURFACE of each zipcode area (PLZ). Now I need to run this program on updated data. The input was line with the coordinates of each corner of the respective polygone for the zip code. Unfortunately, I cannot get ahold of such data. I suspect It's somewhere hidden in the DE- file, but I am not sure. The approximate coordinates of cities will not do.
I need something like
39, 01591, 1591, Riesa, 13.21233192,51.33922191,13.21498116,51.33906171,13.21523676,51.33653262,13.21400268,51.33638763,13.21403328,51.33371733,13.21851168,51.33382038,13.2207462,51.33389661,13.2213096,51.33271023,13.22404092,51.33272175,13.22351748,51.3313866,13.22315208,51.32824326,13.22552952,51.32831571,13.23223488,51.32839968,13.23551952,51.32808306,13.23944856,51.32774736,13.24276164,51.32783889,13.24575792,51.32730483,13.24791432,51.32728962,13.2509232,51.32716371,13.25291904,51.32692719,13.25296512,51.32656476,13.25397672,51.32662578,13.2540282,51.32734677,13.25890152,51.32716371,13.2628716,51.32719044,13.2687558,51.32806011,13.2696306,51.32863233,13.27005396,51.32891844,13.27017312,51.32899476,13.27027896,51.32906343,13.27048956,51.32920077,13.2722262,51.33035277,13.27447116,51.33159639,13.27253436,51.33367539,13.27016736,51.33576969,13.2711372,51.3362808,13.27148064,51.33604815,13.27254876,51.33489228,13.2751008,51.33337785,13.27755564,51.33533481,13.2806664,51.33962628,13.28444784,51.33721545,13.2828606,51.3361359,13.28394708,51.33524706,13.28298012,51.3347778,13.2837354,51.33426282,13.2851952,51.33359142,13.28654664,51.33440781,13.29130836,51.33441159,13.29446808,51.33436587,13.294566,51.33472443,13.29635916,51.33467484,13.29655176,51.33435444,13.29576876,51.3294678,13.29767424,51.32896425,13.29849324,51.32835387,13.29842664,51.32641986,13.2978276,51.32508471,13.2970428,51.32416149,13.29630552,51.32391354,13.29494004,51.32390598,13.29484932,51.32363895,13.29484176,51.32052234,13.29472728,51.31791306,13.29461388,51.31634139,13.29570108,51.31446453,13.2964362,51.31367496,13.29680916,51.31327824,13.29645636,51.31295775,13.29518988,51.31235889,13.29312708,51.31165311,13.2900678,51.31106568,13.28694336,51.31056591,13.28478804,51.31058121,13.28141412,51.31081008,13.27891824,51.31110384,13.27653792,51.31198116,13.27301892,51.31302642,13.27090356,51.31358334,13.26855456,51.31391526,13.26462552,51.31443024,13.26298428,51.31459431,13.26248928,51.31165311,13.2575922,51.3084564,13.25451384,51.30660627,13.24757664,51.3052254,13.24364184,51.30443196,13.23744408,51.30212787,13.23611352,51.30159759,13.235463,51.30132678,13.23512172,51.30119322,13.23479844,51.30106353,13.23468108,51.30084231,13.23223956,51.30086517,13.23193932,51.30064773,13.2309036,51.29819874,13.22926056,51.29833599,13.22797572,51.2984619,13.22708328,51.29799273,13.22528184,51.29813007,13.225257,51.29777142,13.2220926,51.29772183,13.222062,51.29727174,13.21757136,51.29676819,13.21682832,51.2953911,13.21557624,51.29700093,13.21361172,51.30178452,13.21248348,51.30515673,13.21088328,51.30817029,13.20847416,51.31278612,13.20962616,51.31280133,13.21044156,51.31318284,13.21122168,51.31406403,13.2110424,51.31456371,13.20866208,51.31444932,13.20747192,51.31800081,13.20709896,51.31985859,13.20568956,51.32849886,13.20456312,51.32884212,13.21233192,51.33922191
which may be in another format, but the information should be more or less complete.
Thanks
Greg
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
try the database & commandline tools (especially "osmosis") from http://www.openstreetmap.org/ .. I'm actually interested in this myself - haven't made much progress yet. Here's what I used to find streetnames in all of Germany:
~~~~:::shell
$ bin/osmosis --read-xml ../OSM/germany-latest.osm --tf accept-ways highway=* --used-node --write-xml ../highways.osm
Which will give you something like this:
~~~~:::XML
<?xml version='1.0' encoding='UTF-8'?><osmversion="0.6"generator="Osmosis 0.43.1"><boundsminlon="5.86442"minlat="47.26543"maxlon="15.05078"maxlat="55.14777"origin="osmconvert 0.7P"/><nodeid="10"version="7"timestamp="2013-01-03T09:02:51Z"uid="362391"user="DrSeuthberg"changeset="14509589"lat="51.3806887"lon="9.3601583"/><nodeid="12"version="4"timestamp="2012-10-18T15:59:05Z"uid="897213"user="Navi Rookie"changeset="13546297"lat="51.3400443"lon="9.4818949"/><nodeid="13"version="2"timestamp="2011-05-08T22:06:06Z"uid="134914"user="max60watt"changeset="8087754"lat="51.3731042"lon="9.5130058"><tagk="highway"v="bus_stop"/><tagk="name"v="Bleichplatz"/><tagk="shelter"v="yes"/><tagk="uic_ref"v="713807"/></node>
HTH :-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, i am a newbie to geo cordinate work. Former collegues of mine created a code to calculate the SURFACE of each zipcode area (PLZ). Now I need to run this program on updated data. The input was line with the coordinates of each corner of the respective polygone for the zip code. Unfortunately, I cannot get ahold of such data. I suspect It's somewhere hidden in the DE- file, but I am not sure. The approximate coordinates of cities will not do.
I need something like
39, 01591, 1591, Riesa, 13.21233192,51.33922191,13.21498116,51.33906171,13.21523676,51.33653262,13.21400268,51.33638763,13.21403328,51.33371733,13.21851168,51.33382038,13.2207462,51.33389661,13.2213096,51.33271023,13.22404092,51.33272175,13.22351748,51.3313866,13.22315208,51.32824326,13.22552952,51.32831571,13.23223488,51.32839968,13.23551952,51.32808306,13.23944856,51.32774736,13.24276164,51.32783889,13.24575792,51.32730483,13.24791432,51.32728962,13.2509232,51.32716371,13.25291904,51.32692719,13.25296512,51.32656476,13.25397672,51.32662578,13.2540282,51.32734677,13.25890152,51.32716371,13.2628716,51.32719044,13.2687558,51.32806011,13.2696306,51.32863233,13.27005396,51.32891844,13.27017312,51.32899476,13.27027896,51.32906343,13.27048956,51.32920077,13.2722262,51.33035277,13.27447116,51.33159639,13.27253436,51.33367539,13.27016736,51.33576969,13.2711372,51.3362808,13.27148064,51.33604815,13.27254876,51.33489228,13.2751008,51.33337785,13.27755564,51.33533481,13.2806664,51.33962628,13.28444784,51.33721545,13.2828606,51.3361359,13.28394708,51.33524706,13.28298012,51.3347778,13.2837354,51.33426282,13.2851952,51.33359142,13.28654664,51.33440781,13.29130836,51.33441159,13.29446808,51.33436587,13.294566,51.33472443,13.29635916,51.33467484,13.29655176,51.33435444,13.29576876,51.3294678,13.29767424,51.32896425,13.29849324,51.32835387,13.29842664,51.32641986,13.2978276,51.32508471,13.2970428,51.32416149,13.29630552,51.32391354,13.29494004,51.32390598,13.29484932,51.32363895,13.29484176,51.32052234,13.29472728,51.31791306,13.29461388,51.31634139,13.29570108,51.31446453,13.2964362,51.31367496,13.29680916,51.31327824,13.29645636,51.31295775,13.29518988,51.31235889,13.29312708,51.31165311,13.2900678,51.31106568,13.28694336,51.31056591,13.28478804,51.31058121,13.28141412,51.31081008,13.27891824,51.31110384,13.27653792,51.31198116,13.27301892,51.31302642,13.27090356,51.31358334,13.26855456,51.31391526,13.26462552,51.31443024,13.26298428,51.31459431,13.26248928,51.31165311,13.2575922,51.3084564,13.25451384,51.30660627,13.24757664,51.3052254,13.24364184,51.30443196,13.23744408,51.30212787,13.23611352,51.30159759,13.235463,51.30132678,13.23512172,51.30119322,13.23479844,51.30106353,13.23468108,51.30084231,13.23223956,51.30086517,13.23193932,51.30064773,13.2309036,51.29819874,13.22926056,51.29833599,13.22797572,51.2984619,13.22708328,51.29799273,13.22528184,51.29813007,13.225257,51.29777142,13.2220926,51.29772183,13.222062,51.29727174,13.21757136,51.29676819,13.21682832,51.2953911,13.21557624,51.29700093,13.21361172,51.30178452,13.21248348,51.30515673,13.21088328,51.30817029,13.20847416,51.31278612,13.20962616,51.31280133,13.21044156,51.31318284,13.21122168,51.31406403,13.2110424,51.31456371,13.20866208,51.31444932,13.20747192,51.31800081,13.20709896,51.31985859,13.20568956,51.32849886,13.20456312,51.32884212,13.21233192,51.33922191
which may be in another format, but the information should be more or less complete.
Thanks
Greg
try the database & commandline tools (especially "osmosis") from http://www.openstreetmap.org/ .. I'm actually interested in this myself - haven't made much progress yet. Here's what I used to find streetnames in all of Germany:
~~~~:::shell
$ bin/osmosis --read-xml ../OSM/germany-latest.osm --tf accept-ways highway=* --used-node --write-xml ../highways.osm
Which will give you something like this: ~~~~:::XML <?xml version='1.0' encoding='UTF-8'?> <osm version="0.6" generator="Osmosis 0.43.1"> <bounds minlon="5.86442" minlat="47.26543" maxlon="15.05078" maxlat="55.14777" origin="osmconvert 0.7P"/> <node id="10" version="7" timestamp="2013-01-03T09:02:51Z" uid="362391" user="DrSeuthberg" changeset="14509589" lat="51.3806887" lon="9.3601583"/> <node id="12" version="4" timestamp="2012-10-18T15:59:05Z" uid="897213" user="Navi Rookie" changeset="13546297" lat="51.3400443" lon="9.4818949"/> <node id="13" version="2" timestamp="2011-05-08T22:06:06Z" uid="134914" user="max60watt" changeset="8087754" lat="51.3731042" lon="9.5130058"> <tag k="highway" v="bus_stop"/> <tag k="name" v="Bleichplatz"/> <tag k="shelter" v="yes"/> <tag k="uic_ref" v="713807"/> </node>HTH :-)