<div dir="auto"><div>Thanks Admire. <div dir="auto"><br></div><div dir="auto">Yes you read through my question and intentions ... the thing is I have to redo the whole setup and I was trying to shortcut the thinking process and trying process to see if someone had actually done it ...before I start breaking things apart on my system and rebuild stuff (code, tables, q.a. measures the works, recommendations to end users etc etc) and creating test data etc.</div><div dir="auto"><br></div><div dir="auto">Thanks for the insights I will definitely use them.</div><div dir="auto"><br></div><div dir="auto">Regards,</div><div dir="auto"><br></div><div dir="auto">Zibusiso </div><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 10 Dec 2021, 20:38 Admire Nyakudya, <<a href="mailto:addloe@gmail.com">addloe@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div name="messageBodySection">
<div dir="auto">Hi</div>
</div>
<div name="messageSignatureSection"><br>
<div dir="auto">Sent with a <a href="https://sparkmailapp.com/source?from=signature" target="_blank" rel="noreferrer">Spark</a></div>
</div>
<div name="messageReplySection">
<div dir="auto">On 10 Dec 2021, 11:17 +0200, Zibusiso Ncube <<a href="mailto:ncubezedm@gmail.com" target="_blank" rel="noreferrer">ncubezedm@gmail.com</a>>, wrote:</div>
<blockquote style="border-left:thin solid rgb(26,188,156);margin:5px;padding-left:10px">Good Day,<br>
<br>
I have a MySQL db instance that I am "replicating" (also a means to clean up my data via python) to a postgres instance. </blockquote>
<div dir="auto">If your data doesn't have any relations you can use ogr2ogr to migrate it from mysql to Postgresql tables. If it has relations you will need to find a tool that allows you to convert between the two.</div>
<blockquote style="border-left:thin solid rgb(26,188,156);margin:5px;padding-left:10px">initial i was creating a points layers using lat and long fields in my db using SQLview using<br>
<br>
<strong><em>ST_SETSRID(ST_POINT(point_longitude, point_latitude), 4326) as the_geom </em></strong>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?<br>
<br>
Has someone tried this? How best can one do this?</blockquote>
<div dir="auto">If your question is more about can Geoserver SQL views achieve this then yes it can.</div>
<blockquote style="border-left:thin solid rgb(26,188,156);margin:5px;padding-left:10px"><br>
can i use something along the lines off...<br>
<br>
<strong><em>ST_SETSRID(ST_POLYGON(point1xy, point2xy...pointZxy), 4326) as the_geom </em></strong></blockquote>
<div dir="auto"><strong><em>This sounds more like a question of how to write the SQL to achieve this. The Postgresql documentation has nice examples of this ie </em></strong><br>
<a href="https://postgis.net/docs/ST_MakePolygon.html" target="_blank" rel="noreferrer">https://postgis.net/docs/ST_MakePolygon.html</a><br>
<br>
<strong><em> Alternatively you can check some of the answers on stack exchange as they provide solutions to this question i.e </em></strong><a href="https://stackoverflow.com/questions/19046642/convert-points-to-polygon-using-postgis" target="_blank" rel="noreferrer">https://stackoverflow.com/questions/19046642/convert-points-to-polygon-using-postgis</a></div>
<blockquote style="border-left:thin solid rgb(26,188,156);margin:5px;padding-left:10px"><strong><em>?</em></strong>Regards<br>
<br>
Zibusiso M Ncube<br>
<br>
_______________________________________________<br>
Africa mailing list<br>
<a href="mailto:Africa@lists.osgeo.org" target="_blank" rel="noreferrer">Africa@lists.osgeo.org</a><br>
You can UNSUBSCRIBE at <a href="https://lists.osgeo.org/mailman/listinfo/africa" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/africa</a></blockquote>
</div>
</div>
_______________________________________________<br>
Africa mailing list<br>
<a href="mailto:Africa@lists.osgeo.org" target="_blank" rel="noreferrer">Africa@lists.osgeo.org</a><br>
You can UNSUBSCRIBE at <a href="https://lists.osgeo.org/mailman/listinfo/africa" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/africa</a><br>
</blockquote></div></div></div>