I installed Postgresql, Gis, SELECT postgis_full_version() reports,
POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3" LIBJSON="0.11.99"
I was able to import data for a single city, from a Geofabrik file, through osm2pgsql.
Now I'd like to export all pedestrian streets in this database in lat,lon,name format. Same street could show up in multiple rows, a street being composed of multiple line segments - that is fine.
I am able to use this query to get streets, and I believe they are line pieces, but how do I get the latitude / longitude associated with the beginning and end of that line?
SELECT name FROM planet_osm_line WHERE highway in ('pedestrian');
What would be the simplest query to do this?