Tag Info

New answers tagged

1

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


2

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


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.


0

Following is a bit sample code using GeoJSON.NET https://github.com/jbattermann/GeoJSON.Net SQL Data Loaded into dataset ds var modelF = new List<GeoJSON.Net.Feature.Feature>(); foreach (DataRow dr in ds.Tables[0].Rows) { var point = new GeoJSON.Net.Geometry.Point(new ...


0

You can use GeoJSON.Net. I'm planning to work with it. I'll let you know it's usefulness when I do.


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


0

Try using brackets around Lat and Long: select [geom].[Lat] as [Latitude], [geom].[Long] as [Longitude] from dbo.special


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

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



Top 50 recent answers are included