Layers:

Layer: Status (0)

Name: Status

Display Field: Address

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a0f837afe04b45bcb57254d089f416d6

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

Supports Datum Transformation: true

Extent:
XMin: 1608849.7411525548
YMin: 1099001.875161305
XMax: 1665845.1228964627
YMax: 1155510.6581408978
Spatial Reference: 102733  (102733)  VCSWkid(5703)  LatestVCSWkid(5703)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Closed
  Label: Closed
  Description:
  Symbol:
  
• Value: Open
  Label: Open
  Description:
  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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address )
• Light_ID ( type: esriFieldTypeString, alias: Light ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Light_ID )
• Light_Type ( type: esriFieldTypeString, alias: Light Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Light_Type , Coded Values: [Street: Street Light] , [Rental: Rental Light] )
• Problem_Type ( type: esriFieldTypeString, alias: Problem Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Problem_Type , Coded Values: [Light Out: Light Out] , [Continuously On: Continuously On] , [Cycling On and Off: Cycling On and Off] , ...2 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Comments )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Name )
• Email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Email )
• 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 )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Open, modelName: Status , Coded Values: [Open: Open] , [Closed: Closed] )
• Point_X ( type: esriFieldTypeDouble, alias: Point X, editable: true, nullable: true, defaultValue: null, modelName: Point_X )
• Point_Y ( type: esriFieldTypeDouble, alias: Point Y, editable: true, nullable: true, defaultValue: null, modelName: Point_Y )
• ServiceID ( type: esriFieldTypeInteger, alias: ServiceID, editable: true, nullable: true, defaultValue: null, modelName: ServiceID )
• LocationDesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LocationDesc )
• Sensitive_Info ( type: esriFieldTypeString, alias: Sensitive Information, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sensitive_Info )
Types:
ID: Closed
Name: Closed
Domains:
• Light_Type:
  Inherited
• Problem_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: Closed
  Description:
  Prototype:
  LocationDesc: null
  ServiceID: null
  Address: null
  Light_ID: null
  Light_Type: null
  Problem_Type: null
  Comments: null
  Name:
  Email:
  Point_Y: null
  Point_X: null
  Status: Closed
  Sensitive_Info: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open
Name: Open
Domains:
• Light_Type:
  Inherited
• Problem_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: Open
  Description:
  Prototype:
  LocationDesc: null
  ServiceID: null
  Address: null
  Light_ID: null
  Light_Type: null
  Problem_Type: null
  Comments: null
  Name:
  Email:
  Point_Y: null
  Point_X: null
  Status: Open
  Sensitive_Info: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:
• LGIM.DBO.Report_Light_Problem_Table (0) -- Related To: Light Problem Table (3)

Layer: Report Light Problem (1)

Name: Report Light Problem

Display Field: Address

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a0f837afe04b45bcb57254d089f416d6

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

Supports Datum Transformation: true

Extent:
XMin: 1608849.7411525548
YMin: 1099001.875161305
XMax: 1665845.1228964627
YMax: 1155510.6581408978
Spatial Reference: 102733  (102733)  VCSWkid(5703)  LatestVCSWkid(5703)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address )
• Light_ID ( type: esriFieldTypeString, alias: Light ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Light_ID )
• Light_Type ( type: esriFieldTypeString, alias: Light Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Light_Type , Coded Values: [Street: Street Light] , [Rental: Rental Light] )
• Problem_Type ( type: esriFieldTypeString, alias: Problem Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Problem_Type , Coded Values: [Light Out: Light Out] , [Continuously On: Continuously On] , [Cycling On and Off: Cycling On and Off] , ...2 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Comments )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Name )
• Email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Email )
• 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 )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Open, modelName: Status , Coded Values: [Open: Open] , [Closed: Closed] )
• Point_X ( type: esriFieldTypeDouble, alias: Point X, editable: true, nullable: true, defaultValue: null, modelName: Point_X )
• Point_Y ( type: esriFieldTypeDouble, alias: Point Y, editable: true, nullable: true, defaultValue: null, modelName: Point_Y )
• ServiceID ( type: esriFieldTypeInteger, alias: ServiceID, editable: true, nullable: true, defaultValue: null, modelName: ServiceID )
• LocationDesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LocationDesc )
• Sensitive_Info ( type: esriFieldTypeString, alias: Sensitive Information, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sensitive_Info )
Templates:
• Name: Report Light Problem
  Description:
  Prototype:
  LocationDesc: null
  ServiceID: null
  Address: null
  Light_ID: null
  Light_Type: null
  Problem_Type: null
  Comments: null
  Name:
  Email:
  Point_Y: null
  Point_X: null
  Status: Open
  Sensitive_Info: null
  
  Drawing Tool: esriFeatureEditToolPoint
Relationships:
• LGIM.DBO.Report_Light_Problem_Table (0) -- Related To: Light Problem Table (3)

Layer: Light (2)

Name: Light

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a0f837afe04b45bcb57254d089f416d6

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 20000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:
XMin: 1606425.7319095707
YMin: 1097989.3704352316
XMax: 1656067.5263464474
YMax: 1209386.951599121
Spatial Reference: 102733  (102733)  VCSWkid(5703)  LatestVCSWkid(5703)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Time Info:
Start Time Field: last_edited_date
End Time Field: null
Track ID Field: null
Time Extent:
[2022/06/03 17:30:17 UTC, 2022/06/06 11:40:27 UTC]

Time Reference:
Time Zone: UTC
Respects Daylight Saving: false

Time Interval: 4
Time Interval Units: esriTimeUnitsHours
Has Live Data: false
Export Options:
Use Time: true
Time Data Cumulative: false
Time Offset: null (null)

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LCLASS ( type: esriFieldTypeString, alias: LCLASS, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LCLASS )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LOCATION )
• BULB_SIZE ( type: esriFieldTypeInteger, alias: BULB_SIZE, editable: true, nullable: true, defaultValue: null, modelName: BULB_SIZE )
• LTYPE ( type: esriFieldTypeString, alias: LTYPE, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LTYPE , Coded Values: [SM FLOOD: SMALL FLOOD] , [SM DEC: SMALL DECORATIVE] , [SM COBRA: SMALL COBRA] , ...12 more... )
• InstallationDate ( type: esriFieldTypeDate, alias: INSTALDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALDATE )
• FIELDCHECK ( type: esriFieldTypeDate, alias: FIELDCHECK, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIELDCHECK )
• DiscontinueDate ( type: esriFieldTypeDate, alias: Discontinue Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DISCONDATE )
• LocationAddress ( type: esriFieldTypeString, alias: Location Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCADDRESS )
• ACCT7 ( type: esriFieldTypeString, alias: ACCT7, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ACCT7 )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NAME )
• ADDRESS1 ( type: esriFieldTypeString, alias: ADDRESS1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS1 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS2 )
• ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS3 )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 17, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 9, defaultValue: null, modelName: ZIP )
• TELEPHONE ( type: esriFieldTypeString, alias: TELEPHONE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TELEPHONE )
• LIGHTSTAT ( type: esriFieldTypeString, alias: LIGHTSTAT, editable: true, nullable: true, length: 6, defaultValue: null, modelName: LIGHTSTAT , Coded Values: [ON: ON] , [CAHB: Cut At Hand Box] , [CAMB: Cut At Meter Base] , ...5 more... )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 17, defaultValue: null, modelName: FACILITYID )
• Metered ( type: esriFieldTypeString, alias: Metered, editable: true, nullable: true, length: 1, defaultValue: N, modelName: Metered )
• BULB_TYPE ( type: esriFieldTypeString, alias: BULB_TYPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BULB_TYPE , Coded Values: [HPS: HPS] , [LED: LED] , [MH: MH] , ...1 more... )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 60, defaultValue: null, modelName: WORKORDERID )
• LocDesc ( type: esriFieldTypeString, alias: LocDesc, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LocDesc )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Status, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: Open] , [1: Closed] )
• 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 )
• pc_problem ( type: esriFieldTypeString, alias: pc_problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pc_problem )
• network_problem ( type: esriFieldTypeString, alias: network_problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: network_problem )
• INSPECTIONID ( type: esriFieldTypeString, alias: INSPECTIONID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTIONID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• mPowerID ( type: esriFieldTypeString, alias: mPowerID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: mPowerID )
• mPowerParentID ( type: esriFieldTypeString, alias: mPowerPArentID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: mPowerParentID )
• LocationStatus ( type: esriFieldTypeString, alias: LocationStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationStatus , Coded Values: [ASB: As Built] , [EST: Estimated] , [GPS: GPS Located] , ...3 more... )
Templates:
• Name: R
  Description:
  Prototype:
  mPowerParentID: null
  FACILITYID: null
  LCLASS: R
  LOCATION: null
  BULB_SIZE: null
  LTYPE: null
  InstallationDate: null
  FIELDCHECK: null
  DiscontinueDate: null
  LocationAddress: null
  ACCT7: null
  NAME: null
  ADDRESS1: null
  ADDRESS2: null
  ADDRESS3: null
  CITY: null
  STATE: null
  ZIP: null
  TELEPHONE: null
  LIGHTSTAT: null
  Metered: N
  BULB_TYPE: null
  WORKORDERID: null
  LocDesc: null
  Enabled: null
  mPowerID: null
  LocationStatus: null
  INSPECTIONID: null
  network_problem: null
  pc_problem: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: S
  Description:
  Prototype:
  mPowerParentID: null
  FACILITYID: null
  LCLASS: S
  LOCATION: null
  BULB_SIZE: null
  LTYPE: null
  InstallationDate: null
  FIELDCHECK: null
  DiscontinueDate: null
  LocationAddress: null
  ACCT7: null
  NAME: null
  ADDRESS1: null
  ADDRESS2: null
  ADDRESS3: null
  CITY: null
  STATE: null
  ZIP: null
  TELEPHONE: null
  LIGHTSTAT: null
  Metered: N
  BULB_TYPE: null
  WORKORDERID: null
  LocDesc: null
  Enabled: null
  mPowerID: null
  LocationStatus: null
  INSPECTIONID: null
  network_problem: null
  pc_problem: null
  
  Drawing Tool: esriFeatureEditToolPoint

Tables:

Table: Light Problem Table (3)

Name: Light Problem Table

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a0f837afe04b45bcb57254d089f416d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:
N/A
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ReportID ( type: esriFieldTypeGUID, alias: ReportID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ReportID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Light Problem Table
  Description:
  Prototype:
  ReportID: null
  
  Drawing Tool: esriFeatureEditToolNone
Relationships:
• LGIM.DBO.Report_Light_Problem (0) -- Related To: Status (0)