Tag Info

Hot answers tagged

3

You could consider exporting to an XML workspace document via the Export XML Workspace Document GP tool. You can input a geodatabase and then all objects including any behavioural ones will get exported. The problem with Copy Features and FC to FC is that they leave the behavioural objects behind (i.e. networks, topology, etc.). May not be relevant for ...


3

I have used this script in the past (Warning, does not copy any topologies, relationship classes, etc): import arcpy, os def ExportSDEtoGDB(sde_gdb, out_loc, out_name, gdb_type='File Geodatabase'): ''' Creates a copy of an SDE Geodatabase to either a File or Personal Geodatabase. This will copy all tables, rasters, and feature ...


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 ...


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.


1

The only success I have had after using UnionAggregate to use QGIS to move the feature from SQL Server to a shapefile and then ArcGIS can read it.


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

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

(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], ...



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