Name: Street Lights

Display Field: POLENUM

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Field NameAliasDescriptionTANKO_IDTanko IDUnique identifier for each recordPOLENUMPrimary Pole NumberPrimary pole number found in the fieldADDTNLPNUMAdditional Pole NumbersAdditional pole numbers found in the fieldFIXTURTYPEFixture TypeCurrent fixture typeCURNT_LAMPCurrent Lamp TypeCurrent lamp typeLED_STATUSLED Conversion StatusIndicates whether fixture was converted to LED by Tanko LightingDESFIXTNew LED Fixture DesignNew LED fixture wattage and distribution type that was designedLED_FIXTNew LED Fixture Installed and Part NumberNew LED fixture wattage and distribution type that was installedPART_NUMDesign Part NumberPart number of the designed LED fixtureMANUFCTRManufacturerManufacturer of new LED fixtureFUSINGFusingIndicates whether fusing was installed during LED conversionINSDATELED Installation DateInstallation date of new LED fixtureDECODecorative ClassificationDecorative type (e.g. post top, pendant, wall-mount)DECO_SUBDecorative Sub-ClassificationDecorative style (e.g. colonial, acorn, victorian)PHOTOCELLPhotocell or Shorting CapIndicates whether a photocell or shorting cap is on the fixtureHEADSNumber of Heads on PoleNumber of fixture heads mounted to a single poleVOLTAGEVoltageVoltage recorded at installationAPPRX_ADDRApproximate AddressApproximate street addressLATITUDELatitudeLatitude in WGS 84LONGITUDELongitudeLongitude in WGS 84LAT_LONGCoordinatesLatitude, Longitude in WGS 84FEEDPower Feed TypeIndicates whether fixture is powered with an overhead or underground feedALONEVDISTStandalone or DistributionIndicates whether the pole is a standalone pole or distribution polePOLEMATPole MaterialPole materialMOUNT_HTMounting HeightApproximate mounting height of fixture in feetARM_LENGTHArm LengthApproximate length of arm in feetINSISSUESInstallation IssuesIssues found at time of installationAUD_ISSUESAudit IssuesIssues found at time of auditARM_DIRArm AngleArm angle in relation to the streetSTREETDESNStreet 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_WATTOld WattageOld wattage prior to LED conversionOLD_LAMPOld Lamp TypeOld lamp type prior to LED conversionUTIL_PNUtility Pole NumberPole number listed in corresponding utility recordUTIL_ADDRUtility AddressAddress listed in corresponding utility recordUTILITYUTILITYUtility company

Definition Expression: N/A

Copyright Text: Jaclyn Blackwell Senior Project Manager jaclyn@tankolighting.com Victoria "Tori" Evins Project Manager victoria@tankolighting.com Nick Fiore Project Associate nick@tankolighting.com Paolo Salvoni Project Data Analyst paolo@tankolighting.com

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Extent:

XMin: 386622.48437713884
YMin: 3037205.037731875
XMax: 417427.42307317746
YMax: 3052952.4901701338
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry , alias: Shape )
• TANKO_ID ( type: esriFieldTypeInteger , alias: Tanko ID )
• POLENUM ( type: esriFieldTypeString , alias: Primary Pole Number , length: 8000 )
• ADDTNLPNUM ( type: esriFieldTypeString , alias: Additional Pole Numbers , length: 8000 )
• FIXTURTYPE ( type: esriFieldTypeString , alias: Fixture Type , length: 8000 )
• CURNT_LAMP ( type: esriFieldTypeString , alias: Current Lamp Type , length: 8000 )
• LED_STATUS ( type: esriFieldTypeString , alias: LED Conversion Status , length: 8000 )
• DESFIXT ( type: esriFieldTypeString , alias: New LED Fixture Design , length: 8000 )
• LED_FIXT ( type: esriFieldTypeString , alias: New LED Fixture Installed and Part Number , length: 8000 )
• PART_NUM ( type: esriFieldTypeString , alias: Design Part Number , length: 8000 )
• MANUFCTR ( type: esriFieldTypeString , alias: Manufacturer , length: 8000 )
• FUSING ( type: esriFieldTypeString , alias: Fusing , length: 8000 )
• INSDATE ( type: esriFieldTypeString , alias: LED Installation Date , length: 8000 )
• DECO ( type: esriFieldTypeString , alias: Decorative Classification , length: 8000 )
• DECO_SUB ( type: esriFieldTypeString , alias: Decorative Sub-Classification , length: 8000 )
• PHOTOCELL ( type: esriFieldTypeString , alias: Photocell or Shorting Cap , length: 8000 )
• HEADS ( type: esriFieldTypeString , alias: Number of Heads on Pole , length: 8000 )
• VOLTAGE ( type: esriFieldTypeString , alias: Voltage , length: 8000 )
• APPRX_ADDR ( type: esriFieldTypeString , alias: Approximate Address , length: 8000 )
• LATITUDE ( type: esriFieldTypeDouble , alias: Latitude )
• LONGITUDE ( type: esriFieldTypeDouble , alias: Longitude )
• LAT_LONG ( type: esriFieldTypeString , alias: Coordinates , length: 8000 )
• FEED ( type: esriFieldTypeString , alias: Power Feed Type , length: 8000 )
• ALONEVDIST ( type: esriFieldTypeString , alias: Standalone or Distribution , length: 8000 )
• POLEMAT ( type: esriFieldTypeString , alias: Pole Material , length: 8000 )
• MOUNT_HT ( type: esriFieldTypeString , alias: Mounting Height , length: 8000 )
• ARM_LENGTH ( type: esriFieldTypeString , alias: Arm Length , length: 8000 )
• INSISSUES ( type: esriFieldTypeString , alias: Installation Issues , length: 8000 )
• AUD_ISSUES ( type: esriFieldTypeString , alias: Audit Issues , length: 8000 )
• ARM_DIR ( type: esriFieldTypeString , alias: Arm Angle , length: 8000 )
• STREETDESN ( type: esriFieldTypeString , alias: Street Design , length: 8000 )
• CROSSWALK ( type: esriFieldTypeString , alias: Crosswalk , length: 8000 )
• OLD_WATT ( type: esriFieldTypeString , alias: Old Wattage , length: 8000 )
• OLD_LAMP ( type: esriFieldTypeString , alias: Old Lamp Type , length: 8000 )
• UTIL_PN ( type: esriFieldTypeString , alias: Utility Pole Number , length: 8000 )
• UTIL_ADDR ( type: esriFieldTypeString , alias: Utility Address , length: 8000 )
• UTILITY ( type: esriFieldTypeString , alias: Utility , length: 8000 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• TankoID_Text ( type: esriFieldTypeString , alias: TankoID_Text , length: 50 )

Supported Operations:   Query   Generate Renderer   Return Updates