Name: Cases

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ee10c2b35f64418782acf5daf22ffe22

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• latest_reportdate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Report date, type: esriFieldTypeDate )
• name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name, type: esriFieldTypeString )
• positiveincrease ( nullable: true, editable: true, defaultValue: null, alias: New Cases, type: esriFieldTypeInteger )
• deathsincrease ( nullable: true, editable: true, defaultValue: null, alias: Deaths, type: esriFieldTypeInteger )
• casesagerange1 ( nullable: true, editable: true, defaultValue: null, alias: 0-9, type: esriFieldTypeInteger )
• casesagerange2 ( nullable: true, editable: true, defaultValue: null, alias: 10-19, type: esriFieldTypeInteger )
• casesagerange3 ( nullable: true, editable: true, defaultValue: null, alias: 20-29, type: esriFieldTypeInteger )
• casesagerange4 ( nullable: true, editable: true, defaultValue: null, alias: 30-39, type: esriFieldTypeInteger )
• casesagerange5 ( nullable: true, editable: true, defaultValue: null, alias: 40-49, type: esriFieldTypeInteger )
• casesagerange6 ( nullable: true, editable: true, defaultValue: null, alias: 50-59, type: esriFieldTypeInteger )
• casesagerange7 ( nullable: true, editable: true, defaultValue: null, alias: 60-69, type: esriFieldTypeInteger )
• casesagerange8 ( nullable: true, editable: true, defaultValue: null, alias: 70-79, type: esriFieldTypeInteger )
• casesagerange9 ( nullable: true, editable: true, defaultValue: null, alias: 80 and above, type: esriFieldTypeInteger )
• casesageother ( nullable: true, editable: true, defaultValue: null, alias: Not Available, type: esriFieldTypeInteger )
• casesmale ( nullable: true, editable: true, defaultValue: null, alias: Male, type: esriFieldTypeInteger )
• casesfemale ( nullable: true, editable: true, defaultValue: null, alias: Female, type: esriFieldTypeInteger )
• casessexother ( nullable: true, editable: true, defaultValue: null, alias: Other or Not Available, type: esriFieldTypeInteger )
• asymptomatic ( nullable: true, editable: true, defaultValue: null, alias: Asymptomatic, type: esriFieldTypeInteger )
• mild ( nullable: true, editable: true, defaultValue: null, alias: Mild, type: esriFieldTypeInteger )
• severe ( nullable: true, editable: true, defaultValue: null, alias: Severe, type: esriFieldTypeInteger )
• unspecified ( nullable: true, editable: true, defaultValue: null, alias: Unspecified, type: esriFieldTypeInteger )
• contactwithconfirmedcase ( nullable: true, editable: true, defaultValue: null, alias: Contact with Confirmed Case, type: esriFieldTypeInteger )
• travelrelated ( nullable: true, editable: true, defaultValue: null, alias: Travel Related, type: esriFieldTypeInteger )
• underinvestigation ( nullable: true, editable: true, defaultValue: null, alias: Under Investigation, type: esriFieldTypeInteger )
• unidentifiedsource ( nullable: true, editable: true, defaultValue: null, alias: Unidentified Source, type: esriFieldTypeInteger )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• sum_ages ( nullable: true, editable: true, defaultValue: null, alias: Total number of cases in ages, type: esriFieldTypeInteger )
• sum_gendersgroup ( nullable: true, editable: true, defaultValue: null, alias: Total number of cases by gender, type: esriFieldTypeInteger )
• sum_symptompsgroup ( nullable: true, editable: true, defaultValue: null, alias: Total number of cases by symptoms, type: esriFieldTypeInteger )
• sum_infectiongroup ( nullable: true, editable: true, defaultValue: null, alias: Total number of cases by infection, type: esriFieldTypeInteger )

Relationships:

• Covid_Case_Reporter_Cases (0) -- Related To: Covid_Case_Reporter (0)

Capabilities: Query,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata