<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"Times New Roman \(Body CS\)";
panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Georgia",serif;
font-variant:normal !important;
color:windowtext;
text-transform:none;
mso-contextual-alternates:no;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1199006094;
mso-list-template-ids:-1028481460;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">Dear Shao,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">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...<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">You e.g. now state "</span><span style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">In postgis, the term schema
is prominent, but it is not well explained or used</span><span style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">
<span lang="EN-GB">" – 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
<a href="https://en.wikipedia.org/wiki/Database_schema">https://en.wikipedia.org/wiki/Database_schema</a>
<o:p></o:p></span></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">yours,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US">Barend Köbben<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal">On 31/08/2019, 22:58, "postgis-users on behalf of Shaozhong SHI" <<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> on behalf of
<a href="mailto:shishaozhong@gmail.com">shishaozhong@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">Hi, <o:p></o:p></p>
<div>
<p class="MsoNormal">Interesting.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Surely, the fundamental is how the data is stored in postgresql and how it is accessed.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">If you come across more detailed articles, please let me know.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">In postgis, the term schema is prominent, but it is not well explained or used.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p>Shao -<o:p></o:p></p>
<p>If you want to visualize spatial data in a Postgres/PostGIS database using MapInfo as the viewing program you have to:<o:p></o:p></p>
<ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Create a schema / table in : <b><span style="font-family:"Courier New"">MAPINFO.MAPINFO_MAPCATALOG.
</span></b><o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
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.
<o:p></o:p></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.<o:p></o:p></p>
<p>If you use OGR2OGR to upload spatial data to Postgres, OGR2OGR <b>won't </b>create or populate the
<b><span style="font-family:"Courier New"">MAPINFO.MAPINFO_MAPCATALOG</span></b> meta-table for you. However, the Easyloader upload program is capable of that. Finally, you can create and populate the
<b><span style="font-family:"Courier New"">MAPINFO.MAPINFO_MAPCATALOG</span></b> table manually.<o:p></o:p></p>
<p>You can download the Easyloader program from the Pitney Bowes MapInfo Web site (Free download)<o:p></o:p></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.com/VFP05_KnowledgeWithSidebarHowTo?id=kA180000000PNiiCAG</a><o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Med venlig hilsen / Kind regards<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Bo Victor Thomsen<o:p></o:p></pre>
<pre>aestasGIS Denmark<o:p></o:p></pre>
<p> <o:p></o:p></p>
<div>
<p class="MsoNormal">Den 31-08-2019 kl. 17:41 skrev Shaozhong SHI:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hi, Jeff, <o:p></o:p></p>
<div>
<p class="MsoNormal">Thanks. We can upload and visualise in qgis.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">But, I wonder where upload can include metadata.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">If you use qgis, you can use the data, but when you click on properties, you cannot find metadata.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">How to upload metadata into postgis/postgresql?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Shao<br>
<br>
On Friday, 30 August 2019, Jeff Norville <<a href="mailto:jeff@jnorville.com" target="_blank">jeff@jnorville.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal">Hi Shao,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008" target="_blank">https://www.slideshare.net/peterhorsbollmoller/mapinfo-professional-120-and-sql-server-2008</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Jeff<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Aug 27, 2019 at 9:03 PM Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Hi, Tonis, <o:p></o:p></p>
<div>
<p class="MsoNormal">We will bear that in mind. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">A friend of mine says that the problem is not being able to visualize what got into postgre.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Shao<o:p></o:p></p>
<div>
<p class="MsoNormal"><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:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">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:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt">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>
_______________________________________________<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/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
<p class="MsoNormal">_______________________________________________<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/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
</div>
</blockquote>
</div>
</div>
</body>
</html>