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
1answer
311 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[ ...
1
vote
0answers
66 views

Hindi character support in MS SQL 2012

I have spatial MS SQL 2012 and i need to store hindi characters in a column. I tried using nvarchar datatype but I'm getting only "Question marks(????)". Is it possible to store non-english ...
1
vote
0answers
64 views

from shape files to a database [closed]

I've previously converted simple shape files to WKT so that I can store them in RDMS that has spatial capabilities. I'm a new user to QGIS, which I'm using to browse a shape file. But now I have a ...
1
vote
1answer
247 views

How to edit a layer in Geoserver, when we change table schema in a database (SQL Server)?

So, is there a way to change/edit SQL Server layer definition in Geoserver, when a table schema has been changed in a database ? Or you have to delete that layer and then build a new one ? Thanks!
1
vote
1answer
97 views

Cannot create new spatial database connection in ArcCatalog?

I have searched a lot in the net, but i just found Add Spatial Database Connection fails? here. However, I cannot see the confirmed answer. I want to know if anyone has found the solution? my ...
0
votes
1answer
76 views

Querying Arcgis file geodatabase from sql

I need to compare data in a sql db with data stored in an arcgis file geodatabase. I'm not interested in the spatial attributes, only the added text attributes. What's the easiest way to do this? I ...
1
vote
0answers
231 views

Split polyline feature in sql server 2012

Please find the below attached image. I have one point(in blue color) and polyline(in black color). Using the below sql server 2012 comment i got the nearest path(in red color) between ...
1
vote
1answer
1k views

accurately find the bounding box of geography polygons

Im displaying polygons on a map and have had issues with the spatial index where the index performs well only for certain data sets (large areas with low density / high density small map areas). I've ...
2
votes
0answers
117 views

Batch geocoding 1.5 million data points in SQL Server

I am currently attempting to batch geocode 1.5 million points that are stored in a sql database. The points are not very specific (ie only city, state points). I have used ArcGIS in the past but due ...
0
votes
1answer
340 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 ...
0
votes
1answer
28 views

GML TimePeriod mapping in MapForce

I made SQLServer database structure based on xsd schema I got. In that schema two fields have gml:TimePeriodType. In database I put two columns for each field of this type (begin and end) and the ...
1
vote
1answer
613 views

Connecting to SQL Server Geodatabase using ArcObject in C#

I am going to save a polygon that is created from points to remote geodatabase.I am new with arcobject and cant undrestand how it works..at this point I want to open a connection to database using ...
1
vote
0answers
28 views

Error trying to create mssql layer in geoserver

with mssql 2008 and the latest geoserver with the mssql store plugin, I can create a dbo connection with a mssql database and list the tables. When I try to create a layer with one of the tables which ...
0
votes
0answers
21 views

Auto-Increment Integer Field in a Feature Class [duplicate]

Does anyone know of a good way of auto-incrementing an integer field within a SDE feature class when the feature is created? I don't want to have a script run afterwards to populate the field and I'd ...
2
votes
1answer
207 views

Transform wkb to gml geometry using FME

Maybe (and probably) this is stupid question, but I am totaly new to FME and geometry conversion. I need to transform WKB field from SQLServer to GML geometry using FME software. How can I do this?
1
vote
2answers
157 views

STCentroid Question

Hi I'm not sure if I should ask in here or another SE site, however I was wondering if anyone knew if it is possible to configure the results from a STCentroid select statement? If I run a select ...
0
votes
0answers
157 views

How to improve performance using spatial indexing with STIntersects()

I am working on Spatial database. I need to check intersection of state geometry with geometry inside database. I am presently using the query as SELECT a.ID, a.OBJECTID, a.MSID, ...
0
votes
0answers
40 views

Query's “Get Unique Values” includes case variants that don't exist in attribute table

I ran a query on an ArcSDE 10.2 Feature Class to find features that do not follow our office's standard of being in uppercase. The "Get Unique Values" seems to return values that do not exist in the ...
0
votes
2answers
61 views

Arcgis Dynamic Mapservice from sqlserver 2008 r2

I publish the mapservices from the sqlserver2008 R2 through ArcSDE using ArcServer 10.1. Its fine i published, now i change the attributes of my existing gdb using ArcSDE. Now the updated information ...
0
votes
0answers
75 views

Error post installation ArcSDE for SQL server 2008

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then ...
2
votes
1answer
84 views

Can you run GIS Squirrel next to SDE?

My company has SDE to run our webmapping system. We want our arcbasic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can we run squirrel next ...
0
votes
1answer
60 views

Def Query to not display feature if it isn't attributed

I have a bunch of features that I don't want to keep checking if something is attributed. I I want to query it out to not show the geometry if a column has the default string 'NOT ATTRIBUTED' to it. ...
0
votes
1answer
232 views

OpenLayers with MVC and SQL Server

I have imported some shape files into SQL Server 2008. Now i want to use OpenLayers with my MVC 4 application to render those shape files from SQL Server Database. Any help in this regard?
2
votes
0answers
133 views

Convert Arcpy results to feature class in ArcMap 10.1

I am using ArcGIS 10.1 and am a newbie in Python. Currently we are executing stored procedure (from sql server) through ArcPy in ArcMap. I want to create feature class from executing following python ...
1
vote
2answers
409 views

Cannot connect to SQL Server Express 2014 from ArcMap 10.1?

I have ArcMap 10.1 and SQL Server Express 2014. I am trying to add a database server from ArcMap by following Arcmap>Catalog>Add database server>. But the connection is not being established. as far ...
0
votes
0answers
331 views

Export GeoJSON to MSSQL with UTF-8 encoding

I'm testing this command to migrate GeoJSON data to MSSQL table: ogr2ogr -f MSSQLSpatial "MSSQL:server=.\SQLEXPRESS;database=geodb;trusted_connection=yes" test.json -nln test It works beautifully, ...
0
votes
1answer
105 views

Communication between widgets (flex)

Default Communication between widgets hi, i'm new in flex, and im working on Webmapping application using flex 4.6, java, and sql server as database, i'm just trying to make a communication between ...
2
votes
1answer
121 views

Connecting to MSSQL 2008 R2 with QGIS 2.0.1

There have been questions related to this, but some of them seem out of date or no one has asked. I'm trying to connect to SQL Server 2008R2 using a MSSQL connection in QGIS. I'm not exactly sure if ...
1
vote
0answers
93 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
4
votes
2answers
229 views

Storing SRID:4326 data as Geometry or Geography?

I used OGR2OGR to import SRID 4326 point data into MSSQL Server. Didn't realize that it defaults to creating a geometry column instead of detecting the data as 4326 and creating a geography column. ...
2
votes
0answers
327 views

No tables listed in connection to MSSQL 2012 in QGIS

I've (finally) made a connection to my MSSQL 2012 database, but no tables are listed. Here's the tree view of the connection, and the connection properties: Some notes and questions: I've read ...
3
votes
1answer
178 views

How to Unlock feature classes in ArcCatalog that don't show user

In ArcCatalog there are some feature classes that are locked and don't show a user. After restarting SQL server, the feature classes remain locked. Any ideas as to what might be causing this and how I ...
2
votes
0answers
38 views

Need help deciding on a database and datatype [closed]

I realize that these questions should probably be directed to a DBA but I feel like you might have some experience in managing the same kind of data. We have an existing system where we are storing ...
0
votes
1answer
279 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 ...
0
votes
2answers
40 views

Consuming gml generated by sql server As.GML()

Sql server has a method As.GML to produce GML file from geography/geometric type. Is there a good example to utilize this GML on other mapping platform such as QGIS? I have ask a related question ...
1
vote
0answers
68 views

SQL 2012 shortestlineto method

I am trying to find the nearest centerline segment to an address point. I was hoping that I would be able to use the ShortestLineTo method, but it is not working. I have tested with Microsoft's ...
0
votes
1answer
548 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 ...
2
votes
0answers
249 views

Feature service requires registered database error?

I am working on ArcGIS Server 10.2 and SQL Server 2008. when I want to publish the service, I get this error "Feature service requires a registered database" that's error happen when I read (List By ...
1
vote
1answer
59 views

Access SQL database in postgres for routing

i am trying to access sql database in pgadminIII. Using postgres_fdw I am trying to connect. But I am struck in the middle..Following are the steps I followed CREATE EXTENSION postgres_fdw; CREATE ...
0
votes
0answers
131 views

Using Geometry commands in MS SQL Server 2008

I am looking to find the most effect way to use SDE and ST_Geometry SQL commands. Can anyone tell me how/what commands I might use to perform a spatial query in MS Sql Server 2008, to Select property ...
5
votes
1answer
101 views

Automate loading a table into SDE

How can I automatically load a table stored on a network share into SDE when the original table is edited? Environment is ESRI 10.1 ArcSDE on SQL Server. Preference for python or existing GP tools. ...
1
vote
1answer
329 views

ArcSDE/SQL Server Permissions

I have an enterprise geodatabase with about 20 users. Each user has a corresponding schema. When in Arc Catalog, if only the owned schema box is checked in SQL Management studio I receive a ...
2
votes
0answers
241 views

Bulk insert into MS SQL Creating ObjectID's

I am running an ETL from a spatial view into publication database. The view has results in duplicate ObjectID's. I started working with the get_ids SP example from ESRI, but that seems to be built ...
0
votes
0answers
144 views

How to store esri geometry types in sql server

I have a txt file containing some data of polylines. Actually it is saved json objects. The features in it are esriPolyLine objects. Now i want to store it in my sql server db as geography data types ...
3
votes
1answer
124 views

MS SQL Server 2012 to Postgresql

How to use MS SQL Server 2012 spatial database in postgresql using foreign data wrapper?
2
votes
1answer
278 views

Is it possible to get coordinate system name from SQL Server geometry type?

I need to get the name of the coordinate system of a geometry type field in SQL Server 2008 R2 (for example NAD_1983_UTM_Zone_14N or GCS_WGS_1984 or other). Is this possible?
1
vote
2answers
450 views

What is the best way to take a WKB value in SQL Server Management Studio and create a PostGIS geometry in PGAdmin III?

Normally, I would just use WKT strings but I'm investigating some possible geometry weirdness with the Text methods in SQL Server. I would like to copy/paste the WKB values from the SQL Server ...
4
votes
4answers
2k 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
1answer
153 views

Export data from .mxd file to ms sql database

I am using ArcGIS product (v.10.1). I have also tempalte of Maps from ArcGIS. But i need to get data from maps (.mxd files) to store it into MS SQL database. Explanation: I have application that has ...
3
votes
2answers
356 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?