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(in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Restaurants and Coffee)
walkability scores
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
=Data Summary=
Doc with summary of info: https://docs.google.com/a/rice.edu/document/d/17iorMk9KeQV5UJmzGFvBiwKk20sybvAJDeFvbkNzpfw/edit?usp=sharing
Info we have:
*'''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
*'''Government programs and benefits''' (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Houston_Development_Incentives_and_Regulations)
*'''Crime and Safety''' (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Safety)
Unknown:
*Note: Using yelp data (and regressing things like reviews, new businesses and locations) havard business was able to project (with 30% correlation) the economic growth on a granular scale: http://www.hbs.edu/faculty/Publication%20Files/18-022_0bb9b749-f275-41ff-899c-afd9109568ee.pdf
**We may be able to produce something similar but less developed using density of restaurants in houston to find entrepreneurial / growth hotspots
==Yelp API==
Yelp does provide an API for 3rd party developers, and documentation is available [https://www.yelp.com/developers/documentation/v2/overview here].
However, the API limits the search results to 40 for any geographically oriented search. This is hardly a dataset, so we are going to crawl.
==Yelp Crawler==
The code for the crawler can be found here:
E:\McNair\Software\YelpCrawler\yelp_crawl.py
The script runs a search on Restaurants and Coffeeshops in Houston within the 610 Loop. There are 992 results for restaurants, and 270 results for coffeeshops. The data can be found in:
E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Restaurants and Coffee
=Educational Attainment=
=Predictability /stability of Houston's economy=
File listing Metro area GDP for Houston, DFW, Chicago, New York, and LA metro areas located in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Houston stability measurements. To measure differences *Standard deviation of monthly GDP for the last 16 years calculated for each metro area. Also in economic E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Houston stability between these citiesmeasurements is "employment stability measures", I calculated which shows the variation in employment data since 1990 for the standard metro areas Houston, DFW, New York, Los Angeles, and Chicago.*Standard deviation of monthly employment totals, and monthly unemployment rates for the past 27 years calculated for each city's metro area sources: *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 the last 16 yearsemployment data: https://www.bls.gov/lau/metrossa.htm
=Safety=
==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. 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 is saved in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Files for Geocoding as well. See http://mcnair.bakerinstitute.org/wiki/Talk:Houston_Innovation_District
Unsure of how to collect large quantities of this data. Maps below contain relevant info but not in a downloadable format. Many large cities have comprehensive crime addresses listed on https://catalog.data.gov/dataset?tags=crime, but Houston doesn't.
*Map of crimes in each area of Houston: https://www.crimereports.com/home/#!/dashboard?lat=29.73278125282416&lng=-95.31875610351562&zoom=12&incident_types=Assault%252CAssault%2520with%2520Deadly%2520Weapon%252CBreaking%2520%2526%2520Entering%252CDisorder%252CDrugs%252CHomicide%252CKidnapping%252CLiquor%252COther%2520Sexual%2520Offense%252CProperty%2520Crime%252CProperty%2520Crime%2520Commercial%252CProperty%2520Crime%2520Residential%252CQuality%2520of%2520Life%252CRobbery%252CSexual%2520Assault%252CSexual%2520Offense%252CTheft%252CTheft%2520from%2520Vehicle%252CTheft%2520of%2520Vehicle&start_date=2017-10-05&end_date=2017-10-19&days=sunday%252Cmonday%252Ctuesday%252Cwednesday%252Cthursday%252Cfriday%252Csaturday&start_time=0&end_time=23&include_sex_offenders=false¤t_tab=map&shapeIds=&shape_id=false
*Another map: https://www.neighborhoodscout.com/tx/houston/crime
This map shifts quite a bit depending on the time period you look at. I looked at Crime report data from Oct 5-19, 2017.
#Wesleyan and Richmond: 30 total crimes in local area, 2 violent
#East of downtown, but the Gus Wortham Golf Course: 27 total violent crimes in local area, 5 violent
