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:
- is it better to use 32bit or 64bit (multiarch) *buntu? I do not know whether 64bit architecture brings some advantage here...
- 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
- can I make filtered data exports from the database in something like csv or shp?
- 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)