View In:   ArcGIS Online Map Viewer

Name: COVID-19 Complaints

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This report will sort by RID, Activity ID and then Establishment Name.Note: • Activity Type is indicated by F for Fatality/Catastrophe, C for Complaint, and R for Referral in the Activity ID Column.• Fatality/Catastrophes UPAs are indicated as Closed when saved Final and Marked as Inspection = N, or Marked as Inspection = Y and related Inspection entered and saved Final.• For each UPA, the earliest inspection (the first one entered in the system) is displayed in the report. * New Prompt for Hazard and Location String Search allows users to get only those records with given search string. Enclose the search string by "%" sign in begining as well as end e.g. to search for "forklift" the prompt value should be "%forklift%. Enter the search string/s ( 3 maximum ) in lowercase only.

Service Item Id: af13b3d227c64cb6933b5747f16751c1

Copyright Text: US Occupational Safety and Health Administration

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: -1.2132967162172709E7
YMin: 3742672.509797356
XMax: -1.1425600551659316E7
YMax: 4415657.292478741
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [110, 0, 153, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RID ( type: esriFieldTypeString, alias: RID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RID )
• ACT_ID ( type: esriFieldTypeString, alias: Act ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ACT_ID )
• NAME ( type: esriFieldTypeString, alias: Business, editable: true, nullable: true, length: 127, defaultValue: null, modelName: NAME )
• STREET_PRE ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_PRE )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 31, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 63, defaultValue: null, modelName: STATE )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 9, defaultValue: null, modelName: ZIP )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 15, defaultValue: null, modelName: COUNTY )
• PRIMARY_NAICS ( type: esriFieldTypeString, alias: Primary NAICS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PRIMARY_NAICS , Coded Values: [11: Agriculture, Forestry, Fishing and Hunting] , [111: Crop Production] , [1111: Oilseed and Grain Farming] , ...2459 more... )
• SITE_NAICS ( type: esriFieldTypeString, alias: Site NAICS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SITE_NAICS , Coded Values: [11: Agriculture, Forestry, Fishing and Hunting] , [111: Crop Production] , [1111: Oilseed and Grain Farming] , ...2459 more... )
• RECEIPT_DATE ( type: esriFieldTypeDate, alias: Date complaint received, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RECEIPT_DATE )
• RECEIPT_TYPE ( type: esriFieldTypeString, alias: Receipt Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RECEIPT_TYPE )
• FORMALITY ( type: esriFieldTypeString, alias: Formality, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FORMALITY )
• VALID_DO_INSP ( type: esriFieldTypeString, alias: Valid/Do Inspection, editable: true, nullable: true, length: 7, defaultValue: null, modelName: VALID_DO_INSP )
• OPEN_CLOSED_AND_STATUS ( type: esriFieldTypeString, alias: Open/Closed & Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OPEN_CLOSED_AND_STATUS )
• CSHO_ID_SUPV_ID ( type: esriFieldTypeString, alias: CSHO ID/Supervisor ID, editable: true, nullable: true, length: 31, defaultValue: null, modelName: CSHO_ID_SUPV_ID )
• TYPE_S_H_ID_SERIOUS_OTHER ( type: esriFieldTypeString, alias: Type (S/H) - ID, Serious, Other, editable: true, nullable: true, length: 63, defaultValue: null, modelName: TYPE_S_H_ID_SERIOUS_OTHER )
• RESPONSE_TIME_INSP_INQ ( type: esriFieldTypeString, alias: Response Time To Inspections/Inquiry, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RESPONSE_TIME_INSP_INQ )
• ADDL_CODE ( type: esriFieldTypeString, alias: Additional Code, editable: true, nullable: true, length: 31, defaultValue: null, modelName: ADDL_CODE )
• HAZARD_DESC_AND_LOCATIONS ( type: esriFieldTypeString, alias: Hazard description and locations received by NMED, editable: true, nullable: true, length: 1024, defaultValue: null, modelName: HAZARD_DESC_AND_LOCATIONS )
• VALID ( type: esriFieldTypeSmallInteger, alias: Valid, editable: true, nullable: true, defaultValue: null, modelName: VALID )

Templates:

• Name: SDE_ADMIN.covid19_complaints
  Description:
  Prototype:
  HAZARD_DESC_AND_LOCATIONS: null
  RID: null
  ACT_ID: null
  NAME: null
  STREET_PRE: null
  CITY: null
  STATE: null
  ZIP: null
  COUNTY: null
  PRIMARY_NAICS: null
  SITE_NAICS: null
  RECEIPT_DATE: null
  RECEIPT_TYPE: null
  FORMALITY: null
  VALID_DO_INSP: null
  OPEN_CLOSED_AND_STATUS: null
  CSHO_ID_SUPV_ID: null
  TYPE_S_H_ID_SERIOUS_OTHER: null
  RESPONSE_TIME_INSP_INQ: null
  ADDL_CODE: null
  VALID: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata