=New Work=
==Files==
New files are in E:\projects\agglomeration
*agglomeration.sql -- new main sql file for vcdb3
*AgglomerationVcdb4.sql -- even newer main sql file for vcdb4
Contents of the Old Code subdirectory:
*Agglomeration.SQL -- This was the replacement code that was run when vcdb3 was made. We had to work through it to update the counts. Came from E:\projects\vcdb3\OriginalSQL\Agglomeration.SQL
*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
See also:
*[[Restoring vcdb3]]
*[[vcdb4]]
==vcdb4==
The two measures will have temporal variation as TIF areas vary over time and as hull areas vary over time.
==FilesAnalysis Exploration== ===Base specification for highest1hull=== ===Instrumenting highest1hull===
New files are The instrument on highest1hull needs to work in E:\projects\agglomeration*agglomerationitself, but we also need a consistent estimate of an effect for the population and for the 13 (or 10, etc.sql -- new main sql file for vcdb3*AgglomerationVcdb4) cities that we can instrument before we start.sql -- even newer main sql file for vcdb4
Contents of It looks like including year fixed effects in the Old Code subdirectory:*Agglomeration'standard' highest1hull spec is just too much.SQL -- This was the replacement code that was run when vcdb3 was made. We had to Excluding them looks like it might work through it to update the counts. Came from Ethough:\projects\vcdb3\OriginalSQL\Agglomeration reg growthinv17lf growthinv17l numdealsl numstartupsl avghullarea i.SQLplaceid if numlayers>=6 & layer==highest1hulllayer, robust*Agglomeration.sql -- Old version that makes colevel data for python script reg growthinv17lf growthinv17l numdealsl numstartupsl avghullarea i. Came from E:\mcnair\Projects\Agglomerationplaceid if numlayers>=6 & layer==highest1hulllayer & tifs==1, robust*Analysis reg avghullareal tifintareahm i.sql -- Old version builds from HCL forward. Came from E:\mcnair\Projects\Agglomerationplaceid if numlayers>=6 & layer==highest1hulllayer & tifs==1, robust
See also:
*[[Restoring vcdb3]]
*[[vcdb4]]
==CoLevelForCircles==