7,612
edits
Changes
Jump to navigation
Jump to search
*'''Sales''' (inProjects\Innovation Districts\Houston Startup Ecosystem\Files to Geocode)
Info we are in the process of getting:*Yelp data on '''Cafes and restaurants''' within the 610 loop- Peter*'''Crime and Safety''' (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Safety)*Yelp data on '''Cafes and restaurants''' within the 610 loop- We have maps (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Restaurants and some summaries, but unsure of how to collect this data in an efficient manner. Needs help!Coffee)
To geocode these, we can use the first number listed: for example, the above address would be geocoded as 5200 Canal St.
Houston Innovation District (view source)
Revision as of 13:39, 21 September 2020
, 13:39, 21 September 2020no edit summary
{{Project|Has project output=Content|Has sponsor=McNair ProjectsCenter
|Has title=Houston Innovation District
|Has owner=Ben Baldazo, Dylan Dickens, Joe Reilly, Taylor Jacobe, Anne Dayton,
|Has start date=9/20/2017
|Has deadline=10/27/2017
|Has project status=Active
|Does subsume=Houston Entrepreneurship,
}}
=Project Summary=
Mayor of Houston has asked us to make recommendations about how to create an innovation district in Houston
*'''VC''' (in 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.
*'''Patents in Houston''' (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem > HoustonPatents.txt)
*'''Office Space'''(for sale and lease): Info on largest office spaces available (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Location dataand Projects\Innovation Districts\Houston Startup Ecosystem\Files to Geocode. Additional files with prices included in both folders.)
*'''US median income''' for 2000 and (estimated) for 2015 (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Location data)
*'''Educational Attainment''' (in section below)
*'''Houston Industry Breakdown''' (in 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.])
*'''Grant Data''' (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Texas Federal Grant Data. Can filter by county/city)
*'''Preliminary map''': Dylan aggregated the geocoded data for VC Firms, Accelerators, Incubators, University Accelerators, Hubs, and startups into one CSV saved in the Houston Innovation Districts folder called VC Firms, Institutions, Startups Geocoded. Quickly put together this preliminary map as a starting point. The institutions, vc firms, and startups are blue dots, and I layered the bike lane shapefile as purple lines and park shapefile as green polygons on top. Shapefiles are in the Shapefiles folder in the Houston innovation District folder
*'''Public Transportation''' maps 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. (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Predictability_of_Houston.27s_economy)
*'''Government programs and benefits''' (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Houston_Development_Incentives_and_Regulations)
Unknown:
E:\McNair\Software\YelpCrawler\yelp_crawl.py
The script runs a search on Restaurants and Coffeeshops in Houston within the 610 Loop. There are 2615 992 results. The results are currently being compiled into text filesfor restaurants, and the search will be rerun 270 results for coffeeshops. Stay tuned.The data can be found in: E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Restaurants and Coffee
=Educational Attainment=
==Houston police monthly archives==
On http://www.houstontx.gov/police/cs/crime-stats-archives.htm, there's an excel file for each month's crime report. A crime report lists the street name, block range, offense time, hour, and location type of each crime. This is the only list of Houston crimes with their location that I can find. An example entry Files saved in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Safety. "Addresses of all Houston crimes 2016" contains the address of every reported crime in 2016 in Houston; this file issaved in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Files for Geocoding as well. See http: Date Hour Offense Type Beat Premise BlockRange StreetName Type Suffix # offenses1/22/2016 11 Robbery 10H10 Convenience Store 5200-5299 CANAL ST - 1mcnair.bakerinstitute.org/wiki/Talk:Houston_Innovation_District
