Skip to main content
Solved

convert one point into multipoint

  • July 14, 2017
  • 2 replies
  • 259 views

I have a dataset containing different points. To insert them into my postGIS database I need to convert each point into multipoint (but each multipoint is only containing one point)

I may not change the geometry-type in postGIS, so I just need to store each point as a multipoint...

I already did some tests with the aggregator and geometrycoercer, but can't figure out how to change the geometry from point into multipoint.

maybe a bit of a silly question, but I just can't figure out how to do this :(

thanks for helping me!

Best answer by ebygomm

In my experience if you aggregate a point geometry it becomes a multipoint if you have the mode set to geometry assemble one level

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+45
  • Influencer
  • Best Answer
  • July 14, 2017

In my experience if you aggregate a point geometry it becomes a multipoint if you have the mode set to geometry assemble one level


  • Author
  • July 14, 2017

weird... I do not know what I did before, but I became an aggregate-collection before...

thanks, aggrator, with the "geometry assemble one level" and group by unique id, did the trick!