Difference between revisions of "Ranking US Cities by Venture Capital"

From edegan.com
Jump to navigation Jump to search
Line 18: Line 18:
 
However, the cities database takes vc data from '''vcdb2'''. See [[VC Database Rebuild]] for information on the build.
 
However, the cities database takes vc data from '''vcdb2'''. See [[VC Database Rebuild]] for information on the build.
  
The output from vcdb2 is ???
+
The output from vcdb2 is '''roundleveloutput2''', which is exported as roundleveloutput2.txt
 +
 
 +
roundleveloutput2.txt is imported into cities as '''roundleveloutput2''', and then left joined with '''populationtablecorrected'''. This is done in last.population.sql, which is in
 +
Z:\Hubs\2017\sql scripts

Revision as of 19:28, 13 September 2017


McNair Project
Ranking US Cities by Venture Capital
Project logo 02.png
Project Information
Project Title Ranking US Cities by Venture Capital
Owner Ed Egan
Start Date Summer 2017
Deadline
Primary Billing
Notes
Has project status Active
Copyright © 2016 edegan.com. All Rights Reserved.


Files and data

The files are in:

E:\McNair\Projects\Ecosystem\Ranking

The main SQL file is:

Ranking.sql

This file works on the database cities.

However, the cities database takes vc data from vcdb2. See VC Database Rebuild for information on the build.

The output from vcdb2 is roundleveloutput2, which is exported as roundleveloutput2.txt

roundleveloutput2.txt is imported into cities as roundleveloutput2, and then left joined with populationtablecorrected. This is done in last.population.sql, which is in

Z:\Hubs\2017\sql scripts