Display Name: RouteGeomExport

Description: Exports a route geometry feature class to FHWA requirements - to be used for submitting HPMS Submittal. Typically expsed via a geoprocessing service to be consumed from Transcend's HPMS Assistant product.

Category:

Help URL: https://gis.iowadot.gov/rams/rest/directories/arcgisoutput/GPService/hpmsroutegeomexport_GPServer/GPService_hpmsroutegeomexport/routegeomexport.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: skip

Data Type: GPBoolean
Display Name skip
Description: Flag to determine whether to skip the actual export/generation of the data. This should be used when executing (staging) the tool in ArcMap to publish as a service to ArcGIS Server.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value: true
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: connection

Data Type: GPString
Display Name connection
Description: The name of the the connection file to use. Ex: 'Database Connections\MyConnection.sde'
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: table

Data Type: GPString
Display Name table
Description: The table name of the route network feature class.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkRouteIdField

Data Type: GPString
Display Name networkRouteIdField
Description: The name of the field that represents the "route ID" of the network feature class.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeFileName

Data Type: GPString
Display Name networkSdeFileName
Description: network table sde file name
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbType

Data Type: GPString
Display Name networkSdeDbType
Description: network table db type, ex. SQL_SERVER, ORACLE
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbInstance

Data Type: GPString
Display Name networkSdeDbInstance
Description: The database instace, ex. dev-sql, 1433
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbAuthorization

Data Type: GPString
Display Name networkSdeDbAuthorization
Description: The db authorization type, DATABASE_AUTH or OPERATING_SYSTEM_AUTH
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbUsername

Data Type: GPString
Display Name networkSdeDbUsername
Description: Database username
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbPassword

Data Type: GPString
Display Name networkSdeDbPassword
Description: Database password
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbSaveUserPass

Data Type: GPString
Display Name networkSdeDbSaveUserPass
Description: SAVE_USERNAME or DO_NOT_SAVE_USERNAME (true or false also)
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeDbName

Data Type: GPString
Display Name networkSdeDbName
Description: the database name
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkSdeFilePersistLocation

Data Type: GPString
Display Name networkSdeFilePersistLocation
Description: the optional location to persist the sde connection file, if left blank the sde connection file will not be persisted
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkFromDateField

Data Type: GPString
Display Name networkFromDateField
Description: The name of the field that represents the "from date" of the network feature class.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: networkToDateField

Data Type: GPString
Display Name networkToDateField
Description: The name of the field that represents the "to date" of the network feature class.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: logLevel

Data Type: GPString
Display Name logLevel
Description: The level of logging the script should use: error, warn, info, debug, trace
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: fields

Data Type: GPString
Display Name fields
Description: Additional fields to keep in the export feature class.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: where

Data Type: GPString
Display Name where
Description: Additional where clause to apply to the export query.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: exportFileName

Data Type: GPString
Display Name exportFileName
Description: The name of the export file that will get generated.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: exportType

Data Type: GPString
Display Name exportType
Description: The type of file to export (shp or gdb)
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: year

Data Type: GPLong
Display Name year
Description: The HPMS year that is being exported - this year will be used to pull active records for the given year.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: stateCode

Data Type: GPLong
Display Name stateCode
Description: The FIPS state code to export in the feature class.
Direction: esriGPParameterDirectionInput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: output

Data Type: GPDataFile
Display Name output
Description:
Direction: esriGPParameterDirectionOutput
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeDerived
Category:

Supported Operations:   Submit Job