Tiger Geocoder - Revision history

Ed at 17:44, 21 September 2020

2020-09-21T17:44:08Z

2020-09-21T17:34:25Z

2020-09-20T17:20:16Z

2020-09-20T17:12:28Z

2017-12-06T21:59:49Z

2017-12-06T21:36:07Z

2017-11-27T22:31:45Z

2017-11-25T22:05:43Z

2017-11-20T21:52:51Z

2017-11-15T21:14:12Z

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data,Tool
 |Has sponsor=McNair Center
 |Has title=Tiger Geocoder

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=Tiger Geocoder

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=Tiger Geocoder
 |Has owner=Peter Jalbert,

@@ Line 1: / Line 1: @@
-{{McNair Projects
+{{Project
 |Has title=Tiger Geocoder
 |Has owner=Peter Jalbert,

@@ Line 113: / Line 113: @@
 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
+  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===

@@ Line 7: / Line 7: @@
 |Has Image=Tiger.jpg
 }}
 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:

← Older revision		Revision as of 21:52, 20 November 2017
Line 122:		Line 122:

	[https://trac.osgeo.org/postgis/ticket/3699 This] is the only online forum I could find with others who have faced a similar issue.		[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==		==Geocode Function==

@@ Line 138: / Line 138: @@
 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.