NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
<p>To import geospatial data:</p>
<ol>
<ol type="a">
<li>Navigate to the directory where the file that you would like to import is located.</li>
<li>Select the file name(xls or xlsx).</li>
<li>Click the '''Open''' button.</li>
:The geospatial data from the spreadsheet is appended to any existing data in the Points or Polygons table.
===Excel Import Business Rules===__NOEDITSECTION__
<p>To import geospatial data from an Excel spreadsheet, the file must be created according to the following business rules:</p> <ol>* contain the columns in the table below;<li>The * the columns in must have the specified name;* the spreadsheet columns must be in a certain the specified order from left to right.</li></ol>* the first row of the file should contain the column names
{| class="wikitable" width="600"
| PolyID || The ID for the polygon or polyline.
|-
| PointNo || The point number for the point. The point identified as point 1 will be imported as a starting point; all other points will be imported as a turning point.
|-
| PointID || The ID for the point.
|}
''Sample Spreadsheet with Geospatial Data''
</div>
<ol start="31"><li>When a '''Poly ID''' is provided, the coordinate data is 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 shapes, keep the points for each shape together in the spreadsheet and begin each new shape with point number 1. The example shown below illustrates a spreadsheet which defines two polylines.</li>
</ol>
[[Image:SampleSpreadsheetWithDataForTwoPolylines.png|550px|600px|''Sample Spreadsheet with Data For Two Polylinescenter]]<div align="leftcenter">''Sample Spreadsheet With with Data For Two Polylines''
</div>
<ol start="43">
<li>The Point ID cannot be NULL, and must be unique across all points in the Excel spreadsheet and existing points in the Points table and Polygon/Polyline points table at the geospatial widget of the target object.</li>
<li>The Point Type must be valid.</li><li>When a '''Poly ID''' But if Point Type is providednot filled in, the coordinate data is a polygon/polyline point. Otherwise, the coordinate data is considered 1 will be imported as a '''single starting point'''; all other points will be imported as turning points.</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>
<li>If the Bearing, Distance, and FrPointID are not ''NULL'', the Xcoord and Ycoord values will be disregarded/voided.</li>
