{
 "name": "routegeomexport",
 "displayName": "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": "",
 "helpUrl": "https://gis.iowadot.gov/rams/rest/directories/arcgisoutput/GPService/hpmsroutegeomexport_GPServer/GPService_hpmsroutegeomexport/routegeomexport.htm",
 "executionType": "esriExecutionTypeAsynchronous",
 "parameters": [
  {
   "name": "skip",
   "dataType": "GPBoolean",
   "displayName": "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",
   "defaultValue": true,
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "connection",
   "dataType": "GPString",
   "displayName": "connection",
   "description": "The name of the the connection file to use. Ex: 'Database Connections\\MyConnection.sde'",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "table",
   "dataType": "GPString",
   "displayName": "table",
   "description": "The table name of the route network feature class.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkRouteIdField",
   "dataType": "GPString",
   "displayName": "networkRouteIdField",
   "description": "The name of the field that represents the \"route ID\" of the network feature class.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeFileName",
   "dataType": "GPString",
   "displayName": "networkSdeFileName",
   "description": "network table sde file name",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbType",
   "dataType": "GPString",
   "displayName": "networkSdeDbType",
   "description": "network table db type, ex. SQL_SERVER, ORACLE",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbInstance",
   "dataType": "GPString",
   "displayName": "networkSdeDbInstance",
   "description": "The database instace, ex. dev-sql, 1433",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbAuthorization",
   "dataType": "GPString",
   "displayName": "networkSdeDbAuthorization",
   "description": "The db authorization type, DATABASE_AUTH or OPERATING_SYSTEM_AUTH",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbUsername",
   "dataType": "GPString",
   "displayName": "networkSdeDbUsername",
   "description": "Database username",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbPassword",
   "dataType": "GPString",
   "displayName": "networkSdeDbPassword",
   "description": "Database password",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbSaveUserPass",
   "dataType": "GPString",
   "displayName": "networkSdeDbSaveUserPass",
   "description": "SAVE_USERNAME or DO_NOT_SAVE_USERNAME (true or false also)",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeDbName",
   "dataType": "GPString",
   "displayName": "networkSdeDbName",
   "description": "the database name",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkSdeFilePersistLocation",
   "dataType": "GPString",
   "displayName": "networkSdeFilePersistLocation",
   "description": "the optional location to persist the sde connection file, if left blank the sde connection file will not be persisted",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkFromDateField",
   "dataType": "GPString",
   "displayName": "networkFromDateField",
   "description": "The name of the field that represents the \"from date\" of the network feature class.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "networkToDateField",
   "dataType": "GPString",
   "displayName": "networkToDateField",
   "description": "The name of the field that represents the \"to date\" of the network feature class.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "logLevel",
   "dataType": "GPString",
   "displayName": "logLevel",
   "description": "The level of logging the script should use: error, warn, info, debug, trace",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "fields",
   "dataType": "GPString",
   "displayName": "fields",
   "description": "Additional fields to keep in the export feature class.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "where",
   "dataType": "GPString",
   "displayName": "where",
   "description": "Additional where clause to apply to the export query.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "exportFileName",
   "dataType": "GPString",
   "displayName": "exportFileName",
   "description": "The name of the export file that will get generated.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "exportType",
   "dataType": "GPString",
   "displayName": "exportType",
   "description": "The type of file to export (shp or gdb)",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "year",
   "dataType": "GPLong",
   "displayName": "year",
   "description": "The HPMS year that is being exported - this year will be used to pull active records for the given year.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": null,
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "stateCode",
   "dataType": "GPLong",
   "displayName": "stateCode",
   "description": "The FIPS state code to export in the feature class.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": null,
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "output",
   "dataType": "GPDataFile",
   "displayName": "output",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": null,
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  }
 ]
}