Changes

Jump to: navigation, search

Import Geospatial Data from Excel

34 bytes added, 15:52, 15 January 2015
no edit summary
<ol start="1">
<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 shapespolygons/polylines, use different PolyIDs, 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>
<ol start="3">
<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>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. But if Point Type is not filled in, point 1 will be imported as a 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>
<li>The Bearing value must be in the range of -360 to +360.</li>
6,632
edits

Navigation menu