Questions  /  Working with Data  /  PostGIS

How can I normalize my numeric values in Builder?

Learn how to normalize dataset columns by area with PostGIS functions.

When preparing polygon data layers in CARTO, normalize your data is a good cartographic method in order to create meaningul visualizations. CARTO users can normalize raw data by area, by total (like population) or by other thematic value.

For instance, in order to normalize a column value by its area, it would be necessary to apply a SQL query similar to this one, thus using ST_Area PostGIS function:

SELECT
  *,
  numeric_column/ST_Area(the_geom) as norm_column
FROM
  table