7,613
edits
Changes
Jump to navigation
Jump to search
*Old Code\Agglomeration.sql -- Old version that makes colevel data for python script
*Old Code\Analysis.sql -- Old version builds from HCL forward
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 19:54, 27 May 2019
, 19:54, 27 May 2019→New Work
New files are in E:\projects\agglomeration
*agglomeration.sql -- new main sql file uses vcdb3
The build is as follows:
*portcomaster 48001 (where hadgrowth=1 34761) and portcogeo (44413 where latitude and longitude NOT NULL 44413) -> colevelsimple 32642
*colevelsimple 32640 -> CoPoints (adds point geoms)
*tigerplaces 29322 (has place geoms) -> tiger2 (adds areas)
*Old files are in Code\Agglomeration.SQL -- This was the replacement code that was updated with vcdb3 was made. We had to work through it to update the counts. Came from E:\mcnairprojects\vcdb3\ProjectsOriginalSQL\Agglomeration, especially:.SQL*Old Code\Agglomeration.sql-- Old version that makes colevel data for python script. Came from E:\mcnair\Projects\Agglomeration*Old Code\Analysis.sql-- Old version builds from HCL forward. Came from E:\mcnair\Projects\Agglomeration
See also:
*[[The Impact of Entrepreneurship Hubs on Urban Venture Capital Investment]]
*[[Restoring vcdb3]]
==Summary==
