7,649
edits
Changes
Jump to navigation
Jump to search
ArcMap / ArcGIS Documentation (view source)
Revision as of 17:24, 17 March 2019
, 17:24, 17 March 2019→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.
