Skip to content
Pillow Documentation

Dimensions

All area and size measurements use metric units (square meters, hectares, meters) for consistency across international markets.

Total Area

Section titled “Total Area”

square_meters_total

Section titled “square_meters_total”
  • Type: DOUBLE
  • Description: Total floor area of the property in square meters
  • Example: 150.0
  • Required: No
  • Indexed: Yes
  • Unit: Square meters (sqm)
  • Use Case: Primary size metric for filtering and comparison

square_meters_living

Section titled “square_meters_living”
  • Type: DOUBLE
  • Description: Living area (habitable space) in square meters
  • Example: 130.0
  • Required: No
  • Unit: Square meters
  • Note: Excludes garages, storage, unfinished areas

Heated & Cooled Areas

Section titled “Heated & Cooled Areas”

square_meters_heated

Section titled “square_meters_heated”
  • Type: DOUBLE
  • Description: Area with heating system in square meters
  • Example: 140.0
  • Required: No

square_meters_cooled

Section titled “square_meters_cooled”
  • Type: DOUBLE
  • Description: Area with cooling/air conditioning in square meters
  • Example: 130.0
  • Required: No

Finished vs Unfinished

Section titled “Finished vs Unfinished”

square_meters_finished_above_grade

Section titled “square_meters_finished_above_grade”
  • Type: DOUBLE
  • Description: Finished area above ground level
  • Example: 120.0
  • Required: No

square_meters_finished_below_grade

Section titled “square_meters_finished_below_grade”
  • Type: DOUBLE
  • Description: Finished area below ground level (finished basement)
  • Example: 30.0
  • Required: No

square_meters_unfinished_above_grade

Section titled “square_meters_unfinished_above_grade”
  • Type: DOUBLE
  • Description: Unfinished area above ground level
  • Example: 10.0
  • Required: No

square_meters_unfinished_below_grade

Section titled “square_meters_unfinished_below_grade”
  • Type: DOUBLE
  • Description: Unfinished area below ground level (unfinished basement)
  • Example: 20.0
  • Required: No

Specific Areas

Section titled “Specific Areas”

square_meters_garage

Section titled “square_meters_garage”
  • Type: DOUBLE
  • Description: Garage area in square meters
  • Example: 25.0
  • Required: No

square_meters_storage

Section titled “square_meters_storage”
  • Type: DOUBLE
  • Description: Storage area in square meters
  • Example: 5.0
  • Required: No

square_meters_basement

Section titled “square_meters_basement”
  • Type: DOUBLE
  • Description: Total basement area (finished + unfinished)
  • Example: 50.0
  • Required: No

square_meters_attic

Section titled “square_meters_attic”
  • Type: DOUBLE
  • Description: Attic area in square meters
  • Example: 15.0
  • Required: No

Lot Size

Section titled “Lot Size”

lot_size_sqm

Section titled “lot_size_sqm”
  • Type: DOUBLE
  • Description: Total lot/land area in square meters
  • Example: 400.0
  • Required: No
  • Indexed: Yes
  • Unit: Square meters

lot_size_hectares

Section titled “lot_size_hectares”
  • Type: DOUBLE
  • Description: Total lot/land area in hectares
  • Example: 0.04
  • Required: No
  • Unit: Hectares (1 hectare = 10,000 sqm)
  • Use Case: Large properties, rural land

lot_dimensions

Section titled “lot_dimensions”
  • Type: VARCHAR(100)
  • Description: Lot dimensions as text (e.g., “20m x 30m”)
  • Example: "20m x 30m"
  • Required: No

lot_shape

Section titled “lot_shape”
  • Type: VARCHAR(50)
  • Description: Shape of the lot
  • Values: "rectangular", "irregular", "corner", "cul_de_sac"
  • Example: "rectangular"
  • Required: No

frontage_meters

Section titled “frontage_meters”
  • Type: DOUBLE
  • Description: Street frontage width in meters
  • Example: 12.0
  • Required: No
  • Unit: Meters

depth_meters

Section titled “depth_meters”
  • Type: DOUBLE
  • Description: Lot depth from street to back in meters
  • Example: 30.0
  • Required: No
  • Unit: Meters

Usage Examples

Section titled “Usage Examples”

Filter by Size Range

Section titled “Filter by Size Range”
SELECT * FROM properties
WHERE square_meters_total BETWEEN 100 AND 200
AND status = 'active'
ORDER BY square_meters_total;

Calculate Price Per Square Meter

Section titled “Calculate Price Per Square Meter”
SELECT
  id,
  price_current,
  square_meters_total,
  price_current / square_meters_total AS price_per_sqm
FROM properties
WHERE square_meters_total > 0
ORDER BY price_per_sqm;

Find Large Lots

Section titled “Find Large Lots”
SELECT * FROM properties
WHERE lot_size_sqm >= 1000
ORDER BY lot_size_sqm DESC;

Compare Finished vs Total Area

Section titled “Compare Finished vs Total Area”
SELECT
  id,
  square_meters_total,
  square_meters_finished_above_grade +
    COALESCE(square_meters_finished_below_grade, 0) AS total_finished,
  square_meters_total -
    (square_meters_finished_above_grade +
     COALESCE(square_meters_finished_below_grade, 0)) AS unfinished_area
FROM properties
WHERE square_meters_total > 0;

Find Properties with Basements

Section titled “Find Properties with Basements”
SELECT * FROM properties
WHERE square_meters_basement > 0
ORDER BY square_meters_basement DESC;

Unit Conversions

Section titled “Unit Conversions”

Square Meters to Square Feet

Section titled “Square Meters to Square Feet”
-- 1 sqm = 10.764 sqft
SELECT
  square_meters_total,
  square_meters_total * 10.764 AS square_feet
FROM properties;

Hectares to Acres

Section titled “Hectares to Acres”
-- 1 hectare = 2.471 acres
SELECT
  lot_size_hectares,
  lot_size_hectares * 2.471 AS acres
FROM properties;

Best Practices

Section titled “Best Practices”
  1. Always use metric units: Square meters for consistency
  2. Set square_meters_total: Primary size metric
  3. Distinguish finished vs unfinished: Helps buyers understand usable space
  4. Calculate lot_size_hectares: For large properties (1+ hectare)
  5. Validate relationships: Ensure square_meters_total >= square_meters_living
Section titled “Related Attributes”