[postgis-users] Convert between SRID units and meters
Peter Hsu
peter at motivecast.com
Fri May 20 17:37:29 PDT 2011
Dan,
Thanks, that was a really good intro to get my head wrapped around some of the concepts, as this is all new to me.
Instead of reprojecting my data, I found that I could use the ST_Transform and ::geography cast to have ST_Area return the geography area instead, a la (snippet follows). This is fine, and performance isn't an issue as I'm working with this data statically.
select ST_Area(ST_Transform(the_geom,4326)::geography) AS area from ... <snip>
Hope this helps someone else..
Thanks again!
On May 20, 2011, at 12:00 PM, postgis-users-request at postgis.refractions.net wrote:
Hi Peter,
Here is a link to OSGeo workshop that should be a helpful premier on the
issue in general and provides a solution to your problem through the use
of PostGIS's geography type:
http://workshops.opengeo.org/postgis-intro/geography.html
If you are dealing with a fairly well define area, say the West Coast of
the US and Canada, then you might consider reprojecting your data out of
NAD83 (North American Datum of 1983) geographic (lon/lat) coordinates
(EPSG: 4269) into Euclidean coordinates (such as NAD83 UTM 10N), and
then you can use the standard st_area tool and the result will be in meters.
Dan
On 05/20/2011 11:57 AM, Peter Hsu wrote:
> I have a simple question. I've loaded up shape files from the tigerline US census bureau. Everything works fine, but I'm trying to find the area of a geometry in meters. However, I'm only able to get the area in SRID units.
>
> How can I convert from SRID units to meters? Is this a linear conversion? Or is it dependent on the latitude of the area in question?
>
> The SRID for the tigerline files is 4269
>
> Peter
> _______________________________________________
> 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/20110520/d1842b32/attachment.html>
More information about the postgis-users
mailing list