Inconsistent values for indigenous lands

[andre-carvalho]

The values shown in the line graph are not added together when we have more than a fraction of an indigenous land. Related data is presented as individual.
Possible problem for conservation units as well.

One solution is to join this data before putting it into the redis database.

[andre-carvalho]

We have some identical names for different feature of TIs. Test the database using the SQL below.

• It needs more research to confirm the integrity of the data presentation.

WITH candidates AS (
	SELECT terrai_nom as nome, count(*) as tt
		FROM amazonia.ti
	GROUP BY 1
	ORDER BY 2 DESC
)
SELECT m.id, c.nome, ST_Transform(m.geoms, 4326) as geom
FROM amazonia.ti m, candidates c
WHERE c.tt>1
AND m.terrai_nom=c.nome
ORDER BY 1 DESC

[andre-carvalho]

The dashboard displays duplicate rows of data in CSV exported data and in the bar chart "Top10" for some special cases. This behavior is related to the original input data for UCs and TIs.

Reference video to illustrate:
https://terrabrasilis.dpi.inpe.br/download/terrabrasilis/terrabrasilis-about-dashboard-data-2024-04-19_14.56.59.mp4