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)

-1
votes
0answers
10 views

Cannot create new spatial database connection in ArcCatalog

I have searched a lot in the net but i just found your question in this forum but i didn't see the confirmed answer. I want to know if you have found the solution. The problem is that when i click ...
3
votes
2answers
892 views

Can I fix 'qodbc3:unable to execute statement' when querying SQL Server 2008?

I was testing features of QGIS and its really cool.I tried to query each table using right click and query but I can't query sql server 2008 database : Error: An error occured when executing the ...
0
votes
1answer
8 views

GML TimePeriod mapping in MapForce

I made SQLServer database structure based on xsd schema I got. In that schema two fields have gml:TimePeriodType. In database I put two columns for each field of this type (begin and end) and the ...
0
votes
1answer
23 views

Querying Arcgis file geodatabase from sql

I need to compare data in a sql db with data stored in an arcgis file geodatabase. I'm not interested in the spatial attributes, only the added text attributes. What's the easiest way to do this? I ...
5
votes
1answer
408 views

Ogr2Ogr exported this boundary 90 degrees incorrectly

I've got some GEOGRAPHY data in my Sql Server 2008. I wish to export it as a shapefile (so I can import it into QGIS) and when I do, it's rotated 90 degrees to the left and then flipped 180 degrees to ...
1
vote
0answers
27 views

Split polyline feature in sql server 2012

Please find the below attached image. I have one point(in blue color) and polyline(in black color). Using the below sql server 2012 comment i got the nearest path(in red color) between ...
0
votes
1answer
21 views

accurately find the bounding box of geography polygons

Im displaying polygons on a map and have had issues with the spatial index where the index performs well only for certain data sets (large areas with low density / high density small map areas). I've ...
0
votes
2answers
815 views

How to use Sharpmap to display spatial data from MS SQL Server 2008

Can anyone show me a step by step example on how to use Sharpmap to display MS SQL server spatial data using C# as the programming language? Please note I have exploit some of the example online but ...
2
votes
0answers
19 views

Batch geocoding 1.5 million data points in SQL Server

I am currently attempting to batch geocode 1.5 million points that are stored in a sql database. The points are not very specific (ie only city, state points). I have used ArcGIS in the past but due ...
0
votes
1answer
34 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. ...
2
votes
1answer
338 views

SQL Server 2008 Distance and Performance Problem

I had been working on PostGIS to do some geographic processes and due to some reasons, I had to start to use SQL Server 2008. I ported same code for SQL Server but performance is almost dying when I ...
0
votes
1answer
48 views

How to edit feature in sqlserver geodatabase

I am using arcmap 10.2.1 and arcobject 10.2.1,I just want to conncet to a geodatabase and edit,add,delete a feature from a feature class using arcobject,I tried to connect to database and it works ...
1
vote
1answer
41 views

Connecting to SQL Server Geodatabase using ArcObject in C#

I am going to save a polygon that is created from points to remote geodatabase.I am new with arcobject and cant undrestand how it works..at this point I want to open a connection to database using ...
1
vote
0answers
8 views

Error trying to create mssql layer in geoserver

with mssql 2008 and the latest geoserver with the mssql store plugin, I can create a dbo connection with a mssql database and list the tables. When I try to create a layer with one of the tables which ...
5
votes
2answers
815 views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...
0
votes
0answers
17 views

Auto-Increment Integer Field in a Feature Class [duplicate]

Does anyone know of a good way of auto-incrementing an integer field within a SDE feature class when the feature is created? I don't want to have a script run afterwards to populate the field and I'd ...
1
vote
2answers
893 views

what is the format of Geometry data type of SQLServer 2008

I want to know, In which format the Geographic data stored in geometry data type of SQLServer 2008.it looks like a long string,like 0xE6100010466DFEOA4089663524....... for one polygon. My second ...
2
votes
1answer
15 views

Transform wkb to gml geometry using FME

Maybe (and probably) this is stupid question, but I am totaly new to FME and geometry conversion. I need to transform WKB field from SQLServer to GML geometry using FME software. How can I do this?
1
vote
0answers
50 views

Using SQL replication to replicate Geodatabases (in stead of ArcGIS replicas) [closed]

Given two geodatabases (A and B) in SQL Server (Express) is it possible to replicate from A to B using SQL Server replication instead of using Esri's geodatabase replication?
1
vote
2answers
31 views

STCentroid Question

Hi I'm not sure if I should ask in here or another SE site, however I was wondering if anyone knew if it is possible to configure the results from a STCentroid select statement? If I run a select ...
0
votes
2answers
299 views

MSSQL Data Not Showing Up in QGIS

I started using QGIS a few weeks ago. I've been able to create some very nice maps with it. I've used the OpenLayers plugins to bring in different basemaps, I've brought in shapefiles and connected ...
0
votes
0answers
42 views

How to improve performance using spatial indexing with STIntersects()

I am working on Spatial database. I need to check intersection of state geometry with geometry inside database. I am presently using the query as SELECT a.ID, a.OBJECTID, a.MSID, ...
0
votes
0answers
29 views

Query's “Get Unique Values” includes case variants that don't exist in attribute table

I ran a query on an ArcSDE 10.2 Feature Class to find features that do not follow our office's standard of being in uppercase. The "Get Unique Values" seems to return values that do not exist in the ...
3
votes
5answers
266 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
2answers
34 views

Arcgis Dynamic Mapservice from sqlserver 2008 r2

I publish the mapservices from the sqlserver2008 R2 through ArcSDE using ArcServer 10.1. Its fine i published, now i change the attributes of my existing gdb using ArcSDE. Now the updated information ...
3
votes
1answer
160 views

Load and display a layer using PYQGIS

I'm having a go at using pyqgis from within the QGIS python console to load a layer from SQL Server and display it. I feel like I'm part way there but I'm having a real issue getting the layer to ...
3
votes
4answers
368 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 ...
0
votes
2answers
11 views

Consuming gml generated by sql server As.GML()

Sql server has a method As.GML to produce GML file from geography/geometric type. Is there a good example to utilize this GML on other mapping platform such as QGIS? I have ask a related question ...
0
votes
0answers
14 views

Select polylines that are having mutual points from another table with condition

I am struggling with this MapInfo SQL (or T-SQL) query too long so I need little help :) I have two tables: PIPES with polylines CHECK_NODES with points that represents starting and ending points ...
2
votes
1answer
266 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
0answers
22 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
109 views

Routing in MS SQL 2012

I would like to perform routing in MS SQL 2012 similar to pgRouting. In pgRouting, I'd do the following steps to create a routable network: Create a database routing with template template_routing ...
4
votes
1answer
139 views

QGIS 2.0.1 linking table issue, MSSQL 2008 database

I'm trying to link tables in QGIS 2.0.1 and MSSQL 2008 database. I can link them but when I try to open the attribute table QGIS throws an error and shuts down creating a *.dmp file. I saw that ...
0
votes
1answer
52 views

Import non spatial data into SQL Server using ogr2ogr

I am trying to import a CSV files in to SQL Server 2012 using ogr2ogr. The spatial data imports without any problems, but I cannot work out why the non spatial tables fail. I can import the data using ...
0
votes
0answers
31 views

Error post installation ArcSDE for SQL server 2008

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then ...
2
votes
3answers
2k views

Trigger on SQL Server 2008 ArcSDE 10 and ArcGIS Server 10

I need to build a sql server db trigger to update a date field with the current date when a record is inserted or updated, I think. I will be using the date field as a way to recognize ...
2
votes
1answer
45 views

Can you run GIS Squirrel next to SDE?

My company has SDE to run our webmapping system. We want our arcbasic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can we run squirrel next ...
0
votes
1answer
34 views

Def Query to not display feature if it isn't attributed

I have a bunch of features that I don't want to keep checking if something is attributed. I I want to query it out to not show the geometry if a column has the default string 'NOT ATTRIBUTED' to it. ...
0
votes
1answer
32 views

OpenLayers with MVC and SQL Server

I have imported some shape files into SQL Server 2008. Now i want to use OpenLayers with my MVC 4 application to render those shape files from SQL Server Database. Any help in this regard?
0
votes
0answers
14 views

SQL Server 2012 spatial check constraints disabled after migration from 2008

Currently we are using SQL Server 2008 geometry datatyped columns in our databases. These are registered with ESRIs enterprise geodatabase repository, so every spatial table has a check constraint ...
1
vote
0answers
62 views

Convert Arcpy results to feature class in ArcMap 10.1

I am using ArcGIS 10.1 and am a newbie in Python. Currently we are executing stored procedure (from sql server) through ArcPy in ArcMap. I want to create feature class from executing following python ...
0
votes
1answer
44 views

Can't create new geodatabase for SQLSever Express in ArcCatalog 10.0

I'm trying to create a new geodatabase in my local SQLExpress Database Server from ArcCatalog 10.0 (ArcInfo). I can create a database server entry just fine (image below): ESRI documentation has me ...
1
vote
2answers
79 views

Cannot connect to SQL Server Express 2014 from ArcMap 10.1?

I have ArcMap 10.1 and SQL Server Express 2014. I am trying to add a database server from ArcMap by following Arcmap>Catalog>Add database server>. But the connection is not being established. as far ...
0
votes
0answers
54 views

Export GeoJSON to MSSQL with UTF-8 encoding

I'm testing this command to migrate GeoJSON data to MSSQL table: ogr2ogr -f MSSQLSpatial "MSSQL:server=.\SQLEXPRESS;database=geodb;trusted_connection=yes" test.json -nln test It works beautifully, ...
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 ...
0
votes
0answers
29 views

Communication between widgets (flex)

Default Communication between widgets hi, i'm new in flex, and im working on Webmapping application using flex 4.6, java, and sql server as database, i'm just trying to make a communication between ...
0
votes
0answers
32 views

Shortest path between two points in multilinestring

I have a table which contain information about edges of the graph in form of geometry linestring. I combine those linestrings into one shape, and the result is multilinestring SELECT ...
2
votes
1answer
49 views

Connecting to MSSQL 2008 R2 with QGIS 2.0.1

There have been questions related to this, but some of them seem out of date or no one has asked. I'm trying to connect to SQL Server 2008R2 using a MSSQL connection in QGIS. I'm not exactly sure if ...
2
votes
2answers
327 views

How to Register a Spatial View when ArcSDE is direct connect only?

I have an ArcSDE 10.0 set up with MS SQL 2008 R2 Database, on direct connect. There is no service running, nor installed. I have created a spatial view built on a couple of tables. I have followed ...
2
votes
1answer
310 views

How to run “sdetable register” command in SQL Server?

I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2. I tried to run the ...