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 > [email protected] > http://lists.openstreetmap.org/listinfo/geocoding -- michal palenik www.freemap.sk www.oma.sk http://wiki.freemap.sk _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
