Question

which format should be used to save data that I want to write to PostGIS?

  • 10 August 2022
  • 1 reply
  • 1 view
E

I would like to use the hosted (cloud) solution,

but my database is behind VPC, so there is no direct access from FME to my DB.

how can I save the data in the EWKT or EWKB format, so I could save it by myself to the DB , using a text file? (or a stream in websocket?)

 

I tried using GML & GeoJson - but they both loose the geometry types and just save as multilineString

1 reply

hkingsbury
Rank
Userlevel 5
Badge +29

Could you write to a local database, then backup the local instance, and restore it in your hosted instance?

 

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd

Reply


Community Stats

28,670
Posts
109,367
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.