6
votes
3answers
235 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 ...
3
votes
3answers
633 views

Best way to assign points to nearest roads in postgis?

I'm trying to implement a simplified type of dasymetric mapping for census data. I've downloaded the Census's American Community Survey individual-level data and randomly assigned every household to a ...
5
votes
2answers
611 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 ...
5
votes
2answers
2k views

What is the SRID of census.gov shapfiles?

I downloaded the county files from: http://www.census.gov/cgi-bin/geo/shapefiles2011/main I cannot figure out what SRID to use with them. When I am trying to generate a class file from ./manage.py ...