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
7 views

Enterprise Geodatabase Replication for Offline Use

I need to have a consistently updated geodatabase that will go offline in Collector. I am open to new ways to do this. What I have been working on is below. Our environment: SQL Server 2012, ArcGIS ...
0
votes
0answers
33 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 ...
1
vote
1answer
33 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 ...
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 ...
2
votes
0answers
34 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 ...
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 ...
0
votes
0answers
22 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 . ...
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 ...
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 ...
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 ...
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 ...
2
votes
0answers
29 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 [closed]

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).
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 (...
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
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 ...
0
votes
1answer
22 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 ...
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?
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....
1
vote
2answers
59 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
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 ...
1
vote
0answers
14 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 ...
2
votes
1answer
61 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 ...
0
votes
0answers
29 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 ...
1
vote
0answers
36 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 ...
1
vote
1answer
77 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 ...
0
votes
1answer
16 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 ...
4
votes
1answer
109 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
48 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 ...
2
votes
0answers
19 views

Why does QGIS try to create spatial tables when loading into MSSQL Server?

When trying to load a layer from the QGIS layers panel or browsers panel, errors pop up that either the 'spatial_ref_sys' table or 'geometry_columns' table exists: If these tables exist already, ...
3
votes
2answers
133 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 ...
5
votes
1answer
55 views

Can ArcGis accept SQL field names with spaces?

Im working on an integration project that is providing data from our billing system to ArcGis. Field names can include spaces which are acceptable in SQL Server if enclosed in brackets eg: [Street ...
4
votes
1answer
63 views

Change feature class from ESRI native geometry to SQL Server geography

Original question: I have found a lot of documentation on importing and using query layers from SQL Server into ArcCatalog/ArcMap/etc. However, when you change the projection of a feature class or use ...
1
vote
2answers
46 views

Can raster maps be stored in a SQL Server spatial database?

Can raster maps be stored in a SQL Server spatial database? And if so, how? ... I'm aware of VARBINARY and FILESTREAM for images, but can only see GEOMETRIC and GEOGRAPHY for vector data
5
votes
1answer
52 views

Auto-generated field in ArcSDE for end user

The objective: Create a process where a coworker can open an .MXD, start editing, add a feature to represent a complaint, then add records in a related table to represent an inspection. Along the way, ...
0
votes
1answer
26 views

WMS of Geoserver SQL view shows nothing, however WFS works properly [closed]

I am using Geoserver to create a WMS service to serve data out of an SQL Server database. Everything works fine (WMS & WFS) untill I create an SQLView in Geoserver. The SQLView: SELECT * FROM ...
4
votes
0answers
39 views

Are there any MSSQL Licencing restrictions regarding ArcGIS Server Services

I use ArcGIS Server in conjuction with MSSQL Server 2012. According to my Database Administrator there could be licencing restrictions on the side of MSSQL when publishing Data over the web with ...
2
votes
0answers
27 views

Asp.net or MsSql Create bbox of a point proportional to image height and width

Short question is how do I create bbox dimensions that is proportional to image height and width? I'm working on a asp.net webservice to generate a map using geoserver. The parameters I have are ...
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'...
3
votes
0answers
51 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
0
votes
5answers
74 views

PDF Plotting from ArcGIS for Desktop?

I am experiencing a very annoying phenomenon at the moment when trying to plot an A0 PDF Plot and would be interested to hear if anyone has had a similar problem and whether there is a solution or ...
2
votes
0answers
32 views

How to properly deal with rectangles being curved on geographies?

I'm using Microsoft SQL Server to store simple data for administrative boundaries of the world (lots of polygons). I store this in a geography data type column. Afterwards I query these polygons by a ...
3
votes
1answer
87 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 "...
2
votes
2answers
90 views

Labeling MSSQL-Layer in QGIS 2.14

I am using QGIS 2.14 and have problems with labeling a layer. My layer is a MSSQL-Layer (from a GIS-Server) and the fieldtype I am using for labeling is a Sting (typename is nvarchar).If the string ...
1
vote
1answer
197 views

Spatial reference does not match data frame for Bing Maps

In ArcObjects I am loading Bing Maps as a base layer. It's coordinate system is esriSRProjCS3Type.esriSRProjCS_WGS1984WebMercatorMajorAuxSphere. On top of the base layer, I am trying to load points, ...
0
votes
0answers
28 views

Ignore database columns when inserting feature

I have a spatial table in MSSQL which has a "Geog" column that stores WKT and an "area" column that automatically populates based on the "Geog" geometry. This table is succesfully added in qgis and ...
0
votes
0answers
32 views

Google Earth and GeoServer as WFS-T overlay

I need to use Google Earth (Pro) as tool for editing MS SQL Server database content through GeoServer. Is there a way to connect GeoServer and Google Earth using WFS-T, or there is another way of ...
0
votes
2answers
60 views

SpatialPointsDataFrame too slow FOR LOOP

I've run into a small problem where my for loop has been running for 3.5 hrs+. I have a Geodataset in SQL Server with a field called Shape that stores co-ordinates in geometry data type. Firstly, I ...
0
votes
1answer
128 views

Read SQL Server Geometry datatype in R

I have two datasets that come from ArcGis, stored in SQL Server. I have a column called - Shape which is a geometry data type and the value looks like this: ...