[postgis-users] How to Spatialize DB on PostGIS?

[Richard Greenwood]

Kristi,

I think that you should NOT "spatialize" your db. In MapInfo
terminology, "spatializing" your db allowed you to save point objects
in databases that were not spatial. PostGIS is already spatial, and
can store polylines and polygons. Did you attempt to "spatialize" your
db before using easy loader? That might explain why you are only able
to save points. You should be able to store points, lines, and
polygons, all in the same table, from MapInfo into PostGIS.

Check that you do not have constraints on your table that restrict it
to points. e.g. use Pgadmin and look at the constraints on the table.
Which versions of Postgres/PostGIS are you using?

I'd suggest that you post your questions on the MapInfo-L as well as
here, because your problem sounds like it may be on the MapInfo side
of the equation.

Good luck!
Rich


On Tue, Oct 6, 2009 at 11:29 PM, Endah Kristi <kristye_e at yahoo.com> wrote:
>
> Hi Richard,
>
> 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.
>
> Regards,
> Kristi
>
>
> --- On Tue, 10/6/09, Richard Greenwood <richard.greenwood at gmail.com> wrote:
>
> From: Richard Greenwood <richard.greenwood at gmail.com>
> Subject: Re: [postgis-users] How to Spatialize DB on PostGIS?
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Tuesday, October 6, 2009, 8:43 AM
>
>
>
> On Tue, Oct 6, 2009 at 6:22 AM, Endah Kristi <kristye_e at yahoo.com> wrote:
>>
>> Dear All,
>>
>> 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! =)
>
> Use "EasyLoader" in the MapInfo Tools > Tool Manager menu.
> Click "ODBC" button and select or create an ODBC connection to your PostGIS db
> Click "Map Catalog" which will create mapinfo.mapinfo_mapcatalog in your PostGIS db
> Select "Source Tables"
> Click "Upload"
>
> --
> Richard Greenwood
> richard.greenwood at gmail.com
> www.greenwoodmap.com
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



--
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com