2
votes
Accepted
Getting Latitude and Longitude from a Linestring
This is a syntax error, try this:
SELECT st_astext(((ST_Dumppoints (geometry)).geom)) as geom from warning_vmz;
note that this line is incorrect, "LINESTRING(7.2860666 53.1664885,7.2860666 53....
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
postgis-1.5 × 52postgis × 30
postgresql × 20
postgis-2.0 × 10
qgis × 7
python × 3
sql × 3
pgrouting × 3
geodjango × 3
openlayers-2 × 2
openstreetmap × 2
geometry × 2
shapely × 2
ubuntu × 2
php × 2
length × 2
raster × 1
geoserver × 1
shapefile × 1
r × 1
polygon × 1
geojson × 1
point × 1
coordinates × 1
buffer × 1