No announcements
Found 1335 threads
-
0 VotesSpatial Index for geometry columns
Hi SQL server :2016R2 STD I am looking to create Spatial Index. There are things to clarify before create Spatial Index . I have few questions ...Answered | 5 Replies | 4492 Views | Created by ashwan - Thursday, June 18, 2020 7:10 AM | Last reply by Laxmidhar sahoo - Thursday, June 25, 2020 4:05 PM
-
0 Votes
STContains - tests failing for points INSIDE polygon
The full details regarding this question are posted on StackOverflow ...Answered | 5 Replies | 4288 Views | Created by BDCoder - Monday, June 15, 2020 2:07 PM | Last reply by Melissa Ma - Wednesday, June 17, 2020 2:03 AM -
0 Votes
STBuffer Question Newbie
Hello This is the first time i have looked at creating a buffer from SQL so any help is welcomed. I have seen that you can enter coordinates to create a point or line etc but ...Proposed | 2 Replies | 3866 Views | Created by Anonymous2601 - Saturday, June 6, 2020 2:26 PM | Last reply by MIAOYUXI - Wednesday, June 10, 2020 1:11 AM -
0 Votes
Area as it appears on a Bing map?
I'm trying to figure out areas in .Net. I've been using the SqlTypes.dll but, when it gets right down to the details, I'm not precisely sure what it is really calculating. To do my ...Answered | 3 Replies | 4511 Views | Created by Zloth X - Wednesday, April 22, 2020 3:56 PM | Last reply by Zloth X - Tuesday, April 28, 2020 6:29 PM -
0 Votes
Is there a way to modify geometry object, for example offset LINESTRING geometry by some value?
Hi Thanks for any help -- this is vertical panel saw cut, on center of tool width DECLARE @GS varchar(8000) = 'LINESTRING(7.5 10,7.5 549.96)', ...Proposed | 2 Replies | 4997 Views | Created by Vladimir Moldovanenko - Saturday, April 25, 2020 2:46 PM | Last reply by Vladimir Moldovanenko - Monday, April 27, 2020 7:44 PM -
0 Votes
Is there a way to convert GEOMETRYCOLLECTION(LINESTING.., CIRCULARSTRING...), closed, to POLYGON?
Thanks for your help. I asked a question in T-SQL group and got pointed to this group. Here are ...Answered | 2 Replies | 4313 Views | Created by Vladimir Moldovanenko - Wednesday, April 22, 2020 12:38 AM | Last reply by Vladimir Moldovanenko - Saturday, April 25, 2020 5:00 PM -
0 Votes
Need to Load the OSM (Open Street Map) data Nodes and Ways data for a region
Dear Experts, I have a requirement recently to generate an OSM(Open Street Map) database that contains Ways and Node data for our application to generate a Map route sequence ...Answered | 3 Replies | 5804 Views | Created by Momen Azmath - Wednesday, December 4, 2019 7:08 PM | Last reply by Momen Azmath - Tuesday, December 10, 2019 12:35 PM -
0 Votes
Querying all points within geography coordinates returns no data
Bing Maps is giving me bounding coordinates as opposite points on a box that looks like ...Unanswered | 1 Replies | 5708 Views | Created by zBestDataLLC - Friday, December 6, 2019 11:58 AM | Last reply by Dedmon Dai - Monday, December 9, 2019 3:27 AM -
0 Votes
SQL Server Support for the new Australian GDA2020 Datum
We currently utilise SQL Server 2016 to store and manipulate masses of spatial data for our Local Government entity, and have found that SQL Server 2016 does not recognise the 'new' Australian spatial ...Proposed | 4 Replies | 8578 Views | Created by Tony Jordan - Wednesday, October 31, 2018 10:38 PM | Last reply by Mladen Andzic - Thursday, December 5, 2019 3:04 PM -
0 Votes
CheckDB on Geography data
I've narrowed down a DBCC CheckDB issue to a set of tables with Geography data types. These tables are 100s of millions of records. The integrity checks on these tables are taking 30-40 ...Proposed | 1 Replies | 5578 Views | Created by Guapo79 - Tuesday, November 12, 2019 11:59 PM | Last reply by Amelia Gu - Thursday, November 14, 2019 8:02 AM -
0 Votes
How to Convert Geometry points to Geography Lat Long
Hi Experts, I am bit new to deal with the spatial data and came across a situation of working with the following type of data which is in Geometry Points [Easting (Location/Map ...Unanswered | 3 Replies | 7725 Views | Created by Lesly Sebastian - Wednesday, November 6, 2019 9:44 PM | Last reply by Amelia Gu - Monday, November 11, 2019 7:05 AM -
0 Votes
Determine if geolocation falls within map boundary
Hi I have a table of geolocation points and I want to determine if each of those points fall within an entire map boundary. That is made up of geolocation points in geoJson kind of ...Unanswered | 1 Replies | 5525 Views | Created by It Just Works - Tuesday, October 22, 2019 9:12 AM | Last reply by Amelia Gu - Wednesday, October 23, 2019 3:05 AM -
0 Votes
Need to Convert Geometry (Easting/ Northing / Height) to Long / Lat
Hi, I have a requirement to convert the Geometry (Easting/ Northing / Height) to Long / Lat using a SQL Server Function. Can this be achieved ...Answered | 4 Replies | 6229 Views | Created by Momen Azmath - Sunday, October 20, 2019 6:26 AM | Last reply by Momen Azmath - Tuesday, October 22, 2019 4:42 AM -
0 Votes
Finding the distance between the origin and destination Zipcodes using SQL
Hi All, Hope you are doing well!....I am trying to find the distance between the origin and the destination zip codes ..Can you please help me here...Please find the DDL ...Answered | 2 Replies | 6113 Views | Created by Hellothere8028 - Thursday, October 10, 2019 6:55 AM | Last reply by Hellothere8028 - Thursday, October 10, 2019 9:49 AM -
0 Votes
how to Import latitude & Longitude data from excel to SQL server as geography column
hai to all how to import latitude & Longitude data from excel to SQL server as geography columnProposed | 1 Replies | 5840 Views | Created by mani261078 - Wednesday, October 2, 2019 3:38 PM | Last reply by Dedmon Dai - Thursday, October 3, 2019 3:14 AM -
0 Votes
msg 6522. "No extended information available."
i use from sql server 2017 and i want spatial join i have two table: point(500000) and polygon(500) when i use this ...Unanswered | 2 Replies | 6473 Views | Created by milajerd - Thursday, September 5, 2019 6:40 AM | Last reply by Cathy Ji - Friday, September 6, 2019 6:45 AM -
0 Votes
Convert LatLong to POLYGON / WKT Format
Hello, I do have a requirement to export the Metadata which has a Latitude / Longitude points from the table to a CSV file. But while I export them, they need to read it as a ...Answered | 2 Replies | 6418 Views | Created by Momen Azmath - Thursday, August 29, 2019 10:45 AM | Last reply by Momen Azmath - Monday, September 2, 2019 4:43 AM -
1 Votes
Meaningful statistics
> (@P1 varbinary(max))select SHAPE, STYLE_CODE, OBJECTID, SQLOSDATA.DBO.OS_MMT_AREA.GDB_GEOMATTR_DATA from sqlosdata.DBO.OS_MMT_Area WHERE ...Discussion | 4 Replies | 6090 Views | Created by Clive-Online - Friday, August 9, 2019 2:42 PM | Last reply by Clive-Online - Tuesday, August 13, 2019 9:54 AM -
0 Votes
Can I apply a spatial buffer (specific measurement) to a GEOMETRY field?
Quick question.... On a GEOMETRY type field, would I be able to apply a spatial buffer to the GEOMETRY field with a specific distance? My requirements are ...Unanswered | 1 Replies | 5786 Views | Created by NickWM - Tuesday, August 6, 2019 1:27 PM | Last reply by YKN123 - Thursday, August 8, 2019 1:38 AM -
1 Votes
SQL Server Support for GDA2020
We currently use a mix of MS SQL Server database versions to store a range of spatial data for a range of Queensland State Government departments. We are investigating migration to ...Unanswered | 4 Replies | 6739 Views | Created by Jon Bastow - Monday, July 8, 2019 12:12 AM | Last reply by Rob Thiem - Wednesday, July 31, 2019 10:36 PM - Items 1 to 20 of 1335 Next ›
No announcements
