<div dir="ltr">Hi:<div>Maybe this may help you:</div><div><br></div><div><a href="https://info.crunchydata.com/blog/quick-and-dirty-address-matching-with-libpostal">https://info.crunchydata.com/blog/quick-and-dirty-address-matching-with-libpostal</a><br></div><div><br></div><div>Good luck!</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El dom., 3 may. 2020 a las 13:50, Paul Ramsey (<<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Also, <br>
<br>
<a href="https://docs.google.com/presentation/d/1Fgc_2dzWAzT--HdMEiWj2fFLJNnpxPXmnYXx9Js3xjE/edit#slide=id.g6404bf8f4e_0_0" rel="noreferrer" target="_blank">https://docs.google.com/presentation/d/1Fgc_2dzWAzT--HdMEiWj2fFLJNnpxPXmnYXx9Js3xjE/edit#slide=id.g6404bf8f4e_0_0</a><br>
<br>
> On May 3, 2020, at 11:49 AM, Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> wrote:<br>
> <br>
> create extension address_standardizer<br>
> <br>
> <a href="https://postgis.net/docs/postgis_installation.html#installing_pagc_address_standardizer" rel="noreferrer" target="_blank">https://postgis.net/docs/postgis_installation.html#installing_pagc_address_standardizer</a><br>
> <br>
>> On May 3, 2020, at 11:43 AM, Jo <<a href="mailto:winfixit@gmail.com" target="_blank">winfixit@gmail.com</a>> wrote:<br>
>> <br>
>> It would help if you had a bigger sample of valid addresses.<br>
>> <br>
>> This may be a good starting point:<br>
>> <br>
>> (\d+)(\w*)(-)?(\d+)(\w*)(\s)([\w\s]+),\s?([\w\s]+),\s?([\w\s]+)<br>
>> <br>
>> <a href="https://pythex.org/?regex=(%5Cd%2B)(%5Cw*)(-)%3F(%5Cd%2B)(%5Cw*)(%5Cs)(%5B%5Cw%5Cs%5D%2B)%2C%5Cs%3F(%5B%5Cw%5Cs%5D%2B)%2C%5Cs%3F(%5B%5Cw%5Cs%5D%2B)&test_string=223A-5D%20Great%20Avenue%2C%20A%20City%2C%20Planet%20Earth&ignorecase=0&multiline=0&dotall=0&verbose=0" rel="noreferrer" target="_blank">https://pythex.org/?regex=(%5Cd%2B)(%5Cw*)(-)%3F(%5Cd%2B)(%5Cw*)(%5Cs)(%5B%5Cw%5Cs%5D%2B)%2C%5Cs%3F(%5B%5Cw%5Cs%5D%2B)%2C%5Cs%3F(%5B%5Cw%5Cs%5D%2B)&test_string=223A-5D%20Great%20Avenue%2C%20A%20City%2C%20Planet%20Earth&ignorecase=0&multiline=0&dotall=0&verbose=0</a>  <br>
>> <br>
>> Jo<br>
>> <br>
>> On Sun, May 3, 2020 at 2:30 PM Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:<br>
>> Hello,<br>
>> <br>
>> Any robust regex for searching out addresses?<br>
>> <br>
>> The text patterns is as follows:<br>
>> <br>
>> 223A-5D Great Avenue, A City, Planet Earth<br>
>> <br>
>> A robust regex needs to be constructed and tested.<br>
>> <br>
>> Any clue?<br>
>> <br>
>> Regards,<br>
>> <br>
>> Shao<br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
> <br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Roberto Andrade Fonseca<br></div>