337
edits
Changes
Jump to navigation
Jump to search
====10/16/2017 MONDAY''4PM-6PM''====
* Exported maps of points from the Bay Area each year.
** Map used location: E:\McNair\Projects\Agglomeration\HarrisonPeterWorkArcGIS\Jeemin_Bay_Area Points_Every_Year\BayAreaEveryYearMap
** Zoom scale: 1:650.000
* 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
* TODO:
** Find acs place 2016 data for population
** Find larger acs files, ideally at the place level
** Provide more documentation on POSTGIS & geocoding
...
====10/30/2017 MONDAY''4PM-6PM''====
* Downloaded data from ACS, to be continued
* File path:
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data
* Fields of interest:
S1401 SCHOOL ENROLLMENT
S1501 EDUCATIONAL ATTAINMENT
S2301 EMPLOYMENT STATUS
B01003 TOTAL POPULATION
B02001 RACE
B07201 GEOGRAPHICAL MOBILITY
B08303 TRAVEL TIME TO WORK
B19013 MEDIAN HOUSEHOLD INCOME
B19053 SELF-EMPLOYMENT INCOME IN THE PAST 12 MONTHS FOR HOUSEHOLDS
B19083 GINI INDEX OF INCOME INEQUALITY
B25003 TENURE
B25105 MEDIAN MONTHLY HOUSING COSTS
B28011 INTERNET SUBSCRIPTIONS IN HOUSEHOLD
G001 GEOGRAPHIC IDENTIFIERS
====10/31/2017 TUESDAY''9AM-12PM''====
* Finished doanloading files from ACS.
* Started loading tables into tigertest.
* Commands run could be found in
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data\DataLoading_SQL_Commands.txt
...
no edit summary
*Python script location:
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data\pullCertainColumns.py
2017-10-31:
* Finished doanloading files from ACS.
* Started loading tables into tigertest.
* Commands run could be found in
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data\DataLoading_SQL_Commands.txt
2017-10-30:
* Downloaded data from ACS, to be continued
* File path:
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data
* Fields of interest:
S1401 SCHOOL ENROLLMENT
S1501 EDUCATIONAL ATTAINMENT
S2301 EMPLOYMENT STATUS
B01003 TOTAL POPULATION
B02001 RACE
B07201 GEOGRAPHICAL MOBILITY
B08303 TRAVEL TIME TO WORK
B19013 MEDIAN HOUSEHOLD INCOME
B19053 SELF-EMPLOYMENT INCOME IN THE PAST 12 MONTHS FOR HOUSEHOLDS
B19083 GINI INDEX OF INCOME INEQUALITY
B25003 TENURE
B25105 MEDIAN MONTHLY HOUSING COSTS
B28011 INTERNET SUBSCRIPTIONS IN HOUSEHOLD
G001 GEOGRAPHIC IDENTIFIERS
2017-10-23:
* 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
* TODO:
** Find acs place 2016 data for population
** Find larger acs files, ideally at the place level
** Provide more documentation on POSTGIS & geocoding
2017-10-16:
* Exported maps of points from the Bay Area each year.
** Map used location: E:\McNair\Projects\Agglomeration\HarrisonPeterWorkArcGIS\Jeemin_Bay_Area Points_Every_Year\BayAreaEveryYearMap
** Zoom scale: 1:650.000
* Location of Bay Area Points png files:
E:\McNair\Projects\Agglomeration\HarrisonPeterWorkArcGIS\Jeemin_Bay_Area Points_Every_Year
</onlyinclude>
*** Command: ogr2ogr -f "ESRI Shapefile" [Destination of shapefile] [path to gdb file]
*** Problem installing gdal
