6
votes
3answers
175 views

How can I obtain the same area values provided by the Census for TIGER boundaries using PostGIS functions?

In PostGIS, how can I compute the area of Census Boundaries and obtain the same results as are provided by the Census? For example, most Census Boundaries include attributes for Land Area and Water ...
1
vote
1answer
52 views

How to restrict buffer extent within land area only?

I need to create buffer for a point feature, but the buffer area will be restricted within the land area only. For example consider the following: A buffer of say 500 km radius is to be generated ...
3
votes
1answer
181 views

PostGIS: worldwide area calculation

I have a table with polygons in EPSG 4326. These polygons are distributed all over the world, for example: POLYGON((10.7324632658845 59.9253049236956,10.7331908150806 ...
6
votes
3answers
1k views

How do I get the area of a WGS84 polygon in square meters?

The following gives me the area of the polygon in square degrees: SELECT ST_Area(ST_GeomFromText('POLYGON((871325.790874952 6105405.3261047,871418.748307692 6105359.72944624,871346.22022442 ...
5
votes
2answers
446 views

PostGIS - area-weighted calculation on an intersection

I'm trying to learn postgis sql by performing some familiar operations from ArcGIS. Here, I want to perform an area-weighted calculation of certain populations on the intersection of a set of parcels ...
2
votes
1answer
2k views

Calculating area of an EPSG:4326 Polygon [duplicate]

Possible Duplicate: What is the most accurate coordinate system for calculating areas of polygons? In our Postgres/Postgis database we store polygons in a column defined as ...