<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17573"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>At a quick glance, this looks to me like equivalent to
SRID: 4326 (WGS 84 long lat).</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>In that case you don't really need to do a transform or
register the srid.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>Just update your geometry SRID to 4326
-</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff><SPAN class=283253916-07052011><A
href="http://www.postgis.org/documentation/manual-svn/UpdateGeometrySRID.html">http://www.postgis.org/documentation/manual-svn/UpdateGeometrySRID.html</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>SELECT UpdateGeometrySRID('my_table', 'the_geom',
4326);</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>should do it.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>If you really need 8307, just add the entry by copying
the 4326 one.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011>Leo</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011><A
href="http://www.postgis.us">http://www.postgis.us</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=283253916-07052011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Jaime
Lop<BR><B>Sent:</B> Friday, May 06, 2011 10:04 AM<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> Re: [postgis-users] convert
srid<BR></FONT><BR></DIV>
<DIV></DIV>And can I add this srid to postgis or do I need to make the
transformation elsewhere?<BR><BR>
<DIV class=gmail_quote>On Fri, May 6, 2011 at 3:45 PM, Dave <SPAN dir=ltr><<A
href="mailto:dave.potts@pinan.co.uk">dave.potts@pinan.co.uk</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV text="#000000" bgcolor="#ffffff">On 06/05/2011 14:13, Jaime Lop
wrote:<BR>Postgis is telling you that it does not have an entry in the
spatial_ref_sys table for the srid 8307<BR><BR>See <A
href="http://forums.esri.com/Thread.asp?c=2&f=1720&t=136889"
target=_blank>http://forums.esri.com/Thread.asp?c=2&f=1720&t=136889</A>
for some comments about 8307<BR>
<BLOCKQUOTE type="cite">
<DIV>
<DIV></DIV>
<DIV class=h5>Hello everyone,<BR><BR>I have some data with srid 8307 on a
postgis column and I would like to transform it to 4326. Is that
possible?<BR><BR>When I try<BR>UPDATE my_table SET
the_geom=transform(the_geom,4326);<BR>I get this error message:<BR>ERROR:
GetProj4StringSPI: Cannot find SRID (8307) in spatial_ref_sys<BR>SQL state:
XX000<BR><BR>Thanks,<BR>Jaime<BR></DIV></DIV><PRE><FIELDSET></FIELDSET>
_______________________________________________
postgis-users mailing list
<A href="mailto:postgis-users@postgis.refractions.net" target=_blank>postgis-users@postgis.refractions.net</A>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE><BR></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>