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

[Jon Burgess]

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