Re: [OSM-talk] German Shapefile, federal states?
Hello Juan, thanks a lot for that link, it looks like this is exactly what i was searching for. Also, the hint to use a program like qgis was great, thanks to all your hints. It took me a while to find out that the scale of the data in PostGIS and in shoreline_300 are different to the scale in germany.shp. QGIS renders both with these settings: +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs But the Polygons in germany are drawn at lat / lon 0 / 0, on the equator before Africa. Do i need to change that settings to make the Polygons match? Where do you want to draw that map? I'm not sure if i understand you corectly, i want to render a huge map of Germany using the data in PostGIS. But i want to show the federal states in different colors. Best regards, Torsten. Am Donnerstag, 30. April 2009 21:04:01 schrieb Juan Lucas Dominguez Rubio: Hello, Torsten. I think the 16 german federal states (lander) are available as a shapefile in lots of different places. Here is one example: http://wetnet.net/~we7u/xastir/maps/shapefile/Germany/ That is a shapefile (compressed) with 16 polygons, and you also have the population and extension of each one. You have to open it with some GIS application. Where do you want to draw that map? Regards, Juan Lucas De: talk-boun...@openstreetmap.org en nombre de Torsten Mohr Enviado el: jue 30/04/2009 19:20 Para: OSM Talk Asunto: Re: [OSM-talk] German Shapefile, federal states? Ouch, that's bad. i thought they'd contain some actual data, size implied that. I wonder if anybody knows a way to render the 16 German federal states (Bundesländer)? Actually that's what i want to do in the end.. Is there a way to find out what is in a Shapefile? Like that i can write filters like Filter[CNTRY_NAME] = 'Germany'/Filter in world_boundaries_m? Is there a way to find this out from a Shapefile? Thanks for any hints, Torsten. Am Mittwoch, 29. April 2009 23:06:18 schrieb Frederik Ramm: Hi, Torsten Mohr wrote: has anybody got some experience with the Shapefiles at: http://dataservice.eea.europa.eu/dataservice/metadetails.asp?id=760 All I can see are shapefiles that contain a reference grid - no actual geodata? Bye Frederik ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] German Shapefile, federal states?
Hello, Yes, germany.shp is in +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs (used by GPS devices ans by the OSM database), but shoreline_300 is in the spherical mercator projection, which is the projection used by OSM to _render_ the maps because it looks nicer than WGS84 and is widely used. So you either have to reproject germany.shp to spherical mercator (see attached screenshot) or reproject shoreline_300 to WGS84. To do this, you can use FWTools (http://fwtools.maptools.org). It includes command-line utilities: ogr2ogr -s_srs epsg:4326 -t_srs +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +no_defs germany_sm.shp germany.shp OR ogr2ogr -s_srs +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +no_defs -t_srs epsg:4326 shoreline_300_wgs84.shp shoreline_300.shp (as you can see, the last two parameters are not source destination, but destination source) The EPSG code for WGS84 is EPSG:4326 The EPSG code for WGS84 is EPSG:900913 or EPSG:3785 (synonyms) Regards, Juan Lucas De: talk-boun...@openstreetmap.org en nombre de Torsten Mohr Enviado el: vie 01/05/2009 10:30 Para: OSM Talk Asunto: Re: [OSM-talk] German Shapefile, federal states? Hello Juan, thanks a lot for that link, it looks like this is exactly what i was searching for. Also, the hint to use a program like qgis was great, thanks to all your hints. It took me a while to find out that the scale of the data in PostGIS and in shoreline_300 are different to the scale in germany.shp. QGIS renders both with these settings: +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs But the Polygons in germany are drawn at lat / lon 0 / 0, on the equator before Africa. Do i need to change that settings to make the Polygons match? Where do you want to draw that map? I'm not sure if i understand you corectly, i want to render a huge map of Germany using the data in PostGIS. But i want to show the federal states in different colors. Best regards, Torsten. Am Donnerstag, 30. April 2009 21:04:01 schrieb Juan Lucas Dominguez Rubio: Hello, Torsten. I think the 16 german federal states (lander) are available as a shapefile in lots of different places. Here is one example: http://wetnet.net/~we7u/xastir/maps/shapefile/Germany/ That is a shapefile (compressed) with 16 polygons, and you also have the population and extension of each one. You have to open it with some GIS application. Where do you want to draw that map? Regards, Juan Lucas De: talk-boun...@openstreetmap.org en nombre de Torsten Mohr Enviado el: jue 30/04/2009 19:20 Para: OSM Talk Asunto: Re: [OSM-talk] German Shapefile, federal states? Ouch, that's bad. i thought they'd contain some actual data, size implied that. I wonder if anybody knows a way to render the 16 German federal states (Bundesländer)? Actually that's what i want to do in the end.. Is there a way to find out what is in a Shapefile? Like that i can write filters like Filter[CNTRY_NAME] = 'Germany'/Filter in world_boundaries_m? Is there a way to find this out from a Shapefile? Thanks for any hints, Torsten. Am Mittwoch, 29. April 2009 23:06:18 schrieb Frederik Ramm: Hi, Torsten Mohr wrote: has anybody got some experience with the Shapefiles at: http://dataservice.eea.europa.eu/dataservice/metadetails.asp?id=760 All I can see are shapefiles that contain a reference grid - no actual geodata? Bye Frederik ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk attachment: germany_sm.png___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] German Shapefile, federal states?
Sorry, I meant: The EPSG code for Spherical Mercator is EPSG:900913 or EPSG:3785 (synonyms) regards Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] German Shapefile, federal states?
Awesome, thanks a lot. It all worked fine, i converted the germany.shp as you mentioned. I was not sure about the SRS of source and target, especially the parts mentioned in osm.xml. Googling for them did not help and ogr2ogr also does not seem to explain them. Best regards, Torsten. Am Freitag, 1. Mai 2009 11:19:21 schrieb Juan Lucas Dominguez Rubio: Hello, Yes, germany.shp is in +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs (used by GPS devices ans by the OSM database), but shoreline_300 is in the spherical mercator projection, which is the projection used by OSM to _render_ the maps because it looks nicer than WGS84 and is widely used. So you either have to reproject germany.shp to spherical mercator (see attached screenshot) or reproject shoreline_300 to WGS84. To do this, you can use FWTools (http://fwtools.maptools.org). It includes command-line utilities: ogr2ogr -s_srs epsg:4326 -t_srs +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +no_defs germany_sm.shp germany.shp OR ogr2ogr -s_srs +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +no_defs -t_srs epsg:4326 shoreline_300_wgs84.shp shoreline_300.shp (as you can see, the last two parameters are not source destination, but destination source) The EPSG code for WGS84 is EPSG:4326 The EPSG code for WGS84 is EPSG:900913 or EPSG:3785 (synonyms) Regards, Juan Lucas De: talk-boun...@openstreetmap.org en nombre de Torsten Mohr Enviado el: vie 01/05/2009 10:30 Para: OSM Talk Asunto: Re: [OSM-talk] German Shapefile, federal states? Hello Juan, thanks a lot for that link, it looks like this is exactly what i was searching for. Also, the hint to use a program like qgis was great, thanks to all your hints. It took me a while to find out that the scale of the data in PostGIS and in shoreline_300 are different to the scale in germany.shp. QGIS renders both with these settings: +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs But the Polygons in germany are drawn at lat / lon 0 / 0, on the equator before Africa. Do i need to change that settings to make the Polygons match? Where do you want to draw that map? I'm not sure if i understand you corectly, i want to render a huge map of Germany using the data in PostGIS. But i want to show the federal states in different colors. Best regards, Torsten. Am Donnerstag, 30. April 2009 21:04:01 schrieb Juan Lucas Dominguez Rubio: Hello, Torsten. I think the 16 german federal states (lander) are available as a shapefile in lots of different places. Here is one example: http://wetnet.net/~we7u/xastir/maps/shapefile/Germany/ That is a shapefile (compressed) with 16 polygons, and you also have the population and extension of each one. You have to open it with some GIS application. Where do you want to draw that map? Regards, Juan Lucas De: talk-boun...@openstreetmap.org en nombre de Torsten Mohr Enviado el: jue 30/04/2009 19:20 Para: OSM Talk Asunto: Re: [OSM-talk] German Shapefile, federal states? Ouch, that's bad. i thought they'd contain some actual data, size implied that. I wonder if anybody knows a way to render the 16 German federal states (Bundesländer)? Actually that's what i want to do in the end.. Is there a way to find out what is in a Shapefile? Like that i can write filters like Filter[CNTRY_NAME] = 'Germany'/Filter in world_boundaries_m? Is there a way to find this out from a Shapefile? Thanks for any hints, Torsten. Am Mittwoch, 29. April 2009 23:06:18 schrieb Frederik Ramm: Hi, Torsten Mohr wrote: has anybody got some experience with the Shapefiles at: http://dataservice.eea.europa.eu/dataservice/metadetails.asp?id=760 All I can see are shapefiles that contain a reference grid - no actual geodata? Bye Frederik ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] German Shapefile, federal states?
Ouch, that's bad. i thought they'd contain some actual data, size implied that. I wonder if anybody knows a way to render the 16 German federal states (Bundesländer)? Actually that's what i want to do in the end.. Is there a way to find out what is in a Shapefile? Like that i can write filters like Filter[CNTRY_NAME] = 'Germany'/Filter in world_boundaries_m? Is there a way to find this out from a Shapefile? Thanks for any hints, Torsten. Am Mittwoch, 29. April 2009 23:06:18 schrieb Frederik Ramm: Hi, Torsten Mohr wrote: has anybody got some experience with the Shapefiles at: http://dataservice.eea.europa.eu/dataservice/metadetails.asp?id=760 All I can see are shapefiles that contain a reference grid - no actual geodata? Bye Frederik ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] German Shapefile, federal states?
Hi, Torsten Mohr wrote: Is there a way to find out what is in a Shapefile? Use a GIS program like QGIS to open and display the shapefile and you can see what's there! Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] German Shapefile, federal states?
Hello, Torsten. I think the 16 german federal states (lander) are available as a shapefile in lots of different places. Here is one example: http://wetnet.net/~we7u/xastir/maps/shapefile/Germany/ That is a shapefile (compressed) with 16 polygons, and you also have the population and extension of each one. You have to open it with some GIS application. Where do you want to draw that map? Regards, Juan Lucas De: talk-boun...@openstreetmap.org en nombre de Torsten Mohr Enviado el: jue 30/04/2009 19:20 Para: OSM Talk Asunto: Re: [OSM-talk] German Shapefile, federal states? Ouch, that's bad. i thought they'd contain some actual data, size implied that. I wonder if anybody knows a way to render the 16 German federal states (Bundesländer)? Actually that's what i want to do in the end.. Is there a way to find out what is in a Shapefile? Like that i can write filters like Filter[CNTRY_NAME] = 'Germany'/Filter in world_boundaries_m? Is there a way to find this out from a Shapefile? Thanks for any hints, Torsten. Am Mittwoch, 29. April 2009 23:06:18 schrieb Frederik Ramm: Hi, Torsten Mohr wrote: has anybody got some experience with the Shapefiles at: http://dataservice.eea.europa.eu/dataservice/metadetails.asp?id=760 All I can see are shapefiles that contain a reference grid - no actual geodata? Bye Frederik ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
