Here are some superlatives that I’ve found in the data from the Washoe County Assessor’s office.

All buildings constructed before 1900 with the oldest first:

All buildings above 12 floors with the tallest first:

A 30 floor dental office? Looks like there might be some errors in the assessor data.

And the largest by square footage:

Not just a WAREHOUSE, it’s a MEGA WAREHOUSE!

A sub-query was used to remove duplicate parcels on the same address. To get the oldest buildings:

SELECT
    concat_ws(' ', p.number, p.direction, p.street) AS address,
    p.name,
    p.original_year AS year,
    p.type AS purpose
FROM (
    SELECT DISTINCT ON (number, direction, street) * FROM properties
        JOIN buildings ON buildings.parcel = properties.parcel
        ORDER BY number, direction, street, original_year
    ) p
WHERE
    p.original_year <> 0
    AND p.original_year < 1900
ORDER BY year NULLS LAST

To get the tallest:

SELECT
    concat_ws(' ', p.number, p.direction, p.street) AS address,
    p.name,
    p.original_year AS year,
    p.stories AS floors,
    p.type AS purpose
FROM (
    SELECT DISTINCT ON (number, direction, street) * FROM properties
    JOIN buildings ON buildings.parcel = properties.parcel
    WHERE number <> '0'
    ORDER BY
        number,
        direction,
        street,
        stories DESC NULLS LAST,
        name DESC NULLS LAST
    ) p
ORDER BY stories DESC NULLS LAST;

And the largest by square footage:

SELECT
    concat_ws(' ', p.number, p.direction, p.street) AS address,
    p.name, p.original_year AS year,
    p.stories AS floors,
    p.building_sqft AS sqft,
    p.type AS purpose
FROM (
    SELECT DISTINCT ON (number, direction, street) * FROM properties
    JOIN buildings ON buildings.parcel = properties.parcel
    ORDER BY
        number,
        direction,
        street,
        building_sqft DESC,
        name DESC NULLS LAST,
        original_year DESC NULLS LAST
    ) p
ORDER BY building_sqft DESC NULLS LAST