Difference between revisions of "ArcMap / ArcGIS Documentation"
Jump to navigation
Jump to search
Line 28: | Line 28: | ||
FROM (SELECT * FROM cityyearportco WHERE statecode='VT' AND year='2018') AS A | 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 | 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 | + | 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 right click and Display XY data. Add coordinate system: World WGD 1984. |
Revision as of 18:24, 17 March 2019
ArcMap / ArcGIS Documentation | |
---|---|
Project Information | |
Project Title | ArcMap / ArcGIS Documentation |
Owner | Jeemin Sim |
Start Date | |
Deadline | |
Primary Billing | |
Notes | |
Has project status | |
Copyright © 2016 edegan.com. All Rights Reserved. |
Contents
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
Add Text File (.txt) as Data on ArcMap
1) Open ArcMap 2) Locate a a button with a black cross with yellow diamond underneath (below'Selection') 3) Click the tiny triangle drop-down button to its immediate right 4) Select 'Add Data' 5) Find location where local text file resides. For example: (Home - Documents\ArcGIS) 6) Select a text file of interest and click Add - The text file should have at least two columns: X and Y coordinates 7) Locate the text file in the Table Of Contents tab in the left 8) Right click the text file 9) Select 'Display XY Data...' 10) In the pop-up window 'Display XY Data', choose XField and YField - the default should work 11) Check that in the same pop-up window the box labelled 'Coordinate System of Input Coordinates' contains GCS_WGS_1984 - If not: click the 'Edit...' Button. --> Click the Plus sign for 'Geographic Coordinate Systems' --> Click the Plus sign for 'World' --> Select 'WGS 1984' --> Press OK 12) Click 'OK' 13) Most likely a window titled 'Table Does Not Have Object-ID Field' will pop up, but do not fret 14) The points will show on the big screen in the middle
Manipulate Data with Queries
1) Right click on data layer 2) Click on Properties 3) Click on Definition Query 4) There are two options, definition query or query builder 5) Type In Query and Hit Apply and Then OK
Add Base layer on ArcMap
1) Locate a a button with a black cross with yellow diamond underneath (below'Selection') 2) Click the tiny triangle drop-down button to its immediate right 3) Select 'Add Basemap...' 4) Choose a base map of your liking. 'Light Gray Canvas' is frequently used. 5) Click 'Add'
Displaying a KML File on ArcMap
1) Locate a button with a red tool box (ArcToolbox) (below 'Help') 2) ArcToolbox window pops up 3) Click the plus sign to the left of 'Conversion Tools' 4) Click the plus sign to the left of 'From KML' 5) Double-click 'KML To Layer' 6) Select Input KML File, Output Location, and Output Data Name 7) Press 'OK' 8) Data appears on map
Determine the Layer Order (which layer appears in the front)
1) On the left, locate a 'Table Of Contents' panel 2) Under the words 'Table Of Contents', locate the leftmost button, 'List By Drawing Order' 3) Drag around layers to determine priority in view
Aesthetics of the Map
Color
Color Options
- Refer to Branding
- Most frequently used colors:
- Baker Green (rgb values) : 13,119,110
- Baker Orange (rgb values) : 235,109,46
How to Change 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
Transparency
How to Change 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%