Name: TMCRecordsLocal

Display Field: Report_Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Town (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Amherst: Amherst], [Brookline: Brookline], [Hollis: Hollis], ... 10 more ...)
• Rd1 (type: esriFieldTypeString, alias: Rd1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Rd2 (type: esriFieldTypeString, alias: Rd2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Time_Start (type: esriFieldTypeString, alias: Time Start, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Time_End (type: esriFieldTypeString, alias: Time End, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Day_of_Week (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Monday: Monday], [Tuesday: Tuesday], [Wednesday: Wednesday], ... 4 more ...)
• Report_Name (type: esriFieldTypeString, alias: Report Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Report_URL (type: esriFieldTypeString, alias: Report URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TMCNumber (type: esriFieldTypeString, alias: TMCNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• filetype (type: esriFieldTypeString, alias: filetype, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Excel: Excel], [PDF: PDF])
• CountDate (type: esriFieldTypeString, alias: CountDateString, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CMPCorridor (type: esriFieldTypeString, alias: CMPCorridor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Amherst Rd: Amherst Rd], [Continental Blvd: Continental Blvd], [Daniel Webster Highway: Daniel Webster Highway], ... 16 more ...)
• LOSAM (type: esriFieldTypeString, alias: LOS AM, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• LOSPM (type: esriFieldTypeString, alias: LOS PM, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CountYear (type: esriFieldTypeInteger, alias: CountYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CountDate2 (type: esriFieldTypeDate, alias: CountDateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Time_Start_Time (type: esriFieldTypeTimeOnly, alias: Time Start (Time), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Time_End_Time (type: esriFieldTypeTimeOnly, alias: Time_End_Time, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: TMCRecordsLocal
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• TMCSitesLocal (0) -- Related To: TMCSitesLocal (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/25/2025 12:16:46 AM

Schema Last Edit Date: 5/6/2025 1:22:12 PM

Data Last Edit Date: 7/25/2025 12:16:46 AM

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