Changes

Jeemin Sim (Work Log) (view source)

Revision as of 12:50, 9 November 2017

91 bytes removed , 12:50, 9 November 2017

no edit summary

* Location of Bay Area Points png files:

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

2017-10-10:

*Discoveries/ Struggles regarding.gdb to .shp file conversion:

** Esri Production Mapping (costly)

*** License needs to be purchasesd: http://www.esri.com/software/arcgis/extensions/production-mapping/pricing

** Use ogr2ogr from gdal package

*** https://gis.stackexchange.com/questions/14432/migrating-geodatabase-data-into-postgis-without-esri-apps

*** Command: ogr2ogr -f "ESRI Shapefile" [Destination of shapefile] [path to gdb file]

*** Problem installing gdal

2017-10-09:

* TODO'S:

** Downloading data onto tigertest

*** Road

*** Railway

*** Coastline

*** Instructions: http://mcnair.bakerinstitute.org/wiki/PostGIS_Installation#Bulk_Download_TIGER_Shapefiles

** Configure census data from American Community Survey (ACS)

*** 1) Work out what data is of our interest (confirm ACS)

*** 2) Determine appropriate shape file unit:

**** census block vs. census block group vs. census track

*** 3) Load into tigertest

* Done:

** Downloaded data from https://www.census.gov/cgi-bin/geo/shapefiles/index.php

tl_2017_us_coastline -- 4209

tl_2017_us_primaryroads -- 11574

tl_2017_us_rails -- 176237

** Link found to potentially download ACS data: https://www.census.gov/geo/maps-data/data/tiger-data.html

*** But most files on it come with .gdb extension and not .shp

2017-10-03:

* Installed PostGIS & is now visible on pgAdmin III

* ArcGIS (connect to postgis database):

** 1) Open ArcMap

** 2) Either open blank or open existing file/project

** 3) Click on 'Add Data' button with a cross and a yellow diamond (under Selection toolbar)

** 4) Go to the top-most directory by pressing on the arrow that points left-then-up (on the left of home button)

** 5) Click on 'Database Connections'

** 6) Click on 'Add Database Connection' (if Connection to localhost.sde) does not exist already)

** 7) Fill in the following fields:

*** Database Platform: PostgreSQL

*** Instance: localhost

*** User name: postgres

*** Password:

*** Database: tigertest

** 8) Press 'OK'

** 9) Now you'll have 'Connection to localhost.sde' in your Database Connections

** 10) Double click on 'Connection to localhost.sde'

** 11) Double click on the table of interest

** 12) Click 'Finish'

** 13) You'll see information populated on map, as one of the 'Layers'

*** Tested with: tigertest.public.copointplacescontains

* On running & altering Oliver's script:

** Location: E:\McNair\Projects\OliverLovesCircles\src\python\vc_circles.py

** Ed manipulated file names so that underscores would replace dots (St.Louis --> St_Louis)

** Takes in instances and sweep times as part of the argument, but not impactful as those variables are hardcoded in the script

** Ran vc_circles.py with the following variables with changed values:

*** SWEEP_CYCLE_SECONDS = 10 (used to be 30)

*** NUMBER_INSTANCES = 16 (used to be 8)

** New output to be found in: E:\McNair\Projects\OliverLovesCircles\out

</onlyinclude>

*** https://www.gpsfiledepot.com/tutorials/installing-and-setting-up-postgresql-with-postgis/

*** http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01

~~====10/3/2017 TUESDAY ''10AM-12PM & 1PM-2:30PM''====~~