[postgis-users] convert srid

[Dave]

On 06/05/2011 15:04, Jaime Lop wrote:
> And can I add this srid to postgis or do I need to make the 
> transformation elsewhere?
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.
>
> On Fri, May 6, 2011 at 3:45 PM, Dave <dave.potts at pinan.co.uk 
> <mailto: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&f=1720&t=136889
>     <http://forums.esri.com/Thread.asp?c=2&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  <mailto:postgis-users at postgis.refractions.net>
>>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto: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/20110506/6a3c1121/attachment.html>