7,612
edits
Changes
Jump to navigation
Jump to search
|Has Image=Tiger.jpg
no edit summary
{{Project|Has project output=Data,Tool|Has sponsor=McNair ProjectsCenter
|Has title=Tiger Geocoder
|Has owner=Peter Jalbert,
|Has start date=Fall 2017
|Has keywords=Tiger, Geocoder, Database
|Has project status=Active
|Has Image=Tiger.jpg
}}
Note: The Address Ranges National Geodatabase is available from https://www.census.gov/geo/maps-data/data/tiger-geodatabases.html
This page serves as documentation for using the Tiger Geocoder on Postgres SQL, as part of the PostGIS extension. The following wiki pages may also be of use to you:
CURRENT PROGRESS:
The following states have been downloaded into the geocoder database.
AL, AK, AZ, AR, CA, CO, CT, DE, FL, GA, IA, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN
===Current Errors===
[https://trac.osgeo.org/postgis/ticket/3699 This] is the only online forum I could find with others who have faced a similar issue.
NOTE: Contacted the US Census Bureau and never got a response. However, the scripts magically started working again about a week later. Second however, the scripts stopped working again the next day.
==Geocode Function==
rating -- This is an integer that determines the confidence in the resulting geocode. The closer to 0, the more confident the guess.
ST_X(g.geomout) -- This retrieves the longitude coordinate of the point.
ST_Y(g.geomout) -- This retrieves the latitude corodinate of the point.
addy -- In general, addy is a normalized address resulting from the input address.
(addy).address -- The number of the address (Ex: "75" Blabla rd.)
(addy).streetname -- The name of the street (Ex: 75 "Blabla" rd.)
(addy).streettypeabbrev -- The abbreviation of the street (Ex: 75 blabla "rd")
(addy).location -- The city location of the address.
(addy).stateabbrev -- The state abbreviation.
(addy).zip -- The zipcode of the address.
The email exchanges are recorded below.
--------------------------------------
--------------------------------------
I am a student researcher at the McNair Center for Entrepreneurship and Innovation at Rice University, and I am in the process of installing a Postgres Extension that relies on the TIGER data.
