Hello Jim, To do so, you have first to add a Geometry column to your table (you can be more precise on the type of Geometry by using for example Point as type). You have to define also the SRS of the coordinates.
To populate your column you can for example use the ST_MakePoint function using the coordinates available in the other columns. The last step would be to add a spatial index on the geometry column in order to have great performances. Have a look at https://postgis.net/docs/reference.html, the documentation is quite complete. Regards Alexandre Le lun. 24 juin 2024 à 22:37, Jim Rogers <jim.rog...@bogart.ai> a écrit : > Jody, > > > > If I have a PostgreSQL database that contains spatial coordinates, do you > know how I convert that database into PostGIS format so I can publish it on > GeoServer? > > > > Jim Rogers > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
