329
edits
Changes
Jump to navigation
Jump to search
no edit summary
#* Prior Example <code>E:\McNair\Software\Scripts\Patent\createTables.sql</code>
#* Aim to create a completely naive schema with as few constraints as possible--iteratively add more constraints in the future
== Address Data ==
* Question: "In which zipcodes are the most patents granted?"
* Zipcode granularity--if possible, finer detail wanted
* Filter non-US, null addresses
* Need to cleanup addresses
* Extract zipcode or reverse locate to find zip
== Related Pages ==
