PostGIS

stdaddr
Prev	14.1.2. Address Standardizer Types	Next

stdaddr

14.1.2. Address Standardizer Types

Name

stdaddr — A composite type that consists of the elements of an address. This is the return type for standardize_address function.

Description

A composite type that consists of elements of an address. This is the return type for standardize_address function. Some descriptions for elements are borrowed from PAGC Postal Attributes.

The token numbers denote the output reference number in the rules table.

check This method needs address_standardizer extension.

building: is text (token number 0): Refers to building number or name. Unparsed building identifiers and types. Generally blank for most addresses.
house_num: is a text (token number 1): This is the street number on a street. Example 75 in 75 State Street.
predir: is text (token number 2): STREET NAME PRE-DIRECTIONAL such as North, South, East, West etc.
qual: is text (token number 3): STREET NAME PRE-MODIFIER Example OLD in 3715 OLD HIGHWAY 99.
pretype: is text (token number 4): STREET PREFIX TYPE
name: is text (token number 5): STREET NAME
suftype: is text (token number 6): STREET POST TYPE e.g. St, Ave, Cir. A street type following the root street name. Example STREET in 75 State Street.
sufdir: is text (token number 7): STREET POST-DIRECTIONAL A directional modifier that follows the street name.. Example WEST in 3715 TENTH AVENUE WEST.
ruralroute: is text (token number 8): RURAL ROUTE . Example 7 in RR 7.
extra: is text: Extra information like Floor number.
city: is text (token number 10): Example Boston.
state: is text (token number 11): Example MASSACHUSETTS
country: is text (token number 12): Example USA
postcode: is text POSTAL CODE (ZIP CODE) (token number 13): Example 02109
box: is text POSTAL BOX NUMBER (token number 14 and 15): Example 02109
unit: is text Apartment number or Suite Number (token number 17): Example 3B in APT 3B.

Chapter 14. PostGIS Extras

Home

rules table