556
edits
Changes
Jump to navigation
Jump to search
=Startup Map=
'''Total Unique Startup Names: 1451'''
'''Total Unique Accelerator Names: 13'''
'''Houston Startup Sources:'''
*AngelList 500
**Joined 393
**Signal 394
**Total Raised 204
***Total Raised is actually made Redundant by the other 2 Angel List Pulls
*HoustonStartupsList 283
*StartupBlinkMap 379
*Startups-Accelerators 292
*SDC VC Houston Port Cos 493
*CrunchBase 116
*StartHouston 27
=Towards unique names=
Steps:
#Put all the names in one text file (done)
#Sort the file and removed exact dups using textpad (done)
#Run the matcher on that file in mode 2 (rerun)
#Clean that match file manually for idiosyncractic issues (rerun - only 2 problems)
#Load all 7 base files into a dbase
#Load the matchfile into the dbase
#Use SQL to get the unique names for each entry in a base file (7 queries)
#Assemble all of the common variables together taking the best available (somewhat subjective) in SQL, and add the extra vars.
#Output the new master file to work with!
=Necessary Categories to include in each individual Wiki page=
*Name
*Location
*Desc
*accelerator (if available)
==Optional Categories==
*Contact info
*Cohort of accelerator
*Industry
=To Do=
Nexp Steps:
*Standardize names
*Match up SQL tables
*Use URLs to find missing addresses
**Does it matter if website now reroutes to new URL?
*Remove non Houston Startups
*Import into Individual Wiki Pages
*Import into Map
*Repeat Process with:
**Accelerators
**Angels
**Incubators
**Angel Groups
**Venture Capital
**Service Firms
**Co-Working Spaces
**Event Spaces
=Future=
Possible Expansions:
*Calendar that correlates with the map
*Proximity measures & Microgeography
*Weak/Strong Areas in Houston for Entrepreneurship
*Comparing accelerators based on funding
**https://www.propublica.org/
Talk:Start-Ups of Houston (Map) (view source)
Revision as of 13:00, 5 July 2016
, 13:00, 5 July 2016Created page with " =Startup Map= '''Total Unique Startup Names: 1451''' '''Total Unique Accelerator Names: 13''' '''Houston Startup Sources:''' *AngelList 500 **Joined 393 **Signal 394 **To..."
=Startup Map=
'''Total Unique Startup Names: 1451'''
'''Total Unique Accelerator Names: 13'''
'''Houston Startup Sources:'''
*AngelList 500
**Joined 393
**Signal 394
**Total Raised 204
***Total Raised is actually made Redundant by the other 2 Angel List Pulls
*HoustonStartupsList 283
*StartupBlinkMap 379
*Startups-Accelerators 292
*SDC VC Houston Port Cos 493
*CrunchBase 116
*StartHouston 27
=Towards unique names=
Steps:
#Put all the names in one text file (done)
#Sort the file and removed exact dups using textpad (done)
#Run the matcher on that file in mode 2 (rerun)
#Clean that match file manually for idiosyncractic issues (rerun - only 2 problems)
#Load all 7 base files into a dbase
#Load the matchfile into the dbase
#Use SQL to get the unique names for each entry in a base file (7 queries)
#Assemble all of the common variables together taking the best available (somewhat subjective) in SQL, and add the extra vars.
#Output the new master file to work with!
=Necessary Categories to include in each individual Wiki page=
*Name
*Location
*Desc
*accelerator (if available)
==Optional Categories==
*Contact info
*Cohort of accelerator
*Industry
=To Do=
Nexp Steps:
*Standardize names
*Match up SQL tables
*Use URLs to find missing addresses
**Does it matter if website now reroutes to new URL?
*Remove non Houston Startups
*Import into Individual Wiki Pages
*Import into Map
*Repeat Process with:
**Accelerators
**Angels
**Incubators
**Angel Groups
**Venture Capital
**Service Firms
**Co-Working Spaces
**Event Spaces
=Future=
Possible Expansions:
*Calendar that correlates with the map
*Proximity measures & Microgeography
*Weak/Strong Areas in Houston for Entrepreneurship
*Comparing accelerators based on funding
**https://www.propublica.org/
