Also as mentioned before, this is a rewrite of the address standardizer
and it is much easier to use and customize and sample config files for
25 countries:
https://github.com/woodbri/address-standardizer
If you are trying to write a geocoder I have open sourced the imaptools
geocoder which you can find here:
https://github.com/woodbri/imaptools.com
Start by reading these:
https://github.com/woodbri/imaptools.com/blob/master/README-geocoder-design.md
https://github.com/woodbri/imaptools.com/blob/master/README-geocoder.md
Sorry things are a little chaotic because I just dumped all my code up
here, but I have been documenting stuff in README files and trying to
reorg things to make more sense.
-Steve
On 5/11/2020 12:30 PM, Paul Ramsey wrote:
It's not an easy problem. There is no one guaranteed magic bullet.
Use the address_standardizer extension, particularly for north american
addressing.
https://postgis.net/docs/postgis_installation.html#installing_pagc_address_standardizer
Or use an ML trained standardizer like this one.
https://github.com/pramsey/pgsql-postal
Or gate out to a geocoding service using a web service call.
https://docs.google.com/presentation/d/1Fgc_2dzWAzT--HdMEiWj2fFLJNnpxPXmnYXx9Js3xjE/edit
To handball some fuzzy stuff, use the functions in the postgresql contrib
module,
create extension fuzzystrmatch;
The python utility is really just using different ratios of string length and
levenstein distance, it ain't rocket science.
P.
On May 11, 2020, at 9:24 AM, Shaozhong SHI <[email protected]> wrote:
Hello,
I got a few questions as follows:
1. Which one is the best way for Fuzzy Address Matching?
2. FME FuzzyStringComparer uses Python difflib module. Which one in Postgres
is equivalent or similar to it?
3. Often, addresses collected by different people may well be correct. But,
there may be typing errors, or addresses are composed not in a consistent
manner.
For instance, South Great Avenue, A City, Planet Earth may be put down as the
following:
S. Great Aveue, City A, Earth Planet
Great Avene South, A City, Earth Planet
Great Avenue S, A City, Planet Earth
Surely, there would be solutions to deal with this problem.
Can anyone enlighten me?
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
