Hello,
i have set up PostgresQL on a 480 Gb SSD, so there should be heaps of space
for the database and the import.
The commented log of the import is at the end of this mail.
The import was running for less than a day and stopped sometime in the night.
I think --flat-nodes needs a parameter,
Hello,
i once got a hint on this mailing list to use a query like this to get the
lat/lon of the world capitals:
A)
select st_X(wayLL), st_Y(wayLL), name from (select
ST_AsText(ST_Transform(way,4326)) as wayLL, name from planet_osm_point where
capital='yes') as foo limit 5;
B)
Based on that h
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
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
>
>
>
false
-20037508,-19929239,20037508,19929239
so it is a problem of the settings? From googling it seems i need to
set
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
Hello,
i freshly installed the latest database and raw SQL queries work. Thank you
all for the hints that i got here.
I imported the data in WGS84, not Mercator. I started osm2pgsql like this:
osm2pgsql -s -l planet_file.tar.bz2
I wonder, all the python scripts for mapnik don't draw any data
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 char
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
Proc
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 T
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.
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
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. W
it _not_filled_ with
> a
> > LineSymbolizer instead of a PolygonSymbolizer, you get some
> disturbing
> > "plates". But the projection is fine.
> >
> > A
gt; fine.
>
> A ShapeFile contains the "source SRS" inside it, right? When
> rendering
> world_boundaries_m and shoreline_300 i used the same "target
> SRS".
> But the result leads to different positions on the final m
Does that mean that world_boundaries_m is defect?
Is there a way 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
en missing"?
Is there a way to find out which entry represents the boundarys 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 &quo
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,
en missing"?
Is there a way to find out which entry represents the boundarys 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 &quo
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,
Hello,
i can create a map with the "blue marble" as background.
I'd like to overlay the boundaries of the continents and islands and states.
The only correct ShapeFiles i could find have tiles and create a pattern that
doesn't look good in the final image.
I have a ShapeFile that seems to be inc
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
009 08:15:14 schrieb Jukka Rahkonen:
> Torsten Mohr 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 man
them would overwrite
all the satellite image background.
Best regards,
Torsten.
Am Donnerstag, 7. Mai 2009 08:18:35 schrieb Jukka Rahkonen:
> Torsten Mohr s.netic.de> writes:
> > Hello,
> >
> > i'm glad i got the "blu marble" working nw and can create a map of
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 thes
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 "s
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 v
ee a description of projections and
> the use of
> gdalwarp that describes how to get
>
>
> http://egb13.net/2009/04/bending-the-earth-gdalwarp-and-the-blue-marble/
>
>
> But in the end, my understanding did not leave to a correctly
>
m Sonntag, 3. Mai 2009 14:11:06 schrieb Jukka Rahkonen:
> Torsten Mohr 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 g
and i also 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%).
>
> T
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
Hello,
i have an image that can be wrapped around a sphere, its x / y coordinates
directly map to latitude / longitude.
Is that enough information to tell the SRS of that image?
Background is that i'd like to transform that image so it matches the SRS used
in osm.xml. Would that be WGS84? Or i
GS84 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
> A
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
hat i can write
filters like
[CNTRY_NAME] = 'Germany'
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 go
Hello,
has anybody got some experience with the Shapefiles at:
http://dataservice.eea.europa.eu/dataservice/metadetails.asp?id=760
I just downloaded the file for Germany (DE).
Is there a way to filter for the federal states? I want to highlight each of
them in a different color.
To formulate
Hi,
i just found out using a hex editor that the rule i need is:
[CNTRY_NAME] = 'Germany'
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 Moh
Hello,
looking into osm.xml i see Rules with Filters like:
[tourism] = 'attraction'
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
names, i want t
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.
__
mstag, 18. April 2009 10:34:06 schrieb D Tucny:
> 2009/4/18 Torsten Mohr
>
> > Hello,
> >
> > i installed PostgreSQL / PostGIS and use a modified version of this
> > script to render maps:
> >
> > svn.openstreetmap.org/applications/render/mapnik/generate
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 detail'
Hello,
thanks a lot for the hints, i just started importing with option -s.
Best regards,
Torsten.
> Torsten Mohr s.netic.de> writes:
> > Reading in file: -
> > Processing: Node(330350k) Way(159k) Relation(0k)
> > Speicherzugriffsfehler
> > # The line above
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 se
42 matches
Mail list logo
