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

Michael musset mickamusset at gmail.com
Fri Jan 15 15:49:05 GMT 2010


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 :'(



On Fri, Jan 15, 2010 at 4:45 PM, Ævar Arnfjörð Bjarmason
<avarab at gmail.com>wrote:

> Is your osm2pgsql definitely reading the right style file? You can
> specify a path to a style file with the -S switch (see --help).
>



-- 
Musset Michael

Embedded Systems Future Engineer
http://www.linkedin.com/in/micka
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100115/d4b599d7/attachment.html>


More information about the dev mailing list