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

[Stephen Woodbridge]

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
>