[mapguide-users] Spatial Data Formats Best Practice

[Kenneth Skovhede, GEOGRAF A/S]

GISDOTNET skrev:
> Kenneth,
>
> Thanks for the response. I am using FDO which is how I got the OGR and
> PostGIS providers configured. It's great that I don't have to convert;
> however, I started this thread to determine which format, if any, was
> preferred or best practice for use with MGOS from a performance,
> functionality, usability, etc. standpoint.
>   
I see, I have no good advice in that direction.
I have tested that TAB files over OGR outperforms SDF files,
especially if I remove unused columns.

Unfortunately, it is not as stable as I would like.
I'm guessing that SDF is the most stable one, as it was designed for FDO.
> What do you mean by "single polygon" when you wrote "I know the OGR provider
> reports having point+line+polygon if the table contains a single polygon."
> The table is nothing but polygons, or lines, or points. Shouldn't the OGR or
> PostGIS provider be able to distinguish the geometry from the designated
> geometry column? I'll look into MapGuide Maestro and see if that helps.
>
>   
If I have a table with only points, the OGR provider reports that it 
contains geometry of type point.
If I add a line, it reports that it contains points and lines.
If I make a new table and add a single polygon, it reports having 
points, lines and polygons.

You can view what the provider reports if you press the "Preview" button 
while
having the Featuresource open. (on the left side).
> I appreciate the education.
>
> Aaron
>   
Regards, Kenneth Skovhede, GEOGRAF A/S