Changes

|Has title=Tiger Geocoder

|Has owner=Peter Jalbert,

|Has start date=Fall 2017

|Has keywords=Tiger, Geocoder, Database

}}

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.

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

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

--------+-------------------+----------------+------+--------+------+--------+----+-------

0 | -71.0557505845646 | 42.35897920691 | 75 | State | St | Boston | MA | 02109