Vcdb4 - Revision history

Ed at 17:46, 21 September 2020

2020-09-21T17:46:27Z

2020-09-21T17:34:27Z

2020-09-20T16:29:16Z

2020-02-25T17:09:18Z

2019-10-10T23:35:34Z

2019-10-09T21:18:29Z

Agglomeration

2019-10-09T19:11:04Z

2019-10-08T17:51:09Z

Tiger Places

2019-10-08T17:48:53Z

2019-10-08T17:41:21Z

Additions

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data,Tool,How-to
 |Has sponsor=Kauffman Incubator Project
 |Has title=vcdb4

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=Kauffman Incubator Project
 |Has title=vcdb4

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=vcdb4
 |Has owner=Ed Egan,

@@ Line 28: / Line 28: @@
 and others.
-The build should be done as quickly but cleanly as possible, as it is needed right away but also will likely need to be updated in January of 2020 to reflect 2019's year end.
+The build should be done as quickly but cleanly as possible, as it is needed right away but also will likely need to be updated in January of 2020 to reflect 2019's year-end.
 ==SDC Platinum Requests==

@@ Line 209: / Line 209: @@
 **Agglomeration!
 **Note: Needs updating to reflect latest decisions
 To this end, the base tables, which are used by multiple different projects, are built in BuildBaseTables.sql
 ==Agglomeration==
@@ Line 219: / Line 227: @@
 A new Ranking.sql file was created in E:\projects\vcdb4 and run.

@@ Line 214: / Line 214: @@
 ==Agglomeration==
-This build supports the [[Urban Start-up Agglomeration and Venture Capital Investment]] paper. It uses the sql script: AgglomerationVcdb4.sql, which is in E:\projects\agglomeration. The notes are here: [[
+This build supports the [[Urban Start-up Agglomeration and Venture Capital Investment]] paper. It uses the sql script: AgglomerationVcdb4.sql, which is in E:\projects\agglomeration. The notes are here: [[Urban_Start-up_Agglomeration_and_Venture_Capital_Investment#vcdb4]]
 ==Ranking==
 A new Ranking.sql file was created in E:\projects\vcdb4 and run.

@@ Line 181: / Line 181: @@
 We will use the old Tiger Places, but it is worth exploring how to rebuild this from scratch. First, visit https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html. Then download each state's place file. Load them and merge them. See [[PostGIS_Installation#Bulk_Download_TIGER_Shapefiles]] for more information. It is also worth reading the [[Tiger Geocoder]] and [[Jeemin Sim (Work Log)]].
 We also might need to add:
-*Tigerplaces (see MiscTasks.SQL or Agglomeration.sql in E:\vcdb3\OriginalSQL)
+*Accelerator data? (See CohortPortCoMatch.sql for doing the portco matching) -- this might be in its own dbase
 *GSP (see Adding GDP.sql)
 *Industry, Firm type, Firm stage and other lookups (see MatchingEntreps.sql)

@@ Line 110: / Line 110: @@
 The next phase is to standardize the names and match the portcos to the IPOs and MAs. Then clean up all of the core tables. That takes us to the end of the old LoadingScriptV1.sql. We then need to do the equivalent of updating GeoLoad.sql. This time, we are going to use the old data, as before, but try updating any portco or firm that doesn't have at least 4dp (11.1m resolution) or perhaps 5dp (1.11m resolution) accuracy [http://wiki.gis.com/wiki/index.php/Decimal_degrees]. We have to fix the PortCo keys first, but we can only run 2,500 queries through Google each day for free per API key, so this should be a batch job.
 ===Updating GeoCoding===
@@ Line 165: / Line 170: @@
 ===Additions===
-====Population===
+====Population====
 For now:

@@ Line 165: / Line 165: @@
 ===Additions===
 *The population table (see Population.sql)
 *The statepop2017 table (from States2017PopulationEstimate.txt, with DC (2018), GU (2017), and PR (2017) added.
 We also might need to add: