Schemas

Introducing ATTOM Cloud Schemas

In its efforts to make property data easier to consume, ATTOM has implemented a series of schemas that covers different aspects of our data.

ADW Schema

All of ATTOM CLoud's data can be found under the generic schema of ADW.

ADC Schema

The ADC schema is used for all data that has been uploaded by customers into their own dedicate instance of ATTOM Cloud (ATTOM Cloud-SI).

Simplified Schemas

The ADW schema has also been broken up into multiple schemas to make it easier to find/use specific data. These scheme names can be used as an alternative to the ADW schema: -

Property
Ownership
Mortgage & Transactions
Foreclosure
Boundaries (Coming Soon)
Valuation
Listings (Coming Soon)
Schools (Coming Soon)
Hazard (Coming Soon)
Neighborhood (Coming Soon)

All of the simplified schemas should be available in the limited 5-county trial database. The simplified schemas available to you in your own ATTOM Cloud database will depend on how much of ATTOM's data you have licensed.

Viewing the Database Schema

Within ATTOM Cloud, the consolidated schema for the current database is displayed on the left of the screen

Tables & Views

Each schema is made up of one or more tables or views. These are used in queries to extract the property data you need. Expand a table or view to see a list of the columns and the data types.

Special Schemas

In addition to the property data itself, ATTOM provides additional information to help you to make use of that data. These are found within the following special schemas.

Reference

Contains metadata such as the data catalog (AttomDataDictionary) and coverage tables outlining how much data is collected in each county.

Publishing Status

The latest information about when the data was last updated.

Dimension Tables

Used to translate codes commonly used throughout the property data into descriptions.

Searching The Schema

To find out which table/view might have the data you are looking for, search the schema using the search box provided. In the following example, we are searching for information about garages and have established that data exists in the: -

PropertyFeature table under Property;
vPropertyFeatureCoverage view under Reference; and
DimGarage table under Dimension Tables

Typeahead

When creating SQL queries, the SQL editor has an understanding of the current schemas and will provide typeahead support to help you enter the names of tables and columns.

In order to get typeahead support for columns, it is usually necessary to have nominated one or more tables/views in the code

External Access

Please note: When viewing an ATTOM Cloud Data from external software, the available schemas will vary depending on the software. IN some cases both the ADW and the Simplified schemas will be available, and in others, only the ADW schema will appear.