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
0answers
29 views

Select all lines between two points

I need some ideas to solve the problem selecting all "lines" between two "points" using SQL Server. I have tables: Lines (line_id, geom) and Point (point_id, geom) I want to select all Lines between ...
8
votes
4answers
5k views

Convert Sql Server Spatial data to GeoJSON & plot on map

I have a sql server table with Geo spatial data. An example of row would be (with Column names): type: streetline code: 231001 geog: 0xE6100000011 ........ Centroid 0xE61000000C....... geom: ...
5
votes
1answer
253 views

How to set up a QGIS project with SQL Server which can be opened on another computer?

I am using QGIS with SQL server 2008. I need to save project on one computer and then copy project to another 20 clients! After I save project and try to open it on another computer I am getting ...
1
vote
1answer
31 views

Simple POLYGON works for Geometry, goes nuts for Geography

I am trying to do some rough conversions on existing data in SQL Server, and I've run into a fundamental problem: some values result in absolutely insane Geography values (completely different than ...
2
votes
1answer
116 views

Running GISquirrel next to ArcSDE?

My company has ArcSDE to run our webmapping system. We want our ArcGIS for Desktop Basic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can ...
5
votes
1answer
53 views

Finding SDE permissions on feature class using ArcPy?

I am writing an arcpy script where an SDE feature class is removed then recreated. I need to set permissions on the recreated feature class that match the permissions before it was removed. Is there ...
4
votes
2answers
2k 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
1k 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 ...
1
vote
1answer
206 views

Connect to remote Sqlserver using arcobject

I want to connect to a database assigned to a vps with an ip address.I used this string to connect to Database when it was on localhost. how I change it to connect to remote one? ...
1
vote
1answer
186 views

Adding non geographic data from MSSQL Database to QGIS?

In QGIS (2.8) I am trying to add non-geometric data / flat data that originates in a MS SQL database. This flat data later should be joined with other layers etc. Connecting to the specific database =...
2
votes
1answer
176 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 ...
4
votes
1answer
107 views

Error when using arcpy.ArcSDESQLExecute() to connect to SQL Server - ArcGIS 10.4

I am able to connect to a MS SQL Server 2012 geodatabase with the arcpy.ArcSDESQLExecute() when using the .sde connection file pre-created in ArcGIS. I am not able to connect to a MS SQL Server 2012 ...
3
votes
1answer
85 views

The layer is not a valid layer and can not be added to the map - QGIS WFS

I created workspace, store and layer in Geoserver. Data source is SQL Server 2012. When I connected Geoserver WFS to QGIS, it worked. But when I tried to save changes to layer, it crashed with error "...
10
votes
3answers
17k views

How I get SRID from Geometry field

what is the function for getting SRID from Geometry field. I have inserted a shapefile into SQLServer table with Geometry field defined. I know the projection of shapefile is Swreff99_1800 (EPSG:3011)....
1
vote
1answer
999 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
30 views

Is there a SQL Server package similar to Oracle's SDO_CS?

I see that Oracle's SDO_CS package is able to do datum transformations. I'd like to do datum transformations in SQL Server. I searched, but have not found something like this for SQL Server. Is ...
2
votes
2answers
300 views

SQL Error: Latitude values must be between -90 and 90 degrees

I'm more of an ArcGIS user than a SQL Server user but I have polygon data in a 'geography' type in SQL 2008 R2. For a couple of these poly layers, I get this persistent drawing error in ArcMap: ...
2
votes
0answers
33 views

Connecting QGIS 2.14.3 to SQL 2012 both on LocalHost or Remote

I am working on establishing MSSQL (2012) spatial connection from my QGIS 2.14.3, its giving me an error like: (Error opening connection: [Microsoft][SQL Server Native Client 11.0]Named Pipes ...
2
votes
0answers
647 views

No tables listed in connection to MSSQL 2012 in QGIS

I've (finally) made a connection to my MSSQL 2012 database, but no tables are listed. Here's the tree view of the connection, and the connection properties: Some notes and questions: I've read ...
1
vote
1answer
3k 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 ...
3
votes
1answer
85 views

QGIS MSSQL Spatial Layer Instant Crash

I am able to connect to the mssql server database and choose the table that contains the spatial data. However, as soon as the layer is added, I get the 'crash dumped' error with a message saying "...
4
votes
1answer
507 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 (...
1
vote
1answer
10 views

Joined MSSQL Tables are not editable

I want to join two tables(MSSQL tables) in qgis and then match some fields and insert/update them. however when I join two tables from DB Manager and show them as a new layer, I cannot edit any data. ...
0
votes
2answers
32 views

Verify with WKT point is in a polygon SQL

I'm using SQL Server and WKT to deal with geographic data. What I'd like to do is have something like : SELECT pt FROM point_table, polygon_table where pt.point_table WITHIN ply.polygon_table Here ...
0
votes
0answers
20 views

How can I load data into SQL Server spatial using SQL Server Integration Services?

How can I load data into SQL Server spatial using SQL Server Integration Services (SSIS)? I'm aware of other tools, like FME and ogr2ogr, but my only option is using SSIS
0
votes
0answers
6 views

Error found while retrieving conflicts ArcMap 10.3

I have a problem when trying to review Conflicts in ArcMap 10.3 I have found a similar question ,and in the solution there was a link to download ArcSDE service pack , but the link was invalid . ...
1
vote
1answer
430 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 ...
0
votes
0answers
23 views

QGIS MSSQL on OSX

Could someone please help me or point me to the right resource with my Question. I have an OSX machine, with QGis 2.12.1, and a windows instance with MSSQL running on AWS. For the life of me I cannot ...
6
votes
2answers
2k 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?
2
votes
0answers
366 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. ...
1
vote
0answers
43 views

Feature classes not visible to some ArcSDE users? [closed]

Some of my organization's data (several SDE databases) has been migrated to a new server and we have recently upgraded from ArcGIS 10.2 for Server to ArcGIS 10.4 for Server and SQL Server 2005 to SQL ...
3
votes
1answer
1k 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 ...
4
votes
0answers
241 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
22 views

SLD ogc filter for MS Sql server table

In geoserver only geometry type of SQL server table is detected. Which means SLD style can't be applied ogc filter tag. But none of my SQL server field beside geometry are detected by geoserver. How ...
1
vote
1answer
1k views

Importing Census TIGER Shape Files to SQL Server 2012?

I've been doing my research on how to import shape files into Microsoft SQL Server 2012. and am still unable to figure out how to do it after hours of playing around with it. I'll document what I've ...
1
vote
1answer
661 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
2answers
2k views

Why does ogr2ogr SHP import error out trying to create a database?

All, Can anyone tell me what the error is with OGR2OGR when trying to import a .SHP into MSSQLSPATIAL? ERROR 1: MSSQL Spatial driver doesn't currently support database creation. Please create ...
1
vote
1answer
312 views

Using M 'Measure' value in SQL Server 2008

MS Sql Server 2008 geometry type supports adding Z and M values to geometry objects, including linestrings. However, I cannot find any way to make use of these values, since methods such as ....
2
votes
0answers
27 views

Can not install Microsoft SQL Server 2012 Native Client on windows 10

I am trying to compile QGIS project myself. I am following the instructions below, which seems to be official guide but outdated. https://htmlpreview.github.io/?https://github.com/qgis/QGIS/blob/...
1
vote
0answers
32 views

many-to-many relation in Qgis usin MSSQL [on hold]

Does anyone know how to create many-to-many relation using QGIS and MS SQL? I have many pipes that are geometry and I need to place in them many cables (not geometry, table with attribute).
1
vote
2answers
209 views

Using CURRENT_DATE function on ArcSDE SQL Server Database?

I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the ...
8
votes
1answer
154 views

Given two lat/longs, how can I tell if they are within 1 mile of each other?

I'm trying to implement a very efficient check to see whether two points are within a mile of each other, or not. My current approach is to compute the Haversine distance, and then check to see if it'...
0
votes
0answers
14 views

How I can configure correclty Geonetwork 3.0.4 with SQL Server?

I tried to install the version of geonetwork 3.0.4 with sql server but I get this error: FileError: 'http://localhost:8084/geonetwork/catalog/lib/style/bootstrap-3.0.1/bootstrap.less' wasn't found (...
0
votes
0answers
11 views

QGIS server (2.14) AND MSSQL layer wiht sql auth

I have MSSQL layer (using sql auth) (made windows) published in qgis-server (ubuntu) . When tryin to access it QGIS says WFS says not valid layer, and i dont see any published layers. When trying to ...
3
votes
2answers
128 views

Delete table rows in non-spatial database using arcpy

Working on a python script that does a bit of spatial analysis on a few layers, a spatial join of those layers, and then pulls data from a couple of other tables and holds them all in an in_memory ...
0
votes
1answer
21 views

How find Nearest points using STBuffer and STContains in SQLServer using given point from point table?

This is the Query I am using now.. SELECT top 1 coloumname FROM tablename WHERE ROUND ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2 ORDER BY ...
1
vote
1answer
19 views

Update a count of the number of polygons which intesect with polygons in the update table

I have a table with 1km squares as polygons and I want to update a column with the number of spatial intersects in another table of polygons. Something like this [if count could be used here]; Update ...
0
votes
0answers
13 views

I'm trying to direct connect a Pictometry (EFS 2.7) install to a ArcGIS 10.3 SQL server geodatabase

I'm trying to point my Pictometry (EFS 2.7) install to a an ArcGIS 10.3 SQL server geodatabase, it previously worked connecting to an older arcsde service. Do I need to upgrade anything?
0
votes
3answers
2k views

Enabling SQL Server 2008 database to access it as Esri geodatabase via ArcSDE using ArcGIS 10.0?

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is). I'd like to convert them to geodatabases, first that 'MS SQL Server 2008', then Oracle. So, leave Oracle for a ...
1
vote
0answers
45 views

Need help in SQL constraints

let me explain my SQL server issue We have two tablesManholes and Basis, which are related to each other by GlobalID/Guid fields. In the Manhole table i set coded value domain for owner field (1....