Hi: Maybe this may help you: https://info.crunchydata.com/blog/quick-and-dirty-address-matching-with-libpostal
Good luck! El dom., 3 may. 2020 a las 13:50, Paul Ramsey (<[email protected]>) escribió: > Also, > > > https://docs.google.com/presentation/d/1Fgc_2dzWAzT--HdMEiWj2fFLJNnpxPXmnYXx9Js3xjE/edit#slide=id.g6404bf8f4e_0_0 > > > On May 3, 2020, at 11:49 AM, Paul Ramsey <[email protected]> > wrote: > > > > create extension address_standardizer > > > > > https://postgis.net/docs/postgis_installation.html#installing_pagc_address_standardizer > > > >> On May 3, 2020, at 11:43 AM, Jo <[email protected]> wrote: > >> > >> It would help if you had a bigger sample of valid addresses. > >> > >> This may be a good starting point: > >> > >> (\d+)(\w*)(-)?(\d+)(\w*)(\s)([\w\s]+),\s?([\w\s]+),\s?([\w\s]+) > >> > >> > https://pythex.org/?regex=(%5Cd%2B)(%5Cw*)(-)%3F(%5Cd%2B)(%5Cw*)(%5Cs)(%5B%5Cw%5Cs%5D%2B)%2C%5Cs%3F(%5B%5Cw%5Cs%5D%2B)%2C%5Cs%3F(%5B%5Cw%5Cs%5D%2B)&test_string=223A-5D%20Great%20Avenue%2C%20A%20City%2C%20Planet%20Earth&ignorecase=0&multiline=0&dotall=0&verbose=0 > > >> > >> Jo > >> > >> On Sun, May 3, 2020 at 2:30 PM Shaozhong SHI <[email protected]> > wrote: > >> Hello, > >> > >> Any robust regex for searching out addresses? > >> > >> The text patterns is as follows: > >> > >> 223A-5D Great Avenue, A City, Planet Earth > >> > >> A robust regex needs to be constructed and tested. > >> > >> 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 -- Roberto Andrade Fonseca
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
