Hi, Steve, Many thanks. Please send me the link to parse_address() and standardize_address().
I need to find these first before test-running. Regards, Shao On Sat, 25 Apr 2020 at 21:20, Stephen Woodbridge < [email protected]> wrote: > Shao, > > '^( *Building *[0-9]+)?[- 0-9]*' > > or something like that should do it. But I think you will find that a > more robust solution is to use parse_address() and/or > standardize_address() as they will recognize a lot of other address > constructs, like "apt 3a" for for example. > > parse_address() that a text field and breaks it into "house number > street name" and "city state zip", but only works well in North America. > > standardize_address() that comes with postGIS, breaks the address down > into its components and can separate out things like buildings, and > apartment/unit specifiers so you can then take the fields you are > interested in and recombine just them in a new string. Again, this works > best in North America. > > My github address-standardizer is built to recognize address for most > counties, but it can also be configured to recognize address standards > for any county without too much effort. It compiles and installs as > postgresql extension. > > Addresses are generally very messy and unless your addresses are vary > simple you will be constantly fighting with this or that exception. > > -Steve > > On 4/25/2020 2:55 PM, Shaozhong SHI wrote: > > Is there a way to left trim including the building and number? > > > > Building 3 21-1 Great Avenue, a city, a country, this > > planet. > > > > How to take way those things which are too local to an address? > > > > Regards, > > > > Shao > > > > On Sat, 25 Apr 2020 at 01:48, Shaozhong SHI <[email protected] > > <mailto:[email protected]>> wrote: > > > > I find this is a simple, but important question. > > > > How best to split numbers and the rest of address? > > > > For instance, one tricky one is as follows: > > > > 21-1 Great Avenue, a city, a country, this planet > > > > How to turn this into the following: > > > > column 1, column 2 > > > > 21-1 Great Avenue, a city, a country, this planet > > > > Note: there is a hyphen in 21-1 > > > > Any clue? > > > > Regards, > > > > Shao > > > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
