Talk:Houston Innovation District

From edegan.com
Jump to navigation Jump to search

Joe, 10/12 and 10/13:

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.

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