Hey! This content applies only to previous CARTO products

Please check if it's relevant to your use case. On October 2021 we released a new version of our platform.
You can learn more and read the latest documentation at docs.carto.com

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:

  numeric_column/ST_Area(the_geom) as norm_column