Name: Streetlights City Owned Parks
Display Field: TANKO_ID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><TABLE><TBODY><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>TANKO_ID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Unique identifier for each record</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POLENUM</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Pole number as collected in the field</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>OTHERPNUM</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Additional Pole Number found in the field, usually the utility's Location ID</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>SCRUB_STAT</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Indicates whether the record was matched to a utility record</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>UTIL_LOCID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Utility Location ID number</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>UTIL_SPID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Utility account number </SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>UTIL_PN</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Pole number according to the utility record</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>FIXTURTYPE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Fixture type (cobra head, post top, shoe box, etc.)</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>HEADS</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Number of fixtures mounted to a single pole</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>HEADID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Unique ID for each fixture mounted to the same pole</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>HEADS_UID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Common ID for each fixture mounted to the same pole</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>LAMPTYPE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Lamp type</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>PHOTOCELL</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Indicates whether a photocell or shorting cap is present on the fixture</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>OLDWATT</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Fixture wattage</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POLEMAT</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Pole material</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>FEEDTYPE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Indicates overhead or underground feed</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POLEHEIGHT</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Pole height</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>ARM_LENGTH</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Arm length</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>ARMDIR</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Arm direction, in relation to the street</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>NTRSCTN</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Intersection, indicates whether the fixture is located near an intersection</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>TRAFFSIG</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Traffic Signal, indicates whether the fixture is attached to a pole with a traffic signal</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>CROSSWLK</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Crosswalk, indicates whether the fixture is located near a cross walk</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>CULDESAC</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Cul-de-sac, indicates whether the fixture is located in a cul-de-sac</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>HSHIELD</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Indicates whether there is a house-side shield on the fixture</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>TREEISSUE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Tree obstruction, as observed at time of audit</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POLELEAN</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Pole leaning, as observed at time of audit</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>FIXTURDAM</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Fixture damage, as observed at time of audit</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POLEDAM</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Pole damage, as observed at time of audit</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>ARMDAM</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Arm damage, as observed at time of audit</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>ARMCOND</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Arm Condition, as observed at time of the audit</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>HANDHOLE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN>Hand hole cover missing or damaged, as observed at time of audit</SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>REV_Street</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Approximate address</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>CIRC</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Circuit ID</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>CIRC_DIST</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Distance to the Circuit. Null values are greater than 40 feet away.</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN>AREA_DEIG</SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Area designation based off of 5 towns and rural areas</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN>ST_REVIEW</SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Indicates whether the fixture is a street or area light</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>PROJ_PHASE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Project Phase</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>ROAD_DESIG</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Road designation (residential, collector, arterial)</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>NEW_FIXT</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Proposed LED fixture type</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>DECO_TYPE</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Decorative fixture type</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POINT_X</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Longitude</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>POINT_Y</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Latitude</SPAN></SPAN></P></TD></TR></TBODY></TABLE></DIV></DIV></DIV>
Service Item Id: 578529ed3ab44a27a01785bcb7ff3ab5
Copyright Text: Project Manager -
Lizzy Kay, lizzy@tankolighting.com
Project Analyst - Maverick Padilla, maverick@tankolighting.com
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 1755193.9166915566
YMin: 141884.18584547937
XMax: 1775889.4727413058
YMax: 180834.42126506567
Spatial Reference: 103180
(6597)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [255, 0, 197, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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: 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: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
Owner
(
type: esriFieldTypeString, alias: Owner, length: 50
, Coded Values:
[City: City]
, [Chelan County: Chelan County]
, [Chelan County PUD: Chelan County PUD]
, ...7 more...
)
-
POLEMAT
(
type: esriFieldTypeString, alias: POLEMAT, length: 1073741822
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
TANKO_ID
(
type: esriFieldTypeInteger, alias: TANKO_ID
)
-
POLENUM
(
type: esriFieldTypeString, alias: POLENUM, length: 1073741822
)
-
FIXTURTYPE
(
type: esriFieldTypeString, alias: FIXTURTYPE, length: 1073741822
)
-
HEADS
(
type: esriFieldTypeString, alias: HEADS, length: 1073741822
)
-
HEADID
(
type: esriFieldTypeInteger, alias: HEADID
)
-
HEADS_UID
(
type: esriFieldTypeString, alias: HEADS_UID, length: 1073741822
)
-
LAMPTYPE
(
type: esriFieldTypeString, alias: LAMPTYPE, length: 1073741822
)
-
PHOTOCELL
(
type: esriFieldTypeString, alias: PHOTOCELL, length: 1073741822
)
-
OLDWATT
(
type: esriFieldTypeString, alias: OLDWATT, length: 1073741822
)
-
FEEDTYPE
(
type: esriFieldTypeString, alias: FEEDTYPE, length: 1073741822
)
-
POLEHEIGHT
(
type: esriFieldTypeString, alias: POLEHEIGHT, length: 1073741822
)
-
ARM_LENGTH
(
type: esriFieldTypeString, alias: ARM_LENGTH, length: 1073741822
)
-
ARMDIR
(
type: esriFieldTypeString, alias: ARMDIR, length: 1073741822
)
-
NTRSCTN
(
type: esriFieldTypeString, alias: NTRSCTN, length: 1073741822
)
-
TRAFFSIG
(
type: esriFieldTypeString, alias: TRAFFSIG, length: 1073741822
)
-
CROSSWLK
(
type: esriFieldTypeString, alias: CROSSWLK, length: 1073741822
)
-
CULDESAC
(
type: esriFieldTypeString, alias: CULDESAC, length: 1073741822
)
-
HSHIELD
(
type: esriFieldTypeString, alias: HSHIELD, length: 1073741822
)
-
TREEISSUE
(
type: esriFieldTypeString, alias: TREEISSUE, length: 1073741822
)
-
POLELEAN
(
type: esriFieldTypeString, alias: POLELEAN, length: 1073741822
)
-
FIXTURDAM
(
type: esriFieldTypeString, alias: FIXTURDAM, length: 1073741822
)
-
POLEDAM
(
type: esriFieldTypeString, alias: POLEDAM, length: 1073741822
)
-
ARMDAM
(
type: esriFieldTypeString, alias: ARMDAM, length: 1073741822
)
-
ARMCOND
(
type: esriFieldTypeString, alias: ARMCOND, length: 1073741822
)
-
HANDHOLE
(
type: esriFieldTypeString, alias: HANDHOLE, length: 1073741822
)
-
REV_Street
(
type: esriFieldTypeString, alias: REV_Street, length: 1073741822
)
-
CIRC
(
type: esriFieldTypeString, alias: CIRC, length: 1073741822
)
-
CIRC_DIST
(
type: esriFieldTypeInteger, alias: CIRC_DIST
)
-
AREA_DEIG
(
type: esriFieldTypeString, alias: AREA_DEIG, length: 1073741822
)
-
ST_REVIEW
(
type: esriFieldTypeString, alias: ST_REVIEW, length: 1073741822
)
-
PROJ_PHASE
(
type: esriFieldTypeString, alias: PROJ_PHASE, length: 1073741822
)
-
ROAD_DESIG
(
type: esriFieldTypeString, alias: ROAD_DESIG, length: 1073741822
)
-
NEW_FIXT
(
type: esriFieldTypeString, alias: NEW_FIXT, length: 1073741822
)
-
DECO_TYPE
(
type: esriFieldTypeString, alias: DECO_TYPE, length: 1073741822
)
-
POINT_X
(
type: esriFieldTypeDouble, alias: POINT_X
)
-
POINT_Y
(
type: esriFieldTypeDouble, alias: POINT_Y
)
-
ServiceNumber
(
type: esriFieldTypeString, alias: ServiceNumber, length: 50
)
-
PhotoCellVerified
(
type: esriFieldTypeString, alias: PhotoCellVerified, length: 10
)
-
FLMETACODE
(
type: esriFieldTypeString, alias: FLMETACODE, length: 20
)
-
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
)
-
facilityid
(
type: esriFieldTypeString, alias: Facility ID, length: 255
)
-
locdesc
(
type: esriFieldTypeString, alias: Location Description, length: 255
)
-
spatialsource
(
type: esriFieldTypeSmallInteger, alias: Spatial Source
, Coded Values:
[0: Unknown]
, [1: As-Built]
, [2: CAD]
, ...7 more...
)
-
spatialconfidence
(
type: esriFieldTypeSmallInteger, alias: Spatial Confidence
, Coded Values:
[0: Unknown]
, [1: High]
, [2: Medium]
, ...1 more...
)
-
aandefirm
(
type: esriFieldTypeString, alias: A and E Firm, length: 255
)
-
projecttitle
(
type: esriFieldTypeString, alias: Project Title, length: 255
)
-
vertdatum
(
type: esriFieldTypeString, alias: Vertical Datum, length: 255
)
-
label
(
type: esriFieldTypeString, alias: Map Label, length: 255
)
-
UID
(
type: esriFieldTypeInteger, alias: UID
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata