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 <[email protected]
<mailto:[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] <mailto:[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
