No announcements
-
0 Votesupload to database is not working
when i click upload to database button after upload the file and selecting the table it doesnot work.I am using 2017 managment studio and 2017 sql server.Unanswered | 3 Replies | 102 Views | Created by Sohaib Ibne Ali - Saturday, December 02, 2017 8:33 AM | Last reply by Olaf Helper - Monday, December 04, 2017 9:04 AM
-
0 Votes
Is it possible to leverage partition elimination when using a spatial index?
I have a large multi-tenant table whose clustered and non clustered indexes all use a partitioning scheme such that data for each tenant is in a dedicated partition. All queries against the ...Unanswered | 7 Replies | 314 Views | Created by Matthew.Bell - Friday, October 20, 2017 1:48 AM | Last reply by Teige Gao - Tuesday, October 31, 2017 5:49 AM -
0 Votes
Weird results with STBuffer and small negative distance (SQL 2012 and SQL 2016)
Hi there, We've come up with some weird results with trimming a shape with STBuffer and I'm wondering if anyone has any thoughts on it. With 2008 we can add a ...Unanswered | 1 Replies | 181 Views | Created by Rob Thiem - Thursday, October 19, 2017 6:56 AM | Last reply by Lin Leng - Friday, October 20, 2017 7:31 AM -
1 Votes
geography.STContains() or STIntersects() doesn't work
The following simple query doesn't work (i.e. it doesn't give the correct result). DECLARE @g geography; DECLARE @h geography; SET @g = ...Unanswered | 5 Replies | 5489 Views | Created by DilipK - Monday, July 15, 2013 11:26 PM | Last reply by baodad1 - Wednesday, October 11, 2017 11:15 PM -
0 Votes
STIntersects is saying every polygon in my table intersects
I have this query to pull all records within a bounding box I am running against Azure SQL. select risklevel, id, lat2, lng2, sitenames, siteids, listtypes, ...Proposed | 2 Replies | 267 Views | Created by Brad Mathews - Friday, September 29, 2017 12:16 AM | Last reply by Brad Mathews - Tuesday, October 10, 2017 2:15 AM -
1 Votes
Converting OSGB36 to WGS84 with ProjNet; Doing My Head In
I realise this isn't really related to SQL Server spatial objects, but I do want to put the finished CLR assembly into SS, so I'm hoping someone will take pity on me. I started ...Answered | 10 Replies | 16103 Views | Created by ckl42 - Friday, September 16, 2011 5:25 PM | Last reply by id_bates - Thursday, October 05, 2017 12:38 PM -
1 Votes
Good book for teaching/learning SQL Server Spatial
Hello, I am looking for a good book on learning/teaching MS SQL Server Spatial. I have been able to locate one that I am familiar with as a good book (Pro spatial with SQL server ...Proposed | 1 Replies | 322 Views | Created by jderekito - Monday, September 18, 2017 2:44 PM | Last reply by Teige Gao - Tuesday, September 19, 2017 2:30 AM -
0 Votes
Speed up "point intesects polygon" queries
Hi all, I wrote a CLR function that sped up "Point.STIntersects(Polygon)" type queries in SQL server (and oracle/postgres when using the same algorithm) by x10-100 times a ... -
1 Votes
WKT STArea value is huge (looks like a bug)
Trying to get the area of the following polygon returns a huge value: 510064605194832. DECLARE @g geography;SET @g = ...Answered | 2 Replies | 1780 Views | Created by Jaime.Ad - Wednesday, March 19, 2014 4:47 PM | Last reply by Wyatt - Thursday, August 31, 2017 2:59 AM -
0 Votes
Optimal Update Query for Polygon within Polygon
Hi I have two tables of spatial (polygon geography) data. Table A has 22m rows, table B has 115m rows. For each polygon in table B, I want to find the containing polygon in table A. ...Proposed | 7 Replies | 448 Views | Created by ckl42 - Friday, August 18, 2017 3:31 PM | Last reply by Teige Gao - Wednesday, August 30, 2017 8:27 AM -
1 Votes
Manipulating spatial data through some language.
Hello people, I'm new to SQL Server 2016, be patient, anyway, I was reading the documentation, specifically on spatial data, and I did not find an API that would allow me to manipulate ...Answered | 1 Replies | 404 Views | Created by luminier - Wednesday, August 02, 2017 7:23 PM | Last reply by Teige Gao - Thursday, August 03, 2017 7:32 AM -
0 Votes
Geometry.STIsValid incorrectly claiming invalid geometry for long LINESTRING
Has anyone seen anything similar to this before? In the following code, @geomA has STIsValid = 0, with the error "24413: Not valid because of two overlapping edges in curve ...Unanswered | 1 Replies | 465 Views | Created by Howard Urmenyi - Friday, July 28, 2017 9:55 AM | Last reply by Teige Gao - Monday, July 31, 2017 6:20 AM -
0 Votes
How to import a file geodatabase to SQL Server using a Python Script?
How to import a file geodatabase to SQL Server using a Python Script? Are there any limitations? Which modules can I use to create a python script? Is pyodbc module the most appropriate one? Anyone ...Unanswered | 1 Replies | 556 Views | Created by Manuela Sabatino - Sunday, July 23, 2017 3:51 PM | Last reply by Teige Gao - Monday, July 24, 2017 2:24 AM -
0 Votes
Sql Server 2008 Geometry Storage with ArcSDE
Hi, Using SQL Server 2008 r2 sp3 with SQL Server Spatial in Geometry storage and ArcSDE (ESRI). It is sitting in a VM. The database is around 20GB in size with ...Unanswered | 7 Replies | 556 Views | Created by Anthea Tung - Thursday, July 13, 2017 7:00 PM | Last reply by Anthea Tung - Thursday, July 20, 2017 1:37 AM -
0 Votes
SqlServer.Types version on Azure
Hey, Im having issues getting the versions correct for local DBs and Azure DBs returning SqlGeometry types. Its worked fine for ages however a recent local ...Unanswered | 4 Replies | 625 Views | Created by Scoott_Adams - Tuesday, July 04, 2017 3:39 PM | Last reply by Scoott_Adams - Thursday, July 06, 2017 2:40 PM -
0 Votes
COMException on UnionAggregate
Hello, I've run into a weird issue with geography::UnionAggregate. I'm having a problem where it throws a COMException with an HRESULT of E_FAIL. I've only noticed it ... -
0 Votes
Convert Long/Lat to UTM WGS 84
Hi Really hope you can help, have been searching for some time with no real solutions yet. Im running SQL SPs that do a bunch of calculations from location data received ...Answered | 3 Replies | 22731 Views | Created by C.A.Y - Thursday, June 03, 2010 8:43 AM | Last reply by OmarLc28 - Tuesday, June 27, 2017 2:29 PM -
0 Votes
REBUILD SPATIAL index taking too long
Hi, We have a table with a "geography" column that stores vectorial data. This table stores about 50 million registers. We have a ...Proposed | 1 Replies | 699 Views | Created by Bruno da Fonseca - Monday, June 05, 2017 2:26 PM | Last reply by Lin Leng - Wednesday, June 07, 2017 7:45 AM -
0 Votes
Tool to reverse points in polygons?
I've downloaded polygon data from the MapBender project and want to import it into SQL 2008. The problem is: All polygons have the wrong ...Answered | 2 Replies | 11514 Views | Created by Daniel Rieck - Thursday, September 11, 2008 1:00 PM | Last reply by ahmed jamal - Monday, May 29, 2017 6:33 PM -
0 Votes
How to convert a geographic columnto to geometry column with another SRS Id? Thx
How to convert a geographic column to geometry column with a different SRS?Proposed | 1 Replies | 733 Views | Created by djaimes - Sunday, May 21, 2017 11:56 PM | Last reply by Olaf Helper - Monday, May 22, 2017 6:30 AM - Items 1 to 20 of 1289 Next ›
No announcements
