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)

1
vote
0answers
22 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
67 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
29 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
16 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
41 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 ...
2
votes
2answers
90 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
42 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
24 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
14 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
29 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
23 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
26 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
43 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
29 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
40 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
24 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
42 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
15 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
32 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
74 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
23 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
144 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
88 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
35 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
21 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
33 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
949 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
33 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
44 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
42 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
1answer
167 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
26 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
89 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
76 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
144 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
93 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
289 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
39 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
80 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
26 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
36 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
75 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
351 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
38 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
53 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
97 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
84 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
118 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 ...