Field Name

Alias

Description

MUNI_PN

Municipal Pole Number

Municipally owned and installed pole number

FIELD_PN

Audited Pole Number

Primary pole number found during field audit

FIXTURTYPE

Fixture Type

Current fixture type

DECO

Decorative Classification

Decorative type (e.g. post top, pendant, wall-mount)

CONTROL

Control Device

Indicates control device present on the fixture (e.g. photocell, control node, etc.)

HEADS

Number of Heads on Pole

Number of fixture heads mounted to a single pole

CURNT_LAMP

Current Lamp Type

Current lamp type

CURNT_WATT

Current Wattage

Current wattage

OLD_LAMP

Old Lamp Type

Old lamp type prior to LED conversion

HPS = High Pressure Sodium, MV = Mercury Vapor, MH = Metal Halide, IND = Induction, LPS = Low Pressure Sodium, INC = Incandescent

OLD_WATT

Old Wattage

Old wattage prior to LED conversion

ALONEVDIST

Standalone or Distribution

Indicates whether the fixture is on a standalone pole or a distribution pole

FEED

Feed Type

Indicates whether fixture is powered with an overhead or underground electrical feed

POLEMAT

Pole Material

Pole material

ARM_LENGTH

Arm Length

Approximate length of arm in feet

ARM_ANGLE

Arm Angle

Arm angle in relation to the street

DIST_TO_ST

Pole Distance to Street

Approximate distance from pole to street in feet

ST_WIDTH

Street Width

Approximate width of the street in feet

MOUNT_HT

Mounting Height

Approximate mounting height of fixture in feet

STREETDESN

Specialized Street Design

Indicates whether fixture location has a specialized street design (e.g. intersection, cul-de-sac, safety light, etc.)

CROSSWALK

Crosswalk

Indicates whether the fixture is located near a crosswalk

ATTACHMNTS

Device Attachments

Indicates the presence of other devices on the fixture, arm, or pole

VOLTAGE

Voltage

Voltage recorded at installation

ISSUES

Field Issues

Issues found at time of field audit and installation

OWNERSHIP

Ownership

Indicates who owns the fixture

RATE_CODE

Rate Code

Current utility billing rate code for the fixture

LED_STATUS

LED Conversion Status

Indicates whether fixture was converted to LED by Tanko Lighting

MANUFCTR

Manufacturer

Manufacturer of new LED fixture

LED_FIXT

LED Fixture - Part Number

New LED fixture wattage, distribution type, and part number

UTIL_PN

Utility Pole Number

Pole number listed in corresponding utility record

UTIL_ADDR

Utility Address

Address listed in corresponding utility record

LOC_NAME

Location Name

If fixture is not in the right of way, name of location

RATE_SUB

Rate Change Submission Date

Date of rate change submission to utility

AUDIT_DATE

Audit Date

Date fixture was visited in Tanko Lighting's field audit

INSDATE

Installation Date

Date new LED fixture was installed

MAINTSCOPE

Tanko Maintenance Scope

Indicates whether the fixture is in scope for maintenance by Tanko Lighting

APPRX_ADDR

Approximate Address

Approximate street address generated with ESRI reverse geocoding tool

LATITUDE

Latitude

Latitude in WGS 84

LONGITUDE

Longitude

Longitude in WGS 84

LAT_LONG

Latitude, Longitude

Latitude, Longitude in WGS 84

TANKO_ID

Tanko ID

Unique identifier created by Tanko Lighting for each record