Notes

convert CZI to Sqlite-Image-Doc:

ConvCZI.exe -i Example_TMA1_Zeb1_SPRR2_Ck19_S100-1-1-1-1.czi -o Example.db

DB Browser for SQLite

EXPLAIN QUERY PLAN SELECT * FROM TILESINFO WHERE Dim_S=8

CREATE INDEX idx_C ON [Examples].[TILESINFO] (Dim_C)

SELECT id FROM TILESPATIAL_index WHERE minX>=50000 AND maxX<=60000 AND minY>=30000 AND maxY<=40000

---

Assuming a database with 1,000,000 - 1 tiles, where and . Here is a query to find T's for which there are NOT exactly 1000 tiles with different Z.

WITH tcount(tIndex,no) AS (SELECT Dim_T,COUNT(*) no_of_distinct_Ts
FROM TILESINFO
GROUP BY Dim_T)
SELECT *`
FROM tcount
WHERE  no <> 1000

(runtime: 100ms)

Above does not guarantee uniqueness of the Z's - may or not be necessary (depending on whether this would be allowed). This statement would

WITH tcount(tIndex,no) AS (SELECT Dim_T,COUNT(DISTINCT Dim_Z) no_of_distinct_Ts
FROM TILESINFO
GROUP BY Dim_T)
SELECT *
FROM tcount
WHERE  no <> 1000   

(runtime: 400ms)