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

WFS query against SQL Server - Returned results not restricted by query

I have an SQL Server 2012 table, which contains a DbGeometry column with a spatial index. Then a Geoserver 2.7 using it. The problem is that when I do a WFS query it doesn't restrict the results to ...
2
votes
2answers
45 views

Any free Tools to display more than 5000 geography objects in SQL Server?

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or ...
3
votes
1answer
43 views

Can a computer with ArcGIS Server connect to SQL Express in a different domain?

As you can see in my diagram, we have ArcGIS set up with 2 other computers for load balancing. We also have SQL Express 2008 but it's under a different domain. My manager's goal was to a) register ...
4
votes
1answer
52 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field ...
1
vote
0answers
90 views

What if 'geometry_columns' already exists in MSSQL Server Database?

When trying to load a .SHP into MSSQLSpatial using OGR2OGR, I get the following error: ERROR 1: Error initializing the metadata tables : [Microsoft][ODBC SQL Server Dr iver][SQL Server]There is ...
0
votes
0answers
32 views

Copying ArcSDE environment from LIVE to TEST with SQL Server?

I was looking for some advice on how best to go about migrating a copy of our LIVE sde environment across to our TEST sde environment which are on two separate servers - both running MS SQL 2012. I ...
1
vote
2answers
110 views

Using Python to backup ArcSDE geodatabase on SQL Server Express?

Is it possible to use Python to do a backup of ArcSDE databases stored in SQL Server Express? I have been using a custom executable that uses Arcobjects IDataServerManagerAdmin.BackupGeodatabase() ...
1
vote
0answers
68 views

QGIS Connection with MSSQL localdb not possible correctly

I installed MSSql Server Express with localDB. Everything looks ok. The connection with the LocalDB is nessesary and the tables and views are displayed in the QGIS MSSQL Dioalog. A primary key is ...
6
votes
3answers
601 views

How to convert from SQL Server geometry BLOB to something else?

I have a CSV data file from a 3rd party that is an exported SQL Server table. They simply did a select * from foo and output the result to a text file and sent it over. In their table is column of ...
3
votes
3answers
79 views

Migrate datatypes from geometry to geography in MS SQL

I have three ESRI feature classes (POINT, LINE and POLYGON) that contain a geometry datatype column with data in a projected coordinate system. I'm looking for a way that I can convert & project ...
6
votes
2answers
281 views

Draw SQL server geometry records as graphics on map using ArcGIS API for WPF 2.4 -can it be done and how?

I have records (of public festivals changing daily) in the in SQL server 2012 that have a geometry column (polygons where they occur). I need to show the records as graphics on a map using ArcGIS ...
0
votes
0answers
67 views

Reverse geocoding from sql server

I have a lot long/lat data in MS SQL Server, i want to do reverse geocoding by using openstreetmaps or some other free web service, and on the end i want to display all of that in report builder, does ...
0
votes
0answers
40 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
59 views

Does SQL Server Data Need to be Spatial

In reference to my previous question. I am looking for the benefits of telling SQL Server your data is spatial. For instance, I have a duplicate of that table generated by the Shape2SQL tool (see ...
0
votes
1answer
441 views

SQL Server Spatial Querying

I am looking for ways to learn querying for SQL Server Spatial (2008/2012). I have a table created from Shape2SQL and have been trying to run a simple intersection query to get results from that ...
1
vote
0answers
40 views

sql server geometry find points intersection buffer

How do I find the point of intersection of buffer?
2
votes
0answers
131 views

ArcGIS Operation Dashboard

I am working on ArcGIS operation Dashboard. There is an widget on the top left corner “ Model Manager”. Here the Model manager will read the data from ForecastStage_MPT and ForecastTimePT database ...
2
votes
0answers
62 views

How to create MBtiles from geoserver [closed]

How to generate mbtiles in geoserver? using openlayers for displaying geoserver layer for example calling wms layer like this new OpenLayers.Layer.WMS("Kanpur", ...
0
votes
0answers
41 views

How to load points in a SQL server polygon table?

I have a spatial table in SQL server which stores both points and polygons geometry and I am using the table to return geoJSON for API calls. I want to load some points to this table with shapetype ...
1
vote
1answer
163 views

why can one user register a geodatabase with the server and the other user can not?

So i have two users; arcgis_db and AD\raclark, one can publish a service the other can not. It all goes fine till i get to the 'service editor' screen and click 'analyze'. One user, arcgis_db comes ...
0
votes
0answers
28 views

GeoWebCache Speed SQL Server Store

How to increase GeoWebCache speed, Am using geoserver 2.7.2 for tile cache and data store creating from a SQL Server database it will take 1 day and above to complete cache and it terminated several ...
2
votes
0answers
131 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
0answers
195 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. While ...
0
votes
1answer
39 views

Error: Failed to convert: Database Connections… when trying to export to shape file

I have created a table with some derived data in SDE using sql server. The following is an example row of the table: T_OBJECTID T_GEOID T_STATE T_COUNTY T_TRACT T_NAME T_LSAD T_CENSUSAREA ...
0
votes
0answers
29 views

Styling MSSQL Layers in QGIS

I have set up Ordnance Survey MasterMap as 2 MSSQL layers (area and text) which are working great, I can style the layers as I would do usually with shape files but I'm struggling to work if it's ...
1
vote
0answers
34 views

Managing privileges for an ArcSDE database using SSMS

I am trying to mange users for my ArcSDE database via SSMS as opposed to tools in ArcGIS, to do this i want to set up two new user roles, data-viewer and data-editor, and then assign users to those ...
1
vote
1answer
224 views

Database connection fails when using db authentication, succeeds using OS

When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get "Connection was attempted with an older ...
0
votes
0answers
58 views

Remote SQL Server, Crystal Reports and Geospatial Join

I have: A remote SQL server (2008 R2) that I have access to (But NOT full control of) which contains my source data including OSGB 1936 Geometry [ESPG: 27700] In house SQL Server 2008 R2 A Crystal ...
1
vote
0answers
117 views

qgis unable to connect to ms sql server using sql authentication

I am getting the following error when I try to set up a connection to a MS SQL Server database using sql server authentication. I did find a bug report from 2014, but that was apparently fixed and ...
0
votes
1answer
114 views

SQL Server table not updating in ArcGIS Online map

I have a SQL Server table in my ArcGIS Online web app. It is related to 2 other feature classes also in my map. The source table is a non spatial table being related on a common field. Not sure ...
2
votes
1answer
106 views

How to correct topology area boundary errors (slivers/gaps) on arcs in arcgis / arcsde

I use arcgis 10.1 (arcinfo licence) with arcsde to connect to a SQL Server database. The initial dataset has around 100k polygons (used for land registration, having a resolution that is around 1cm ...
0
votes
1answer
35 views

How do I generate 3d WKT FROM A Sql Server geometry or geography types

If I have the point POINT (-75.45454 25.12345 1024 ) in a geometry or geography column in SQL Server, but render it with STAsText() I lose the Z dimension. SELECT geography::STGeomFromText('POINT ...
2
votes
1answer
133 views

convert ordnance survey easting and northing data to WGS84 latitude longitude values

The C# code published here is not very accurate as also mentioned by tanoshimi. I think this has to do with the lack of 'approximate Helmurt transformation'. Just curious is anyone aware of some ...
0
votes
0answers
132 views

MS SQL table with geometry field to feature class

I have a table in a native SQL database (no geodatabase, dc_geobank_public.sde in the code) with cca. 300 000 records and 18 fields. Two of the field contains projected X and Y coordinates, and one ...
1
vote
0answers
39 views

ArcGIS SQL Server - Using Windows Authentication

I want to use a domain level service account to manage my database connections. This account is added as a Windows authenticated account in SQL Server 2012 as a sysadmin. If I try to use this ...
2
votes
1answer
496 views

Adding SQL Trigger to update field on INSERT (multiple rows)

I have an address point Feature Class that has an addressID field. I am trying to write a trigger that will in effect auto increment this field when a new address is added to the map. I cannot alter ...
1
vote
2answers
63 views

Database Server Node vs. Database Connection Node

What are the main differences between the Server Node and the Connection Node? The only difference I have been able to find is that the Server Node is intended for administrative tasks while the ...
1
vote
0answers
152 views

FME 2015.1.01 and SQL Server 2012 Native Client Issues

I'm having trouble connecting to a SQL Server 2008 database from FME 2015.1.01 on a computer with SQL Server Management Studio 2012, including SQL Server Native Client. Here's the error message: MS ...
4
votes
1answer
48 views

Move/Shift a line toward x and y axises in SQL-Server

Is there a function in SQL Server to move/shift a geometry toward X or Y axises?
0
votes
1answer
233 views

Cannot add database connection using windows authetication SQL Server and ArcSDE 10.3

We can't seem to add a database connection from ArcSDE to sql server 2008 using ArcCatalog 10.3.1 from a specific computer with a specific username. When trying to add a database connection using this ...
1
vote
0answers
74 views

LOX table shows up instead of an address locator in SDE geodatabase on SQL server 2012

Tried to copy an address locator from a network share to an SDE database, that worked. Tried the same thing on another database and it shows up in the target geodatabase as an SDE table with LOX in ...
0
votes
0answers
38 views

Multiple editors

I am trying to have multiple editors editing the same layer at the same time. I am running ArcInfo v10.2 and have set up a SDE connection using sqlexpress. I have created a geodatabase on my personal ...
1
vote
1answer
127 views

Adding point layer in QGIS from SQL Server failing

I just downloaded QGIS a few days ago (version 2.8.2-Wien) but I am not able to get it to work as I thought it would. I tried pulling in spatial data from sql server (a "geometry" column containing ...
1
vote
1answer
176 views

How to import UTF-8 encoded Shapefiles into SQL Server?

I am trying to load a shape file to sql, using ogr2ogr and Shape2SQL tools. The shape file uses UTF-8 encoding, specified in a .cpg file, and confirmed when opening the file with QGIS. However, as ...
1
vote
1answer
196 views

Heatmap failing in QGIS (2.8.2-Wien)

I am super new to QGIS so I may be doing something really dumb, but it doesn't seem to work to create a heatmap in QGIS Desktop 2.8.2 (just downloaded this yesterday so I think it is the most current ...
0
votes
0answers
87 views

import table from sql database results in empty ouput - ArcMap

I am trying to import a table to a .gdb from a SQL Server database (not spatial). I can see the table's rows and data in ArcCatalog preview. When I import, there are no errors but I get a message: ...
2
votes
1answer
131 views

SQL Server Geography Query works but Geometry Query Does Not - Different Tables, Similar Schemas

I am trying to get a Geometry query to work. A similar Geography query works fine but I must work with a table that uses a Geometry type. Although the Geography version returns lots of records as ...
0
votes
0answers
128 views

Can't create address locator in SQL Express GDB

I am working out of a SQL Express ArcSDE geodatabase with ArcGIS 10.3.0 Standard and would like to create a composite address locator based on streets and parcels. I can copy and rebuild a streets ...
0
votes
0answers
51 views

Get table of adjacent polygons

I am using the cb_2013_us_zcta510_500k shapefile to push zipcode polygons. I have the shapefile, and a SQL Server table loaded where the polygon is loaded in the GEOG data type. What I need is to ...
1
vote
1answer
181 views

Directly querying a raster

I've done tons of work within ArcGIS to analyze and process rasters. I'm pretty well knowledgeable on that subject. A question has come in from my coworker who is attempting to populate elevation data ...