MapInfo Pro lets you select which tables in a SQLite database to open, and gives you the option to set display styles, and column and row filters for the tables.
MapInfo Pro works with existing SQLite databases and it lets you create new SQLite databases. You can open a table in a SQLite database and save your edits, and you can save your new or existing MapInfo tables to a SQLite Database (*.sqlite).
To open one or more tables in a SQLite database:
- On the HOME tab, in the File group, on the Open list, click Table.
- In the Open dialog box, from the Files of type list, select SQLite Database (*.sqlite).
- From the Look in list, select the folder location of the database that you want to access.
- From the files list, select the database to open.
To select more than one database file in the Open dialog box, press the Ctrl or Shift key while selecting files.
- Click Open. The Select One or More Tables to Open dialog box opens.
- In the Database Tables list, select a table to open by adding a check mark beside the table name.
You can select one or more tables. Only the tables that have a check mark beside them will open.
- Optionally, select how you want the data to display on the map by selecting (highlighting) the table name and clicking Style.
This opens the Change Table Object Style dialog box where you can specify the display style for geometry (spatial object types), such as symbols, lines, and regions in the table. The custom styles that you set only apply to the table that you highlighted (whether it has a check mark beside it or not).
To select more than one table, press Ctrl while selecting table names. Your style choices are made to all of the tables that you select (that are highlighted in the Database Tables list).
- From the View list, select how you want to open the tables.
Select New Mapper or Current Mapper to open them in a Map window, or Browser to open them in a Browser window to see the table contents.
- Click OK.
The table, or tables, from your selection open in MapInfo Pro.
If you choose to open more than one SQLite database (.sqlite file) in the Open dialog box, then each database opens a Select One or More Tables to Open dialog box. Repeat the previous steps for each database.
For additional information, see:
Mapping FDO (SQLite) Coordinate Systems to MapInfo Coordinate Systems
If MapInfo Pro has an issue identifying a coordinate system when it opens a table in a SQLite database, then it opens the Choose Projection dialog box. In this dialog box, you would associate a coordinate system with the table. MapInfo Pro then saves this information to the TAB file for the table and reads it every time you open the table.
For very experienced users who understand how to work with MapBasic strings and coordinate systems, there is an advanced customization option. When MapInfo Pro opens a SQLite table, it converts the SQLite coordinate system definition into a MapBasic CoordSys (coordinate system) string. MapInfo Pro installs with a file called MapInfoCoordinateSystemSet.xml where you can customize the translations from SQLite Well Known Text (WKT) coordinate system definitions to MapBasic CoordSys (coordinate system) strings and back.