Skip to main content
Question

Writing to GeoServer using PostGIS

  • September 24, 2025
  • 3 replies
  • 48 views
jonathan_vru
Contributor
Forum|alt.badge.img+6

Goodmorning! I want to write a dataset with the postgis writer to GeoServer, but the result gives errors.

 

 

Process: A reader of municipal boundaries, and a reader with fire hydrants, the fire hydrants gets clipped on the boundaries layer, and then i want to write it to Geoserver.

 

The postGIS writer says its succesfull, but when i inspect the layer in QGIS, there is no data, and i get the error: there is no item in geometry_colums. What have i done wrong in the postGIS writer? Can anyone help me? 

 

Thanks in advance!

 

danilo_fme

3 replies

crutledge
Influencer
Forum|alt.badge.img+43
  • crutledgeInfluencer
  • Influencer
  • September 24, 2025

Hi ​@jonathan_vru Can you successfully write output with geometry to another format like GeoJSON?

At your rest service ^B
jonathan_vru
Contributor
Forum|alt.badge.img+6
  • jonathan_vruContributor
  • Author
  • Contributor
  • September 25, 2025

Hi ​@crutledge yes, that works fine. Just writing new layers to a postgis database doenst work. I dont really know what is going wrong, neither one of my collegues. 

jonathan_vru
Contributor
Forum|alt.badge.img+6
  • jonathan_vruContributor
  • Author
  • Contributor
  • September 25, 2025

It finally shows the points, but the field "geometie"  has value GEOMETRY, where it should be point. How do i change that in my process?

 

Thanks in advance!

 

Community Stats

32,117
Posts
121,941
Replies
39,766
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.