[mapguide-users] SQL Server 2008 Spatial Data not Displaying in Open Source Viewers

[Brent Robinson]

One thing to check would be the extents in the datastore.

If the f_spatialcontextgroup table is present then the upper values are in the xmax and ymax columns. If these are not 0 then it would be a bug.

Otherwise, the extents are set from the extents of the spatial index for the column for the layer's geometry property. If you look at the properties for the index, through SQL Server Management Studio, they are on the Spatial tab. If the column type is geography, the extents are always listed as (0,0) (0,0). However, in this case the SQLServerSpatial provider should be defaulting them to the entire world (-180,-90) (180, 90).

I did some quick tests with an LL83 layer and the initial extents got automatically calculated. I'm working with the latest development version of the provider. If the extents in your datastore look ok but they're still not showing up in Studio, I could send you my provider to see if it makes a difference.

I also got an "Undeliverable" message from Mail Delivery System but not sure why.

From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rock Beans
Sent: Wednesday, July 16, 2008 5:31 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] SQL Server 2008 Spatial Data not Displaying in Open Source Viewers

I figured out the issue. The Initial Extents are not calculating automatically. I had to manually enter in the Upper/Lower X/Y values then everything worked as planned. This would be a nice feature as other layers when put into a new map automatically figure these things out. So basically none of the previews work till you get to the map and set these values. There would be no way to preview a layer with this issue. Is this a bug, if so should it be added to bug trac?

The Rock


PS Why do I get this every reply?
Mail Delivery System
This is the Postfix program at host lists.osgeo.org<http://lists.osgeo.org/>.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.


On Wed, Jul 16, 2008 at 1:55 PM, Brent Robinson <brent.robinson at autodesk.com<mailto:brent.robinson at autodesk.com>> wrote:

Hi Rock,



Do any messages show up in Error.log?



Brent.



From: mapguide-users-bounces at lists.osgeo.org<mailto:mapguide-users-bounces at lists.osgeo.org> [mailto:mapguide-users-bounces at lists.osgeo.org<mailto:mapguide-users-bounces at lists.osgeo.org>] On Behalf Of Rock Beans
Sent: Wednesday, July 16, 2008 2:33 PM
To: MapGuide Users Mail List
Subject: [mapguide-users] SQL Server 2008 Spatial Data not Displaying in Open Source Viewers



I have MapGuide Studio 2009 creating the SQL data connection successfully. I have layers being created from that data connection with the SDE object I specify, for example, county polygons. Only problem is when previewing data, layers, maps or layouts both old and new flex style nothing shows up. The legend is populated correctly. I am using a dataset that is LL83 so there should not be a coordinate system issue. Anyone have any ideas or will this not work yet as it is very new technology.

Side Note: I have it working in Map 2009 as far as bulk copy and then later display that data right from SQL Server. Is this going to be a limitation to the Open Source version. In other words withh Map Guide Enterprise be required?

The Rock

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/mapguide-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080717/95dd23f7/attachment.html