Name: ODH_Local_Health_Departments_2023

Display Field: Business_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9422938.63450925
YMin: 4683795.64372554
XMax: -8968022.1862151
YMax: 5152785.7278743
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"ec5d69fc63329f5714d4cd4c72d3a2ef","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACxUlEQVRIibVVz2sTQRj9EhLo9pQNRNjtxSoUbHspKR7E5iCol8SD1qax9+Tau0IS8A/oNbm32/xA0K0HFTxE8aLWS9JAwR+X7IIVm0uJGNyVNzrT2U1iQsF3WmZn37zvfd+8DdF/RGjcBsMwdDcYjgcDAc11HR1rTsA1N9bW3p+ZfLtajQedQEGZVpKqqpIyNUWKorB3lmXnjUqdyKUyuf1iJpOxJiY3KrVCNBLN67pGiwuXBt7ztY+fPmffvtvPGpVaMZO+WxhLbuzWzKgaTS4vL1FUVf9Z9sULs6RrGr16/SZv7Na1zPpqbiQ5U6xGkzeuX6NJoShThP3PX7xEBbZcQUj2GFZA8VmwcvUKPTaf5rerVdFsQY7mwWPZik6pSN2GST+/2TR7v0SRRJK6jT3qlApsTV1J0vkHJVHB4sI8tVptLCwLcowbpkJuXqdUZCQch5spOnc7S18flcUaf+YH4Ptm6yDusQVzjHGT0W2YA6WDbG7LZAcB4ZhOJ23vuKP6nUo9dS+9ajJyXBDMsYwT30cAlMMaKEVlS886dLh5y7MHPOA7Ve46Or8gHJf33QGLYneyjGxu64kQwJ8FuaIwPkE+DP0jmz7c1FnpUBiOacKuLw9zTD0O4tUMQ4hnBa603NBwTBP+ymTce9kmGZZlMz5BjrlkWeFDJJGkmVyBWTI9H/c0GRX5iXu9H/T9+JiCzi/ba4tLZWQFrrSMmVye+kcWU88BxVj3w7JtxsODTCLvFxFCyApcCBmwJJJIMTtGeQzFzdYBOUFHXARBjtOQbgihYdkCwlGNA5qtNvV6veJG+jTnPdOC0EG6IYSQFf4KhuGP4jZZHWsvs+6N3YFRRGwi3RBCyIphec6bB49hBRT7iYeS8wqQbgghZAWutO9PxBSjefBYtmIsOfA3Nlm6ISv8/1CM26jf21hyGQihSfb58Rt41mGJLpNBYgAAAABJRU5ErkJggg==","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0}},"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Business_Type (type: esriFieldTypeString, alias: Business Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Business_Name (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line_1 (type: esriFieldTypeString, alias: Location Address Line 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line_2 (type: esriFieldTypeString, alias: Location Address Line 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_City (type: esriFieldTypeString, alias: Location City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_State (type: esriFieldTypeString, alias: Location State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Zip (type: esriFieldTypeString, alias: Location Zip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_County (type: esriFieldTypeString, alias: Location County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VoicePhone (type: esriFieldTypeString, alias: VoicePhone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EmailAddress (type: esriFieldTypeString, alias: EmailAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPLastName (type: esriFieldTypeString, alias: RPLastName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPFirstName (type: esriFieldTypeString, alias: RPFirstName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPMiddleName (type: esriFieldTypeString, alias: RPMiddleName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPSuffix (type: esriFieldTypeString, alias: RPSuffix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPEmail (type: esriFieldTypeString, alias: RPEmail, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Dispenses_Naloxone (type: esriFieldTypeString, alias: Dispenses Naloxone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CredentialStatus (type: esriFieldTypeString, alias: CredentialStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CredentialStatusReason (type: esriFieldTypeString, alias: CredentialStatusReason, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• License_Number (type: esriFieldTypeString, alias: License Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Subcategory_Code (type: esriFieldTypeString, alias: Subcategory Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line_3 (type: esriFieldTypeString, alias: Location Address Line 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LocationLat (type: esriFieldTypeDouble, alias: LocationLat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationLong (type: esriFieldTypeDouble, alias: LocationLong, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MailingAddressLine1 (type: esriFieldTypeString, alias: MailingAddressLine1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingAddressLine2 (type: esriFieldTypeString, alias: MailingAddressLine2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingAddressLine3 (type: esriFieldTypeString, alias: MailingAddressLine3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingCity (type: esriFieldTypeString, alias: MailingCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingState (type: esriFieldTypeString, alias: MailingState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingZip (type: esriFieldTypeString, alias: MailingZip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FaxPhone (type: esriFieldTypeString, alias: FaxPhone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• License_Prefix (type: esriFieldTypeString, alias: License Prefix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Ohio_Drug_Category (type: esriFieldTypeString, alias: Ohio Drug Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Business_Type_1 (type: esriFieldTypeString, alias: Business Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PracticeTypeDescription (type: esriFieldTypeString, alias: PracticeTypeDescription, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DateofFirstLicensure (type: esriFieldTypeString, alias: DateofFirstLicensure, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EffectiveDate (type: esriFieldTypeString, alias: EffectiveDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ExpirationDate (type: esriFieldTypeString, alias: ExpirationDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LegalFiles (type: esriFieldTypeString, alias: LegalFiles, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPCredentialTypePrefix (type: esriFieldTypeString, alias: RPCredentialTypePrefix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• StateID (type: esriFieldTypeString, alias: StateID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Abbreviation (type: esriFieldTypeString, alias: Abbreviation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MedicareID (type: esriFieldTypeString, alias: MedicareID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MedicaidID (type: esriFieldTypeString, alias: MedicaidID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ClosedDate (type: esriFieldTypeString, alias: ClosedDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LicensedBedTotal (type: esriFieldTypeString, alias: LicensedBedTotal, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OpenDate (type: esriFieldTypeString, alias: OpenDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BedEffectiveDate (type: esriFieldTypeString, alias: BedEffectiveDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CertifiedBedTotal (type: esriFieldTypeString, alias: CertifiedBedTotal, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SortOrder (type: esriFieldTypeInteger, alias: SortOrder, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HC_Name (type: esriFieldTypeString, alias: HC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HC_Phone (type: esriFieldTypeString, alias: HC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HC_Email (type: esriFieldTypeString, alias: HC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MD_Name (type: esriFieldTypeString, alias: MD_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MD_Phone (type: esriFieldTypeString, alias: MD_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MD_Email (type: esriFieldTypeString, alias: MD_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AD_Name (type: esriFieldTypeString, alias: AD_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AD_Phone (type: esriFieldTypeString, alias: AD_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AD_Email (type: esriFieldTypeString, alias: AD_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EHD_Name (type: esriFieldTypeString, alias: EHD_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EHD_Phone (type: esriFieldTypeString, alias: EHD_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EHD_Email (type: esriFieldTypeString, alias: EHD_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ND_Name (type: esriFieldTypeString, alias: ND_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ND_Phone (type: esriFieldTypeString, alias: ND_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ND_Email (type: esriFieldTypeString, alias: ND_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VS_Name (type: esriFieldTypeString, alias: VS_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VS_Phone (type: esriFieldTypeString, alias: VS_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VS_Email (type: esriFieldTypeString, alias: VS_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FO_Name (type: esriFieldTypeString, alias: FO_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FO_Phone (type: esriFieldTypeString, alias: FO_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FO_Email (type: esriFieldTypeString, alias: FO_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIO_Name (type: esriFieldTypeString, alias: PIO_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIO_Phone (type: esriFieldTypeString, alias: PIO_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIO_Email (type: esriFieldTypeString, alias: PIO_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EPI_Name (type: esriFieldTypeString, alias: EPI_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EPI_Phone (type: esriFieldTypeString, alias: EPI_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EPI_Email (type: esriFieldTypeString, alias: EPI_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ERC_Name (type: esriFieldTypeString, alias: ERC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ERC_Phone (type: esriFieldTypeString, alias: ERC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ERC_Email (type: esriFieldTypeString, alias: ERC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AHC_Name (type: esriFieldTypeString, alias: AHC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AHC_Phone (type: esriFieldTypeString, alias: AHC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AHC_Email (type: esriFieldTypeString, alias: AHC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DHC_Name (type: esriFieldTypeString, alias: DHC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DHC_Phone (type: esriFieldTypeString, alias: DHC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DHC_Email (type: esriFieldTypeString, alias: DHC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DR_Name (type: esriFieldTypeString, alias: DR_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DR_Phone (type: esriFieldTypeString, alias: DR_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DR_Email (type: esriFieldTypeString, alias: DR_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AC_Name (type: esriFieldTypeString, alias: AC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AC_Phone (type: esriFieldTypeString, alias: AC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AC_Email (type: esriFieldTypeString, alias: AC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HE_Name (type: esriFieldTypeString, alias: HE_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HE_Phone (type: esriFieldTypeString, alias: HE_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HE_Email (type: esriFieldTypeString, alias: HE_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Population (type: esriFieldTypeInteger, alias: Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LHDId (type: esriFieldTypeInteger, alias: LHDId, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Business_Type_Category (type: esriFieldTypeInteger, alias: Business Type Category, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hospital_Type (type: esriFieldTypeString, alias: Hospital Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NATCEP_Type (type: esriFieldTypeString, alias: NATCEP Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDType (type: esriFieldTypeString, alias: LHDType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDCountyCity (type: esriFieldTypeString, alias: LHDCountyCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDStatus (type: esriFieldTypeString, alias: LHDStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDDistrict (type: esriFieldTypeString, alias: LHDDistrict, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContractingWith (type: esriFieldTypeString, alias: ContractingWith, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BusinessTypeCategoryDesc (type: esriFieldTypeString, alias: BusinessTypeCategoryDesc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HospitalTypeDesc (type: esriFieldTypeString, alias: HospitalTypeDesc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NATCEPTypeDesc (type: esriFieldTypeString, alias: NATCEPTypeDesc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Data_Source (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CombinedWith (type: esriFieldTypeString, alias: CombinedWith, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDIdOld (type: esriFieldTypeInteger, alias: LHDIdOld, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Active_Facility (type: esriFieldTypeString, alias: Active Facility, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: ODH_Local_Health_Departments_2023
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/8/2023 4:51:03 PM

Schema Last Edit Date: 8/8/2023 4:51:03 PM

Data Last Edit Date: 8/8/2023 4:51:03 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat