Name: LOTTR_TTTR_table_all_years.csv

Display Field: timezone_name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• tmc (type: esriFieldTypeString, alias: tmc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• road (type: esriFieldTypeString, alias: road, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• direction (type: esriFieldTypeString, alias: direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• intersection (type: esriFieldTypeString, alias: intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: state, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• zip (type: esriFieldTypeInteger, alias: zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• start_latitude (type: esriFieldTypeDouble, alias: start_latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• start_longitude (type: esriFieldTypeDouble, alias: start_longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• end_latitude (type: esriFieldTypeDouble, alias: end_latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• end_longitude (type: esriFieldTypeDouble, alias: end_longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• miles (type: esriFieldTypeDouble, alias: miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• road_order (type: esriFieldTypeDouble, alias: road_order, SQL Type: sqlTypeOther, nullable: true, editable: true)
• timezone_name (type: esriFieldTypeString, alias: timezone_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• type (type: esriFieldTypeString, alias: type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• country (type: esriFieldTypeString, alias: country, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• tmclinear (type: esriFieldTypeInteger, alias: tmclinear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• frc (type: esriFieldTypeInteger, alias: frc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• border_set (type: esriFieldTypeString, alias: border_set, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• f_system (type: esriFieldTypeInteger, alias: f_system, SQL Type: sqlTypeOther, nullable: true, editable: true)
• urban_code (type: esriFieldTypeInteger, alias: urban_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• faciltype (type: esriFieldTypeInteger, alias: faciltype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• structype (type: esriFieldTypeString, alias: structype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• thrulanes (type: esriFieldTypeInteger, alias: thrulanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• route_numb (type: esriFieldTypeString, alias: route_numb, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• route_sign (type: esriFieldTypeInteger, alias: route_sign, SQL Type: sqlTypeOther, nullable: true, editable: true)
• route_qual (type: esriFieldTypeInteger, alias: route_qual, SQL Type: sqlTypeOther, nullable: true, editable: true)
• altrtename (type: esriFieldTypeString, alias: altrtename, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• aadt (type: esriFieldTypeInteger, alias: aadt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aadt_singl (type: esriFieldTypeInteger, alias: aadt_singl, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aadt_combi (type: esriFieldTypeInteger, alias: aadt_combi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nhs (type: esriFieldTypeInteger, alias: nhs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nhs_pct (type: esriFieldTypeInteger, alias: nhs_pct, SQL Type: sqlTypeOther, nullable: true, editable: true)
• strhnt_typ (type: esriFieldTypeInteger, alias: strhnt_typ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• strhnt_pct (type: esriFieldTypeInteger, alias: strhnt_pct, SQL Type: sqlTypeOther, nullable: true, editable: true)
• truck (type: esriFieldTypeInteger, alias: truck, SQL Type: sqlTypeOther, nullable: true, editable: true)
• isprimary (type: esriFieldTypeInteger, alias: isprimary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• active_start_date (type: esriFieldTypeString, alias: active_start_date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• active_end_date (type: esriFieldTypeString, alias: active_end_date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Start_Lat_Long (type: esriFieldTypeString, alias: Start_Lat_Long, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Start_Lat_Long_X (type: esriFieldTypeDouble, alias: Start_Lat_Long_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Start_Lat_Long_Y (type: esriFieldTypeDouble, alias: Start_Lat_Long_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• End_Lat_Long (type: esriFieldTypeString, alias: End_Lat_Long, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• End_Lat_Long_X (type: esriFieldTypeDouble, alias: End_Lat_Long_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• End_Lat_Long_Y (type: esriFieldTypeDouble, alias: End_Lat_Long_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NHS_length (type: esriFieldTypeDouble, alias: NHS_length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOTTR_Binary (type: esriFieldTypeInteger, alias: LOTTR_Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOTTR_Period_1 (type: esriFieldTypeDouble, alias: LOTTR_Period_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOTTR_Period_2 (type: esriFieldTypeDouble, alias: LOTTR_Period_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOTTR_Period_3 (type: esriFieldTypeDouble, alias: LOTTR_Period_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOTTR_Period_4 (type: esriFieldTypeDouble, alias: LOTTR_Period_4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOTTR_Period_12 (type: esriFieldTypeString, alias: LOTTR_Period_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_23 (type: esriFieldTypeString, alias: LOTTR_Period_2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_34 (type: esriFieldTypeString, alias: LOTTR_Period_3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_45 (type: esriFieldTypeString, alias: LOTTR_Period_4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_1_50th (type: esriFieldTypeString, alias: LOTTR_Period_1_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_1_80th (type: esriFieldTypeString, alias: LOTTR_Period_1_80th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_2_50th (type: esriFieldTypeString, alias: LOTTR_Period_2_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_2_80th (type: esriFieldTypeString, alias: LOTTR_Period_2_80th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_3_50th (type: esriFieldTypeString, alias: LOTTR_Period_3_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_3_80th (type: esriFieldTypeString, alias: LOTTR_Period_3_80th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_4_50th (type: esriFieldTypeString, alias: LOTTR_Period_4_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOTTR_Period_4_80th (type: esriFieldTypeString, alias: LOTTR_Period_4_80th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_4 (type: esriFieldTypeString, alias: TTTR_Period_4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_5 (type: esriFieldTypeString, alias: TTTR_Period_5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_1_50th (type: esriFieldTypeString, alias: TTTR_Period_1_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_1_95th (type: esriFieldTypeString, alias: TTTR_Period_1_95th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_2_50th (type: esriFieldTypeString, alias: TTTR_Period_2_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_2_95th (type: esriFieldTypeString, alias: TTTR_Period_2_95th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_3_50th (type: esriFieldTypeString, alias: TTTR_Period_3_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_3_95th (type: esriFieldTypeString, alias: TTTR_Period_3_95th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_4_50th (type: esriFieldTypeString, alias: TTTR_Period_4_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_4_95th (type: esriFieldTypeString, alias: TTTR_Period_4_95th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_5_50th (type: esriFieldTypeString, alias: TTTR_Period_5_50th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TTTR_Period_5_95th (type: esriFieldTypeString, alias: TTTR_Period_5_95th, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• year (type: esriFieldTypeInteger, alias: year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• f_system_label (type: esriFieldTypeString, alias: f_system_label, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• urban_rural (type: esriFieldTypeString, alias: urban_rural, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Avg_LOTTR (type: esriFieldTypeDouble, alias: Average LOTTR (4 periods), SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: LOTTR_TTTR_table_all_years.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/5/2024 6:05:47 AM

Schema Last Edit Date: 5/5/2024 6:05:47 AM

Data Last Edit Date: 5/5/2024 6:05:44 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat