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
18 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 ...
4
votes
1answer
320 views

Has anyone successfully installed HAZUS MR4?

I am attempting to install HAZUS-MH MR4 (v1.4) on a Windows XP SP3 computer with ArcGIS 9.3 SP1 installed. The installation seems to be running fine up until it attempts to start services. Then it ...
0
votes
1answer
402 views

SQL Geometry Query similar to Select by Centroid

Does anyone know if it's possible to query SQL geometry by something like 'centroid of polygon'...similar to ArcMap's select by location? I'm using SQL Server 2008 R2 as the DBMS. I have two polygon ...
0
votes
0answers
28 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 ...
2
votes
1answer
137 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
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
1answer
227 views

How to edit feature in sqlserver geodatabase

I am using arcmap 10.2.1 and arcobject 10.2.1,I just want to conncet to a geodatabase and edit,add,delete a feature from a feature class using arcobject,I tried to connect to database and it works ...
2
votes
2answers
245 views

How can we generate GeoJSON from SQL data with latlong

Is there any way we can create GeoJSON from SQL server table with Latitude & Longitude Data?
3
votes
2answers
1k views

Can I fix 'qodbc3:unable to execute statement' when querying SQL Server 2008?

I was testing features of QGIS and its really cool.I tried to query each table using right click and query but I can't query sql server 2008 database : Error: An error occured when executing the ...
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
33 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 ...
4
votes
3answers
1k views

Convert Sql Server Spatial data to GeoJSON & plot on map

I have a sql server table with Geo spatial data. An example of row would be (with Column names): type: streetline code: 231001 geog: 0xE6100000011 ........ Centroid 0xE61000000C....... geom: ...
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
338 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
0
votes
2answers
2k views

How to use Sharpmap to display spatial data from MS SQL Server 2008

Can anyone show me a step by step example on how to use Sharpmap to display MS SQL server spatial data using C# as the programming language? Please note I have exploit some of the example online but ...
0
votes
1answer
36 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 - ...
2
votes
1answer
602 views

SQL Server 2008 Distance and Performance Problem

I had been working on PostGIS to do some geographic processes and due to some reasons, I had to start to use SQL Server 2008. I ported same code for SQL Server but performance is almost dying when I ...
0
votes
0answers
34 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
43 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
1answer
191 views

Can't create new geodatabase for SQLServer Express in ArcCatalog 10.0

I'm trying to create a new geodatabase in my local SQLExpress Database Server from ArcCatalog 10.0 (ArcInfo). I can create a database server entry just fine (image below): ESRI documentation has me ...
1
vote
1answer
269 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
8
votes
4answers
1k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
2
votes
1answer
375 views

SQL Server UNion of geography feature returns FULLGLOBE result?

I have some trouble with sql server 2012. I store coordinates of french cities in my database as geography object (with ESRI 4326) and i want to make the UNION of some cities. I have in result ...
1
vote
1answer
770 views

Plotting Multiple Points on Google Map using VB.net

I am creating a database application using VB.net and MSSQL 2012. I have retrieved a list of customer from the database and want to plot them on google map. At it stands, I can only plot the first ...
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 ...
1
vote
1answer
358 views

How to convert SQL Server Rasters to ASCII Grid?

I have 25km by 25km squares of the world in a relational database. Each square has coordinates for the top left and lower right corner as latitudes and longitudes. Each square also has an index ilat ...
1
vote
1answer
212 views

Union of several linestring to multilinestring using MS SQL Server

Followed Postgreql query is the existing one used to combine serveral linestring to a single multilinestring. is there any equivalent of this in SQLServer . SELECT ST_AsText(ST_Collect( ARRAY[ ...
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
1answer
184 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
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 ...
5
votes
2answers
604 views

Load and display a layer from SQL Server using PyQGIS

I'm having a go at using pyqgis from within the QGIS python console to load a layer from SQL Server and display it. I feel like I'm part way there but I'm having a real issue getting the layer to ...
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
1answer
1k views

Getting 001270 error : Consolidating the data failed while publishing as map service in ArcGIS for Server?

I am getting an error "001270 error" . I am inserting table for sql-server database and joining few records to polygon layer also I have lat,Lon data in few tables so I am displaying data using ...
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
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: ...
7
votes
1answer
578 views

Geoserver with SQL server consuming all my CPU

This question is long please bear me and my problem. SQL Server Query profiler The Sample Query from profiler that geoserver is running that corresponds to SLD I am using and not the SQL SERVER view I ...
2
votes
0answers
34 views

Shoehorning hierarchial data into ArcSDE for MS SQL Server?

I've been tasked with creating a set of tables to store hierarchical data within an ArcSDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
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 ...
4
votes
8answers
1k views

Any Good Map Rendering Engines for SqlGeometry/SqlGeography

Can anyone suggest good map rendering engines for MS SQL Server Spatial types (SqlGeometry/SqlGeography)? By rendering, I mean plot the geometries to a common image format such as png or jpeg with ...
1
vote
2answers
58 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
39 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 ...
2
votes
1answer
368 views

Why does a geoprocessing service fail every other time it is run?

I have a ArcGIS Server 10 geoprocessing service right now that takes in a string and runs a parameterized query to SQL Server 2008R2 through pyodbc. The service works, but only every other time. I can ...
1
vote
2answers
83 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 ...