Questions tagged [sql-server]
Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
925
questions
1
vote
1
answer
16
views
Use ogr2ogr/ogrinfo to connect to MSSQL on Ubuntu Server
OS: Ubuntu Server 20.04; Software: GDAL/QGIS, ogr2ogr/ogrinfo
My goal is to use ogr to pull data from MSSQL as part of a longer process that I'm working on.
First step is to test out the connection ...
- 51
1
vote
0
answers
24
views
Setup a QGIS model to run on an Ubuntu server automatically
I made a QGIS model tool that pulls a copy of two datasets from a MSSQL db and runs several sets of geoprocessing tasks and outputs a single resulting dataset to a pgSQL db.
This process runs ...
- 51
1
vote
0
answers
37
views
Is there a faster approach to change a data type on a feature class field in ArcGIS Pro 2.9.5?
I've followed the "Calculate Field Tool" steps from this article https://support.esri.com/en/technical-article/000023089 to change the data type on a field but it takes so long to copy the ...
0
votes
1
answer
19
views
Configuring the database for a new GeoNetwork Installaion
I have some questions after reading the documentation for "Configuring the database" for version 4.0.x GeoNetwork.
The documentation states: "The database dialect is configured in /WEB-...
- 867
0
votes
1
answer
16
views
Force GeoServer to make use of carriage return from SQL Server
I'm completely new to GeoServer.
In desktop GIS I can use CHAR(13) in views on SQL Server to make GIS interpret a carriage return, when I visualize a label.
Is this possible using GeoServer?
As I ...
0
votes
0
answers
15
views
Visualise results from STUnion in SQL-Server 2008 R2
I have an SQL table which contains the buffers polygons of points. These buffers should now be aggregated any displayed as a single Polygon/Multipolygon. With the following command I think I can do a ...
- 10.1k
1
vote
0
answers
48
views
Issues saving and retrieving data from MS SQL Server with QGIS
Wondering if anyone has issues with geometry not loading into QGIS when sourced from MS SQL Server for following specific case.
Software specifics:
MS SQL Server spatial :15.0.2000.5 Standard Edition (...
- 11
3
votes
0
answers
81
views
QGIS has started putting all features into one row in Attribute Table
This is a bit of an odd one. We host our data in an Microsoft SQL Server database, and until a couple of weeks ago this was working fine. We've got about 17000 rows in it, all with a geometry.
When I ...
- 852
-2
votes
1
answer
54
views
Float data type data shows null in attribute table [duplicate]
When I tried to open table from MS SQL Server, float data type data shows null in the attribute table.
It only shows only one record.
- 3
0
votes
0
answers
31
views
Convert PostGIS to MS SQL inside web app using ogr2ogr.py and Docker
I am trying to convert a PostGIS database to a SQL Server database inside a running Flask app.
There are three docker containers running:
web: flask app
postgis: PostGIS database
mssql: MSSQL ...
- 101
1
vote
0
answers
36
views
Cannot Append date field - getting NULL values
I'm working on a standalone script that appends data from a SQL Server table onto an SDE db table. When working directly in ArcGIS Pro - the append works fine, but using a standalone script - dates ...
- 51
1
vote
1
answer
101
views
ArcGIS Pro unable to add SQL database object when new fields had been added
About 90% of the layers on my maps are query layers from SQL Server database connection. My typical workflow is to drag and drop the spatial objects from the Catalog pane into the map frame and then ...
- 11
0
votes
1
answer
86
views
SQL Server: Coordinate conversion from NZTM to WGS84
I got a table that has shape value in one of the columns. I am converting shape value into geo_json formate and calculating centroid value and saving in two columns. The coordinate system of shape ...
- 183
2
votes
1
answer
80
views
Loading MS SQL table into QGIS using PyQGIS
I'm hoping to have some pieces of code on hand that link QGIS to a MS SQL database. All the tables in the database lack geometry, but have X Y Z coordinates. The database is password protected but I ...
- 63
0
votes
0
answers
52
views
MSSQL : Find polygons with in a distance of a point
I am trying to find all polygons (both polygons and multipolygons) that are with in a certain distance of a point.
I have a table with both geography polygons and multipolygons. I want to set a point ...
0
votes
0
answers
41
views
Datatype mismatch in enterprise geodatabase
An ArcSDE geodatabase is connected to a Microsoft SQL Database Server. In my process, I run some SQL commands to push data from MS SQL Server into other applications. I received the following error ...
- 17
2
votes
1
answer
86
views
Publish UTM from geoserver using mssql geometry
I have my world lat, lon coordinates insert in an ms sql geometry column like this:
geometry::Point(56.120417, 10.159337, 0);
I have an ms sql store in geoserver and a layer that exposes these ...
- 123
0
votes
0
answers
57
views
Enterprise geodatabase maintenance Esri vs. SQL Server (rebuild index and update statistics)
I'm looking at two geodatabase maintenance practices and seeing if they need to be updated/refined, and I'm noticing that these can be accomplished via ESRI tools or directly via SQL / within SQL ...
- 11
0
votes
1
answer
31
views
Creating DbGeometry instances that honor SRID
I maintain an ArcMap Add-in tasked with allowing people to see & edit some native SQL shapes in ArcMap, which of course require working with SqlGeometry and DbGeometry types. Converting between ...
- 438
0
votes
1
answer
263
views
Microsoft SQL Server "There is already an object named 'geometry_columns' in the database" error
I have trouble adding new layers to the existing MS SQL Server database. Whenever I try to add any type of spatial layer I encounter an error, as follows:
[Microsoft][ODBC SQL Server Driver][SQL ...
2
votes
0
answers
96
views
Cannot add geometry layer to QGIS although geometry column is recognized
The geometry column POINT in the View (not Table) View_MyGeometry is generated in the SQL database GeoData with Microsoft SQL Server Management Studio. QGIS recognizes this column as a geometry column ...
- 361
0
votes
0
answers
79
views
GDAL Appending Shapefile to SQL Error: Ogr2ogr ERROR 1: MSSQL extents query returned a NULL value
I have an OGR2OGR script to append a shapefile to an existing SQL table, but I get the error 'Ogr2ogr ERROR 1: MSSQL extents query returned a NULL value'. I have seen discussions with various ...
- 123
0
votes
0
answers
30
views
High margin of error for circle point calculation
Created a circle of points, 50m, 100m, 150m and 200m from a central lat/lng (51.500421, -0.124754) using the sql functions below (one for the lat the other lng). My concern is with the accuracy of the ...
- 65
1
vote
0
answers
46
views
Create grid around lat/lng with same spacing on the diagonal points using SQL Server
As an example I have a lat/lng circled in red below. I want to create a grid of points using SQL Server at 50m intervals up to 200m from the centre point. But those points that are on a diagonal are ...
- 65
0
votes
0
answers
44
views
Join to MSSQL table with no geom
I'm using QGIS 3.22.5. I want to join an MS SQL Server (MSSQL) spatial table to an MSSQL non-spatial table. I don't see that I can do this. Am I missing something? Can someone tell me how to add a ...
- 1
0
votes
0
answers
82
views
Publish a query layer from ArcGIS Pro to your GIS Server to maintain connection
I have a query layer pulling from a SQL Server database that I use within ArcGIS Pro and am wondering if there is a way I can publish this to our GIS server (10.8.1) to maintain connectivity to the ...
- 5
0
votes
0
answers
39
views
QGIS and SQL Spatial Feature Classes with multiple Geometry Types
I have noticed when adding a multiple Geometry type SQL feature to QGIS it displays as a line and I can't see other geometries apart from line geometies. Is there a way I can see all features? I can ...
- 123
0
votes
1
answer
63
views
GIS layers created using FME 2021 not visible in QGIS
QGIS 3.24
SQL Server 2015
I have GIS layers in SQL Server created using ogr2ogr and FME2021
All the layers are created using my machine.
In my QGIS Desktop I can see all layers irrespective of how ...
0
votes
0
answers
23
views
Merging SQL Spatial Polygons in QGIS 3 Not Saving due to Incompatible Geometry Types
We have SQL Spatial tables which accept multi-polygons and even have multi-polygon features. In QGIS we can add a part to an existing polygon even if not adjacent, but when merging we can't save.
The ...
- 123
1
vote
0
answers
126
views
Check if connected to geodatabase as database owner (DBO) with ArcPy
I was wondering if anyone knows of a reasonable workflow with ArcPy, for ArcGIS Pro/Python3 (or ArcMap 10.8.1/Python2.7, but I'd prefer a solution for Pro), to check if a given *.SDE connection file ...
- 3,843
0
votes
0
answers
140
views
Writing from file geodatabase to SQL Server 2017 instance using ogr2ogr
I'm attempting to import a large feature class from a file geodatabase to my SQL Server 2017 instance using GDAL. I have tried many different options on the ogr2ogr command and nothing seems to work. ...
- 437
0
votes
0
answers
31
views
JoinField doesn't concatenate date type fields from database view
I'm using this code to make a join to a SQL Server database view.
arcpy.management.MakeQueryTable(CEView, "CE", "USE_KEY_FIELDS", "SID")
arcpy.management.JoinField(...
- 11
1
vote
0
answers
173
views
Joining tables by more than one field in ArcGIS Pro
I am joining multiple tables together with different aspects of chemical analysis result data. Some of the joins need to match up with more than just the field they are being joined on. (I am ...
1
vote
1
answer
69
views
Deleted point layer reappears upon refresh in ArcGIS Pro
I've deleted a point layer from a SQL Server geodatabase in ArcGIS Pro (using the Pro UI). The deletion appears successful but upon refresh of the geodatabase, it reappears.
I haven't really seen ...
0
votes
0
answers
30
views
SQL Server WKT crosses antimeridian - sqlgeography looks normal, sqlgeometry does not
I have a WKT that crosses the antimeridian and is stored in SQL Server as a geometry. But when I read it back out it is stretched/skewed. If I take the WKT from the geometry, and create a geography ...
- 131
1
vote
0
answers
45
views
Update a table from a geodatabse
I use a Geodatabase on SQL Server, on which I base myself to configure tables of the bors and maps.
I tried to modify a few items in a table in this Geodatabase with a simple query (UPDATE...SET). I ...
- 21
0
votes
1
answer
67
views
In GeoServer, when adding a layer, how to list all tables when using a "Microsoft SQL Server" store?
Presently all the tables are listed when attempting to add a layer from a SQL Server store but the schema is not shown nor used in the definition. My database has about 3k tables so I'm thinking ...
- 2,851
0
votes
1
answer
512
views
Intersect points with polygons using SQL Server query from ArcGIS Enterprise Geodatabase
I have 2 databases in ArcGIS Enterprise Geodatabase in SQL Server. One database (DB_A) contains a feature class with points and the other database (DB_B) contains a feature class with polygons. I'd ...
- 271
0
votes
0
answers
250
views
MSSQL tables not displaying in QGIS and MapInfo depending on load process
Some tables in MSSQL are not available in QGIS or MapInfo but can be seen by Management Studio on the same machine.
QGIS
MapInfo
The ones visible (and with geom) in QGIS were loaded using the '...
- 7,898
0
votes
1
answer
20
views
Dataset won't upload with datastore
I have an SQL Server database that I have connected to Portal using a datastore. There are three datasets inside this database but for some reason only one of the three datasets are actually uploading ...
- 11
0
votes
0
answers
34
views
Batch Update GIS Data in QGIS
I am looking to batch update data in QGIS. Basically my QGIS Project data is connected to a SQL server. I have to update several hundred attributes with new data. I have the updated data in an excel ...
- 1
1
vote
1
answer
144
views
Does QGIS import SQL Server data or query it?
I have a SQL Server DB with about 200GB of various datapoints stored on server.
When I use this datasource in QGIS from my PC would all the data be imported?
I.e do I need to make sure I have 200GB ...
- 11
3
votes
0
answers
148
views
Efficient way to "gridify" SQLGeography shape
Read the "Background" below for full details of why I want to achieve this.
Given a shape, I would like to process it in such a way that it conforms to a 0.00001 x 0.00001 degree grid. (This ...
- 31
0
votes
0
answers
141
views
Unable to connect ArcPy with ArcMap to MS SQL Server accessed via ArcSDE
Why can I not connect my ArcPy to our enterprise database hosted on a Microsoft SQL Server?
I'm running Python 2.7, ArcMap 10.6.1, MSSQL Server 12.0 (2014)
I've created an SDE connection file in ...
- 71
0
votes
1
answer
54
views
Changing the origins of SQL Server polygon geometry
I've got a table with polygon geometries, all with their origins @ (0,0). I want to recreate these polygons with the same dimensions, but at different origin points(x,y). Because all the original ...
- 33
1
vote
0
answers
139
views
Converting GeoJSON point into polygon in React
I have a JSON file of areas making polygon. I have saved those files in SQL Server database so i convert GeoJSON into CSV and import in my database and now i want to connect database with React.js.
...
1
vote
0
answers
479
views
"Driver not loaded Driver not loaded" when adding MSSQL layer in QGIS
Similar problem as here and elsewhere...
When I try to Add MSSQL Spatial Layer to connect to an Azure-hosted MS SQL Server database, I get Error opening connection: Driver not loaded Driver not loaded ...
- 11
0
votes
0
answers
37
views
Can OpenLayers be used to show/edit electrical Single Line Diagram (SLD)
I have some spatial data source(SQL server tables with geometry fields) that contain
spatial data for single line diagram or SLD(here does not stand for styled layer descriptor) of electrical networks....
- 826
0
votes
1
answer
208
views
Getting all Datasets and/or Feature classes and consequently spatial data from Esri Structures in MS SQL
I'm looking for query Esri data on MS SQL Server (best by using pure SQL).
So far I'm using ArcPy from Esri Python toolset but that is far from being optimal.
Example of iterating through the entire ...
- 47
1
vote
1
answer
983
views
SQL Server STIntersects, STDistance and STCointains with Lat Lon points and Geometry Polygons [closed]
I need to create 3 functions in SQL Server (2017) that has to do the following:
IsPointInsideTown(Point, TownCode, [SRID]) -> true/false: indicates if the point is inside the town's polygon.
...
- 319