Geek Answers Handbook

How to compare different formatted addresses (php / mysql)

I am working on an installed mysql php web application with some pretty big data.

As part of data management procedures, new address data is added to the database (import) from two different sources.

All addresses for this data are from the UK.

The application used addressRecord.address1 = address1 AND addressRecord.postcode = postcodeas conflict detection before inserting a new address or linking a record to an existing address.

The problem is that the collision test is not final. Because two different data sources provided several different address formats.

source 1

    address1 = 'FLAT N, RICHMOND HILL GATE, 1'

    address2 = 'RICHMOND HILL DRIVE'

    address3 = 'BOURNEMOUTH'

    postcode = 'BH2 6LT'

source 2

    address1 = 'Flat N'

    address2 = 'Richmond Hill Gate'

    address3 = '1 Richmond Hill Drive'

    postcode = 'BH2 6LT'

, , , .

, ( ) , (10 ).

, , , , 3 , , , , ... .

+4
1

, @chris. , " " . . , , , : ; , ; ; , -, "W Churchill Ln" "Winston Churchill Lane". , , . , . , , , .

+1

More articles:


All Articles