> 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 <[email protected]> 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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
