MapInfo SQL Select - used to return Object Types (point, line...etc)

Video #76 In this video I use MapInfo Pro to return object types: POINT, LINE and REGION using the standard SQL Select dialog. - Some features are drawn in the Cosmetic Layer - Those objects are saved to a MapInfo TAB - I then use UPDATE COLUMN to add ROWID to the new layer For an overall report of all types use: Select ID, str$(obj), Count(*) from mytable group by 2 To find out what each individual record object type is, then enhance the GROUP BY with an existing unique identifier: Select ID,str$(obj), Count(*) from mytable group by 1,2 MapInfo can store multiple geometry types in the TAB format so this might be useful when you want to dissect such a table of features.