7,612
edits
Changes
Jump to navigation
Jump to search
*Predictability of Houston's economy
*Risk preparedness
**Zoning?
File listing Metro Most Dangerous Areas: #Midtown/Downtown by the intersection of 59 and 45: 65 total crimes in local area GDP for Houston, DFW14 violent#Main Downtown: 61 total crimes in local area, Chicago5 violent#Downtown by the intersection of 10 and 45: 47 total crimes reported in local area, New York11 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 LA metro areas located in ERichmond:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Houston stability measurements. To measure differences 30 total crimes in economic stability between these citieslocal area, I calculated the standard deviation 2 violent#East of each city's GDP for downtown, but the last 16 years.Gus Wortham Golf Course: 27 total violent crimes in local area, 5 violent
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:
*'''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 data*'''Houston NSF grants located in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem*Risk preparedness: '''Houston floodmap''': (at http://www.harriscountyfemt.org/). But (in In a study published just before Harvey), predictive mpas 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 Houston's economy''' compared to other Metro areas. (at http://mcnair.bakerinstitute.org/wiki/Houston_Innovation_District#Predictability_of_Houston.27s_economy)Info we are in the process of getting*'''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- Peter*Government programs (in E:\McNair\Projects\Innovation Districts\Houston Startup Ecosystem\Restaurants and benefits, how they differ in different areas of town (if they do differCoffee)- Tay
Unknown:
*Other R&D data in Houston
*Competition
*''Infrastructure and land as a platform for experimentation''
**'''Flexibility of space and infrastructure'''
*''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=
=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¤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.
