[postgis-users] Is there a MapInfo to PostGIS/PostgreSQL loader?

Sun Sep 1 03:28:35 PDT 2019

Dear Shao,

I notice you have been asking a great many questions on this forum. That is great because it means you are interested in and want to learn about PostGIS.

However, I would advise you to also do a bit of searching and learning on your own, especially in basic database technology. Otherwise people might get tired of explaining everything...

You e.g. now state "In postgis, the term schema is prominent, but it is not well explained or used " – It is explained very well in may places, schema is a concept central to any database, and you can find loads on information, just a search on "database schema" finds useful info such as https://en.wikipedia.org/wiki/Database_schema

yours,
Barend Köbben

On 31/08/2019, 22:58, "postgis-users on behalf of Shaozhong SHI" <postgis-users-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org> on behalf of shishaozhong at gmail.com<mailto:shishaozhong at gmail.com>> wrote:

Hi,
Interesting.
Surely, the fundamental is how the data is stored in postgresql and how it is accessed.

If you come across more detailed articles, please let me know.

In postgis, the term schema is prominent, but it is not well explained or used.
Regards,
Shao

On Saturday, 31 August 2019, Bo Victor Thomsen <bo.victor.thomsen at gmail.com<mailto:bo.victor.thomsen at gmail.com>> wrote:

Shao -

If you want to visualize spatial data in a Postgres/PostGIS database using MapInfo as the viewing program you have to:

  *   Create a schema / table in : MAPINFO.MAPINFO_MAPCATALOG.
  *   Populate it with information about your spatial tables in the Postgres database. It contains approximately the same information that's stored in the normal public.geometry_columns view plus some extra MapInfo specific information.

MapInfo uses this table to get information about the different spatial tables in the database, so it has to be present and populated with the correct information.

If you use OGR2OGR to upload spatial data to Postgres, OGR2OGR won't create or populate the MAPINFO.MAPINFO_MAPCATALOG meta-table for you. However,  the Easyloader upload program is capable of that. Finally, you can create and populate the MAPINFO.MAPINFO_MAPCATALOG table manually.

You can download the Easyloader program from the Pitney Bowes MapInfo Web site (Free download)

I suggest you read (and understand) the following article from the MapInfo knowledge base: http://support.pitneybowes.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG

--

Med venlig hilsen / Kind regards

Bo Victor Thomsen

aestasGIS Denmark

Den 31-08-2019 kl. 17:41 skrev Shaozhong SHI:
Hi, Jeff,
Thanks.  We can upload and visualise in qgis.
But, I wonder where upload can include metadata.
If you use qgis, you can use the data, but when you click on properties, you cannot find metadata.
How to upload metadata into postgis/postgresql?
Regards,
Shao

On Friday, 30 August 2019, Jeff Norville <jeff at jnorville.com<mailto:jeff at jnorville.com>> wrote:
Hi Shao,

I generally use QGIS to visualize postgis / postgresql loads - but mostly because it's free. But if you're using MapInfo it seems the EasyLoader may be the way forward - there are some posts about this over on gis.stackexchange.com<http://gis.stackexchange.com>, including this guide:
https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008

Best,
Jeff

On Tue, Aug 27, 2019 at 9:03 PM Shaozhong SHI <shishaozhong at gmail.com<mailto:shishaozhong at gmail.com>> wrote:
Hi, Tonis,
We will bear that in mind.
A friend of mine says that the problem is not being able to visualize what got into postgre.
Regards,
Shao

On Tuesday, 27 August 2019, Tõnis Kärdi <tonis.kardi at gmail.com<mailto:tonis.kardi at gmail.com>> wrote:
Hi,

one option would be to use ogr2ogr. And I can't remember exactly but I think MapInfo's EasyLoader could do that very fine aswell.

All the best,
Tõnis

On 27.08.19 15:44, Paolo Cavallini wrote:
Not that I know of, but you can use ogr or QGIS for this.
Cheers.

On 27 August 2019 15:14:06 EEST, Shaozhong SHI <shishaozhong at gmail.com<mailto:shishaozhong at gmail.com>> wrote:

    Hi,
    Is there a MapInfo to PostGIS/PostgreSQL loader?  For instance, use
    psql.exe or something like that?

    Regards,

    Shao

--
Sorry for being short

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________

postgis-users mailing list

postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>

https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190901/51f51e83/attachment.html>