<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>gisgraphy.com - have some database dumps but are old, are from 2011.</span></div><div><span>csv dumps are like this:</span></div><div><span>1 : id; openstreetmap Id(was null in last version)<br>2 : name; The name <br>3 : location; The middle point of the street in HEXEWKB<br>4 : length ; Length of the street in meters<br>5 : countrycode; The iso3166 Alpha2 Code of the country <br>6 : is_in ; where the street is located (generally the city)<br>7 : type; The type of street (see bellow)<br>8 : oneway; Whether the street is a one way street<br>9 : shape; The delimitation of the street in HEXEWKB </span><br></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <div class="hr" style="margin: 5px 0px; padding:
0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" contenteditable="false" readonly="true"></div> <font face="Arial" size="2"> <b><span style="font-weight: bold;">From:</span></b> Peter K <peathal@yahoo.de><br> <b><span style="font-weight: bold;">To:</span></b> GraphHopper Java routing engine <graphhopper@openstreetmap.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, July 4, 2013 2:19 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [GraphHopper] coordinate search by name<br> </font> </div> <div class="y_msg_container"><br>
<div id="yiv607897360">
<div>
<div class="yiv607897360moz-cite-prefix">This is not that easy as you'll have to
combine street names with cities (+village+country+zipcode) names
while the import ...<br>
<br>
Also if you do it this way I would rather use a real search engine
like lucene or elasticsearch.<br>
<br>
Regards,<br>
Peter.<br>
<br>
</div>
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; background-color: rgb(255, 255, 255);">
<div><span>An idea is to import roads shapefiles from
<a href="http://geofabrik.de/" target="_blank">geofabrik.de</a> in spatialite and make a sqlite database.</span></div>
<div><span>After that you can search database for street names.</span></div>
<div><span>Resulted SQLite database contains also the path of a
street (a collection of geopoints) so you can reverse make a
reverse geocoding.</span></div>
<div> </div>
<div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">
<div style="font-family: times new roman, new york, times, serif; font-size: 12pt;">
<div dir="ltr"> <font face="Arial" size="2"> <b><span style="font-weight: bold;">From:</span></b> Peter K
<a class="yiv607897360moz-txt-link-rfc2396E" href="mailto:peathal@yahoo.de" target="_blank" rel="nofollow" ymailto="mailto:peathal@yahoo.de">mailto:peathal@yahoo.de</a><br>
<b><span style="font-weight: bold;">To:</span></b>
GraphHopper Java routing engine
<a class="yiv607897360moz-txt-link-rfc2396E" href="mailto:graphhopper@openstreetmap.org" target="_blank" rel="nofollow" ymailto="mailto:graphhopper@openstreetmap.org">mailto:graphhopper@openstreetmap.org</a> <br>
<b><span style="font-weight: bold;">Sent:</span></b>
Thursday, July 4, 2013 1:53 PM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [GraphHopper] coordinate search by name<br>
</font> </div>
<div class="yiv607897360y_msg_container"><br>
<div id="yiv607897360">
<div>
<div class="yiv607897360moz-cite-prefix">Hey Dmitriy,<br>
<br>
such a name search is not available offline (yet)
but if you have internet access you can use
NominatimGeocoder<br>
<br>
Regards,<br>
Peter.<br>
<br>
</div>
<blockquote type="cite"> Good day!<br>
<span class="yiv607897360" id="yiv607897360result_box" lang="en"><span class="yiv607897360hps">I need to</span> <span class="yiv607897360hps">search </span><span>coordinate
search by name(String)</span>.<br>
<span class="yiv607897360hps">I</span> <span class="yiv607897360hps">understood the</span> <span class="yiv607897360hps">class</span> <span class="yiv607897360hps">com.graphhopper.serch</span>
<span class="yiv607897360hps">but</span> <span class="yiv607897360hps">unfortunately</span> <span class="yiv607897360hps">did not understand how</span>
<span class="yiv607897360hps">to use it.</span><br>
<span class="yiv607897360hps">Please, tell me</span>
<span class="yiv607897360hps">how to get the</span>
<span class="yiv607897360hps">longitude and
latitude of</span> <span class="yiv607897360hps">the location</span> <span class="yiv607897360hps">by name</span><span>?</span></span><br>
<br>
<span class="yiv607897360short_text" id="yiv607897360result_box" lang="en"><span class="yiv607897360hps">I'm sorry</span> <span class="yiv607897360hps">that</span> <span class="yiv607897360hps">I asked</span> <span class="yiv607897360hps">a lot of questions</span></span>!<br>
<br>
-- <br>
Dmitriy Puchkov<br>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</div>
</div><br>_______________________________________________<br>GraphHopper mailing list<br><a href="mailto:GraphHopper@openstreetmap.org" ymailto="mailto:GraphHopper@openstreetmap.org">GraphHopper@openstreetmap.org</a><br><a href="http://lists.openstreetmap.org/listinfo/graphhopper" target="_blank">http://lists.openstreetmap.org/listinfo/graphhopper</a><br><br><br></div> </div> </div> </div></body></html>