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
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
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
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
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
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
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
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
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
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
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
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
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
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
14 matches
Mail list logo