Grow your YouTube views, likes and subscribers for free
POSTGIS query SQL Calcolo area con funzione ST_Area() by E-mi S
SELECT id, provincia, ST_Area(geom)/10000 AS hectares
FROM province
ORDER BY provincia;
SELECT provincia, ROUND(SUM(ST_Area(geom)/1000000)::numeric,0) AS km2
FROM province
GROUP BY provincia;
SELECT id, provincia, ST_Area(geom)/10000 AS hectares
FROM province WHERE provincia='LI';
by Emi S
![Data Modeling for Power BI [Full Course]](https://i.ytimg.com/vi/MrLnibFTtbA/mqdefault.jpg)
Recommended
