Name: Streetlight Pole
Display Field: Comments
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Feature class containing record of City owned poles. Also includes poles owned by other departments, or poles maintained by the City for other municipalities.
Copyright Text: Modified from the ArcFM Electrical Distribution Data Model. Original data field collected by Davey Resource Group in 2014. Updated with assistance from Geotech Inc.
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
Min Scale: 10000
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: false
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 1.2752811727905273E7
YMin: 504215.66790771484
XMax: 1.2801316725524902E7
YMax: 559849.1030883789
Spatial Reference: PROJCS["NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",13123359.58005249],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.36666666666666],PARAMETER["Standard_Parallel_1",42.1],PARAMETER["Standard_Parallel_2",43.66666666666666],PARAMETER["Latitude_Of_Origin",41.5],UNIT["Foot",0.3048]]
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: SubtypeCD
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
ConstructionStatus
(
type: esriFieldTypeInteger, alias: Construction Status
, Coded Values:
[0: Proposed]
, [5: Existing]
, [10: Waiting For Staking]
, ...6 more...
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, length: 255
)
-
SubtypeCD
(
type: esriFieldTypeInteger, alias: Subtype
)
-
Owner
(
type: esriFieldTypeString, alias: Owner, length: 20
)
-
Material
(
type: esriFieldTypeString, alias: Material, length: 5
)
-
Class
(
type: esriFieldTypeString, alias: Class, length: 5
)
-
Height
(
type: esriFieldTypeString, alias: Height, length: 5
)
-
FoundationType
(
type: esriFieldTypeString, alias: Foundation Type, length: 5
)
-
Grounded
(
type: esriFieldTypeString, alias: Grounded Indicator, length: 5
)
-
Style
(
type: esriFieldTypeString, alias: Style, length: 5
)
-
TreatmentType
(
type: esriFieldTypeString, alias: Treatment Type, length: 5
)
-
UsageType
(
type: esriFieldTypeString, alias: Usage Type, length: 5
)
-
Manufacturer
(
type: esriFieldTypeString, alias: Manufacturer, length: 20
)
-
BannerArm
(
type: esriFieldTypeString, alias: BannerArm, length: 5
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: Support Structure lID, length: 38
)
-
SymbolRotation
(
type: esriFieldTypeDouble, alias: Symbol Rotation
)
-
HeightEstimated
(
type: esriFieldTypeString, alias: HeightEstimated, length: 5
)
-
ClassEstimated
(
type: esriFieldTypeString, alias: ClassEstimated, length: 5
)
-
OldAttchmentPole
(
type: esriFieldTypeString, alias: OldAttchmentPole, length: 5
)
-
PoleIssues
(
type: esriFieldTypeString, alias: PoleIssues, length: 15
)
-
Birthdate
(
type: esriFieldTypeString, alias: Birthdate, length: 7
)
-
Condition
(
type: esriFieldTypeString, alias: Condition, length: 20
, Coded Values:
[GOOD: Good]
, [FAIR: Fair]
, [POOR: Poor]
, ...3 more...
)
-
Fed_from_UG
(
type: esriFieldTypeString, alias: Fed_from_UG, length: 5
)
-
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
)
-
InstallationDate
(
type: esriFieldTypeDate, alias: InstallationDate, length: 8
)
-
Asset_ID
(
type: esriFieldTypeString, alias: Asset_ID, length: 10
)
-
Asset_Num
(
type: esriFieldTypeInteger, alias: Asset_Num
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 25
, Coded Values:
[Active: Active]
, [Inactive: Inactive]
)
-
Last_Date
(
type: esriFieldTypeDate, alias: Last_Date, length: 8
)
-
Location_Code
(
type: esriFieldTypeString, alias: Location_Code, length: 12
)
-
Activity_Code
(
type: esriFieldTypeString, alias: Activity_Code, length: 12
)
Types:
ID: 4
Name: Wood Streetlight Pole
Domains:
-
ConstructionStatus:
Coded Values:
[0: Proposed]
, [5: Existing]
, [10: Waiting For Staking]
, ...5 more...
-
Material:
Coded Values:
[W: Wood]
-
Class:
Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...7 more...
-
Height:
Coded Values:
[20: 20']
, [25: 25']
, [30: 30']
, ...23 more...
-
FoundationType:
Coded Values:
[EXD: Set Extra Deep In Earth]
, [BUR: Set Normally In Earth]
, [BWC: Set Normal With Concrete Backfill]
, ...4 more...
-
Grounded:
Coded Values:
[N: No]
, [Y: Yes]
-
Style:
Coded Values:
[DEC: Decorative]
, [NORM: Normal]
, [OTH: Other]
, ...13 more...
-
TreatmentType:
Coded Values:
[CCA: Chromated Copper Arsenates]
, [CN: Copper Naphthenate]
, [CRE: Creosote]
, ...5 more...
-
UsageType:
Coded Values:
[DSL: Decorative Street Light]
, [D2P: Distribution 2-Pole Structure]
, [OBO: Owned By Others]
, ...6 more...
-
Status:
Coded Values:
[Active: Active]
, [Retired: Retired]
ID: 2
Name: Wood Power Pole
Domains:
-
ConstructionStatus:
Coded Values:
[0: Proposed]
, [5: Existing]
, [10: Waiting For Staking]
, ...5 more...
-
Material:
Coded Values:
[W: Wood]
-
Class:
Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...7 more...
-
Height:
Coded Values:
[20: 20']
, [25: 25']
, [30: 30']
, ...23 more...
-
FoundationType:
Coded Values:
[EXD: Set Extra Deep In Earth]
, [BUR: Set Normally In Earth]
, [BWC: Set Normal With Concrete Backfill]
, ...4 more...
-
Grounded:
Coded Values:
[N: No]
, [Y: Yes]
-
Style:
Coded Values:
[DEC: Decorative]
, [NORM: Normal]
, [OTH: Other]
, ...13 more...
-
TreatmentType:
Coded Values:
[CCA: Chromated Copper Arsenates]
, [CN: Copper Naphthenate]
, [CRE: Creosote]
, ...5 more...
-
UsageType:
Coded Values:
[DSL: Decorative Street Light]
, [D2P: Distribution 2-Pole Structure]
, [OBO: Owned By Others]
, ...6 more...
-
HeightEstimated:
Coded Values:
[N: No]
, [Y: Yes]
-
ClassEstimated:
Coded Values:
[N: No]
, [Y: Yes]
-
Status:
Coded Values:
[Active: Active]
, [Retired: Retired]
ID: 3
Name: Non-Wood Streetlight Pole
Domains:
-
ConstructionStatus:
Coded Values:
[0: Proposed]
, [5: Existing]
, [10: Waiting For Staking]
, ...5 more...
-
Material:
Coded Values:
[A: Aluminum]
, [C: Concrete]
, [B: Fiberglass]
, ...3 more...
-
Class:
Coded Values:
[NA: Not Applicable]
-
Height:
Coded Values:
[20: 20']
, [25: 25']
, [30: 30']
, ...23 more...
-
FoundationType:
Coded Values:
[EXD: Set Extra Deep In Earth]
, [BUR: Set Normally In Earth]
, [BWC: Set Normal With Concrete Backfill]
, ...4 more...
-
Grounded:
Coded Values:
[N: No]
, [Y: Yes]
-
Style:
Coded Values:
[DEC: Decorative]
, [NORM: Normal]
, [OTH: Other]
, ...13 more...
-
TreatmentType:
Coded Values:
[NON: None]
, [PNT: Paint]
, [OTH: Other]
-
UsageType:
Coded Values:
[DSL: Decorative Street Light]
, [D2P: Distribution 2-Pole Structure]
, [OBO: Owned By Others]
, ...6 more...
-
BannerArm:
Coded Values:
[N: No]
, [Y: Yes]
-
Status:
Coded Values:
[Active: Active]
, [Retired: Retired]
ID: 6
Name: Traffic Signal Pole
Domains:
-
ConstructionStatus:
Coded Values:
[0: Proposed]
, [5: Existing]
, [10: Waiting For Staking]
, ...5 more...
-
Material:
Coded Values:
[A: Aluminum]
, [C: Concrete]
, [B: Fiberglass]
, ...3 more...
-
FoundationType:
Coded Values:
[EXD: Set Extra Deep In Earth]
, [BUR: Set Normally In Earth]
, [BWC: Set Normal With Concrete Backfill]
, ...4 more...
-
Grounded:
Coded Values:
[N: No]
, [Y: Yes]
-
Style:
Coded Values:
[DEC: Decorative]
, [NORM: Normal]
, [OTH: Other]
, ...13 more...
-
TreatmentType:
Coded Values:
[NON: None]
, [PNT: Paint]
, [OTH: Other]
-
UsageType:
Coded Values:
[DSL: Decorative Street Light]
, [D2P: Distribution 2-Pole Structure]
, [OBO: Owned By Others]
, ...6 more...
-
BannerArm:
Coded Values:
[N: No]
, [Y: Yes]
-
Status:
Coded Values:
[Active: Active]
, [Retired: Retired]
Relationships:
Supported Operations:
Query
Query Attachments
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata