[mapguide-users] Databases PostGIS/ ArcSDE / Oracle spatial

[Berdel, Brian]

Thanks for the info Haris.  When you created a layer from a data source
using King.MsSQLSpatial, did it have point, line, and polygon styles to
set?  

The layer is a polygon layer, but it is showing all three types in the
layer editor and in the map legend...Am I missing something?

The layer displays correctly in the map, but it expands in the legend
thinking it has 3 types of geometry. (Even if I uncheck "Style a point
Symbol", etc.)

Brian  Berdel 
McMahon Associates, Inc. 
p: 215.283.9444
www.mcmtrans.com 

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Haris
Kurtagic
Sent: Friday, October 19, 2007 5:16 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Databases PostGIS/ ArcSDE / Oracle spatial

Hi Brian,

I found MsSqlSpatial good enough for one of our projects.
We are using King.MsSqlSpatial FDO provider and we do MapGuide view of
data and with AutoCAD editing of spatial data in SQL Sever using
King.MsSqlSpatial.
We used Fdo2Fdo to copy data from SHP to SqlServer.

Haris

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Berdel,
Brian
Sent: Wednesday, October 17, 2007 9:05 PM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Databases PostGIS/ ArcSDE / Oracle spatial

Hey Jason, 
I appreciate the quick response! For now I will only be accessing via
mapguide and ado.net

2008 will not be released until February 27th...And my deadline is a lot
sooner that to complete this project.  

For the most part I will only need to perform simple updates, and
reporting for now via asp.net and sql 2005 reporting.  I think I may
give MsSqlSpatial a try and see how it pans out.  Then hopefully it may
be an easy migration to 2008 in the spring...

Thanks, 

Brian  Berdel 
McMahon Associates, Inc. 
p: 215.283.9444
www.mcmtrans.com 

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Wednesday, October 17, 2007 2:45 PM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Databases PostGIS/ ArcSDE / Oracle spatial

Hi Brian,

What is your use case for the spatial database?  Do you need to access
it using more than just MapGuide?  

My understanding is that the MsSqlSpatial provider is functional but not
fully featured.  Perhaps Haris will be able to pop in and comment on
this.

Can you afford to wait until SQL Server 2008 comes out with native
spatial support?

PostGIS / PostgreSQL is an extremely capable and robust spatial database
system.  Its capabilities are similar to SQL Server 2005, apart from
some of the higher-end enterprise features.  The PostGIS provider is
still in early days, but is settling down nicely.  There are apparently
.Net drivers available for PostgreSQL; I don't know if this means that
it integrates into Visual Studio the same way that MS SQL does though.

Jason 

-----Original Message-----
From: Berdel, Brian
Subject: [mapguide-users] Databases PostGIS/ ArcSDE / Oracle spatial

We are going to migrate everything into spatial databases, but I wanted
to get some feedback from the group if possible on your experiences with
the different products. We currently have SQL 2005 and I am very
comfortable with it, from what I can tell the only spatial product that
is compatible is ArcSDE.  Is that true?  Also, I believe you need to
purchase the full ArcGIS server suite now. 

Secondly how is PostGIS / PostgreSQL? Pro's Con's?  

I develop in .NET so I would like to use SQL 2005 if possible. 
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users