Revision as of 16:29, 23 June 2016

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!

Total Unique Startup Names: 1451

Total Unique Accelerator Names: 13

Houston Startup Sources:

Necessary Categories to include in each individual Wiki page

Optional Categories

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

Possible Expansions:

@@ Line 1: / Line 1: @@
+=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!
 =Startup Map=