Re: [postgis-users] Problem with st_dumppoints

[Sebastian Teßmer]

Hi Hugues, I try it.

 

Thank you very much... Sebastian

 

Gesendet: Freitag, 05. August 2016 um 09:20 Uhr
Von: "Hugues François" <hugues.franc...@irstea.fr>
An: "PostGIS Users Discussion" <postgis-users@lists.osgeo.org>
Betreff: Re: [postgis-users] Problem with st_dumppoints

Hi,

If I understand what you're looking for, I think you just need to call path and geom separately. This would look like:
WITH yourquery AS (yourquery)
SELECT (st_dumppoints).path, (st_dumppoints).geom FROM yourquery

And if you want to collect all points of an object you could do that using a group by clause on the object identifier and st_collect((st_dumppoints).geom).

HTH

Hug

 

Le 5 août 2016 8:56 AM, Sebastian Teßmer <sebastiantess...@gmx.de> a écrit :

Hi everybody,

 

i have a problem with st_dumppoints and i hope you can help...

 

my sql is:

 

SELECT st_dumppoints(st_transform(flstfinal.geom, 4326)) AS st_dumppoints FROM flstfinal;

 

with the result (for example):

 

("{1,1,1}", and then a wkt geometry.....

 

at the beginning, i have that i want, but the geomtery isn't that what i want.

 

I need a geometry like MULTIPOINT(.....)

 

I want a result like:

 

Column 1      |      Column 2

1,1,1            |     Multipoint(Point in WGS84)

....

Can anybody help me?

 

Thank you very munch!!!

 

Sebastian

 

 

_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users