[postgis-devel] [PostGIS] #1355: Normalizing internal addresses with non-numeric unit identifier strips unit identifier
PostGIS
trac at osgeo.org
Wed Dec 7 13:03:37 PST 2011
#1355: Normalizing internal addresses with non-numeric unit identifier strips unit
identifier
----------------------------+-----------------------------------------------
Reporter: bpanulla | Owner: robe
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.0.0
Component: tiger geocoder | Version: trunk
Keywords: |
----------------------------+-----------------------------------------------
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||
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1355>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list