Reference Documents 2.xlsx
XLSX spreadsheet 835 KB Posted
- Attached to
- SCDOT GIS MIGRATION CONSULTANT State and local contract opportunity
- Solicitation number
- 5400022867
- Issued by
- Richland County, South Carolina
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment 1.doc | DOC document | |
| Solicitation.doc | DOC document | |
| Award Posting Extension.doc | DOC document | |
| Amendment 2.doc | DOC document | |
| Reference Documents 1.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Dedicated Roads Updated on: 7/31/19
| System Name: | Dedicated Roads | ||||||||||||||||
| Data Owner: | Road Data Services | ||||||||||||||||
| Systems Integrated With | |||||||||||||||||
| Table Name | Table Description | Field Name | Field Description | Data Type | Code List | Nullable? | RIMS | TDMA | Dedicated Roads | P2S | RWDMS | STIP Manager | Photolog | Pavement Viewer | Performance Viewer | ITMS | RIS |
| DT_DEDICATED_ROADS_HDR | |||||||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | DEDICATED_NAME | Dedicated Road Name | VARCHAR2(100) | N | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | LAST_NAME | Last Name | VARCHAR2(90) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | FIRST_NAME | First Name | VARCHAR2(80) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | MIDDLE_NAME | Middle Name | VARCHAR2(40) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | SUFFIX | Suffix | NUMBER(38,0) | CT_NAME_SUFFIX | Y | |||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | DEDICATION_TYPE | Dedication Type | NUMBER(38,0) | CT_DEDICATION_TYPE | N | |||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | ADOPTION_DATE | Adoption Date | DATE | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | BEGIN_DESCR | Begin Description | VARCHAR2(80) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | END_DESCR | End Description | VARCHAR2(80) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | GENERAL_DESCR | General Description | VARCHAR2(380) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | COMMENTS | Comments | VARCHAR2(520) | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | PDF_FILE | PDF Map | BLOB | Y | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | UPDT_BY | Updated By | VARCHAR2(41) | N | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | UPDT_ON | Updated Date | DATE | N | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | DT_DEDICATED_ROAD_HDR_ID | Dedicated Road Unique ID | NUMBER(10,0) | N | ||||||||||||
| DT_DEDICATED_ROADS_HDR | Dedicated Roads | ADDITIONAL_NAMES | Additional Names | VARCHAR2(1024) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | |||||||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | DOM_RTE_LRS | Route LRS | VARCHAR2(12) | N | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | DOM_BMP | Beginning Milepoint | NUMBER(6,3) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | DOM_EMP | Ending Milepoint | NUMBER(6,3) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | COMMENTS | Comments | VARCHAR2(250) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | UPDT_BY | Updated By | VARCHAR2(41) | N | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | UPDT_ON | Updated Date | DATE | N | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | DT_DEDICATED_ROAD_HDR_ID | Dedicated Road Unique ID | NUMBER(10,0) | N | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | DOM_DEDICATED_ROADS_ID | Dedicated Roads Location Unique ID | NUMBER(10,0) | N | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | BLAT | Beginning Latitude | NUMBER(12,6) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | BLONG | Beginning Longitude | NUMBER(12,6) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | ELAT | Ending Latitude | NUMBER(12,6) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | ELONG | Ending Longitude | NUMBER(12,6) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | DOM_DIR | Direction | VARCHAR2(1) | Y | ||||||||||||
| DOM_DEDICATED_ROADS_LOCATION | Dedicated Road Locations | ASSET_ID | Asset ID | NUMBER(5,0) | Y | ||||||||||||
| CT_DEDICATION_TYPE | |||||||||||||||||
| CT_DEDICATION_TYPE | Dedication Type Code List | DEDICATION_TYPE_ID | Dedication Type Unique ID | NUMBER(38,0) | N | ||||||||||||
| CT_DEDICATION_TYPE | Dedication Type Code List | DEDICATION_TYPE_DESCR | Dedication Type Description | VARCHAR2(80) | Y | ||||||||||||
| CT_NAME_SUFFIX | |||||||||||||||||
| CT_NAME_SUFFIX | Suffix Code List | SUFFIX_ID | Suffix Unique ID | NUMBER(22,0) | N | ||||||||||||
| CT_NAME_SUFFIX | Suffix Code List | SUFFIX_DESCR | Suffix Description | VARCHAR2(80) | Y |
ITMS
| Updated on: | 4/27/21 | ||||||||||||||||
| System Name: | Integrated Transportation Management System | ||||||||||||||||
| Data Owner: | Road Data Services | ||||||||||||||||
| Systems Integrated With | |||||||||||||||||
| Table Name | Table Description | Field Name | Field Description | Data Type | Code List | Nullable? | RIMS | TDMA | Dedicated Roads | P2S | RWDMS | STIP Manager | Photolog | Pavement Viewer | Performance Viewer | ITMS | RIS |
| _PRSScoringCriteria | |||||||||||||||||
| _PRSScoringCriteria | PRS Scoring Criteria | Column | PRS Scoring Criteria | varchar(max) | NO | ||||||||||||
| _PRSScoringCriteria | PRS Scoring Criteria | FromValue | From Value | numeric(12,3) | YES | ||||||||||||
| _PRSScoringCriteria | PRS Scoring Criteria | ToValue | To Value | numeric(12,3) | YES | ||||||||||||
| _PRSScoringCriteria | PRS Scoring Criteria | Value | Value | varchar(max) | YES | ||||||||||||
| _PRSScoringCriteria | PRS Scoring Criteria | Points | Points | int | NO | ||||||||||||
| _PRSScoringCriteria | PRS Scoring Criteria | Weight | Weight | int | NO | ||||||||||||
| active_project_work | |||||||||||||||||
| active_project_work | Active Projects Work | filenumber | File Number | varchar(50) | YES | ||||||||||||
| active_project_work | Active Projects Work | letting_date | Letting Date | datetime | YES | ||||||||||||
| active_project_work | Active Projects Work | award_date | Award Date | datetime | YES | ||||||||||||
| active_project_work | Active Projects Work | award_amt | Award Amount | int | YES | ||||||||||||
| active_project_work | Active Projects Work | termini_from | Termini From | varchar(50) | YES | ||||||||||||
| active_project_work | Active Projects Work | termini_to | Termini To | varchar(50) | YES | ||||||||||||
| active_project_work | Active Projects Work | work_type | Work Type | varchar(4) | YES | ||||||||||||
| active_project_work | Active Projects Work | work_type_desc | Work Type Description | varchar(24) | YES | ||||||||||||
| active_project_work | Active Projects Work | cont_id | Contract ID | varchar(24) | YES | ||||||||||||
| active_project_work | Active Projects Work | contractor | Contractor | varchar(60) | YES | ||||||||||||
| active_project_work | Active Projects Work | completion_date | Completion Date | datetime | YES | ||||||||||||
| active_project_work | Active Projects Work | seq_id | Sequence ID | int | YES | ||||||||||||
| active_project_work | Active Projects Work | color_desc | Color Description | varchar(24) | YES | ||||||||||||
| active_project_work | Active Projects Work | color | Color | int | YES | ||||||||||||
| active_project_work_routes | |||||||||||||||||
| active_project_work_routes | Active Projects Work Routes | county | County | int | DT_COUNTIES | YES | |||||||||||
| active_project_work_routes | Active Projects Work Routes | route_lrs | Route LRS | varchar(12) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | bmp | Beginning Milepoint | decimal(6,3) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | emp | Ending Milepoint | decimal(6,3) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | filenumber | File Number | varchar(50) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | route | Route Number | varchar(20) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | road_name | Road Name | varchar(50) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | begin_desc | Beginning Description | varchar(50) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | end_desc | Ending Description | varchar(50) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | seq_id | Sequence ID | int | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | county_name | County Name | varchar(32) | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | color | Color | int | YES | ||||||||||||
| active_project_work_routes | Active Projects Work Routes | color_desc | Color Description | varchar(24) | YES | ||||||||||||
| APP_STATS | |||||||||||||||||
| APP_STATS | Application Statistics | USERNAME | User Name | varchar(50) | YES | ||||||||||||
| APP_STATS | Application Statistics | IP | IP Address | varchar(50) | YES | ||||||||||||
| APP_STATS | Application Statistics | APPLICATION | Application | varchar(50) | YES | ||||||||||||
| APP_STATS | Application Statistics | OPERATION | Operation | varchar(50) | YES | ||||||||||||
| APP_STATS | Application Statistics | QUERY | Query | varchar(2048) | YES | ||||||||||||
| APP_STATS | Application Statistics | RESULT | Result | varchar(50) | YES | ||||||||||||
| APP_STATS | Application Statistics | ELAPSED | Elapsed Time | float | YES | ||||||||||||
| APP_STATS | Application Statistics | EXECUTION | Execution Date | datetime | YES | ||||||||||||
| APP_STATS | Application Statistics | DETAILS | Details | varchar(2048) | YES | ||||||||||||
| APP_STATS | Application Statistics | MSMEMORY | MS Memory | varchar(127) | YES | ||||||||||||
| APP_STATS | Application Statistics | MSVM | MS Virtual Memory | varchar(127) | YES | ||||||||||||
| APP_STATS | Application Statistics | PRIVATEMEM | Private Memory | varchar(127) | YES | ||||||||||||
| APP_STATS | Application Statistics | IISMEMORY | IIS Memory | varchar(127) | YES | ||||||||||||
| APP_STATS | Application Statistics | IISVM | IIS Virtual Memory | varchar(127) | YES | ||||||||||||
| APP_STATS | Application Statistics | IISPRIVATEMEM | IIS Private Memory | varchar(127) | YES | ||||||||||||
| APW_ROUTE_STYLES | |||||||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | ROUTE_TYPE | Route Type | nvarchar(2) | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | RANGE_CRITERIA_NAME | Range Criteria Name | nvarchar(32) | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | STYLE_FILE | Style File Name | nvarchar(32) | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | PRIORITY | Priority | int | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | LEVEL_NAME | Level Name | nvarchar(32) | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | BORDER | Border | int | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | TOOLTIP | Tooltip | nvarchar(128) | YES | ||||||||||||
| APW_ROUTE_STYLES | Application Route Styles | SHEET_NAME | Sheet Name | nvarchar(48) | YES | ||||||||||||
| CandidateListThresholds | |||||||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | ID | Unique ID | int | NO | ||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | CountyID | County Number | int | DT_COUNTIES | YES | |||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | Prim_PRS | Primary PRS Score | int | YES | ||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | Sec_PRS | Secondary PRS Score | int | YES | ||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | Threshold | Threshold | int | YES | ||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | UpdatedBy | Updated By | varchar(50) | YES | ||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | UpdatedOn | Updated Date | datetime | YES | ||||||||||||
| CandidateListThresholds | Resurfacing Candidate List Thresholds | IsObsolete | Is Obsolete | bit | YES | ||||||||||||
| CART_INFO | |||||||||||||||||
| CART_INFO | ITMS Cart Information | CART_ID | Unique Cart ID | bigint | NO | ||||||||||||
| CART_INFO | ITMS Cart Information | USERNAME | User Name | varchar(127) | NO | ||||||||||||
| CART_INFO | ITMS Cart Information | CART_STRING | Cart String Criteria | varchar(3000) | YES | ||||||||||||
| CART_INFO | ITMS Cart Information | CART_NAME | Cart Name | varchar(64) | NO | ||||||||||||
| COGS | |||||||||||||||||
| COGS | COG Code List | COGID | Unique COG ID | int | NO | ||||||||||||
| COGS | COG Code List | COG_ID | Alternative COG ID | varchar(2) | YES | ||||||||||||
| COGS | COG Code List | DESCRIPTION | COG Description | varchar(255) | NO | ||||||||||||
| COGS | COG Code List | COUNTIES | COG Counties | varchar(255) | NO | ||||||||||||
| COMMISSION | |||||||||||||||||
| COMMISSION | Commission Code List | COMMID | Unique Commission ID | int | NO | ||||||||||||
| COMMISSION | Commission Code List | DESCRIPTION | Commission Description | varchar(255) | NO | ||||||||||||
| COMMISSION | Commission Code List | COUNTIES | Commission Counties | varchar(255) | NO | ||||||||||||
| COMMISSION_REPORT_DATA | |||||||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | PCN | PCN Number | varchar(50) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | PCN_SUFFIX | PCN Suffix | varchar(10) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | COUNTY_NAME | County Name | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | ENGINEERING_DISTRICT | Engineering District | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | CONGRESSIONAL_DISTRICT | Congressional District | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | APPROVAL_DATE | Approval Date | datetime | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | ENGINEERING_RANK | Engineering Rank | varchar(50) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | PROJECT_RANK | Project Rank | int | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | WORK_TYPE | Work Type | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | ROUTE_LIST | Route List | varchar(255) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | FUNDING_SOURCE | Funding Source | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | AWARD_DATE | Award Date | datetime | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | STATUS | Status | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | DETAILED_STATUS | Detailed Status | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | REPORT_TITLE | Report Title | varchar(100) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | DOM_ROUTE_LRS | Dominant Route LRS | varchar(12) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | DOM_BMP | Dominant Route Beginning Milepoint | decimal(6,3) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | DOM_EMP | Dominant Route Ending Milepoint | decimal(6,3) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | ROUTE | Route | varchar(50) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | BMP | Beginning Milepoint | decimal(6,3) | YES | ||||||||||||
| COMMISSION_REPORT_DATA | Commission Report Data (Active Projects) | EMP | Ending Milepoint | decimal(6,3) | YES | ||||||||||||
| COMMISSION_RPT_FUNDING_HEADERS | |||||||||||||||||
| COMMISSION_RPT_FUNDING_HEADERS | Commission Report Funding Headers (Active Projects) | REPORT_ID | Unique Commission Report ID | int | NO | ||||||||||||
| COMMISSION_RPT_FUNDING_HEADERS | Commission Report Funding Headers (Active Projects) | HEADER | Report Header | varchar(255) | NO | ||||||||||||
| COMMISSION_RPT_FUNDING_HEADERS | Commission Report Funding Headers (Active Projects) | FOOTER | Report Footer | varchar(255) | YES | ||||||||||||
| CommissionReports | |||||||||||||||||
| CommissionReports | Commission Report Categories (Active Projects) | ID | Unique Report Category ID | int | NO | ||||||||||||
| CommissionReports | Commission Report Categories (Active Projects) | CATEGORY | Commission Report Category | varchar(50) | NO | ||||||||||||
| CommissionReports | Commission Report Categories (Active Projects) | COLOR | Category Map Color | varchar(50) | NO | ||||||||||||
| CommissionReports | Commission Report Categories (Active Projects) | WEIGHT | Category Map Weight | int | NO | ||||||||||||
| COUNTIES | |||||||||||||||||
| COUNTIES | County Code List | COUNTY_ID | Unique County ID | decimal(2,0) | YES | ||||||||||||
| COUNTIES | County Code List | COUNTY | County Name | varchar(240) | YES | ||||||||||||
| CountyDistricts | |||||||||||||||||
| CountyDistricts | Engineering & Commission District Lookup | CntyNbr | Unique County ID | int | NO | ||||||||||||
| CountyDistricts | Engineering & Commission District Lookup | CntyName | County Name | varchar(50) | NO | ||||||||||||
| CountyDistricts | Engineering & Commission District Lookup | EngrDist | Related Engineering District | varchar(50) | NO | ||||||||||||
| CountyDistricts | Engineering & Commission District Lookup | CommDist | Related Commission District(s) | varchar(50) | NO | ||||||||||||
| CT_FUNC_CLS | |||||||||||||||||
| CT_FUNC_CLS | Functional Classification Code List | FUNC_CLS_ID | Unique Functional Class ID | int | NO | ||||||||||||
| CT_FUNC_CLS | Functional Classification Code List | FUNC_CLS | Functional Classification | nvarchar(500) | YES | ||||||||||||
| CT_FUNC_CLS | Functional Classification Code List | IS_OBSOLETE | Is Obsolete | bit | YES | ||||||||||||
| CT_FUNC_CLS | Functional Classification Code List | IS_FEDERAL_AID | Is Federal Aid | bit | YES | ||||||||||||
| CT_RTE_AUX_IDS | |||||||||||||||||
| CT_RTE_AUX_IDS | Route Auxiliary Code List | RTE_AUX_ID | Unique Route Auxiliary ID | numeric(2,0) | NO | ||||||||||||
| CT_RTE_AUX_IDS | Route Auxiliary Code List | ROUTE_AUX | Route Auxiliary Abbreviation | varchar(3) | NO | ||||||||||||
| CT_RTE_AUX_IDS | Route Auxiliary Code List | IS_OBSOLETE | Is Obsolete | numeric(1,0) | NO | ||||||||||||
| CT_RTE_AUX_IDS | Route Auxiliary Code List | RTE_AUXILIARY | Route Auxiliary Description | varchar(240) | NO | ||||||||||||
| CT_RTE_AUX_IDS | Route Auxiliary Code List | UPDT_BY | Updated By | varchar(41) | NO | ||||||||||||
| CT_RTE_AUX_IDS | Route Auxiliary Code List | UPDT_ON | Updated Date | date | NO | ||||||||||||
| CT_RTE_TYPES | |||||||||||||||||
| CT_RTE_TYPES | Route Types Code List | RTE_TYPE_ID | Unique Route Type ID | numeric(2,0) | NO | ||||||||||||
| CT_RTE_TYPES | Route Types Code List | ROUTE_TYPE | Route Type Abbreviation | varchar(2) | NO | ||||||||||||
| CT_RTE_TYPES | Route Types Code List | IS_OBSOLETE | Is Obsolete | numeric(1,0) | NO | ||||||||||||
| CT_RTE_TYPES | Route Types Code List | RTE_TYPE | Route Type Description | varchar(240) | NO | ||||||||||||
| CT_RTE_TYPES | Route Types Code List | UPDT_BY | Updated By | varchar(41) | NO | ||||||||||||
| CT_RTE_TYPES | Route Types Code List | UPDT_ON | Updated Date | date | NO | ||||||||||||
| CT_RTE_TYPES_SORT | |||||||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | RTE_TYPE_ID | Unique Route Type ID | numeric(2,0) | NO | ||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | ROUTE_TYPE | Route Type Abbreviation | varchar(2) | NO | ||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | IS_OBSOLETE | Is Obsolete | numeric(1,0) | NO | ||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | RTE_TYPE | Route Type Description | varchar(240) | NO | ||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | UPDT_BY | Updated By | varchar(41) | NO | ||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | UPDT_ON | Updated Date | date | NO | ||||||||||||
| CT_RTE_TYPES_SORT | Route Types Sort | SORT_ORDER | Sort Order | tinyint | YES | ||||||||||||
| DT_COUNTIES | |||||||||||||||||
| DT_COUNTIES | County Code List | COUNTY_ID | Unique County ID | numeric(2,0) | NO | ||||||||||||
| DT_COUNTIES | County Code List | COUNTY | County Name | varchar(240) | NO | ||||||||||||
| DT_COUNTIES | County Code List | FIPS_COUNTY_ID | FIPS County ID | numeric(2,0) | NO | ||||||||||||
| DT_COUNTIES | County Code List | DISTRICT_ID | Related Engineering District | numeric(1,0) | NO | ||||||||||||
| DT_COUNTIES | County Code List | HURR_EVAC_RGN_ID | Hurricane Evacuation Region ID | numeric(1,0) | YES | ||||||||||||
| DT_COUNTIES | County Code List | MSLINK | MS Link | numeric(10,0) | NO | ||||||||||||
| DT_COUNTIES | County Code List | MAPID | Unique Map ID | numeric(5,0) | NO | ||||||||||||
| DT_COUNTIES | County Code List | UPDT_BY | Updated By | varchar(41) | NO | ||||||||||||
| DT_COUNTIES | County Code List | UPDT_ON | Updated Date | date | NO | ||||||||||||
| HMMS_ASSETS | |||||||||||||||||
| HMMS_ASSETS | HMMS Assets Code List | DESCR | HMMS Asset Description | varchar(50) | NO | ||||||||||||
| HMMS_ASSETS | HMMS Assets Code List | ASSET_GRP_ID | HMMS Asset Group ID | numeric(3,0) | NO | ||||||||||||
| HMMS_ASSETS_LANDSCAPE | |||||||||||||||||
| HMMS_ASSETS_LANDSCAPE | HMMS Assets Landscape Type Code List | DESCR | HMMS Asset Description | varchar(50) | NO | ||||||||||||
| HMMS_ASSETS_LANDSCAPE | HMMS Assets Landscape Type Code List | ASSET_GRP_ID | HMMS Asset Group ID | numeric(2,0) | NO | ||||||||||||
| HMMS_ASSETS_LANDSCAPE | HMMS Assets Landscape Type Code List | PLOT_TYPE_ID | Plot Type ID | numeric(2,0) | NO | ||||||||||||
| INFO_TYPES7 | |||||||||||||||||
| INFO_TYPES7 | ITMS Information Types | INFORMATION | Information | varchar(24) | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | SUB_SYSTEM | System Stored | varchar(24) | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | DESCR | Description of Information | varchar(240) | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | EXPOSED | Exposed Indicator | tinyint | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | COMMON | Common Indicator | tinyint | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | HINT | Hint | varchar(128) | YES | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | HAS_CODELIST | Has Code List Indicator | tinyint | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | IS_NUMERIC | Is Numeric Indicator | tinyint | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | POINT_IDENTIFIER | Point Identifier (Bridge, Signal) | varchar(50) | YES | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | CATEGORY | ITMS Category | varchar(50) | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | PCN_COMMON | PCN Common Indicator | tinyint | NO | ||||||||||||
| INFO_TYPES7 | ITMS Information Types | ROUTEINFO | Route Info Indicator | tinyint | YES | ||||||||||||
| INTERSECTION_DETAILS | |||||||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | ID | Unique Key | int | NO | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | INTSECT_ID | Intersection ID | int | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | MAJ_LRS | Major Route LRS | varchar(12) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | MAJ_MP | Major Route Milepoint | float | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | MIN_LRS | Minor Route LRS | varchar(12) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | MIN_MP | Minor Route Milepoint | float | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | CONTROL_TYPE | Traffic Control Type | varchar(50) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | SPEED_LIMIT | Speed Limit | int | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | MAJ_LANES | Major Route No. of Lanes | int | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | MIN_LANES | Minor Route No. of Lanes | int | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | CITY | City | varchar(127) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | COLLECTION_DATE | Collection Date | date | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | WEEK_DAY | Week Day | varchar(50) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | NAME | Name | varchar(127) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | WEATHER | Weather | varchar(50) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | ADT | Average Daily Traffic (ADT) | int | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | TOTAL_VOLUME | Total Traffic Volume | int | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | HOUR_COUNT | Hourly Count | decimal(18,2) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | XLS | Excel Filename | varchar(255) | YES | ||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | PDF Filename | varchar(255) | YES | |||||||||||||
| INTERSECTION_DETAILS | Turning Movement Counts | USERNAME | Username | varchar(127) | YES | ||||||||||||
| ITMS_CONFIG | |||||||||||||||||
| ITMS_CONFIG | ITMS Configuration | CATEGORY | Configuration Category | varchar(40) | NO | ||||||||||||
| ITMS_CONFIG | ITMS Configuration | SUB_CATEGORY | Configuration SubCategory | varchar(40) | NO | ||||||||||||
| ITMS_CONFIG | ITMS Configuration | VAL | Value | varchar(3200) | YES | ||||||||||||
| ITMS_CONFIG | ITMS Configuration | UPDT_BY | Updated By | varchar(41) | YES | ||||||||||||
| ITMS_CONFIG | ITMS Configuration | UPDT_ON | Updated Date | datetime | YES | ||||||||||||
| ITMS_CONFIG | ITMS Configuration | DESC | Description | varchar(512) | YES | ||||||||||||
| ITMS_CONFIG | ITMS Configuration | AXOSOFT | Axosoft Ticket ID | varchar(64) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | |||||||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | PCN | PCN Number & Suffix | varchar(32) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | COUNTY_ID | County ID | int | COUNTIES | YES | |||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | RTE_TYPE_ID | Route Type ID | int | CT_RTE_TYPES | YES | |||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | RTE_NBR | Route Number | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | RTE_AUX_ID | Route Auxiliary ID | int | CT_RTE_AUX_IDS | YES | |||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | MP | Milepoint | numeric(6,3) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | RTE_TYPE_ID_XED | Route Type ID Modified | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | RTE_NBR_XED | Route Number Modified | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | RTE_AUX_ID_XED | Route Auxiliary ID Modified | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | MP_XED | Milepoint Modified | numeric(6,3) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | ENGR_DISTRICT | Engineering District | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | CNGR_DISTRICT | Congressional District | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | ENGR_RANK | Engineering Rank | varchar(3) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | PROJ_RANK | Project Rank | int | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | FUNDING_SRC | Funding Source | varchar(100) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | INT_TYPE | Intersection Type | varchar(50) | YES | ||||||||||||
| LOW_COST_INTERSECTIONS | Low Cost Intersections (Active Projects) | ID | Unique Key | int | NO | ||||||||||||
| LUPostingStatus | |||||||||||||||||
| LUPostingStatus | Posting Status Code List | LUPostingStatusID | Unique Posting Status ID | nvarchar(2) | NO | ||||||||||||
| LUPostingStatus | Posting Status Code List | PostingStatusName | Posting Status Name | nvarchar(250) | YES | ||||||||||||
| LUPostingStatus | Posting Status Code List | IsObsolete | Is Obsolete | bit | YES | ||||||||||||
| LUPostingStatus | Posting Status Code List | DisplayOrder | Display Order | int | YES | ||||||||||||
| MAP_CONNECTION | |||||||||||||||||
| MAP_CONNECTION | Map Connection | CONNECTION_DESC | Connection Description | nvarchar(40) | NO | ||||||||||||
| MAP_CONNECTION | Map Connection | CONNECTION_NAME | Connection Name | nvarchar(40) | NO | ||||||||||||
| MAP_CONNECTION | Map Connection | CONNECTION_CONFIG | Connection Configuration Name | varchar(40) | NO | ||||||||||||
| MAP_CONNECTION | Map Connection | BASEMAP | Base Map | char | NO | ||||||||||||
| MAP_CONNECTION | Map Connection | GDOSERVER | GIS Data Objects Server | nvarchar(40) | YES | ||||||||||||
| MAP_CONNECTION | Map Connection | DBNAME | Database Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | |||||||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FEATURE_ID | Unique Feature ID | int | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FEATURE_NAME | Feature Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FEATURE_SET_NAME | Feature Set Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | TABLE_NAME | Table Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | QUERY_NAME | Query Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | CONNECTION_NAME | Connection Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | WHERE_CLAUSE | Where Clause | nvarchar(256) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | SHEET_NAME | Sheet Name | nvarchar(80) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | STYLE_FILE | Style File Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | PRIORITY | Priority | int | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | RANGE_CRITERIA_NAME | Range Criteria Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | MIN_RANGE | Minimum Range | numeric(10,0) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | MAX_RANGE | Maximum Range | numeric(18,0) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | TOOLTIP | Tooltip | nvarchar(256) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | BASEMAP | Base Map | char | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FEATURE_ACTION | Feature Action | nvarchar(255) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FEATURE_GROUP | Feature Group | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FEATURE_TYPE | Feature Type | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | SYMBOL_BITMAP | Symbol Bitmap | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | FILL | Fill Hex Color | nvarchar(10) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | STROKE | Stroke Hex Color | nvarchar(10) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | STROKE_WIDTH | Stroke Width | int | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | GEOMETRY | Geometry | nvarchar(64) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND | Map Features with Legend | LINE_TYPE | Line Type | nvarchar(32) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | |||||||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FEATURE_ID | Unique Feature ID | int | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FEATURE_NAME | Feature Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FEATURE_SET_NAME | Feature Set Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | TABLE_NAME | Table Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | QUERY_NAME | Query Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | CONNECTION_NAME | Connection Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | WHERE_CLAUSE | Where Clause | nvarchar(256) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | SHEET_NAME | Sheet Name | nvarchar(80) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | STYLE_FILE | Style File Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | PRIORITY | Priority | int | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | RANGE_CRITERIA_NAME | Range Criteria Name | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | MIN_RANGE | Minimum Range | numeric(10,0) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | MAX_RANGE | Maximum Range | numeric(18,0) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | TOOLTIP | Tooltip | nvarchar(256) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | BASEMAP | Base Map | char | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FEATURE_ACTION | Feature Action | nvarchar(255) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FEATURE_GROUP | Feature Group | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FEATURE_TYPE | Feature Type | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | SYMBOL_BITMAP | Symbol Bitmap | nvarchar(40) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | FILL | Fill Hex Color | nvarchar(10) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | STROKE | Stroke Hex Color | nvarchar(10) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | STROKE_WIDTH | Stroke Width | int | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | GEOMETRY | Geometry | nvarchar(64) | YES | ||||||||||||
| MAP_FEATURES_WITH_LEGEND_BACKUP | Backup of Map Features with Legend Table | LINE_TYPE | Line Type | nvarchar(32) | YES | ||||||||||||
| MAP_GENERAL_PARAMS | |||||||||||||||||
| MAP_GENERAL_PARAMS | Map General Parameters | PAN_AMOUNT | Map Pan Amount | numeric(18,3) | YES | ||||||||||||
| MAP_GENERAL_PARAMS | Map General Parameters | ZOOM_AMOUNT | Map Zoom Amount | numeric(18,3) | YES | ||||||||||||
| MAP_GENERAL_PARAMS | Map General Parameters | SNAP_TOLERANCE | Map Snap Tolerance | numeric(18,3) | YES | ||||||||||||
| REGISTERED_USERS | |||||||||||||||||
| REGISTERED_USERS | Registered Users | TYPE | User Type | varchar(127) | NO | ||||||||||||
| REGISTERED_USERS | Registered Users | USERNAME | User Name | varchar(127) | NO | ||||||||||||
| REGISTERED_USERS | Registered Users | FIRST_NAME | First Name | varchar(127) | NO | ||||||||||||
| REGISTERED_USERS | Registered Users | LAST_NAME | Last Name | varchar(127) | NO | ||||||||||||
| REPORT_TYPES | |||||||||||||||||
| REPORT_TYPES | Report Types (Active Projects) | REPORT_ID | Unique Report ID | int | NO | ||||||||||||
| REPORT_TYPES | Report Types (Active Projects) | REPORT_CATEGORY | Report Category Name | varchar(50) | NO | ||||||||||||
| REPORT_TYPES | Report Types (Active Projects) | REPORT_NAME | Report Name | varchar(100) | NO | ||||||||||||
| REPORT_TYPES | Report Types (Active Projects) | REPORT_DESCR | Report Description | varchar(255) | NO | ||||||||||||
| REPORT_TYPES | Report Types (Active Projects) | REPORT_ORDER | Report Order | int | NO | ||||||||||||
| resurfacing_lrs | |||||||||||||||||
| resurfacing_lrs | Resurfacing LRS | filenumber | File Number | varchar(50) | NO | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | county | County | int | NO | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | route | Route | varchar(20) | NO | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | bmp | Beginning Milepoint | real | NO | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | emp | Ending Milepoint | real | NO | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | road_name | Road Name | varchar(50) | YES | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | begin_desc | Beginning Description | varchar(50) | YES | ||||||||||||
| resurfacing_lrs | Resurfacing LRS | end_desc | Ending Description | varchar(50) | YES | ||||||||||||
| ROUTE_MOD_LOG | |||||||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | OPERATION | Route Modification Operation | varchar(50) | NO | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | PCN | PCN Number | varchar(50) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | BEFORE_RTE_LRS | Before Route LRS | varchar(12) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | BEFORE_BMP | Before Route Beginning Milepoint | numeric(6,3) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | BEFORE_EMP | Before Route Ending Milepoint | numeric(6,3) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | AFTER_RTE_LRS | After Route LRS | varchar(12) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | AFTER_BMP | After Route Beginning Milepoint | numeric(6,3) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | AFTER_EMP | After Route Ending Milepoint | numeric(6,3) | YES | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | MOD_SEQ | Modification Sequence | int | NO | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | MOD_USER | Modification User | varchar(50) | NO | ||||||||||||
| ROUTE_MOD_LOG | Route Modification Log | MOD_TIME | Modification Date | datetime | NO | ||||||||||||
| ROUTEINFO_SLOTDATA | |||||||||||||||||
| ROUTEINFO_SLOTDATA | ITMS Users Route Info Selection Data | USERNAME | User Name ID | varchar(50) | NO | ||||||||||||
| ROUTEINFO_SLOTDATA | ITMS Users Route Info Selection Data | APPNAME | Application Name | varchar(50) | NO | ||||||||||||
| ROUTEINFO_SLOTDATA | ITMS Users Route Info Selection Data | SLOTONE | Slot One | varchar(50) | YES | ||||||||||||
| ROUTEINFO_SLOTDATA | ITMS Users Route Info Selection Data | SLOTTWO | Slot Two | varchar(50) | YES | ||||||||||||
| ROUTEINFO_SLOTDATA | ITMS Users Route Info Selection Data | SLOTTHREE | Slot Three | varchar(50) | YES | ||||||||||||
| ROUTES | |||||||||||||||||
| ROUTES | Routes | ROUTE_LRS | Route LRS | varchar(12) | NO | ||||||||||||
| ROUTES | Routes | COUNTY_ID | County ID | tinyint | COUNTIES | NO | |||||||||||
| ROUTES | Routes | RTE_TYPE_ID | Route Type ID | tinyint | CT_RTE_TYPES | NO | |||||||||||
| ROUTES | Routes | RTE_NBR | Route Number | int | NO | ||||||||||||
| ROUTES | Routes | RTE_AUX_ID | Route Auxiliary ID | tinyint | CT_RTE_AUX_IDS | NO | |||||||||||
| ROUTES | Routes | RTE_DIR | Route Direction | varchar(2) | NO | ||||||||||||
| ROUTES | Routes | IS_DIR_OF_CHG | Is Direction of Change Indicator | tinyint | NO | ||||||||||||
| ROUTES | Routes | RTE_BMP | Route Beginning Milepoint | decimal(6,3) | NO | ||||||||||||
| ROUTES | Routes | RTE_EMP | Route Ending Milepoint | decimal(6,3) | NO | ||||||||||||
| RPGS | |||||||||||||||||
| RPGS | RPGs | RPGID | Unique RPG ID | char(10) | NO | ||||||||||||
| RPGS | RPGs | DESCRIPTION | RPG Description | varchar(255) | NO | ||||||||||||
| RPGS | RPGs | COUNTIES | County IDs associated with RPG | varchar(255) | NO | ||||||||||||
| RTE_SEGS | |||||||||||||||||
| RTE_SEGS | Route Segments | ROUTE_LRS | Route LRS | varchar(12) | NO | ||||||||||||
| RTE_SEGS | Route Segments | SEG_BMP | Segment Beginning Milepoint | decimal(6,3) | NO | ||||||||||||
| RTE_SEGS | Route Segments | SEG_EMP | Segment Ending Milepoint | decimal(6,3) | NO | ||||||||||||
| RTE_SEGS | Route Segments | SEG_SEQ | Segment Sequence | tinyint | NO | ||||||||||||
| RTE_SEG_OVERLAPS | |||||||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_RTE_LRS | Dominant Route LRS | varchar(12) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | COUNTY_ID | County ID | tinyint | COUNTIES | NO | |||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_RTE_TYPE_ID | Dominant Route Type ID | tinyint | CT_RTE_TYPES | NO | |||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_RTE_NBR | Dominant Route Number | int | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_RTE_AUX_ID | Dominant Route Auxiliary ID | tinyint | CT_RTE_AUX_IDS | NO | |||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_RTE_DIR | Dominant Route Direction | varchar(1) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_SEG_BMP | Dominant Segment Beginning Milepoint | decimal(6,3) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | DOM_SEG_EMP | Dominant Segment Ending Milepoint | decimal(6,3) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_RTE_LRS | Subordinate Route LRS | varchar(12) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_RTE_TYPE_ID | Subordinate Route Type ID | tinyint | CT_RTE_TYPES | NO | |||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_RTE_NBR | Subordinate Route Number | int | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_RTE_AUX_ID | Subordinate Route Auxiliary ID | tinyint | CT_RTE_AUX_IDS | NO | |||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_RTE_DIR | Subordinate Route Direction | varchar(1) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_SEG_BMP | Subordinate Segment Beginning Milepoint | decimal(6,3) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_SEG_EMP | Subordinate Segment Ending Milepoint | decimal(6,3) | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | IS_MILEAGE_REV | Is Mileage Reversed Indicator | tinyint | NO | ||||||||||||
| RTE_SEG_OVERLAPS | Route Segment Overlaps | SUB_SEQ_SEQ | Subordinate Segment Sequence | tinyint | NO | ||||||||||||
| RteAuxCategory | |||||||||||||||||
| RteAuxCategory | Route Auxiliary Category | ID | Unique Route Auxiliary Category ID | int | NO | ||||||||||||
| RteAuxCategory | Route Auxiliary Category | Code | Route Auxiliary Code | varchar(256) | NO | ||||||||||||
| RteAuxCategory | Route Auxiliary Category | Description | Route Auxiliary Description | varchar(64) | NO | ||||||||||||
| RteAuxCategory | Route Auxiliary Category | DisplayOrder | Display Order | int | YES | ||||||||||||
| Signal_Type | |||||||||||||||||
| Signal_Type | Signal Type Code List | SgnlTypNum | Signal Type ID | char(2) | NO | ||||||||||||
| Signal_Type | Signal Type Code List | SgnlTypDesc | Signal Type Description | char(80) | YES | ||||||||||||
| SignalCategory | |||||||||||||||||
| SignalCategory | Signal Category Code List | SIGNALCATEGORY | Signal Category ID | char(2) | NO | ||||||||||||
| SignalCategory | Signal Category Code List | SIGNALTYPE | Associated Signal Types | varchar(255) | NO | ||||||||||||
| SignalCategory | Signal Category Code List | DESCRIPTION | Signal Category Description | varchar(255) | NO | ||||||||||||
| SignalTypeSymbology | |||||||||||||||||
| SignalTypeSymbology | Signal Type Symbology Code List | SIGNALTYPE | Signal Type Symbology ID | char(2) | NO | ||||||||||||
| SignalTypeSymbology | Signal Type Symbology Code List | SYMBOLOGY | Signal Type Symbology | varchar(255) | NO | ||||||||||||
| SignType | |||||||||||||||||
| SignType | Sign Type Code List | Code | Sign Type ID | varchar(32) | YES | ||||||||||||
| SignType | Sign Type Code List | Description | Sign Type Description | varchar(32) | YES | ||||||||||||
| SignType | Sign Type Code List | DisplayOrder | Display Order | int | YES | ||||||||||||
| StreetNameMessages | |||||||||||||||||
| StreetNameMessages | Street Name Messages | County | County Message | int | NO | ||||||||||||
| StreetNameMessages | Street Name Messages | State | State Message | varchar(255) | YES | ||||||||||||
| StreetNameMessages | Street Name Messages | Local | Local Message | varchar(255) | YES | ||||||||||||
| StreetNameMessages | Street Name Messages | NotFound | Not Found Message | varchar(255) | YES | ||||||||||||
| tblActionTypes | |||||||||||||||||
| tblActionTypes | Action Types Code List | ID | Action Type Unique ID | int | NO | ||||||||||||
| tblActionTypes | Action Types Code List | ActionType | Action Type Description | varchar(32) | YES | ||||||||||||
| tblAnticipatedOpening | |||||||||||||||||
| tblAnticipatedOpening | Anticipated Opening Type Code List | Code | Anticipated Opening Type ID | int | NO | ||||||||||||
| tblAnticipatedOpening | Anticipated Opening Type Code List | AnticipatedOpening | Anticipated Opening Type Description | varchar(50) | NO | ||||||||||||
| tblCounty | |||||||||||||||||
| tblCounty | County Code List | county_id | Unique County ID | int | NO | ||||||||||||
| tblCounty | County Code List | county_name | County Name | varchar(30) | NO | ||||||||||||
| tblCounty | County Code List | actual_county | Actual County | int | YES | ||||||||||||
| tblCounty | County Code List | fk_cty_district_id | Engineering District | int | NO | ||||||||||||
| tblCounty | County Code List | status | Status | tinyint | YES | ||||||||||||
| tblCounty | County Code List | status_date | Status Date | datetime | YES | ||||||||||||
| tblCounty_intergraph | |||||||||||||||||
| tblCounty_intergraph | Copy of tblCounty table | county_id | Unique County ID | int | NO | ||||||||||||
| tblCounty_intergraph | Copy of tblCounty table | county_name | County Name | varchar(30) | NO | ||||||||||||
| tblCounty_intergraph | Copy of tblCounty table | actual_county | Actual County | int | YES | ||||||||||||
| tblCounty_intergraph | Copy of tblCounty table | fk_cty_district_id | Engineering District | int | NO | ||||||||||||
| tblCounty_intergraph | Copy of tblCounty table | status | Status | tinyint | YES | ||||||||||||
| tblCounty_intergraph | Copy of tblCounty table | status_date | Status Date | datetime | YES | ||||||||||||
| tblDamageTypes | |||||||||||||||||
| tblDamageTypes | Damage Types Code List | Code | Unique Damage Types ID | int | NO | ||||||||||||
| tblDamageTypes | Damage Types Code List | DamageType | Damage Type Description | varchar(50) | YES | ||||||||||||
| tblDistrict | |||||||||||||||||
| tblDistrict | Engineering District Code List | district_id | Unique District ID | int | NO | ||||||||||||
| tblDistrict | Engineering District Code List | district_name | District Name | varchar(15) | YES | ||||||||||||
| tblDistrict | Engineering District Code List | status | Status | tinyint | NO | ||||||||||||
| tblDistrict | Engineering District Code List | status_date | Status Date | datetime | YES | ||||||||||||
| tblEmergency | |||||||||||||||||
| tblEmergency | Emergency Events | Condition | Emergency Event Name | varchar(127) | NO | ||||||||||||
| tblEmergency | Emergency Events | Active | Active Indicator | bit | NO | ||||||||||||
| tblEmergency | Emergency Events | DefaultOption | Default Option | int | YES | ||||||||||||
| tblEmergency | Emergency Events | AvailableOptions | Available Options | varchar(50) | YES | ||||||||||||
| tblEmergency | Emergency Events | DateLogic | Date Logic | varchar(2048) | YES | ||||||||||||
| tblEmergency | Emergency Events | ColorLogic | Color Logic | varchar(2048) | YES | ||||||||||||
| tblEmergency | Emergency Events | OrderBy | Order By | int | NO | ||||||||||||
| tblEquipment | |||||||||||||||||
| tblEquipment | Equipment | equipment_id | Unique Equipment ID | int | NO | ||||||||||||
| tblEquipment | Equipment | fk_equ_equipment_class_id | Equipment Class ID | int | tblEquipment_Class | NO | |||||||||||
| tblEquipment | Equipment | equipment_number | Equipment Number | char | YES | ||||||||||||
| tblEquipment | Equipment | equipment_name | Equipment Name | varchar(30) | YES | ||||||||||||
| tblEquipment | Equipment | rental_rate | Rental Rate | money | YES | ||||||||||||
| tblEquipment | Equipment | fk_equ_crew_id | Equipment Crew ID | int | YES | ||||||||||||
| tblEquipment | Equipment | equ_dwr_print | Equipment DWR Print | tinyint | YES | ||||||||||||
| tblEquipment | Equipment | status | Status | tinyint | YES | ||||||||||||
| tblEquipment | Equipment | status_date | Status Date | datetime | YES | ||||||||||||
| tblEquipment_Class | |||||||||||||||||
| tblEquipment_Class | Equipment Class Code List | equipment_class_id | Unique Equipment Class ID | int | NO | ||||||||||||
| tblEquipment_Class | Equipment Class Code List | class_name | Class Name | varchar(30) | YES | ||||||||||||
| tblEquipment_Class | Equipment Class Code List | class_def_rate | Class Default Rate | money | YES | ||||||||||||
| tblEquipment_Class | Equipment Class Code List | status | Status | tinyint | NO | ||||||||||||
| tblEquipment_Class | Equipment Class Code List | status_date | Status Date | datetime | YES | ||||||||||||
| tblIIStatus | |||||||||||||||||
| tblIIStatus | Status Code List | PKStatusID | Unique Status ID | int | NO | ||||||||||||
| tblIIStatus | Status Code List | StatusDescription | Status Description | varchar(50) | NO | ||||||||||||
| tblInterstateInfo | |||||||||||||||||
| tblInterstateInfo | Interstate Information | InterstateID | Interstate Information ID | varchar(10) | NO | ||||||||||||
| tblInterstateInfo | Interstate Information | IIStatusID | Interstate Information Status ID | int | NO | ||||||||||||
| tblInterstateInfo | Interstate Information | ImageName | Image Name | varchar(30) | YES | ||||||||||||
| tblLaneClosureCondition | |||||||||||||||||
| tblLaneClosureCondition | Lane Closure Conditions Code List | ID | Unique Lane Closure Conditions ID | int | NO | ||||||||||||
| tblLaneClosureCondition | Lane Closure Conditions Code List | Description | Lane Closure Condition Description | varchar(64) | NO | ||||||||||||
| tblLaneClosureCondition | Lane Closure Conditions Code List | SortOrder | Sort Order | int | YES | ||||||||||||
| tblMaterial | |||||||||||||||||
| tblMaterial | Material | material_id | Unique Material ID | int | NO | ||||||||||||
| tblMaterial | Material | material_name | Material Name | varchar(40) | YES | ||||||||||||
| tblMaterial | Material | commodity_code | Commodity Code | int | YES | ||||||||||||
| tblMaterial | Material | fk_mat_unit_of_measure_id | Material Unit of Measure ID | int | YES | ||||||||||||
| tblMaterial | Material | default_cost | Default Cost | money | YES | ||||||||||||
| tblMaterial | Material | status | Status | tinyint | NO | ||||||||||||
| tblMaterial | Material | status_date | Status Date | datetime | YES | ||||||||||||
| tblPredefinedDescriptions | |||||||||||||||||
| tblPredefinedDescriptions | Predefined Descriptions Code List | ID | Unique Predefined Description ID | int | NO | ||||||||||||
| tblPredefinedDescriptions | Predefined Descriptions Code List | Condition | Predefined Description Condition | varchar(64) | NO | ||||||||||||
| tblPredefinedDescriptions | Predefined Descriptions Code List | Description | Predefined Description | varchar(512) | NO | ||||||||||||
| tblPredefinedDescriptions | Predefined Descriptions Code List | SortOrder | Sort Order | int | YES | ||||||||||||
| tblPredefinedDescriptions | Predefined Descriptions Code List | Type | Predefined Description Type | int | YES | ||||||||||||
| tblPRInfo | |||||||||||||||||
| tblPRInfo | Public Report Information | PKPRID | Unique Public Report ID | int | NO | ||||||||||||
| tblPRInfo | Public Report Information | FKPRType | Public Report Type ID | int | tblPRTypes | NO | |||||||||||
| tblPRInfo | Public Report Information | DateCreated | Date Created | datetime | YES | ||||||||||||
| tblPRInfo | Public Report Information | CreatedByUserID | Created By User ID | varchar(15) | YES | ||||||||||||
| tblPRInfo | Public Report Information | Title | Report Title | varchar(250) | YES | ||||||||||||
| tblPRInfo | Public Report Information | BriefDetail | Report Brief Detail | varchar(250) | YES | ||||||||||||
| tblPRInfo | Public Report Information | ShowOnWeb | Report Show on Web Indicator | tinyint | YES | ||||||||||||
| tblPRInfo | Public Report Information | PRDetail | Report Detail | image | YES | ||||||||||||
| tblPRInfo | Public Report Information | PRDetail2 | Report Detail 2 | text | YES | ||||||||||||
| tblPRTypes | |||||||||||||||||
| tblPRTypes | Public Report Types Code List | PKPRType | Unique Public Report Type ID | int | NO | ||||||||||||
| tblPRTypes | Public Report Types Code List | PRTypeDesc | Public Report Type Description | varchar(25) | NO | ||||||||||||
| tblRCTypes | |||||||||||||||||
| tblRCTypes | Road Conditions Types Code List | PKRCTypeID | Unique RC Types ID | int | NO | ||||||||||||
| tblRCTypes | Road Conditions Types Code List | TypeDescription | RC Type Description | varchar(25) | YES | ||||||||||||
| tblRoadCloseNew | |||||||||||||||||
| tblRoadCloseNew | New Road Closures | ID | Unique Road Closure ID | int | NO | ||||||||||||
| tblRoadCloseNew | New Road Closures | CO NO | Road Closure County ID | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | district_id | Road Closure District ID | float | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | roadname | Road Closure Road Name | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | FILE | Road Closure File Number | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | RCFROM | Road Closure From | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | RCTO | Road Closure To | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | Description | Road Closure Description | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | LENGTH | Road Closure Length | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | Time Frame | Road Closure Time Frame | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | Remarks | Road Closure Remarks | nvarchar(255) | YES | ||||||||||||
| tblRoadCloseNew | New Road Closures | RCTYPE | Road Closure Type | int | YES | ||||||||||||
| tblRoadClosureArchive | |||||||||||||||||
| tblRoadClosureArchive | Road Closures Archive | PKRoadClosedID | Unique Road Closure ID | int | NO | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | FKClosureType | Road Closure Type | int | NO | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | FKRoadType | Road Closure Road Type | int | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RoadNumber | Road Closure Road Number | varchar(10) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | FKRoadCounty | Road Closure County | int | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | FKRoadCountyEnd | Road Closure Road County End | int | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | DateBeg | Road Closure Begin Date | datetime | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | DateEnd | Road Closure End Date | datetime | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RoadName | Road Closure Road Name | varchar(50) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RCFrom | Road Closure From | varchar(50) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RCFromMP | Road Closure From Milepoint | float | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RCTo | Road Closure To | varchar(50) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RCToMP | Road Closure To Milepoint | float | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RCDescription | Road Closure Description | varchar(250) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | RCStatus | Road Closure Status | varchar(15) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | FKSourceInfoID | Source Info ID | int | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | CreatedByUserID | Created By User ID | varchar(30) | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | DateCreated | Date Created | datetime | YES | ||||||||||||
| tblRoadClosureArchive | Road Closures Archive | ApprovedByUserID | Approved By User ID | varchar(30) | YES |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .