Re: [Talk-es] RV: coordenadas extrañas

[Juan Lucas Domínguez Rubio]

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 Ortega 
Enviado: 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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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?

[Juan Lucas Domínguez Rubio]

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?

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

--- 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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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...

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

--- 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

[Juan Lucas Domínguez Rubio]

--- 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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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)

[Juan Lucas Domínguez Rubio]

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)

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

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

[Juan Lucas Domínguez Rubio]

--- 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

[Juan Lucas Domínguez Rubio]

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