[OSM-dev] osm2pgsql => default.style => add a new line to get a new column in the database postgis

[Michael musset]

lawl not bad !

i'm so tired that i miss this thing lol, thanks you very much, it's work now
-_-

On Fri, Jan 15, 2010 at 4:56 PM, Jon Burgess <jburgess777 at googlemail.com>wrote:

> 2010/1/15 Michael musset <mickamusset at gmail.com>:
> > yes i'm agree, but it is not the problem because i can see a new column,
> but
> > the problem, it's that this column is empty,
> > by example if my sql request is :
> >
> > select * from planet_osm_point where wifi is not null LIMIT 10;
> >
> > i get 0 rows ..........
> >
> > and that thing is interesting :
> >
> > gis=# select * from planet_osm_point where wifi is not null LIMIT 10;
> >  osm_id | access | addr:flats | addr:housenumber | addr:interpolation |
> > admin_level | aerialway | aeroway | amenity | area | barrier | bicycle |
> > bridge | boundary | building | capital | construction | cutting | disused
> |
> > ele | embankment | foot | highway | historic | horse | junction | landuse
> |
> > layer | learning | leisure | lock | man_made | military | motorcar | name
> |
> > natural | oneway | operator | poi | power | power_source | place |
> railway |
> > ref | religion | residence | route | service | shop | sport | tourism |
> > tunnel | waterway | width | wood | z_order | wifi | way
> >
> --------+--------+------------+------------------+--------------------+-------------+-----------+---------+---------+------+---------+---------+--------+----------+----------+---------+--------------+---------+---------+-----+------------+------+---------+----------+-------+----------+---------+-------+----------+---------+------+----------+----------+----------+------+---------+--------+----------+-----+-------+--------------+-------+---------+-----+----------+-----------+-------+---------+------+-------+---------+--------+----------+-------+------+---------+------+-----
> > (0 rows)
> >
> >
> > so from this point i don't know why the script doesn't fill correctly my
> > database :'(
> >
>
> The name of the column must match the name of the key, so in the
> example you gave earlier the name should have been 'mac', as shown in
> your style file, not wifi.
>
> --
>     Jon
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100115/5441e3c5/attachment.html>