CreateSimpleDataMapping

Title  Create Simple Data Mapping

Description

This tool creates a spreadsheet you can use to map your current geodatabase schema to the schema of an asset packge for a utility network.

Usage

          
Once you've used this tool to create a data mapping spreadsheet you will then manually populate it with the mappings from your current (source) data model to the new (utility network) model.
Once you've populated the spreadsheet you will run the the 'Create Migration Workspace' tool to create a data loading workspace and data model suitable for performing the data conversion.

License

Standard

Syntax

CreateSimpleDataMapping (source_dataset, asset_package, output_folder, output_name, {count_features}, {source_type_table})

Parameter Explanation Data Type
source_dataset Dialog Reference

The source feature dataset or workspace you want to migrate

GPComposite
asset_package Dialog Reference

The asset package you want to use as your base data model

DEWorkspace
output_folder Dialog Reference

Folder to contain the simple data mappings

DEFolder
output_name Dialog Reference

Name of the simple data mappings spreadsheet

GPString
count_features (Optional) Dialog Reference

Whether to calculate feature counts for each mapping

GPBoolean
source_type_table (Optional) Dialog Reference

List of field names to use to determine types in the source data. A row is created in the workbook for each type in this column. This is similar subtypes in the source data. Common values are:

  • bedmaterial
  • devicetype
  • dischrtyp
  • fittingtype
  • hydrflag
  • inlettype
  • largemeter
  • linetype
  • pumptype
  • servicetype
  • structtype
  • transmiss
  • valvetype
  • weirtype

GPRecordSet

Code Samples