Name: Signs_Table

Display Field: A_SignCode

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 71b833423c4948e7b3092f6dc1195e0e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Signs_Table
  Description:
  Prototype:
  URL: null
  A_SignCode: null
  A_Surface: null
  A_Shape: null
  A_Color: null
  A_Dimension1: null
  A_Dimension2: null
  A_Dimension3: null
  A_Material: null
  A_AnchorFacing: null
  A_OrdinanceNumber: null
  A_Responsibility: null
  B_Destinations: null
  B_Condition: null
  B_SignComments: null
  SignCode_Int: null
  POINT_Y: null
  POINT_X: null
  Man_SignDescript: null
  SignCode: null
  GUID_Pole: null
  Wayfinding: null
  SignOrderFromTop: null
  AnchorType: null
  SignDescription: null
  Original_Install: null
  DateReplaced: null
  MUTCD: null
  
  Drawing Tool: esriFeatureEditToolNone

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CreatDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata