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

Stefan Keller sfkeller at gmail.com
Tue Jul 9 14:26:55 UTC 2013


Hi Simon

2013/7/9 Simon Poole <simon at poole.ch>:
> I believe there is a bug that the timestamps don't get imported from
> .pbf files. Should work fine with xml.

We opened a ticket here https://trac.openstreetmap.org/ticket/4894

Yours, Stefan


2013/7/9 Simon Poole <simon at poole.ch>:
> 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
>
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev



More information about the dev mailing list