View In:   ArcGIS Online Map Viewer

Name: Streetlight

Display Field: ancillaryrole

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Streetlight

Service Item Id: e016517ff46a47a58eda42b3b68ec5c3

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 6006503.8719320595
YMin: 2097781.5544254854
XMax: 6019213.651630551
YMax: 2123238.4474092424
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: subtypecd
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[26, 26, 26, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 2
  Label: Architctural Light
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [238, 252, 199, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 1
  Label: Streetlight
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 231, 202, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: subtypecd

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ancillaryrole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: null, modelName: AncillaryRole )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• creationuser ( type: esriFieldTypeString, alias: Creation User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CreationUser )
• datecreated ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• lastuser ( type: esriFieldTypeString, alias: Last User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastUser )
• datemodified ( type: esriFieldTypeDate, alias: Date Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• subtypecd ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• facilityid ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• feederid ( type: esriFieldTypeString, alias: Feeder ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeederID )
• feederid2 ( type: esriFieldTypeString, alias: Feeder ID 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeederID2 )
• operatingvoltage ( type: esriFieldTypeInteger, alias: Operating Voltage, editable: true, nullable: true, defaultValue: null, modelName: OperatingVoltage , Coded Values: [120: 4.16 kV Grounded Wye] , [160: 7.2 kV Grounded Wye] , [210: 12.5 kV Grounded Wye] , ...8 more... )
• constructionstatus ( type: esriFieldTypeInteger, alias: Construction Status, editable: true, nullable: true, defaultValue: 5, modelName: ConstructionStatus , Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more... )
• workorderid ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkOrderID )
• installationdate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• electrictraceweight ( type: esriFieldTypeInteger, alias: Electric Trace Weight, editable: true, nullable: true, defaultValue: null, modelName: ElectricTraceWeight )
• feederinfo ( type: esriFieldTypeInteger, alias: Feeder Information, editable: true, nullable: true, defaultValue: null, modelName: FeederInfo )
• symbolrotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: 0, modelName: SymbolRotation )
• hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• nominalvoltage ( type: esriFieldTypeInteger, alias: NominalVoltage, editable: true, nullable: true, defaultValue: null, modelName: NominalVoltage )
• phasedesignation ( type: esriFieldTypeInteger, alias: Phase Designation, editable: true, nullable: true, defaultValue: 4, modelName: PhaseDesignation , Coded Values: [4: A] , [2: B] , [1: C] )
• ballasttype ( type: esriFieldTypeString, alias: Ballast Type, editable: true, nullable: true, length: 5, defaultValue: NPF, modelName: BallastType , Coded Values: [HPF: High Power Factor] , [NPF: Normal Power Factor] )
• fixturesupport ( type: esriFieldTypeString, alias: Fixture Support, editable: true, nullable: true, length: 5, defaultValue: SEC, modelName: FixtureSupport , Coded Values: [COB: Cobra] , [SEC: Security] , [OTH: Other] )
• lamptype ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LampType , Coded Values: [FLUO: Fluorescent] , [HPS: High Pressure Sodium] , [INC: Incandescent] , ...3 more... )
• lenstype ( type: esriFieldTypeString, alias: Lens Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LensType , Coded Values: [DIF: Diffuser] , [RFL: Reflector] , [RFR: Refractor] )
• lightcount ( type: esriFieldTypeInteger, alias: Light Count, editable: true, nullable: true, defaultValue: null, modelName: LightCount , Range: [1, 4] )
• lightstyle ( type: esriFieldTypeString, alias: Light Style, editable: true, nullable: true, length: 5, defaultValue: STD, modelName: LightStyle , Coded Values: [ORL: Ornamental Light] , [STD: Standard] )
• mountheight ( type: esriFieldTypeSmallInteger, alias: Mount Height, editable: true, nullable: true, defaultValue: null, modelName: MountHeight )
• ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 5, defaultValue: UTIL, modelName: Ownership , Coded Values: [CUST: Customer] , [OTH: Other] , [PORT: Port of San Francisco] , ...3 more... )
• photocelltype ( type: esriFieldTypeString, alias: Photocell Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PhotocellType , Coded Values: [BUT: Button] , [NTL: Nema Twist Lock] , [NONE: None] )
• shielding ( type: esriFieldTypeString, alias: Shielding Indicator, editable: true, nullable: true, length: 5, defaultValue: Y, modelName: Shielding , Coded Values: [N: No] , [Y: Yes] )
• streetlightrole ( type: esriFieldTypeString, alias: Streetlight Role, editable: true, nullable: true, length: 5, defaultValue: AL, modelName: StreetLightRole , Coded Values: [AL: Area Light] , [COM: Commercial Area Lighting] , [FPL: Family Protective Light] , ...5 more... )
• timecontrol ( type: esriFieldTypeString, alias: Time Control Indicator, editable: true, nullable: true, length: 5, defaultValue: N, modelName: TimeControl , Coded Values: [N: No] , [Y: Yes] )
• wattage ( type: esriFieldTypeDouble, alias: Wattage, editable: true, nullable: true, defaultValue: 175, modelName: Wattage , Coded Values: [100: 100 W] , [175: 175 W] , [250: 250 W] , ...1 more... )
• supportstructureobjectid ( type: esriFieldTypeInteger, alias: SupportStructureObjectID, editable: true, nullable: true, defaultValue: null, modelName: SupportStructureObjectID )
• hframeobjectid ( type: esriFieldTypeInteger, alias: HFrameObjectID, editable: true, nullable: true, defaultValue: null, modelName: HFrameObjectID )
• constructiontype ( type: esriFieldTypeString, alias: constructiontype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONSTRUCTIONTYPE )
• ownercontact ( type: esriFieldTypeString, alias: Owner Contact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ownercontact )

Types:

ID: 2
Name: Architctural Light
Domains:
• enabled:
  Inherited
• operatingvoltage:
  Inherited
• constructionstatus:
  Inherited
• phasedesignation:
  Inherited
• ballasttype:
  Inherited
• fixturesupport:
  Inherited
• lamptype:
  Inherited
• lenstype:
  Inherited
• lightcount:
  Inherited
• lightstyle:
  Inherited
• ownership:
  Inherited
• photocelltype:
  Inherited
• shielding:
  Inherited
• streetlightrole:
  Inherited
• timecontrol:
  Inherited
• wattage:
  Inherited
Templates:
• Name: Architctural Light
  Description:
  Prototype:
  constructiontype: null
  ownercontact: null
  ancillaryrole: null
  enabled: 1
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  subtypecd: 2
  facilityid: null
  feederid: null
  feederid2: null
  operatingvoltage: null
  constructionstatus: 5
  workorderid: null
  installationdate: null
  comments: null
  electrictraceweight: null
  feederinfo: null
  symbolrotation: 0
  hyperlink: null
  nominalvoltage: null
  phasedesignation: 4
  ballasttype: NPF
  fixturesupport: SEC
  lamptype: null
  lenstype: null
  lightcount: null
  lightstyle: STD
  mountheight: null
  ownership: UTIL
  photocelltype: null
  shielding: Y
  streetlightrole: AL
  timecontrol: N
  wattage: 175
  supportstructureobjectid: null
  hframeobjectid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Streetlight
Domains:
• enabled:
  Inherited
• operatingvoltage:
  Inherited
• constructionstatus:
  Inherited
• phasedesignation:
  Inherited
• ballasttype:
  Inherited
• fixturesupport:
  Inherited
• lamptype:
  Inherited
• lenstype:
  Inherited
• lightcount:
  Inherited
• lightstyle:
  Inherited
• ownership:
  Inherited
• photocelltype:
  Inherited
• shielding:
  Inherited
• streetlightrole:
  Inherited
• timecontrol:
  Inherited
• wattage:
  Inherited
Templates:
• Name: Streetlight
  Description:
  Prototype:
  constructiontype: null
  ownercontact: null
  ancillaryrole: null
  enabled: 1
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  subtypecd: 1
  facilityid: null
  feederid: null
  feederid2: null
  operatingvoltage: null
  constructionstatus: 5
  workorderid: null
  installationdate: null
  comments: null
  electrictraceweight: null
  feederinfo: null
  symbolrotation: 0
  hyperlink: null
  nominalvoltage: null
  phasedesignation: 4
  ballasttype: NPF
  fixturesupport: SEC
  lamptype: null
  lenstype: null
  lightcount: null
  lightstyle: STD
  mountheight: null
  ownership: UTIL
  photocelltype: null
  shielding: Y
  streetlightrole: AL
  timecontrol: N
  wattage: 175
  supportstructureobjectid: null
  hframeobjectid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata