{ "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://rh.dcgis.dc.gov/dcgis/rest/directories/arcgisoutput/DDOT/RouteGeomExport_N_GPServer/DDOT_RouteGeomExport_N/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": "networkTableVersion", "dataType": "GPString", "displayName": "networkTableVersion", "description": "Network table version", "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": "exportSdeFileName", "dataType": "GPString", "displayName": "exportSdeFileName", "description": "export db sde file name", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbName", "dataType": "GPString", "displayName": "exportSdeDbName", "description": "export db name", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbTableName", "dataType": "GPString", "displayName": "exportSdeDbTableName", "description": "export db table name", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbInstance", "dataType": "GPString", "displayName": "exportSdeDbInstance", "description": "export db instance", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbType", "dataType": "GPString", "displayName": "exportSdeDbType", "description": "export db type", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbAuthorization", "dataType": "GPString", "displayName": "exportSdeDbAuthorization", "description": "export db authorization type", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbUsername", "dataType": "GPString", "displayName": "exportSdeDbUsername", "description": "export db username", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbPassword", "dataType": "GPString", "displayName": "exportSdeDbPassword", "description": "export db password", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeDbSaveUserPass", "dataType": "GPString", "displayName": "exportSdeDbSaveUserPass", "description": "export db save user pass", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportSdeFilePersistLocation", "dataType": "GPString", "displayName": "exportSdeFilePersistLocation", "description": "export db sde file persist location", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "exportType", "dataType": "GPString", "displayName": "exportType", "description": "The type of file to export (shp, gdb, or rdbms)", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "beginDate", "dataType": "GPDate", "displayName": "beginDate", "description": "The date to used to determine data to include", "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": "isNetworkBranchVersioned", "dataType": "GPBoolean", "displayName": "isNetworkBranchVersioned", "description": "Checked if using branch versioning.", "direction": "esriGPParameterDirectionInput", "defaultValue": null, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "networkLayerUrl", "dataType": "GPString", "displayName": "networkLayerUrl", "description": "URL to the network layer", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "portalUrl", "dataType": "GPString", "displayName": "portalUrl", "description": "URL for portal sign-in", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "portalUserName", "dataType": "GPString", "displayName": "portalUserName", "description": "Portal username", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "portalPassword", "dataType": "GPString", "displayName": "portalPassword", "description": "Portal password", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "output", "dataType": "GPDataFile", "displayName": "output", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": null, "parameterType": "esriGPParameterTypeDerived", "category": "" }, { "name": "success", "dataType": "GPBoolean", "displayName": "success", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": null, "parameterType": "esriGPParameterTypeDerived", "category": "" }, { "name": "errorMessage", "dataType": "GPString", "displayName": "errorMessage", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": "", "parameterType": "esriGPParameterTypeDerived", "category": "" } ] }