Re: [Talk-es] RV: coordenadas extrañas
Hola, Santiago. El ejemplo que has enviado estaba en epsg:23030, tendrás que reproyectarlo a epsg:4326 usando rejilla o los parámetros ed50-wgs84 de España-zona centro. -- Juan Lucas De: Iván Sánchez OrtegaEnviado: miércoles, 20 de abril de 2016 15:44 Para: Discusión en Español de OpenStreetMap; Santiago Crespo Asunto: Re: [Talk-es] coordenadas extrañas El Miércoles 20. abril 2016 15.12.02 Santiago Crespo escribió: > Algunos de los conjuntos de datos del Ayuntamiento de Madrid vienen con > unas coordenadas extrañas, por ejemplo: > > X=439825.332 Y=4475789.111 > > ¿Qué sistema de coordenadas es? ¿Es posible hacer la conversión para > usarlos en OSM? UTM, zona 30 norte. Dependiendo de si usan el geoide antiguo (ED50) o el "moderno" (WGS84), tiene los códigos de sistema de coordenadas EPSG:32030 ó EPSG:32630. Lo que necesitas es reproyectar esos datos a latitud-longitud en WGS84 - en otras palabras, EPSG:4326. Cualquier herramienta que te soporte proj4 puede cargar datos en otras proyecciones. Para estos menesteres suelo utilizar ogr2ogr[1], aunque es posible usar qgis o gvsig o (el FSM no lo quiera) arcgis o muchas otras herramientas. [1] http://www.gdal.org/ogr2ogr.html -- Iván Sánchez Ortega ___ Talk-es mailing list Talk-es@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-es ___ Talk-es mailing list Talk-es@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-es
[OSM-talk] issues in Majorca, z = 9
FYI. Issues in Spain's Mediterranean areas @ level 9: http://www.openstreetmap.org/#map=9/39.2259/2.3209 RegardsJuan Lucas ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Question about Osmosis, Geofabrik and HTTP 504 Error
Dear list, I am getting the HTTP 504 error message *sometimes* when trying to get a state.txt file from Geofabrik with osmosis, but it happens sometimes and with some files. For example, the state.txt file for the Berlin updates fails to download and the state.txt file for the Bretagne updates works ok, and after a few minutes, the opposite situation happens. Could this be because the server is denying files by using some kind of file-oriented policy? Regards, Juan___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Question about Osmosis, Geofabrik and HTTP 504 Error
Hello, Thanks for the explanation. I have set up the cron so that it gets the *.osc.gz files from Geofabrik every night. I thought it would be a good idea to run osmosis three times, so in case the first does not work, the second perhaps will, and if one of them works, then the rest will do nothing because I am checking the lag every time. After your reply, I think I will try it only once every night, and if one night it does not work, it's not so important because the following night it will probably work. Any comments? Regards, Juan On Wednesday, May 21, 2014 5:46 PM, Frederik Ramm frede...@remote.org wrote: Hi, On 05/21/2014 04:36 PM, Juan Lucas Domínguez Rubio wrote: I am getting the HTTP 504 error message *sometimes* when trying to get a state.txt file from Geofabrik with osmosis, but it happens sometimes and with some files. For example, the state.txt file for the Berlin updates fails to download and the state.txt file for the Bretagne updates works ok, and after a few minutes, the opposite situation happens. Could this be because the server is denying files by using some kind of file-oriented policy? The Geofabrik download server applies rate limiting. If you try to download too many files in a short time - for example, if you were to run Osmosis in a loop where you'd check for a new state.txt every minute even though they only are renewed once a day - then the server will block access for your IP and issue 503 Service Unavailable errors (but not 504). Because of the throttling nature of this block, you might land in a situation where you can request one file every five minutes successfully, but then you get 503 again. Don't request so many files, and the problem will go away. If you check for 10 state.txt files every hour you won't have a problem but if you do that every five minutes then you might. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Osmosis bug with --write-pgsql task?
Dear list, I think I have run into this issue myself: https://www.mail-archive.com/dev@openstreetmap.org/msg18345.html I was doing an initial import into a brand-new database. It was not the whole planet. It was a pbf file containing an area representing about 3% of the data. Anybody knows anything about this? Regards, Juan ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Osmosis bug with --write-pgsql task?
More details: Error message is: = Caused by: org.postgresql.util.PSQLException: ERROR: Unable to create unique index «pk_users» Detail: Key (id)=(499804) is duplicated. = But if I execute select * from users where id = 499804, I get one row: id;name 499804;rtafav Regards, Juan == Dear list, I think I have run into this issue myself: https://www.mail-archive.com/dev@openstreetmap.org/msg18345.htmlI was doing an initial import into a brand-new database. It was not the whole planet. It was a pbf file containing an area representing about 3% of the data. Anybody knows anything about this? Regards, Juan ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Command-line program to remove untagged, unconnected nodes from .osm file
Dear list, I am trying to find a way to get rid of untagged, unconnected nodes in a .osm file. I know JOSM can do this but I need a command-line application. I've been trying to do it with osmosis and osmfilter without success (pattern *=* not allowed). Any ideas? Regards, Juan___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Command-line program to remove untagged, unconnected nodes from .osm file
Thanks. I'm starting to think that the task is too ambitious especially if the .osm file is a large one. Regards, Juan On Wednesday, May 14, 2014 11:30 AM, Peter Wendorff wendo...@uni-paderborn.de wrote: Unfortuately you're wrong here, as it does not keep untagged, but connected nodes. regards Peter Am 14.05.2014 11:16, schrieb Dominik George: Hi, I am trying to find a way to get rid of untagged, unconnected nodes in a .osm file. I know JOSM can do this but I need a command-line application. I've been trying to do it with osmosis and osmfilter without success (pattern *=* not allowed). Any ideas? If your data file is well-formed, a simple grep will do: grep -v node .*/ Cheers, Nik ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk___ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Worst of OSM
Hello. Those little place-names are estates, not towns: http://worstofosm.tumblr.com/post/22245375879/one-has-heard-the-news-about-the-eu-economy-but Regards,Juan Lucas --- On Tue, 5/15/12, Martin Koppenhoefer dieterdre...@gmail.com wrote: From: Martin Koppenhoefer dieterdre...@gmail.com Subject: [OSM-talk] Worst of OSM To: osm talk@openstreetmap.org Date: Tuesday, May 15, 2012, 12:33 PM I couldn't find a contact possibilty on the page, that's why I try it here. Worst of OSM is a nice idea IMHO: http://worstofosm.tumblr.com/ What I really miss though is a possibility to comment / discuss the examples. This could help to explain the context of the screenshot as well as discuss some examples which might be disputed. cheers, Martin ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Spain needs OSM love
Hello, whoots can only be used with WMS servers which support EPSG:900913 (spherical mercator) I think? The PNOA server does not support it Here is a full request: http://www.idee.es/wms/PNOA/PNOA?REQUEST=GetMapSERVICE=WMSVERSION=1.1.1LAYERS=pnoaSRS=EPSG:4326BBOX=-2.9364084238270007,43.262077032184024,-2.9334676982225805,43.26391313849734WIDTH=797HEIGHT=498FORMAT=image/jpegSTYLES=defaultTRANSPARENT=TRUE regards, Juan Lucas --- On Thu, 2/24/11, Jens Frank jens.l.fr...@googlemail.com wrote: From: Jens Frank jens.l.fr...@googlemail.com Subject: Re: [OSM-talk] Spain needs OSM love To: Ed Loach e...@loach.me.uk Cc: talk@openstreetmap.org Date: Thursday, February 24, 2011, 10:45 PM Hi, 2011/2/24 Ed Loach e...@loach.me.uk I'm pretty sure P2 doesn't do WMS. The wiki suggests using Whoots for WMS under custom installs: http://wiki.openstreetmap.org/wiki/Potlatch_2/Deploying_Potlatch_2#C ustomising_Potlatch_2 I've tried http://whoots.mapwarper.net:80/tms/$z/$x/$y/pnoa/http://www.idee.es/wms/pnoa/pnoa or http://whoots.mapwarper.net:80/tms/$z/$x/$y/pnoa/http://www.idee.es/wms/pnoa but both didn't work :-( Does anyone have a working URL for this service? Regards, jens -Inline Attachment Follows- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Zero tolerance on imports
--- On Sun, 2/20/11, Steve Bennett stevag...@gmail.com wrote: From: Steve Bennett stevag...@gmail.com Subject: Re: [OSM-talk] Zero tolerance on imports To: Richard Fairhurst rich...@systemed.net Cc: talk@openstreetmap.org Date: Sunday, February 20, 2011, 2:08 PM On Sun, Feb 20, 2011 at 11:03 AM, Richard Fairhurst rich...@systemed.net wrote: This is killing OSM. We are not here to provide a free API to government Sounds like OSM has reached the point Wikipedia many years ago, where the limits of open slather editing become apparent. Suggestions: 1) Lock down the upload capability, requiring approval for big uploads 2) Make rollbacks easier 3) Improve detection of big changes And, sure, continue to attempt to educate the community. But with a wide open API, that's only going to be so effective. Steve ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk hello,zero tolerance on X implies X is bad, which sounds ridiculous after all the huge imports already done. This thread totally backfired... also, how do you distinguish an 'import' from a long JOSM tracing session? I think the concept 'import' is artificial and useless. We don't have imports, we have big and small contributions. All data -surveyed by the person who uploads them or not- have errors and need maintenance. The important things are: respect the license terms, do not destroy data, do not upload irrelevant data, use tags reasonably. Regards, Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] (magical?) road detector
Hello, a couple quick ideas you might have already considered: - Optional parameters in the API to provide additional information for the algorithm, for example: ...roadcolorsample=RGB_values(the user has previously sampled the road color by clicking several times the roads of that area) ...areatype={urban,suburban,rural,...} ...shadowsheading=heading...shadowslength={short,medium,long}(some aerial images have very visible shadows, all in the same direction of course) - I don't know how your algorithm works, but if it generates several solutions, you might return an array of linestrings instead of just one. Sophisticated clients will show them all, simple clients will use the first. regardsJuan Lucas --- On Fri, 2/4/11, Ido Omer ido.o...@microsoft.com wrote: From: Ido Omer ido.o...@microsoft.com Subject: [OSM-talk] (magical?) road detector To: talk@openstreetmap.org talk@openstreetmap.org Date: Friday, February 4, 2011, 7:59 PM Hi Guys, I am a researcher at Microsoft and I am currently working on the road detector. I joined a bit late and can’t post answers in the existing road detector thread, but I might be able to provide some additional info regarding the road detector. It is *FAR* from being perfect, but in our experiments it may produce a lot of value (== save time) if you use it correctly. When use it correctly means don’t expect too much, so here are some practical tips: 1. It is currently uses the two end points as example and tries to find a path that is similar to those examples, so it is recommended to use the tool at a zoom level that will let you make sure you click on a road and not near a road (we will probably loosen that restriction in the future). 2. Don’t try to challenge the detector too much, it will probably fail, instead if you have a very complicated winding road break it into a few sections and let it detect shorter legs (it will still save you most of the clicks…) 3. One of the main features used is color, so if the road changes its color a lot, break it again into shorter legs. 4. We currently only compute one path (road) between the points and cannot provide a meaningful score for that path. Defining a score is a difficult problem (but we are open to ideas…). 5. To speed things up, we are using a bounding box that is in many cases smaller than the bounding box provided by the client (we take constant margins around the bounding box defined by the two end points). This means that if you click on the two end points of a U shaped road we might truncate the lower part of the U and find a “shortcut “ through buildings, fields, etc. And again you’ll need to break the query into shorter legs… (I am currently working on speeding things up and I hope to get rid of this limitation in a week) 6. The algorithm is currently ignoring junctions, but I should be able to add them very soon (early next week) That is for road detection. The other mode we will provide is road exploration which will enable finding all the roads in a certain bounding box (well, you’ll probably need to click once or twice…) I am not sure if there is an exposed version of this service (I hope not, since so far it is really a bunch of experiments…) but we should have it really soon (a week or two). For the road exploration we will probably have some kind of certainty level for each road segment. I will be very happy to hear of any complaints/requests/places where you think the detector should work but it fails/any other feedback. Thanks, Ido -Inline Attachment Follows- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] (magical?) road detector
Hi Ido,thanks for putting the ? after magical, I had problems to take this thread seriously until now.And welcome! RegardsJuan Lucas --- On Fri, 2/4/11, Ido Omer ido.o...@microsoft.com wrote: From: Ido Omer ido.o...@microsoft.com Subject: [OSM-talk] (magical?) road detector To: talk@openstreetmap.org talk@openstreetmap.org Date: Friday, February 4, 2011, 7:59 PM Hi Guys, I am a researcher at Microsoft and I am currently working on the road detector. I joined a bit late and can’t post answers in the existing road detector thread, but I might be able to provide some additional info regarding the road detector. It is *FAR* from being perfect, but in our experiments it may produce a lot of value (== save time) if you use it correctly. When use it correctly means don’t expect too much, so here are some practical tips: 1. It is currently uses the two end points as example and tries to find a path that is similar to those examples, so it is recommended to use the tool at a zoom level that will let you make sure you click on a road and not near a road (we will probably loosen that restriction in the future). 2. Don’t try to challenge the detector too much, it will probably fail, instead if you have a very complicated winding road break it into a few sections and let it detect shorter legs (it will still save you most of the clicks…) 3. One of the main features used is color, so if the road changes its color a lot, break it again into shorter legs. 4. We currently only compute one path (road) between the points and cannot provide a meaningful score for that path. Defining a score is a difficult problem (but we are open to ideas…). 5. To speed things up, we are using a bounding box that is in many cases smaller than the bounding box provided by the client (we take constant margins around the bounding box defined by the two end points). This means that if you click on the two end points of a U shaped road we might truncate the lower part of the U and find a “shortcut “ through buildings, fields, etc. And again you’ll need to break the query into shorter legs… (I am currently working on speeding things up and I hope to get rid of this limitation in a week) 6. The algorithm is currently ignoring junctions, but I should be able to add them very soon (early next week) That is for road detection. The other mode we will provide is road exploration which will enable finding all the roads in a certain bounding box (well, you’ll probably need to click once or twice…) I am not sure if there is an exposed version of this service (I hope not, since so far it is really a bunch of experiments…) but we should have it really soon (a week or two). For the road exploration we will probably have some kind of certainty level for each road segment. I will be very happy to hear of any complaints/requests/places where you think the detector should work but it fails/any other feedback. Thanks, Ido -Inline Attachment Follows- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] help from people with first-hand knowledge
dear list, is there a website similar to this: http://toolserver.org/~flacus/OSM/checkcrossing/spain/C03-spain-20110128.htm where people with first-hand knowledge can provide names for streets and buildings without using an editor? for example, with a textbox and a submit button which updates some table or sends an email to a list or user who actually uses an editor. regards juan lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] help from people with first-hand knowledge
thanks, osmbugs.org is exactly what I was looking for. regards --- On Wed, 2/2/11, Matthias Meißer dig...@arcor.de wrote: From: Matthias Meißer dig...@arcor.de Subject: Re: [OSM-talk] help from people with first-hand knowledge To: talk@openstreetmap.org Date: Wednesday, February 2, 2011, 4:47 PM Hi there Juan, well you can simply use www.walking-papers.org to add informations by penpaper. Another way would be to use www.osmbugs.org to add markers with hints online. There are a few other services that offer direct tagging for dedicated feature sets (www.wheelmap.org, www.karbukoo.com,...) You might have a look here: http://wiki.openstreetmap.org/wiki/List_of_OSM_based_Services regards Matthias ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] OSM-in-a-box doubts...
Dear list, I am trying to use Osm-in-a-box to keep a synchronized Postgis DB. I am doing a little test with the data of Iceland which should be about 0.06 % of the whole OSM database (size of iceland.osm.bz2 is about 8 MB) and it seems to be very slow (took 2 hours) The command was: sudo ./osm2gis.sh --initial-import -h localhost -d osmiceland -u postgres -p postgres -f /mnt/data/iceland_25_01_2011.osm.bz2 With a simple rule of three, we should expect that the whole planet would need 2 * 1600 = 3200 hours (about 4 months) to be imported. Any general thoughts about Osm-in-a-box? Anybody is keeping a synchronized DB by using OSM-in-a-box? Is there a better mailing list than this to get help about this? Regards Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Image Of The Week proposal
Hello, nice map! And the girl in the left margin is a master stroke! Regards --- On Wed, 7/28/10, Floris Looijesteijn o...@floris.nu wrote: From: Floris Looijesteijn o...@floris.nu Subject: Re: [OSM-talk] Image Of The Week proposal To: Talk Openstreetmap talk@openstreetmap.org Date: Wednesday, July 28, 2010, 1:15 PM Nice map, great exposure! Bu to be the first: Where's the Openstreetmap attribution? Greets, Floris Valent Turkovic wrote: This is my first proposal for Image Of The Week so please tell me if this proposal is correct: http://wiki.openstreetmap.org/wiki/Featured_image_proposals#Sinj_town_OSM_map Thank you in advance, Valent. -- pratite me na twitteru - www.twitter.com/valentt blog: http://kernelreloaded.blog385.com linux, anime, spirituality, windsurf, wireless, ronjenje, pametne kuće, zwave registered as user #367004 with the Linux Counter, http://counter.li.org. ICQ: 2125241, Skype: valent.turkovic, MSN: valent.turko...@hotmail.com ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Image Of The Week proposal
--- On Wed, 7/28/10, Adam Killian vi...@bonius.com wrote: From: Adam Killian vi...@bonius.com Subject: Re: [OSM-talk] Image Of The Week proposal To: Floris Looijesteijn o...@floris.nu Cc: talk@openstreetmap.org Date: Wednesday, July 28, 2010, 4:29 PM On Wed, 2010-07-28 at 15:57 +0200, Floris Looijesteijn wrote: But the girl is worth image of the week anyhow... Could we please not talk about the girl anymore? This is the kind of behavior that can drive women away from open source projects and geekery in general. I would prefer we not have a situation like the infamous CouchDB fiasco[1] in OSM. [1] - http://geekfeminism.wikia.com/wiki/CouchDB_talk LOL, girls are far less stupid than you think. Regarding the map of Sinj: what do you mean by All data was collected by Jhabjan? In the history of that bounding box I can see lots of contributions from different users... Regards Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] 10 Greatest Maps that changed the world
--- On Wed, 7/28/10, si...@mungewell.org si...@mungewell.org wrote: From: si...@mungewell.org si...@mungewell.org Subject: [OSM-talk] 10 Greatest Maps that changed the world To: talk talk@openstreetmap.org Date: Wednesday, July 28, 2010, 8:24 PM As we're all map geeks here: http://www.dailymail.co.uk/home/moslive/article-1272921/Ten-greatest-maps-changed-world.html Simon. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk All those were derived from the Catalan Atlas (Abraham Cresques, Majorca, 1375) http://www.henry-davis.com/MAPS/LMimages/235C.jpg ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] OSM-to-PostGIS issues
Yes, sorry, here is the command and error message: http://www.prodevelop.es/files/fm/public/downloads/wxp_console.png Regards, Juan Lucas --- On Mon, 7/19/10, Graham Jones grahamjones...@googlemail.com wrote: From: Graham Jones grahamjones...@googlemail.com Subject: Re: [OSM-talk] OSM-to-PostGIS issues To: Juan Lucas Domínguez Rubio juan_lucas...@yahoo.com Date: Monday, July 19, 2010, 12:42 PM Juan Lucas,I think you attached the wrong link - you have not attached the error message? I have not used osm2pgsql on windows, but on my linux machine I have seen errors if I have not used 'slim' mode (-s parameter). Graham. On 19 July 2010 11:33, Juan Lucas Domínguez Rubio juan_lucas...@yahoo.com wrote: Hello, list: I've tried to export a 9.5 GB (150 GB uncomp.) planet to a PostGIS DB @ localhost on a Windows XP machine (1.5 GB RAM). I have tuned the DB parameters like this: shared_buffers = 256MB checkpoint_segments = 20 maintenance_work_mem = 256MB autovacuum = off postgresql.conf file here: http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt but I still get the same error message I got in the previous attempt (with no DB tuning). See command parameters and error message here: http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt. Any ideas why this happens? Not enough RAM? osm2pgsql is not Windows-friendly? DB tuning needs double-checking? Anybody has done this on WXP? Regards, Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk -- Dr. Graham Jones Hartlepool, UK email: grahamjones...@gmail.com ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] OSM-to-PostGIS issues
Hello, Are you taking into account Windows XP's virtual memory (4 GB, I think)? I meant 1.5 GB of physical memory. Regards Juan Lucas --- On Mon, 7/19/10, Brian Quinion openstreet...@brian.quinion.co.uk wrote: From: Brian Quinion openstreet...@brian.quinion.co.uk Subject: Re: [OSM-talk] OSM-to-PostGIS issues To: Juan Lucas Domínguez Rubio juan_lucas...@yahoo.com Cc: Graham Jones grahamjones...@googlemail.com, talk@openstreetmap.org Date: Monday, July 19, 2010, 4:47 PM On Mon, Jul 19, 2010 at 12:12 PM, Juan Lucas Domínguez Rubio juan_lucas...@yahoo.com wrote: Yes, sorry, here is the command and error message: http://www.prodevelop.es/files/fm/public/downloads/wxp_console.png Slim uses 800MB of ram as a cache by default (change with -C) Postgresql is configured to use 256MB of shared ram plus 256MB of working memory. That gives you a peak usage of at least 1312MB on a 1536MB machine during index creation (it will actually be a little higher) leaving about 200MB for the entire rest of windows. -- Brian ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] OSM planet, osm2pgsql issue
Hello. list: I'm trying to export the OSM planet to a Postgres DB in my LAN, but I get the error message seen in the attached screenshot (osm2pgsql_error.png) Context is: - osm2pgsql running on Windows XP, 3GB RAM - Postgres DB in another machine in the local network - Tablespace on a disk with 80 GB of space - Took 5 days, then showed error message when process was finishing - Used the -s parameter to avoid memory issues, but error message says 'out of memory' Any ideas? Regards, Juan Lucas attachment: osm2pgsql_error.png___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] OSM Postgres table sizes (was: Failed to download 9.5 GB planet)
Hello, thanks. Solved. I think the problem was that I was downloading the file to a remote disk (R: mapped to \\lanserver\data) Another question: after exporting the whole planet (recently) to Postgres, what is the size of the largest table created (which I presume will take up 80% of the whole DB)? You can get the table size with: SELECT pg_size_pretty(pg_total_relation_size('big_table')); Regards, Juan Lucas --- On Tue, 6/22/10, Grant Slater openstreet...@firefishy.com wrote: From: Grant Slater openstreet...@firefishy.com Subject: Re: [OSM-talk] Failed to download 9.5 GB planet To: Dirk-Lüder Kreie osm-l...@deelkar.net Cc: talk@openstreetmap.org Date: Tuesday, June 22, 2010, 11:29 AM 2010/6/22 Dirk-Lüder Kreie osm-l...@deelkar.net: Am 21.06.2010 18:12, schrieb Juan Lucas Domínguez Rubio: 16:23:53 (1.02 MB/s) - Connection closed at byte 1621101924. Retrying. --16:23:53-- http://ftp.heanet.ie/mirrors/openstreetmap.org/planet-100618.osm.bz2 (try: 2) = `planet_100618.osm.bz2' Connecting to ftp.heanet.ie|193.1.193.64|:80... connected. HTTP request sent, awaiting response... 500 ( Arithmetic result exceeded 32 bits. ) 16:23:53 ERROR 500: ( Arithmetic result exceeded 32 bits. ). Try a different mirror, or try it via ftp. (if that's possible) Can anyone confirm if there is a problem with the heanet mirror? Juan: you could try FTP or rsync too. ftp://ftp.heanet.ie/mirrors/openstreetmap.org/planet-100618.osm.bz2 or rsync://ftp.heanet.ie/mirrors/openstreetmap.org/planet-100618.osm.bz2 Regards Grant ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] OSM Postgres table sizes (was: Failed to download 9.5 GB planet)
From: Richard Weait rich...@weait.com Subject: Re: [OSM-talk] OSM Postgres table sizes (was: Failed to download 9.5 GB planet) To: talk@openstreetmap.org Date: Thursday, June 24, 2010, 4:28 PM On Thu, Jun 24, 2010 at 4:34 AM, Juan Lucas Domínguez Rubio juan_lucas...@yahoo.com wrote: Hello, thanks. Solved. I think the problem was that I was downloading the file to a remote disk (R: mapped to \\lanserver\data) Another question: after exporting the whole planet (recently) to Postgres, what is the size of the largest table created (which I presume will take up 80% of the whole DB)? based on my planet and minutely mapnik: 8 GB polygon 21 GB line 2 GB point 43 GB nodes 3 GB roads 50 GB ways 4 GB rels overall disk use ~ 130 GB and growing about 2.5 GB/week at the moment. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk Hello, thanks. That's much more than what I expected. With a small example, I obtained a 1:3 ratio between the .osm format and the table size, so I estimated ~50 GB for the whole DB. Regards, Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Failed to download 9.5 GB planet
Dear list: I'm trying to download one of the latest planets and I repeatedly get this error message, always after ~1.5 GB, with wget and also using Mozilla Firefox. Any idea why this happens and how to solve it? ... 1583000K .. .. .. 15%1.36 MB/s 1583050K .. .. .. 15%1.16 MB/s 1583100K ... 15%2.90 MB/s 16:23:53 (1.02 MB/s) - Connection closed at byte 1621101924. Retrying. --16:23:53-- http://ftp.heanet.ie/mirrors/openstreetmap.org/planet-100618.osm.bz2 (try: 2) = `planet_100618.osm.bz2' Connecting to ftp.heanet.ie|193.1.193.64|:80... connected. HTTP request sent, awaiting response... 500 ( Arithmetic result exceeded 32 bits. ) 16:23:53 ERROR 500: ( Arithmetic result exceeded 32 bits. ). Regards Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] OSM XAPI doubt
Dear list, Anybody knows why the first query works and the second doesn't? wget http://www.informationfreeway.org/api/0.6/node[bbox=-82.90108,21.82252,-82.88907,21.82971] --output-document=a.txt wget http://www.informationfreeway.org/api/0.6/way[bbox=-82.90108,21.82252,-82.88907,21.82971] --output-document=b.txt Area is: http://www.openstreetmap.org/?box=yesmaxlat=21.82971maxlon=-82.88907minlat=21.82252minlon=-82.90108 Regards, Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] OSM XAPI doubt
--- On Wed, 6/2/10, Maarten Deen md...@xs4all.nl wrote: From: Maarten Deen md...@xs4all.nl Subject: Re: [OSM-talk] OSM XAPI doubt To: talk@openstreetmap.org Date: Wednesday, June 2, 2010, 9:56 AM On Wed, 2 Jun 2010 00:39:14 -0700 (PDT), Juan Lucas Domínguez Rubio juan_lucas...@yahoo.com wrote: Dear list, Anybody knows why the first query works and the second doesn't? wget http://www.informationfreeway.org/api/0.6/node[bbox=-82.90108,21.82252,-82.88907,21.82971] --output-document=a.txt wget http://www.informationfreeway.org/api/0.6/way[bbox=-82.90108,21.82252,-82.88907,21.82971] --output-document=b.txt Both work for me, although the last one takes about a half a minute whereas the first is done in less than a second. Maarten Thanks. Took 8 minutes for me this time, while ...api/0.6/*[bbox=... is also immediate (?) Regards, Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Bad Haiti maps
Hello, did you know about these issues: http://gvsigmobileonopenmoko.files.wordpress.com/2010/01/haiti_map_chaos.jpg The WMS layers are the ones from January 18 (google and geoeye). I took those screenshots on 23 Jan 2010 at 2 PM (London time). Regards, Juan Lucas ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk