Name: Sign

Display Field: SignMount

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• SignID ( type: esriFieldTypeInteger , alias: SignID )
• PostID ( type: esriFieldTypeInteger , alias: PostID )
• SignMount ( type: esriFieldTypeString , alias: SignMount , length: 25 )
• SignDirection ( type: esriFieldTypeString , alias: SignDirection , length: 2 )
• SignPosition ( type: esriFieldTypeSmallInteger , alias: SignPosition )
• MountingHeight ( type: esriFieldTypeDouble , alias: MountingHeight )
• MUTCD ( type: esriFieldTypeString , alias: MUTCD , length: 10 )
• Wording ( type: esriFieldTypeString , alias: Wording , length: 100 )
• SignSheeting ( type: esriFieldTypeString , alias: SignSheeting , length: 25 )
• BackgroundColor ( type: esriFieldTypeString , alias: BackgroundColor , length: 10 )
• TextColor ( type: esriFieldTypeString , alias: TextColor , length: 10 )
• SignBacking ( type: esriFieldTypeString , alias: SignBacking , length: 25 )
• SignWidth ( type: esriFieldTypeSmallInteger , alias: SignWidth )
• SignHeight ( type: esriFieldTypeSmallInteger , alias: SignHeight )
• Obstructions ( type: esriFieldTypeString , alias: Obstructions , length: 25 )
• SheetingCondition ( type: esriFieldTypeString , alias: SheetingCondition , length: 25 )
• Reflectivity ( type: esriFieldTypeString , alias: Reflectivity , length: 10 )
• Notes ( type: esriFieldTypeString , alias: Notes , length: 255 )
• InstallDate ( type: esriFieldTypeDate , alias: InstallDate , length: 8 )
• InspectionDate ( type: esriFieldTypeDate , alias: InspectionDate , length: 8 )
• NightInspectionDate ( type: esriFieldTypeDate , alias: NightInspectionDate , length: 8 )
• Inspector ( type: esriFieldTypeString , alias: Inspector , length: 50 )
• GraffitiType ( type: esriFieldTypeString , alias: GraffitiType , length: 20 )
• GraffitiText ( type: esriFieldTypeString , alias: GraffitiText , length: 50 )
• SignCategory ( type: esriFieldTypeString , alias: SignCategory , length: 20 )
• SignSymbol ( type: esriFieldTypeString , alias: SignSymbol , length: 20 )
• Removed ( type: esriFieldTypeString , alias: Removed , length: 1 )
• OrdinanceNumber ( type: esriFieldTypeInteger , alias: OrdinanceNumber )
• OrdinanceDate ( type: esriFieldTypeDate , alias: OrdinanceDate , length: 8 )
• DateReplaced ( type: esriFieldTypeDate , alias: DateReplaced , length: 8 )
• PicLocation ( type: esriFieldTypeString , alias: PicLocation , length: 55 )

Relationships:

• sde.GIS.Trans_SignPost (1) -- Related To: SignPost (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata