Re: [OSM-dev-fr] Partage de DEM
Le 08/07/2013 12:08, Jean-Claude Repetto a écrit : Et d'après la présentation faite par l'IGN la semaine dernière ( http://info.ign.fr/Media/IGN/2013/pros/confign/Conference-en-ligne-ign-04-07-2013.pdf, page 14 ), il semblerait que la BD-Alti 75 vienne de passer sous licence Etalab. Mais je n'ai pas encore trouvé où la télécharger sur le site de l'IGN ... Elle est probablement de meilleure qualité que le SRTM, et en plus la fusion avec les zones à grille de 5 m dont on dispose (PACA, Auvergne) sera plus facile. Voici la réponse de Camille Salou, de l'IGN : La BD ALTI® au pas de 75m est effectivement désormais sous licence ETALAB (donc libre) depuis mi-juin 2013. Toutefois, nous rencontrons actuellement quelques soucis techniques qui retardent sa mise à disposition sur nos divers canaux de diffusion (y compris sur notre site Internet « espace professionnel »). Cette donnée devrait être accessible et téléchargeable en ligne au plus tard à la rentrée 2013 (septembre). ___ dev-fr mailing list dev-fr@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev-fr
Re: [OSM-dev-fr] cadastre.openstreetmap.fr cassé - ça à l'air plus grâve que d'habitude
A noter ce message (que je viens de lire un instant trop tard) : http://lists.openstreetmap.org/pipermail/talk-fr/2013-July/060766.html et dont je ne sais s'il peut y avoir un lien ou pas -- sly (sylvain letuffe) ___ dev-fr mailing list dev-fr@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev-fr
[osmosis-dev] Improving pgsnapshot
I've been working on expanding cgimap to use pgsnapshot. In the process I've come across some changes to the schema I'd like to propose. The changes basically consist of removing the giant (237GB) way_nodes table. Would this be best to do within the existing pgsnapshot tasks and by incrementing the schema version? Should it be in new tasks based on those? Advice is welcome. Schema details: I want to add a nodes.ways bigint[] column to the nodes table and use it for node-ways lookups, then use the existing ways.nodes bigint[] column for way-nodes ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Error on a node modified and deleted in the same changeset
Hi, On 07.05.2013 23:50, Jocelyn Jaubert wrote: I'm including a patch for this, that only impacts the ChangeDeriver class. I have tested it on a country, and the generated diff was correct - the only difference with the current osmosis version is the version on deleted elements. I had not followed this thread, sorry. I didn't know the Geofabrik diffs had this problem, but of course if one thinks about it, it does seem logical - comparing two excerpts, when the newer one doesn't have an object then how am I to know who deleted it when and in what version? I could run Jocelyn's patch on the Geofabrik server but technically it would create wrong osc files - if you were to compare a Geofabrik osc with one loaded from osm.org you'd find that the Geofabrik diff reports the wrong user name, wrong timestamp, and *possibly* also wrong version on a deleted object. No idea if that problem is worse than the one we have now! Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
[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? Yours, Stefan ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?
From: Stefan Keller [mailto:sfkel...@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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?
Hi Paul 2013/7/9 Paul Norman penor...@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 penor...@mac.com: From: Stefan Keller [mailto:sfkel...@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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?
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 penor...@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 penor...@mac.com: From: Stefan Keller [mailto:sfkel...@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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?
Hi Simon 2013/7/9 Simon Poole si...@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 si...@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 penor...@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 penor...@mac.com: From: Stefan Keller [mailto:sfkel...@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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?
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 si...@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 si...@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 penor...@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 penor...@mac.com: From: Stefan Keller [mailto:sfkel...@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@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev