Description: Field NameAliasDescriptionMUNITAGMunicipal Tag NumberMunicipally owned and installed tagFIELD_PNField Pole NumberPrimary pole number found in the fieldUTIL_PNUtility Pole NumberPole number listed in corresponding utility recordFIXTURTYPEFixture TypeCurrent fixture typeDECODecorative ClassificationDecorative type (e.g. post top, pendant, wall-mount)CURNT_LAMPCurrent Lamp TypeCurrent lamp typeCURNT_WATTCurrent WattageCurrent wattageOWNERSHIPOwnershipIndicates whether fixture is owned by MiddletownLED_STATUSLED Conversion StatusIndicates whether fixture was converted to LED by Tanko LightingLED_FIXTLED Fixture, Part NumberNew LED fixture wattage, distribution type, and part numberMANUFCTRManufacturerManufacturer of new LED fixtureINSDATEInstallation DateInstallation date of new LED fixtureVOLTAGEVoltageVoltage recorded at installationCONTROLControl DeviceIndicates control device present on the fixture (e.g. photocell, control node, etc.)ISSUESField IssuesIssues found at time of audit and installAUDIT_DATEAudit DateDate of Tanko Lighting street light field auditHEADSNumber of Heads on PoleNumber of fixture heads mounted to a single poleALONEVDISTStandalone or DistributionIndicates whether the fixture is on a standalone pole or distribution poleFEEDFeed TypeIndicates whether fixture is powered with an overhead or underground feedPOLEMATPole MaterialPole materialARM_LENGTHArm LengthApproximate length of arm in feetARM_DIRArm AngleArm angle in relation to the streetMOUNT_HTMounting HeightApproximate mounting height of fixture in feetSTREETDESNStreet DesignIndicates whether a fixture is at an intersection, cul-de-sac, is a safety light, etc.CROSSWALKCrosswalkIndicates whether the fixture is located near a crosswalkOLD_LAMPOld Lamp TypeOld lamp type prior to LED conversionOLD_WATTOld WattageOld wattage prior to LED conversionLOC_NAMEAdditional Scope Location NameName of additional scope locationUTIL_ADDRUtility AddressAddress listed in corresponding utility recordAPPRX_ADDRApproximate AddressApproximate street address autogenerated via ESRI reverse geocoder toolLATITUDELatitudeLatitude in WGS 84LONGITUDELongitudeLongitude in WGS 84LAT_LONGLatitude, LongitudeLatitude, Longitude in WGS 84TANKO_IDTanko IDUnique identifier created by Tanko Lighting for each record
Copyright Text: Toni Leong, PMP
Senior Project Manager - Team Lead
toni@tankolighting.com
Emily Danko
Project Manager
emily@tankolighting.com
Maeve Hanafin
Project Manager
maeve@tankolighting.com
Paolo Salvoni
GIS Data Analyst II
paolo@tankolighting.com