Re: [OSM-dev] [Talk-us] SEO Damage to OSM
hi simon, Am 01.07.2017 um 08:33 schrieb Simon Poole: I've already touched on this with the sys admins and saved refs to the ones that I fixed. However it is unlikely that we will do any thing with the information as the accounts are extremely unlikely to be reused, and on the other hand, given that *we have a known US based SEO company that has created (literally) 1000s of such accounts* (but with slightly less spammy edits), and "we" haven't taken any action, why should we in this case? what's about a captcha to disable automatic registration? and a confirmation mail, which is asking a variable question too? Regards walter aka wambacher ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] size of postgresql database - without flat file
Hi Paul, found osm2pgsql.0.93.0-dev in git (must be quite new) and start using it. Regards waltrer ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] size of postgresql database - without flat file
Hi, i'm just installing my brand new server to get my applications (missing boundaries and many more) running again. The server has 2x 960GB SSD and 1x 2TB SATA disk installed. I'm doing a full planet import using osm2pgsql 0.92. This time i'm doing the import without flat file, because i would like to use the nodes in planet_osm_nodes for some new queries. But: planet_osm_nodes got an actual size of 785 GB, which is much much more than i exspected. Is that the usual size or may be, i'm doing something wrong? my import batch: - # no more Flat File # + extra_attributes set -x cd /osm/db/$1/create OSM2PGSQL=/usr/local/bin/osm2pgsql $OSM2PGSQL --verbose \ --create \ --slim \ --exclude-invalid-polygon \ --style /osm/db/wno_2017.style \ --port 5432 \ --database $1 \ --latlon \ --username postgres \ --hstore-all \ --hstore-add-index \ --tablespace-main-data $1_ttmp \ --tablespace-main-index $1_is1 \ --tablespace-slim-data $1_ttmp \ --tablespace-slim-index $1_is2 \ -C 25000 \ --cache-strategy optimized \ --extra-attributes \ --number-processes 12 \ --keep-coastlines \ --multi-geometry \ import/$2 -- called: do_import planet3 planet-latest.osm.bz2 any hints? Regards walter ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Incoming osm2pgsql change without migrations
Hi Paul, in other words: because i'm using the diff-process i have to reload the full planet once, right? When will this osm2pgsql be availiabe? I'm asking because my osm database server has broken some days ago and starting end of next week i must reload the full planet to get an actual live database. Of course this should be done by the newest version. Regards walter ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Tileserver User-agent
I think, i found it: https://itunes.apple.com/jp/app/geographica-map-caching-offline/id887734855?l=en=8 as being a "Map Caching Offline GPS app", i would suggest, to block it asap. origin: japan ? regards Walter Am 24.09.2016 um 21:56 schrieb yvecai: Hi there, Out of curiosity, does anybody know this user-agent: "geographica/1.1.35.0". Must be some kind of software using map tiles, but googling such a common name is not the best way to contact them. Yves ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Tile usage without proper identification
Hi, Matthiijs, | (2) providing geospatial data for anybody to use and share Data does not mean tiles. Companies may/should/have to dowload *osm raw data* (e.g. the planet file), to feed their local tile generation chain. regards walter ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [osmosis-dev] Optimizing filtering of administative boundaries with Osmosis
Hi Steijn, that's ok for me. The road from OSM, which is not 100% OGC compatible, to the GIS-world is a hard but interesting way ;) Regards walter Am 06.02.2016 um 18:14 schrieb Steijn van den Toorn: Hi Walter, thank you for your reply. I had that option in mind, but I also wanted to get a better understanding of Osmosis as I need to do a presentation on how to work with OSM and QGIS for my fellow students. :) Regards, Steijn van den Toorn. 2016-02-06 13:10 GMT+01:00 Walter Nordmann <wnordm...@gmx.de <mailto:wnordm...@gmx.de>>: goto https://osm.wno-edv-service.de/boundaries and download what you need. usage: https://osm.wno-edv-service.de/index.php/projekte/internationale-administrative-grenzen/boundaries-map sorry, german only but that will change soon. Regards walter ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org <mailto:osmosis-dev@openstreetmap.org> https://lists.openstreetmap.org/listinfo/osmosis-dev ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Optimizing filtering of administative boundaries with Osmosis
goto https://osm.wno-edv-service.de/boundaries and download what you need. usage: https://osm.wno-edv-service.de/index.php/projekte/internationale-administrative-grenzen/boundaries-map sorry, german only but that will change soon. Regards walter ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/osmosis-dev
[OSM-dev] replication broken
Hi, the replication process on planet.openstreetmap.org is broken. https://planet.openstreetmap.org/replication/minute/001/479/ the last diff is empty. Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/replication-broken-tp5849967.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] *** GMX Spamverdacht *** Re: get node data from flatfile
Thanks, Bernhard i'll check it. Walter ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] *** GMX Spamverdacht *** Re: get node data from flatfile
But there is no existing plugin for flatfiles, right? walter ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] get node data from flatfile
On 07.05.2015 21:00, Paul Norman wrote:. If you're speaking of the OSM PBF format, the osm2pgsql schema is ill-suited for this, as it doesn't have all the metadata needed. That's right, i'll generate those missing attributes like version, timestamp, ... with dummy data, because we don't need them anyway. And it has not to be a pbf-file, simple .osm will do the job too. As Frederik mentioned, there's a bug. Make sure you're using 0.87.3 or later, not 0.87.3-dev. Yes, that is a very important info. I'm using 0.85 :( At the end i would like to write my own pg/plsql-Function get_node(osm_id) which gives me the geometry of that node (reading the flatfile of course). The right way to do this is probably to implement a foreign data wrapper (FDW) as a PostgreSQL extension reading the flat-nodes file. This would let it appear as a table and you could then JOIN to it and interact with it as you normally would. Great idea! I used FDW for another small project so it should not be too complex for me. Regards walter ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] get node data from flatfile
Hi, at the moment i'm using osm2pgsql with slim-mode + flatfile for my imports and diff-updates and everything is running fine. But now i need to create pbf-exports of my database and i would like to access the node-data of the flatfile, because planet_osm_nodes is empty (whicht is ok). Is there any way to access those nodes by osm_id? I tried to write a litte program starting with node-persistent-cache-reader.c but i did not manage it. Many nodes are missing. At the end i would like to write my own pg/plsql-Function get_node(osm_id) which gives me the geometry of that node (reading the flatfile of course). Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/get-node-data-from-flatfile-tp5843642.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] vacuum running amok - and me too ;)
Problem identified and fixed: It's a bug in Postgres 9.4 or 9.4.1. see http://www.postgresql.org/message-id/5501b10e.8020...@iki.fi will be rolled out with the next planned fix-version. Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/vacuum-running-amok-and-me-too-tp5836373p5836924.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] vacuum running amok - and me too ;)
opened a bug report: http://www.postgresql.org/message-id/20150311163510.4035.18...@wrigleys.postgresql.org current vacuum is using 86 GB of ram. walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/vacuum-running-amok-and-me-too-tp5836373p5836753.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] vacuum running amok - and me too ;)
Hi, tried to get help on the postgresql-general forum but they didn't help me yet. (http://postgresql.nabble.com/autovacuum-worker-running-amok-and-me-too-td5840299.html) *Vacuum planet_osm_ways* is using very, very much memory vacuuming the GIN-Index planet_osm_ways_nodes. Running on a 24GB-System with now 50GB Swap i had to kill the Vacuum after using about 68 GB Virt memory ( 80% total) because of thrashing. the postgresql-config-params are very conservative, because i reduced them to minimize mem usage: http://gis.19327.n5.nabble.com/file/n5836373/pidstat.png A graph on memory usage during vaccuuming until i had to reboot my system. left scale virt mem in MB. Any hints? Feeling helpless. Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/vacuum-running-amok-and-me-too-tp5836373.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [osmosis-dev] Supplying postgres port to osmosis commands
just call osmosis with host=localhost:15432 regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-dev-Supplying-postgres-port-to-osmosis-commands-tp5820003p5820010.html Sent from the Osmosis Development mailing list archive at Nabble.com. ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/osmosis-dev
Re: [osmosis-dev] Streaming Replication
Hi Brett, is Streaming replication running or is it dead? The first (and last) state i get is that: and when i do an osmosis --receive-replication host=planet.openstreetmap.org port=80 pathPrefix=replication/streaming --replication-to-change --write-xml-change - i get any hints? Regards walter * sent this mail a second time because of some techical problems with nabble. - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-dev-Streaming-Replication-tp5730318p5785642.html Sent from the Osmosis Development mailing list archive at Nabble.com. ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/osmosis-dev
[OSM-dev] osm2pgsql: access flatfile from postgresql via foreign data wrapper
hi, after using osm2pgsql with --flat-nodes everything is running fine during import and update via diffs. Now i would like to access the raw node-data, which is in the external flatfile, from postgresql using a foreign data wrapper http://www.postgresql.org/docs/9.1/static/ddl-foreign-data.html. I have to export some data from the database as an osm-file to send it to *osmcoastline*. so i need access to the non tagges nodes which should be in planet_osm_nodes but now are - on my own wish - in the flatfile. i can try to write a program, but: *has anybody done that before*? regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-access-flatfile-from-postgresql-via-foreign-data-wrapper-tp5784817.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql: access flatfile from postgresql via foreign data wrapper
Jochen123 wrote
...
This is probably slightly easier to do than the postgresql fdw, but, of
course, not as general.
It's no problem for me to do it with postgresql. I'v done that before whilst
working with the osmosis/snapshot-schema. i could dump osm-objects (nodes,
ways and relations) directly from my database using some simple
pl/pgsql-functions.
something like /select wno_asosm('R',111);/ dumped the relation with all
ways and all nodes to an osm-file. Even relations as members. But now i'm
missing the nodes :(
First step: try to read the flatfile with /persistent_cache_nodes_get/ from
osm2pgsql and fetch some nodes.
next: convert flatfile to csv and use postgresql /file_fdw/ as a simple
data wrapper
last step: write own wrapper? may be i don't have to.
regards
walter
-
[url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map
1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url]
--
View this message in context:
http://gis.19327.n5.nabble.com/osm2pgsql-access-flatfile-from-postgresql-via-foreign-data-wrapper-tp5784817p5784824.html
Sent from the Developer Discussion mailing list archive at Nabble.com.
___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] osm2pgsql: create flatfile from database?
hi, is there a way/tool to create a flatfile for the persitant node cache from planet_osm_nodes? Otherwise i have to re-import the full planet to get it. Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-create-flatfile-from-database-tp5782958.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql: create flatfile from database?
Frederik Ramm wrote I don't know of any existing tool. I'd just write a quick script that does select id,lat,lon from planet_osm_nodes and outputs lines of the form node id=x lat=y lon=z / , and then feed that to osm2pgsql (called with --flat-nodes and the name of an otherwise unused, throwaway database). When you make the script, remember you need to divide lat/lon by 1E+07 or so. great idea, will do the same with a well formed select like node id=||id|| ... and writing to file. after the dummy-Import move the flat-file to the working directory, change the update-script (adding --flat-nodes ...), truncate planet_osm_lines and cross my fingers ;) Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-create-flatfile-from-database-tp5782958p5782963.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql: create flatfile from database?
great stuff. i'll try to get it working again. at the moment im' going frederiks way (dumping, dummy-import, fetch the flat-file) but that will need a long time too. regards walter current state: dumped 680Mio Nodes of about 2G, filesize 60GB. ~2 more hours to run - only step 1 - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-create-flatfile-from-database-tp5782958p5783005.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql: create flatfile from database?
got it and it's running fine 2 minor very easy changes and it's ok. disabled // static int scale = 100; and changed init_node_persistent_cache(options, 0, 0); to init_node_persistent_cache(options, 0); sorry, can't create a patch, no idea how to do it :( Regard walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-create-flatfile-from-database-tp5782958p5783011.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] iD editor damaging landuse polygons
Pieren wrote We get more and more feedbacks on the French community about landuse polygons damaged by iD editor. They can be partially orthogonalized (squared ?) or tags replaced by fancy new values, e.g. landuse=residential by building=yes.. It seems that this problem is already reported here https://github.com/systemed/iD/issues/542 since 8 months... Same Trouble in Germany: dozens of damages landuse-polygons. have a look at the german thread: http://forum.openstreetmap.org/viewtopic.php?pid=361270#p361270 Every link to osmi is/was a serious problem! Same with links to changesets! Have a look even if you don't speak german - just count and read the links to damages areas. Most of them are fixed and you can't see them in OSMI any more (erledigt means done) still open: http://tools.geofabrik.de/osmi/?view=geometrylon=4.99490lat=43.43292zoom=12opacity=0.50overlays=self_intersection_ways,self_intersection_points,duplicate_node_in_way http://tools.geofabrik.de/osmi/?view=geometrylon=5.76428lat=49.81079zoom=16opacity=0.50overlays=self_intersection_ways,self_intersection_points,duplicate_node_in_way Regards walter - [url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url] -- View this message in context: http://gis.19327.n5.nabble.com/iD-editor-damaging-landuse-polygons-tp5777499p5779032.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] hourly-diffs broken
Hi, i'm using minutely diffs. should i do something (reset state.txt to last evening) or is everything fine? and whats with the streaming client? I'm not using it yet but maybe someone else. Regards walter - [url=osm.wno-edv-service.de/residentials] Missing Residentials Map 1.13[/url] -- View this message in context: http://gis.19327.n5.nabble.com/hourly-diffs-broken-tp5769662p5769746.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Making polylines from route relations
hi richard, the biggest problem is, that some routes have forks. they split into two or more ways and sometimes join again. i have no solution to handle that stuff. regards walter -- View this message in context: http://gis.19327.n5.nabble.com/Making-polylines-from-route-relations-tp5726152p5726907.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osmosis + postgis 2.0 - usage of legacy function namens
Hi Brett postgis 2.0 is availiable - and making still some problems. ALL the old functions without st_ have gone and osmosis 0.40.1 is in little trouble. i.e. my diff-update is missing the good old Collect (and may be more). i can (and have to) install the postgis legacy.sql to get them back. But it would be better if that is not needed. http://postgis.refractions.net/docs/PostGIS_FAQ.html#legacy_faq Regards walter -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-postgis-2-0-usage-of-legacy-function-namens-tp5234278p5713863.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osmosis + postgis 2.0 - usage of legacy function namens
Igor Podolskiy wrote Hello Walter, thanks for your bug report and proposed solution. I'll take a look into it, seems simple. However, for the next time you may want to post a proper patch (i.e. the output of diff -u or git diff). Or, even better, register with Github and make a pull request. It's not that hard (it's _way_ easier than hacking Osmosis sources, for that matter :)). i know, but i had to make a decision: - take time to learn the proper way while other developers try to fix my problem - or say: i got it right now so i chosed the quickdirty way to save YOUR time. i'm not a developer (yet) so i will need some days to learn that github-stuff. but i'll try my best. I don't have any experience with PostGIS 2.0 yet and I don't have a working installation of it either. When I'm done with applying the change, would you at least be willing to test the changed code? that's ok. will do a git checkout (?) to get the actual version b.t.w. patched version is running fine (differential updates of live database) for many hours. Regards Walter aka wambacher @ Schlangenbad/Germany -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-postgis-2-0-usage-of-legacy-function-namens-tp5234278p5713959.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osmosis + postgis 2.0 - usage of legacy function namens
Igor Podolskiy wrote You can do a git checkout or just grab the sources from: https://github.com/podolsir/osmosis/tarball/postgis2-compat or even the binary version from http://dev.openstreetmap.de:23457/hudson/job/osmosis-podolsir/10/artifact/package/distrib/tgzs/osmosis-0.40.1-127-g4999008.tgz took the binary one - and it's working fine for me. Importing data of 1 Hour: but i'm only doing diff-updates of the database. nothing more. and that was using Collect Envelope. May be there is more old stuff used somewhere else in osmosis? don't know. Greetings from wambach/schlangenbad Walter -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-postgis-2-0-usage-of-legacy-function-namens-tp5234278p5713963.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osmosis + postgis 2.0 - usage of legacy function namens
Hi Brett postgis 2.0 is availiable - and making still some problems. ALL the old functions without st_ have gone and osmosis 0.40.1 is in little trouble. i.e. my diff-update is missing the good old Collect (and may be more). i can (and have to) install the postgis legacy.sql to get them back. But it would be better if that is not needed. http://postgis.refractions.net/docs/PostGIS_FAQ.html#legacy_faq Regards walter p.s. sorry for second post. having touble with nabble -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-postgis-2-0-usage-of-legacy-function-namens-tp5234278p5713868.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osmosis + postgis 2.0 - usage of legacy function namens
got it. legacy.sql didn't help. had to change the sources. Changed all calls of Collect(..) and Envelope(..) to ST_Collect and ST_Envelope in pgsimple/src/main/java/org/openstreetmap/osmosis/pgsimple/v0_6/impl/NodeDao.java pgsimple/src/main/java/org/openstreetmap/osmosis/pgsimple/v0_6/impl/IndexManager.java pgsimple/src/main/java/org/openstreetmap/osmosis/pgsimple/v0_6/impl/WayDao.java and same in pgsnapshot/src/main/java/org/openstreetmap/osmosis/pgsnapshot/v0_6/impl/NodeDao.java pgsnapshot/src/main/java/org/openstreetmap/osmosis/pgsnapshot/v0_6/impl/IndexManager.java pgsnapshot/src/main/java/org/openstreetmap/osmosis/pgsnapshot/v0_6/impl/WayDao.java ant build that works for me. Sorry, can't upload with git (no account, no expierence) Regards walter @brett: please integrate in svn, i can't do that -- View this message in context: http://gis.19327.n5.nabble.com/osmosis-postgis-2-0-usage-of-legacy-function-namens-tp5234278p5713909.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OAuth down
Tom Hughes-3 wrote On 16/11/11 17:25, Pierre Giraud wrote: I just tested JOSM by setting explicitely that I wanted to use the OAuth authentication. And I received an error when getting the access request. I think it should be fixed now. Tom hi tom, can't get oauth running on dev-server too (josm 4616) - automatic mode oauth on production-server is ok. if you like (and need) i can send the german error-messages. regards walter - Wenn du den Wald vor lauter Bäumen nicht siehst, fälle die Bäume und du wirst sehen, dass da kein Wald ist. -- View this message in context: http://gis.638310.n2.nabble.com/OAuth-down-tp6999428p7038814.html Sent from the Developer Discussion mailing list archive at Nabble.com. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [osmosis-dev] one node ways
Kirill Bestoujev wrote: Hi Brett There are two fixes. Both of them are working for more than a week on my server with no errors and no new invalid geoms in the db. regarding the array_length - I was not aware of that, as I'm using 8.4 on all my machines. I will have a look how to change that. The performance issue - no, I made no tests, I can try to test it on an other server, where I did not change osmosis to the modified version. kirill hi, any news? i've the same singe-node-way problem and would like to get rid of it. Regards Walter - 33,33% aller Statistiken beruhen auf kleinen Datenmengen. -- View this message in context: http://gis.638310.n2.nabble.com/osmosis-dev-one-node-ways-tp6253452p6394248.html Sent from the Osmosis Development mailing list archive at Nabble.com. ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
