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: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"if($feature.SUBTYPECD == 1 || $feature.SUBTYPECD == 7){\n return \"1\"\n}\nreturn \"5\"","valueExpressionTitle":" ","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"4f11885b97cd7d2a2687746826a31d1d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABnklEQVRIid3VT0jTYRgH8E9hW+QlSqM6qAgjIqyIunWTBV48KkRFCFkUxC4dHDKiwPJoHRwRXSIIunpqHYwOtbYKI/pDwhSSJGF02Vj/KAiFLTa3/cRL3+P7Pu/n5eV5ed8W65iW/xbf0ElfNyfaaAuzuUjhM/OvmSwwEwjfT28X4+fp6SVUXljAAwbv8vwlZ78y1zB+mNgAI5fYUW2+FafZepxj53j4hOFZpuvi++g/Sfwi7eokhDtEhrj1iWiJ+dXwUA9jjcDlSRLJkZymryZ+kNhl9jYDr5zgFEcyHChvcgXeSXQPGwXIANsnGc5woSq+m51B4JUm76KjfKwCD7MlKL68QWtN/AelteClf9ZX4Evkg8I/8eUvUQPPkV3iaFP3cDmPKL7jXk08w9Ur9N+ku1l8gpk8qZo48k+5nWI02kRzr7PwnhH8Xg33gmsJIhhsZIMJFu8zPsfjhh6uZwzFmZ3izChd1XrwgV8J3r4i/pGppp7cLGNZkmkSHRxqZ9smwt8oLrCYI/WGG/ge9LPIp4ml6xQFxdeUdcX/ANZ8Z6vR1xIWAAAAAElFTkSuQmCC","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"Street Light"},{"symbol":{"type":"esriPMS","url":"b8d0ab8014e290d577cabc39e9acce3f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB8klEQVRIid3VX0hTYRjH8W9rbq2Fmpv9g6YIs4aYEkYE3cRY4I2XClERQhoFspsuHDKiwPLSunBEdBNB0K1XLsKIcGsrW0StkqbicmdnHJd05rG5Cgppgx23HfGm3+X7vHweXp6X99WzhdH/t/g2qhs6qW46i8lqRW/cQTYjIy/OkXo7RlaOaMMtR5zUNI7QdrmVg04DurytWRk+Pe4h+uAl4ut+lPRs+fjeDjf27kE6ru4pWq8yQ8uFWg6fOc3TSxPEn/eRnpksjVtbunCc89A+UE+pbDeA676did67pBdcoMxthBuoax0uC86P02dnOeZjYbJTHbe0uzlxzVERvH4Cx/ljCKG2/CEX4rUNLnYf0qElzd0WImN9JENXiuPmA/s0wetD3rXfRvLfUiGuN+7UjP9tYC7gCoq5rLIpPKco6viKKGmGf66BnBTV8W+xMCviSUyV3cQ/mX+SQfrwUB0XQjcIXO/i1J2mivE3oxFWJb86DhKJqXvM+4ewucofbuhWnFR0EPi1EQ7Cq5sEvHagp6wG06MJoo9G+D77rLyH62uglxeeGb6MX+T4UGPRGSx9zDHlfY847WHp83hlT64QHkYI+1gMeqmxHcVUX4euysjaagY5nmA55if17jbwQ+tnISEE3QjBEtu04ZvKluK/AeDRoWO65le/AAAAAElFTkSuQmCC","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0},"value":"5","label":"Upgraded LED Light"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,252,182,255],"toColor":[194,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,182,252,255],"toColor":[242,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,200,179,255],"toColor":[252,200,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,229,252,255],"toColor":[179,229,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[251,252,215,255],"toColor":[251,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,193,252,255],"toColor":[187,193,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,235,255],"toColor":[182,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,212,255],"toColor":[252,189,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,210,252,255],"toColor":[240,210,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,182,255],"toColor":[244,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,216,255],"toColor":[252,215,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,222,179,255],"toColor":[252,222,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,213,255],"toColor":[212,252,213,255]}]}}},"scaleSymbols":false,"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:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
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)
COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
INSTALLATIONDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PHASEDESIGNATION (type: esriFieldTypeInteger, alias: Phase Designation, SQL Type: sqlTypeOther, 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 ...)
LIGHTCOUNT (type: esriFieldTypeInteger, alias: Light Count, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [6: 6], ... 2 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 ...)
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 ...)
WATTAGE (type: esriFieldTypeDouble, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [100: 100 Watts], [175: 175 Watts], [250: 250 Watts], ... 11 more ...)
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: REPLACEDBY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [2: Brett Pefferkorn], [3: Shaun Morein], [4: Ashton Whaley], ... 18 more ...)
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: [1: Replaced - Same Wattage], [2: Replaced - Different Wattage])
WIREREPLACESTATUS (type: esriFieldTypeString, alias: WIREREPLACESTATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Wood Pole: Wood Pole], [21': 21' Pole], [25': 25' Pole], ... 3 more ...)
FUSEREPLACESTATUS (type: esriFieldTypeString, alias: FUSEREPLACESTATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: No Fuse], [2: 120V Regular Fuse], [3: 240V Regular Fuse], ... 2 more ...)
WATTAGEDISCREPANCY (type: esriFieldTypeSmallInteger, alias: WATTAGEDISCREPANCY, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [150: 150], [250: 250], [400: 400])
LIGHTCHANGEDTOLED (type: esriFieldTypeString, alias: LIGHTCHANGEDTOLED, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
LIGHTCHANGEDTOLED_INSPDATE (type: esriFieldTypeDate, alias: LIGHTCHANGEDTOLED_INSPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LIGHTCORRECTSIZE (type: esriFieldTypeString, alias: LIGHTCORRECTSIZE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
LIGHTCORRECTSIZE_INSPDATE (type: esriFieldTypeDate, alias: LIGHTCORRECTSIZE_INSPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LIGHTWIRINGCORRECT (type: esriFieldTypeString, alias: LIGHTWIRINGCORRECT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [NA: N/A])
LIGHTWIRINGCORRECT_INSPDATE (type: esriFieldTypeDate, alias: LIGHTWIRINGCORRECT_INSPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
INSPECTION_COMMENTS (type: esriFieldTypeString, alias: INSPECTION_COMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
INSPECTOR (type: esriFieldTypeString, alias: INSPECTOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Richard Breaux], [2: Rahul Anand], [3: Greg Lavergne], ... 1 more ...)
STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [IS: IN SERVICE], [REM: REMOVED])

Templates:

STATUS: IS
STREETLIGHTROLE: AL
VERIFIED: Not Verified
SUBTYPECD: 1
PHASEDESIGNATION: 4
WATTAGE: 175
HOUSESIDESHIELD: N

STREETLIGHTROLE: AL
STATUS: IS
VERIFIED: Not Verified
SUBTYPECD: 2
PHASEDESIGNATION: 4
WATTAGE: 0
HOUSESIDESHIELD: N

STATUS: IS
STREETLIGHTROLE: AL
VERIFIED: Not Verified
SUBTYPECD: 3
PHASEDESIGNATION: 4
WATTAGE: 175
HOUSESIDESHIELD: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/18/2024 1:32:42 PM

Schema Last Edit Date: 3/18/2024 1:32:42 PM

Data Last Edit Date: 3/18/2024 1:32:42 PM

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