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
14 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
7 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 ...
-2
votes
0answers
18 views

Which version of sql server is suitable for connect with ArcGIS in organization? [on hold]

Which version of sql server is suitable for connect with ArcGIS in organization? my windows is seven
1
vote
1answer
32 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
28 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
26 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
20 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
23 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
33 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
11 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
28 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 ...
0
votes
0answers
55 views

Error while connecting to Sql server Data Base

i use opengeo suite 4.1.1 with geoserver 2.5-snapshot i downloaded sql server server extension , i install it with both microsoft jdbc while connecting to sql server i recived this error Error ...
1
vote
0answers
22 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...
2
votes
0answers
90 views

Using arcpy.da.editor on a transactional version raising errors

I've run up against a wall trying to get an edit session to work on a version. These are the scenarios Ive gone through in the code and their error mesages: Setting up an edit session not as a ...
3
votes
2answers
80 views

What is the best way to get from wkt to shapefile in Python?

I am querying tables from a SQL-Server database and would like to convert the table into a shapefile. It has wkt geometries and wkb as columns in the table, along with other attributes that need to ...
0
votes
1answer
34 views

Is there a performance difference between SQL Server 2008 and 2008 R2?

We are currently hosting our ArcSDE geodatabase on SQL Server 2008 SP3. I was wondering if there'd be any type of performance boost if we jumped up to 2008 R2?
0
votes
0answers
18 views

ArcGIS Explorer “Play Time Animation” button missing

I've connected ArcGIS Explorer 2.0.0.2500 to my SQL Server data and the points come up on the map just fine (well, super slowly, but they come up). I have a datetime column in the table that has the ...
1
vote
0answers
31 views

Update enterprise database from shapefile data?

Where I work we recently moved our GIS data from GDB databases to an enterprise SQL database. We primarily use ArcGIS 10.2 to edit and maintain our internal data but we also receive ancillary data ...
9
votes
2answers
946 views

why do people use geometry to represent geography?

Historically I've mainly worked with simple latitude and longitude coordinates in a SQL Server. I stored them as a geography datatype in SQL Server, and rendered them on a variety of displays ...
2
votes
1answer
30 views

SQL Server equivelent to Arcmap Intersect for polygons?

I have three different sets of GEOMETRY Polygon datasets in SQL Server that completely overlap. I need to create a new dataset that has a polygon for each unique area of the three layers. So ...
0
votes
1answer
40 views

How to convert MapXtreme FeatureGeometry to something writable to sql server geometry type

I'm new in MapXtreme and I'm bit lost. I have polygon in MapXtreme 7.0 (in C#) saved as FeatureGeometry type. I need to save this in SqlServer 2008 as geometry type, but I don't have direct access to ...
2
votes
1answer
39 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
0
votes
0answers
116 views

Geometry datatype to latitude /Longitude MS SQL Server

I need to convert Sql Server geometry datatype to latitude /Longitude I have just imported a shapefile to my table (geometry) This query does not work:- select geom.Lat as [Latitude], ...
1
vote
0answers
23 views

Preventing Export Layer by user via ArcObjects?

In my project, I am using a Geodatabase (SQL Server) to store feature classes. I want to prevent users (who do not have permission to access or edit) exporting layers into shapefile or other ...
1
vote
0answers
73 views

How To Bulk Export Shapefiles Into Microsoft SQL Server using QGIS or PostGIS

Hey all thanks so much in advance for your help I have been researching this issue for a while. I have found two popularly suggested ways to preform this task: ogr2ogr - just take a shapefile and use ...
1
vote
1answer
55 views

Geoserver WFS features query inaccurate using SQL Server Backend with spatial index

I´m using Geoserver to query features through WFS in an Web Application with Openlayers as client. The queried layer is using SQL Server as backend storage. When applying a spatial index to the ...
2
votes
1answer
98 views

Fastest strategy for proximity searches in SQL Server 2012

This is my very first question here, so bear with me! I'm implementing a back end for a mobile app which will have to do proximity searches to find nearby POIs (points os interest). I know it's a ...
2
votes
1answer
76 views

using arcpy to get all database names within a server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
7
votes
2answers
262 views

Do I need ArcGIS for server to edit my MS SQL Server database?

Here is what I have: ArcGIS Desktop Advanced (10.2) & MS SQL Server 2008 R2 Here is my problem: I need to be able to connect to the ms sql server and import, export, create, and edit spatial ...
2
votes
0answers
31 views

Is there a way to eliminate duplicate 'point clusters' in SQL Server 2008 r2 spatial?

I am using the ST.Distance function to identify clusters of geometry data points. Each point has a unique reference number associated with it. I would like to eliminate duplicate clusters from the ...
0
votes
1answer
78 views

dealing with geometry that should be geography (bad coordinates)

I'm working on a project with a few publicly available datasets. One of them is from the USGS, it's their prediction of peak ground acceleration in 50 years. Here's a link, and here's what it looks ...
1
vote
1answer
22 views

Can adding of attribute table fields cause geoDB replica fail

We have a arcsde replica between 2 sql server geoDB, it is one way replica and our side is the child. Recently our scheduler to synchronize the replica failed. The parent side add fields in some ...
1
vote
0answers
32 views

Query Data from an Event Table in ArcGIS (Linear Referencing)

My goal is to store a bunch of past present and future Events in a central place from different vehicles, query those tables on demand and display the result in ArcMap. Note that right now, my Route ...
2
votes
1answer
62 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
0answers
43 views

Specifying which fields in SQL Server table are lat/longs using QGIS?

I have successfully connected my MSSQL DB to my project and I am trying to add a layer to represent the data in a table. I want to make a density map using the lat/longs that are stored in two fields ...
1
vote
1answer
226 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 ...
2
votes
0answers
31 views

split polyline at specific distance

I am working on a project that uses sql server for geometry datatype and arcgis server and asp.net website and entity framework for data access and arcgis javascript api for map viewer. I want to ...
1
vote
1answer
46 views

Replicate Geodatabase and append to main SDE database

I have my ArcSDE GDB on SQL Server 2005. This we are maintaining at our end at head office. Now we have installed ArcGIS editor license to regional offices. GIS technicians at regional offices can't ...
0
votes
0answers
82 views

How to convert multipolygons to a single polygon

I have converted a set of gps points to polygon and then using .makevalid() I saved them in sql server.But It converted them to multypolygons.Is there any way to fix this problem and convert them to ...
1
vote
1answer
81 views

Broken MSSQL provider in recent QGIS versions - has anyone experienced this?

I recently moved from QGIS 2.2 to 2.4.0 and in the process the MSSQL spatial data provider appears to have stopped working properly (behaviour is also the same with 2.5.0). QGIS will still connect ...
4
votes
2answers
107 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
2
votes
1answer
239 views

Converting set of points to polygon using C#?

I want to convert a set of gps ponints to polygon.I used a simple loop to convert it to a WKT and than used makevalid() in sql server and save it in a gemetry column in databasae.Is this way right?or ...
1
vote
1answer
70 views

StArea() in sqlserver is in which unit?

I have a problem with saving STArea in sqlserver. Here is a query where I get the area of a polygon: select Geometry::STGeomFromText('POLYGON ((51.3386535086000000 31.7951253522000000, ...
1
vote
1answer
55 views

How to perform SQL query using .STContains in MS SQL Server

I have a table that stores polygons and a table that stores points with a value field. Both sets of data are stored using the Geometry type in MS SQL Server. I have a simple requirement - I need to ...
1
vote
0answers
25 views

primary key in sql server uneditable in mapinfo attribute?

I trying create table relationship in sqlserver 2008 R2. Tables will have spatial table and non-spatial (tabular) . I having trouble while selecting varchar field as primary key, this field cannon be ...
1
vote
0answers
28 views

mapping and update data in database

We have two feature layers: layer A - drainage segment layer (along road outline) layer B - road centre line layer. In my SQL Server database I have a table storing the mapping information of ...
2
votes
2answers
178 views

Getting coordinates of shortest distance between point and line MS SQL 2008

I have a table of point data (POINTS) in a SQL Server 2008 database table (No ShortestLineTo Function!). Each one has a SpatialPoint field of type geography (4326). I have another table of line data ...
1
vote
1answer
50 views

Cannot Register Database

I want to publish a database to ArcGIS Server. When I try and register the database, I get this error: Can anyone help me? I am using ArcGIS Server and Desktop 10.2 with Microsoft SQL Server 2008. ...
1
vote
1answer
35 views

Start session edit on a specific layer on the map?

I created a GIS using ArcObjects, my application needs to be connected with a geodatabase stored in SQL Server. I used ARCSDE to connect my application to the database and when the database is ...
2
votes
1answer
86 views

ArcSDE performance and table changes on upgrade from 9.3 to 10.1?

I'm using ArcSDE 9.3 and SQL Server 2008 R2 and I want to migrate from ArcSDE 9.3 to ArcSDE 10.1. Is there any performance differences between ArcSDE 10.1 and ArcSDE 9.3 ? Is there any change ...