[postgis-users] convert srid

[Paragon Corporation]

At a quick glance, this looks to me like equivalent to SRID: 4326 (WGS 84
long lat).
 
In that case you don't really need to do a transform or register the srid.
 
Just update your geometry SRID to 4326 -
 
http://www.postgis.org/documentation/manual-svn/UpdateGeometrySRID.html
 
SELECT UpdateGeometrySRID('my_table', 'the_geom', 4326);
 
should do it.
 
If you really need 8307, just add the entry by copying the 4326 one.
 
Leo
http://www.postgis.us
 
  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jaime
Lop
Sent: Friday, May 06, 2011 10:04 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] convert srid


And can I add this srid to postgis or do I need to make the transformation
elsewhere?


On Fri, May 6, 2011 at 3:45 PM, Dave <dave.potts at pinan.co.uk> wrote:


On 06/05/2011 14:13, Jaime Lop wrote:
Postgis is telling you that it does not have an entry in the spatial_ref_sys
table for the srid 8307

See http://forums.esri.com/Thread.asp?c=2
<http://forums.esri.com/Thread.asp?c=2&f=1720&t=136889> &f=1720&t=136889 for
some comments about 8307


Hello everyone,

I have some data with srid 8307 on a postgis column and I would like to
transform it to 4326. Is that possible?

When I try
UPDATE my_table SET the_geom=transform(the_geom,4326);
I get this error message:
ERROR: GetProj4StringSPI: Cannot find SRID (8307) in spatial_ref_sys
SQL state: XX000

Thanks,
Jaime



_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110507/434e6f1b/attachment.html>