[OSM-dev] osm2pgsql and timestamp as data in Postgres?

Simon Poole simon at poole.ch
Tue Jul 9 11:10:50 UTC 2013


I believe there is a bug that the timestamps don't get imported from
.pbf files. Should work fine with xml.

Simon

Am 09.07.2013 12:21, schrieb Stefan Keller:
> Hi Paul
>
> 2013/7/9 Paul Norman <penorman at mac.com> wrote:
>> The -x|--extra-attributes option will include this metadata. You may want to
>> add the columns to your .style file, and you will need to if you're not
>> using hstore.
> Thanks for your reply. That's what we're already doing:
>
> osm2pgsql --create --slim --extra-attributes --database $DB_NAME \
>        --prefix osm --style /usr/local/share/osm2pgsql/terminal.style \
>        --username $DB_USER --port $DB_PORT --hstore-all --input-reader pbf \
>        "$OSRM_BIN_DIRECTORY/$(basename $CH_OSM_URL)"
>        >/dev/null
>
> Unfortunately, the hstore field contains e.g. osm_id, osm_version -
> but no timestamp!
>
> Yours, Stefan
>
> 2013/7/9 Paul Norman <penorman at mac.com>:
>>> From: Stefan Keller [mailto:sfkeller at gmail.com]
>>> Subject: [OSM-dev] osm2pgsql and timestamp as data in Postgres?
>>>
>>> Hi,
>>>
>>> Did anyone manage to configure osm2pgsql in order that it stores also
>>> the timestamp XML attribute in Postgres - either as separate field or as
>>> key/value in the hstore field? If yes, how can I do that?
>> The -x|--extra-attributes option will include this metadata. You may want to
>> add the columns to your .style file, and you will need to if you're not
>> using hstore.
>>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev





More information about the dev mailing list