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)

2
votes
1answer
15 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 ...
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
28 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
16 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
4 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
424 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
17 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
1k 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
337 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
34 views

Feature classes not visible to some ArcSDE users? [on hold]

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
229 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
19 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
638 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
304 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
17 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
28 views

many-to-many relation in Qgis usin MSSQL

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).
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 ...
1
vote
2answers
205 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
150 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
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 ...
0
votes
0answers
6 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
6 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
111 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
18 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
18 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
10 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?
1
vote
1answer
196 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? ...
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
44 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....
2
votes
1answer
57 views

Why would FME imported data into SQL Server not being found by QGIS?

Why is FME imported data into SQL Server not being found by QGIS? I've imported some MapInfo format data into SQL Server 2014 using FME. In SQL Management Studio (SSMS), I can do a query and the ...
1
vote
2answers
50 views

No ArcGIS Server License found

I have attached geodatabase "Riverside" to databases list in MS SQL SERVER 2012 Enterprise edition : After that I created two logins using : USE [master] GO CREATE LOGIN [sde] WITH PASSWORD='...
1
vote
0answers
13 views

Text imported into SQL Server using ogr2ogr had extra characters at the beginning

I've managed to import some MapInfo data sets into SQL Server using ogr2ogr But when I run a query in SQL Management Studio (SSMS), the various text fields look to be "blank" However if I use the ...
0
votes
0answers
24 views

Publishing kml service from ArcGIS Server

I'm publishing ArcGIS map service from ArcGIS Server 10.1 with kml capability enabled. Publish completes successfully. Published data is in coordinate system WGS_1984_UTM_38N, and is stored in SQL ...
2
votes
2answers
274 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: ...
1
vote
1answer
972 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 ...
1
vote
0answers
28 views

Which SQL Server spatial data type to use for UK data in SQL Server?

Which spatial data type should be used for UK data in SQL Server?, i.e. GEOMETRY or GEOGRAPHY? I'm aware of OS National Grid and my understanding is it's an X/Y coordinate system, covering from ...
2
votes
1answer
416 views

how to transform DB stored EPSG data to Geography data type in sql server

I have a 3 GB database in SQL Server, with certain points stored in float values. The points are stored in EPSG 3765. I would prefer to have them saved in the Geography datatype. I can not store them ...
0
votes
1answer
50 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
56 views

enable enterprise geodatabase error

I am trying to enable an enterprise database. I right click > enable and then navigate to our organizations keycode file. I get this error: Attribute Column Not found... (see screenshot) This ...
2
votes
1answer
170 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
12 views

How do you use ogrinfo with a SQL Server database?

How do you use ogrinfo with a SQL Server database? I've tracked down documentation on it at GDAL and it mentions ... datasource_name: The data source to open. May be a filename, directory or ...
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 ...
0
votes
2answers
621 views

how to reproject data in EPSG:4326 to 3857 using SharpMapv0.9 for display on google maps

I have data stored in SQL Server 2012 in EPSG:4326. I need to display this data on a google map in 3857. but without an ST_Transform function, I cannot determine how to convert my data on the fly to ...
4
votes
1answer
497 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 (...
4
votes
1answer
85 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 ...
1
vote
0answers
44 views

Can't specify OID field in arcpy.MakeQueryLayer_management

I manage a library of query layers and have recently had the need to apply the same update to a bunch of them at once. Seems the only way to do that in python is to create new ones and apply ...
7
votes
1answer
1k views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...