<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 06/05/2011 15:04, Jaime Lop wrote:
<blockquote
cite="mid:BANLkTinz7n6_A7UEpgg=Jt6CeZ5x0Xf7Yg@mail.gmail.com"
type="cite">And can I add this srid to postgis or do I need to
make the transformation elsewhere?<br>
</blockquote>
Just update the table, the spatial ref sys table defines how a
mapping should be done. The link I provide gives a def for this
projection.<br>
<blockquote
cite="mid:BANLkTinz7n6_A7UEpgg=Jt6CeZ5x0Xf7Yg@mail.gmail.com"
type="cite"><br>
<div class="gmail_quote">On Fri, May 6, 2011 at 3:45 PM, Dave <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:dave.potts@pinan.co.uk">dave.potts@pinan.co.uk</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> 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 moz-do-not-send="true"
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 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 moz-do-not-send="true" href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>