public void FromString(String s) { if (IsGeoNull(s)) { geoText = EMPTY_GEOMETRY; } else { geoText = s.Trim(); } try { // Parse _innerValue = NTSGeographyWrapper.Parse(geoText); // SRID, Type & Points X, Y if ((!NTSGeographyWrapper.IsValid(_innerValue)) && _innerValue != null) { //_innerValue = NTSGeographyWrapper.MakeValid(_innerValue); } this.srid = NTSGeographyWrapper.Srid(_innerValue); this.setGXGeoType(NTSGeographyWrapper.STGeometryType(_innerValue).ToString()); if (GeographicType == GeoGraphicTypeValue.Point) { this.Point.Longitude = NTSGeographyWrapper.Long(_innerValue); this.Point.Latitude = NTSGeographyWrapper.Lat(_innerValue); } } catch (Exception ex) { if (!String.IsNullOrEmpty(ex.ToString()) && ex.HResult == -2146232832 && ex.Message.Contains("Unknown Type")) { if (GeographicType == GeoGraphicTypeValue.Point && !String.IsNullOrEmpty(geoText)) { _innerValue = Geospatial.FromGXLocation(geoText); } else { // Cannot parse value _innerValue = NTSGeographyWrapper.NullSQLGeography; this.geoText = ""; this.Point.Longitude = 0; this.Point.Latitude = 0; } } else { // Cannot parse value _innerValue = NTSGeographyWrapper.NullSQLGeography; this.geoText = ""; this.Point.Longitude = 0; this.Point.Latitude = 0; } } }
ArrayList geoToArray(String geoType, Object geoInstance) { ArrayList ArrayOfPoints = new ArrayList(); if (geoType.Equals("MultiPoint") || geoType.Equals("LineString")) { int points = NTSGeographyWrapper.STNumPoinst(geoInstance); for (int i = 1; i < points; i++) { double[] CurrentPoint = new double[2]; Coordinate currentPoint = NTSGeographyWrapper.STPoints(geoInstance)[i]; // lat y long CurrentPoint[0] = currentPoint.X; CurrentPoint[1] = currentPoint.Y; ArrayOfPoints.Add(CurrentPoint); } } else if (geoType.Equals("Point")) { ArrayOfPoints.Add(NTSGeographyWrapper.Long(geoInstance)); ArrayOfPoints.Add(NTSGeographyWrapper.Lat(geoInstance)); } else if (geoType.Equals("Polygon")) { int rings = NTSGeographyWrapper.STNumRings(geoInstance); for (int j = 0; j < rings; j++) { ArrayList RingArray = new ArrayList(); object currentRing = NTSGeographyWrapper.STRingN(geoInstance, j); int p = NTSGeographyWrapper.STNumPoinst(currentRing); for (int i = 0; i < p; i++) { double[] CurrentPoint = new double[2]; Coordinate currentPoint = NTSGeographyWrapper.STPoints(currentRing)[i]; CurrentPoint[0] = currentPoint.X; CurrentPoint[1] = currentPoint.Y; RingArray.Add(CurrentPoint); } ArrayOfPoints.Add(RingArray); } } else if (geoType.Equals("MultiLineString")) { int geoms = NTSGeographyWrapper.STNumGeometries(geoInstance); for (int j = 0; j < geoms; j++) { object currentgeom = NTSGeographyWrapper.STGeometryN(geoInstance, j); ArrayOfPoints.Add(geoToArray("LineString", currentgeom)); } } else if (geoType.Equals("MultiPolygon")) { int geoms = NTSGeographyWrapper.STNumGeometries(geoInstance); for (int j = 1; j < geoms; j++) { object currentgeom = NTSGeographyWrapper.STGeometryN(geoInstance, j); ArrayOfPoints.Add(geoToArray("Polygon", currentgeom)); } } return(ArrayOfPoints); }