Skip to main content
Solved

How to visualize PostGIS table with two different geometry types - Point & Polygon?

  • September 27, 2023
  • 2 replies
  • 161 views

fmeuser_gc
Contributor
Forum|alt.badge.img+9

I've PostGIS table with two geometry types - Point & Polygon. When I read table, I'm only able to see Polygons. But point geometry column is only shown in table and unable to visualize.

 

Is there any way to visualize point geometry instead? How do we explicitly mention for which geometry columns to be visualized?

 

Thanks!

Best answer by chrisatsafe

Hi @fmeuser_gc​ ,

Check out the Reading Mulitple PostGIS Geometries section of this article. Essentially you just need to use a SELECT statement in the Reader Feature Type as FME will read the first geometry column by default and ignore the others. You can override it by using a SELECT statement. From there, you can expose the attribute and use a GeometryReplacer to visualize the geometry.

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

chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • Best Answer
  • September 28, 2023

Hi @fmeuser_gc​ ,

Check out the Reading Mulitple PostGIS Geometries section of this article. Essentially you just need to use a SELECT statement in the Reader Feature Type as FME will read the first geometry column by default and ignore the others. You can override it by using a SELECT statement. From there, you can expose the attribute and use a GeometryReplacer to visualize the geometry.


fmeuser_gc
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • October 17, 2023

Able to visualize now. Thank You @chrisatsafe​