LED Street Lights
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
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'POLENUM', 'type': 'esriFieldTypeString', 'alias': 'Pole Number', 'length': 1073741822, 'domain': None}, {'name': 'ADDTNLPNUM', 'type': 'esriFieldTypeString', 'alias': 'Additional Pole Number', 'length': 1073741822, 'domain': None}, {'name': 'GROTON_PN', 'type': 'esriFieldTypeString', 'alias': 'Corrected Pole Number', 'length': 1073741822, 'domain': None}, {'name': 'FIXTURTYPE', 'type': 'esriFieldTypeString', 'alias': 'Fixture Type', 'length': 1073741822, 'domain': None}, {'name': 'NEWLAMP', 'type': 'esriFieldTypeString', 'alias': 'Lamp Type', 'length': 1073741822, 'domain': None}, {'name': 'NEWFIXT', 'type': 'esriFieldTypeString', 'alias': 'New Fixture', 'length': 1073741822, 'domain': None}, {'name': 'INST_STAT', 'type': 'esriFieldTypeString', 'alias': 'Installation Status', 'length': 1073741822, 'domain': None}, {'name': 'INST_DATE', 'type': 'esriFieldTypeString', 'alias': 'Install Date', 'length': 1073741822, 'domain': None}, {'name': 'HEADS', 'type': 'esriFieldTypeString', 'alias': 'Heads', 'length': 1073741822, 'domain': None}, {'name': 'PHOTOCELL', 'type': 'esriFieldTypeString', 'alias': 'Photocell', 'length': 1073741822, 'domain': None}, {'name': 'VOLTAGE', 'type': 'esriFieldTypeString', 'alias': 'Voltage', 'length': 1073741822, 'domain': None}, {'name': 'POLEMAT', 'type': 'esriFieldTypeString', 'alias': 'Pole Material', 'length': 1073741822, 'domain': None}, {'name': 'FEED_TYPE', 'type': 'esriFieldTypeString', 'alias': 'Feed Type', 'length': 1073741822, 'domain': None}, {'name': 'STANDALONE', 'type': 'esriFieldTypeString', 'alias': 'Standalone Pole', 'length': 1073741822, 'domain': None}, {'name': 'GROUNDING', 'type': 'esriFieldTypeString', 'alias': 'Grounding', 'length': 1073741822, 'domain': None}, {'name': 'METALFOUND', 'type': 'esriFieldTypeString', 'alias': 'Attachment to Foundation', 'length': 1073741822, 'domain': None}, {'name': 'MOUNTHEIGH', 'type': 'esriFieldTypeString', 'alias': 'Mounting Height', 'length': 1073741822, 'domain': None}, {'name': 'ARM_LENGTH', 'type': 'esriFieldTypeString', 'alias': 'Arm Length', 'length': 1073741822, 'domain': None}, {'name': 'ARMDIR', 'type': 'esriFieldTypeString', 'alias': 'Arm Direction', 'length': 1073741822, 'domain': None}, {'name': 'ARMCOND', 'type': 'esriFieldTypeString', 'alias': 'Arm Condition', 'length': 1073741822, 'domain': None}, {'name': 'POLELEAN', 'type': 'esriFieldTypeString', 'alias': 'Pole Leaning', 'length': 1073741822, 'domain': None}, {'name': 'POLEDAM', 'type': 'esriFieldTypeString', 'alias': 'Pole Damage', 'length': 1073741822, 'domain': None}, {'name': 'HANDHOLE', 'type': 'esriFieldTypeString', 'alias': 'Hand Hole Issue', 'length': 1073741822, 'domain': None}, {'name': 'TREEISSUE', 'type': 'esriFieldTypeString', 'alias': 'Tree Issue', 'length': 1073741822, 'domain': None}, {'name': 'NTRSCTN', 'type': 'esriFieldTypeString', 'alias': 'Intersection', 'length': 1073741822, 'domain': None}, {'name': 'CROSSWLK', 'type': 'esriFieldTypeString', 'alias': 'Crosswalk', 'length': 1073741822, 'domain': None}, {'name': 'CULDESAC', 'type': 'esriFieldTypeString', 'alias': 'Culdesac', 'length': 1073741822, 'domain': None}, {'name': 'HSHIELD', 'type': 'esriFieldTypeString', 'alias': 'Houseside Shield', 'length': 1073741822, 'domain': None}, {'name': 'OLDFIXTURE', 'type': 'esriFieldTypeString', 'alias': 'Old Fixture Type', 'length': 1073741822, 'domain': None}, {'name': 'OLDLAMP', 'type': 'esriFieldTypeString', 'alias': 'Old Lamp Type', 'length': 1073741822, 'domain': None}, {'name': 'OLDWATT', 'type': 'esriFieldTypeString', 'alias': 'Old Wattage', 'length': 1073741822, 'domain': None}, {'name': 'APPRX_ADDR', 'type': 'esriFieldTypeString', 'alias': 'Approximate Address', 'length': 1073741822, 'domain': None}, {'name': 'LAT_Y', 'type': 'esriFieldTypeDouble', 'alias': 'Latitude', 'domain': None}, {'name': 'LONG_X', 'type': 'esriFieldTypeDouble', 'alias': 'Longitude\n', 'domain': None}, {'name': 'LAT_LONG', 'type': 'esriFieldTypeString', 'alias': 'Latitude, Longitude', 'length': 1073741822, 'domain': None}, {'name': 'UTILITY', 'type': 'esriFieldTypeString', 'alias': 'Utility', 'length': 1073741822, 'domain': None}, {'name': 'UTIL_STAT', 'type': 'esriFieldTypeString', 'alias': 'Utility Match', 'length': 1073741822, 'domain': None}, {'name': 'UTIL_WATT', 'type': 'esriFieldTypeString', 'alias': 'Old Utility Wattage', 'length': 1073741822, 'domain': None}, {'name': 'TANKO_UID', 'type': 'esriFieldTypeInteger', 'alias': 'Tanko Unique ID', 'domain': None}, {'name': 'MFR', 'type': 'esriFieldTypeString', 'alias': 'Manufacturer', 'length': 1073741822, 'domain': None}, {'name': 'MODEL_NUM', 'type': 'esriFieldTypeString', 'alias': 'Model Number', 'length': 1073741822, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}]
[{'name': 'R1113_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'S1068_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriPMS', 'url': 'd211cdc78e74ba2c43359d329d5c45d9', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAATZJREFUOI2lkj8oxHEYh5/Tue/vOi69p2RQikFIBkRiYrXJKEaXzWoj0bnsSo5JmSxXLoUrRdRNLDfIYtC9ogzfXBj41Y/uv3d8e5/n/bz1+vln+WvkHGPMqLX2pBZBENgNhUJr1tqqEwSBhIisq2oGSp9gRKRPVZ+Aew+8oao37lAxwVS/ITojqjnD+84jPoWwiKyo6rV3sJCge7qVha0BRnzQCBDNc96VxLqxSwqMMbPLvTbiwgDGz/hqJ9tLWSaAZEmBtbYhHKD5b78tQj1ZWsomAFKZZzqGIrR7evnDBwLAVSWC4/kL4gdjpHqaGPyA3P4dp0dqXsDelhM4QOLNmLnJtB0GXoE6IA02UWDZL4ED7IlITFUvgbNCQDGBw/eTbP7AFZcriIlIvFrYK1hU1c9qYYAvMhlmUf+x0tgAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 12, 'height': 12, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': None}
nan
nan