353
edits
Changes
Jump to navigation
Jump to search
*'''Write functions to simplify SQL code.'''
*'''Condense Address Information'''
The address information extracted from addrline1, addrline2 and city is not consistent. For example, the postcode extracted from addrline1 may be different from that extracted from city.
Examples:
| postcode | postcode_addr1 | postcode_addr2 | postcode_city
| 77042 | 77251-1407 | |
| 83716-9632 | | 83707-0006 |
| 90045 | 90080-0028 | |
(postcode_city is the postcode extracted from 'city'; postcode_addr1 is the postcode extracted from 'addrline1'; postcode_addr2 is the postcode extracted from 'addrline2'.)
Patent Assignment Data Restructure (view source)
Revision as of 17:54, 12 April 2017
, 17:54, 12 April 2017→Issues
====Issues====
*'''Inconsistency between 'addrline' and 'country' '''
