3.1.1 Load Data
Load the data in your database and examine the data set and its attributes.
You can download the dataset from Rolling sales data for the Brooklyn borough. If you are using the Oracle Autonomous Database, you will upload files to the Oracle Cloud Infrastructure (OCI) Object Storage, create a sample table, load data into the sample table from files on the OCI Object Storage, and explore the data.
Examine Data
There are 110 attributes in the dataset; below are descriptions of a few important ones. For a complete description of the attribute, see Rolling sales data.
| Attribute Name | Information |
|---|---|
| Borough | The borough in which the tax lot is located. |
| BoroCode | The borough in which the tax lot is located. |
| Year Built | The year construction of the building was completed. |
| Zip Code | A ZIP code that is valid for one of the addresses assigned to the tax lot. |
| Address | An address for the tax lot |
| BUILDING CLASS | A code describing the major use of structures on the tax lot. |
| HEALTH CENTER DISTRICT | The health center district in which the tax lot is located. Thirty health center districts were created by the City in 1930 to conduct neighborhood focused health interventions |
| LAND USE CATEGORY | A code for the tax lot's land use category |
| LOT AREA | Total area of the tax lot, expressed in square feet rounded to the nearest integer. |
| Building Area | The total gross area in square feet. Same as 'gross_sqft' |
| Gross Square Feet | The total area of all the floors of a building as measured from the exterior surfaces of the outside walls of the building, including the land area and space within any building or structure on the property. |
| Year Built | Year the structure on the property was built. |
| Sales Price | Price paid for the property. |
- Import Data
Import data into the database by using Object Storage (for Cloud).
Related Topics
Parent topic: Regression Use case