SQL Spatial gives you the benefits of spatial indexes, ability to transform coordinates, etc. It also uses the native driver rather than ODBC.
On the extents (assuming no transformations) take the smallest x and y values and the largest x and y values, that is your extents for that data. Do those coordinates fall within the range of your mapguide map? Martin Morrison Application Engineer Engineering Design Systems, Inc. 3780 Peters Creek Rd Ext SW Roanoke, VA 24018 540.345.1410 gis.edsi.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of soudemans Sent: Tuesday, November 22, 2011 2:37 PM To: [email protected] Subject: [mapguide-users] RE: Points from Sql/ODBC data source not showing Thanks Martin, A lot of suggestions, so here go the answers and resulting questions: /"Seriously consider moving your data to a 2008 SQL server using a spatial datatype."/ - A valid suggestion, and I am not sure why I would not have considered that myself. I will keep this in mind if an answer is not forthcoming. I do have a question, to what extend would having a spatial data source affect the way I am capturing the coordinates (See JS below)? /"Do you have nulls in your current data?"/ - Oh did we ever, it was all test data so I was able to remove them. Alas it did not fix the problem. /"Are your extents correct?"/ - I hope so, but I am not sure how to check that for a layer. The only place I could find an extent definition was in the MapGuide Studio map definition document and that was for the initial view. I could not find a place to define the extents anywhere else, but I might have missed something. Perhaps you could tell me where I would set the extents /"Do the coordinate system of the point match the map?"/ - The coordinates are captured from the map using the Javascript below. I set the coordinate system of the data source to correspond to the map - WI-S NAD 27 State Plane (Foot) /"Indexed?"/ - The table has a primary key definition assigned to an ID field function btnRecordMainBrkOnClick() { alert("Please digitize a point along the selected watermain to indicate the approximate location of the main break") parent.parent.mapFrame.DigitizePoint(OnPointDigitized); } function OnPointDigitized(point) { var vResultSelect = document.getElementById("resultSelect"); var vMainId = vResultSelect.value; var vXcoord = point.X var vYcoord = point.Y } -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Points-from-Sql-ODBC-data-source-not-showing-tp7021115p7021649.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
