Name: Clean_HealthSites_Regional_ExcelToTable_Geocoded

Display Field: Facility_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 73957191

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -87.5667573663351
YMin: 37.9667313816654
XMax: -84.8957833020843
YMax: 41.6323178326464
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[42,65,150,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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)
• PublicHealth_PreparednessDistri (type: esriFieldTypeInteger, alias: PublicHealth_PreparednessDistrict , SQL Type: sqlTypeOther, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PickUp_Frequency (type: esriFieldTypeString, alias: PickUp_Frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PickUp_Days (type: esriFieldTypeString, alias: PickUp_Days, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Facility_Name (type: esriFieldTypeString, alias: Facility_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Facility_Acronymn (type: esriFieldTypeString, alias: Facility_Acronymn, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Main_Phone (type: esriFieldTypeString, alias: Main_Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fax (type: esriFieldTypeString, alias: Fax, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Courier_PickUp_Hours (type: esriFieldTypeString, alias: Courier_PickUp_Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mon_DropOff_Hours (type: esriFieldTypeString, alias: Mon_DropOff_Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tues_DropOff_Hours (type: esriFieldTypeString, alias: Tues_DropOff_Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wed_DropOff_Hours (type: esriFieldTypeString, alias: Wed_DropOff_Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Thurs_DropOff_Hours (type: esriFieldTypeString, alias: Thurs_DropOff_Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fri_DropOff_Hours (type: esriFieldTypeString, alias: Fri_DropOff_Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Specimen_DropOff (type: esriFieldTypeString, alias: Specimen_DropOff, SQL Type: sqlTypeOther, length: 327, nullable: true, editable: true)
• AfterHours_DropOff (type: esriFieldTypeString, alias: AfterHours_DropOff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Primary_POC (type: esriFieldTypeString, alias: Primary_POC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• First_Name (type: esriFieldTypeString, alias: First_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Job_Title (type: esriFieldTypeString, alias: Job_Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExtraInfo (type: esriFieldTypeString, alias: ExtraInfo, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Office_Phone (type: esriFieldTypeString, alias: Office_Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mobile_Phone (type: esriFieldTypeString, alias: Mobile_Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• Active (type: esriFieldTypeString, alias: Show on Public Map, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ETAPickUpTime (type: esriFieldTypeString, alias: Courier Pick Up Time ETA, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ActiveSite (type: esriFieldTypeString, alias: Active Site, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: Clean_HealthSites_Regional_ExcelToTable_Geocoded
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Office_Phone:
• Mobile_Phone:
• PublicHealth_PreparednessDistri: 0
• County:
• PickUp_Frequency:
• PickUp_Days:
• Facility_Name:
• Facility_Acronymn:
• Address:
• City:
• State:
• Zip:
• Main_Phone:
• Fax:
• Courier_PickUp_Hours:
• Mon_DropOff_Hours:
• Tues_DropOff_Hours:
• Wed_DropOff_Hours:
• Thurs_DropOff_Hours:
• Fri_DropOff_Hours:
• Specimen_DropOff:
• AfterHours_DropOff:
• Primary_POC:
• First_Name:
• LastName:
• Job_Title:
• Email:
• Active: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/23/2025 9:55:29 PM

Schema Last Edit Date: 6/12/2025 3:07:17 PM

Data Last Edit Date: 12/23/2025 9:55:29 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat