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

send attribute from 75,000 object polygon to 20Mil point database

I have sql server 2008 r2. I have two tables: PropertyParameters and REF_GEOID. Property Parameters has four columns: PropertyID, ParcelID, Lat, Long. REF_GEOID has two: GEOID and GEOM. GEOM is a ...
2
votes
0answers
27 views

Error inserting new column in ArcSDE table (ERROR 999999)

I am using a python script to populate a table with values I get from rasters files. I use arcpy.AddField_management to add a new column and arcpy.CalculateField_management to insert the values for ...
1
vote
1answer
14 views

Layers render very slowly when importing from sql

I am trying to get a handle on importing layers into qgis 2.6 using the "Add MSSQL Spatial Layer" option. I was able to import a layer successfully, but it seems to take a long time to render. Is ...
0
votes
0answers
28 views

Load OSM data into SQL Server

I'm learning how to implement my own routing system. First at all I want to load OpenStreet data into SQL Server. I have found this tutorial, that is very interesting. It explains how to create a ...
0
votes
0answers
23 views

How to make SQL Server buffer only on one side?

Is there any way to make a buffer on a linestring only on the right or the left side? If not, is there any way to translate the linestring?
1
vote
0answers
21 views

Can I do the sql server for find fnode and tnode?

Can I do the sql server for find fnode and tnode field?
1
vote
1answer
36 views

Is it possible to limit export feature class in ArcSDE to only some users?

I'm trying to manage user and their privileges in ArcSDE and sql server 2012. I can privilege the select and edit a layer for users. I can use just two privileges but i want to permit export feature ...
0
votes
0answers
16 views

Cannot connect MSSQL server from QGIS

I'm trying to connect to an MS SQL 2012 database from QGIS 2.8 on Windows and get this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "xxx" requested by the login. The ...
0
votes
0answers
4 views

how to make shapefile in geometry column of ms sql? [migrated]

I was tried ogr2ogr command like this. ogr2ogr -f "ESRI Shapefile" "C:\temp\sqlexport.shp" "MSSQL:server=[RemoteServerIp];database=[dbname];User Id=[user];Password=[password];trust_connection=yes;" ...
0
votes
1answer
23 views

How can i set permission to user for web editing using ArcGIS silverlight API

I want to develop a webGIS using ArcGIS silverlight api 3.1 . I'm using ArcGIS for server 10.2 , sql server 2012 .The Database is registered in ArcGIS Server. The webGIS must have an editing ...
0
votes
2answers
34 views

Geoserver WFS-T not saving edits from QGIS to MS SQL layer

I added a MS SQL layer from my Geoserver to QGIS. It will save changes for attributes in the table and it will save the file if I delete features. However, if I add a feature or change a feature, it ...
2
votes
1answer
57 views

File GeoDatabase Table is too large to export?

We need to query data from the national soils database. The data is in a file geodatabase (which is about 20 GB), but we need to query the data in a SQL Server environment. In ArcCatalog, I am able ...
0
votes
1answer
48 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
34 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
22 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
16 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
23 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
53 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
2answers
57 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
60 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
31 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
52 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
26 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
58 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
29 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
18 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
35 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
125 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
49 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
46 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
70 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
57 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
22 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
123 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
17 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
17 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
48 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
132 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
64 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
71 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
107 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
72 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
118 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
104 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
131 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
162 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
56 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
123 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 ...