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 .

  • November 6, 2019
  • 3 replies
  • 62 views

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"

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.

3 replies

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

Can anyone help


nielsgerrits
VIP
Forum|alt.badge.img+64
  • 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