Tag Info

Hot answers tagged

2

I see you have the SQL Server tag so I will answer based on the assumption that both of your database servers are SQL Server. You can used SQL Server's Linked Servers to do this. In SSMS, log into the instance that has ArcSDE on it and do the following the following to set up a linked server: Instance > Server Objects > Right-click Linked Servers > New ...


2

You could use the static/class method Parse to create a point from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation. For example var myZMPoint = SqlGeography.Parse("POINT ZM (1 1 5 60)") There are other class methods that might also work.


2

I have same problem, my understanding is that the stored data is correct, if you consider it a binary utf-8 encoded data, to convert this data to nvarchar i wrote this (partially tested) UDF function in sql server: CREATE FUNCTION varbinUTF8_to_nvarchar ( @data VARBINARY(MAX) ) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @n INT DECLARE @buffer ...


1

Here are your starting shapes: At one billionth (10^9) of a degree precision (the same scale as your coordinates in the WKT), I receive a self-intersection error from the Esri geometry library. The geometry really is invalid as presented. If I increase the precision to 10 billionths (10^10), I get long slivers in the middle of the shape: If I back the ...


1

You can join and display datasets on a map using an ArcGIS endpoint if you join them in ArcMap. The process is described HERE. Once you make the connection in your MXD just publish it like you normally would and it will be your REST endpoint. This will allow a connection to two databases through an ArcGIS REST web service without you having to write a single ...


1

(Credit to @Russell at ISC for the use of the modulo operator.) We have a table in SQL Server with a column of geography data type, called [GeoCoor]. This is how we convert to degrees, minutes, and seconds: SELECT [GeoCoor].[Lat] as [DecimalLatitude], floor(ABS([GeoCoor].[Lat]))*(CASE WHEN [GeoCoor].[Lat] < 0 then -1 ELSE 1 END) as [LatDegrees], ...


1

This issue has been discussed on the GeoServer mailing list here: http://comments.gmane.org/gmane.comp.gis.geoserver.user/44081 Basically this comes from a (faulty) security update from Microsoft that has been updated, see this link from MS: https://support2.microsoft.com/kb/2992611


1

Given that I am still in 10.1, if you reconcile and post, but there is a lock on the feature class, the dates and editors will not be posted to the business table. If you need to see the data immediately for reporting purposes or other pressing reason(s), you can see the editor tracking information in the Adds table (a table) for that particular feature ...



Only top voted, non community-wiki answers of a minimum length are eligible