[postgis-users] Usage of Transform() function in a query.

[Paul Ramsey]

Your call looks exactly right. You compiled postgis with proj support? 
You have an entry for 42304 in your spatial_ref_sys table, that has a 
proj4 definition in it?

P

David.Jacques at CCRS.NRCan.gc.ca wrote:

> I need to reproject a spatial table from one SRID to another
> Both the source and destination SRIDs are in the SPATIAL_REF_SYS table.
> I've consulted the manual and the following is presented...
> 
> SELECT transform(GEOM,4269) FROM GEOTABLE
> 
> Here is the exact query
> 
> SELECT transform(the_geom,42304) FROM xxmodishotspots;
> 
> What I get is all records consisting of 1 column called "transform" with all
> null values.
> 
> I expected to get the same output as SELECT * from xxmodishotspots; would
> produce, with
>  the exception being that "the_geom" column would contain a value like
> 
> 	SRID=42304;POINT(-552256.351008368 22239.2415119158)
> 
> 	instead of
> 
> 	SRID=4269;POINT(-90.673 69.4310000006199)
> 
> 
> Does anyone have a better example than the manual ? I can't see what I am
> doing wrong.
> 
> 
> Thanks in advance..
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users