Import Geospatial Data from Excel - Revision history

Alnaucler at 13:47, 22 November 2017

2017-11-22T13:47:11Z

← Older revision		Revision as of 15:47, 22 November 2017
Line 54:		Line 54:
	* WGS 84		* WGS 84
	* UTM		* UTM
	* UTM with distance and bearing		* UTM with distance and bearing
			* MGRS with distance and bearing
	can be downloaded from '''[[Media:ExcelImportTemplate.zip \| here]]'''.		can be downloaded from '''[[Media:ExcelImportTemplate.zip \| here]]'''.

Line 65:		Line 66:
	<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>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>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 ~~polylines~~.		<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 polygons.

	[[Image:SampleSpreadsheetWithDataForTwoPolygons.png\|800px\|center]]		[[Image:SampleSpreadsheetWithDataForTwoPolygons.png\|800px\|center]]

Alnaucler at 17:17, 6 November 2017

2017-11-06T17:17:04Z

← Older revision		Revision as of 19:17, 6 November 2017
Line 67:		Line 67:
	<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 polylines.		<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 polylines.

	[[Image:~~SampleSpreadsheetWithDataForTwoPolylines~~.png\|800px\|center]]		[[Image:SampleSpreadsheetWithDataForTwoPolygons.png\|800px\|center]]
	<div align="center">		<div align="center">
	'' Sample ~~Spreadsheet~~ with ~~Data For Two Polylines~~ ''		'' Sample Excel file with coordinates for two polygons ''
	</div></li>		</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>		<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>

Alnaucler at 03:58, 13 January 2017

2017-01-13T03:58:29Z

← Older revision		Revision as of 05:58, 13 January 2017
Line 55:		Line 55:
	* UTM		* UTM
	* UTM with distance and bearing		* UTM with distance and bearing
	can be downloaded from [[Media:ExcelImportTemplate.zip \| here]].		can be downloaded from '''[[Media:ExcelImportTemplate.zip \| here]]'''.

	[[Image:SampleSpreadsheetForGeospatialData.png\|800px\|center]]		[[Image:SampleSpreadsheetForGeospatialData.png\|800px\|center]]

Alnaucler at 10:42, 23 June 2016

2016-06-23T10:42:59Z

← Older revision		Revision as of 12:42, 23 June 2016
Line 63:		Line 63:

	<ol>		<ol>
	<li>The selected coordinate reference system at the ~~geospatial widget~~ is the coordinate system ~~for~~ 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 in the ~~Point Editor~~ Excel ~~Import~~ function.</li>		<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 is a polygon/polyline point. Otherwise, the coordinate data is considered a '''single point'''.</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 ~~begin each new shape with point number 1~~. The example shown below illustrates a spreadsheet which defines two polylines.		<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 polylines.

	[[Image:SampleSpreadsheetWithDataForTwoPolylines.png\|800px\|center]]		[[Image:SampleSpreadsheetWithDataForTwoPolylines.png\|800px\|center]]
Line 74:		Line 74:
	<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 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 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 Xcoord and Ycoord values must conform to the coordinate reference format selected at the ~~geospatial widget~~. Available coordinate formats are: ''dd'', ''dd:mm'', ''dd:mm:ss'', ''X/Y'', and ''MGRS''.</li>		<li>The Xcoord and Ycoord values must conform to the coordinate reference format selected at the window. Available coordinate formats are: ''dd'', ''dd:mm'', ''dd:mm:ss'', ''X/Y'', and ''MGRS''.</li>
	<li>If the Bearing, Distance, and FrPointID are not ''NULL'', the Xcoord and Ycoord values will be disregarded/voided.</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>		<li>The Bearing value must be in the range of -360 to +360.</li>
			<li>If Distance/Bearing is used than the first point of the polygon(s) must have coordinates i.e. the first point cannot be relative to e.g. the Benchmark.</li>
	</ol>		</ol>

Alnaucler at 09:16, 23 June 2016

2016-06-23T09:16:21Z

← Older revision		Revision as of 11:16, 23 June 2016
Line 72:		Line 72:
	</div></li>		</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>		<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 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 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 Xcoord and Ycoord values must conform to the coordinate reference format selected at the geospatial widget. Available coordinate formats are: ''dd'', ''dd:mm'', ''dd:mm:ss'', ''X/Y'', and ''MGRS''.</li>		<li>The Xcoord and Ycoord values must conform to the coordinate reference format selected at the geospatial widget. Available coordinate formats are: ''dd'', ''dd:mm'', ''dd:mm:ss'', ''X/Y'', and ''MGRS''.</li>

Alnaucler at 07:04, 23 June 2016

2016-06-23T07:04:56Z

← Older revision		Revision as of 09:04, 23 June 2016
Line 51:		Line 51:
	\|}		\|}

	Examples of the Excel files with dot as decimal symbol		Examples of the Excel files with '''dot''' as decimal symbol
	* WGS 84		* WGS 84
	* UTM		* UTM

Alnaucler at 22:11, 27 June 2015

2015-06-27T22:11:07Z

← Older revision		Revision as of 00:11, 28 June 2015
Line 67:		Line 67:
	<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 begin each new shape with point number 1. The example shown below illustrates a spreadsheet which defines two polylines.		<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 begin each new shape with point number 1. The example shown below illustrates a spreadsheet which defines two polylines.

	[[Image:SampleSpreadsheetWithDataForTwoPolylines.png\|~~550px~~\|center]]		[[Image:SampleSpreadsheetWithDataForTwoPolylines.png\|800px\|center]]
	<div align="center">		<div align="center">
	'' Sample Spreadsheet with Data For Two Polylines ''		'' Sample Spreadsheet with Data For Two Polylines ''

Alnaucler at 21:49, 27 June 2015

2015-06-27T21:49:48Z

← Older revision		Revision as of 23:49, 27 June 2015
Line 57:		Line 57:
	can be downloaded from [[Media:ExcelImportTemplate.zip \| here]].		can be downloaded from [[Media:ExcelImportTemplate.zip \| here]].

	[[Image:SampleSpreadsheetForGeospatialData.~~jpg~~\|~~600px~~\|center]]		[[Image:SampleSpreadsheetForGeospatialData.png\|800px\|center]]
	<div align="center">		<div align="center">
	''Sample Spreadsheet with Geospatial Data''		''Sample Spreadsheet with Geospatial Data''

Dionysia at 16:14, 23 March 2015

2015-03-23T16:14:17Z

← Older revision		Revision as of 18:14, 23 March 2015
Line 13:		Line 13:
	</ol>		</ol>

	===Excel Import Business Rules===__NOEDITSECTION__		==Excel Import Business Rules==__NOEDITSECTION__
	{{Note \|To import geospatial data from an Excel spreadsheet, the file must:		{{Note \|To import geospatial data from an Excel spreadsheet, the file must:
	* contain the columns in the table below		* contain the columns in the table below
Line 55:		Line 55:
	* UTM		* UTM
	* UTM with distance and bearing		* UTM with distance and bearing
	~~may~~ be downloaded from [[Media:ExcelImportTemplate.zip \| here]].		can be downloaded from [[Media:ExcelImportTemplate.zip \| here]].

	[[Image:SampleSpreadsheetForGeospatialData.jpg\|600px\|center]]		[[Image:SampleSpreadsheetForGeospatialData.jpg\|600px\|center]]
Line 62:		Line 62:
	</div>		</div>

	<ol ~~start="1"~~>		<ol>
	<li>The selected coordinate reference system at the geospatial widget is the coordinate system for 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 in the Point Editor Excel Import function.</li>		<li>The selected coordinate reference system at the geospatial widget is the coordinate system for 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 in the Point Editor Excel Import function.</li>
	<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>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 polygons/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>~~		<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 begin each new shape with point number 1. The example shown below illustrates a spreadsheet which defines two polylines.
	~~</ol>~~

	[[Image:SampleSpreadsheetWithDataForTwoPolylines.png\|550px\|center]]		[[Image:SampleSpreadsheetWithDataForTwoPolylines.png\|550px\|center]]
	<div align="center">		<div align="center">
	'' Sample Spreadsheet with Data For Two Polylines ''		'' Sample Spreadsheet with Data For Two Polylines ''
	</div>		</div></li>

	<~~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 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 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>

Dionysia at 09:31, 16 February 2015

2015-02-16T09:31:17Z

← Older revision		Revision as of 11:31, 16 February 2015
Line 1:		Line 1:
	~~[[Image:PointandPolyListWindow.png\|500px\|center]]~~		To import geospatial data from Excel file:
	~~<p>~~To import geospatial data from Excel file:~~</p>~~
	<ol>		<ol>
	<li>Click the [[Image:EditReportIcon.png \| Import Points]] button.</li>		<li>Click the [[Image:EditReportIcon.png \|Import Points]] button.
	:The Open window displays.		[[Image:PointandPolyListWindow.png\|500px\|center]]</li>
			<li>The Open window displays.</li>
	<li>From the Open window:</li>		<li>From the Open window:</li>
	<ol type="a">		<ol type="a">