[Loadstone] converting 3gb file

Cearbhall O'Meadhra cearbhall.omeadhra at idd.ie
Mon Jul 27 20:28:24 BST 2009


A very good suggestion. Thanks Sean.   


All the best,
 
Cearbhall
Good design enables - Bad design disables

 

T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra at idd.ie

 

-----Original Message-----
From: loadstone-bounces at loadstone-gps.com
[mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of Shawn Kirkpatrick
Sent: 24 July 2009 22:14
To: loadstone at loadstone-gps.com
Subject: Re: [Loadstone] converting 3gb file

You do realize the name field is only 75 characters long? Trying to put all
that information in the name probably isn't going to work very well. It'll
also result in a lot of output when announcing the point names. If you want
things sorted by category you might be better off putting each category in
its own database. You could also do this for each city, that way you can
load just the data you need at the time rather than the entire country.

On Fri, 24 Jul 2009, Przemys3aw Rogalski wrote:

> Hi,
> If you were able to convert the file Poland.osm from
> http://download.geofabrik.de/osm/europe/poland.osm.bz2
> (24-Jul-2009 03:36)
> , so that each output LS POI contained:
> - A category,
> - An address (without ZIP - only street plus house number),
> - City name,
> I'd be very happy.
> Thanks in advance,
> Przemyslaw
>  ----- Wiadomo6f oryginalna -----
>  Od: Cearbhall O'Meadhra
>  Do: loadstone at loadstone-gps.com
>  Wys3ano: 23 lipca 2009 20:34
>  Temat: Re: [Loadstone] converting 3gb file
>
>
>  Yes, these can be collected and put into the name field. However, You
will find that this makes the name field too long to appear in the mobile
phone.
>
>  There is no problem collecting these fields. The question is, what can
you do with them?
>
>  If you like, I will collect all of these items and you can try out your
own ideas of what to do to access them when you are using the phone. Would
that be useful?
>
>
>  All the best,
>
>  Cearbhall
>
>  Good design enables - Bad design disables
>
>
>
>  T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra at idd.ie
>
>
>
>
>
>
> ----------------------------------------------------------------------
> --------
>  From: loadstone-bounces at loadstone-gps.com 
> [mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of Przemyslaw 
> Rogalski
>  Sent: 23 July 2009 17:48
>  To: loadstone at loadstone-gps.com
>  Subject: Re: [Loadstone] converting 3gb file
>
>
>  By category I mean eg. bank Hotel, restaurant, etc.
>    ----- Wiadomo6f oryginalna -----
>    Od: Cearbhall O'Meadhra
>    Do: loadstone at loadstone-gps.com
>    Wys3ano: 22 lipca 2009 23:53
>    Temat: Re: [Loadstone] converting 3gb file
>
>
>    Thanks fro the info. I will be able to give it some time this weekend.
>
>    Yes, the details can be included in the name field but you run the risk
of being unable to display it on the mobile when there is so much detail. I
am not sure what you mean by "category" of the POI. Could you explain that?
>
>    All the best,
>
>    Cearbhall
>
>    Good design enables - Bad design disables
>
>
>
>    T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra at idd.ie
>
>
>
>
>
>
>
----------------------------------------------------------------------------
>    From: loadstone-bounces at loadstone-gps.com
[mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of Przemyslaw
Rogalski
>    Sent: 17 July 2009 11:25
>    To: loadstone at loadstone-gps.com
>    Subject: Re: [Loadstone] converting 3gb file
>
>
>    Hi,
>    The link is:
>    http://download.geofabrik.de/osm/europe/poland.osm.bz2
>    17-Jul-2009 03:50
>      However, you can easily extract it under Windows, using eg. 7zip:
>      http://heanet.dl.sourceforge.net/sourceforge/sevenzip/7z465.exe
>
>      By the way: What fields is an OSM record consisted of?
>      I mean, what other fields apart from latitude and longitude can be
converted?
>      Could a Loadstone output include - if possible - POI's category,
street name, house number and city name?
>      Thanks in advance for conversion.
>      Hope I'll be able to do it myself in the future, so as not to trouble
you so much...
>      ----- Wiadomo6f oryginalna -----
>      Od: Cearbhall O'Meadhra
>      Do: loadstone at loadstone-gps.com
>      Wys3ano: 17 lipca 2009 02:53
>      Temat: Re: [Loadstone] converting 3gb file
>
>
>      Not so easy, I am afraid.
>
>      It is a bit complicated to convert the Long and Lat so I have it
built into an Excel spread sheet. You would need it to be in a compiled
format if I were to pass it to you. I would be happy to do the conversion
for you if you send me the osm file. I would need the file to be in a
windows compatible format rather than Linux.
>
>      If necessary, you can send me the link rather than the file. Please
make sure that the link points to the file you want and downloads it to
Windows.
>
>      Looking forward to hearing from you.
>
>
>      All the best,
>
>      Cearbhall
>
>      Good design enables - Bad design disables
>
>
>
>      T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra at idd.ie
>
>
>
>
>
>
> --------------------------------------------------------------------------
>      From: loadstone-bounces at loadstone-gps.com
[mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of Przemyslaw
Rogalski
>      Sent: 17 July 2009 00:48
>      To: loadstone at loadstone-gps.com
>      Subject: Re: [Loadstone] converting 3gb file
>
>
>      Oh, that's great.
>      Could you send it, please?
>        ----- Wiadomo6f oryginalna -----
>        Od: Cearbhall O'Meadhra
>        Do: loadstone at loadstone-gps.com
>        Wys3ano: 16 lipca 2009 22:27
>        Temat: Re: [Loadstone] converting 3gb file
>
>
>        I have one! I created it!
>
>
>        All the best,
>
>        Cearbhall
>
>        Good design enables - Bad design disables
>
>
>
>        T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra at idd.ie
>
>
>
>
>
>
> ------------------------------------------------------------------------
>        From: loadstone-bounces at loadstone-gps.com
[mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of Josh
>        Sent: 16 July 2009 21:06
>        To: loadstone gps
>        Subject: [Loadstone] converting 3gb file
>
>
>        Hi,
>
>        It's representing the state of Pennsylvania in the united states.
and I did change the values in the php.ini file and it still says out of
memory.
>        too bad there isn't a .osm file splitter.
>
>        Josh
>
>        Join me on klango at www.klango.net visit and sign my petition at:
http://www.petitiononline.com/coda1234/petition.html
>        and visit my blog at: http://jkenn337.klangoblog.net follow me 
> on twitter at http://www.twitter.com/jkenn337
>
>
> ----------------------------------------------------------------------
> --
>
>
>        _______________________________________________
>        Loadstone mailing list
>        Loadstone at loadstone-gps.com
>        http://www.loadstone-gps.com/mailman/listinfo/loadstone
>
>
>
> ----------------------------------------------------------------------
> ----
>
>
>      _______________________________________________
>      Loadstone mailing list
>      Loadstone at loadstone-gps.com
>      http://www.loadstone-gps.com/mailman/listinfo/loadstone
>
>
>
> ----------------------------------------------------------------------
> ------
>
>
>    _______________________________________________
>    Loadstone mailing list
>    Loadstone at loadstone-gps.com
>    http://www.loadstone-gps.com/mailman/listinfo/loadstone
>
>
>
> ----------------------------------------------------------------------
> --------
>
>
>  _______________________________________________
>  Loadstone mailing list
>  Loadstone at loadstone-gps.com
>  http://www.loadstone-gps.com/mailman/listinfo/loadstone
>



More information about the Loadstone mailing list