7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
[[Jeemin Sim]] [[Work Logs]] [[Jeemin Sim (WorkLog)|(log page)]]
===Spring 2018===
2017-01-11:
*Was briefed on [[Urban Start-up Agglomeration and Venture Capital Investment]]
*Going forward - running regressions in R in PostgreSQL and with desired layers (instead of levels)
===Fall 2017===
<onlyinclude>
2017-12-05:
* Uploaded tables with KML files in TIF folder in bulk(E:) drive
** Allegheny County
** Atlanta
** Chicago
** Columbus, OH
** Dublin, OH
** Vermont
** Washington, D.C.
*Updated documentation for:
** http://www.edegan.com/wiki/TIF_Project#Uploading_TIF_Data_onto_database_.28tigertest.29
* shp2pgsql needs to be installed to upload Shapefiles to PostgreSQL database
** applies for Houston, TX and Dallas, TX
** DONE
2017-12-04:
* To upload KML file into database with specified table name:
researcher@McNairDBServ:/bulk/tigertest$ ogr2ogr -f PostgreSQL PG:"dbname=tigertest" chicagotif.kml -nln chicagotif
* chicagotif table now resides in tigertest database
2017-11-30:
* Displayed map with TIF districts and startups
* Location:
E:\McNair\Projects\Agglomeration\TIF\McNair_Color_Chicago_TIF_and_startups.png
* Added information and steps to ArcMap/ArcGIS documentation page
* Create a project page for 'Working with POSTGIS' and add instructions for uploading KML file onto POSTGIS
** Command used :
*** Logged in as : researcher@McNairDBServ
/bulk/tigertest$ ogr2ogr -f PostgreSQL PG:"dbname=tigertest" chicagotif.kml
* chicago TIF kml file currently downloaded in tigertest with a table name of Layer0
** Figure out how to change layer name while loading kml file
** Instructions pulled from : http://wiki.wildsong.biz/index.php/Loading_data_into_PostGIS#Loading_data_from_KMZ_files
2017-11-28:
*** Railway
*** Coastline
*** Instructions: http://mcnairwww.bakerinstituteedegan.orgcom/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)
2017-09-26:
* Created a table that maps a state to the database name.
** http://mcnairwww.bakerinstituteedegan.orgcom/wiki/PostGIS_Installation#Translating_Table_names_to_corresponding_States
* Added more GIS-information (functions, realm & outliers to consider)
** http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Urban_Start-up_Agglomeration#GIS_Resources
* Visualization in PostGIS or connecting to ArcGIS for visualization (import/export data)
* Spatial indexing:
* To add documentation :
** http://mcnairwww.bakerinstituteedegan.orgcom/wiki/PostGIS_Installation** http://mcnairwww.bakerinstituteedegan.orgcom/wiki/Urban_Start-up_Agglomeration
* Discussed the need to maintain venture capital database.
