[go: up one dir, main page]
Scribd
Upload
116 views6 pages

Files Needed: Excel File of Northings & Eastings (Ex. Plotting - Applicantname - Application-Number - XSLX) Procedure

This document provides instructions for plotting location coordinates from an Excel file into ArcGIS. It involves a 10 step process: 1) Loading the Excel file of Northings and Eastings into ArcMap, 2) Specifying the correct coordinate system, 3) Exporting the XY data to a shapefile, 4) Reprojecting the data to WGS84, 5) Updating the attribute table with longitude, latitude, Northings and Eastings. The coordinate system used depends on the location, and files are saved at each step for record keeping.

Uploaded by

Paulo Edrian Dela Pena
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
116 views6 pages

Files Needed: Excel File of Northings & Eastings (Ex. Plotting - Applicantname - Application-Number - XSLX) Procedure

This document provides instructions for plotting location coordinates from an Excel file into ArcGIS. It involves a 10 step process: 1) Loading the Excel file of Northings and Eastings into ArcMap, 2) Specifying the correct coordinate system, 3) Exporting the XY data to a shapefile, 4) Reprojecting the data to WGS84, 5) Updating the attribute table with longitude, latitude, Northings and Eastings. The coordinate system used depends on the location, and files are saved at each step for record keeping.

Uploaded by

Paulo Edrian Dela Pena
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

MANUAL ON ARCGis PLOTTING:

FILES NEEDED:
 Excel file of Northings & Eastings (ex. plotting_ApplicantName_Application-Number.xslx)

PROCEDURE:
1. Open ArcMap 10.2.2 or ArcMap 10.4.1

2. Go to: File -> Add Data-> Add XY Data


3. Load the excel file of Northings and Eastings: (plotting_ApplicantName_Application-Number.xslx)

Select: Sheet1$

X Field: Eastings

Y Field: Northings

Click “Edit” Button to specify the Coordinate


System to be used

4. Specifying the Coordinate System:


IMPORTANT:
FOR ORIENTAL MINDORO, OCCIDENTAL MINDORO and MARINDUQUE: Use “PRS 92 Philippines Zone III”
FOR ROMBLON: Use “PRS 92 Philippines Zone IV”
To locate go to: Projected Coordinate Systems -> National Grids -> Asia -> PRS 92 Philippines Zone III
5. Right Click on the loaded file on Table of Contents on the right panel, then go to Data -> Export Data

6. Export the XY data previously loaded into a new feature shp file. Save the file with same file name of the
excel file, then append “_PRS92”: Ex. plotting_ApplicantName_Application-Number_PRS92.shp

7. Remove the previously loaded XY data (Sheet1$ Events)


8. Re-project the data into WGS-84 Projection:

Go to ArcToolbox -> Data Management Tools -> Projections and Transformations -> Project
9. Input the necessary details for the re-projection:

Input Dataset or Feature Class: Select the file needed for reprojection into WGS84

Output Dataset or Feature Class: Specify the new filename to be created with a new projection. Save the file with
the same file name but change the “_PRS92” with “_WGS84”

Ex. plotting_ApplicantName_Application-Number_WGS84.shp

Output Coordinate System: Specify the projection to be used

IMPORTANT:

FOR ORIENTAL MINDORO, OCCIDENTAL MINDORO, MARINDUQUE and ROMBLON:


Use “WGS 1984 UTM ZONE 51N”
To locate go to:
Projected Coordinate Systems -> UTM -> WGS 1984 -> Northern Hemisphere -> WGS 1984 UTM ZONE 51N

Then click, “OK” button and wait for the progress to complete. Usually there’s a small pop-up notification on
the lower right corner when the process completes.

SAVE all the created shape files (.shp) in to the same


folder of the plotting file (.xslx)

10. Update the attribute table of the created files:

Go to the attribute table of PRS92 projected file: Right


click on PRS92 file -> Open Attribute Table
Select the LONGITUDE/LATITUDE

Column then Right Click -> Calculate Geometr

For Units: Degrees Minutes Seconds (DDD MM’ SS.sss”


[W][E]

For LATITUDE:
LONGITUDE: Property: Select Y Coordinate Point
Property: Select X Coordinate Point Units: Degrees Minutes Seconds (DDD MM’ SS.sss”
[N][S]

Do the same process for the WGS84 File! But also include in the UPDATE the NORTHINGS and EASTINGS
Columns.

For EASTINGS:
Property: Select X Coordinate Point
Units: Meters

For NORTHINGS:
Property: Select Y Coordinate Point
Units: Meter

You might also like