Normalizing internal addresses with non-numeric unit identifier strips unit identifier

[bpanulla]

Normalizing an address with an internal component that starts with a non-numeric character component strips out the internal component.

STE A

SELECT (addy).*
FROM normalize_address('100 E BROADWAY AVE STE A, TUCSON, AZ') AS addy;

Address	Pre-Dir	Street	Street Type	Post-Dir	Internal	Locality	State	Zip	parsed
100	E	BROADWAY	Ave	STE		TUSCON	AZ	t

BLDG C

SELECT (addy).*
FROM normalize_address('100 E BROADWAY AVE BLDG C, TUCSON, AZ') AS addy;

Address	Pre-Dir	Street	Street Type	Post-Dir	Internal	Locality	State	Zip	parsed
100	E	BROADWAY	Ave	BLDG		TUSCON	AZ	t

This works: BLDG 3C

SELECT (addy).*
FROM normalize_address('100 E BROADWAY AVE BLDG 3C, TUCSON, AZ') AS addy;

Address	Pre-Dir	Street	Street Type	Post-Dir	Internal	Locality	State	Zip	parsed
100	E	BROADWAY	Ave	BLDG 3C		TUSCON	AZ	t

[woodbri]

PAGC tools handle these.