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
1answer
24 views

Using pymssql to create a table using python ArcMap 10.3

I am using ArcMap 10.3 have a my data in a geodatabase (MS SQL Server Express) and I am trying to write a python script that does a bunch of spatial and non-spatial data manipulation. I need to dump ...
0
votes
0answers
29 views

inherted .net extension not connecting to arcSDE in ArcMap10.2.2

I have a custom .net extension tool that is supposed to connect to a file geodatabase or SDE (SQL Server). The SDE connection fails to recognize it as valid. The file geodatabase connection works just ...
0
votes
1answer
10 views

Creating Shapefiles from MS SQL using ColdFusion/Java?

A client wants to export, from their MS SQL server, data into Shapefiles. I've looked around for a starting ground and have heard Ogr2Ogr mentioned and it seems intimidating. So I was wondering if ...
0
votes
0answers
8 views

How do I insert a Query Result into an existing Table?

I am attempting to create a map that displays the Service Area for Firestations within Toronto, In order to do this I need to identify the Length of all pathways. I tried using the calculate geometry ...
0
votes
1answer
13 views

'Find your nearest' type function with a large dataset

In a previous employment, I needed to display a "Distance to stockist" on our website. It would get your current co-ordinates (from a postcode or HTML5 geolocate) and then display a list of nearby ...
0
votes
0answers
34 views

SQL Server to Google Maps

Does someone have a beginning to end example of how to take data from a SQL Server geography type field and pass it to the Google Maps API to display the shape on a map? The geography data I'm ...
0
votes
0answers
10 views

Creating a point in a fixed distance and course

How can I create a point in a fixed distance and course from an existing point using the Microsoft SQL SqlGeography object ?
0
votes
1answer
39 views

What version of SQL Express to download?

I want to start working with Geodatabase replicas. What version of SQL Express 2014 should I download, at the sample at ESRI Help it is 2008R2, at Microsoft site there is the flowing options - ...
0
votes
0answers
35 views

Setup ArcGIS 10.2.2 and SQL Server 2012

I installed on Oracle VM VirtualBox two Windows Server 2008 R2. • One with ArcGIS Server and ArcGIS Desktop 10.2.2 10.2.2 • The second SQL Server 2012 in Mixed Mode Because I'm not connected to ...
0
votes
0answers
20 views

SQL XYZ tile server for OpenLayers

I am looking for some guidance to build a SQL XYZ tile server. I have a good understanding SQL Server and some experience with PostGIS. I currently generate the XYZ tiles from large raster images and ...
2
votes
1answer
44 views

Definition Query Current Date SQL Server Native Syntax Error 10.2?

I have this definition query that worked for a layer from a file geodatabase. Now the same query will not work from the same layer in an SDE. I am getting a 'SQL Server Native Client Syntax' error. ...
0
votes
0answers
19 views

How to Transform Many Projections Into One With SQL Server

I know very little SQL Server, but am quite familiar with Arc and Python. The data I want to transform is point data which is in a single table [ID], [X] [Y], [COORDSYS]. There are 5 possible ...
2
votes
0answers
36 views

ArcGIS server 10.1 rest api queries fail inconsistently

Apologies for length and xposting, here and geonet I have a set of map and esri feature services running on a 10.1 AGServer with SQL Server back end. When I query the layers for either the geometry ...
2
votes
0answers
26 views

Save edits before disconnecting users from enterprise geodatabase?

Is there any method that enables the Administrator to save the users edits before disconnecting them for an enterprise geodatabase. Because I am disconnecting users as shown in the screenshot, but ...
2
votes
0answers
15 views

SQL Server, Given a linestring with M value, what is the location of this other M value

We are investigating migrating a prototype into SQL Server (azure). We have LineStrings that also have M values. What we would like to do is given another M value find out what its geographical ...
1
vote
1answer
31 views

Coordinates from a SQL Server Inserts don't Show Results

I am trying to parse a JSON output file from an .Mxd file. All work fine and the following SQL Insert in SSMS using sample coordinates: delete from RoomData insert into RoomData ...
0
votes
0answers
92 views

C#, SQL Server Spatial Functions: Convert Polygon's Lat Long ESRI Polygon Values?

I have a C# program which parses a .kml file and reads polygonal Shape field's data and then does sql inserts to a SQL Server database. The value of the final_coords variable in code below is: ...
2
votes
1answer
35 views

Populate X and Y fields in SDE Point Data Using SQL trigger

Here is my situation. I am running ESRI ArcGIS Server and Desktop 10.2 on SQL Server 2008 R2. I would like to populate the Latitude and Longitude fields from point data (Signs data collected using ...
0
votes
1answer
42 views

Adding multiple users to an enterprise database in one go

I couldn’t figure out how to add multiple users to an Enterprise database in one go. Please consider the following situation: 1 ) I have an enterprise database named “ Test02” 2) Then I try to ...
1
vote
2answers
59 views

Converting OSGB easting and northing to geometry on the fly in SQL Server 2008 R2

I have a table in a database that contains an easting and a northing for broadband relay stations. I am trying to create a view in SQL Server 2008 R2 that I can use in QGIS and I want to create a ...
1
vote
0answers
40 views

SQL Error: Latitude values must be between -90 and 90 degrees

I'm more of an ArcGIS user than a SQL Server user but I have polygon data in a 'geography' type in SQL 2008 R2. For a couple of these poly layers, I get this persistent drawing error in ArcMap: ...
1
vote
1answer
21 views

Is there any way to know if a polygon is part of another bigger polygon(s) in SQL server?

Basicaly, what I am trying to do is we have a lot of geographical containers like territories, sub-territories etc. and the boundaries of each keep on changing all the times and I have to store the ...
1
vote
2answers
84 views

Order sql server spatial geometry distance by the nearest

I have a geometry column in a table, I want to get the N nearest neighbours; here is a specific example with the geography type DECLARE @PTO Geography = Geography::STPointFromText('POINT(-57.432546 ...
0
votes
1answer
15 views

Locking fields in ArcGIS to maintain integrity of last_edited_user field

I have a Collector for ArcGIS application which records the last_edited_user from the field, however post-processing needs to occur and overwrites my users from the field to my desktop user. Is there ...
1
vote
0answers
14 views

Using REST Services acquiring limited data from DataBase like LayerDefinition

I am working with ArcGIS Server 10.2 and MS SQL DB. I have a requirement in which i need to retrieve limited data using a query from a bulk data using the same Map Service REST URL which can give me ...
1
vote
1answer
43 views

Using CURRENT_DATE function on ArcSDE SQL Server Database?

I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the ...
2
votes
2answers
104 views

How to use SQL Server Spatial without ArcSDE

At work we are using ArcGIS 10.1 for fairly simple spatial data. We don't use the more advanced items such as topology that are available in Arc. We have a couple SQL Server databases for other ...
0
votes
2answers
61 views

ArcSDE Locks With No Owner

Running enterprise SDE on Sql Server 2008, ArcGIS 10.1, SP1. The issue is old locks on all feature classes within a specific feature dataset that aren't being released. When viewed with an admin ...
0
votes
0answers
59 views

API for Java and JavaScript app integration

Are there any APIs to make calls or integrate JavaScript functions to a Java written application? I have come across Rhino's liveconnect.js, but this is uncharted territory for me, and would like a ...
2
votes
1answer
89 views

Edit default version table view using SQL Server

I have a ArcSDE (10.3) geodatabase setup which is versioned as we have a few people working concurrently on the data. However, I want to run some background scripts in SQL Server to update the default ...
1
vote
1answer
66 views

FME Data Tranform and Concatenate Tables in DB without Key from Access to SQL

I have been able to do a conversion (in FME2013) from an Access DB to a SQL Express DB(in Desktop Workbench), adding some transformers to grab data from three of the tables, two of which have primary ...
3
votes
2answers
109 views

Creating a weekly FGDB backup of ArcSDE?

I need to create a script that will copy our county's parcel data, maintained in SDE/SQL, to a file geodatabase. This script will be run as a scheduled task over the weekend. What GP tool do you ...
0
votes
2answers
91 views

MS Sql Server 2012 UnionAggregate geometry fails in ArcMap

I have following two geometries. Geometry 1 (G1): MULTIPOLYGON (((148.134707676 -34.1519003565, 148.143738823 -34.1540810687, 148.14648294 -34.1396863245, 148.143196834 -34.1392361445, 148.140859243 ...
1
vote
0answers
20 views

what I do share data in sqlserver enterprise for server?

I want to create a web editing services using ArcGIS Server, but the following error occurs when I add an editor task and click on configure. "No Editable layers found". I am using Microsoft SQL ...
1
vote
0answers
122 views

Importing 2014 TIGER County Shape Files to 2012 SQL Server?

Last year, I figured out how to import TIGER Census Block shape files into 2012 SQL Server with no issues. I assumed I would use similar code to do the county shape files but I keep getting a few ...
3
votes
2answers
138 views

How to link spatial and nonspatial data that is housed on two database servers?

I'm working on a proof of concept. We are building a web map application where the data is split across two different database servers. The geometry is on ArcGIS server and the attributes or business ...
1
vote
0answers
55 views

SQL server in ArcGIS 10.2 Desktop

I am using ArcGIS 10.2, and previously using Oracle spatial as back end. Now the data providers have shifted to SQL providing core data using FTP which is being staged at SQL server. We need to ...
1
vote
1answer
104 views

Creating C# SqlGeography point with Z value

In C#, there appears to be only one method to create a SqlGeography Point object. It takes a lat/lon and SRID. But it can also have a Z and M value. How are these created? The Point class is ...
0
votes
0answers
35 views

SQL Server ShortestLineTo doesn't return an intersecting line

I have a LineString describing a path, and a Point, which is not on the line. I am trying to find the closest point to my POI on the line. I figured I'd get the ShortestLineTo between the two objects, ...
0
votes
0answers
106 views

SQL Server : find Intersecting geometries with a geometry using sql query

I asked this question on parallel site (h++p://stackoverflow.com)and think this is a better place to ask such questions I want to find all geometries in a table that intersects with spacial geometry ...
0
votes
0answers
65 views

How to convert geometric point to geographic point in SQL Server?

I am new to sql geometric and geographic types What I need is a way to convert a sql table of geometric points into geographic points?
0
votes
0answers
149 views

how to connect with MS sql server 2014 with Geo server 2.6

I am working with MS Sq l server 2014 and want to developed a web based application with Geo server 2.6 .............i am not able to see the MS Sq l server option in Data->Store please provide ...
1
vote
1answer
167 views

Trouble connecting to microsoft sql server 2008 from geoserver

I am having trouble connecting to ms sql server 2008 from geoserver. my ports seem to be fine. error message: Error creating data store, check the parameters. Error message: Unable to obtain ...
1
vote
1answer
35 views

Can't recreate missing address locators

My organization uses several address locators stored in SDE. The server license was recently updated, and shortly after, some of these locators simply disappeared -- they are no longer visible or ...
2
votes
0answers
175 views

Database connection (SDE) failed after database was renamed

I created an enterprise geodatabase in SQL Server 2008 R2 with ArcCatalog (10.2). It was connected via an sde file in ArcCatalog then. Then I had to rename the database from SQL Server Management ...
0
votes
0answers
22 views

How to create a simple Web-Application using ArcGIS-Server? [duplicate]

my organizsation uses ArcGIS Server to serve geodata stored in MSSQL with an SDE. There are many departments that use the web clients to view information, but there are no web applications that allow ...
1
vote
1answer
32 views

Is averaging the points for lines and multilines a valid method of getting the centroid?

I'm working with a SqlGeometry SqlServer DB and am a novice to GIS. I'm tasked with getting the centroid of a series of geometries from C#'s SqlGeometry object. This is fine as it has a GetCentroid ...
1
vote
1answer
75 views

ArcPy Export SQL Server to Shapefile gives RuntimeError: Object: Error in executing tool?

I have executed a stored procedure and want to export this layer to a shapefile. I feel like this should be an easy solution. I tried using arcpy.CopyFeatures_management and it threw an error. I am ...
1
vote
0answers
22 views

Needing to find parent zip code of a bunch of missing zip codes in the US

We're using MapPoint to export zip code / territory combinations. Unfortunately, the export doesn't include PO Box zip codes which mean that we're missing a lot of zip codes The PO Box zip codes are ...
1
vote
0answers
52 views

'OutofMemoryException' whilst data trasnfer

I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer ...