Name: APD Facilities by Type

Display Field: FacilityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: This is a Query Layer of the licensing.webFACILITY table in the OBI SQL Server database. This table is updated daily

Copyright Text: Oregon Department of Human Services Office of Business Intelligence Office of Forecasting, Research and Analysis - GIS

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: -124.505
YMin: 42.0311
XMax: -116.964
YMax: 46.2012
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"FacilityDisplayDesc","uniqueValueGroups":[{"heading":"Facility Type","classes":[{"label":"Adult Foster Home","description":"Adult Foster Home","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[204,51,51,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"values":[["Adult Foster Home"]]},{"label":"Assisted Living Facility","description":"Assisted Living Facility","symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[0,153,153,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"values":[["Assisted Living Facility"]]},{"label":"Nursing Facility","description":"Nursing Facility","symbol":{"type":"esriPMS","url":"f260aee88c7117f8c67606766568021b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAyUlEQVQokaWSgQ3CIBBF/ylL1DGgY9QtENxCxpDiFl1Du5FgoE3TUKlWf0K4hLvH8Q+GP8XWDrl0Iu797fT4CUD0NCCKkMNmAI+3k29SrK3qrW43AWjvLcIYBxgA3wO4tgoB6f2jqlpZc2+1+Qjg0gkKfpEYgAuXrssNZXnibudVAKqiqcCxCODSiQCv3hWPhCbmzLtgyxuoWD+ZC9QLAB+MS2NbVYCYj3UCEFBuPe9iNtYE4Po6GEMoftlcsaa35y4BYgAgrs16ARNwRfTOeY8hAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":10,"angle":0,"xoffset":0,"yoffset":0},"values":[["Nursing Facility"]]},{"label":"Residential Care Facility","description":"Residential Care Facility","symbol":{"type":"esriPMS","url":"5f3867267694d298ce7340fe256f36df","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAWCAYAAAD0OH0aAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABKUlEQVQ4ja2SzW2DQBCF35KVqIG0QcqwIguODjkYhMsIlGGEuWCOWJapgzISWsjvTjQEkG3+FMnvAlrmmzfzWIl/St4E8DLb52e8yqNZwMuWJhEFAAwA84BSmi9EXYx1am0T57AZBf66ox6HJQR8L1tG8epYDgKKRCCuHInutgAeegAvSkSLfgRksnPr0gHno/QQ0goA9x3QdDfHAAAG13DM8izGSRER7xJJ9a4qoWt1jDOquLlM3NObl1ohCbxMO6DYPR3LeofYOQTu3l5wIsPlokycfHP5HxRCaDgN1iuE7WsH7J7zwt3bZd9FlPytB9Rzfnw9Cl2+XpSLn/G7xAGsUyviO9QsGvGio0Ctz+8QumSg0jQ1f73bmBVgXHcfdmhiHjofBab0CwndhXF7BqPSAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":16,"angle":0,"xoffset":0,"yoffset":0},"values":[["Residential Care Facility"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[204,51,51,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"Adult Foster Home","label":"Adult Foster Home"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[0,153,153,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"Assisted Living Facility","label":"Assisted Living Facility"},{"symbol":{"type":"esriPMS","url":"f260aee88c7117f8c67606766568021b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAyUlEQVQokaWSgQ3CIBBF/ylL1DGgY9QtENxCxpDiFl1Du5FgoE3TUKlWf0K4hLvH8Q+GP8XWDrl0Iu797fT4CUD0NCCKkMNmAI+3k29SrK3qrW43AWjvLcIYBxgA3wO4tgoB6f2jqlpZc2+1+Qjg0gkKfpEYgAuXrssNZXnibudVAKqiqcCxCODSiQCv3hWPhCbmzLtgyxuoWD+ZC9QLAB+MS2NbVYCYj3UCEFBuPe9iNtYE4Po6GEMoftlcsaa35y4BYgAgrs16ARNwRfTOeY8hAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Nursing Facility","label":"Nursing Facility"},{"symbol":{"type":"esriPMS","url":"5f3867267694d298ce7340fe256f36df","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAWCAYAAAD0OH0aAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABKUlEQVQ4ja2SzW2DQBCF35KVqIG0QcqwIguODjkYhMsIlGGEuWCOWJapgzISWsjvTjQEkG3+FMnvAlrmmzfzWIl/St4E8DLb52e8yqNZwMuWJhEFAAwA84BSmi9EXYx1am0T57AZBf66ox6HJQR8L1tG8epYDgKKRCCuHInutgAeegAvSkSLfgRksnPr0gHno/QQ0goA9x3QdDfHAAAG13DM8izGSRER7xJJ9a4qoWt1jDOquLlM3NObl1ohCbxMO6DYPR3LeofYOQTu3l5wIsPlokycfHP5HxRCaDgN1iuE7WsH7J7zwt3bZd9FlPytB9Rzfnw9Cl2+XpSLn/G7xAGsUyviO9QsGvGio0Ctz+8QumSg0jQ1f73bmBVgXHcfdmhiHjofBab0CwndhXF7BqPSAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"Residential Care Facility","label":"Residential Care Facility"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[237,81,81,255],"toColor":[237,81,81,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[21,160,207,255],"toColor":[21,160,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[167,199,54,255],"toColor":[167,199,54,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[158,85,156,255],"toColor":[158,85,156,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,145,30,255],"toColor":[252,145,30,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,223,61,255],"toColor":[255,223,61,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,136,216,255],"toColor":[247,136,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,129,73,255],"toColor":[184,129,73,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[60,176,155,255],"toColor":[60,176,155,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[107,107,214,255],"toColor":[107,107,214,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: LoadID

Unique ID Field:

Name : LoadID

IsSystemMaintained : True

Global ID Field:

Type ID Field: FacilityDisplayDesc

Fields:

• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• CCMUNum (type: esriFieldTypeString, alias: CCMUNum, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• InternalFacilityID (type: esriFieldTypeInteger, alias: InternalFacilityID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MedicareID (type: esriFieldTypeString, alias: MedicareID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• MedicaidID (type: esriFieldTypeString, alias: MedicaidID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• FundingSource (type: esriFieldTypeString, alias: FundingSource, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true)
• CompanyID (type: esriFieldTypeInteger, alias: CompanyID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FacilityName (type: esriFieldTypeString, alias: FacilityName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FacilityTypeCd (type: esriFieldTypeString, alias: FacilityTypeCd, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• FacilityTypeDesc (type: esriFieldTypeString, alias: FacilityTypeDesc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FacilityDisplayDesc (type: esriFieldTypeString, alias: FacilityDisplayDesc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FacilityAbbreviation (type: esriFieldTypeString, alias: FacilityAbbreviation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• FacilityCloseDate (type: esriFieldTypeDateOnly, alias: FacilityCloseDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OperatingStatusCod (type: esriFieldTypeString, alias: OperatingStatusCod, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• OperatingStatusDesc (type: esriFieldTypeString, alias: OperatingStatusDesc, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FinalOrderDate (type: esriFieldTypeDateOnly, alias: FinalOrderDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFHClass (type: esriFieldTypeString, alias: AFHClass, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• ActiveDate (type: esriFieldTypeDateOnly, alias: ActiveDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InactiveDate (type: esriFieldTypeDateOnly, alias: InactiveDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AdministratorName (type: esriFieldTypeString, alias: AdministratorName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Fax (type: esriFieldTypeString, alias: Fax, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TotalBed (type: esriFieldTypeInteger, alias: TotalBed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OwnerName (type: esriFieldTypeString, alias: OwnerName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OwnerAddress (type: esriFieldTypeString, alias: OwnerAddress, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OwnerCity (type: esriFieldTypeString, alias: OwnerCity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OwnerState (type: esriFieldTypeString, alias: OwnerState, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• OwnerZip (type: esriFieldTypeString, alias: OwnerZip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• OwnerPhone (type: esriFieldTypeString, alias: OwnerPhone, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• OwnerActiveDate (type: esriFieldTypeDateOnly, alias: OwnerActiveDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OperatorName (type: esriFieldTypeString, alias: OperatorName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OperatorAddress (type: esriFieldTypeString, alias: OperatorAddress, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OperatorCity (type: esriFieldTypeString, alias: OperatorCity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OperatorState (type: esriFieldTypeString, alias: OperatorState, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• OperatorZip (type: esriFieldTypeString, alias: OperatorZip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• OperatorPhone (type: esriFieldTypeString, alias: OperatorPhone, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• ManagementName (type: esriFieldTypeString, alias: ManagementName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ManagementAddress (type: esriFieldTypeString, alias: ManagementAddress, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ManagementCity (type: esriFieldTypeString, alias: ManagementCity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ManagementState (type: esriFieldTypeString, alias: ManagementState, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ManagementZip (type: esriFieldTypeString, alias: ManagementZip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ManagementPhone (type: esriFieldTypeString, alias: ManagementPhone, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• AlternativeLanguage (type: esriFieldTypeSmallInteger, alias: AlternativeLanguage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AlzheimerDementia (type: esriFieldTypeSmallInteger, alias: AlzheimerDementia, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bariatric (type: esriFieldTypeSmallInteger, alias: Bariatric, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Daycare (type: esriFieldTypeSmallInteger, alias: Daycare, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pets (type: esriFieldTypeSmallInteger, alias: Pets, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Smoking (type: esriFieldTypeSmallInteger, alias: Smoking, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TraumaticBrainInjury (type: esriFieldTypeSmallInteger, alias: TraumaticBrainInjury, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ventilator (type: esriFieldTypeSmallInteger, alias: Ventilator, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MedicaidFlg (type: esriFieldTypeSmallInteger, alias: MedicaidFlg, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MedicareFlg (type: esriFieldTypeSmallInteger, alias: MedicareFlg, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PrivatePayFlg (type: esriFieldTypeSmallInteger, alias: PrivatePayFlg, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LoadID (type: esriFieldTypeOID, alias: LoadID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• LoadDt (type: esriFieldTypeDateOnly, alias: LoadDt, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: Adult Foster Home
Name: Adult Foster Home
Domains:

Templates:

Name: Adult Foster Home
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• FacilityDisplayDesc: Adult Foster Home

---

ID: Assisted Living Facility
Name: Assisted Living Facility
Domains:

Templates:

Name: Assisted Living Facility
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• FacilityDisplayDesc: Assisted Living Facility

---

ID: Nursing Facility
Name: Nursing Facility
Domains:

Templates:

Name: Nursing Facility
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• FacilityDisplayDesc: Nursing Facility

---

ID: Residential Care Facility
Name: Residential Care Facility
Domains:

Templates:

Name: Residential Care Facility
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• FacilityDisplayDesc: Residential Care Facility

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2025 6:06:51 PM

Schema Last Edit Date: 3/19/2025 6:06:51 PM

Data Last Edit Date: 3/19/2025 6:06:51 PM

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