<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>Hello,</div><div><br></div>I am fairly new to postgis so it would be great if someone could point me in the right direction on how to fix this issue. Or if its even fixable. <div><br></div><div>I have a table that stores polygons and multi polygons with a column:</div><div><br></div><div><b> report_geom geometry(Geometry,4326)</b></div><div><br></div><div>I have a view that uses that column like:</div><div><br></div><div><b> st_centroid(report_geom) as pt_geom</b></div><div><b><br></b></div><div>The issue is when you use the st_centroid is removes the srid and leaves it a plain geometry. Which can make it a bit inconvenient for use in arc and qgis apps. Is there a way to cast it to be a point with 4326? </div><div><br></div><div>Thanks all!</div><div><br></div><div>-jason </div><div><br></div><div><br></div></body></html>
<br>
<p><font face="Arial" size="2">This transmission contains confidential and privileged
information intended solely for the party identified above. If you receive this message in error, you must not use
it or convey it to others. Please destroy it immediately and contact the sender at
(303) 386-3955 or by return e-mail to the sender.</font></p>