Tagged Questions

3
votes
1answer
97 views

Create polygons in ArcMap 10.0 from lat/long data pulled from SQL Server 2008 database

Forgive me if this is very basic, as I'm new to GIS work (though I've been a programmer for 10 years) and so I'm not really sure how to approach this, but here goes... Can I take a table with ...
0
votes
1answer
166 views

How to import ArcGIS 10.1 File geodatabse to MS SQL Server 2012

Hello I´d like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I´ve never do it before, so I expect to do the import same way as import data from excel table. Problem is ...
0
votes
1answer
64 views

how to make a join with sql server table

I have a question. I'd like to join .shp to table by using AddJoin_management. But I'd like to make join to sqlserver table (not to *.dbf). Is it possible to do? it should look something like this: ...
2
votes
2answers
344 views

ArcGIS Server 10.1 and SQL Server 2012 SP1

We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
1
vote
0answers
46 views

Retrieving ArcGIS:s Spatial Data into a Database

Background: If you have created a vector map with lots of spatial data in geometry flat in with measurement kilometer. The following object that is used in the map will be point, line and polygon ...
1
vote
0answers
183 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 ...
2
votes
2answers
417 views

ArcGIS Server simple link with SQL Server database

I am using ArcGIS Server 10 to create Rich Internet Application with embeded Maps. Basicaly, I created an Optimized Map Service on ArcGIS Server, from an MXD file (produced with Arc Map). I have ...
5
votes
1answer
521 views

Reset Object ID After Truncating Table In SQL Server

I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
2
votes
0answers
178 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 ...
3
votes
3answers
373 views

merging data in ArcSDE

I need some suggestions/inspiration for a problem we have. The problem: We have an ArcSDE master GIS database. We will edit this data almost exclusively outside of ArcGIS and outside of ArcSDE. In ...
6
votes
1answer
394 views

SQL Server Relationships in ArcSDE

I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
1
vote
1answer
255 views

How to convert SQL Server Rasters to ASCII Grid?

I have 25km by 25km squares of the world in a relational database. Each square has coordinates for the top left and lower right corner as latitudes and longitudes. Each square also has an index ilat ...
12
votes
5answers
3k views

Use arcgis with SQL Server 2008 as a backend

I'm wondering how best to use arcgis] and sql 2008 together. At the moment we run manual imports and exports between sql 2008 and arcgis 10 shape files. With sql 2008 having a geography data type I ...
1
vote
1answer
615 views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
7
votes
4answers
756 views

Spatial query tool for laymen

I know nothing about GIS, but I have what I think is a GIS problem. From spending a few hours googling my problem, I think what I need to do is perform a spatial query, but I'm not sure how to go ...
0
votes
1answer
835 views

How to safely replace ArcGIS SDE feature classes using transactions

I am using C#, ArcGIS Server 10, MS-SQL Server 2008, and I want to replace an ArcGIS SDE feature class inside of a transaction. After the deletion of the feature class, I have to create a new one with ...
2
votes
1answer
634 views

How to create SDE GDB without post installation?

Is there any way to create a SDE sqlserver2008 geodatabase without : SDE post-installation execution on the server having sde service running on the server and using : execution of some DDL ...