[mapguide-users] RE: Points from Sql/ODBC data source not showing

[Martin Morrison]

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: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of soudemans
Sent: Tuesday, November 22, 2011 2:37 PM
To: mapguide-users at lists.osgeo.org
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
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users