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.
816
questions
0
votes
0answers
22 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
12 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 ...
0
votes
0answers
29 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 ...
0
votes
0answers
7 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
65 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
9 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 ...
1
vote
0answers
21 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
27 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
46 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
29 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
29 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
28 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
36 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
9 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
21 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 ...
1
vote
1answer
63 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
36 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
44 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
80 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
150 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
87 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 ...
1
vote
0answers
30 views
How to get geographic data of any particular region of map in Geometry datatype format in SQL Server? [closed]
I am completely new to Geometry datatype format of a Microsoft SQL Server database. DataType is Geometry. If not wrong, geographic data contains latitude and longitude of each point of that map, ...
2
votes
0answers
30 views
Having functional copy of geodatabase in same SQL Server instance? [closed]
Having an Esri Enterprise geodatabase, I want to have a copy of the database in order to make some tests. I have an instance of SQL Server, and I do not want the overhead of installing and maintain ...
2
votes
0answers
45 views
Running ogr2ogr script batchfile from SQL fails due to temporary drive mapping
I am trying to run the SQL procedure
EXEC xp_CMDShell 'blahblah.bat'
which needs to run an ogr2ogr script to create a kml from sql. The batch file works if I run it alone but with SQL permissions it ...
0
votes
0answers
44 views
Google Earth like tool to direct query spatial data from an SQL database
I'm looking for a desktop reporting tool which allows me to query spatial SQL data via direct query. I'm looking for a simple application end user without any GIS knowledge can use. I've tested ...
1
vote
1answer
76 views
ArcCatalog not showing view just created? [closed]
I have a geodatabase with a feature layer of parcels and a scalar database of consumption data for those parcels. Using SQL Server 2012r2 and ArcGIS 10.5.
In ArcCatalog, I open the parcel database ...
0
votes
0answers
18 views
mssql Vectorlayer import have no Coordinatesystem
Hi I'am using QGIS Version 3.4.6. If I add a Vectorlayer out of my mssql database a CRS dialog pops up for choosing a coordinatesystem. Like loading layer without CRS.
uri = QgsDataSourceUri()
uri....
1
vote
1answer
46 views
Connect to a SQL Server database from MS Access [closed]
I have an existing Microsoft SQL Server database which has been configured as an Enterprise geodatabase. I want to access it in MS Access in order to extract data to populate a form. What is the ...
0
votes
2answers
25 views
Storing related tables and toolboxes within feature dataset?
I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset ...
1
vote
1answer
59 views
AutoCAD Map/Civil 3D Feature Data Object (FDO) layer displays but is no longer editable
Just over a week ago, one of our main GIS layers became uneditable. Our GIS layers are connected to AutoCAD Civil 3D (Fig.3) via an SQL Server Spatial Connection in the Task Pane. We were able to edit ...
0
votes
0answers
23 views
What would cause editing capability difference for same geodatabase connections?
In ArcMap 10.5.1, from Computer 'A', I am receiving a 'no editable feature layers' error when trying to edit feature class 'X' that is in a SQL Server Geodatabase. However, I am able to edit feature ...
1
vote
0answers
31 views
Copy Rows to SQL Server Table using ModelBuilder?
I want to copy a table in my GDB to a table in MSSQL server 2012.
I'm using the "Copy Rows" tool in ModelBuilder, but when I run it, I get the following error:
ERROR 000210: Cannot create output ...
0
votes
0answers
15 views
Field Names in ArcGIS Pro Query Layer for SQL Server Database [duplicate]
I successfully connected internal SQL Server Database to ArcGIS Pro and loaded a list of database tables it contains. When I want to create a Query Layer on the database I always run into the error ...
1
vote
1answer
43 views
Extract intersecting polygon from multipolygon search
I'm using the latest SQL Server and trying to build a query where i can search a database of spatial data and find the intersecting polygon.
The problem is that the spatial data can be of ...
2
votes
0answers
20 views
arcpy.ArcSDESQLExecute with UPDATE and OUTPUT
Is there a way to get OUTPUT through arcpy.ArcSDESQLExecute? Whatever I do I get only True. When running UPDATE through MS SQL Server Management Studio I get OBJECTID of all updated features (rows):
...
0
votes
1answer
111 views
OGR2OGR -overwrite mssql table is appending instead
I am running
Command '['C:\\OSGeo4W\\bin\\ogr2ogr.exe', '-progress', '-skipfailures', '-overwrite', '-lco', 'UPLOAD_GEOM_FORMAT=wkt',
'-t_srs', 'EPSG:28354', '-f', 'MSSQLSpatial', 'MSSQL:Server=xxx;...
0
votes
1answer
102 views
MSSQL performance with Geography (point within polygon)
I have a query, below, that works - however its very slow, looping through roughly 24,000 points per second. This is a rather high end production DB server with MSSQL and SDE, and in other instances a ...
0
votes
1answer
23 views
ogr2ogr Warning 502: Field name 'yyy xx' contains invalid characters. 'yyy_xx' will be used instead
On MSSQL tables/views that have field names with spaces or starting with a number we get the warning 502 re: replacing invalid characters with a _
As we re-injest some of these files into MSSQL and ...
0
votes
1answer
177 views
ogr2ogr conversion failed when converting the varchar value to data type int
I keep getting this Error 1 when I run the following on some tables
ogr2ogr -skipfailures -f "MapInfo File" -lco overwrite=yes -lco launder=no -lco relaxedFieldNameMatch "D:\QG\CREFNO.tab" "MSSQL:...
0
votes
1answer
56 views
Uploading TAB data to MSSQL using ogr2ogr
I have been trying various methods to import a shapefile into MSSQL but keep getting
FAILURE: no source datasource provided.
ATTEMPTS
ogr2ogr -f "MSSQL:Server=xxx;Database=_GIS_Test;UID=yyy;PWD=...
1
vote
1answer
82 views
Converting MSSQL linked MapInfo Tab file to a shapefile using ogr2ogr
I have some tab files that are actually references to a view in a MS SQL Server table. It looks like
begin_metadata
"\IsReadOnly" = "FALSE"
"\MapInfo" = ""
"\MapInfo\TableID" = "055372be-523f-430a-...
0
votes
0answers
19 views
In QGIS3 graphical modeler can I access a mssql based view as an input?
Is it possible to set the input file of "Extract by Attribute" to an mssql based table view?
In the drop down to choose the input DB I don't see the loaded db view and don't see a way to connect one ...
0
votes
1answer
230 views
Database support in GE Smallworld?
What database engine can be used for GE Smallworld?
I have poor information but I read about Smallword proprietary VMDS.
Is it possible to use Oracle or SQL Server?
2
votes
0answers
95 views
T-SQL Invalid Geometry Created by Intersection
I have two sets of geometries (A and B) in SQL Server 2016. I want to determine the overlap areas of those geometries from set A that intersect set B.
Most of the time this code works:
SELECT a....
1
vote
1answer
56 views
Using data from SQL Table instead of File Geodatabase Table
Does anyone know of a method to use the table from SQL Server table using OS Authentication, instead of a File Geodatabase Table in ArcPy?
I have been using the below to reference the table
...
0
votes
0answers
160 views
Connect to MSSQL from QGIS on Mac
I tried to connect to MSSQL from QGIS and I couldn't find any solution to my problem.
I install MSSQL on my Mac with Docker and try to connect QGIS with localhost(host=localhost) and left the DSN ...
1
vote
1answer
126 views
Open a MSSQL Spatial View in QGIS
I have created a view in MSSQL Server 2012 that does a spatial join as below:
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 100)) AS PID, DS.Dip_No, PB.SP_GEOMETRY
FROM dbo.Dipsites AS DS INNER JOIN
...
0
votes
0answers
39 views
export pymssql query to geodatabase table
I have thousands of databases in Microsoft SQL Server and I want the user to select the server and DB they want so I cannot use arcpy.ArcSDESQLExecute
I am trying to use pymssql to connect to the ...
1
vote
0answers
60 views
Load Raster from MS SQL Server into QGIS
Attempting to connect to an MS SQL database in QGIS.
Database connects fine, and all the vector items load correctly.
Rasters, however, appear as polygons, geometry column shows as FOOTPRINT, and ...
2
votes
1answer
196 views
How to access data from a registered SQL Server database in ArcGIS Server
Little bit of background on the problem: I have been working on a PHP application with an SQL Server backend. The application works through a web browser, but, I've recently been tasked with allowing ...
