[OSM-talk] German Shapefile, federal states?

Fri May 1 10:19:21 BST 2009

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 +nadgrids=@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 +nadgrids=@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-bounces at 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-bounces at 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 at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk

_______________________________________________
talk mailing list
talk at openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090501/ec128207/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: germany_sm.png
Type: image/x-png
Size: 16488 bytes
Desc: germany_sm.png
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090501/ec128207/attachment.bin>