[Geocoding] Gazetteer instalation

[Michal Palenik]

hello, 

after compiling osm2pgsql (it was the first time i compiled something
under linux, i thought it would be harder), ignoring a lot of error
messages (like in _int.sql from pgsql contrib a type is defined later
than used), and waiting, i have an almost working copy of gazetteer.
when i will have a working and reliabable order of import procedures
i'll let you know, so far it is only trial and fail.


last messages that occur and (probably) cause troubles are missing tables
planet_osm_ways/rels, i don't know how to create them. 

now i am able to search for streets and cities, however POIs are not findable 
(in the www frontend). 

is there anything else i missed ?

michal


On Wed, Jan 27, 2010 at 03:39:22PM +0200, Ciprian Talaba wrote:
> Hi Michal,
> 
> On Wed, Jan 27, 2010 at 3:30 PM, Michal Palenik
> <michal.palenik at freemap.sk>wrote:
> 
> > hello, i have problems installing/configuring Gazetteer on debian
> > testing.
> >
> > i have osm2pgsql binary from packages, Gazetteer from todays svn
> > database creation is ok, osm2pgsql is also ok (after correcting
> > duplicate nodes)
> >
> > i have problems with step:
> > cat gazetteer-functions.sql | psql -q gazetteer
> >
> > ERROR:  typy keyvalue[] does not exist
> >
> > should it be created by ?
> >
> >  CREATE TYPE keyvalue AS (
> >  key TEXT,
> >    value TEXT
> >      );
> >
> >
> > (i could not find it anywhere, neither in
> > contrib nor in gazetteer)
> >
> >
> > other missing types are:
> > wordscore
> > place_boundingbox
> >
> > also in gazetteer-index.sql
> > place and placex have different structure, which causes
> > insert into placex select * from place where osm_type = 'N';
> > to fail
> >
> >
> > michal
> >
> > ps:
> > postgresql-contrib-8.3 needs to be installed
> >
> > pg_config is sometimes faulty, so i had to change the makefile to
> > PGXS := $(shell /usr/lib/postgresql/8.3/bin/pg_config --pgxs)
> >
> > notes on role 'twain' are in some sql scripts
> >
> >
> >
> > --
> > michal palenik
> > www.freemap.sk
> > http://wiki.freemap.sk
> >
> >
> >
> I had the most of these problems when I first tried Nominatim. The
> solution(s) is to get the latest osm2pgsql from svn (
> http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/) and built
> it from source. osm2pgsql is the one that creates the keyvalue type when
> importing data using  gazetteer option.
> 
> The other missing types will be created at the second run of
> gazetter-functions.sql file.
> 
> --Ciprian

-- 
michal palenik
www.freemap.sk
http://wiki.freemap.sk