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

SQL Server aggregate function in ogr2ogr command

I would like to define create a GeoJSON bounding box using SQL Server's EnvelopeAggregate function, embedded in an ogr2ogr command. I have the following command: ogr2ogr -f GeoJSON envelope.json ...
0
votes
0answers
74 views

Need to find a point a given distance along a linestring

Need to take a linestring and find a coord every x meters along the line. I tried using the SQL Server Spatial Tools and found .NET to be slow and after 5(ish) days of processing, SQL server (or .NET) ...
0
votes
1answer
38 views

ArcPy function for changing data source server properties inside mxds?

Is it possible to change the parameters highlighted in the screenshot below? If so which ArcPy function would do this? I know about and do not want to use the function that references .sde files on ...
0
votes
2answers
156 views

Downloading entire OSM world dataset and import into MS SQL

I am trying to download the entire dataset of OSM and placing into a MS SQL Database. Does anyone have any ideas of how to go about that?
0
votes
0answers
45 views

Triangulation of Cell Towers using MSQL Server Spatial

I need to triangulate a GSM Device by using known cell towers locations and GSM readings. All Data is in a MS SQL Server as Geometry Types. herewith an example of the data : here is also a SQL ...
0
votes
0answers
32 views

Looping all features of cursor onto SQL Server feature class?

It might be me but I've been experiencing something weird. (I actually tried what suggested in this thread Arcpy MakeFeatureLayer won't loop with no luck) What I'm trying to accomplish is to use ...
0
votes
1answer
40 views

Cleaning up inexact polygon unions

I have geography data stored in SQL Server and I am trying to merge polygons from two data sets together. The problem is that they do not line up exactly, so unioning them results in narrow gaps ...
0
votes
1answer
99 views

Convert SQL Server spatial table with unknown coordinate reference system to GeoJSON with ogr2ogr

I have a table in SQL Server with an STSrid of 0. I would like to convert this table to GeoJSON using ogr2ogr. The problem is, despite converting to EPSG:4326, the resulting coordinates are not valid ...
1
vote
1answer
283 views

SQL Server Convert GeoJson format into SQL geometry/spatial data

I'm using javascript and Openlayers 3 and to draw shapes or geometry in osm map. The data is in geojson format and i want to store it in SQL server 2008 R2 using SQL geometry or spatial data types. ...
0
votes
1answer
41 views

Listing geodatabases in local SQL Express Workgroup ArcSDE using ArcPy/Python? [duplicate]

I would like to create a list of the multiple geodatabases that sit in my local SQL Express Workgroup SDE server. I have set up a connection using the "Database Connections\Connection to ...
0
votes
0answers
42 views

Querying geom from MS SQL 2014 in PHP/PDO returns empty array

I'm using the following php code: $query = $dbconn->prepare("SELECT [geom].ToString() as geom FROM [the_table_im_using]"); $query->execute(); if($query->errorCode() != 0) { die("Query ...
0
votes
0answers
43 views

Mulitpart dissolve equivalent with SQL Server

SQL Server 2012 has introduced a handy set of geographic aggregate functions that is well summarized here. Among the aggregate functions are UnionAggregate and CollectionAggregate. UnionAggregate is ...
0
votes
0answers
54 views

Spatial results tab saying:One or more spatial objects were too large to display

I've saved country borders in my sql server 2012 as geography data from geojson files. It turns out that when I query all the boundaries that have an administration level 2, not all the polygons are ...
2
votes
2answers
141 views

GeoJson to Spatial Geography in sql server 2012, fix orientation of polygon

I've download from Mapzen many geoJson files related to countries with their respective administration level. Then I've parsed all the geoJson files and saved them to my sql server 2012 as geography ...
0
votes
1answer
73 views

Finding primary column in SQL Server table using QGIS?

I just created a SQL Server geometry columns table and a new table for testing in QGIS. However, QGIS still won't find the primary column in the table. I am creating the table this way: CREATE ...
0
votes
0answers
14 views

How to Aggregate data locations using 2010 Census block [duplicate]

I want to aggregate locations data specifically taxi drop off and pick points to census blocks to show taxi demand at a block level. I have a huge dataset of taxi drop off and pick up points around ...
1
vote
1answer
60 views

How to use LIKE clause/condition in Arcpy.Exists/Delete

I would like to delete several raster files in an ArcSDE SQL Server database. I would like to do so with Arcpy. How can I succesfully use a LIKE condition to delete all files in my database that ...
1
vote
1answer
43 views

Change field names in SQL Server Management Studio

I am building a spatial view using SQL Server Management Studio 2014. One of the tables I am using to build this view has field names that are not compatible with esri; the field names have slashes, ...
0
votes
0answers
50 views

Z and M values get lost when extending MS SQL geography Linestring by .STUnion

I'm trying to add new geography points with Z and M values to a geography linestring. This has to be SQL 2008 R2 compatible. I've found some references to .STUnion() and tried that. The linestrings ...
1
vote
0answers
58 views

GDAL MSSQL with numeric table names

I have many SHP tables organised by year, for example 2015_xx_data.shp that I have loaded into a MS SQL Server database using OGR2OGR. I have also loaded them into MySQL for a comparison. There are no ...
0
votes
0answers
25 views

Convert Lat and Long Data to Geometry datatype in SQL server [duplicate]

I need to convert Sql Server latitude /Longitude to geometry datatype I have just imported a csv to my table in my database. Table consist ID Begin_trip Lat Begin_trip Lng Drop_Lat Drop_Lng ...
2
votes
1answer
47 views

Clipping SQL Server LINESTRING geometry based on polygon without overlap in result?

Using DbGeometry and Entity Framework to work with Sql Geometry types. User can draw a line that can run outside of a given polygon. my validation traps that. I correct this by clipping the line to be ...
0
votes
1answer
78 views

Publishing views from microsoft sql server in geoserver

I am developing the application with open layers 3 and geoserver for serving WMS layers. The Layers are published from Microsoft SQL server in geoserver. In MSSQL server, there are two databases, ...
1
vote
3answers
431 views

How do I find points that are NOT within a list of polygons using MS SQL?

I have a table of points, and and a table of polygons. I have managed to build queries (MS SQL) to get the containing polygon for a given point, as well as listing all the points within a specified ...
1
vote
0answers
112 views

SQL Server Geometry draw rectangle around a line

I am VERY new to spatial data queries, so please bear with me. I have a LineString (geometry) in SQL Server and need to "draw" a rectangle around it, based on padding for the Width and the Height, ...
1
vote
1answer
135 views

Obtaining Centroid from Polygon in SQL Server 2008 R2

I have several spatial layers created in QGIS that are held as spatial data in SQL Server 2008 R2. What I want to do is to find the centroid (OS Easting and Northing) of the polygon from the geometry. ...
1
vote
0answers
38 views

ArcSDE post installation error?

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 when I ...
0
votes
1answer
557 views

Unable to register gdb with the server due to sql server client incompatibility

There are two virtual machines: One where I've created an enterprise geodatabase on a Microsft SQL 2014 server- with a Windows Server 2012 R2 64-bit Operating system And a second machine where ...
1
vote
1answer
22 views

Creating layer where more attributes are presented

I would like to create a layer in ArcGIS containing polylines, that are rendered by combination of more than one attribute. I can create layer where the polylines are of different thickness or ...
0
votes
1answer
33 views

How Update one table row with combare with the other polygon table using their geom in SQL Server

a-> points b -> Polygon i want to update city trow in table a with compare b of geom in SQL server this is the PostgreSQL Query update a set city=b.name from b where st_contains(b.the_geom, ...
0
votes
0answers
72 views

WFS query against SQL Server - Returned results not restricted by query

I have an SQL Server 2012 table, which contains a DbGeometry column with a spatial index. Then a Geoserver 2.7 using it. The problem is that when I do a WFS query it doesn't restrict the results to ...
2
votes
2answers
61 views

Any free Tools to display more than 5000 geography objects in SQL Server?

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or ...
3
votes
1answer
56 views

Can a computer with ArcGIS Server connect to SQL Express in a different domain?

As you can see in my diagram, we have ArcGIS set up with 2 other computers for load balancing. We also have SQL Express 2008 but it's under a different domain. My manager's goal was to a) register ...
4
votes
1answer
66 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field ...
1
vote
0answers
161 views

What if 'geometry_columns' already exists in MSSQL Server Database?

When trying to load a .SHP into MSSQLSpatial using OGR2OGR, I get the following error: ERROR 1: Error initializing the metadata tables : [Microsoft][ODBC SQL Server Dr iver][SQL Server]There is ...
0
votes
0answers
32 views

Copying ArcSDE environment from LIVE to TEST with SQL Server?

I was looking for some advice on how best to go about migrating a copy of our LIVE sde environment across to our TEST sde environment which are on two separate servers - both running MS SQL 2012. I ...
1
vote
2answers
175 views

Using Python to backup ArcSDE geodatabase on SQL Server Express?

Is it possible to use Python to do a backup of ArcSDE databases stored in SQL Server Express? I have been using a custom executable that uses Arcobjects IDataServerManagerAdmin.BackupGeodatabase() ...
1
vote
0answers
117 views

QGIS Connection with MSSQL localdb not possible correctly

I installed MSSql Server Express with localDB. Everything looks ok. The connection with the LocalDB is nessesary and the tables and views are displayed in the QGIS MSSQL Dioalog. A primary key is ...
7
votes
3answers
1k views

How to convert from SQL Server geometry BLOB to something else?

I have a CSV data file from a 3rd party that is an exported SQL Server table. They simply did a select * from foo and output the result to a text file and sent it over. In their table is column of ...
3
votes
3answers
119 views

Migrate datatypes from geometry to geography in MS SQL

I have three ESRI feature classes (POINT, LINE and POLYGON) that contain a geometry datatype column with data in a projected coordinate system. I'm looking for a way that I can convert & project ...
6
votes
2answers
370 views

Draw SQL server geometry records as graphics on map using ArcGIS API for WPF 2.4 -can it be done and how?

I have records (of public festivals changing daily) in the in SQL server 2012 that have a geometry column (polygons where they occur). I need to show the records as graphics on a map using ArcGIS ...
1
vote
0answers
129 views

Reverse geocoding from sql server

I have a lot long/lat data in MS SQL Server, i want to do reverse geocoding by using openstreetmaps or some other free web service, and on the end i want to display all of that in report builder, does ...
0
votes
1answer
49 views

Geodatabase disappears

I have an old ArcGIS 10.1 in my laptop. While I'm trying to create a geodatabase it gets created, but doesn't let me create new featureclass and/or feature dataset. I get the error:" failed to connect ...
1
vote
1answer
70 views

Does SQL Server Data Need to be Spatial

In reference to my previous question. I am looking for the benefits of telling SQL Server your data is spatial. For instance, I have a duplicate of that table generated by the Shape2SQL tool (see ...
1
vote
1answer
971 views

SQL Server Spatial Querying

I am looking for ways to learn querying for SQL Server Spatial (2008/2012). I have a table created from Shape2SQL and have been trying to run a simple intersection query to get results from that ...
1
vote
0answers
43 views

sql server geometry find points intersection buffer

How do I find the point of intersection of buffer?
2
votes
0answers
158 views

ArcGIS Operation Dashboard

I am working on ArcGIS operation Dashboard. There is an widget on the top left corner “ Model Manager”. Here the Model manager will read the data from ForecastStage_MPT and ForecastTimePT database ...
2
votes
0answers
83 views

How to create MBtiles from geoserver [closed]

How to generate mbtiles in geoserver? using openlayers for displaying geoserver layer for example calling wms layer like this new OpenLayers.Layer.WMS("Kanpur", ...
0
votes
0answers
66 views

How to load points in a SQL server polygon table?

I have a spatial table in SQL server which stores both points and polygons geometry and I am using the table to return geoJSON for API calls. I want to load some points to this table with shapetype ...
1
vote
1answer
276 views

why can one user register a geodatabase with the server and the other user can not?

So i have two users; arcgis_db and AD\raclark, one can publish a service the other can not. It all goes fine till i get to the 'service editor' screen and click 'analyze'. One user, arcgis_db comes ...