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: [email protected] 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: [email protected] 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 > [email protected] > http://lists.openstreetmap.org/listinfo/talk _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
<<attachment: germany_sm.png>>
_______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk

