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.