Name: Pending Requests

Display Field: CompletedByFirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: dbo.GIS_Requests

Service Item Id: 83c44084044243f7b1e0d9a6ec84c642

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

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: RequestType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Report a Pothole
  Label: Report a Pothole
  Description: N/A
  Symbol:
  
• Value: Report a Sidewalk Hazard
  Label: Sidewalk Hazard
  Description: N/A
  Symbol:
  
• Value: Report a Streetlight Issue (Not Traffic Signal)
  Label: Streetlight Issue
  Description: N/A
  Symbol:
  
• Value: Report Missing/Damaged Street Signs
  Label: Missing/Damaged Street Signs
  Description: N/A
  Symbol:
  
• Value: Garbage Can Requests
  Label: Garbage Can Requests
  Description: N/A
  Symbol:
  
• Value: Report a Leak on City Water System
  Label: Leak on City Water System
  Description: N/A
  Symbol:
  
• Value: Report a Water Outage
  Label: Water Outage
  Description: N/A
  Symbol:
  
• Value: Report Water Pressure/Quality Concerns
  Label: Water Pressure/Quality Concerns
  Description: N/A
  Symbol:
  
• Value: Report a Property Concern/Code Enforcement
  Label: Property Concern/Code Enforcement
  Description: N/A
  Symbol:
  
• Value: Other Request
  Label: Other Request
  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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• RequestID ( type: esriFieldTypeOID, alias: RequestID )
• RequestTypeID ( type: esriFieldTypeInteger, alias: RequestTypeID )
• RequestType ( type: esriFieldTypeString, alias: RequestType, length: 500 )
• RequestStatusID ( type: esriFieldTypeInteger, alias: RequestStatusID )
• RequestStatus ( type: esriFieldTypeString, alias: RequestStatus, length: 500 )
• DivisionID ( type: esriFieldTypeInteger, alias: DivisionID )
• Division ( type: esriFieldTypeString, alias: Division, length: 250 )
• SubmissionBy ( type: esriFieldTypeString, alias: SubmissionBy, length: 2500 )
• SubmissionByEmail ( type: esriFieldTypeString, alias: SubmissionByEmail, length: 2500 )
• Subject ( type: esriFieldTypeString, alias: Subject, length: 2500 )
• Problem ( type: esriFieldTypeString, alias: Problem, length: 1073741822 )
• Resolution ( type: esriFieldTypeString, alias: Resolution, length: 1073741822 )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, length: 8, precision: 1 )
• LastUpdated ( type: esriFieldTypeDate, alias: LastUpdated, length: 8, precision: 1 )
• Completed ( type: esriFieldTypeSmallInteger, alias: Completed )
• DateCompleted ( type: esriFieldTypeDate, alias: DateCompleted, length: 8, precision: 1 )
• CompletedByFirstName ( type: esriFieldTypeString, alias: CompletedByFirstName, length: 50 )
• CompletedByLastName ( type: esriFieldTypeString, alias: CompletedByLastName, length: 50 )
• Cancelled ( type: esriFieldTypeSmallInteger, alias: Cancelled )
• LocationNo ( type: esriFieldTypeString, alias: LocationNo, length: 50 )
• LOC_Address ( type: esriFieldTypeString, alias: LOC_Address, length: 500 )
• LOC_City ( type: esriFieldTypeString, alias: LOC_City, length: 500 )
• CustomerNo ( type: esriFieldTypeString, alias: CustomerNo, length: 50 )
• CUST_Name ( type: esriFieldTypeString, alias: CUST_Name, length: 500 )
• CUST_Phone1 ( type: esriFieldTypeString, alias: CUST_Phone1, length: 50 )
• Service ( type: esriFieldTypeString, alias: Service, length: 150 )
• MeterID ( type: esriFieldTypeString, alias: MeterID, length: 250 )
• MeterNo ( type: esriFieldTypeString, alias: MeterNo, length: 50 )
• GISAssetNo ( type: esriFieldTypeString, alias: GISAssetNo, length: 50 )
• GISFeatureLabel ( type: esriFieldTypeString, alias: GISFeatureLabel, length: 500 )
• EXSLayerID ( type: esriFieldTypeInteger, alias: EXSLayerID )
• EXSLayerName ( type: esriFieldTypeString, alias: EXSLayerName, length: 250 )
• AssetNo ( type: esriFieldTypeInteger, alias: AssetNo )
• ASSET_AssetTag ( type: esriFieldTypeString, alias: ASSET_AssetTag, length: 500 )
• FacilityID ( type: esriFieldTypeInteger, alias: FacilityID )
• Facility ( type: esriFieldTypeString, alias: Facility, length: 250 )
• Facility_Full_Location ( type: esriFieldTypeString, alias: Facility_Full_Location, length: 1073741822 )
• BillableLaborHoursTotal ( type: esriFieldTypeDouble, alias: BillableLaborHoursTotal )
• BillableLaborTotal ( type: esriFieldTypeDouble, alias: BillableLaborTotal )
• NonBillableLaborHoursTotal ( type: esriFieldTypeDouble, alias: NonBillableLaborHoursTotal )
• NonBillableLaborTotal ( type: esriFieldTypeDouble, alias: NonBillableLaborTotal )
• LaborHoursTotal ( type: esriFieldTypeDouble, alias: LaborHoursTotal )
• LaborTotal ( type: esriFieldTypeDouble, alias: LaborTotal )
• LaborCostTotal ( type: esriFieldTypeDouble, alias: LaborCostTotal )
• BillableInventoryTotal ( type: esriFieldTypeDouble, alias: BillableInventoryTotal )
• NonBillableInventoryTotal ( type: esriFieldTypeDouble, alias: NonBillableInventoryTotal )
• InventoryTotal ( type: esriFieldTypeDouble, alias: InventoryTotal )
• InventoryCostTotal ( type: esriFieldTypeDouble, alias: InventoryCostTotal )
• BillableContractorTotal ( type: esriFieldTypeDouble, alias: BillableContractorTotal )
• NonBillableContractorTotal ( type: esriFieldTypeDouble, alias: NonBillableContractorTotal )
• ContractorTotal ( type: esriFieldTypeDouble, alias: ContractorTotal )
• BillableEquipmentTotal ( type: esriFieldTypeDouble, alias: BillableEquipmentTotal )
• NonBillableEquipmentTotal ( type: esriFieldTypeDouble, alias: NonBillableEquipmentTotal )
• EquipmentTotal ( type: esriFieldTypeDouble, alias: EquipmentTotal )
• BillableRequestTotal ( type: esriFieldTypeDouble, alias: BillableRequestTotal )
• NonBillableRequestTotal ( type: esriFieldTypeDouble, alias: NonBillableRequestTotal )
• RequestTotal ( type: esriFieldTypeDouble, alias: RequestTotal )
• GeoShape ( type: esriFieldTypeGeometry, alias: GeoShape )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• SRID ( type: esriFieldTypeInteger, alias: SRID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata