0
votes
2answers
57 views

can't geocode with PostGIS 2.1.1

I don't know where's the mistake... I am using the process from the PostGIS documentation (http://postgis.net/docs/manual-2.1/postgis_installation.html#loading_extras_tiger_geocoder) . I created a ...
0
votes
0answers
44 views

Extract city boundary from TIGER data

I'm trying to find the bounding box of US cities but I just can't seem to figure out what to do with the TIGER data I download (not to mention, which data to download!). Could someone experienced with ...
1
vote
0answers
47 views

Interpretation of PostGIS geocode function ratings

Edit: I am using Postgres 9.2 and recently installed PostGIS along with the Tiger Geocoder from the extras folder and downloaded all the latest Tiger data. I have been testing the Tiger Geocoder ...
6
votes
3answers
173 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
2answers
248 views

Install PostGIS and TIGER Data in Ubuntu 12.04

Could someone write a brief albeit dumbed down idiot's guide to installing postgis and loading national Tiger data on ubuntu? I've tried a few guides, namely, ...
1
vote
3answers
146 views

How long does it take to load the complete Tiger 2013 dataset into Postgis?

I'm loading the complete TIGER 2013 dataset into a Postgis database and finding that the process is taking an extraordinarily long time. I was surprised by how long it took to load the TIGER 2012 ...
1
vote
1answer
279 views

How to improve poor performance times for PostGIS 2.1 Tiger Geocoder?

I've recently upgraded my PostGIS DB from 2.0 to 2.1. I initially followed the instructions from Waiting for PostGIS 2.1 - Install PostGIS Tiger Geocoder as an Extension and 2.7. Installing, ...
2
votes
1answer
69 views

Tiger geocoder / postgis - get county from point

Looking for some help with getting the county for a lat / lon. I have postgis / tiger geocoder installed and can reverse look up a point and get the addresses. I would like to get the county the ...
9
votes
1answer
5k views

Geocode quality: Nominatim vs. PostGIS Geocoder vs. Geocoder::US 2.0

I occasionally need to geocode >> 500,000 US street addresses (no features or intersections). I'd like to set up a geocoding service locally to handle these bulk geocodes. I've used the Tiger-based ...