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=

==== To adjust How to Change Color ==== - For colors to choose, refer to [[Branding]] - Baker Green (rgb values) : 13,119,110 - Baker Orange (rgb values) : 235,109,46 - To adjust the color, 1) Locate the 'Table Of Contents' panel on the left 2) Locate the layer of interest 3) Double-click on its symbol (circle, diamond, rectangle ...) 4) 'Symbol Selector' window pops up 5) Click on the drop-down of 'Color' 6) Click on 'More Colors' 7) Input the appropriate RGB values 8) Click OK 9) Then Click OK

 ==== How to Change Transparency ====  - To adjust transparency, 1) Locate the 'Table Of Contents' panel on the left 2) Double-click on a desired layer 3) 'Layer Properties' window pops up 4) Adjust text field for 'Transparent' For points, transparency is usually 0%, and for areas, it is usually between 60% and 70%