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.
839
questions
0
votes
0answers
39 views
Copy tables from Server Database to a Geopackage with no geometry and with geometries using PyQGIS
I am making an application in PyQGIS that uses tables that are on an SQL server.
I want to make a copy of all those tables in a local Geopackage, because I want to use my application in my laptop ...
0
votes
0answers
21 views
Generate Points from inside SQL Geography
I have a shapefile which has been loaded into MS SQL-Server. Mostly polygons, but some multi-polygons as well.
For each record, I need to generate a list of say 50 points that are within the polygon. ...
2
votes
1answer
27 views
How are Modifications and Deletions represented when looking at enterprise geodatabase delta (add, delete) tables?
I'm trying to understand how to make sure a delete is a proper delete and not a modification, and vice versa. I'm using ArcGIS 10.2 and Enterprise geodatabase on MS SQL Server.
See below SQL:
select ...
0
votes
1answer
42 views
Using Python, how to get SQL Server queried points in the map?
Since days I'm struggling with this problem, did a lot of searching - also in this forum - but did not find the answer I need.
I have a layer 'Project' in QGIS that is connected to a spatial table in ...
2
votes
1answer
80 views
Using Python, how to select points within a certain radius of a certain point?
I have a spatial table in SQL Server with point features, and connected it to QGIS which neatly shows all points.
Now I want to select points in this table (and show them in the map) within a certain ...
-2
votes
1answer
35 views
SQL Server how to create spatial index? ( spatial query )
I know how to do spatial query,
Shape is my geometry type column.
bbox is well know text format of a bounding box
srid = 2229, you must specify this srid in where intersect clause
...
0
votes
1answer
35 views
GeoServer Microsoft SQLServer view not visible as WFS
I am running a GeoServer 2.16.2 that connects to a Microsoft SQL Server 2008 database using the SQL Server extension and the Microsoft JDBC Drivers. Java Version: AdoptOpenJDK: 1.8.0_242.
I can ...
1
vote
0answers
50 views
QGIS 3.10.3 failing to recognize EPSG:27700 on MS SQL data
If I load data that's held in EPSG:27700 (British National Grid) on a MSSQL Spatial database (v13.0.5622.0) into an instance of QGIS 3.10 (new project, defaulted to 27700), the CRS does not get ...
0
votes
0answers
14 views
Adjusting nodes in SQL
The intranet our company is using is combining shapes to form larger shapes. This is using code that is lost in the darkest realms of extremely bad practices, but for the most part it is okay.
...
1
vote
1answer
85 views
How do I transfer data from a geopackage to MS SQL server
I am trying to upload a geopackage (created with ogr2ogr though I don't think that matters) to a MS SQL Server 2008 instance.
I can't access the instance with ogrinfo all I can get is
C:\>...
0
votes
0answers
59 views
Connecting to Microsoft SQL Server from QGIS
I can't connect my QGIS to SQL Server.
This is my database:
This is my connection configuration to QGIS
If I press test connection it says "Driver not loaded". If i load database, there is ...
0
votes
1answer
27 views
Unable to connect to SQL Server tables with 10.5 ArcMap but it works with 10.7
I have a requirement where I need to connect to the SQL Server which I have created using ArcCatalog 10.7.
I have a requirement where I need to now use 10.5 version. But when I attempt to connect to ...
1
vote
1answer
132 views
Convert a SQL Server Geometry into PostGIS spatial data with Python and shapely
I'm trying to migrate spatial data from a SQL Server database to a PostGIS database with Python. I need this to be automated since its not just one table, but a lot tables in a lot of databases.
I am ...
1
vote
1answer
25 views
Display map object from SQL database in MapInfo with read only access to the database
I can connect MapInfo to a SQL database using a select statement to display the contents of a table in the SQL database. However, the table is not mapable and I only have read access to the database ...
1
vote
0answers
43 views
Poor performance when adding layer indexed ArcGIS Service layer to AGOL
My data sits in enterprise geoddatabases on Windows Server 2012, SQL Server manager.
I often add ArcGIS Server Web services to my AGOL maps and they perform really well. However, when I add a ...
0
votes
1answer
35 views
Slow SDE Performance After Append - Geometric Network
I had an odd thing happen today, I do almost daily appends to our fiber network (fiber, splices, etc) and usually, it goes smoothly and with no complications. For some reason, I had an Append stall ...
1
vote
2answers
90 views
Convert shapefile into usable data
I am new to GIS data.
Our organization uses ArcGIS to map parcels of land used for agriculture. The lowest addressable level is currently a single polygon, representing a parcel. Throughout the year, ...
2
votes
1answer
132 views
Can't convert a WKT with a Z value into a SQL Geometry value
I'm using nettopologysuite in c# to build a nettopology geometry object, and then save it as a geometry object in SQL. Generally this works fine, except i recent came up with (from a shapefile) the ...
1
vote
0answers
35 views
Pre-populating list in Survey123 using SQL Server column
What I currently have is a Survey which enters the data collected from the survey in a SQL Server table, I'd like for one of those columns in that table to become the choices in another survey.
If ...
0
votes
0answers
59 views
Export geodataframe with shapely polygon to sql server table (geometry)
I'm pulling open street map data into a geodataframe and looking to write the results to a sql server database. The geometry types are polygon and they are in shapely format. When I attempt to write ...
0
votes
1answer
102 views
Use PHP form to insert geometry from WKT into SQL Server 2017
I have a PHP 7.3 form that asks the user for a Name, a WKT and an SRID. I would like to upload the WKT and SRID to SQL Server 2017 so that it creates a geometric object in Upload_WKT_Test using ...
1
vote
0answers
29 views
ArcGIS Pro PostgreSQL SSH connection string
I am involved in a project where a SQL Server-base application is being retired and replaced with a PostgreSQL/PostGIS-based tool under development. There is a large amount of cross-checking to be ...
0
votes
1answer
69 views
Using geometry stored in SQL Server table instead of WKT as input to function
I am new to SQL Server,
I have a function called STVectorize that takes a geometry and breaks it down into its constituent vectors:
SELECT e.[id], e.[element_id], e.[subelement_id], e.[vector_id],
...
3
votes
2answers
226 views
Combining ST Buffer and Intersect with Where clause
I'm trying to create a buffer around a single point in a spatial entity and finding all the points from a different entity that fall within that buffer.
I tried two approaches. The code below runs ...
2
votes
1answer
111 views
Converting ArcSDE point data from image to MSSQL geometry
I have a bunch of points in an SDE table which is currently stored in an MSSQL database.
The full entry is below, while the data i'm trying to convert from binary to geometry is: ...
2
votes
0answers
28 views
Cannot save to shapefile using ogr2ogr [closed]
I am trying to fix a bug in some software that exports to Shapefile and/or MapInfo files. I am struggling to wrap my head around this OGR2OGR stuff.
The software will not export to shapefile and I ...
0
votes
0answers
58 views
Linking SQL Server database to ArcGIS Online
I'm not sure this is possible, and the ESRI documentation is a bit of a mess it seems. Or maybe it's not possible at all and the ESRI documentation is giving me the nearest it can.
Basically, the ...
0
votes
1answer
38 views
Editing Point Data Layer made from Database Table using ArcGIS Pro?
I have a project in ArcGIS Pro which is connected to a SQL Server Database. I made a point feature layer from one of the tables however I cannot add points to the layer. I connected to the database ...
2
votes
0answers
58 views
Passing parameters from QGIS to a SQL Server stored procedure and link this as new layer?
I'm new to QGIS and may not have understood the principle properly yet. I'm coming from database development.
Question: I have a stored procedure in SQL Server that uses a date range as a parameter. ...
0
votes
0answers
49 views
Deploy/ Copy Feature Class under users AD account with gis Schema,
This question is regarding to SQL Server 2017 and ArcMap or ArcMap Pro environment.
Little history: Currently GIS team deploying/Copying Feature class (FC) from ArcMap 10.4 or Pro under one SQL ...
0
votes
0answers
25 views
Assigning the same schema to multiple users in an enterprise geodatabase?
When I add a user to the database via ArcCatalog > Adminstration > Add User, it creates a schema for the user, and sets that schema as the default schema for the user. From then on, when the user ...
1
vote
0answers
37 views
Getting geodatabase to SQL Server
I am currently attempting to load in 1000 data sets I have in 1000 different tables. I need to do this in Microsoft SQL Server.
My data sources are either in Excel or geodatabases. The plan is to ...
1
vote
2answers
139 views
Reducing coordinate decimal places in WKT using C#?
I have imported several shapefiles into a Microsoft SQL Server 2017 database
When I use the STAsText() function on geography objects I get the following WKT:
SELECT [Adm0GeoBoundaryID]
,[...
2
votes
1answer
87 views
Optimising Large Spatial Queries in SQL
I'm sure similar answers have been given elsewhere but no matter what I have tried I am unable to optimise this query.
Details: TableA has 3.5mill records TableB Had 57000 records but I have ...
0
votes
0answers
75 views
Importing geographical data into SQL Server Spatial
I'm uploading a shapefile containing all the world geometries of each country into SQL Server.
The issue I'm facing is that for some of them I'm getting a SQL Exception during insert:
A .NET ...
7
votes
0answers
252 views
“Driver not loaded Driver not loaded” when trying to connect to MSSQL database in QGIS 3.8 on MacOS
When trying to create a new MSSQL Connection, I get an error saying: Error opening connection: Driver not loaded Driver not loaded.
I have tried both QGIS 3.8.0 and the newest pre-compiled QGIS 3.8.1 ...
1
vote
1answer
46 views
Measuring area covered by linestring
I have a trajectory given by GPS which I store as a ST_LineString() and I'd like to know the area covered by the line string. I know the "width" of the trajectory, but I'm not sure how to approach the ...
1
vote
0answers
203 views
SQL Server spatial data geometry type
I'm trying to link a GeoServer application to a SQL Server Spatial Database.
The spatial data has been saved as Geography, but GeoServer can read only Geometry type.
So I'm using the following script ...
1
vote
0answers
107 views
SQL server 2012 convert Multipolygon geometry to geography - GDA94 / MGA zone 55 coordinate reference system
Is there a way to convert geometry column value which has GDA94 / MGA zone 55 coordinate reference system into Geography value in SQL server 2012.
The layer is a multipolygon layer
We were having the ...
1
vote
0answers
31 views
Esri enterprise GDB features showing as non-spatial table in QGIS [closed]
Why are Esri's Enterprise geodatabase 10.4.1 (in MS SQL Server 2012) feature classes showing as non-spatial table/spatial type is 'no Geometry' in QGIS?
The storage properties of the feature class ...
0
votes
1answer
94 views
Viewing MSSQL data in QGIS
I am working with spatial data stored in an MSSQL 2012 database as varbinary. I am able to view the spatial data in SSMS with the following query:
SELECT geometry::STGeomFromWKB([column_name], 4955) ...
1
vote
0answers
45 views
Attribute objects in Enterprise geodatabase automatically
There is a Enterprise geodatabase (MS SQL Server, ArcGIS), it has about 100 feature classes. It is necessary to automate the process of populating a unique number to each object in the database. ...
0
votes
0answers
14 views
QGIS Map Server WDS with MSSQL Datasource Publish
Does QGIS Map Server support a WDS Layer with data driven from MSSQL.
Currently it states that the layer is invalid when trying to publish this type of layer within a project.
Any help would be ...
0
votes
0answers
22 views
Saving changed positions in SQL Server table X, Y columns
I have a SQL Server table with X,Y columns linked to QGIS 3.6, and I made a virtual layer of it using "MakePoint(X,Y,CRS_id) as geometry".
Now I want to shift a point in the map and have the change ...
2
votes
1answer
201 views
Non-spatial SQL Server table with X,Y fields directly in QGIS?
In QGIS 3.6 I linked a SQL Server table with a field 'X' and a field 'Y', together representing positions in a known co-ordinate system.
How can I show these positions directly in QGIS, without ...
1
vote
1answer
66 views
ST_Force2D in SQL Server alternative? 3D loading problems from QGIS to PostGIS
I am having problems loading a 3D layer from MS SQL Server to PostgreSQL PostGIS database with QGIS. The PostGIS data loader in DB Manager and other import tools in QGIS have problems with 3D export ...
0
votes
0answers
177 views
Load CSV file Polygon Column to Microsoft SQL Table
Is there a best practice for importing a polygon from CSV to SQL?
I have attempted to use the SQL Import and Export wizard to load it in as varchar(max) and then convert using geography::Parse(column)...
3
votes
1answer
96 views
Performance of arcpy.Exists() in SQL Server enterprise gdb environment
While iterating on a list containing table names,
I used arcpy.Exists() to check if a table/featureclass exists.
This action is very time consuming.
I've ended up using a database approach select ...
1
vote
2answers
1k views
Visualize geographic spatial data from SQL Server directly in PowerBI
Is it possible to directly query geographic spatial data form SQL Server in PowerBI like its possible with Tableau?
https://cloudblogs.microsoft.com/sqlserver/2018/05/14/visualize-geographic-spatial-...
0
votes
0answers
447 views
Error when register database with ArcGIS server, failure to access the DBMS
The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server:
Machine: DESKTOP-TFF79J4 [db: The connection property set was ...
