Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.

learn more… | top users | synonyms (1)

0
votes
3answers
93 views

database server connection to MSSQL Server with ArcCatalog not possible?

I have a MSSQL Server where my geodata is held. In the ArcGIS Docs, it says... "To administer ArcSDE geodatabases for SQL Server Express, you can also connect to these geodatabases by first making a ...
3
votes
3answers
259 views

ArcSDE command registration issues

I have an ArcSDE 10.0 enabled SQL Server 2008 R2 database on a development server. We are using TeamCity to run continual deployment to this development server, which runs through the following steps: ...
7
votes
2answers
811 views

How to use the ESRI JS API to map SQL Server Spatial Types without ArcGIS Server

I have heard of people using the ESRI Javascript API to create webmaps with spatial data from SQL Server or other RDBMS's. From what I can tell, they are not using ArcGIS Server as a middleware. In ...
0
votes
1answer
102 views

How can i generate parcel extracts on demand through a webservice

Ok, i need to generate parcel extract documents on demand. The backend is Arcgis 9.3.1 on SQL server 2008. I would like to build a webservice (C# .Net) on the server that generates these extracts. My ...
0
votes
1answer
188 views

Do any of the SQL Server 2008 R2 SP 2 cumulative updates contain the MAXDOP spatial index fix?

I am troubleshooting ArcGIS 10.1 performance issues with SQL Server 2008 R2 SP 2 (10.50.4000) and the issue appears to be this MAXDOP issue: ...
0
votes
1answer
150 views

geoserver problem to join sql-server table to a layer

i have a layer published on geoserver based on a connection to a postgres/postgis Table and i need to add another table existing on sql server to do a data jointure table to table in order to add ...
3
votes
5answers
303 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
1answer
36 views

layer from sqlserver database table

I'm new in ArcGIS. Is it possible to create a layer from a SqlServer table instead of a shapefile? in other words, is it possible to store layer data in a table in Sql Sever instead of a shapfile? ...
2
votes
0answers
180 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 ...
1
vote
0answers
116 views

Polygon not a valid geography instance

I am trying to create and insert data from ESRI shape files. This is one of the many features in the shape file, you can copy paste it and try it yourself: DECLARE @g geography; SET @g = ...
0
votes
0answers
23 views

Asp code for distance in SQL sever

I've looked around but I can't find the answer anywhere and im getting kinda frustrated now. I'm using sql server and what im trying to do is to find apartments within a 0.5km radious of a said ...
1
vote
1answer
335 views

How to insert features in a MS SQL based SDE without giving ObjectID s?

I'm trying to load features into ArcSDE without using ArcObjects, and using SQL from my .NET Application instead. I have followed the answers given in this question: Is it possible to load features ...
0
votes
1answer
191 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
190 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 ...
1
vote
0answers
202 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
3
votes
0answers
214 views

Geoserver WMST Date Format

There is table in SLQ-Server 2008 R2. In this table i have date column with date format like this 2006-09-08 14:39:41.000. Now i make View from this table on Geoserver side but do nothing wiht date ...
1
vote
1answer
342 views

Insert XY table data into SQL Spatial column

ArcGIS Server 10.1.1 SQL Server Standard 2012 Current workflow is user submits a table (text file) containing lat-long data (same spatial reference each time); SQL Server Integration services pushes ...
0
votes
2answers
193 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...
2
votes
1answer
159 views

ArcExplorer - possible connect to a non-SDE database?

In ArcExplorer, I'm wondering if you can connect to a non-SDE database, like SQL Server, with geometry or geography columns?
1
vote
2answers
495 views

Plotting large numbers of objects on a chart using R and WKT format

I am retrieving thousands of geometry lines in WKT format from a Microsoft SQL Server database. I would like to plot all of those lines in one map, but I am having some difficulty with the code. How ...
2
votes
1answer
352 views

Reading OGC geometry data from SQL server using R

I would like to write a script in R that creates a map using OGC geometry data that is stored on a Microsoft SQL server. Is there a way to read OGC geometry data using a query passed from R? Maybe ...
5
votes
1answer
238 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
2k 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
134 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 ...
4
votes
2answers
3k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
9
votes
2answers
296 views

How do I perform a 3 parameter geotransformation and projection in Sql Server 2012?

I have a table with latitude longitude (NAD27) columns in it. I compute two other columns, X and Y, representing Web Mercator (WGS84) location. Currently I'm using a Arcmap to do this, by applying ...
2
votes
0answers
257 views

Why does a geoprocessing service fail every other time it is run?

I have a ArcGIS Server 10 geoprocessing service right now that takes in a string and runs a parameterized query to SQL Server 2008R2 through pyodbc. The service works, but only every other time. I can ...
2
votes
1answer
304 views

SQL Server UNion of geography feature returns FULLGLOBE result?

I have some trouble with sql server 2012. I store coordinates of french cities in my database as geography object (with ESRI 4326) and i want to make the UNION of some cities. I have in result ...
0
votes
1answer
79 views

Unsupported WFS request in MapServer at Insert and Update

I'm created a WFS with MapServer (ms4w) and SQL Server DB. The wfs:GetFeature works fine. But I cann't get the wfs:insert/wfs:update to work, they return: <?xml version="1.0" ...
2
votes
1answer
1k views

Which one is better ?SQL server 2012 or Oracle 11g

I want to learn a database server, SQL server 2012 or Oracle 11g . I surf in the internet to compare SQL server and Oracle for spatial data and found good websites such as gisboston.it was very ...
2
votes
0answers
308 views

ArcMap runs custom script once and then it crashes on second run

So I made a script that takes data from an MSSQL database and inserts it into a featureclass. I added the script to a toolbox and am able to run the tool from within ArcMap 10.1. The problem is that ...
3
votes
1answer
774 views

add new SRID to sql server

Is it possible to add a new SRID to sql server 2012? I've tried insert into sys.spatial_reference_systems values (4938, 'GEOCCS["GDA94",DATUM["Geocentric Datum of Australia 1994",SPHEROID["GRS ...
0
votes
1answer
275 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: ...
1
vote
2answers
60 views

Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)

I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
0
votes
1answer
61 views

number of arcgis server users for CAL-based backends

The licenses for our organization's MS SQL and ArcGIS Server are such: MS SQL: CAL ArcGIS Server: enterprise Are the number of users that can be served still limited to the number of CALs present in ...
0
votes
1answer
175 views

How to export Spatial data from MsSQL to MySQL using OpenSource/Free tools

I have a few tables with geometry fields in MsSQL Server 2008. I would like to export the whole table with data to MsSQL Server. Are there any open source/free tools that does this job?
0
votes
0answers
318 views

SDE connection error

In my company we have a number of databases in an MS SQL instance. This morning only 1 database i generating following error when I try to do a direct-connect in ArcCatalog: Failed to connect to ...
0
votes
1answer
101 views

Creating “Empty” version of ArcSDE geodatabase?

Is it possible to create an "Empty" version of an ArcSDE geodatabase? I have a large default ArcSDE geodatabase that I would like to create an empty version for a new project. By "Empty" version I ...
2
votes
2answers
846 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
1answer
495 views

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
0
votes
0answers
73 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 ...
0
votes
0answers
129 views

Retrieving the data from SQL database is taking much more time than expected

I am creating a block wise vector layer and related data stored in a sql database while retrieving the data from the SQL database through querying and would represent the result on a map. This is ...
2
votes
1answer
212 views

Connecting gvSIG with SQLSERVER

I am working for the first time with gvSIG and SQL SERVER, I want to connect gvsig with spatial database SQL SERVER. I don't know how to, Is it by using a protocol and which one ? plz help me
1
vote
1answer
332 views

tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER

i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
3
votes
4answers
400 views

What Application for Vector and Cartesian Coordinate System

Goal: Visualize a picture in SQL server 2012 spatial data based on geometry Problem: In order to display a vector picture I need to retrieve X, Y coordinate (cartesian coordinate system) and ...
4
votes
3answers
651 views

How to migrate PostGIS spatial data to MsSql spatial data?

am trying to migrate PostGIS geometry to SQL server Spatial data. which ETL i have to use. it's the first time i'll work with SQL server Spatial. is there any Data ETL model that do this migration. ...
0
votes
0answers
68 views

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
1
vote
3answers
136 views

How to Retrieve X and Y from a papermap or gif picture

Goal: Visualize a subway map in SQL server 2012 spatial data based on the map of the subway. The map shall use geometry, traffic rail road as line object, station as point object and zon as polygon ...
3
votes
1answer
300 views

How to use stored procedure in Geoserver?

I have a MS SQL Server 2008 R2 with and have stored procedure in here. I want to create layer in GEoserver using this. I try: EXECUTE [dd_base].[dbo].[Request BaseSration] 'param1', 'param2', ...
1
vote
0answers
333 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...