Name: StreetLights

Display Field: LOC_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 999209.670530413
YMin: 741123.2424967011
XMax: 1051163.7245894554
YMax: 781036.6680243524
Spatial Reference: 102656  (2234)

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
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

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 )
• MUNITAG ( type: esriFieldTypeString, alias: Municipal Tag Number, length: 8000 )
• FIELD_PN ( type: esriFieldTypeString, alias: Field Pole Number, length: 8000 )
• UTIL_PN ( type: esriFieldTypeString, alias: Utility Pole Number, length: 8000 )
• FIXTURTYPE ( type: esriFieldTypeString, alias: Fixture Type, length: 8000 )
• DECO ( type: esriFieldTypeString, alias: Decorative Classification, length: 8000 )
• CURNT_LAMP ( type: esriFieldTypeString, alias: Current Lamp Type, length: 8000 )
• CURNT_WATT ( type: esriFieldTypeString, alias: Current Wattage, length: 8000 )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, length: 8000 )
• LED_STATUS ( type: esriFieldTypeString, alias: LED Conversion Status, length: 8000 )
• LED_FIXT ( type: esriFieldTypeString, alias: LED Fixture, Part Number, length: 8000 )
• MANUFCTR ( type: esriFieldTypeString, alias: Manufacturer, length: 8000 )
• INSDATE ( type: esriFieldTypeString, alias: Installation Date, length: 8000 )
• VOLTAGE ( type: esriFieldTypeString, alias: Voltage, length: 8000 )
• CONTROL ( type: esriFieldTypeString, alias: Control Device, length: 8000 )
• ISSUES ( type: esriFieldTypeString, alias: Field Issues, length: 8000 )
• AUDIT_DATE ( type: esriFieldTypeString, alias: Audit Date, length: 50 )
• HEADS ( type: esriFieldTypeString, alias: Number of Heads on Pole, length: 8000 )
• ALONEVDIST ( type: esriFieldTypeString, alias: Standalone or Distribution, length: 8000 )
• FEED ( type: esriFieldTypeString, alias: Feed Type, length: 8000 )
• POLEMAT ( type: esriFieldTypeString, alias: Pole Material, length: 8000 )
• ARM_LENGTH ( type: esriFieldTypeString, alias: Arm Length, length: 8000 )
• ARM_DIR ( type: esriFieldTypeString, alias: Arm Angle, length: 8000 )
• MOUNT_HT ( type: esriFieldTypeString, alias: Mounting Height, length: 8000 )
• STREETDESN ( type: esriFieldTypeString, alias: Street Design, length: 8000 )
• CROSSWALK ( type: esriFieldTypeString, alias: Crosswalk, length: 8000 )
• OLD_LAMP ( type: esriFieldTypeString, alias: Old Lamp Type, length: 8000 )
• OLD_WATT ( type: esriFieldTypeString, alias: Old Wattage, length: 8000 )
• LOC_NAME ( type: esriFieldTypeString, alias: Additional Scope Location Name, length: 8000 )
• UTIL_ADDR ( type: esriFieldTypeString, alias: Utility Address, 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: Latitude, Longitude, length: 8000 )
• TANKO_ID ( type: esriFieldTypeInteger, alias: Tanko ID )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata