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

2021-01-09 Thread Shaozhong SHI
Hi, Steve, Many thanks. We are strongly interested in dealing with UK addresses. Last time, I passed on messages for testing. I was told not working for UK addresses. I will try it again. Anything else do we have to watch out for? Regards, David On Sat, 9 Jan 2021 at 15:53, Stephen Woodbr

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

2021-01-09 Thread Stephen Woodbridge
David, This is the link to the address standardizer: https://github.com/woodbri/address-standardizer This is a link to all my code that I developed consulting. It includes a few SQL geocoders based on the code above. And has some README files discussing how to build a geocoder which is the bas

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

2021-01-09 Thread Shaozhong SHI
Hi, Stephen, Please send me the link to libpostal. I also need information on how to instal it one PostGIS. I need the information to instruct our ICT staff, so that they can make it ready. Regards, David On Sat, 9 Jan 2021 at 15:04, Stephen Woodbridge < stephenwoodbridg...@gmail.com> wrote:

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

2021-01-09 Thread Shaozhong SHI
Hi, Stephen, Many thanks. We are interested in it is working with the UK addresses. Please send me the link to this. Regards, David On Sat, 9 Jan 2021 at 15:00, Stephen Woodbridge < stephenwoodbridg...@gmail.com> wrote: > David, > > Yup and this is just one a dozens of cases that you have to

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

2021-01-09 Thread Stephen Woodbridge
Or use libpostal as Komяpa suggested and I’m sure there are others also. I’m just familiar with my own code and the fact that I built it to work inside a postgresql database. Sent from my iPhone > On Jan 9, 2021, at 10:00 AM, Stephen Woodbridge > wrote: > > David, > > Yup and this is just

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

2021-01-09 Thread Stephen Woodbridge
David, Yup and this is just one a dozens of cases that you have to deal with. You are dealing with a natural language processing problem. And you have to deal with human input that has typos and abbreviations. These issues are what the address standardizer fixes. It tokenized the address and

[postgis-users] Testing and evaluating postal_parser

2021-01-09 Thread Shaozhong SHI
Has anyone tested and evaluated postal_parer? https://github.com/pramsey/pgsql-postal We will interested in hearing from you. Regards, David ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-

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

2021-01-09 Thread Komяpa
Hello, People make neural networks for this kind of task: https://github.com/openvenues/libpostal сб, 9 сту 2021, 12:40 карыстальнік Shaozhong SHI напісаў: > Hi, Steve W, > > it is easy to parse addresses as tokens. But it is difficult to put > tokens in right columns, due to that the same ad

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

2021-01-09 Thread Shaozhong SHI
Hi, Steve W, it is easy to parse addresses as tokens. But it is difficult to put tokens in right columns, due to that the same address could be expressed with partial address or full address. The same address can be written like, Flat 1 122 Great Avenue London UK, or Flat 1 122 Greet Avenue Cen