Changes

2017-07-14: used data from links in "Industry breakdown by GDP..." in E:\McNair\Projects\Houston\Industries to create Excel charts of Houston employment & Gross Area Product broken down by industry. Saved charts in the same folder. Energy, health, and (for employment data) IT sectors were emphasized, in line with the goal of communicating the idea that, as substantial parts of the Houston economy, those industries will benefit from supporting local startups. Looked up example charts in the file 2017ReportV1 in E:\McNair\Projects\Houston\Houston Ecosystem Recommendations, both for ideas for future charts, and to get a an idea of quantitative VC data in Houston. Fixed typos, improved incomplete keys. Cleaned the file Venture Funds in E:\McNair\Projects\Houston\VCData: added research on funds declared dead to make sure they actually are. Double checked that all firms in the master list were accounted for in the grouped list of VC firms.

2017-08-24: For xpath project, added cpc_subclass, cpc_main-group, and cpc_subgroup to Patent Schema Reconciliation text.txt in E:\McNair\Projects\SimplerPatentData\data\examples\Patent Schema Reconciliation. Began listing an exhaustive set of example types for different types and versions of classification_national_class in [[Equivalent XPath and APS Queries]]. 2017-08-25: For xpath project, added classification_national_country and classification_national_class xpaths to Patent Schema Reconciliation text.txt in E:\McNair\Projects\SimplerPatentData\data\examples\Patent Schema Reconciliation. Continued listing an exhaustive list of example types for the different types and versions of classification_national_class in [[Equivalent XPath and APS Queries]]. 2017-09-05: For xpath project, added primary_examiner_first_name xpaths to Patent Schema Reconciliation text.txt in E:\McNair\Projects\SimplerPatentData\data\examples\Patent Schema Reconciliation. Listed an exhaustive set of example types for primary_examiner_first_name in [Equivalent XPath and APS Queries]]. Did the same for primary_examiner_last_name, primary_examiner_department, and number_of_claims. 2017-09-07: For xpath project, corrected example types that mistakenly contained quotation marks in [[Equivalent XPath and APS Queries]]. Only kept quotation marks when they appeared in the patent text itself. Added, in the citations category, sequence, last_name, and first_name to Patent Schema Reconciliation text.txt in E:\McNair\Projects\SimplerPatentData\data\examples\Patent Schema Reconciliation. I also listed an exhaustive set of examples for sequence, last_name, and first_name in [[Equivalent XPath and APS Queries]]. Also Listed orgname fov v4.5 on [[Equivalent XPath and APS Queries]].  *Note: [[Equivalent XPath and APS Queries]] indicates that all entries under the citations header are strings. Assuming strings are indicated by quotation marks, only sequence appears to be a string. 2017-09-08: For xpath project, added notes on [[Equivalent XPath and APS Queries]] titled "Notes for Joe to remember". Listed orgname xpaths for citations, discovered that the citations and inventors section were effectively identical. Orgname still needs to be added to Patent Schema Reconciliation text.txt. 2017-09-012: Continued on xpath project. Finished citations section; still need to check which types and versions had entries for city, country, and state, under assignments. Still need to complete lawyers section as well. 2017-09-14: Finished listing xpaths for "lawyer" section (appears as "agent" in text files in E:\McNair\Projects\SimplerPatentData\data\examples\granted) in [[Equivalent XPath and APS Queries]]. With it, every xpath we're interested in in E:\McNair\Projects\SimplerPatentData\data\examples\granted is now listed in [[Equivalent XPath and APS Queries]], for each type and version, with relevant examples. Still need to add some of these xpaths to the file Patent Schema Reconciliation text.txt in E:\McNair\Projects\SimplerPatentData\data\examples\Patent Schema Reconciliation. 2017-09-15: Edited mistaken xpaths. Discovered that inventors and citations are indeed two different sections, with inventors only existing for v4.3-v4.5. They are not different headers referencing the same information. The ''inventors'' section appears only to exist under v4.3-v4.5, and the xpath for ''citations'' is parties/applicants/applicant (for v4.0-v4.2), or (for v4.3-v4.5) us-parties/applicants/applicant. Checked xpaths and listed under all sections. Xpaths still need to be added to the text file Patent Schema Reconciliation text.txt in E:\McNair\Projects\SimplerPatentData\data\examples\Patent Schema Reconciliation. 2017-09-19: Added xpaths on [[Equivalent XPath and APS Queries]] to Patent Schema Reconciliation text.txt, which hasn't been updated in a while. The xpaths for [[Equivalent XPath and APS Queries]] are complete for granted v4.0-v4.5. Added city and state under the citations header from the wiki page to the text file. 2017-09-20-21Category: Added xpaths to Patent Schema Reconciliation text.txt from [[Equivalent XPath and APS QueriesWork Log]], completed all up to assignment org name. Finished listing the xpaths under assignments for the text file, and with it, all the granted xppaths are now listed in the text file. I still need to check them thoroughly. 2017-09-22: Checked xpaths for granted, made corrections for mistakes in the text file and McNair.  To-do notes: For the assignment file in E:\McNair\Projects\SimplerPatentData\data\examples, list the XML and an example for 1 instance of every node of information. Don't need to list repeats,just every unique xpath with its corresponding example. pgs 27-28 of https://www.uspto.gov/sites/default/files/documents/USPTO_Patents_Assignment_Dataset_WP.pdf have good definitions. 2017-09-26: Created a text file with XML of every unique piece of information in the assignment file in E:\McNair\Projects\SimplerPatentData\data\examples. Saved file as ______ in the same folder. user: normal; pass: First 4 digits are normal, then the next favorite number-8. On [[Augusta Startup Ecosystem]], completed numbers 2 and 3 under "Tasks..." 2017-09-28: Created slides listing info on Augusta from the wiki page. Saved in E:\McNair\Projects\Innovation Districts\Augusta Startup Ecosystem, called "Joe Augusta". Merged with Dylan's slides. Still need to add more info, make cleaner. Edited Augusta Ecosystem page. Added chart from augmaster excel file in E:\McNair\Projects\Innovation Districts\Augusta Startup Ecosystem\NIH NSF Clinical Trials for Georgia by Zip to Augusta Powerpoint. 2017-10-03: On http://mcnair.bakerinstitute.org/wiki/Augusta_Startup_Ecosystem: *Added sections: **Augusta Incubators section: added Clubhou.se, with a list of corporate sponsors. If info if I could find any on how they supported clubhou.se.**Augusta Innovation Zone**UNISYS presecne**Booz Allen Hamilton presence*On powerpoint, added slide on Clubhouse.se & Augusta Innovation Zone. Saved as Augusta_Innovation_District_10.03 in E:\McNair\Projects\Innovation Districts\Augusta Startup Ecosystem. 2017-10-15: see http://mcnair.bakerinstitute.org/wiki/Talk:Augusta_Startup_Ecosystem 2017-10-19: see http://mcnair.bakerinstitute.org/wiki/Talk:Houston_Innovation_District. 2017-10-20: see http://mcnair.bakerinstitute.org/wiki/Talk:Houston_Innovation_District. 2017-10-26: Continued working on [[Patent Schema Reconciliation]]. Added XMLs under citations header. Added 7 XMLs; checked for different types and versions. See http://mcnair.bakerinstitute.org/wiki/Equivalent_XPath_and_APS_Queries#Citations. See [[Talk:Houston Innovation District]]. 2017-10-27: cleaned "addresses of all Houston crimes 2016" completely. Made changes on the google docs summarizing our work. 2017-10-31: Checked applicants entries for XML project. Corrected google docs for Houston Innovation district. Cleaned lease/sales info in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Location data. Created cleaned lease data with prices, cleaned sales data with prices. Copied data into "Adresses with more info" in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem. Copied "addresses of all Houston crimes 2016" into E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Files for Geocoding. 2017-11-3: Moved "Cleaned lease data with prices" into E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Files for Geocoding. Did the same for "cleaned sales data with prices". Added a section on the google docs for Houston Innovation District for Office Space for Lease. To measure cost of living (median income in Houston lower than US median), collected CPI data from Bureau of Labor Statistics. See "Median Income" section on https://docs.google.com/document/d/17iorMk9KeQV5UJmzGFvBiwKk20sybvAJDeFvbkNzpfw/edit.