NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
* WGS 84
* UTM
* UTM with distance and bearing* MGRS with distance and bearing can be downloaded from '''[[Media:ExcelImportTemplate.zip | here]]'''.
[[Image:SampleSpreadsheetForGeospatialData.png|800px|center]]
<li>The selected coordinate reference system in the ''Point and Polygon/Polyline List'' window is the coordinate system need to be the same as the coordinate data in the Excel input file. Please note that the ProjName column in the Excel input file is purely for manual reference and not used by the import from Excel function.</li>
<li>When a '''Poly ID''' is provided, the coordinate data will be a polygon/polyline point. Otherwise, the coordinate data is considered a '''single point'''.</li>
<li>If you would like to import geospatial data for multiple polygons/polylines, use different PolyIDs, keep the points for each shape together in the spreadsheet and make the Point ID unique in the file. The example shown below illustrates a spreadsheet which defines two polylinespolygons.
[[Image:SampleSpreadsheetWithDataForTwoPolylinesSampleSpreadsheetWithDataForTwoPolygons.png|800px|center]]
<div align="center">
'' Sample Spreadsheet Excel file with Data For Two Polylines coordinates for two polygons ''
</div></li>
<li>The PointNo cannot be NULL for any polygon/polyline points. If the PointNo is NULL and the coordinate is a single point, the PointNo will be set to 1.</li>
