Hi. Could someone advise how to write the attributes to the postgres DB, but at the same time write the coordinates in the geometric data type? I have postgis extension in postgres DB. I don't see any such data type in the user attribute tab on the postgres writer. Thank you
Question
witer data to postgres
+8- Contributor
Hi,
I am not sure what you want to accomplish; but I believe it is best to use the PostGIS-writer. The geometry and attributes are then written in the table.
What is you inputdata? Does it already have geometry? If not you can use the VertexCreator to convert to Lat and Lon columns to geometry.
+11- Contributor
Hi,
I am not sure what you want to accomplish; but I believe it is best to use the PostGIS-writer. The geometry and attributes are then written in the table.
What is you inputdata? Does it already have geometry? If not you can use the VertexCreator to convert to Lat and Lon columns to geometry.
hi, the target is a printscreen, see the attachment, but the coordinates are written as the correct data type - geometry. It is currently written as varchar. The input attributes already contain the geometry, it is just a write-up.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.