View In:   ArcGIS Online Map Viewer

Name: Traffic Support Pole

Display Field: CWID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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.</SPAN></P><P><SPAN>The attribute table contains information about the support type, location, # of signs, lifecycle, maintenance, condition and inspection date/inspector.</SPAN></P><P><SPAN>Metadata last updated: 6/2021</SPAN></P></DIV></DIV></DIV>

Service Item Id: f11de3f569e245ddb93abdd1f977be59

Copyright Text: City of Allen

Default Visibility: true

MaxRecordCount: 2000

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: 2508589.936050266
YMin: 7061424.83775638
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: N/A
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:
UniqueValueInfos:
• Value: Pole
  Label: Pole
  Description: N/A
  Symbol:
  
• Value: Traffic Signal
  Label: Traffic Signal
  Description: N/A
  Symbol:
  
• Value: Flasher
  Label: Flasher
  Description: N/A
  Symbol:
  
• Value: Light Post
  Label: Light Post
  Description: N/A
  Symbol:
  
• Value: Overhang
  Label: Overhang
  Description: N/A
  Symbol:
  
• Value: Other
  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

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] , ...12 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
Domains:
• SupportType:
  Inherited
• Condition:
  Inherited
• LifecycleStatus:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Pole
  Description:
  Prototype:
  CWID: null
  Condition: null
  EngineerGrid: null
  SupportType: Pole
  LocationDesc: null
  NumSigns: null
  LifecycleStatus: Active
  MaintainedBy: null
  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
  Condition: null
  EngineerGrid: null
  SupportType: Traffic Signal
  LocationDesc: null
  NumSigns: null
  LifecycleStatus: Active
  MaintainedBy: null
  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
  Condition: null
  EngineerGrid: null
  SupportType: Flasher
  LocationDesc: null
  NumSigns: null
  LifecycleStatus: Active
  MaintainedBy: null
  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
  Condition: null
  EngineerGrid: null
  SupportType: Light Post
  LocationDesc: null
  NumSigns: null
  LifecycleStatus: Active
  MaintainedBy: null
  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
  Condition: null
  EngineerGrid: null
  SupportType: Overhang
  LocationDesc: null
  NumSigns: null
  LifecycleStatus: Active
  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
  Description:
  Prototype:
  CWID: null
  Condition: null
  EngineerGrid: null
  SupportType: Other
  LocationDesc: null
  NumSigns: null
  LifecycleStatus: Active
  MaintainedBy: null
  LastServiceDate: null
  InspectedDate: null
  InspectedBy: null
  Comments: null
  URL: null
  DecimalDegreeLong: null
  DecimalDegreeLat: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

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

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

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