<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'">Hi Richard,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'">I’ve never attempted to “spatialize” my db before using Easy Loader (because I don’t know how to do that, hehe).<o:p></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'">I don’t have constraints on my table. I’m using PostGIS-pg83-1.3.6-1 and <SPAN class=yshortcuts>PostgreSQL</SPAN> v8.3.7-1.<o:p></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'">I’ve asked this to PBBI APAC Sydney, and Jesse Hoobler and engineering team told that this problem appeared because I’m not hitting the spatialized database, database has to be spatialized one. They told this is outside of MapInfo domain. So I thought I should do something in PostGIS. I’ll try to ask on the MapInfo-L, I don’t join yet.<o:p></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'">A long time ago, I’ve found the same problem on MapInfo Spatialware, the polygon & polyline can’t be uploaded properly into SQL Server before it’s spatialized. Then I run a script to spatialize that on SQL Server, and I was able to upload them properly. So I thought that PostGIS is the same problem, but if I’m wrong, maybe any advice for me?<o:p></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=IN style="COLOR: black; FONT-FAMILY: 'Courier New'">Kristi<o:p></o:p></SPAN></DIV>
<DIV> </DIV>
<DIV><BR><BR>--- On <B>Wed, 10/7/09, Richard Greenwood <I><richard.greenwood@gmail.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><BR>From: Richard Greenwood <richard.greenwood@gmail.com><BR>Subject: Re: [postgis-users] How to Spatialize DB on PostGIS?<BR>To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>Date: Wednesday, October 7, 2009, 9:55 AM<BR><BR>
<DIV class=plainMail>Kristi,<BR><BR>I think that you should NOT "spatialize" your db. In MapInfo<BR>terminology, "spatializing" your db allowed you to save point objects<BR>in databases that were not spatial. PostGIS is already spatial, and<BR>can store polylines and polygons. Did you attempt to "spatialize" your<BR>db before using easy loader? That might explain why you are only able<BR>to save points. You should be able to store points, lines, and<BR>polygons, all in the same table, from MapInfo into PostGIS.<BR><BR>Check that you do not have constraints on your table that restrict it<BR>to points. e.g. use Pgadmin and look at the constraints on the table.<BR>Which versions of Postgres/PostGIS are you using?<BR><BR>I'd suggest that you post your questions on the MapInfo-L as well as<BR>here, because your problem sounds like it may be on the MapInfo side<BR>of the equation.<BR><BR>Good luck!<BR>Rich<BR><BR><BR>On Tue, Oct 6, 2009 at 11:29 PM, Endah
Kristi <<A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=kristye_e@yahoo.com" ymailto="mailto:kristye_e@yahoo.com">kristye_e@yahoo.com</A>> wrote:<BR>><BR>> Hi Richard,<BR>><BR>> I mean that I've tried to upload that using Easy Loader > ODBC > Map Catalog also created > Upload into PostGIS -- but there are warning messages for polyline & polygon objects that they become points (please find the attachment). When I downloaded it in MapInfo for the data that I've uploaded into PostGIS, the polyline & polygon objects become points. There is no problem with the point object. There are problems for graphical objects, no problem to edit the attribute data (link to PostGIS). So I think, does it need we should do spatialize db in PostGIS? I don't know how to do that. Or maybe there is any setting that I should do in MIPro or PostGIS? Please advice.<BR>><BR>> Regards,<BR>>
Kristi<BR>><BR>><BR>> --- On Tue, 10/6/09, Richard Greenwood <<A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=richard.greenwood@gmail.com" ymailto="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</A>> wrote:<BR>><BR>> From: Richard Greenwood <<A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=richard.greenwood@gmail.com" ymailto="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</A>><BR>> Subject: Re: [postgis-users] How to Spatialize DB on PostGIS?<BR>> To: "PostGIS Users Discussion" <<A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=postgis-users@postgis.refractions.net" ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>><BR>> Date: Tuesday, October 6, 2009, 8:43 AM<BR>><BR>><BR>><BR>> On Tue, Oct 6, 2009 at 6:22 AM, Endah Kristi <<A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=kristye_e@yahoo.com"
ymailto="mailto:kristye_e@yahoo.com">kristye_e@yahoo.com</A>> wrote:<BR>>><BR>>> Dear All,<BR>>><BR>>> Apologies first, I'm not familiar with PostGIS/PostgreSQL. Could you please explain to me how to spatialize the database on PostGIS? I've installed PostGIS v1.3 and PostgreSQL v8.3.1 for MapInfo Pro v10, but I can't upload .TAB files to PostGIS successfully (for polygon & polyline objects -- it become points when uploaded), whereas MIPro v10 supports read/write for PostGIS. I think it needs spatialize db first. Appreciate if anyone here can advise me how to do that on PostGIS, the steps and its script. Thanks in advance! =)<BR>><BR>> Use "EasyLoader" in the MapInfo Tools > Tool Manager menu.<BR>> Click "ODBC" button and select or create an ODBC connection to your PostGIS db<BR>> Click "Map Catalog" which will create mapinfo.mapinfo_mapcatalog in your PostGIS db<BR>>
Select "Source Tables"<BR>> Click "Upload"<BR>><BR>> --<BR>> Richard Greenwood<BR>> <A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=richard.greenwood@gmail.com" ymailto="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</A><BR>> www.greenwoodmap.com<BR>><BR>> -----Inline Attachment Follows-----<BR>><BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> <A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=postgis-users@postgis.refractions.net" ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>> <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>><BR>><BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> <A
href="http://us.mc1114.mail.yahoo.com/mc/compose?to=postgis-users@postgis.refractions.net" ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>> <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>><BR><BR><BR><BR>--<BR>Richard Greenwood<BR><A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=richard.greenwood@gmail.com" ymailto="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</A><BR>www.greenwoodmap.com<BR>_______________________________________________<BR>postgis-users mailing list<BR><A href="http://us.mc1114.mail.yahoo.com/mc/compose?to=postgis-users@postgis.refractions.net" ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></DIV></BLOCKQUOTE></td></tr></table><br>