Description: Field NameAliasField DescriptionPOLENUMPole NumberPole number as collected in the fieldADDTNLPNUMAdditional Pole NumberAdditional pole number as collected in the fieldGROTON_PNCorrected Pole NumberPole number corrected with Eversource dataFIXTURTYPEFixture TypeNew fixture typeNEWLAMPLamp TypeNew lamp typeNEWFIXTNew FixtureInstalled LED fixtureINST_STATInstallation StatusRed Thread installation statusINST_DATEInstall DateDate of installationHEADSHeadsNumber of fixtures mounted to a single pole PHOTOCELLPhotocellIndicates the presence of a photocell or shorting capVOLTAGEVoltageVoltage collected during installPOLEMATPole Material Pole material FEED_TYPEFeed TypePower sourceSTANDALONEStandalone PoleIndicates if the pole is a standalone or distribution poleGROUNDINGGroundingIndicates the type of grounding identifed during auditMETALFOUNDAttachment to FoundationIf available, indicates attachment to foundationMOUNTHEIGHMounting HeightApproximate fixture mounting heightARM_LENGTHArm Length Approximate arm lengthARMDIRArm DirectionDirection of fixture in relation to streetARMCONDArm ConditionIs the arm rusting, bent, or normal?POLELEANPole LeaningPole leaning found in auditPOLEDAMPole DamagePole damage found in auditHANDHOLEHand Hole IssueHand hole cover missing or damaged as found in auditTREEISSUETree IssueTree interference found in auditNTRSCTNIntersectionIs fixture located at an intersection?CROSSWLKCrosswalkIs fixture located at a crosswalk?CULDESACCuldesacIs the fixture located at a cul-de-sac?HSHIELDHouseside ShieldIs a houseside shield present or needed?OLDFIXTUREOld Fixture TypeFixture type found during the auditOLDLAMPOld Lamp TypeLamp type before conversionOLDWATTOld WattageWattage before conversionAPPRX_ADDRApproximate AddressReverse geocoded addressLAT_YLatitude Latitude of fixtureLONG_XLongitudeLongitude of fixtureLAT_LONGLatitude, LongitudeGPS coordinates of the fixtureUTILITYUtilityEversource or Groton UtilitiesUTIL_STATUtility MatchStatus of match to utility recordUTIL_WATTOld Utility WattageOld wattage found in utility dataTANKO_UIDTanko Unique IDTanko's unique identification numberMFRManufacturerFixture manufacturerMODEL_NUMModel Number Fixture part number
Copyright Text: Jaclyn Blackwell
Senior Project Manager
jaclyn@tankolighting.com
415.470.3787 (phone)
Rawley Loken
Project Design Manager
rawley@tankolighting.com
415.696.6603 (phone)
Drew Taylor
Lead GIS & IT Analyst
drew@tankolighting.com
310.720.0239 (phone)
Nick Fiore
Project Data Analyst
nick@tankolighting.com
415.310.4048 (phone)