7,649
edits
Changes
Jump to navigation
Jump to search
ArcMap / ArcGIS Documentation (view source)
Revision as of 17:12, 17 March 2019
, 17:12, 17 March 2019no edit summary
}}
= New Instructions= ==Add a connections to the dbase server== Open ArcMap !First time: Add Connection Go to catelog (below windows) Add database connection If postgres server is set up correctly (edit pg_hba.conf) then 192.168.2.92 researcher smallamount vcdb3 ==Vermont Example== File -> Add Data -> Add Query Layer Use query: SELECT A.coname, A.statecode, A.datefirstinv, A.city, B.addr1, B.zip, B.latitude, B.longitude 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; Then Add Data (Yellow Diamond with Black Plus) dropdown -> Add Baselayer -> light grey Finally reorder the layers and zoom in to export images. Save as Vermont2018.mxd in E:\projects\vcbd3 =ArcMap Instructions By Jeemin=
== Add Text File (.txt) as Data on ArcMap ==
