Skip to main content
Solved

When writing data from filegoedatabase to postgres some features come geometry field empty or not complete. However this data in fme it shown geographically correct .


hamdyahmed
Forum|alt.badge.img

the problem when i see data in pgadmin i cant perview data correct . however it is shown in fme inspector

 

fme2019.1

Best answer by nielsgerrits

It's hard to understand what you are asking exactly, but I think the issue you have is you are writing to a generic geometry column. (Generic is multi geometry type, most GIS software can't handle this.) This is the default in the PostGIS Writer somehow. You can find it under Parameters... Uncheck "Create Generic Spatial Columns"

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

3 replies

hamdyahmed
Forum|alt.badge.img
  • Author
  • November 12, 2019

Can anyone help


nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • November 12, 2019

It's hard to understand what you are asking exactly, but I think the issue you have is you are writing to a generic geometry column. (Generic is multi geometry type, most GIS software can't handle this.) This is the default in the PostGIS Writer somehow. You can find it under Parameters... Uncheck "Create Generic Spatial Columns"


hamdyahmed
Forum|alt.badge.img
  • Author
  • November 12, 2019

Thanks it is working with me through uncheck create generic spatial column


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