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.
Open up conf.py (in the same directory as the toolbox), update the "connection", run the script (leave all options blank), publish the geoprocessing service, and configure the service URL in HPMS Assistant.
| Parameter | Explanation |
|---|---|
| skip (Optional) | 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. |
| connection (Optional) | The name of the the connection file to use. Ex: 'Database Connections\MyConnection.sde' |
| table (Optional) | The table name of the route network feature class. |
| networkRouteIdField (Optional) | The name of the field that represents the "route ID" of the network feature class. |
| networkSdeFileName (Optional) | network table sde file name |
| networkSdeDbType (Optional) | network table db type, ex. SQL_SERVER, ORACLE |
| networkSdeDbInstance (Optional) | The database instace, ex. dev-sql, 1433 |
| networkSdeDbAuthorization (Optional) | The db authorization type, DATABASE_AUTH or OPERATING_SYSTEM_AUTH |
| networkSdeDbUsername (Optional) | Database username |
| networkSdeDbPassword (Optional) | Database password |
| networkSdeDbSaveUserPass (Optional) | SAVE_USERNAME or DO_NOT_SAVE_USERNAME (true or false also) |
| networkSdeDbName (Optional) | the database name |
| networkSdeFilePersistLocation (Optional) | the optional location to persist the sde connection file, if left blank the sde connection file will not be persisted |
| networkFromDateField (Optional) | The name of the field that represents the "from date" of the network feature class. |
| networkToDateField (Optional) | The name of the field that represents the "to date" of the network feature class. |
| logLevel (Optional) | The level of logging the script should use: error, warn, info, debug, trace |
| fields (Optional) | Additional fields to keep in the export feature class. |
| where (Optional) | Additional where clause to apply to the export query. |
| exportFileName (Optional) | The name of the export file that will get generated. |
| exportType (Optional) | The type of file to export (shp or gdb) |
| year (Optional) | The HPMS year that is being exported - this year will be used to pull active records for the given year. |
| stateCode (Optional) | The FIPS state code to export in the feature class. |
There are no code samples for this tool.
HPMS
Transcend Spatial Solutions LLC
There are no use limitations for this item.