Changes

Jump to navigation Jump to search
no 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:
*'''Startups ''' (in [[Houston Entrepreneurship]])*'''Accelerators/Incubators ''' (in [[Houston Entrepreneurship]])*'''Entrepreneurship Ecosystems ''' (in [[Houston Entrepreneurship]])*'''Small Business ''' (in [[Houston Entrepreneurship]])*'''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)*15 best cafes '''Cafes in Houston ''' (Projects\Innovation Districts\Houston Startup Ecosystem\Files to Geocode)*'''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)*Sales (inProjects\Innovation Districts\Houston Startup Ecosystem\Files to Geocode)*'''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 dataInfo we are *'''Houston NSF grants located in the process E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem*Risk preparedness: '''Houston floodmap''': (at http://www.harriscountyfemt.org/). In a study published just before Harvey, predictive maps were shown to be largely inadequate for predicting flooding locations: https://www.forbes.com/sites/trevornace/2017/09/18/fema-flood-maps-missed-claims-harvey-houston/#32e295be9938*Used GDP and employment statistics for measurements of '''Stability of gettingHouston'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)*'''Crime and Safety''' (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Safety)*Yelp data on cafes '''Cafes and restaurants ''' within the 610 loop- (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Restaurants and Coffee)
Unknown:
*Other R&D data in Houston
*Public Transportation
*Predictability of Houston's economy
*Government programs and benefits, how they differ in different areas of town (if they do differ)
*Risk preparedness
*Competition
=Understanding Innovation Districts===
*Factors relating to best Innovation Districts:
[[File:Factors for innovation district.png]]
*''Infrastructure and land as a platform for experimentation''
**'''Flexibility of space and infrastructure'''
**Zoning?
*''Placemaking to achieve critical mass of real estate and commercial activity and authentic sense of place''
**Location, location, location
*''Prioritize attention on city wide eco-system and development and networking''
**'''Current Government benefits to improve innovation ecosystem'''
**What would we ideally have to attract business?
*''Grow and support existing innovation firms and activity''
*''Manage externalities that arise''
**'''Competition?'''
*''Adapt through cycles''
**'''Predictability Stability of Houston's economy data?'''
Build the City's Innovation Brand
*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=
source: https://www.census.gov/quickfacts/fact/table/harriscountytexas,houstoncitytexas,US/PST045216
 
=Houston Development Incentives and Regulations=
*'''Historic Sites:''' http://www.houstontx.gov/ecodev/historic_site_tax_exemption.html
*'''Tax Abatements:''' Houston created a program that encourages new growth, new development, and new jobs: tax abatements. These abatements attempt to strengthen Houston’s existing competitive advantages, while augmenting Houston’s emerging markets. http://www.houstontx.gov/ecodev/tax_abatements.html. Projects that qualify have one of the following situations:
**A developer builds in a declining part of Houston, a place where the project increases job opportunities, reduces poverty, or redevelops an area.
**The rare situation when a developer requires an abatement to remain, expand, or locate, in Houston, a situation where Houston’s job and economic market is significantly strengthened by the developer’s presence.
**A company invests in real estate that serves the public. Such an investment could provide affordable housing or rejuvenate a blighted area.
*'''380 Agreements:''' To make loans and/or grants of public money and to provide personnel and/or services of the City of Houston for the purpose of promoting state or local economic development. Also accepts donations and contributions to fund this program. http://www.houstontx.gov/ecodev/380agreements.html. An eligible project must include:
**construction of substantial new real property improvements of at least $2,500,000 in value, or extensive renovation of existing improvements, on land owned or to be acquired by the applicant; and documented equity investment of at least $500,000 ( loans to the project and guarantees of third party financing do not qualify);
**and either: documented creation of at least 25 new full time jobs (40-hours per week), and retention of such jobs for a period of no less than five years; or creation of affordable housing or transitional housing, to be established by deed restrictions recorded in the Official Public Records of Real Property of the county in which the property is located.
*'''Texas Enterprise Zones:''' Areas of underinvestment, places of distress targeted for rejuvenation. Terms:
**This economic revival comes in the form of state sales and use tax refunds. These reimbursements are based on how much a company invests and the number of jobs a company creates. Job and investment requirements fall in the chart at http://www.houstontx.gov/ecodev/enterprise_zones.html
**Besides these investment requirements, a municipality must nominate the company to the state government. The city of Houston may nominate 9 areas every 2 years.
*'''Tax Increment Reinvestment Zones:''' Tax Increment Reinvestment Zones (TIRZs) are special zones created by City Council to attract new investment in an area. TIRZs help finance costs of redevelopment and encourage development in areas that would otherwise not attract sufficient market development in a timely manner. Taxes attributable to new improvements (tax increments) are set-aside in a fund to finance public improvements within the boundaries of the zone.
**Map at http://www.houstontx.gov/ecodev/tirz.html
 
 
=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.
*Standard deviation of monthly GDP for the last 16 years calculated for each metro area.
 
 
Also in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Houston stability measurements is "employment stability measures", which shows the variation in employment data since 1990 for the 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 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 employment 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&current_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.
 
Most Dangerous Areas:
#Midtown/Downtown by the intersection of 59 and 45: 65 total crimes in local area, 14 violent
#Main Downtown: 61 total crimes in local area, 5 violent
#Downtown by the intersection of 10 and 45: 47 total crimes reported in local area, 11 violent
#Midtown, where Elgin becomes Westheimer: 49 total crimes in local area, 10 violent
#Museum District: 45 total crimes in local area, 10 violent
#Greater Third Ward: 30 total crimes in local area, 10 violent
#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

Navigation menu