I am working on automated land parcel identification and would like to extract road/river/thin and linear-like polygons from a massive dataset. For now, the only index I can get some answers from is the ratio between the perimeter and the area of the polygons. The results are Ok, but I need to "clean" them.
How do I find the shape index, compactness or assymetry with PostgreSQL/PostGIS? I need a solution for vector data only.