No announcements
-
0 Voteshow 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 | 110 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 | 302 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 | 328 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 | 521 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 | 436 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 | 787 Views | Created by Jon Bastow - Monday, July 8, 2019 12:12 AM | Last reply by Rob Thiem - Wednesday, July 31, 2019 10:36 PM -
0 Votes
SQL 2014 - Support for 3D for Geometry Objects?
Hi All, with the Geometry support x,y,z for all Points, Lines and Polygons in SQL Server 2014? I really need 3D. gordonAnswered | 2 Replies | 2726 Views | Created by MapGuide Guy - Tuesday, December 10, 2013 7:51 PM | Last reply by Dennis M. Myers - Friday, July 26, 2019 5:31 PM -
0 Votes
How to Save Shapefiles (.shp) in Microsoft SQL Server 2017 via VB.NET code?
Hi ! I got stuck with working with spatial data in Microsoft SQL server! How to accomplish the task of saving shapefiles (.shp) into ...Unanswered | 2 Replies | 566 Views | Created by VBProgrammer_2020 - Monday, July 22, 2019 3:40 PM | Last reply by VBProgrammer_2020 - Tuesday, July 23, 2019 5:58 AM -
0 Votes
What is the measurement of distance with STBuffer when using a GEOMETRY object?
All, My question revolves around using "STBuffer()" on a GEOMETRY object. (see code below) DECLARE @ogc varchar(MAX); DECLARE @geogObj GEOGRAPHY; ...Unanswered | 3 Replies | 640 Views | Created by NickWM - Wednesday, July 10, 2019 8:58 PM | Last reply by NickWM - Friday, July 12, 2019 12:40 PM -
0 Votes
Spatial Results Tab window not showing up in Microsoft Visual studio(SSDT)
I cannot see the 'spatial results' tab window when i execute the query below.When i run a normal query i can see 2 tabs showing 'results' and 'message' but not the 'spatial results' tab. I ...Proposed | 6 Replies | 879 Views | Created by mark allam - Saturday, July 6, 2019 1:24 PM | Last reply by Cathy Ji - Thursday, July 11, 2019 1:07 AM -
0 Votes
how to work with spatial data
Hi All, I want to map my cube with spatial ...Unanswered | 12 Replies | 9124 Views | Created by divy s - Monday, March 2, 2009 9:18 AM | Last reply by mark allam - Sunday, July 7, 2019 11:40 PM -
0 Votes
OLE DB Provider "Stream" for linked server "(null)" returned message "Requested conversion is not supported"
Hello, I am using a Synonym which calls a Remote procedure inside one procedure. Synonym is defined as Linked Server ODBC connection with Multi Subnet Failover ...Unanswered | 2 Replies | 637 Views | Created by Momen Azmath - Tuesday, June 25, 2019 11:17 AM | Last reply by Momen Azmath - Saturday, June 29, 2019 1:24 PM -
0 Votes
Bug - STConvexHull returns non-convex hull
Where do we go to report bugs now that Connect is gone? I have a very complicated geometry that when calling STConvexHull return a non-convex polygon. STIsValid = 1. ...Unanswered | 1 Replies | 658 Views | Created by wimpy1 - Tuesday, June 18, 2019 4:06 PM | Last reply by Cathy Ji - Wednesday, June 19, 2019 9:58 AM -
0 Votes
More geo STDistance questions
I'm working on a simple stored proc to calculate the distance between two points. Greatly simplified, here is the relevant code and result set. Obviously I don't understand all I know ...Answered | 2 Replies | 893 Views | Created by Payson B - Thursday, May 23, 2019 5:11 PM | Last reply by Payson B - Friday, May 24, 2019 1:45 PM -
1 Votes
How to import Shapefile with Shape2SQL or with Safe FME Desktop?
Hi I would like to make an application where I check GeoCoordinates against postal code polygons of the country of Denmark. I have found a file which I hope contains the data I ...Answered | 14 Replies | 21900 Views | Created by rune007 - Thursday, July 7, 2011 3:59 PM | Last reply by Nizaamudeen23 - Wednesday, May 1, 2019 5:44 PM -
0 Votes
Convert KML to Simple XML
Greetings All Is there a way to convert KML To simple XML using the XLS Transformation, i noticed that there are different style sheets and not sure which one to ...Unanswered | 1 Replies | 919 Views | Created by Ronald Van Der Westhuizen - Wednesday, April 24, 2019 4:29 AM | Last reply by Dedmon Dai - Thursday, April 25, 2019 1:54 AM -
0 Votes
Geometry in varbinary
Hi, I have a table with a column name Geometry (datatype varbinary (max)) and it contains geom of certain Area, table also have other columns e.g. Area (values A, B, C), Zone ...Unanswered | 6 Replies | 1520 Views | Created by AshwaniSrivastava - Monday, April 1, 2019 9:07 PM | Last reply by NALUTO - Friday, April 5, 2019 7:04 AM -
0 Votes
Is there any way to get the middle point of a line in T-SQL?
Hi guys, I have a problem with getting the middle point of a line by distance. Example I have a linestring with only 2 coordinates start and end. Let it be 6,7km long, the middle of it is 3,35km far ...Unanswered | 3 Replies | 1434 Views | Created by hadobas - Tuesday, March 19, 2019 9:08 AM | Last reply by NALUTO - Thursday, March 28, 2019 8:22 AM -
0 Votes
CompoundCurve to LineString
We have several tables on SQL Server with geometry data, but the problem is that objects are saved as CompoundCurve also if they are simple LineString. Is there a method ...Unanswered | 2 Replies | 1515 Views | Created by FabioGW - Thursday, February 21, 2019 5:16 PM | Last reply by FabioGW - Friday, February 22, 2019 8:47 AM -
0 Votes
DB geography type not working
I am facing below error while running this query. select a.LocationID, 'B' , c.RegionID, getdate() from ...Unanswered | 2 Replies | 1598 Views | Created by Jaz1987 - Tuesday, February 12, 2019 4:24 AM | Last reply by Puzzle_Chen - Wednesday, February 13, 2019 2:12 AM - Items 1 to 20 of 1324 Next ›
No announcements
