View In:   ArcGIS Online Map Viewer

Name: tTrafficSignal

Display Field: OWNER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c67eb27eaede4fd991bd36ec156606ac

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1500.0

Max Scale: 0.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: 1938088.3677749932
YMin: 227552.34147499502
XMax: 1994161.293050006
YMax: 306673.4420749992
Spatial Reference: 102677  (3419)  LatestVCSWkid(0)

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OWNER , Coded Values: [CITY: City of Topeka] , [COUNTY: Shawnee County] , [Private: Private] , ...1 more... )
• S_TYPE ( type: esriFieldTypeString, alias: Signal Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: S_TYPE , Coded Values: [ETW: ELTEC Warning Flasher] , [FW: Fire Warning Flasher] , [PB: Pedestrian Beacon] , ...8 more... )
• S_DETECT ( type: esriFieldTypeString, alias: Signal Detection, editable: true, nullable: true, length: 20, defaultValue: null, modelName: S_DETECT , Coded Values: [Video: Video Tracking] , [Pushbutton: Pushbutton Control] , [Loops: Loops] , ...6 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [ACT: Active] , [ABAND: Abandoned] , [REMOVED: Removed] , ...7 more... )
• INST_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INST_DATE )
• P_SOURCE ( type: esriFieldTypeString, alias: Power Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: P_SOURCE , Coded Values: [AC: Alternating Current] , [DC: Direct Current - Battery] , [S: Solar Panel] )
• POLE_ID ( type: esriFieldTypeString, alias: POLE_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POLE_ID )
• MastArmID ( type: esriFieldTypeString, alias: MastArmID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MastArmID )
• AMTZ ( type: esriFieldTypeString, alias: AM Time Zone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AMTZ )
• PMTZ ( type: esriFieldTypeString, alias: PM Time Zone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PMTZ )
• W_AMTZ ( type: esriFieldTypeString, alias: Wed AM Time Zone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: W_AMTZ )
• W_PMTZ ( type: esriFieldTypeString, alias: Wed PM Time Zone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: W_PMTZ )
• LTZ1 ( type: esriFieldTypeString, alias: Lunch 1 Time Zone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LTZ1 )
• LTZ2 ( type: esriFieldTypeString, alias: Lunch 2 Time Zone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LTZ2 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENTS )
• 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 )
• DIST ( type: esriFieldTypeDouble, alias: Distance Along Asset, editable: true, nullable: true, defaultValue: null, modelName: DIST )
• 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... )
• DIRLENS ( type: esriFieldTypeString, alias: Directional Lens, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DIRLENS , Coded Values: [Y: Yes] , [N: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROJECT )
• MAINTAINEDBY ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINTAINEDBY , Coded Values: [CITY: City of Topeka] , [STATE: State of Kansas] , [COUNTY: Shawnee County] , ...4 more... )
• SIG_CNT ( type: esriFieldTypeSmallInteger, alias: Signal Count, editable: true, nullable: true, defaultValue: null, modelName: SIG_CNT )

Templates:

• Name: cotbase.DBO.tTrafficSignal
  Description:
  Prototype:
  MAINTAINEDBY: null
  OWNER: null
  S_TYPE: null
  S_DETECT: null
  STATUS: null
  INST_DATE: null
  P_SOURCE: null
  POLE_ID: null
  MastArmID: null
  AMTZ: null
  PMTZ: null
  W_AMTZ: null
  W_PMTZ: null
  LTZ1: null
  LTZ2: null
  COMMENTS: null
  PROJECT: null
  FACILITYID: null
  SIG_CNT: null
  DIRLENS: null
  DIST: null
  FACING: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• tPole (3) -- Related To: tPole (2)
• tMastArm (4) -- 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: true

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