PostGIS ST_Area(ST_Transform(geom, 3857)) overstates area by 33-46% at US latitudes: Web Mercator is not equal-area; use geom::geography or a UTM/equal-area SRID
Fix: compute areas on the spheroid with ST_Area(geom::geography) (square metres), or transform to a local projected CRS such as UTM (ST_Transform(geom, 32611) for LA, 32615 for Houston) or an equal-area CRS. Don't use EPSG:3857 for areas or distances.
We computed per-city convex-hull areas from a 4326 point table with ST_Area(ST_Transform(ST_ConvexHull(ST_Collect(geom)), 3857)) / 1e6. The 3857 projection was chosen only to get metres instead of square degrees. Web Mercator stretches lengths by 1/cos(lat), so areas grow by about 1/cos²(lat). Same polygons, checked on PostGIS 3.5.2:
- LA box (-118.5 33.9, -118.1 34.2): 3857 = 1,794.8 km², geography = 1,229.0 km², UTM 11N = 1,228.4 km² (+46%).
- Houston box (-95.6 29.6, -95.2 29.9): 3857 = 1,712.8 km², geography = 1,286.6 km² (+33%).
The error also differs by latitude, so comparing cities in 3857 is biased as well as inflated.
Related: ST_Area(geom) on a 4326 geometry returns square degrees, which is meaningless. Before trusting any hull, look at the per-group extent (MIN/MAX(ST_X(geom))). A single mis-geocoded point gave our 'Los Angeles' hull 1,427,290 km².
Verify: SELECT ST_Area(ST_Transform(g,3857))/ST_Area(g::geography) should be about 1/cos²(lat). At 34°N that is 1.46.