New answers tagged osm2pgsql
Maybe a heavy solution/workaround for a smal problem, but you can try to work with full planet extracts: http://wiki.openstreetmap.org/wiki/Planet.osm/full
The default.style file has this annotation: There are some special database columns that if present in the .style file will be populated by osm2pgsql. These are osm_user, osm_uid, osm_version, osm_timestamp - datatype text. Used with the --extra-attributes option to include metadata in the database. If importing with both --hstore and ...
By default, the source tag is automatically deleted. You will need to remove the delete line for that tag later in the file. German names are stored with the "name:de" tag. I would not expect you to find anything in a "name_de" column.
With osm2pgsql, you have to edit the default.style file. it is a simple text file, so any text editor will do. For including lanes, add a line node,way lane text linear you have to re-import your data afterwards. If you have installed the hstore, you could extract the tags from there, but that's a bit more difficult.
ST_AsLatLonText documentation says: It is assumed the point is in a lat/lon projection. The X (lon) and Y (lat) coordinates are normalized in the output to the "normal" range (-180 to +180 for lon, -90 to +90 for lat). So you are seeing your point (in 900913) "wrapped" around until it eventually gets into the normal range. To see your ...
A final good looking map style can be very complex and needs a lot of knowledge about the data and cartography. You might want to start with a ready to use SLD style file: http://blog.geoserver.org/2009/01/30/geoserver-and-openstreetmap/
Top 50 recent answers are included