View In:   ArcGIS Online Map Viewer

Name: Street Lights

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Street Lights

Service Item Id: 791441651b5946b680f93d72349c9a3a

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: 6620717.343008131
YMin: 1956835.0935372263
XMax: 6654236.015143886
YMax: 1971485.8089863956
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LTG_LIB_CD
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 1
  Label: Street Light
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Pathway
  Description: N/A
  Symbol:
  
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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: LTG_LIB_CD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Alt ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ATTACHID ( type: esriFieldTypeString, alias: Attachment ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ATTACHID )
• LIGHTTYPE ( type: esriFieldTypeString, alias: Ballast Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIGHTTYPE , Coded Values: [4: Mag-Reg] , [3: Reactor or Lag] , [2: Mag-Reg/Grounded Shell] , ...1 more... )
• BULBTYPE ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BULBTYPE , Coded Values: [FLUO: Fluorescent] , [HPS: High Pressure Sodium] , [INC: Incandescent] , ...6 more... )
• WATTAGE ( type: esriFieldTypeString, alias: Watts, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WATTAGE , Coded Values: [87: 87 WATTS] , [63: 63 WATTS] , [55: 55 WATTS] , ...7 more... )
• DISTTOTOP ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: DISTTOTOP )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• CONDITION ( type: esriFieldTypeString, alias: Overall Cond, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [0: N/A] , [4: Poor] , [3: Fair] , ...2 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owner, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [3: LS1] , [2: LS2-C] , [1: LS2-A] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [2: Water Division] , [1: WWTP] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LucityAutoID ( type: esriFieldTypeInteger, alias: Link to Lucity, editable: true, nullable: true, defaultValue: null, modelName: LucityAutoID )
• InLucity ( type: esriFieldTypeSmallInteger, alias: In Lucity?, editable: true, nullable: true, defaultValue: 0, modelName: InLucity )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• POLEID ( type: esriFieldTypeInteger, alias: Alt Pole ID, editable: true, nullable: true, defaultValue: null, modelName: POLEID )
• LTG_LIB_CD ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LTG_LIB_CD , Coded Values: [1: Street Light] , [2: Pathway] )
• INTERSECTID ( type: esriFieldTypeInteger, alias: INTERSECTID, editable: true, nullable: true, defaultValue: null, modelName: INTERSECTID )
• LTG_USER1CD ( type: esriFieldTypeInteger, alias: Park Name, editable: true, nullable: true, defaultValue: null, modelName: LTG_USER1CD , Coded Values: [4: Redwood Park] , [261: Sycamore Park] , [260: Village Park] , ...29 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LTG_SN_ID ( type: esriFieldTypeInteger, alias: Segment ID, editable: true, nullable: true, defaultValue: null, modelName: LTG_SN_ID )
• LTG_LAMPOTH ( type: esriFieldTypeString, alias: Lamp Other, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LTG_LAMPOTH )
• BADGENUM ( type: esriFieldTypeString, alias: BADGENUM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BADGENUM )
• BADGENUM_Lucity ( type: esriFieldTypeString, alias: BADGENUM_Lucity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BADGENUM_Lucity )
• FX_CODE ( type: esriFieldTypeDouble, alias: FX_CODE, editable: true, nullable: true, defaultValue: null, modelName: FX_CODE )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STATUS )
• REC_DATE ( type: esriFieldTypeDate, alias: REC_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REC_DATE )
• RET_DATE ( type: esriFieldTypeDate, alias: RET_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RET_DATE )
• INS_DATE ( type: esriFieldTypeDate, alias: INS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INS_DATE )
• REM_DATE ( type: esriFieldTypeDate, alias: REM_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REM_DATE )
• COP_DATE ( type: esriFieldTypeDouble, alias: COP_DATE, editable: true, nullable: true, defaultValue: null, modelName: COP_DATE )
• DESC_ADDR ( type: esriFieldTypeString, alias: DESC_ADDR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESC_ADDR )
• MAPNUMBER ( type: esriFieldTypeString, alias: MAPNUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAPNUMBER )
• RATE_SCHED ( type: esriFieldTypeString, alias: RATE_SCHED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RATE_SCHED )
• ITEM_CODE ( type: esriFieldTypeString, alias: ITEM_CODE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ITEM_CODE )
• LAMP_SIZE ( type: esriFieldTypeString, alias: LAMP SIZE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAMP_SIZE )
• POLE_TYPE ( type: esriFieldTypeString, alias: POLE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POLE_TYPE )
• POLE_LGTH ( type: esriFieldTypeString, alias: POLE_LGTH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POLE_LGTH )
• SUSPENSION ( type: esriFieldTypeString, alias: SUSPENSION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUSPENSION )
• POLE_USE ( type: esriFieldTypeString, alias: POLE_USE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POLE_USE )
• GPS ( type: esriFieldTypeSmallInteger, alias: GPS Flag, editable: true, nullable: true, defaultValue: 0, modelName: GPS , Coded Values: [0: No] , [1: Yes] )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )

Types:

ID: 1
Name: Street Light
Domains:
• LIGHTTYPE:
  Inherited
• BULBTYPE:
  Inherited
• WATTAGE:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• LTG_LIB_CD:
  Inherited
• LTG_USER1CD:
  Inherited
• GPS:
  Inherited
Templates:
• Name: Street Light
  Description:
  Prototype:
  POLEID: null
  LucityAutoID: null
  GPS: 0
  FACILITYID: null
  ATTACHID: null
  LIGHTTYPE: null
  BULBTYPE: null
  WATTAGE: null
  DISTTOTOP: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  InLucity: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  LTG_LIB_CD: 1
  INTERSECTID: null
  LTG_USER1CD: null
  POLE_USE: null
  SUSPENSION: null
  POLE_LGTH: null
  POLE_TYPE: null
  Notes: null
  LTG_SN_ID: null
  LTG_LAMPOTH: null
  BADGENUM: null
  BADGENUM_Lucity: null
  FX_CODE: null
  STATUS: null
  REC_DATE: null
  RET_DATE: null
  INS_DATE: null
  REM_DATE: null
  COP_DATE: null
  DESC_ADDR: null
  MAPNUMBER: null
  RATE_SCHED: null
  ITEM_CODE: null
  LAMP_SIZE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Pathway
Domains:
• LIGHTTYPE:
  Inherited
• BULBTYPE:
  Inherited
• WATTAGE:
  Inherited
• CONDITION:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• LTG_LIB_CD:
  Inherited
• LTG_USER1CD:
  Inherited
• GPS:
  Inherited
Templates:
• Name: Pathway
  Description:
  Prototype:
  POLEID: null
  LucityAutoID: null
  GPS: 0
  FACILITYID: null
  ATTACHID: null
  LIGHTTYPE: null
  BULBTYPE: null
  WATTAGE: null
  DISTTOTOP: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  InLucity: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  LTG_LIB_CD: 2
  INTERSECTID: null
  LTG_USER1CD: null
  POLE_USE: null
  SUSPENSION: null
  POLE_LGTH: null
  POLE_TYPE: null
  Notes: null
  LTG_SN_ID: null
  LTG_LAMPOTH: null
  BADGENUM: null
  BADGENUM_Lucity: null
  FX_CODE: null
  STATUS: null
  REC_DATE: null
  RET_DATE: null
  INS_DATE: null
  REM_DATE: null
  COP_DATE: null
  DESC_ADDR: null
  MAPNUMBER: null
  RATE_SCHED: null
  ITEM_CODE: null
  LAMP_SIZE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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   Update Metadata