I have a plenty of point measurements - thousands of points with date/time, gps, measured values etc. I would like to make it possible to put all my particular datasets (can decide whether shp or something like CSV) somewhere and then to be able to load the points in QGIS (my prefered app) and possibly also to newest MapInfo Pro (colleague uses it) on PCs in our local network - but not always all the points but for example particular date range only.

I will have one linux desktop (probably *buntu) which I can use as server and already tried PostGIS some time ago. My questions are following:

  1. is it better to use 32bit or 64bit (multiarch) *buntu? I do not know whether 64bit architecture brings some advantage here...
  2. is PostgreSQL/PostGIS good solution or should I look for something else?
    • according to the internet - even MapInfo is able to read the data from it
  3. can I make filtered data exports from the database in something like csv or shp?
  4. is it possible to define some script loading a bunch of files (same structure and CRS) into DB just by running it? (looks like I could use this maybe)

closed as too broad by PolyGeo May 23 at 23:14

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


Postgis is surely a good idea for your task. You can use SQL queries to filter the data to a dataset you want.

Another option is to use a spatialite database. The data will be stored in one single file, which makes it more portable (either for homework, different OS or backup reasons). Spatialite uses SQL queries in the same way.

  • Just check which version of Mapinfo is in question, because Mapinfo does not support latest versions of postgresql/postgis. Look my answer here gis.stackexchange.com/questions/103146/… – sys49152 Jan 21 '15 at 12:18
  • I know Spatialite but I need to make the DB accessible for about 3 computers and it seems to be really slow have Czech Republic OSM data in it. So I rather would move the DB processing to other PC. – Juhele Jan 21 '15 at 12:19
  • @sys49152: we have annual maintenance for our one license so it will be latest MapInfo Pro. So I rather should use older postgresql/postgis? – Juhele Jan 21 '15 at 12:21
  • The whole countries OSM data is indeed too much for economic working with spatialite. – AndreJ Jan 21 '15 at 12:46
  • From reference.mapinfo.com/software/mapinfo_pro/english/12.5/… • PostgreSQL 9.0.3 with PostGIS 1.5 • PostgreSQL 9.2.2 with PostGIS 2.0 In order for MapInfo Professional to access a remote database, you must install a client or driver. The following are ODBC drivers that MapInfo Professional supports: • PostgreSQL ANSI ODBC driver 9.01.02 (which comes with PostgreSQL 2.0.x) – sys49152 Jan 21 '15 at 12:49

You could use PostgreSQL/PostGIS. QGIS support is not in question.

As for latest MapInfo v12.5 supported versions and ODBC drivers are:


enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.