Re: [osmosis-dev] postgresql base for osmosis

2010-07-24 Thread Brett Henderson 
On Sat, Jul 24, 2010 at 2:44 AM, Nakor nakor@gmail.com wrote:

 On Fedora, the script to run against your database is
 /usr/share/pgsql/contrib/spatial_ref_sys.sql



 Brett,

 Thanks that helps. I was able to import data into the DB.

 BTW what are the other schema useful for?


What other schema are you referring to?

Brett
___
osmosis-dev mailing list
osmosis-dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/osmosis-dev

Re: [osmosis-dev] postgresql base for osmosis

2010-07-22 Thread Brett Henderson 
Hi Nakor,

You're getting an error earlier in the script:

psql:/tmp/pgsql_simple_schema_0.6.sql:42: ERROR:  AddGeometryColumns() -
invalid SRID
CONTEXT:  SQL statement SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 ,
$5 )
PL/pgSQL function addgeometrycolumn line 4 at SQL statement

You don't appear to have the PostGIS SRID tables populated.  I don't have
details handy on how to do this, but your PostGIS distribution should
include a script for doing this ...

I'll look again later when I have a PostgreSQL system available.

Brett

On Thu, Jul 22, 2010 at 10:16 AM, Nakor nakor@gmail.com wrote:

   Hello,

 Is there a good documentation for how to setup a postgresql base for
 osmosis. I've read thru OpenStrettMap wiki and it is quite hard to
 understand waht exact schema you need to use.

 I tired to use pgsql_simple_schema_0.6.sql but got errors (see below) and
 then when I run osmosis it complains about index idx_nodes_geom not
 existing.

 Thanks in advance,

  N.

 -bash-4.1$ psql -d local -f /tmp/pgsql_simple_schema_0.6.sql
 [...]
 psql:/tmp/pgsql_simple_schema_0.6.sql:42: ERROR:  AddGeometryColumns() -
 invalid SRID
 CONTEXT:  SQL statement SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4
 , $5 )
 PL/pgSQL function addgeometrycolumn line 4 at SQL statement
 [...]
 INSERT 0 1
 psql:/tmp/pgsql_simple_schema_0.6.sql:111: NOTICE:  ALTER TABLE / ADD
 PRIMARY KEY will create implicit index pk_schema_info for table
 schema_info
 ALTER TABLE
 psql:/tmp/pgsql_simple_schema_0.6.sql:113: NOTICE:  ALTER TABLE / ADD
 PRIMARY KEY will create implicit index pk_users for table users
 ALTER TABLE
 psql:/tmp/pgsql_simple_schema_0.6.sql:115: NOTICE:  ALTER TABLE / ADD
 PRIMARY KEY will create implicit index pk_nodes for table nodes
 ALTER TABLE
 psql:/tmp/pgsql_simple_schema_0.6.sql:117: NOTICE:  ALTER TABLE / ADD
 PRIMARY KEY will create implicit index pk_ways for table ways
 ALTER TABLE
 psql:/tmp/pgsql_simple_schema_0.6.sql:119: NOTICE:  ALTER TABLE / ADD
 PRIMARY KEY will create implicit index pk_way_nodes for table way_nodes
 ALTER TABLE
 psql:/tmp/pgsql_simple_schema_0.6.sql:121: NOTICE:  ALTER TABLE / ADD
 PRIMARY KEY will create implicit index pk_relations for table relations
 ALTER TABLE
 CREATE INDEX
 psql:/tmp/pgsql_simple_schema_0.6.sql:126: ERROR:  column geom does not
 exist
 [...]

 ___
 osmosis-dev mailing list
 osmosis-dev@openstreetmap.org
 http://lists.openstreetmap.org/listinfo/osmosis-dev

___
osmosis-dev mailing list
osmosis-dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/osmosis-dev

[osmosis-dev] postgresql base for osmosis

2010-07-21 Thread Nakor 

   Hello,

Is there a good documentation for how to setup a postgresql base for 
osmosis. I've read thru OpenStrettMap wiki and it is quite hard to 
understand waht exact schema you need to use.


I tired to use pgsql_simple_schema_0.6.sql but got errors (see below) 
and then when I run osmosis it complains about index idx_nodes_geom 
not existing.


Thanks in advance,

  N.

-bash-4.1$ psql -d local -f /tmp/pgsql_simple_schema_0.6.sql
[...]
psql:/tmp/pgsql_simple_schema_0.6.sql:42: ERROR:  AddGeometryColumns() - 
invalid SRID
CONTEXT:  SQL statement SELECT AddGeometryColumn('','', $1 , $2 , $3 , 
$4 , $5 )

PL/pgSQL function addgeometrycolumn line 4 at SQL statement
[...]
INSERT 0 1
psql:/tmp/pgsql_simple_schema_0.6.sql:111: NOTICE:  ALTER TABLE / ADD 
PRIMARY KEY will create implicit index pk_schema_info for table 
schema_info

ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:113: NOTICE:  ALTER TABLE / ADD 
PRIMARY KEY will create implicit index pk_users for table users

ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:115: NOTICE:  ALTER TABLE / ADD 
PRIMARY KEY will create implicit index pk_nodes for table nodes

ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:117: NOTICE:  ALTER TABLE / ADD 
PRIMARY KEY will create implicit index pk_ways for table ways

ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:119: NOTICE:  ALTER TABLE / ADD 
PRIMARY KEY will create implicit index pk_way_nodes for table way_nodes

ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:121: NOTICE:  ALTER TABLE / ADD 
PRIMARY KEY will create implicit index pk_relations for table relations

ALTER TABLE
CREATE INDEX
psql:/tmp/pgsql_simple_schema_0.6.sql:126: ERROR:  column geom does 
not exist

[...]

___
osmosis-dev mailing list
osmosis-dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/osmosis-dev