<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi,</div><div><br class="webkit-block-placeholder"></div><div>I have got a basic database and was able to fill it with a map area of about 2.7 MB data.</div><div><br class="webkit-block-placeholder"></div><div>But this is very less compared to germany with about 3.5 GB. So when trying to get the database</div><div>out of germany xsltproc gets killed due to memory problems. I currently only have 1 GB :-)</div><div><br class="webkit-block-placeholder"></div><div>The processing should be tailored into smaller regions.</div><div><br class="webkit-block-placeholder"></div><div>But about the data and the search:</div><div><br class="webkit-block-placeholder"></div><div>I think I would do search that way:</div><div><br class="webkit-block-placeholder"></div><div>1.) Find the villages and its lon / lat by a SQL query by given first characters entered (minimum = 3).</div><div>2.) Find all streetnames by given first characters entered (minimum = 3).</div><div>3.) Display streets to villages sorted by distance </div><div><br class="webkit-block-placeholder"></div><div>If the data is in the database, this should be very fast. Then, when the user selects a street, it's position</div><div>could be used to center the display to.</div><div><br class="webkit-block-placeholder"></div><div>Is this practical ?</div><div><br class="webkit-block-placeholder"></div><div>Lothar</div><br><div><div>Am 17.12.2008 um 19:53 schrieb Lothar Behrens:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Yes,<div><br class="webkit-block-placeholder"></div><div>I have found it too.</div><div><br class="webkit-block-placeholder"></div><div>If someone has interest, I am currently create an XSLT template to extract the relevant data of villages / cities and streets with their lon / lat coordinates.</div><div><br class="webkit-block-placeholder"></div><div>If I have it I try to setup a database to be a possible base for searching :-)</div><div><br class="webkit-block-placeholder"></div><div>Lothar</div><div><br><div><div>Am 17.12.2008 um 17:51 schrieb Tilman Baumann:</div><br class="Apple-interchange-newline"><blockquote type="cite">Lothar Behrens wrote:<br><blockquote type="cite">Hi,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">has someone an example of searching a city and a street that works with <br></blockquote><blockquote type="cite">the germany map when it was downloaded from the quicklink<br></blockquote><blockquote type="cite">as of the page here <br></blockquote><blockquote type="cite">lists: <a href="http://wiki.navit-project.org/index.php/OpenStreetMaps">http://wiki.navit-project.org/index.php/OpenStreetMaps</a> ?<br></blockquote><br><a href="http://wiki.navit-project.org/index.php/OpenStreetMaps#Search_doesn.27t_work_in_most_countries">http://wiki.navit-project.org/index.php/OpenStreetMaps#Search_doesn.27t_work_in_most_countries</a><br>and following...<br><br>-- <br>Drucken Sie diese Mail bitte nur auf Recyclingpapier aus.<br>Please print this mail only on recycled paper.<br><br>_______________________________________________<br>Openmoko community mailing list<br><a href="mailto:community@lists.openmoko.org">community@lists.openmoko.org</a><br>http://lists.openmoko.org/mailman/listinfo/community<br><br></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "></p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">-- <span class="Apple-style-span" style="font-family: Helvetica; "><font class="Apple-style-span" face="Courier">| </font><font class="Apple-style-span" face="Courier">Rapid Prototyping <span class="Apple-style-span" style="font-family: Helvetica; "><font class="Apple-style-span" face="Courier">| </font><font class="Apple-style-span" face="Courier">XSLT Codegeneration <span class="Apple-style-span" style="font-family: Helvetica; "><font class="Apple-style-span" face="Courier">| http://</font><font class="Apple-style-span" face="Courier"><a href="http://www.lollisoft.de">www.lollisoft.de</a></font></span></font></span></font></span></font></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">Lothar Behrens</font></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">Heinrich-Scheufelen-Platz 2</font></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">73252 Lenningen</font></font></div><div><font class="Apple-style-span" face="Courier"><span class="Apple-style-span" style="white-space: pre; "><br class="webkit-block-placeholder"></span></font></div></div><div><br class="webkit-block-placeholder"></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br></div></div></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"> </div><br></div></div>_______________________________________________<br>Openmoko community mailing list<br><a href="mailto:community@lists.openmoko.org">community@lists.openmoko.org</a><br>http://lists.openmoko.org/mailman/listinfo/community<br></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "></p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">-- <span class="Apple-style-span" style="font-family: Helvetica; "><font class="Apple-style-span" face="Courier">| </font><font class="Apple-style-span" face="Courier">Rapid Prototyping <span class="Apple-style-span" style="font-family: Helvetica; "><font class="Apple-style-span" face="Courier">| </font><font class="Apple-style-span" face="Courier">XSLT Codegeneration <span class="Apple-style-span" style="font-family: Helvetica; "><font class="Apple-style-span" face="Courier">| http://</font><font class="Apple-style-span" face="Courier"><a href="http://www.lollisoft.de">www.lollisoft.de</a></font></span></font></span></font></span></font></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">Lothar Behrens</font></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">Heinrich-Scheufelen-Platz 2</font></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font style="font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" face="Courier">73252 Lenningen</font></font></div><div><font class="Apple-style-span" face="Courier"><span class="Apple-style-span" style="white-space: pre; "><br class="webkit-block-placeholder"></span></font></div></div><p></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><br></p></div></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"> </div><br></body></html>