0
votes
0answers
25 views

Finding a common area by a set of ID variables?

I am trying to find a way to find a way to get matches of areas based on multiple sets of ID variables. I am using state-county and state-puma as an example below, but I am wishing to do this for more ...
6
votes
3answers
237 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 ...
5
votes
2answers
612 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 ...