No announcements
-
0 VotesNeed 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 | 579 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 | 566 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 | 2728 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 | 874 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 | 707 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 | 787 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 | 876 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 | 861 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 | 1211 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 | 1121 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 | 1139 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 | 1533 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 | 1194 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 | 1549 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 | 3417 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 | 1363 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 | 1408 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 | 1734 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 | 9945 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 | 1397 Views | Created by Momen Azmath - Tuesday, June 25, 2019 11:17 AM | Last reply by Momen Azmath - Saturday, June 29, 2019 1:24 PM - Items 1 to 20 of 1331 Next ›
No announcements
