Hello Jason, All you need to cast a geometry as other more restrict geometry type is:
*st_centroid(report_geom)::geometry(POINT,4326)* Hope this helps Alexandre Neto On Thu, May 8, 2014 at 9:49 PM, Jason Mathis <[email protected]>wrote: > Hello, > > 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. > > I have a table that stores polygons and multi polygons with a column: > > * report_geom geometry(Geometry,4326)* > > I have a view that uses that column like: > > * st_centroid(report_geom) as pt_geom* > > 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? > > Thanks all! > > -jason > > > > 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. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
