Talk:Houston Innovation District
Joe, 10/12 and 10/13:
- see headers http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Location_data and http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Educational_Attainment.
- Copied Houston Industry breakdown into E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem("Houston Gross Area Product by Industry", "Houston employment share by industry" excel files and "Industry breakdown..." text file.
Notes on completed/uncompleted research:
- Grant data accessible in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Texas Federal Grant Data. Can filter by county/city.
- HoustonPatents is in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem.
10/17: Moved VC data info compiled mainly in summer 2017 to Houston Startup Ecosystem: E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\VCData. VC locations have already been geocoded. For a final map, use info in "VC firms with address, basic sector info" to match sector and size with each VC firm. Bigger VC firms who invest in more relevant sectors should be emphasized more.
10/19: Maps of Houston metro system saved in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Location data. Used GDP and employment statistics for measurements of stability of Houston's economy; compared to other Metro areas. Files detailed in http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Predictability_of_Houston.27s_economy.
- source for GDP data: https://www.bea.gov/itable/iTable.cfm?ReqID=70&step=1#reqid=70&step=1&isuri=1&7003=200&7035=-1&7004=naics&7006=16980,19100,26420,31080,35620&7001=2200&7036=-1&7002=2&7090=70&7007=-1&7093=levels
- source for employment data: https://www.bls.gov/lau/metrossa.htm
For http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Safety, found a link (http://www.houstontx.gov/police/cs/crime-stats-archives.htm) with monthly crime statistics and location. See http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Safety for details.
10/20: downloaded crime addresses, saved in text file. Unsuccessfully tried to separate just addresses from this file so it could be geocoded.
10/26: Cleaned addresses in text file a fair bit. Regex to use if pulling addresses from identical files:
find: \n[^\t]+\t[^\t]+\t[^\t]+\t[^\t]+\t[^\t]+\t replace with: \n
See "addresses of all Houston crimes 2016" in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Safety.
10/27: Cleaned "addresses of all Houston crimes 2016" file completely, saved in the same folder. Saved in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Files for Geocoding
