Mapping FGF Objects in a SQLite Database to MapInfo Objects - MapInfo_Pro - 2023

MapInfo Pro Help

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Help
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:39:16.995549

The OSGeo FDO Data Access Technology stores geometry data to a SQLite database as FGF (Feature Geometry Format) objects. This section lists the object mappings between FGF (Feature Geometry Format) objects in a SQLite database to MapInfo objects. This information is helpful when creating object data that you plan to share with other applications, because it will help you understand how an object will be handled in another application.

The mappings between FGF object types and MapInfo Object types are:

FGF Object MapInfo Object

FGF_Geom_None

P_NULL

FGF_Geom_Point

P_POINT

FGF_Geom_MultiPoint

P_MPOINT

FGF_Geom_LineString

P_PLINE

FGF_Geom_MultiLineString

P_PLINE with multiple parts

FGF_Geom_Polygon

P_REGION with zero or more holes

FGF_Geom_MultiPolygon

P_REGION with multiple parts, each with zero or more holes

FGF_Geom_MultiGeometry

P_COLLECTION

FGF_Geom_CurveString

P_PLINE

FGF_Geom_MultiCurveString

P_PLINE with multiple parts

FGF_Geom_CurvePolygon

P_REGION

FGF_Geom_MultiCurvePolygon

P_REGION with multiple parts

The mappings between MapInfo object types and FGF object types are:

MapInfo Object FGF Object

P_POINT

FGF_Geom_Point

P_LINE

FGF_Geom_LineString

P_ARC

FGF_Geom_LineString

P_PLINE

FGF_Geom_LineString or FGF_Geom_MultiLineString if multiple parts

P_REGION

FGF_Geom_Polygon - One exterior polygon. If it has multiple parts then each part is defined in a ring.

FGF_Geom_MultiPolygon - More than one exterior polygon. If each exterior polygon has multiple parts then each part is defined in a ring

P_RECT

FGF_Geom_Polygon

P_ROUNDRECT

FGF_Geom_Polygon

P_ELLIPSE

FGF_Geom_Polygon

P_MPOINT

FGF_Geom_MultiPoint

P_COLLECTION

FGF_Geom_MultiGeometry

Unsupported MapInfo objects are:

  • P_NULL
  • P_TEXT
  • P_WINDOWPORT
  • P_PIECHART
  • P_BARCHART

When creating arcs, ellipses, or rounded rectangles in MapInfo Pro and then saving them back to a SQLite table, you may be asked to convert them to supported FGF object types. The MapInfo objects convert from arc to polyline, ellipse to polygon, and rounded rectangle to polygon.