Skip to main content
Solved

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

  • September 27, 2023
  • 2 replies
  • 108 views

fmeuser_gc
Contributor
Forum|alt.badge.img+8

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.

View original
Did this help you find an answer to your question?

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+8
  • Author
  • Contributor
  • October 17, 2023

Able to visualize now. Thank You @chrisatsafe​ 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings