7,612
edits
Changes
Jump to navigation
Jump to search
Go to catelog catalog (below windows) Add database connection If postgres server is set up correctly (edit pg_hba.conf) then 192.168.2.92 researcher smallamount vcdb3
ArcMap / ArcGIS Documentation (view source)
Revision as of 13:47, 21 September 2020
, 13:47, 21 September 2020no edit summary
{{Project|Has project output=How-to|Has sponsor=McNair ProjectsCenter
|Has title=ArcMap / ArcGIS Documentation
|Has owner=Jeemin Sim,
Open ArcMap!
First time: Add Connection
==Vermont Example==
FROM (SELECT * FROM cityyearportco WHERE statecode='VT' AND year='2018') AS A
LEFT JOIN portcogeo AS B ON A.coname=B.coname AND A.statecode=B.statecode AND
A.datefirstinv=B.datefirstinv WHERE latitude IS NOT NULL; Note that there should be no semi-colon! Then right click and Display XY data. Add coordinate system: World WGD 1984.
Then Add Data (Yellow Diamond with Black Plus) dropdown -> Add Baselayer -> light grey
