Name: Street Pole/Post Inventory

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>To show the location of street poles in the City of Tumwater. This includes poles that the City maintains plus poles from other agencies like Puget Sound Energy and the Tumwater School District. These poles are of several different types, including: sign poles, street light poles, signal poles and more.</SPAN></P><P><SPAN>NOTES:</SPAN></P><P><SPAN>The street lights on both end of the pedestrian bridge over Interstate 5 are maintained by the City (LP3618, LP3619)</SPAN></P><P><SPAN>There are a few special school zone signs that the Tumwater School District maintains. These signs are on a special pole and have a flashing light above the sign with a solar power panel on top of the pole. There are 12 of these signs in Tumwater (at last count). They have been given a speical naming convention that is different from other sign poles. Here is a sample of their special naming convention: "SGN_TSD1" where TSD stands for Tumwater School District.</SPAN></P><P /></DIV></DIV></DIV>

Service Item Id: 58bf6965977a4b99bd6be4c41be119da

Copyright Text: City of Tumwater Public Works Department

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.3688903061369475E7
YMin: 5934082.64461761
XMax: -1.3677424804636661E7
YMax: 5946677.422359376
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PURPOSE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 3
  Label: Lights
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Signals
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Signs
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Utilities
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FACILITYID]
Use Coded Values: true
Symbol:
Color: [230, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 11
Font Family: Calibri
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2000.0
Max. Scale: 0.0

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: false
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: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Alt Pole ID, length: 20 )
• POLETYPE ( type: esriFieldTypeInteger, alias: Pole Type , Coded Values: [9: Tree] , [8: Fence Post] , [7: Power Pole] , ...12 more... )
• CONDITION ( type: esriFieldTypeInteger, alias: Overall Cond , Coded Values: [4: Poor] , [3: Fair] , [2: Good] , ...1 more... )
• PURPOSE ( type: esriFieldTypeInteger, alias: Primary Use , Coded Values: [4: Utilities] , [3: Lights] , [2: Signals] , ...1 more... )
• GPSFLAG ( type: esriFieldTypeSmallInteger, alias: GPS Flag )
• LUCITYID ( type: esriFieldTypeInteger, alias: Pole Number )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity Database? )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, length: 40 , Coded Values: [MATTS: MATT STULL] , [CORAB: CORA BAULKE] , [jradcliff: JEN RADCLIFF] , ...3 more... )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, length: 8 )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, length: 8 )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, length: 8 )
• PHOTO ( type: esriFieldTypeString, alias: PHOTO, length: 230 )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 70 )
• NORTHING ( type: esriFieldTypeString, alias: NORTHING, length: 25 )
• EASTING ( type: esriFieldTypeString, alias: EASTING, length: 25 )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• OLD_KROLL_NUM ( type: esriFieldTypeString, alias: Old Kroll Pole Number, length: 20 )
• INFO_SOURCE ( type: esriFieldTypeSmallInteger, alias: INFO_SOURCE )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 15 , Coded Values: [CITY: City of Tumwater] , [PSE: Puget Sound Energy] , [PRI: Private] , ...2 more... )
• PSE_TAGID ( type: esriFieldTypeString, alias: PSE TagID, length: 12 )
• STYLE ( type: esriFieldTypeString, alias: STYLE, length: 25 )
• WATTAGE ( type: esriFieldTypeDouble, alias: WATTAGE )
• LED ( type: esriFieldTypeString, alias: LED, length: 3 , Coded Values: [NO: No] , [YES: Yes] , [UNK: Unknown] , ...1 more... )
• METERED ( type: esriFieldTypeString, alias: METERED, length: 3 , Coded Values: [NO: No] , [YES: Yes] , [UNK: Unknown] , ...1 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• ST_LIGHT ( type: esriFieldTypeString, alias: STREET LIGHT ON POLE?, length: 3 , Coded Values: [YES: YES] , [NO: NO] )
• NUM_LIGHTS ( type: esriFieldTypeSmallInteger, alias: NUMBER OF STREET LIGHTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• DataGrade ( type: esriFieldTypeString, alias: DataGrade, length: 15 , Coded Values: [Survey: Survey] , [GPS: Mapping Grade GPS] , [Plan: Approved Plans] , ...2 more... )
• Source ( type: esriFieldTypeString, alias: Source, length: 50 )
• Decorative ( type: esriFieldTypeString, alias: Decorative, length: 3 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• STATUS ( type: esriFieldTypeInteger, alias: STATUS , Coded Values: [1: Active] , [2: Abandoned] , [3: Relocated] )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata