Name: Active Oracle Service Requests

Display Field: GROUP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 20b728a5a1d54b3884dc191cd4e2f086

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

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 732257.4779603034
YMin: 264758.3852428943
XMax: 880869.046878308
YMax: 357598.2553370595
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: INCIDENT_TYPE_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: Other
UniqueValueInfos:
• Value: 10197
  Label: FS-Anti-Neglect
  Description: N/A
  Symbol:
  
• Value: 10199
  Label: FS-Fire Hydrants
  Description: N/A
  Symbol:
  
• Value: 10200
  Label: FS-Miscellaneous
  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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: INCIDENT_TYPE_ID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• X ( type: esriFieldTypeDouble, alias: X_COORD )
• Y ( type: esriFieldTypeDouble, alias: Y_COORD )
• DIVISION ( type: esriFieldTypeString, alias: DIVISION, length: 150 )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, length: 150 )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, length: 150 )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: INCIDENT_ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: INCIDENT_NUMBER, length: 100 )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: INCIDENT_TYPE_ID , Coded Values: [1: FS-01] , [2: FS-02] , [3: FS-03] , ...58 more... )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: REQUEST_TYPE, length: 100 , Coded Values: [FS-Anti-Neglect: Anti-Neglect] , [FS-Fire Hydrants: Fire Hydrants] , [FS-Miscellaneous: Miscellaneous] )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: REQUEST_STATUS, length: 50 , Coded Values: [Back to Department: Back to Department] , [Back to MCSC: Back to MCSC] , [Closed: Closed] , ...3 more... )
• REQUEST_PRIORITY ( type: esriFieldTypeString, alias: REQUEST_PRIORITY, length: 25 )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: REPORTED_DATE, length: 8 )
• SUMMARY ( type: esriFieldTypeString, alias: SUMMARY, length: 255 )
• SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 100 )
• CREATED_BY_USER ( type: esriFieldTypeString, alias: CREATED_BY_USER, length: 100 )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: DAYS_OLD )
• CREATION_DATE ( type: esriFieldTypeDate, alias: CREATION_DATE, length: 8 )
• CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: LAST_UPDATE_DATE, length: 8 )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: FOLLOWUP_DATE, length: 8 )
• NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
• RESOLVED_DATE ( type: esriFieldTypeDate, alias: RESOLVED_DATE, length: 8 )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: CLOSE_DATE, length: 8 )
• RESOLUTION_CODE ( type: esriFieldTypeString, alias: RESOLUTION_CODE, length: 50 )
• RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
• RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: RESOLUTION_SUMMARY, length: 255 )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 75 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 255 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 255 )
• ADDRESS1 ( type: esriFieldTypeString, alias: ADDRESS1, length: 255 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 255 )
• ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 255 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 75 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 10 )
• POSTAL_CODE ( type: esriFieldTypeString, alias: POSTAL_CODE, length: 75 )
• PARCEL_ID ( type: esriFieldTypeString, alias: PARCEL_ID, length: 100 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 25 , Coded Values: [CD1: CD1] , [CD2: CD2] , [CD3: CD3] , ...5 more... )
• SUB_DISTRICT ( type: esriFieldTypeString, alias: SUB_DISTRICT, length: 25 )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: TARGET_BLOCK, length: 25 )
• MAP_PAGE ( type: esriFieldTypeString, alias: MAP_PAGE, length: 25 )
• RESPONSE_AREA ( type: esriFieldTypeString, alias: RESPONSE_AREA, length: 25 , Coded Values: [HYD: HYD] , [NN: NONE] , [1: FS-01] , ...56 more... )
• FIRE_ZONE ( type: esriFieldTypeString, alias: ZONE, length: 25 , Coded Values: [FMZ-0101: FMZ-0101] , [FMZ-0102: FMZ-0102] , [FMZ-0103: FMZ-0103] , ...553 more... )
• UNIT ( type: esriFieldTypeString, alias: UNIT, length: 25 , Coded Values: [AC002: AC002] , [AC003: AC003] , [PU001: PU001] , ...78 more... )
• SHIFT ( type: esriFieldTypeString, alias: ROUTE, length: 25 , Coded Values: [A: A] , [B: B] , [C: C] )
• PREM_CODE ( type: esriFieldTypeInteger, alias: PREM_CODE )
• MLGW_ON ( type: esriFieldTypeString, alias: MLGW_ON, length: 25 )
• MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW_STATUS, length: 25 )
• NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
• LINKED_SR ( type: esriFieldTypeString, alias: LINKED_SR, length: 50 )
• RELATION ( type: esriFieldTypeString, alias: RELATION, length: 50 )
• cd_name ( type: esriFieldTypeString, alias: cd_name, length: 100 )
• cd_desc ( type: esriFieldTypeString, alias: cd_desc, length: 100 )
• sccd_name ( type: esriFieldTypeString, alias: sccd_name, length: 100 )
• sccd_desc ( type: esriFieldTypeString, alias: sccd_desc, length: 100 )
• scd_name ( type: esriFieldTypeString, alias: scd_name, length: 100 )
• scd_desc ( type: esriFieldTypeString, alias: scd_desc, length: 100 )
• neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
• neigh_desc ( type: esriFieldTypeString, alias: neigh_desc, length: 100 )
• tract_name ( type: esriFieldTypeString, alias: tract_name, length: 100 )
• tract_desc ( type: esriFieldTypeString, alias: tract_desc, length: 100 )
• voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
• voting_desc ( type: esriFieldTypeString, alias: voting_desc, length: 100 )
• zip_name ( type: esriFieldTypeString, alias: zip_name, length: 100 )
• zip_desc ( type: esriFieldTypeString, alias: zip_desc, length: 100 )
• ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
• ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
• cityzone ( type: esriFieldTypeString, alias: cityzone, length: 100 )
• CONTACT_NAME ( type: esriFieldTypeString, alias: CONTACT_NAME, length: 100 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: CONTACT_EMAIL, length: 50 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: CONTACT_PHONE, length: 50 )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: REC_EDIT_MODE, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
• SCF_URL ( type: esriFieldTypeString, alias: SCF_URL, length: 1000 )
• SCF_Description ( type: esriFieldTypeString, alias: SCF_DESC, length: 2000 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Types:

ID: 10197
Name: FS-Anti-Neglect
Domains:
• REQUEST_TYPE:
  Inherited
• REQUEST_STATUS:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [FDANRACR: Pending Court ruling] , [FDANRAD: Referred to the appropriate Division] , [FDANRSC: Secured building] , ...6 more...
• DISTRICT:
  Inherited
• RESPONSE_AREA:
  Inherited
• FIRE_ZONE:
  Inherited
• UNIT:
  Inherited
• SHIFT:
  Inherited
• REC_EDIT_MODE:
  Inherited

---

ID: 10199
Name: FS-Fire Hydrants
Domains:
• REQUEST_TYPE:
  Inherited
• REQUEST_STATUS:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [FDFHRRE: Fire Hydrant has been replaced] , [FDFHRO: Other: (See Resolution Summary for details)] , [FDFHRND: Fire Hydrant will not be replaced or repaired] , ...2 more...
• DISTRICT:
  Inherited
• RESPONSE_AREA:
  Inherited
• FIRE_ZONE:
  Inherited
• UNIT:
  Inherited
• SHIFT:
  Inherited
• REC_EDIT_MODE:
  Inherited

---

ID: 10200
Name: FS-Miscellaneous
Domains:
• REQUEST_TYPE:
  Inherited
• REQUEST_STATUS:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [FDMSRD: Problem has been resolved] , [FDMSRAD: Referred to the appropriate Division] , [FDMSRO: Other: (See Resolution Summary for details)]
• DISTRICT:
  Inherited
• RESPONSE_AREA:
  Inherited
• FIRE_ZONE:
  Inherited
• UNIT:
  Inherited
• SHIFT:
  Inherited
• REC_EDIT_MODE:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata