SQLite Forum

Recursive CTE
Login
If geopoly_area is +ve then the polygon is "enclosing"  
If geopoly_area is -ve then the polygon is a "hole"  
If geopoly_area is NULL then the polygon is not a polygon  
If geopoly_area is 0 then the polygon is a point  

No idea about spatialite however it probably has documentation that would answer the question.