Hi,<div>Interesting.</div><div>Surely, the fundamental is how the data is stored in postgresql and how it is accessed.</div><div><br></div><div>If you come across more detailed articles, please let me know.</div><div><br></div><div>In postgis, the term schema is prominent, but it is not well explained or used.</div><div>Regards,</div><div>Shao <br><br>On Saturday, 31 August 2019, Bo Victor Thomsen <<a href="mailto:bo.victor.thomsen@gmail.com">bo.victor.thomsen@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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><span><span 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><span><span 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><span><span 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 href="http://support.pitneybowes.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG" target="_blank">http://support.pitneybowes.<wbr>com/VFP05_<wbr>KnowledgeWithSidebarHowTo?id=<wbr>kA180000000PNiiCAG</a></p>
<pre cols="72">--
Med venlig hilsen / Kind regards
Bo Victor Thomsen
aestasGIS Denmark
</pre>
<p> <br>
</p>
<div>Den 31-08-2019 kl. 17:41 skrev
Shaozhong SHI:<br>
</div>
<blockquote type="cite">
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" target="_blank">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">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">https://www.slideshare.net/pet<wbr>erhorsbollmoller/mapinfo-profe<wbr>ssional-120-and-sql-server-<wbr>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">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">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">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">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a><br>
<br>
</blockquote>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a></blockquote>
</div>
</div>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a></blockquote>
</div>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>______________________________<wbr>_________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre cols="72"></pre>
</div>
</blockquote></div>