View In:   ArcGIS Online Map Viewer

Name: Traffic Support Pole

Display Field: CWID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class contains points representing poles, traffic signals, flashers, or other features that support traffic signs. This feature class was developed after a 2019 sign collection project by Halff Associates. It is in a one to many relationship with the StreetSigns table. The origin field is the CW ID and it relates to the Post ID field in the StreetSigns table.The attribute table contains information about the support type, location, # of signs, lifecycle, maintenance, condition and inspection date/inspector.Metadata last updated: 6/2021

Service Item Id: c0fc60796fa04c4fb238308468b67c6a

Copyright Text: City of Allen

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 2508589.936050266
YMin: 7028320.116317555
XMax: 2547261.2413022816
YMax: 7108692.975784406
Spatial Reference: 102738  (2276)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SupportType
Field 2: MaintainedBy
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [78, 78, 78, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: Pole,Allen
  Label: Pole - COA
  Description: N/A
  Symbol:
  
• Value: Pole,HOA
  Label: Pole - HOA
  Description: N/A
  Symbol:
  
• Value: Pole,Private
  Label: Pole - Private
  Description: N/A
  Symbol:
  
• Value: Pole,TxDOT
  Label: Pole - TxDOT
  Description: N/A
  Symbol:
  
• Value: Pole,NTTA
  Label: Pole - NTTA
  Description: N/A
  Symbol:
  
• Value: Pole,Collin County
  Label: Pole - Other
  Description: N/A
  Symbol:
  
• Value: Pole,<Null>
  Label: Pole - Other
  Description: N/A
  Symbol:
  
• Value: Pole,ISD
  Label: Pole - Other
  Description: N/A
  Symbol:
  
• Value: Pole,Other
  Label: Pole - Other
  Description: N/A
  Symbol:
  
• Value: Pole,Plano
  Label: Pole - Other
  Description: N/A
  Symbol:
  
• Value: Pole,State
  Label: Pole - Other
  Description: N/A
  Symbol:
  
• Value: Traffic Signal,<Null>
  Label: Traffic Signal
  Description: N/A
  Symbol:
  
• Value: Traffic Signal,Allen
  Label: Traffic Signal
  Description: N/A
  Symbol:
  
• Value: Flasher,<Null>
  Label: Flasher
  Description: N/A
  Symbol:
  
• Value: Flasher,Allen
  Label: Flasher
  Description: N/A
  Symbol:
  
• Value: Light Post,<Null>
  Label: Light Post
  Description: N/A
  Symbol:
  
• Value: Light Post,Allen
  Label: Light Post
  Description: N/A
  Symbol:
  
• Value: Light Post,Private
  Label: Light Post
  Description: N/A
  Symbol:
  
• Value: Overhang,<Null>
  Label: Overhang
  Description: N/A
  Symbol:
  
• Value: Overhang,Allen
  Label: Overhang
  Description: N/A
  Symbol:
  
• Value: <Null>,<Null>
  Label: Other
  Description: N/A
  Symbol:
  
• Value: Other,<Null>
  Label: Other
  Description: N/A
  Symbol:
  
• Value: Other,Allen
  Label: Other
  Description: N/A
  Symbol:
  
• Value: Other,Private
  Label: Other
  Description: N/A
  Symbol:
  
• Value: Other,Unknown
  Label: Other
  Description: N/A
  Symbol:
  
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SupportType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CWID ( type: esriFieldTypeString, alias: CW ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CWID )
• SupportType ( type: esriFieldTypeString, alias: Support Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SupportType , Coded Values: [Pole: Pole] , [Traffic Signal: Traffic Signal] , [Flasher: Flasher] , ...3 more... )
• LocationDesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDesc )
• NumSigns ( type: esriFieldTypeSmallInteger, alias: # of Signs, editable: true, nullable: true, defaultValue: null, modelName: NumSigns )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• LifecycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Active: Active] , [Future: Future] , [Removed: Removed] , ...3 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintainedBy , Coded Values: [Allen: Allen] , [Allen PR: Allen Public & Media Relations (PAMRO)] , [Collin County: Collin County] , ...16 more... )
• LastServiceDate ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastServiceDate )
• InspectedDate ( type: esriFieldTypeDate, alias: Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectedDate )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL )
• created_user ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Creation Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• DecimalDegreeLat ( type: esriFieldTypeString, alias: Decimal Degree Latitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DecimalDegreeLat )
• DecimalDegreeLong ( type: esriFieldTypeString, alias: Decimal Degree Longitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DecimalDegreeLong )
• EngineerGrid ( type: esriFieldTypeSmallInteger, alias: Engineering Grid #, editable: true, nullable: true, defaultValue: null, modelName: EngineerGrid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Pole
Name: Pole - COA
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Pole - COA
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Allen
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - HOA
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: HOA
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Private
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Private
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - TxDOT
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: TxDOT
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - NTTA
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: NTTA
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Other
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Collin County
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Other (1)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Other (2)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: ISD
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Other (3)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Other
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Other (4)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Plano
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Pole - Other (5)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: State
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Traffic Signal
Name: Traffic Signal
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Traffic Signal
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Traffic Signal
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Traffic Signal (1)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Traffic Signal
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Allen
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Flasher
Name: Flasher
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Flasher
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Flasher
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Flasher (1)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Flasher
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Allen
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Light Post
Name: Light Post
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Light Post
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Light Post
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Light Post (1)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Light Post
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Allen
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Light Post (2)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Light Post
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Private
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Overhang
Name: Overhang
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Overhang
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Overhang
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Overhang (1)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Overhang
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Allen
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: null
Name: Other
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: <Null>
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Other
Name: Other
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Other (1)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Other
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: <Null>
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Other (2)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Other
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Allen
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Other (3)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Other
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Private
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Other (4)
  Description:
  Prototype:
  CWID: null
  LifecycleStatus: Active
  EngineerGrid: null
  SupportType: Other
  LocationDesc: null
  NumSigns: null
  Condition: null
  MaintainedBy: Unknown
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• SupportPoleToStreetSigns (0) -- Related To: Traffic Signs (8)

Capabilities: Query

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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