7,613
edits
Changes
Jump to navigation
Jump to search
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)
*tiger2,CoPoints ST_Intersects -> colevelbase 29790
*colevelbase,years -> colevelblowout 221525, CoLevelSummary 35785, PlacesWithGT10Active 202
*colevelblowout,PlacesWithGT10Active -> '''CoLevelForCircles 173202'''
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 16:26, 13 June 2019
, 16:26, 13 June 2019no edit summary
New files are in E:\projects\agglomeration
*agglomeration.sql -- new main sql file uses vcdb3
Contents of the Old Code subdirectory:
*Agglomeration.sql -- Old version that makes colevel data for python script. Came from E:\mcnair\Projects\Agglomeration
*Analysis.sql -- Old version builds from HCL forward. Came from E:\mcnair\Projects\Agglomeration
===CoLevelForCircles===
Note: Make sure that the geocoding has been fixed first! See [[Restoring_vcdb3#Fix_the_Geocoding]].
The build is as follows:
*portcomaster 48001 (where hadgrowth=1 34761) and portcogeo (47715 where latitude and longitude NOT NULL 47715) -> colevelsimple 33869
*colevelsimple 33869-> CoPoints (adds point geoms)
*tigerplaces 29322 (has place geoms) -> tiger2 (adds areas)
*tiger2,CoPoints ST_Intersects -> colevelbase 29442
*colevelbase,years -> colevelblowout 219060, CoLevelSummary 35344, PlacesWithGT10Active 200
*colevelblowout,PlacesWithGT10Active -> '''CoLevelForCircles 171170'''
===HCA===
Take CoLevelForCircles.txt and feed it into the HCA script in
E:\projects\hca\main.py
See also:
