View In:   ArcGIS Online Map Viewer

Name: Streetlight

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 389893.57730213087
YMin: 126438.14597123623
XMax: 407844.1572568812
YMax: 147488.5820497732
Spatial Reference: 26985  (26985)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• STREETLIGHTID ( type: esriFieldTypeString, alias: Streetlight ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: STREETLIGHTID )
• PEPCOLIGHTID ( type: esriFieldTypeString, alias: PEPCOLIGHTID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PEPCOLIGHTID )
• ASSETSTATUS ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 30, defaultValue: Active, modelName: ASSETSTATUS , Coded Values: [Active: Active] , [Inactive: Inactive] , [Leased To: Leased To] , ...1 more... )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type, editable: true, nullable: true, defaultValue: 1, modelName: ASSETTYPE )
• LIGHTTYPE ( type: esriFieldTypeSmallInteger, alias: Light Type, editable: true, nullable: true, defaultValue: null, modelName: LIGHTTYPE , Coded Values: [6: LED-Light Emitting Diode] , [1: HPS-High Pressure Sodium] , [3: INC-Incandescent] , ...3 more... )
• WATTAGE1 ( type: esriFieldTypeString, alias: Wattage 1, editable: true, nullable: true, length: 4, defaultValue: null, modelName: WATTAGE , Coded Values: [10: 10] , [100: 100] , [1000: 1000] , ...33 more... )
• WATTAGE2 ( type: esriFieldTypeString, alias: Wattage 2, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WATTAGE2 , Coded Values: [10: 10] , [100: 100] , [1000: 1000] , ...33 more... )
• POLECOMPOSITION ( type: esriFieldTypeString, alias: Pole Composition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: POLETYPE , Coded Values: [Aluminum: Aluminum] , [Cast Iron: Cast Iron] , [Composite: Composite] , ...7 more... )
• POLETYPE ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POLESTYLE , Coded Values: [16St Triple: 16St Triple] , [3A: 3A] , [3A-Ext: 3A-Ext] , ...25 more... )
• POLEHEIGHT ( type: esriFieldTypeString, alias: Pole Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POLEHEIGHT , Coded Values: [10: 10 ft] , [100: 100 ft] , [13: 13 ft] , ...23 more... )
• TBASETYPE ( type: esriFieldTypeString, alias: T-Base Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BASETYPE , Coded Values: [Breakaway: Breakaway] , [DB: DB] , [Direct Anchored: Direct Anchored] , ...4 more... )
• NUMBERARMS ( type: esriFieldTypeSmallInteger, alias: Number of Arms, editable: true, nullable: true, defaultValue: null, modelName: NUMBERARMS , Coded Values: [1: 1] , [2: 2] , [5: 5] , ...6 more... )
• ARMLENGTH1 ( type: esriFieldTypeSmallInteger, alias: Arm Length 1, editable: true, nullable: true, defaultValue: null, modelName: ARMLENGTH , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...9 more... )
• ARMLENGTH2 ( type: esriFieldTypeSmallInteger, alias: Arm Length 2, editable: true, nullable: true, defaultValue: null, modelName: ARMLENGTH2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...9 more... )
• ARMSTYLE ( type: esriFieldTypeString, alias: Arm Style, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ARMSTYLE , Coded Values: [Decorated Straight: Decorated Straight] , [Decorated Truss Wrap: Decorated Truss Wrap] , [Decorated Wrap: Decorated Wrap] , ...16 more... )
• NUMBERLIGHTS ( type: esriFieldTypeSmallInteger, alias: Number of Lights, editable: true, nullable: true, defaultValue: null, modelName: NUMBERFIXTURES )
• FIXTURESTYLE ( type: esriFieldTypeSmallInteger, alias: Fixture Style, editable: true, nullable: true, defaultValue: null, modelName: FIXTURE , Coded Values: [1: Cobrahead Cutoff] , [2: Cobrahead Semi Cutoff] , [3: Posttop] , ...18 more... )
• PROXIMITY ( type: esriFieldTypeSmallInteger, alias: Proximity, editable: true, nullable: true, defaultValue: null, modelName: PROXIMITY , Coded Values: [1: Front] , [2: Rear] , [3: Opposite] , ...34 more... )
• HOUSENO ( type: esriFieldTypeString, alias: House No, editable: true, nullable: true, length: 12, defaultValue: null, modelName: HOUSENO )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: STREETNAME )
• CROSSSTREET ( type: esriFieldTypeString, alias: Cross Street, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CROSSSTREET )
• QUADRANT ( type: esriFieldTypeSmallInteger, alias: Quadrant, editable: true, nullable: true, defaultValue: null, modelName: QUADRANT , Coded Values: [1: NW] , [2: NE] , [3: SE] , ...3 more... )
• OWNER ( type: esriFieldTypeSmallInteger, alias: Owner, editable: true, nullable: true, defaultValue: null, modelName: OWNER , Coded Values: [0: Unknown] , [1: DDOT] , [11: PEPCO] , ...2 more... )
• WARD ( type: esriFieldTypeSmallInteger, alias: Ward, editable: true, nullable: true, defaultValue: null, modelName: WARD , Coded Values: [0: Unknown] , [1: 1] , [2: 2] , ...6 more... )
• TRAFFICCOMBO ( type: esriFieldTypeString, alias: Traffic Combo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TRAFFICCOMBO , Coded Values: [YES: YES] , [NO: NO] )
• OTHEREQUIPMENT ( type: esriFieldTypeString, alias: Other Equipment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OTHEREQUIPMENT , Coded Values: [YES: YES] , [NO: NO] )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: CONDITION , Coded Values: [1: Need Immediate Replacement] , [2: Replace Within a Year] , [3: Need Inspection in 2 years] , ...1 more... )
• ISMODIFIED ( type: esriFieldTypeString, alias: Is Modified, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ISMODIFIED , Coded Values: [YES: YES] , [NO: NO] )
• LASTMODIFIED ( type: esriFieldTypeDate, alias: Last Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTMODIFIED )
• WHATMODIFIED ( type: esriFieldTypeString, alias: What Modified, editable: true, nullable: true, length: 100, defaultValue: null, modelName: WHATMODIFIED )
• INOPERATION ( type: esriFieldTypeDate, alias: In Operation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INOPERATION )
• ADDTOGIS ( type: esriFieldTypeDate, alias: Add to GIS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADDTOGIS )
• ADDEDBY ( type: esriFieldTypeString, alias: Added By, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ADDEDBY )
• LEDINOPERATION ( type: esriFieldTypeDate, alias: LED in Operation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LEDINOPERATION )
• CCT ( type: esriFieldTypeString, alias: Correlated Color Temperature, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CCT , Coded Values: [1000: 1000] , [2000: 2000] , [2500: 2500] , ...6 more... )
• LIGHTMANUFACTURER ( type: esriFieldTypeString, alias: Light Manufacturer, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LIGHTMANUFACTURER , Coded Values: [Acuity: Acuity] , [Cree: Cree] , [General Electric: General Electric] , ...13 more... )
• LASTPAINTED ( type: esriFieldTypeDate, alias: Last Painted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTPAINTED )
• POLECOLOR ( type: esriFieldTypeString, alias: Pole Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: POLECOLOR , Coded Values: [Black: Black] , [Gray: Gray] , [Red: Red] , ...2 more... )
• STREETSEGMID ( type: esriFieldTypeInteger, alias: StreetSegID, editable: true, nullable: true, defaultValue: null, modelName: STREETSEGMID )
• ROADCLASSIFICATION ( type: esriFieldTypeInteger, alias: Road Classification, editable: true, nullable: true, defaultValue: null, modelName: ROADCLASSIFICATION , Coded Values: [11: Interstate] , [12: Other Freeway and Expressway] , [14: Principal Arterial] , ...3 more... )
• SHIELD ( type: esriFieldTypeString, alias: Shield, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SHIELD , Coded Values: [Internal 180: Internal 180] , [Internal 360: Internal 360] , [Internal 90: Internal 90] , ...10 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• POLEMANUFACTURER ( type: esriFieldTypeString, alias: Pole Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLEMANUFACTURER , Coded Values: [Gray Bar: Gray Bar] , [Miller Metal: Miller Metal] , [Miller Metal/Traffic Systems Technologies: Miller Metal/Traffic Systems Technologies] , ...9 more... )
• FEEDMANHOLEID ( type: esriFieldTypeString, alias: Feed Manhole ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FEEDMANHOLEID )
• ROUTEID ( type: esriFieldTypeString, alias: RouteID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROUTEID )
• MEASURE ( type: esriFieldTypeDouble, alias: Measure, editable: true, nullable: true, defaultValue: null, modelName: MEASURE )
• SUBBLOCKKEY ( type: esriFieldTypeString, alias: SubBlockKey, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBBLOCKKEY )
• SIDE ( type: esriFieldTypeString, alias: Side, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIDE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Streetlight
  Description:
  Prototype:
  ASSETSTATUS: null
  SIDE: null
  FACILITYID: null
  STREETLIGHTID: null
  PEPCOLIGHTID: null
  ASSETTYPE: 1
  LIGHTTYPE: null
  WATTAGE1: null
  WATTAGE2: null
  POLECOMPOSITION: null
  POLETYPE: null
  POLEHEIGHT: null
  TBASETYPE: null
  NUMBERARMS: null
  ARMLENGTH1: null
  ARMLENGTH2: null
  ARMSTYLE: null
  NUMBERLIGHTS: null
  FIXTURESTYLE: null
  PROXIMITY: null
  HOUSENO: null
  STREETNAME: null
  CROSSSTREET: null
  QUADRANT: 0
  OWNER: 1
  WARD: 0
  TRAFFICCOMBO: null
  OTHEREQUIPMENT: null
  CONDITION: null
  ISMODIFIED: null
  LASTMODIFIED: null
  WHATMODIFIED: null
  INOPERATION: null
  ADDTOGIS: null
  ADDEDBY: null
  LEDINOPERATION: null
  CCT: null
  LIGHTMANUFACTURER: null
  LASTPAINTED: null
  POLECOLOR: null
  STREETSEGMID: null
  ROADCLASSIFICATION: null
  SHIELD: null
  COMMENTS: null
  POLEMANUFACTURER: null
  FEEDMANHOLEID: null
  ROUTEID: null
  MEASURE: null
  SUBBLOCKKEY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• ConditionAssessment (0) -- Related To: DDOTSGIS.STREETLIGHT.ConditionAssessment (30)
• Streetlight_Equip_Misc (1) -- Related To: TOA.Streetlight_Equip_Misc (28)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATED_DATE
• Creator Field: CREATED_USER
• Edit Date Field: LASTLOGGED
• Editor Field: LOGGEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata