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

[Stephen Woodbridge]

PostGIS has address_standardizer extension that includes parse_address() 
and standardize_address() functions.

-Steve W

On 4/24/2020 9:54 PM, Imre Samu wrote:
> > handle addresses in postgresql
>
> maybe you can use the https://github.com/openvenues/libpostal library
> with your favorite language bindings ( Python / Ruby / Go / PHP / Node 
> / R / Java  ...)
>
> or as a Postgres database extension:
> https://info.crunchydata.com/blog/quick-and-dirty-address-matching-with-libpostal
> https://github.com/pramsey/pgsql-postal
>
> Regards,
>  Imre
>
>
>
>
> Shaozhong SHI <shishaozhong at gmail.com <mailto:shishaozhong at gmail.com>> 
> ezt írta (időpont: 2020. ápr. 25., Szo, 2:49):
>
>     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
>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users