[postgis-users] Various ways to handle addresses in postgresql

[Shaozhong SHI]

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 <shishaozhong at gmail.com> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200425/02bcbb7c/attachment.html>