Skip to main content

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!

 

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


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. 


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!