View In:   ArcGIS Online Map Viewer

Name: NBGIS.DBO.Warning_Signal

Display Field: AUDIT_CITY_ISSUE_COMMENT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 100000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 812484.4776507169
YMin: 2692493.2166499794
XMax: 814343.8535251319
YMax: 2697227.8823774755
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CONTROL_BOX_ID ( type: esriFieldTypeString, alias: CONTROL BOX ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTROL_BOX_ID )
• SIGNAL_SEQUENCE_ID ( type: esriFieldTypeDouble, alias: SIGNAL_SEQUENCE_ID, editable: true, nullable: true, defaultValue: null, modelName: SIGNAL_SEQUENCE_ID )
• WARNING_SIGNAL_TYPE ( type: esriFieldTypeString, alias: WARNING_SIGNAL_TYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: WARNING_SIGNAL_TYPE )
• WARNING_SIGNAL_SECTIONS ( type: esriFieldTypeDouble, alias: WARNING_SIGNAL_SECTIONS, editable: true, nullable: true, defaultValue: null, modelName: WARNING_SIGNAL_SECTIONS , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• WARNING_SIGNAL_BULB_SIZE ( type: esriFieldTypeString, alias: WARNING_SIGNAL_BULB_SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WARNING_SIGNAL_BULB_SIZE , Coded Values: [8 INCH: 8 INCH] , [8 INCH LED: 8 INCH LED] , [12 INCH: 12 INCH] , ...5 more... )
• RETROFIT_TEAM ( type: esriFieldTypeString, alias: RETROFIT_TEAM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETROFIT_TEAM , Coded Values: [SIEMENS TEAM 1: SIEMENS TEAM 1] , [SIEMENS TEAM 2: SIEMENS TEAM 2] , [SIEMENS TEAM 3: SIEMENS TEAM 3] , ...17 more... )
• RETROFIT_DATE_INSPECTED ( type: esriFieldTypeDate, alias: RETROFIT_DATE_INSPECTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETROFIT_DATE_INSPECTED )
• RETROFIT_COMMENTS ( type: esriFieldTypeString, alias: RETROFIT_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RETROFIT_COMMENTS )
• AUDITOR_STATUS ( type: esriFieldTypeString, alias: AUDITOR_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUDITOR_STATUS , Coded Values: [COLLECTED: COLLECTED] , [REVIEWED: REVIEWED] )
• RETROFIT_STATUS ( type: esriFieldTypeString, alias: RETROFIT_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETROFIT_STATUS , Coded Values: [CONVERTED: CONVERTED] , [CONVERTED WITH ISSUE: CONVERTED WITH ISSUE] , [UNCONVERTED WITH ISSUE CONTRACTOR: UNCONVERTED WITH ISSUE CONTRACTOR] , ...8 more... )
• ISSUE_TRACKING ( type: esriFieldTypeString, alias: ISSUE_TRACKING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ISSUE_TRACKING , Coded Values: [N: NO] , [Y: YES] , [RESOLVED: RESOLVED] )
• AUDITOR_ISSUE_COMMENT ( type: esriFieldTypeString, alias: AUDITOR_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AUDITOR_ISSUE_COMMENT )
• AUDITOR_ISSUE_COMMENT_DATE ( type: esriFieldTypeDate, alias: AUDITOR_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AUDITOR_ISSUE_COMMENT_DATE )
• AUDITOR_SIEMENS_ISSUE_COMMENT ( type: esriFieldTypeString, alias: AUDITOR_SIEMENS_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AUDITOR_SIEMENS_ISSUE_COMMENT )
• AUDITOR_SIEMENS_ISSUE_COMMENT_D ( type: esriFieldTypeDate, alias: AUDITOR_SIEMENS_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AUDITOR_SIEMENS_ISSUE_COMMENT_D )
• AUDITOR_SIEMENS_ISSUE_COMMENT_N ( type: esriFieldTypeString, alias: AUDITOR_SIEMENS_ISSUE_COMMENT_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUDITOR_SIEMENS_ISSUE_COMMENT_N )
• AUDIT_CITY_ISSUE_COMMENT ( type: esriFieldTypeString, alias: AUDIT_CITY_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AUDIT_CITY_ISSUE_COMMENT )
• AUDIT_CITY_ISSUE_COMMENT_DATE ( type: esriFieldTypeDate, alias: AUDIT_CITY_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AUDIT_CITY_ISSUE_COMMENT_DATE )
• AUDIT_CITY_ISSUE_COMMENT_NAME ( type: esriFieldTypeString, alias: AUDIT_CITY_ISSUE_COMMENT_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUDIT_CITY_ISSUE_COMMENT_NAME )
• AUDIT_RESOLUTION_ISSUE_COMMENT ( type: esriFieldTypeString, alias: AUDIT_RESOLUTION_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AUDIT_RESOLUTION_ISSUE_COMMENT )
• AUDIT_RESOLUTION_ISSUE_COMMENT_ ( type: esriFieldTypeDate, alias: AUDIT_RESOLUTION_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AUDIT_RESOLUTION_ISSUE_COMMENT_ )
• AUDIT_RESOLUTION_ISSUE_COMMENT1 ( type: esriFieldTypeString, alias: AUDIT_RESOLUTION_ISSUE_COMMENT_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUDIT_RESOLUTION_ISSUE_COMMENT1 )
• RETROFIT_ISSUE_COMMENT ( type: esriFieldTypeString, alias: RETROFIT_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RETROFIT_ISSUE_COMMENT )
• RETROFIT_SIEMENS_ISSUE_COMMENT ( type: esriFieldTypeString, alias: RETROFIT_SIEMENS_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RETROFIT_SIEMENS_ISSUE_COMMENT )
• RETROFIT_SIEMENS_ISSUE_COMMENT_ ( type: esriFieldTypeDate, alias: RETROFIT_SIEMENS_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETROFIT_SIEMENS_ISSUE_COMMENT_ )
• RETROFIT_SIEMENS_ISSUE_COMMENT1 ( type: esriFieldTypeString, alias: RETROFIT_SIEMENS_ISSUE_COMMENT_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETROFIT_SIEMENS_ISSUE_COMMENT1 )
• RETROFIT_CITY_ISSUE_COMMENT ( type: esriFieldTypeString, alias: RETROFIT_CITY_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RETROFIT_CITY_ISSUE_COMMENT )
• RETROFIT_CITY_ISSUE_COMMENT_DAT ( type: esriFieldTypeDate, alias: RETROFIT_CITY_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETROFIT_CITY_ISSUE_COMMENT_DAT )
• RETROFIT_CITY_ISSUE_COMMENT_NAM ( type: esriFieldTypeString, alias: RETROFIT_CITY_ISSUE_COMMENT_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETROFIT_CITY_ISSUE_COMMENT_NAM )
• RETROFIT_RESOLUTION_ISSUE_COMME ( type: esriFieldTypeString, alias: RETROFIT_RESOLUTION_ISSUE_COMMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RETROFIT_RESOLUTION_ISSUE_COMME )
• RETROFIT_RESOLUTION_ISSUE_COM_1 ( type: esriFieldTypeDate, alias: RETROFIT_RESOLUTION_ISSUE_COMMENT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETROFIT_RESOLUTION_ISSUE_COM_1 )
• RETROFIT_RESOLUTION_ISSUE_COM_2 ( type: esriFieldTypeString, alias: RETROFIT_RESOLUTION_ISSUE_COMMENT_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETROFIT_RESOLUTION_ISSUE_COM_2 )
• COUNT_ ( type: esriFieldTypeDouble, alias: COUNT, editable: true, nullable: true, defaultValue: null, modelName: COUNT_ )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• GIS_ID ( type: esriFieldTypeString, alias: GIS_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GIS_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• AUDITOR_TEAM ( type: esriFieldTypeString, alias: AUDITOR TEAM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUDITOR_TEAM , Coded Values: [SIEMENS TEAM 1: SIEMENS TEAM 1] , [SIEMENS TEAM 2: SIEMENS TEAM 2] , [SIEMENS TEAM 3: SIEMENS TEAM 3] , ...17 more... )
• AUDIT_DATE ( type: esriFieldTypeDate, alias: AUDIT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AUDIT_DATE )
• LucityLink ( type: esriFieldTypeInteger, alias: LucityLink, editable: true, nullable: true, defaultValue: null, modelName: LucityLink )
• InLucity ( type: esriFieldTypeSmallInteger, alias: InLucity, editable: true, nullable: true, defaultValue: null, modelName: InLucity )

Templates:

• Name: NBGIS.DBO.Warning_Signal
  Description:
  Prototype:
  LucityLink: null
  AUDIT_DATE: null
  CONTROL_BOX_ID: null
  SIGNAL_SEQUENCE_ID: null
  WARNING_SIGNAL_TYPE: null
  WARNING_SIGNAL_SECTIONS: null
  WARNING_SIGNAL_BULB_SIZE: null
  RETROFIT_TEAM: null
  RETROFIT_DATE_INSPECTED: null
  RETROFIT_COMMENTS: null
  AUDITOR_STATUS: null
  RETROFIT_STATUS: null
  ISSUE_TRACKING: null
  AUDITOR_ISSUE_COMMENT: null
  AUDITOR_ISSUE_COMMENT_DATE: null
  AUDITOR_SIEMENS_ISSUE_COMMENT: null
  AUDITOR_SIEMENS_ISSUE_COMMENT_D: null
  AUDITOR_SIEMENS_ISSUE_COMMENT_N: null
  AUDIT_CITY_ISSUE_COMMENT: null
  AUDIT_CITY_ISSUE_COMMENT_DATE: null
  AUDIT_CITY_ISSUE_COMMENT_NAME: null
  AUDIT_RESOLUTION_ISSUE_COMMENT: null
  AUDIT_RESOLUTION_ISSUE_COMMENT_: null
  AUDIT_RESOLUTION_ISSUE_COMMENT1: null
  RETROFIT_ISSUE_COMMENT: null
  RETROFIT_SIEMENS_ISSUE_COMMENT: null
  RETROFIT_SIEMENS_ISSUE_COMMENT_: null
  RETROFIT_SIEMENS_ISSUE_COMMENT1: null
  RETROFIT_CITY_ISSUE_COMMENT: null
  RETROFIT_CITY_ISSUE_COMMENT_DAT: null
  RETROFIT_CITY_ISSUE_COMMENT_NAM: null
  RETROFIT_RESOLUTION_ISSUE_COMME: null
  RETROFIT_RESOLUTION_ISSUE_COM_1: null
  RETROFIT_RESOLUTION_ISSUE_COM_2: null
  COUNT_: null
  X: null
  Y: null
  GIS_ID: null
  InLucity: null
  AUDITOR_TEAM: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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