Name: TCPH_Covid_DailyUpdateEditor_2021

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

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

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"TCPH_Covid_DailyUpdateEditor_2021","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• intro (type: esriFieldTypeString, alias: Daily Case Update Form. Updates TC Public Health COVID-19 Information dashboard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dateReported (type: esriFieldTypeDate, alias: Date Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• testsPerformed (type: esriFieldTypeInteger, alias: Total Number of Tests Administered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inmateCases (type: esriFieldTypeInteger, alias: Confirmed Inmate Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• commCases (type: esriFieldTypeInteger, alias: Confirmed Community Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• confirmed (type: esriFieldTypeInteger, alias: Total Confirmed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• newInmateCases (type: esriFieldTypeInteger, alias: New Inmate Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• newCommCases (type: esriFieldTypeInteger, alias: New Community Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• newCases (type: esriFieldTypeInteger, alias: Total New Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inIsolation (type: esriFieldTypeInteger, alias: In Isolation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hospitalized (type: esriFieldTypeInteger, alias: Hospitalized, SQL Type: sqlTypeOther, nullable: true, editable: true)
• active (type: esriFieldTypeInteger, alias: Active Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• recovered (type: esriFieldTypeInteger, alias: Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deaths (type: esriFieldTypeInteger, alias: Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_0to17_F (type: esriFieldTypeInteger, alias: Age 0-17 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_0to17_M (type: esriFieldTypeInteger, alias: Age 0-17 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_0to17_UNB (type: esriFieldTypeInteger, alias: Age 0-17 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_18to29_F (type: esriFieldTypeInteger, alias: Age 18-29 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_18to29_M (type: esriFieldTypeInteger, alias: Age 18-29 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_18to29_UNB (type: esriFieldTypeInteger, alias: Age 18-29 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_30to39_F (type: esriFieldTypeInteger, alias: Age 30-39 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_30to39_M (type: esriFieldTypeInteger, alias: Age 30-39 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_30to39_UNB (type: esriFieldTypeInteger, alias: Age 30-39 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_40to49_F (type: esriFieldTypeInteger, alias: Age 40-49 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_40to49_M (type: esriFieldTypeInteger, alias: Age 40-49 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_40to49_UNB (type: esriFieldTypeInteger, alias: Age 40-49 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_50to59_F (type: esriFieldTypeInteger, alias: Age 50-59 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_50to59_M (type: esriFieldTypeInteger, alias: Age 50-59 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_50to59_UNB (type: esriFieldTypeInteger, alias: Age 50-59 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_60to69_F (type: esriFieldTypeInteger, alias: Age 60-69 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_60to69_M (type: esriFieldTypeInteger, alias: Age 60-69 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_60to69_UNB (type: esriFieldTypeInteger, alias: Age 60-69 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_70to79_F (type: esriFieldTypeInteger, alias: Age 70-79 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_70to79_M (type: esriFieldTypeInteger, alias: Age 70-79 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_70to79_UNB (type: esriFieldTypeInteger, alias: Age 70-79 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_80to89_F (type: esriFieldTypeInteger, alias: Age 80-89 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_80to89_M (type: esriFieldTypeInteger, alias: Age 80-89 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_80to89_UNB (type: esriFieldTypeInteger, alias: Age 80-89 Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_Over90_F (type: esriFieldTypeInteger, alias: Age 90+ Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_Over90_M (type: esriFieldTypeInteger, alias: Age 90+ Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_Over90_UNB (type: esriFieldTypeInteger, alias: Age 90+ Unknown or Non-Binary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tierNum (type: esriFieldTypeDouble, alias: Tier Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tierColor (type: esriFieldTypeString, alias: Tier Color, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [purple_tier_1: Purple - Tier 1], [red_tier_2: Red - Tier 2], [orange_tier_3: Orange - Tier 3], ... 1 more ...)
• blueprint (type: esriFieldTypeDouble, alias: Blueprint Case Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• positiveRate (type: esriFieldTypeDouble, alias: Testing Positivity Rate (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• latestUpdate1 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate2 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate3 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate4 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate5 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate6 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate7 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate8 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate9 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• latestUpdate10 (type: esriFieldTypeString, alias: Update Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• SCC_TestsPerformed (type: esriFieldTypeInteger, alias: Number of Sierra Conservation Center (SCC) tests administered to date., SQL Type: sqlTypeOther, nullable: true, editable: true)
• NonSCC_TestsPerformed (type: esriFieldTypeInteger, alias: Number of Tests Administered as of date reported. Do not include SCC associated tests., SQL Type: sqlTypeOther, nullable: true, editable: true)
• VaxAdmin (type: esriFieldTypeInteger, alias: Vaccines Administered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fullVax (type: esriFieldTypeInteger, alias: Number of individualls Fully Vaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• partialVax (type: esriFieldTypeInteger, alias: Number of individualls Partially Vaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• percentPopVax (type: esriFieldTypeInteger, alias: Percent of Population that has been vaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_0to11_F (type: esriFieldTypeInteger, alias: Age 0-11 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_0to11_M (type: esriFieldTypeInteger, alias: Age 0-11 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_12to17_F (type: esriFieldTypeInteger, alias: Age 12-17 Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_12to17_M (type: esriFieldTypeInteger, alias: Age 12-17 Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_0to11_O (type: esriFieldTypeInteger, alias: Age 0-11 Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age_12to17_O (type: esriFieldTypeInteger, alias: Age 12-17 Other, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• TCPH_Covid_DailyUpdateEditor_2021_episodes (1) -- Related To: episodes (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/25/2023 12:52:57 AM

Schema Last Edit Date: 2/25/2023 12:52:57 AM

Data Last Edit Date: 2/25/2023 12:52:57 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat