Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Martijn van Oosterhout
On Dec 27, 2007 6:20 PM, Joerg Ostertag (OSM Munich/Germany) <[EMAIL PROTECTED]> wrote: > I tried something like: > > echo "select osm_id,highway,name from planet_osm_line where highway is not > null and way && transform(GeomFromText('POLYGON((48.18605 11.86398,48.18632 > 11.86398,48.18632 11.868

Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Jochen Topf
On Thu, Dec 27, 2007 at 06:20:47PM +0100, Joerg Ostertag (OSM Munich/Germany) wrote: > FEHLER: AddToPROJ4SRSCache: Cannot find SRID (3395) in spatial_ref_sys You probably have to read the contents of /usr/share/postgresql-8.2-postgis/spatial_ref_sys.sql into you db with psql -f /usr/share/postgr

Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Joerg Ostertag (OSM Munich/Germany)
I tried something like: echo "select osm_id,highway,name from planet_osm_line where highway is not null and way && transform(GeomFromText('POLYGON((48.18605 11.86398,48.18632 11.86398,48.18632 11.86884,48.18605 11.86884,48.18605 11.86398))',4326),3395) limit 5;" | psql gis FEHLER: AddToPROJ4S

Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Joerg Ostertag (OSM Munich/Germany)
On Donnerstag 27 Dezember 2007, Jochen Topf wrote: > On Thu, Dec 27, 2007 at 03:43:32PM +0100, Joerg Ostertag (OSM ... Thanks for the example. It works and helpd a lot. > The 3395 ist the so-called SRID, the projection used. Mapnik db uses > WGS84 Mercator. But now Im trying to find out how I

Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Martijn van Oosterhout
On Dec 27, 2007 4:21 PM, Jochen Topf <[EMAIL PROTECTED]> wrote: > The 3395 ist the so-called SRID, the projection used. Mapnik db uses > WGS84 Mercator. Note this is a paramter of the conversion. On my sites I use Spherical Mercator (900913) which avoid an extra reprojection in TileCache/Mapnik. W

Re: [OSM-dev] [Mapnik-users] How does Mapnik know which nodes are "important"?

2007-12-27 Thread Gabriel Ebner
On Thu, Dec 27, 2007 at 03:29:47PM +, Jon Burgess wrote: > On 27/12/2007, Gabriel Ebner <[EMAIL PROTECTED]> wrote: > > On Thu, Dec 27, 2007 at 02:06:48AM +, Jon Burgess wrote: > > > > By using QuadTiles, you only have to look at 120,000 nodes (10,000 > > > > nodes each for the QuadTile and

Re: [OSM-dev] [Mapnik-users] How does Mapnik know which nodes are "important"?

2007-12-27 Thread Jon Burgess
On 27/12/2007, Gabriel Ebner <[EMAIL PROTECTED]> wrote: > On Thu, Dec 27, 2007 at 02:06:48AM +, Jon Burgess wrote: > > > By using QuadTiles, you only have to look at 120,000 nodes (10,000 > > > nodes each for the QuadTile and all of its parents) to determine what to > > > map. Of course, you co

Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Jochen Topf
On Thu, Dec 27, 2007 at 03:43:32PM +0100, Joerg Ostertag (OSM Munich/Germany) wrote: > I would like to query mapnik data directly from the postgis Database. Can > anyone give me a hint which SELECT statements I would need to querey all > streets in a bounding Box or in the (surrounding) area of

Re: [OSM-dev] querying mapnik data

2007-12-27 Thread Jon Burgess
On 27/12/2007, Joerg Ostertag (OSM Munich/Germany) <[EMAIL PROTECTED]> wrote: > I would like to query mapnik data directly from the postgis Database. Can > anyone give me a hint which SELECT statements I would need to querey all > streets in a bounding Box or in the (surrounding) area of a point. I

[OSM-dev] Rails environment on dev

2007-12-27 Thread Nick Black
When running: $ rake db:migrate --trace >From a fresh svn checkout on dev I see this error: (in /home/nickb/rails_port) rake aborted! undefined method `gem' for main:Object /home/nickb/rails_port/config/boot.rb:29 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:21:in `require__' /usr/loc

[OSM-dev] querying mapnik data

2007-12-27 Thread Joerg Ostertag (OSM Munich/Germany)
I would like to query mapnik data directly from the postgis Database. Can anyone give me a hint which SELECT statements I would need to querey all streets in a bounding Box or in the (surrounding) area of a point. I want to use this inside of osmtrackfilter.pl to get and compare against the alre

Re: [OSM-dev] [Mapnik-users] How does Mapnik know which nodes are "important"?

2007-12-27 Thread Gabriel Ebner
On Thu, Dec 27, 2007 at 02:06:48AM +, Jon Burgess wrote: > > By using QuadTiles, you only have to look at 120,000 nodes (10,000 > > nodes each for the QuadTile and all of its parents) to determine what to > > map. Of course, you could use this in conjunction with spatial > > indexing to make th

Re: [OSM-dev] Osmosis - sorted streams

2007-12-27 Thread Brett Henderson
Cool thanks, I've done the former. It's only available in svn for now. Frederik Ramm wrote: > Hi, > > >> Yep, they require sorted input. I should add a validation check in the >> code to error if non-sorted input is detected. And I should add >> documentation to the wiki ... >> > > I

[OSM-dev] FW: [OSM-newbies] Text adventure game-like interface to openstreetmap?

2007-12-27 Thread Andy Robinson (blackadder)
Forwarded from the newbies list. Cheers Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Jones Sent: 27 December 2007 4:42 AM To: [EMAIL PROTECTED]; dev@openstreetmap.org Subject: Re: [OSM-newbies] Text adventure game-like interface to openstre