PostGIS

stdaddr

Prev

11.1.2. Address Standardizer Types

Next

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.

Prev

Up

Next

Chapter 11. PostGIS Extras

Home

rules table