Re: [Geoserver-users] PostgreSQL and PostGIS

[Russ Hore]

Have you installed the ostGIS extension?

CREATE EXTENSION postgis;

If so you can add a Geometry column with;

https://postgis.net/docs/AddGeometryColumn.html

Set the SRID to what your data is.

Then you ST_MakePoint (If it is point data) to update the new column using the 
data from other fields in the row.

https://postgis.net/docs/ST_MakePoint.html

Something like UPDATE tablename set the_geom=ST_makePoint(X, Y)


> 
> 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

Re: [Geoserver-users] PostgreSQL and PostGIS

[Alexandre Gacon]

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  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

[Geoserver-users] PostgreSQL and PostGIS

[Jim Rogers]

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