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

[Imre Samu]

> 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> 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
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200425/eddad1e7/attachment.html>