[Tile-serving] [osm2pgsql] osm_changeset not importing (#271)

Alex Barth notifications at github.com
Sat Jan 31 16:14:10 UTC 2015


I'm trying to import osm_changeset and osm_version information into point, line and polygon tables.

- Expected behavior: populated `osm_changeset` column (just like `osm_version` column)
- Unexpected: `osm_changeset` column empty

## Details

My .style file contains (among others) the rules:

    node,way   osm_changeset       text  linear
    node,way   osm_version         text  linear

This is how I import data:

    curl -o $HOME/nyc.osm "http://www.overpass-api.de/api/xapi?map?bbox=-74.021416,40.697983,-73.932495,40.756263"
    osm2pgsql -c --extra-attributes --style changefeed.style -d osm --slim $HOME/nyc.osm

Here's how my resulting `planet_osm_polygon` table looks like:

    osm=> \d planet_osm_polygon
                 Table "public.planet_osm_polygon"
           Column       |           Type            | Modifiers 
    --------------------+---------------------------+-----------
     osm_id             | bigint                    | 
     addr:housenumber   | text                      | 
     addr:street        | text                      | 
     addr:full          | text                      | 
     addr:interpolation | text                      | 
     nyc:bin            | text                      | 
     building           | text                      | 
     osm_uid            | text                      | 
     osm_changeset      | text                      | 
     osm_version        | text                      | 
     way                | geometry(Geometry,900913) | 
    Indexes:
        "planet_osm_polygon_index" gist (way)
        "planet_osm_polygon_pkey" btree (osm_id)

The result is a populated version column while the changeset column is empty:

    osm=> select count(*)  from planet_osm_polygon where osm_version is not null;
     count 
    -------
     43717

    osm=> select count(*)  from planet_osm_polygon where osm_changeset is not null;
     count 
    -------
         0


---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/271
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150131/50522745/attachment.html>


More information about the Tile-serving mailing list