About the GIS Data Loader Workbook Layout and Use

In order to import data using the GIS Data Loader, GE Digital provides an Excel workbook, Geographic Information System (GIS).xlsx, which supports baseline GIS in GE Digital APM. This workbook must be used to perform the data load.

The following table lists the worksheets that are included in the GIS Data Loader workbook.

Worksheet	Description
GIS	The only worksheet used by the GIS Data Loader. It is used to load geospatial data for existing entities.

The following table lists the fields in the workbook:

GIS Worksheet

Field Caption	Field ID	Data Type (Length)	Comments
Batch ID	BATCH_ID	Character (50)	This is the Batch ID field.
Entity Key	ENTITY_KEY	Numeric	This is the Entity Key field.
Entity ID	ENTITY_ID	Character (255)	This is the Entity ID field.
Family ID	FAMILY_ID	Character (50)	This is the Family ID field.
Family ID Field	ID_FIELD	Character (50)	This is the ID Field name for the specified Family.
ID	ID	Character (255)	The is the ID field.
Geometry	GEOD_DATA	Character (4000)	This is the Spatial Data Field.