0
votes
1answer
80 views

Create Ms-Access type queries in ArcMap [closed]

We have a dataset with a personal GDB (mdb) with several feature classes and an mxd tied to those features to create layers based on definition queries… Currently to QAQC our data we use MsAccess ...
4
votes
1answer
119 views

call Sql Server stored procedure form arcpy

Is there a way to execute a SQL Server stored procedure with arcpy or Python and retrieve the results returned by the stored procedure? There is a very similar question posted on ArcGIS forum with ...
1
vote
0answers
75 views

ArcGIS Query Layer SQL Server Performance Issue

I'm experiencing a performance issue with ArcGIS Query Layer using non-sde Sql Server 2008 R2. Actually, I'm using a rather comprehensive view that pulls and joins data from multiple databases and ...
0
votes
0answers
25 views

Is there a way to force a featureclass to not allow non-simple shapes when using native geometry storage?

After spending a good chunk of the morning trying to figure out why a feature was displaying a circle when I was setting it as a rectangle polygon via SQL, I found the SDE_GEOMETRY table and some ...
2
votes
0answers
74 views

Issues importing feature class to SDE SQL Server 2012

I have received an error indicating there could be issues with my geometry when attempting to import a feature class into SDE. I ran the check geometry tool. No issues. I have removed all fields ...
1
vote
1answer
63 views

Not enough memory in the file group “Primary”: SDE Database error with MSSQL

I got this error message whilst trying to load data into a raster in ArcMap 10.0. Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Eine neue Seite für die sde-Datenbank konnte nicht ...
4
votes
1answer
69 views

What is happening when I register a “Feature Class” with Geodatabase?

I'm registering a table w/ native geometry with the geodatabase and it is taking a long, long time. Actually I'm not sure if ArcCatalog is frozen or crashing. The table does have several million ...
0
votes
0answers
42 views

SQL Server query, simillar to Symmetrical Difference in ArcMap

i have two tables with geometry data in SQL Server. How can I get all geometry differences with spatial query? I tried: select k.geom.STSymDifference(r.geom).ToString() from table1 k, table2 r But ...
0
votes
0answers
26 views

Is there a way to force ArcCatalog to use a specific tessellation scheme for a SQL Server spatial index?

If I Recalculate a spatial index from ArcCatalog, the tessellation scheme is always set to "Geometry Grid". Even when the previous index was Geometry auto grid. ArcCatalog always changes it back. ...
7
votes
3answers
368 views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
6
votes
2answers
75 views

Define projection at the record level

Hopefully this isn't too dumb a question, but is it possible to define projection at the record level, instead of a whole layer or table? I want to create a "project" database for all the work my ...
3
votes
2answers
89 views

Can't open ArcCatalog Database Connection SQL database Tables with field names greater than 31 characters

I am using SQLEXPRESS as a test environment. My issue: I have a database connection in ArcCatalog to a SQL database. Some tables in the SQL database have field names greater than 31 characters and ...
0
votes
0answers
50 views

using Arcgis silverlight viewer, how to autoload a layer of Lat/Long points stored in MS SQL 2008

I use Arcmap to register a layer into ArcGIS server whose source data is spatial points stored in MS SQL 2008. Everything works fine until a new entry is added into the database table, it doesn't ...
1
vote
0answers
111 views

SQL Server geography.Intersects Yields Unexpected Results (arch shape)

I've coupled ESRI's ArcGIS with SQL Server 2008 R2 in an attempt to allow users to search for geographical points using a polygon (with ArcGIS' drawing toolbar). I've run up against an issue that's ...
3
votes
5answers
209 views

Installing ArcGIS 10.1 on SQL Server 2008 R2 Cluster

We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the ...
0
votes
0answers
93 views

Remove last 5 characters from Feature classes names

I need to remove the last 5 characters from all feature classes in a mssql database by removing the last 5 letters. I have MYSQLServer 2008 R, ArcGIS Server 10.0 Enterprise Standard, Arcsde 9.3 with ...
2
votes
0answers
107 views

Problem viewing SQL 2008 “Date” field

I am using ArcMap Basic 10.1 SP1 and I'm connected to a permitting database stored in a SQL Server 2008 R2 database. I am trying to pull the tabular data over into my ArcGIS Desktop Project so that I ...
0
votes
1answer
138 views

Problem in filling table of ArcSDE feature class in SQL Server 2008?

I have an ArcSDE point feature class and I add it to ArcMap 10. After that I add some points to it and fill every field for all points in the attribute table and Save Editing. However, the SQL ...
0
votes
2answers
148 views

Need help in ArcGIS Desktop: Automate the task

I am using ArcGIS 10.1 desktop on Windows 7 and I want to run few task automatically. Scenario: I have plane table from sql server contains lat,lon information. I have added that table in Arc Map ...
5
votes
1answer
195 views

How to create polygons in ArcMap 10.0 using lat/long data 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 ...
3
votes
2answers
1k views

How to import ArcGIS 10.1 File geodatabase to MS SQL Server 2012?

I would like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I have never done it before, so I expect to do the import the same way as import data from excel table. Problem ...
1
vote
1answer
114 views

How to share *.sql files between ArcGIS and MapInfo?

In Denmark many municipalities have the same provider of public data. These data are pushed to a local database – often a SQL Server. The DBMS layout is the same for all municipalities. When I create ...
0
votes
0answers
70 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 ...
7
votes
2answers
172 views

ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field. In order to help themselves, they asked me to implement a particular ...
2
votes
0answers
321 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
1answer
271 views

Live update (the database & Map) possible in ArcGIS Server 10.1?

I am using sql server data base contains lat/lon values and using this information I have created the shape files and published on server.. When I get the update say 100 records then I need to ...
2
votes
0answers
464 views

View in ArcSDE 10.1 Problem

I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In ...
1
vote
0answers
376 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...