Layer: Streetlights (ID:19)

View In: Map Viewer

Name: Streetlights

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"08b3e76014335087253dca6e37d4ebb4","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAVlJREFUKJGlkk0rRGEYhq+ZOfXmq8wIYWGHzUTexpEi+QVKOWeUjWzY+gt+g1FsbJxzsvADZLCRI2c/U8pHmI0ZDUmvGsfCR8Z8adzL57mv7p67R+Mf0qotJ7fpPZzjqi74KcQ8sFoXXEtl4TE7oityw5rPiLRY1iDjxtmtCUtLTCmefc8kIR3aPJM13WZAt1l0TTarJwdVn2ew/nPkmqSkTbTfoSdtcFsEDzmRwUZyUSBc8EW3tJQJICAqLcxPY3OrL1akpU5BZLy4OtIA2rXcxfUr2YZAV1j4mdGWICcAL28iJnx1BlBAdBBQCJ+zfFA9fyfvzfAIPELmRlqMHxpcAkhHPbgG5wC6pSaaYCc5R77izVqIfd1iwX1i62um20yHAuIuaah8kfc37M6S1m2yegsL+MSkzRJwcGyoVElQSdsf7d4DG9Kh0zNIlPNUhP+qqrBnVP5rgHd1OXL8isfDoAAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"Street","description":""},{"symbol":{"type":"esriPMS","url":"906c2db54796a6ef9c7e9e38014aab60","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAWpJREFUKJGlkj9Lw1AUxU+ShhpwKQUFHdzEpQhCrYtSHjze6ujiUlx0E6FNdiHpF7CCLs4OTqU8gjFuVvoBKggqqF1spQVBGnrjUkrV/pF6psu958flcG8E/1Bk1NBJpxdM33+aCEY0ug3gcDJ4jAbCthApJQhWAKzajO0pul4zpbwYCztCMEVVw5znFRwh4pbnHdlCLDmc75iuezp6cxAs5jzvuL9lSVl1OE84QsybUr58g+10ellV1USo6zEAc3nGtgAgJEr0amAaRAd5xm6JqGb5/nUEAKZ0/eETqGtBECNNWyOiGwCApiVDw6gAgNJuzwAAGUalQ/TR27zvui0ALQDPNmPrlu8/dvO/m8XiPQDYnG9onc55tlhsDs8cjV7anGfirnvW6LbyQmyC6DXrec1+6y/YKpXu7FSq3uA8gyBIOoztEnBluW71p3fgna1y+Q3AiSPErCllYZBnKPxXjYRNKYf+NQB8AVjdiciD0ilgAAAAAElFTkSuQmCC","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"5","label":"LED Streetlight","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: SUBTYPECD

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FEEDERID (type: esriFieldTypeString, alias: Feeder ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FEEDERID2 (type: esriFieldTypeString, alias: Feeder ID 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
OPERATINGVOLTAGE (type: esriFieldTypeInteger, alias: Operating Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [120: 4.16 kV Grounded Y], [160: 7.2 kV Grounded Y], [210: 12.5 kV Grounded Y], ... 7 more ...)
COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
WORKORDERID (type: esriFieldTypeString, alias: Work Order Id, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
INSTALLATIONDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
FEEDERINFO (type: esriFieldTypeInteger, alias: Feeder Information, SQL Type: sqlTypeOther, nullable: true, editable: true)
SYMBOLROTATION (type: esriFieldTypeDouble, alias: SYMBOLROTATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
PHASEDESIGNATION (type: esriFieldTypeInteger, alias: Phase Designation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: B], [4: A], [1: C])
BALLASTTYPE (type: esriFieldTypeString, alias: Ballast Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
FIXTURESUPPORT (type: esriFieldTypeString, alias: Fixture Support, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
LAMPTYPE (type: esriFieldTypeString, alias: Lamp Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [FLUO: Fluorescent], [HPS: High Pressure Sodium], [INC: Incandescent], ... 4 more ...)
LENSTYPE (type: esriFieldTypeString, alias: Lens Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DIF: Diffuser], [RFL: Reflector], [RFR: Refractor])
LIGHTCOUNT (type: esriFieldTypeInteger, alias: Light Count, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [6: 6], ... 1 more ...)
LIGHTSTYLE (type: esriFieldTypeString, alias: Light Style, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: Single Cobra Head], [2: Double Cobra Head], [3: Shoe Box], ... 11 more ...)
OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
PHOTOCELLTYPE (type: esriFieldTypeString, alias: Photocell Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Regular: Regular], [Shorting Cap: Shorting Cap])
SHIELDING (type: esriFieldTypeString, alias: Shielding Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
STREETLIGHTROLE (type: esriFieldTypeString, alias: Streetlight Role, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [AL: Area Light], [COM: Commercial Area Lighting], [FPL: Family Protective Lighting], ... 5 more ...)
TIMECONTROL (type: esriFieldTypeString, alias: Time Control Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
WATTAGE (type: esriFieldTypeDouble, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [100: 100 Watts], [175: 175 Watts], [250: 250 Watts], ... 10 more ...)
MMELECTRICTRACEWEIGHT (type: esriFieldTypeInteger, alias: MMELECTRICTRACEWEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
SUPPORTSTRUCTUREOBJECTID (type: esriFieldTypeInteger, alias: SUPPORTSTRUCTUREOBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OLDOID (type: esriFieldTypeInteger, alias: OLDOID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SDEOID (type: esriFieldTypeInteger, alias: SDEOID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SAVESUPOID (type: esriFieldTypeInteger, alias: Save Sup OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
PHASE (type: esriFieldTypeString, alias: PHASE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
TMPFACID (type: esriFieldTypeString, alias: TMPFACID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MANUFACTRURER (type: esriFieldTypeString, alias: MANUFACTRURER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DECORATIVETYPE (type: esriFieldTypeString, alias: Decorative Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Globe: Globe Acorn], [N/A: N/A], [Teardrop: Teardrop], ... 2 more ...)
SUPPORTLENGTH (type: esriFieldTypeString, alias: Support Length, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1.5: 1.5'], [2.5: 2.5'], [4: 4'], ... 3 more ...)
POLESETBACK (type: esriFieldTypeString, alias: Pole Setback, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0: 0], [1: 1'], [2: 2'], ... 30 more ...)
VERIFIED (type: esriFieldTypeString, alias: Verified, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Moved: Moved], [Attributes only: Attributes Only], [New: New], ... 3 more ...)
HOUSESIDESHIELD (type: esriFieldTypeString, alias: House Side Shield, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
MOUNTINGHEIGHT (type: esriFieldTypeString, alias: Mounting Height, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Interstate Height: Interstate Height], [14: 14'], [15: 15'], ... 19 more ...)
ADG_DAMAGE (type: esriFieldTypeString, alias: ADG_DAMAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
ADG_COMMENTS (type: esriFieldTypeString, alias: ADG_COMMENTS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
REPLACEDBY (type: esriFieldTypeString, alias: LEDREPLACESTATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
REPLACEDDATE (type: esriFieldTypeDate, alias: REPLACEDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LEDREPLACESTATUS (type: esriFieldTypeString, alias: LEDREPLACESTATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Replaced: Replaced])

Types:

Field Name: ENABLED
Inherited
Field Name: OPERATINGVOLTAGE
Inherited
Field Name: PHASEDESIGNATION
Inherited
Field Name: LAMPTYPE
Inherited
Field Name: LENSTYPE
Inherited
Field Name: LIGHTCOUNT
Inherited
Field Name: LIGHTSTYLE
Inherited
Field Name: PHOTOCELLTYPE
Inherited
Field Name: SHIELDING
Inherited
Field Name: STREETLIGHTROLE
Inherited
Field Name: TIMECONTROL
Inherited
Field Name: WATTAGE
Inherited
Field Name: DECORATIVETYPE
Inherited
Field Name: SUPPORTLENGTH
Inherited
Field Name: POLESETBACK
Inherited
Field Name: VERIFIED
Inherited
Field Name: HOUSESIDESHIELD
Coded Values:[N: No], [Y: Yes]
Field Name: MOUNTINGHEIGHT
Inherited
Field Name: ADG_DAMAGE
Inherited
Field Name: LEDREPLACESTATUS
Inherited

ENABLED: 1
SUBTYPECD: 1
PHASEDESIGNATION: 4

Field Name: ENABLED
Inherited
Field Name: OPERATINGVOLTAGE
Inherited
Field Name: PHASEDESIGNATION
Inherited
Field Name: LAMPTYPE
Inherited
Field Name: LENSTYPE
Inherited
Field Name: LIGHTCOUNT
Inherited
Field Name: LIGHTSTYLE
Inherited
Field Name: PHOTOCELLTYPE
Inherited
Field Name: SHIELDING
Inherited
Field Name: STREETLIGHTROLE
Inherited
Field Name: TIMECONTROL
Inherited
Field Name: WATTAGE
Inherited
Field Name: DECORATIVETYPE
Inherited
Field Name: SUPPORTLENGTH
Inherited
Field Name: POLESETBACK
Inherited
Field Name: VERIFIED
Inherited
Field Name: HOUSESIDESHIELD
Inherited
Field Name: MOUNTINGHEIGHT
Inherited
Field Name: ADG_DAMAGE
Inherited
Field Name: LEDREPLACESTATUS
Inherited

ENABLED: 1
SUBTYPECD: 5
PHASEDESIGNATION: 4
OWNERSHIP: UTIL
SHIELDING: Y
STREETLIGHTROLE: AL
TIMECONTROL: N
WATTAGE: 175
VERIFIED: Not Verified
HOUSESIDESHIELD: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/4/2022 3:28:41 PM

Schema Last Edit Date: 5/4/2022 3:28:41 PM

Data Last Edit Date: 5/4/2022 3:28:41 PM

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