Tagged Questions

1
vote
0answers
179 views

How to build a Query Layer in ArcMap 10.1 using columns of two different databases?

As you may know, to create a Query Layer in ArcMap 10.1, it is required to specify a connection to a concrete database and then, define the access to the tables and columns in the SQL Query ...
4
votes
1answer
68 views

How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
0
votes
0answers
197 views

How to display points on map as a graphic using C#?

I have created map using ArcGIS Server in C#. I need to display points as a graphic. my database consists of points lat lon values, xval yval txnid attr1 attr2 ...
3
votes
1answer
121 views

Has anyone been successful using the CAST function in ArcMap 10 with ArcSDE 10

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
5
votes
1answer
169 views

BigInt data type in SQL Server mapped as Text in ArcMap

I have a table in a SQL Server 2008 database containing a BIGINT data column. When I tried to import it into ArcMap 10, it automatically converted as Text of 8 length. This caused the records that ...
1
vote
0answers
169 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
3
votes
2answers
570 views

SQL Spatial view using a Query Layer in ArcMap 10 is SLOW

We have a number of SQL Spatial views each made up of approximately 10 tables (so relatively complex views) and each including a table with a SQL Geometry column. A view could return up to 300-400 ...
2
votes
0answers
177 views

Updating SDE point feature classes with SQL SERVER 2008 R2

I am contacting you in hope that you can help me resolve an issue using SQL Server 2008 R2 to push updates to a SDE point feature class. We are using a C# app that uses ArcGIS Runtime to edit the ...
5
votes
1answer
686 views

How to persist a polygon to SQL Server database and vice versa?

How do I extract all the points from a Polygon drawn in ArcMAP and then persist that data into a SQLServer database table containing a geometry column and then when I've got the data persisted read ...