<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 id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">ah yes that works. Turns out you have to drop and create the view if I tried a replace i get the below message. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><p style="margin: 0px; font-size: 12px; font-family: Monaco;"> ERROR: cannot change data type of view column "pt_geom" from geometry to geometry(Point,4326)</p><p style="margin: 0px; font-size: 12px; font-family: Monaco;"><br></p><p style="margin: 0px; font-size: 12px; font-family: Monaco;">But a new view shows up correctly. </p><p style="margin: 0px; font-size: 12px; font-family: Monaco;"><br></p><p style="margin: 0px; font-size: 12px; font-family: Monaco;">Thanks!</p></div> <br><p style="color:#000;">On May 8, 2014 at 3:50:24 PM, Alexandre Neto (<a href="mailto:senhor.neto@gmail.com">senhor.neto@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<div dir="ltr">Hello Jason,
<div><br></div>
<div>All you need to cast a geometry as other more restrict
geometry type is:</div>
<div><br></div>
<div><b style="font-family:arial,sans-serif;font-size:12.727272033691406px">st_centroid(report_geom)::geometry(POINT,4326)</b><br>
</div>
<div><b style="font-family:arial,sans-serif;font-size:12.727272033691406px"><br>
</b></div>
<div><span style="font-family:arial,sans-serif;font-size:12.727272033691406px">Hope
this helps</span></div>
<div><span style="font-family:arial,sans-serif;font-size:12.727272033691406px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:12.727272033691406px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:12.727272033691406px"><br>
</span></div>
<div><span style="font-family:arial,sans-serif;font-size:12.727272033691406px">Alexandre
Neto</span></div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, May 8, 2014 at 9:49 PM, Jason
Mathis <span dir="ltr"><<a href="mailto:jmathis@redzonesoftware.com" target="_blank">jmathis@redzonesoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<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>
</div>
<br>
<p><font face="Arial">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 <a href="tel:%28303%29%20386-3955" value="+13033863955" target="_blank">(303) 386-3955</a> or by return e-mail to the
sender.</font></p>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br></div>
_______________________________________________
<br>postgis-users mailing list
<br>postgis-users@lists.osgeo.org
<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</div></div></span></blockquote></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>