353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:51, 10 April 2017
, 17:51, 10 April 2017→Extraction
END;
$$ LANGUAGE plpgsql;
Explanation:
adr is the feature from which you want to extract postcode.
* Extract State
ELSE NULL END AS result;
$$ LANGUAGE SQL;
Explanation:
adr is the feature from which you want to extract state.
* Extract City
$$ LANGUAGE SQL;
Explanation: adr is the feature from which you want to extract city. With these functions, we can generate ptoassigneend_us_extractptoassigneend_us_extracted, which is the final output in Section 2.2.1, with the following code: CREATE TABLE ptoassigneend_us_ ptoassigneend_us_extracted AS
SELECT *, ExtractPostcode(city) postcode_city,
ExtractPostcode(addrline1) postcode_addr1,
ExtractState(city) state_city,
ExtractState(addrline1) state_addr1,
ExtractState(addrline2) state_addr2,
ExtractCity(city) city_city,
ExtractCity(addrline1) city_addr1,
FROM ptoassigneend_missus;
All the SQL code can be foundis in: E:/McNair/Projects/PatentAddress/Functions.sql
===== Cleaning =====
