Re: [postgis-users] Problem with st_dumppoints

Hugues François Fri, 05 Aug 2016 01:03:29 -0700

Hi,

Should be
WITH yourwithname AS (
SELECT st_dumppoints(st_transform(flstfinal.geom, 4326)) AS st_dumppoints FROM flstfinal
)
SELECT (st_dumppoints).path, (st_dumppoints).geom FROM yourwithname

It is always better if you can choose non ambiguous aliases.

Hug

Le 5 août 2016 9:48 AM, Sebastian Teßmer <[email protected]> a écrit :

Hi Hugues,

i try it like:

WITH flstfinal AS (flstfinal)
SELECT (st_dumppoints).path, (st_dumppoints).geom FROM flstfinal

and i have this mistake:

FEHLER: Syntaxfehler bei „flstfinal“
LINE 1: WITH flstfinal AS (flstfinal)
                           ^
********** Fehler **********

FEHLER: Syntaxfehler bei „flstfinal“
SQL Status:42601
Zeichen:20

Where is my fault?

Gesendet: Freitag, 05. August 2016 um 09:20 Uhr
Von: "Hugues François" <[email protected]>
An: "PostGIS Users Discussion" <[email protected]>
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 <[email protected]> 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 [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] Problem with st_dumppoints

Reply via email to