<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Shao -</p>
<p>If you want to visualize spatial data in a Postgres/PostGIS
database using MapInfo as the viewing program you have to:</p>
<ul>
<li> Create a schema / table in : <b><span id="j_id0:j_id16"><span
id="j_id0:j_id49"><span class="ph filepath"
style="font-family: monospace;">MAPINFO.MAPINFO_MAPCATALOG.
</span></span></span></b><br>
</li>
<li>Populate it with information about your spatial tables in the
Postgres database. It contains approximately the same
information that's stored in the normal <b>public.geometry_columns</b>
view plus some extra MapInfo specific information. <br>
</li>
</ul>
<p>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.</p>
<p>If you use OGR2OGR to upload spatial data to Postgres, OGR2OGR <b>won't</b><b>
</b>create or populate the <b><span id="j_id0:j_id16"><span
id="j_id0:j_id49"><span class="ph filepath"
style="font-family: monospace;">MAPINFO.MAPINFO_MAPCATALOG</span></span></span></b>
meta-table for you. However, the Easyloader upload program is
capable of that. Finally, you can create and populate the <b><span
id="j_id0:j_id16"><span id="j_id0:j_id49"><span class="ph
filepath" style="font-family: monospace;">MAPINFO.MAPINFO_MAPCATALOG</span></span></span></b>
table manually.</p>
<p>You can download the Easyloader program from the Pitney Bowes
MapInfo Web site (Free download)<br>
</p>
<p>I suggest you read (and understand) the following article from
the MapInfo knowledge base:
<a class="moz-txt-link-freetext" href="http://support.pitneybowes.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG">http://support.pitneybowes.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG</a></p>
<pre class="moz-signature" cols="72">--
Med venlig hilsen / Kind regards
Bo Victor Thomsen
aestasGIS Denmark
</pre>
<p> <br>
</p>
<div class="moz-cite-prefix">Den 31-08-2019 kl. 17:41 skrev
Shaozhong SHI:<br>
</div>
<blockquote type="cite"
cite="mid:CA+i5Jwa4gVmtpK_rHrAG9dbkJ8-yG5Chd_7ituNuc=VM=eMFPA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Hi, Jeff,
<div>Thanks. We can upload and visualise in qgis.</div>
<div>But, I wonder where upload can include metadata.</div>
<div>If you use qgis, you can use the data, but when you click on
properties, you cannot find metadata.</div>
<div>How to upload metadata into postgis/postgresql?</div>
<div>Regards,</div>
<div>Shao<br>
<br>
On Friday, 30 August 2019, Jeff Norville <<a
href="mailto:jeff@jnorville.com" moz-do-not-send="true">jeff@jnorville.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>Hi Shao,</div>
<div><br>
</div>
<div>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 <a
href="http://gis.stackexchange.com" target="_blank"
moz-do-not-send="true">gis.stackexchange.com</a>,
including this guide:<br>
</div>
<div><a
href="https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008"
target="_blank" moz-do-not-send="true">https://www.slideshare.net/<wbr>peterhorsbollmoller/mapinfo-<wbr>professional-120-and-sql-<wbr>server-2008</a></div>
<div><br>
</div>
<div>Best,</div>
<div>Jeff<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Aug 27, 2019 at
9:03 PM Shaozhong SHI <<a
href="mailto:shishaozhong@gmail.com" target="_blank"
moz-do-not-send="true">shishaozhong@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hi, Tonis,
<div>We will bear that in mind. </div>
<div>A friend of mine says that the problem is not being
able to visualize what got into postgre.</div>
<div>Regards,</div>
<div>Shao<br>
<div><br>
On Tuesday, 27 August 2019, Tõnis Kärdi <<a
href="mailto:tonis.kardi@gmail.com" target="_blank"
moz-do-not-send="true">tonis.kardi@gmail.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
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.<br>
<br>
All the best,<br>
Tõnis<br>
<br>
On 27.08.19 15:44, Paolo Cavallini wrote:<br>
<blockquote class="gmail_quote" style="margin:0px
0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
Not that I know of, but you can use ogr or QGIS
for this.<br>
Cheers.<br>
<br>
On 27 August 2019 15:14:06 EEST, Shaozhong SHI
<<a href="mailto:shishaozhong@gmail.com"
target="_blank" moz-do-not-send="true">shishaozhong@gmail.com</a>>
wrote:<br>
<br>
Hi,<br>
Is there a MapInfo to PostGIS/PostgreSQL
loader? For instance, use<br>
psql.exe or something like that?<br>
<br>
Regards,<br>
<br>
Shao<br>
<br>
<br>
-- <br>
Sorry for being short<br>
<br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></blockquote>
</div>
</div>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></blockquote>
</div>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>