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
+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
stefanh wrote:
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.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.