[Geocoding] Nominatim: Listing all streets in city

[Michal Palenik]

after osm2pgsql import, there are tables planet_osm_line and
planet_osm_polygon

something like

select name from planet_osm_line where highway is not null and
st_intersects(way, (select way from planet_osm_polygon where
osm_id=-123456)) group by name;

i use it at sites like http://cadca.oma.sk/u

michal


On Sun, May 26, 2013 at 08:23:14PM +0200, Dariusz Bączkowski wrote:
> Hi,
> 
> I would like to list all streets in city using Nominatim. 
> Let's say in Koszalin, Poland. Is there any way to do that?
> I have Nominatim server available, so it can be in a form of database query if 
> no other way is possible. 
> 
> P.S. Is there some place where I can read how Nominatim works in detail, 
> especially how database is used in searches?
> 
> -- 
> Pozdrawiam,
> Dariusz Bączkowski



> _______________________________________________
> Geocoding mailing list
> Geocoding at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/geocoding


-- 
michal palenik
www.freemap.sk
www.oma.sk
http://wiki.freemap.sk