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 ...
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 ...
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 ...
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 ...
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 ...