Hello,
i created a GIS database and imported the planet data with osm2pgsql -m.
So the data is stored in mercaator format.
When executing this raw SQL query:
select st_X(way), st_Y(way), name from planet_osm_point where capital='yes';
Then i get some data like:
st_x| st_y
Hi,
i've set up a new PostGIS server on Linux, i had all tools installed before,
i've just replaced the old database gis with a new one that i've imported
using -l instead of -m, so i use lat/lon instead of mercaator.
Now Mapnik still renders GeoTIFF and Shapefiles, but no data that come from
Hello,
Now Mapnik still renders GeoTIFF and Shapefiles, but no data that come
from PostGIS. But also, normal SQL queries still work.
What is the setting of
Parameter name=estimate_extent
Parameter name=extent
Parameter name=estimate_extentfalse/Parameter
Parameter
Hello,
thanks for your hints, i've set up the database gis completely new,
now i also imported _int.sql.
Setting up table: planet_osm_nodes
*** WARNING: intarray contrib module not installed
Now i get this error during import:
Reading in file: /local/ftp/osm/planet-100310.osm.bz2
Hello,
I can't imagine that the file is corrupt.
It is corrupt, from the developer list:
The planet dump code used to turn all characters less than 32
into '?' instead of creating these character sequences. I guess he
didn't read the bit of the XML spec which says that all characters
Hello,
i hope this is not off-topic here. I've set up a Postgis server here on my
linux box using OpenSuSE 11.2 like this:
Here are the commands (User tmohr):
su postgres
createuser -Upostgres -S -D -R tmohr
createdb -Upostgres -EUTF8 gis
psql -Upostgres gis
gis=# GRANT ALL ON SCHEMA PUBLIC
Hello,
thanks a lot for your hint.
http://postgis.refractions.net/documentation/manual-svn/ST_X.html
http://postgis.refractions.net/documentation/manual-svn/ST_Y.html
select st_X(st_transform(way,4326)), st_Y(st_transform(way,4326)) from
planet_osm_point where ...
I tried it like this:
Hello,
first, thank you all for your hints.
You might also consider importing with osm2pqsql with the -l flag (use
lat/lon) that way your database will be in a EPSG:4326 official
projection (which 900913 is not) and you will have an easier life if you
want to convert between projections.
Hi,
i'm not sure what is the best way, Mapnik or plain postgresql, maybe somebody
can give me a hint?
I'd like to get the coordinates of a point, e.g. Berlin or another city. In
postgres i can do:
psql -d gis
select * from planet_osm_point where name = 'Berlin';
Now several data are shown.
? Or would scaling be
possible?
Best regards,
Torsten.
Hi,
Torsten Mohr wrote:
I have a ShapeFile that seems to be incorrect, scaling it in
Y-direction could make it fit
? Or would
scaling be
possible?
Best regards,
Torsten.
Hi,
Torsten Mohr wrote
Hello,
i just found out that the missing states are called:
Freistaat Bayern
Freistaat Sachsen
Freistaat Thüringen
That was the problem.
Best regards,
Torsten.
On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote:
I also tried to access Thüringen by its osm_id, but also no success
of
the missing federal states?
Thanks for any hints,
Torsten.
Am Sonntag, 10. Mai 2009 14:19:35 schrieb Jon Burgess:
On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote:
I also tried to access Thüringen by its osm_id, but also no success.
In PSQL gis:
gis= select osm_id, name from
Hello,
i just found out that the missing states are called:
Freistaat Bayern
Freistaat Sachsen
Freistaat Thüringen
That was the problem.
Best regards,
Torsten.
On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote:
I also tried to access Thüringen by its osm_id, but also no success
of
the missing federal states?
Thanks for any hints,
Torsten.
Am Sonntag, 10. Mai 2009 14:19:35 schrieb Jon Burgess:
On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote:
I also tried to access Thüringen by its osm_id, but also no success.
In PSQL gis:
gis= select osm_id, name from
to fix it somehow? Or would scaling be possible?
Best regards,
Torsten.
Hi,
Torsten Mohr wrote:
I have a ShapeFile that seems to be incorrect, scaling it in Y-direction
could make it fit the background.
Do you have a basic understanding of coordinate projections? If not,
you'd
Hello,
when connecting to PostGIS and querying for german federal states
i can find them all in either:
planet_osm_line
planet_osm_polygon
It also is no problem to find states with special characters like in
Baden-Württemberg.
But no matter what i do, i don't find Bayern and Sachsen. I do
:
Torsten Mohr tmohr at s.netic.de writes:
Hello,
this issue is not related to another post that i did here regarding the
outline of the world (shoreline_300).
I want to create a map of Germany with many details, especially the
federal states should have different background colors.
I
Hello Jukka,
no, thanks for your help, any hint and discussion is really appreciated.
Sorry, I misunderstood a bit what you were going to do. It may well be
that for Mapnik you'll need to reproject raster image first. I do not much
about Mapnik and while a have been using gdal utilities very
Hello,
i'm glad i got the blu marble working nw and can create a map of the whole
world with the satellite images of the earth as background. It looks really
great.
But what would be great if i could also overlay the world / continents /
islands / states borders as outline.
I can't use the
Hello,
this issue is not related to another post that i did here regarding the
outline of the world (shoreline_300).
I want to create a map of Germany with many details, especially the
federal states should have different background colors.
I got a hint already for a ShapeFile that contains
:
Torsten Mohr tmohr at s.netic.de writes:
Hello,
thanks for that hint.
Right, the chosen projection won't work around the poles, i don't expect
that. In the call to gdalwarp i gave the source projection (EPSG:4326 or
WGS84) and as target projection i gave the projection used
projected
image...
Best regards,
Torsten.
Am Sonntag, 3. Mai 2009 14:11:06 schrieb Jukka Rahkonen:
Torsten Mohr tmohr at s.netic.de writes:
Hello,
thanks for that hint
Hello,
i got much further converting an image with gdalwarp, mainly with these two
links:
http://egb13.net/2009/04/bending-the-earth-gdalwarp-and-the-blue-marble/
http://en.wikipedia.org/wiki/World_file
Basically i got the blue marble (high quality TIF image of the earth,
consists of two files,
can't explain it.
Best regards,
Torsten.
On May 2, 2009, at 8:53 AM, Torsten Mohr wrote:
But cstr_4.tif is distorted, Africa is at 20% from the top, 40%
from the top
begins Antarctica and goes down to the bottom (100%).
There are a bunch of projections that don't work near the poles
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
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
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
Hello,
looking into osm.xml i see Rules with Filters like:
Filter[tourism] = 'attraction'/Filter
How can i find out what tags (right wording? I mean keywords like 'tourism')
are available? What values could they have?
Background is that i want to write an own Rule (with Filter) for country
Hi,
i just found out using a hex editor that the rule i need is:
Filter[CNTRY_NAME] = 'Germany'/Filter
It would be great to know if there is another way than using a hex editor,
has anybody got a hint?
Best regards,
Torsten.
Am Mittwoch, 29. April 2009 21:22:34 schrieb Torsten Mohr:
Hello
Hi,
can anybody give me a hint on a GPS logger? I'd just like to track the
position on SD card.
It would be great if the battery would last for a week or even longer.
That should also be much cheaper than e.g. Garmin GPS devices.
Thanks for any hints,
Torsten.
Hello,
i installed PostgreSQL / PostGIS and use a modified version of this
script to render maps:
svn.openstreetmap.org/applications/render/mapnik/generate_image.py
I've just created two maps of Germany, one is 12000 x 16000, the other
is 3000 x 4000. I then get two different 'levels of
, 18. April 2009 10:34:06 schrieb D Tucny:
2009/4/18 Torsten Mohr tm...@s.netic.de
Hello,
i installed PostgreSQL / PostGIS and use a modified version of this
script to render maps:
svn.openstreetmap.org/applications/render/mapnik/generate_image.py
I've just created two maps
Hello,
i have two sources of information that seem to contradict sometimes,
maybe somebody can give me some hints?
I used subversion to checkout svn.openstreetmap.org.
After installing geos-3.1.0 i could compile and install osm2pgsql.
I also downloaded and installed postgis-1.3.5.
I've also
34 matches
Mail list logo
