Name: StreetLights

Display Field: MUNITAG

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: Field NameAliasDescriptionMUNITAGMunicipal Pole NumberMunicipally owned and installed pole tagFIELD_PNField Pole NumberPrimary pole number found in the fieldUTIL_PNUtility Pole NumberPole number listed in corresponding utility recordFIXTURTYPEFixture TypeCurrent fixture typeCURNT_LAMPCurrent Lamp TypeCurrent lamp typeCURNT_WATTCurrent WattageCurrent wattageOWNERSHIPOwnershipIndicates who owns the fixtureLED_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 conversionUTIL_ACCTService Account NumberUtility service account number post-acquisitionUTIL_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 84MAINTSCOPEMaintenance ScopeIndicates whether the fixture is within Tanko Lighting's maintenance scope (at time of data delivery; subject to future updates)TANKO_IDTanko IDUnique identifier created by Tanko Lighting for each record

Copyright Text: Toni Leong, PMP Senior Project Manager - Team Lead toni@tankolighting.com Rebecca Rodriguez Data Program Manager rebecca@tankolighting.com

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -118.826533
YMin: 34.2275930000001
XMax: -118.635314
YMax: 34.3119380000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"07f3ff4a18c8abe5310510ec479c0b52","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAYpJREFUKJGd0ksvQ0EUB/D/zJ3rKlXilYY7bm0IiYWw8YhEbCSCjc9gZUOIYC+kSxLiC7AnXpuKKAshsbCxofog0QeaVsudjgUaN5oSZ3dm8pv85+Qw/LOYpTuSNlCMDlAx4lIEj0j6sGGyLWSwhG4SzQ1PZP1UQdpTTYXxmKEICIYaKgy37bU9KcnEvFf2p7vIiRUeS21eSx7cCLXOndJ+vDvIhGPBntwfP5ZN6CSB7M2i7WUuJFjd2qua8z+bpgKkNPtycWJlDBjMwlIqhqaTtrzD2DQV9EnSbcmSkLQsr/qsW1MpvboO1DbU60EGAIzg+S8wlqFPGhXlAD5glWJeAGj5DTarb2eKogSzUVuL4h48OXoB1OZxqZ6S+I6u69EstKty11MZdvSGK2cAVOdAL6v2xKxTTXu/DhgAcM5DPp/Pe+68m+y4d7alQYYB1ACIAHJ/ryK23VgYfzYM16kFAoBhGKd+vz94pftNAIeEkIyUkgAooJRecu66/B7Bsquc8xCA9d+GBADvX8SHGEIwtVYAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• MUNITAG (type: esriFieldTypeString, alias: Municipal Pole Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FIELD_PN (type: esriFieldTypeString, alias: Field Pole Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UTIL_PN (type: esriFieldTypeString, alias: Utility Pole Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FIXTURTYPE (type: esriFieldTypeString, alias: Fixture Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CURNT_LAMP (type: esriFieldTypeString, alias: Current Lamp Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CURNT_WATT (type: esriFieldTypeString, alias: Current Wattage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LED_STATUS (type: esriFieldTypeString, alias: LED Conversion Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LED_FIXT (type: esriFieldTypeString, alias: LED Fixture - Part Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MANUFCTR (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• INSDATE (type: esriFieldTypeString, alias: Installation Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VOLTAGE (type: esriFieldTypeString, alias: Voltage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CONTROL (type: esriFieldTypeString, alias: Control Device, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ISSUES (type: esriFieldTypeString, alias: Field Issues, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AUDIT_DATE (type: esriFieldTypeString, alias: Audit Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HEADS (type: esriFieldTypeString, alias: Number of Heads on Pole, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ALONEVDIST (type: esriFieldTypeString, alias: Standalone or Distribution, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FEED (type: esriFieldTypeString, alias: Feed Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• POLEMAT (type: esriFieldTypeString, alias: Pole Material, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ARM_LENGTH (type: esriFieldTypeString, alias: Arm Length, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ARMDIR (type: esriFieldTypeString, alias: Arm Angle, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MOUNT_HT (type: esriFieldTypeString, alias: Mounting Height, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• STREETDESN (type: esriFieldTypeString, alias: Street Design, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CROSSWALK (type: esriFieldTypeString, alias: Crosswalk, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OLD_LAMP (type: esriFieldTypeString, alias: Old Lamp Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OLD_WATT (type: esriFieldTypeString, alias: Old Wattage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UTIL_ACCT (type: esriFieldTypeString, alias: Service Account Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UTIL_ADDR (type: esriFieldTypeString, alias: Utility Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• APPRX_ADDR (type: esriFieldTypeString, alias: Approximate Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAT_LONG (type: esriFieldTypeString, alias: Latitude, Longitude, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MAINTSCOPE (type: esriFieldTypeString, alias: Tanko Maintenance Scope, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TANKO_ID (type: esriFieldTypeInteger, alias: Tanko ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: StreetLights
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/24/2022 6:56:15 PM

Schema Last Edit Date: 8/24/2022 6:56:15 PM

Data Last Edit Date: 8/24/2022 6:56:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat