Changes

Jump to navigation Jump to search
=====Postcode=====
Reminder: postcode_city is the postcode postcodes extracted from 'city'; postcode_addr1 is the postcode postcodes extracted from 'addrline1'; postcode_addr2 is the postcode postcodes extracted from 'addrline2'.
The postcode_city, postcode_addr1 and postcode_addr2 are consistent.
city | state | postcode_city | postcode
HAUPPAUGE, 11788-8847 | NEW YORK | 11788-8847 | 78759
 
SQL code is in:
 
Postcodes extracted from addrline1, addrline2 and city are stored in ptoassigneend_postcode.

Navigation menu