Name: tcSign

Display Field: MUTCD

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 25f35c90b9dd42aaa7298b0164c13fc4

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, length: 80 )
• SignText ( type: esriFieldTypeString, alias: SignText, length: 150 )
• Sign_Face_Direction ( type: esriFieldTypeString, alias: Sign_Face_Direction, length: 5 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...6 more... )
• Flashers ( type: esriFieldTypeString, alias: Flashers, length: 50 )
• Speed_Limit ( type: esriFieldTypeInteger, alias: Speed_Limit )
• SignSize ( type: esriFieldTypeString, alias: SignSize, length: 50 , Coded Values: [S: Standard] , [N: Non-Standard] )
• SignSize_Demensions ( type: esriFieldTypeString, alias: SignSize_Demensions, length: 50 , Coded Values: [6in x 12in: 6" x 12"] , [8in x 24in: 8" x 24"] , [9in x 12in: 9" x 12"] , ...50 more... )
• Compkey ( type: esriFieldTypeInteger, alias: Compkey )
• NighttimeInspection ( type: esriFieldTypeString, alias: NighttimeInspection, length: 50 )
• Nighttime_Date ( type: esriFieldTypeDate, alias: Nighttime_Date, length: 8 )
• Custom ( type: esriFieldTypeString, alias: Custom, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 35 )
• tcMountID ( type: esriFieldTypeString, alias: tcMountID, length: 50 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 35 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 30 )
• Location ( type: esriFieldTypeString, alias: Location, length: 130 )
• EstimatedEffectiveLife ( type: esriFieldTypeSmallInteger, alias: EstimatedEffectiveLife )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear )
• LifeCycle ( type: esriFieldTypeString, alias: LifeCycle, length: 5 , Coded Values: [AC: Active] , [PR: Proposed] , [AB: Abandoned] , ...3 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SignTypeImage ( type: esriFieldTypeString, alias: SignTypeImage, length: 255 )
• SignType ( type: esriFieldTypeString, alias: SignType, length: 50 )

Relationships:

• DBO.tcMount (0) -- Related To: Street Sign Mount (2)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata