Changes

{{Project|Has project output=How-to|Has sponsor=McNair ProjectsCenter

= New Instructions= ==Add a connections to the dbase server== Open ArcMap !First time: Add Connection Go to 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 ==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 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 Finally reorder the layers and zoom in to export images. Save as Vermont2018.mxd in E:\projects\vcbd3 =ArcMap Instructions By Jeemin=

For points, transparency is usually 0%, and for areas, it is usually between 60% and 70%