View In:   ArcGIS Online Map Viewer

Name: Complaints

Display Field: CMPLNTIMPCT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 51c84284cc134872b67ac63df1e460ec

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9244648.868618

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: -84.581378002
YMin: 36.94836171
XMax: -81.861744333
YMax: 40.757410582
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [45, 147, 103, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [CMPLT_RPTID] CONCAT NEWLINE CONCAT ([C_COUNTY])
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 144447.638572
Max. Scale: 0.0

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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SE_ANNO_CAD_DATA ( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA, editable: true, nullable: true, defaultValue: null, modelName: SE_ANNO_CAD_DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• CMPLNTIMPCT ( type: esriFieldTypeString, alias: CmplntImpct, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CMPLNTIMPCT )
• CMPLNT_PRGRM ( type: esriFieldTypeString, alias: OEPA_PROGRAM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CMPLNT_PRGRM )
• CMPLT_RPTID ( type: esriFieldTypeString, alias: REPORT_ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CMPLT_RPTID )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DISTRICT , Coded Values: [NEDO: Northeast District Office] , [NWDO: Northwest District Office] , [SWDO: Southwest District Office] , ...4 more... )
• RECEIVED_BY ( type: esriFieldTypeString, alias: RECEIVED_BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RECEIVED_BY , Coded Values: [CDO: Central District Office] , [CO: Central Office] , [EMRG: Emergency Response] , ...6 more... )
• COMPLAINANT ( type: esriFieldTypeString, alias: COMPLAINANT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMPLAINANT )
• C_ADDRESS ( type: esriFieldTypeString, alias: C_ADDRESS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: C_ADDRESS )
• C_CITY ( type: esriFieldTypeString, alias: C_CITY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: C_CITY )
• C_STATE ( type: esriFieldTypeString, alias: C_STATE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: C_STATE )
• C_ZIP ( type: esriFieldTypeString, alias: C_ZIP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: C_ZIP )
• C_PHONE ( type: esriFieldTypeString, alias: C_PHONE, editable: true, nullable: true, length: 12, defaultValue: null, modelName: C_PHONE )
• C_EMAIL ( type: esriFieldTypeString, alias: C_EMAIL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: C_EMAIL )
• CONFIDENTIAL ( type: esriFieldTypeString, alias: CONFIDENTIAL, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONFIDENTIAL , Coded Values: [A: Anonymous] , [N: Not Confidential] , [Y: Confidential] )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SOURCE )
• S_ADDRESS ( type: esriFieldTypeString, alias: S_ADDRESS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: S_ADDRESS )
• S_CITY ( type: esriFieldTypeString, alias: S_CITY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: S_CITY )
• S_STATE ( type: esriFieldTypeString, alias: S_STATE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: S_STATE )
• S_ZIP ( type: esriFieldTypeString, alias: S_ZIP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: S_ZIP )
• S_PHONE ( type: esriFieldTypeString, alias: S_PHONE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: S_PHONE )
• S_CONTACT ( type: esriFieldTypeString, alias: S_CONTACT, editable: true, nullable: true, length: 25, defaultValue: null, modelName: S_CONTACT )
• S_ADDSNGL ( type: esriFieldTypeString, alias: SingleLineAddr, editable: true, nullable: true, length: 125, defaultValue: null, modelName: S_ADDSNGL )
• S_SECND_ID ( type: esriFieldTypeInteger, alias: SECONDARY_ID, editable: true, nullable: true, defaultValue: null, modelName: S_SECND_ID )
• S_SECND_ID_DESC ( type: esriFieldTypeString, alias: SECONDARY ID DESC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: S_SECND_ID_DESC )
• S_CORE_PLACE_ID ( type: esriFieldTypeInteger, alias: S_CORE_PLACE_ID, editable: true, nullable: true, defaultValue: null, modelName: S_CORE_PLACE_ID )
• C_COUNTY ( type: esriFieldTypeString, alias: C_COUNTY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: C_COUNTY )
• COMPLAINT ( type: esriFieldTypeString, alias: COMPLAINT, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: COMPLAINT )
• COMPLAINT_DT ( type: esriFieldTypeDate, alias: COMPLAINT_DT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMPLAINT_DT )
• S_LATITUDE ( type: esriFieldTypeDouble, alias: S_LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: S_LATITUDE )
• S_LONGITUDE ( type: esriFieldTypeDouble, alias: S_LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: S_LONGITUDE )
• S_HUC ( type: esriFieldTypeString, alias: S_HUC, editable: true, nullable: true, length: 15, defaultValue: null, modelName: S_HUC )
• 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 )
• RECEIVED_DATE ( type: esriFieldTypeDate, alias: RECEIVED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RECEIVED_DATE )

Templates:

• Name: Complaints
  Description:
  Prototype:
  S_LONGITUDE: null
  S_HUC: null
  SE_ANNO_CAD_DATA: null
  RECEIVED_DATE: null
  CMPLNTIMPCT: null
  CMPLNT_PRGRM: null
  CMPLT_RPTID: null
  DISTRICT: null
  RECEIVED_BY: null
  COMPLAINANT: null
  C_ADDRESS: null
  C_CITY: null
  C_STATE: null
  C_ZIP: null
  C_PHONE: null
  C_EMAIL: null
  CONFIDENTIAL: null
  SOURCE: null
  S_ADDRESS: null
  S_CITY: null
  S_STATE: null
  S_ZIP: null
  S_PHONE: null
  S_CONTACT: null
  S_ADDSNGL: null
  S_SECND_ID: null
  S_SECND_ID_DESC: null
  S_CORE_PLACE_ID: null
  C_COUNTY: null
  COMPLAINT: null
  COMPLAINT_DT: null
  S_LATITUDE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• OEPA.TRAIN_COMPLAINTS_WORKFLOW (0) -- Related To: WORKFLOW (6)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata