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

[soudemans]

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.