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)

6
votes
2answers
73 views
+50

Draw SQL server geometry records as graphics on map using ArcGIS API for WPF 2.4 -can it be done and how?

I have records (of public festivals changing daily) in the in SQL server 2012 that have a geometry column (polygons where they occur). I need to show the records as graphics on a map using ArcGIS ...
1
vote
0answers
52 views

ArcGIS Operation Dashboard

I am working on ArcGIS operation Dashboard. There is an widget on the top left corner “ Model Manager”. Here the Model manager will read the data from ForecastStage_MPT and ForecastTimePT database ...
1
vote
2answers
2k 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
1answer
273 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
0
votes
1answer
16 views

Convert coordinates into decimal using SQL Server

I am looking to convert a pair of coordinates to decimal, and am unsure how to go about doing it. The following script select Centroid.STY as Longitude, Centroid.STX as Latidude from ( select ...
2
votes
2answers
803 views

Getting coordinates of shortest distance between point and line MS SQL 2008

I have a table of point data (POINTS) in a SQL Server 2008 database table (No ShortestLineTo Function!). Each one has a SpatialPoint field of type geography (4326). I have another table of line data ...
1
vote
1answer
322 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
1answer
420 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 ...
2
votes
1answer
784 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
0answers
21 views

Reverse geocoding from sql server

I have a lot long/lat data in MS SQL Server, i want to do reverse geocoding by using openstreetmaps or some other free web service, and on the end i want to display all of that in report builder, does ...
0
votes
0answers
32 views

Geodatabase disappears

I have an old ArcGIS 10.1 in my laptop. While I'm trying to create a geodatabase it gets created, but doesn't let me create new featureclass and/or feature dataset. I get the error:" failed to connect ...
1
vote
1answer
43 views

why can one user register a geodatabase with the server and the other user can not?

So i have two users; arcgis_db and AD\raclark, one can publish a service the other can not. It all goes fine till i get to the 'service editor' screen and click 'analyze'. One user, arcgis_db comes ...
0
votes
1answer
36 views

SQL Server Spatial Querying

I am looking for ways to learn querying for SQL Server Spatial (2008/2012). I have a table created from Shape2SQL and have been trying to run a simple intersection query to get results from that ...
1
vote
1answer
27 views

Does SQL Server Data Need to be Spatial

In reference to my previous question. I am looking for the benefits of telling SQL Server your data is spatial. For instance, I have a duplicate of that table generated by the Shape2SQL tool (see ...
1
vote
0answers
18 views

sql server geometry find points intersection buffer

How do I find the point of intersection of buffer?
1
vote
3answers
105 views

How to use STUnion with GroupBy

I'm using SQL Server 2008 R2 to store Geometry data types. I have a bunch of lines as individual features, that share common names ('NAME' field). I would like to create a view that Groups By 'NAME' ...
1
vote
0answers
30 views

How to create MBtiles from geoserver

How to generate mbtiles in geoserver? using openlayers for displaying geoserver layer for example calling wms layer like this new OpenLayers.Layer.WMS("Kanpur", ...
0
votes
1answer
585 views

SQL Geometry Query similar to Select by Centroid

Does anyone know if it's possible to query SQL geometry by something like 'centroid of polygon'...similar to ArcMap's select by location? I'm using SQL Server 2008 R2 as the DBMS. I have two polygon ...
0
votes
0answers
13 views

How to load points in a SQL server polygon table?

I have a spatial table in SQL server which stores both points and polygons geometry and I am using the table to return geoJSON for API calls. I want to load some points to this table with shapetype ...
0
votes
0answers
19 views

GeoWebCache Speed SQL Server Store

How to increase GeoWebCache speed, Am using geoserver 2.7.2 for tile cache and data store creating from a SQL Server database it will take 1 day and above to complete cache and it terminated several ...
3
votes
2answers
409 views

How can we generate GeoJSON from SQL data with latlong

Is there any way we can create GeoJSON from SQL server table with Latitude & Longitude Data?
1
vote
0answers
39 views

QGIS 2.10.1 & SQL Server 2014

I'm struggling to load spatial data into QGIS from SQL Server 2014. I have a table with 4 geography columns (3 are polygon layers, one is a point layer). The table has a primary key column that is a ...
1
vote
1answer
523 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
3
votes
2answers
1k 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
32 views

Error: Failed to convert: Database Connections… when trying to export to shape file

I have created a table with some derived data in SDE using sql server. The following is an example row of the table: T_OBJECTID T_GEOID T_STATE T_COUNTY T_TRACT T_NAME T_LSAD T_CENSUSAREA ...
0
votes
0answers
53 views

Deploy Web AppBuilder for external access

I am developing an app using Web AppBuilder within ArcGIS Online. The data are hosted in in-house SQL Server, not in ArcGIS Online. I have tested deploying in IIS, it works well, no issues. While ...
0
votes
0answers
75 views

MS SQL table with geometry field to feature class

I have a table in a native SQL database (no geodatabase, dc_geobank_public.sde in the code) with cca. 300 000 records and 18 fields. Two of the field contains projected X and Y coordinates, and one ...
5
votes
2answers
757 views

Load and display a layer from SQL Server 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 ...
0
votes
0answers
11 views

Styling MSSQL Layers in QGIS

I have set up Ordnance Survey MasterMap as 2 MSSQL layers (area and text) which are working great, I can style the layers as I would do usually with shape files but I'm struggling to work if it's ...
1
vote
1answer
2k views

Plotting Multiple Points on Google Map using VB.net

I am creating a database application using VB.net and MSSQL 2012. I have retrieved a list of customer from the database and want to plot them on google map. At it stands, I can only plot the first ...
2
votes
1answer
451 views

Database connection (SDE) failed after database was renamed

I created an enterprise geodatabase in SQL Server 2008 R2 with ArcCatalog (10.2). It was connected via an sde file in ArcCatalog then. Then I had to rename the database from SQL Server Management ...
0
votes
1answer
358 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 ...
4
votes
3answers
3k 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
0answers
24 views

Managing privileges for an ArcSDE database using SSMS

I am trying to mange users for my ArcSDE database via SSMS as opposed to tools in ArcGIS, to do this i want to set up two new user roles, data-viewer and data-editor, and then assign users to those ...
0
votes
0answers
38 views

Remote SQL Server, Crystal Reports and Geospatial Join

I have: A remote SQL server (2008 R2) that I have access to (But NOT full control of) which contains my source data including OSGB 1936 Geometry [ESPG: 27700] In house SQL Server 2008 R2 A Crystal ...
2
votes
4answers
7k views

Insert Geography data into SQL Server 2008

Can someone guide me to or give me an example on how would one go about insert/query Geography data in Sql Server 2008 ( Polygon with 4 points and Point in specific) using C# EF or Linq2Sql. I've ...
0
votes
1answer
298 views

Can't create new geodatabase for SQLServer 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 ...
3
votes
2answers
3k views

Feature Class To Geodatabase => ERROR 000210: Cannot create output

error messages: Executing: FeatureClassToGeodatabase E:\jags20120321.mdb\ch_cs "Database Connections\Connection to localhost.sde" "Database Connections\Connection to localhost.sde" Start Time: Sat ...
0
votes
0answers
44 views

ArcCatalog Unable to Connect to Database (Invalid object name SDE_table_registry)

Trying to make a database connection in ArcCatalog The ArcServer is on a separate vm than the SQL Server vm. When I attempt to connect to the database using integrated security I get the error: ...
1
vote
0answers
38 views

qgis unable to connect to ms sql server using sql authentication

I am getting the following error when I try to set up a connection to a MS SQL Server database using sql server authentication. I did find a bug report from 2014, but that was apparently fixed and ...
0
votes
1answer
48 views

SQL Server table not updating in ArcGIS Online map

I have a SQL Server table in my ArcGIS Online web app. It is related to 2 other feature classes also in my map. The source table is a non spatial table being related on a common field. Not sure ...
1
vote
1answer
35 views

How to correct topology area boundary errors (slivers/gaps) on arcs in arcgis / arcsde

I use arcgis 10.1 (arcinfo licence) with arcsde to connect to a SQL Server database. The initial dataset has around 100k polygons (used for land registration, having a resolution that is around 1cm ...
0
votes
1answer
18 views

How do I generate 3d WKT FROM A Sql Server geometry or geography types

If I have the point POINT (-75.45454 25.12345 1024 ) in a geometry or geography column in SQL Server, but render it with STAsText() I lose the Z dimension. SELECT geography::STGeomFromText('POINT ...
2
votes
1answer
46 views

convert ordnance survey easting and northing data to WGS84 latitude longitude values

The C# code published here is not very accurate as also mentioned by tanoshimi. I think this has to do with the lack of 'approximate Helmurt transformation'. Just curious is anyone aware of some ...
0
votes
0answers
97 views

Cannot connect MSSQL server from QGIS

I'm trying to connect to an MS SQL 2012 database from QGIS 2.8 on Windows and get this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "xxx" requested by the login. The ...
1
vote
0answers
26 views

ArcGIS SQL Server - Using Windows Authentication

I want to use a domain level service account to manage my database connections. This account is added as a Windows authenticated account in SQL Server 2012 as a sysadmin. If I try to use this ...
0
votes
1answer
77 views

Adding SQL Trigger to update field on INSERT (multiple rows)

I have an address point Feature Class that has an addressID field. I am trying to write a trigger that will in effect auto increment this field when a new address is added to the map. I cannot alter ...
0
votes
2answers
127 views

Copying Personal Geodatabase (in Access) with relationship classes to ArcSDE for SQL Server?

How to copy a Personal Geodatabase (in Access) with relationship classes to ArcSDE for SQL Server. I tried a simple copy paste and imported, but didn't get the relationship classes. error: unable ...
4
votes
1answer
34 views

Move/Shift a line toward x and y axises in SQL-Server

Is there a function in SQL Server to move/shift a geometry toward X or Y axises?
1
vote
2answers
32 views

Database Server Node vs. Database Connection Node

What are the main differences between the Server Node and the Connection Node? The only difference I have been able to find is that the Server Node is intended for administrative tasks while the ...