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

Simon Poole simon at poole.ch
Tue Jul 9 14:32:09 UTC 2013


If I remember correctly the relevant code is simply missing from  the
.pbf parser.

Simon

Am 09.07.2013 16:26, schrieb Stefan Keller:
> 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20130709/d2f73cac/attachment.html>


More information about the dev mailing list