Name: Signs_Table

Display Field: A_SignCode

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f0438499ad8f4b72a421e851145a5a05

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• A_SignCode ( type: esriFieldTypeString, alias: Sign Code, length: 50 )
• A_Surface ( type: esriFieldTypeString, alias: Surface, length: 50 , Coded Values: [Reflective: Reflective] , [Nonreflective: Nonreflective] )
• A_Shape ( type: esriFieldTypeString, alias: Shape, length: 50 , Coded Values: [Xbar: Xbar] , [Shield: Shield] , [Octagon: Octagon] , ...8 more... )
• A_Color ( type: esriFieldTypeString, alias: Color, length: 50 , Coded Values: [Black on White: Black on White] , [Black on Yellow: Black on Yellow] , [White on Red: White on Red] , ...14 more... )
• A_Dimension1 ( type: esriFieldTypeDouble, alias: Dimension 1 )
• A_Dimension2 ( type: esriFieldTypeDouble, alias: Dimension 1 )
• A_Dimension3 ( type: esriFieldTypeDouble, alias: Dimension 3 )
• A_Material ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [.080 Aluminum: .080 Aluminum] , [Wood: Wood] , [.063 Aluminum: .063 Aluminum] , ...4 more... )
• A_AnchorFacing ( type: esriFieldTypeString, alias: Anchor Facing, length: 50 , Coded Values: [Facing: Facing] , [Opposing: Opposing] , [Parallel: Parallel] , ...2 more... )
• A_OrdinanceNumber ( type: esriFieldTypeString, alias: Ordinance Number, length: 50 )
• A_Responsibility ( type: esriFieldTypeString, alias: Responsibility, length: 50 , Coded Values: [City: City] , [Transit: Transit] , [Other: Other] )
• B_Destinations ( type: esriFieldTypeString, alias: Destinations, length: 300 )
• B_Condition ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• B_SignComments ( type: esriFieldTypeString, alias: Sign Comments, length: 300 )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CreatDate ( type: esriFieldTypeDate, alias: Creat Date, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, length: 38 )
• Wayfinding ( type: esriFieldTypeString, alias: Wayfinding Sign?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SignOrderFromTop ( type: esriFieldTypeString, alias: Sign Order(from top), length: 50 )
• AnchorType ( type: esriFieldTypeString, alias: AnchorType, length: 50 , Coded Values: [Ground: Ground] , [Concrete: Concrete] , [Collar: Collar] , ...5 more... )
• SignDescription ( type: esriFieldTypeString, alias: Sign Description, length: 200 )
• Original_Install ( type: esriFieldTypeDate, alias: Original Install Date, length: 8 )
• DateReplaced ( type: esriFieldTypeDate, alias: Date Replaced, length: 8 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD Code, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• SignCode_Int ( type: esriFieldTypeInteger, alias: Sign Code Integer )
• Man_SignDescript ( type: esriFieldTypeString, alias: Manual Sign Description, length: 255 )
• URL ( type: esriFieldTypeString, alias: URL, length: 500 )
• SignCode ( type: esriFieldTypeInteger, alias: Enter Sign Code )

Relationships:

• CityOfSheboygan.OWNER.Sign_Pole_WOs (2) -- Related To: Sign Pole Work Orders (2)
• SignPoles (1) -- Related To: SignPoles (0)
• CityOfSheboygan.OWNER.SignCodeTable2023 (3) -- Related To: SignCodeTable2023 (3)

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

  Iteminfo   Thumbnail   Metadata