Name: tSign

Display Field: MUTCD

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c67eb27eaede4fd991bd36ec156606ac

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MUTCD )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• POLE_ID ( type: esriFieldTypeString, alias: Pole ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POLE_ID )
• EQUIPMENTID ( type: esriFieldTypeString, alias: Equipment ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EQUIPMENTID )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OWNER , Coded Values: [CITY: City of Topeka] , [COUNTY: Shawnee County] , [Private: Private] , ...3 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STATUS , Coded Values: [ACT: Active] , [ABAND: Abandoned] , [REMOVED: Removed] , ...7 more... )
• M_HEIGHT ( type: esriFieldTypeDouble, alias: Height (Top of Sign), editable: true, nullable: true, defaultValue: null, modelName: M_HEIGHT )
• MastArmID ( type: esriFieldTypeString, alias: MastArmID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MastArmID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATOR )
• CREATEDDATE ( type: esriFieldTypeDate, alias: CREATEDDATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATEDDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• INST_DATE ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INST_DATE )
• FACING ( type: esriFieldTypeString, alias: Facing, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FACING , Coded Values: [East: East] , [North: North] , [South: South] , ...11 more... )
• SIGN_TEXT ( type: esriFieldTypeString, alias: SIGN_TEXT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SIGN_TEXT )
• COND ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: COND , Coded Values: [POOR: Poor] , [FAIR: Fair] , [GOOD: Good] )
• COND_DT ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COND_DT )
• S_CNT ( type: esriFieldTypeSmallInteger, alias: Sign Count, editable: true, nullable: true, defaultValue: null, modelName: S_CNT )

Templates:

• Name: tSign
  Description:
  Prototype:
  COND_DT: null
  COND: null
  MUTCD: null
  COMMENTS: null
  POLE_ID: null
  EQUIPMENTID: null
  OWNER: null
  STATUS: null
  M_HEIGHT: null
  MastArmID: null
  S_CNT: null
  SIGN_TEXT: null
  FACING: null
  INST_DATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• tPole (8) -- Related To: tPole (2)
• tMastArm (12) -- Related To: tMastArm (4)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATEDDATE
• Creator Field: CREATOR
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata