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

[Shaozhong SHI]

Thanks to everyone.

Steve W, at the moment, I will be interested in exploring SQL regexp to
handle addresses.  It will be useful, if we can also deal with minor human
errors in the addresses.

Regards,

Shao

On Sat, 25 Apr 2020 at 05:09, Stephen Woodbridge <
stephenwoodbridge37 at gmail.com> wrote:

> And I have create an address-standardizer project here
> https://github.com/woodbri/address-standardizer which is user
> configurable. I might be over kill is you just want to strip off the
> number, in which case you might just use a SQL regexp replace to remove it.
>
> -Steve W
>
> On 4/25/2020 12:04 AM, Stephen Woodbridge wrote:
> > 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
> >
>
> _______________________________________________
> 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/1495b070/attachment.html>