Changes

Jeemin Sim (Work Log) (view source)

598 bytes added , 17:41, 23 October 2017

no edit summary

* Location of Bay Area Points png files:

E:\McNair\Projects\Agglomeration\HarrisonPeterWorkArcGIS\Jeemin_Bay_Area Points_Every_Year

...

====10/23/2017 MONDAY''4PM-6PM''====

* Talked to Ed with Peter & Oliver about upcoming tasks & projects.

* Loaded acs_place table 2017 (does not contain population) on tigertest.

** SQL commands used:

DROP TABLE acs_place;

CREATE TABLE acs_place (

USPS varchar(5),

GEOID varchar(30),

ANSICODE varchar(30),

NAME varchar(100),

LSAD varchar(30),

FUNCSTAT varchar(10),

ALAND varchar(30),

AWATER varchar(30),

ALAND_SQMI varchar(30),

AWATER_SQMI varchar(30),

INTPTLAT varchar(30),

INTPTLONG varchar(30)

);

\COPY acs_place FROM '/bulk/2017_Gaz_place_national.txt';

--COPY 29578

[[Category:Work Log]]

337

edits