[OSGeo Africa] Geoserver SQL View

[Zibusiso Ncube]

Good Day,

I have a MySQL db instance that I am "replicating" (also a means to clean
up my data via python) to a postgres instance. initial i was creating  a
points layers using lat and long fields in my db using SQLview using

*ST_SETSRID(ST_POINT(point_longitude, point_latitude), 4326) as the_geom *

I have some data that has 4 coordinate points and these are the corners
of ploygons/areas of interest. Is it possible to use SQLviews in Geoserver
to create polygons?

Has someone tried this? How best can one do this?

can i use something along the lines off...

*ST_SETSRID(ST_POLYGON(point1xy, point2xy...pointZxy)**, 4326) as the_geom *

*?*

Regards

Zibusiso M Ncube
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20211210/9139e28c/attachment.html>