SELECT
*
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'continent'
    LIMIT 1
    ) AS continent
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'area|country|territory'
    LIMIT 1
    ) AS "area|country|territory"
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'region|state|province'
    LIMIT 1
    ) AS "region|state|province"
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'county'
    LIMIT 1
    ) AS county_
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'quadrangle'
    LIMIT 1
    ) AS quadrangle
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'Geographic Name'
    LIMIT 1
    ) AS "Geographic Name"
, (SELECT "placeName"
    FROM place
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
    WHERE
    place."PLOTPLACE_ID" = plot."PLOT_ID"
    AND "placeSystem" = 'River Basin'
    LIMIT 1
    ) AS "River Basin"
FROM plot
