No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Proposed0VotesGet the bounding box from a DbGeography MULTIPOINT?
Sorry if the question is not 100% related to SQL Server itself. But I thought it matches the topic close enough to post it here. I'm using Entity Framework in my ASP.NET Web API ... -
Discussion0VotesLatitude values must be between -90 and 90 degrees.
Hi All: I was using GEOGRAPHY::STPointFromText and ran into the following problem: A .NET Framework error occurred during execution of user-defined routine or ... -
Proposed0VotesCalculate distance between point and nearest point intersecting an area
Hi, I am trying to find a way to get the distance between the start of a line and the point where that line intersects an area. I am using the geography data type ... -
Answered0VotesSplit a complex LINESTRING & calculate distance
Hi (using MS SQL 2008 R2) Would it be possible to split a complex LINESTRING at a known intersection point on the linestring & then calculate distance on the ... -
Proposed0Votesget Spatial image
Dears,I have simple question, i need to get the image that created from spatial result. ex: i need to send mail with the (ex. "PIE" chart) from sql ... -
Answered0Votesimport kml to sql server 2008
How to import KML file to sql server 2008 -
Answered2Votes1 record per X mile Radius
My table setup. -------------------------- lat (float) lon (float) location (varchar) GeoLocation ... -
Answered0VotesPolygon not a valid geography instance
I am trying to create and insert data from ESRI shape files. This is one of the many features in the shape file, you can copy paste it and try it yourself: DECLARE @g ... -
Unanswered0VotesSpatialDataTypes accessed remotely (linked server).
We have a database of common data used across many applications. We've recently added spatial datatypes. We are using a linked server so when applications move and servers are replaced we ... -
Answered0VotesGeography / Distinctions between Contains, Within, Intersects (and related)
Despite several hours of searching and reading numerous questions and answers on this forum and others, I have been unable to find definitive and complete explanations for the behaviors of several of ... -
Answered0VotesSqlGeography.Equals always returns false
Hi, We have a generic code in our C# application which does bunch of comparisions between two databases and Stored Procedures. Recently we are hitting issue with ... -
Unanswered0VotesI need to find 10 locations that are closest to a users location on a webservice.
I have a webservice that will return currently all address's in the database. That database has [Location]Geography column, a Lat decimal column and a Long decimal column. Along ... -
Unanswered0VotesGeometry from Oracle 10g into SQL server 2012
I'm building a service(C#) which selects a number of geometries from a system that stores its geometries in an Oracle 10g, and then save a copy of those into a SQL Server database ... -
Answered0VotesLat and Long data from Geography Column
I was provided a table with a geography column. The table name being CTJ with the column name being geoloc. What would my command look like if I wanted to get the latitude and longitude information ... -
Answered0VotesGeography type SQL Server R2 - Query to populate a new Geography Field with known Lat/long data
I love the idea that a special GEO type will make it easier and faster to find PLACES in my data table that are in a radius of a given lat/long.. So I am thinking that a I should be ... -
Answered0VotesCombining multiple geography fields from multiple rows into a single geography column/single record
Hey there! I'm hoping some big-brained person might be able to help point me in the right direction... We have a query that returns multiple records, each record with its own ... -
Answered0Votessql server spatial beginner, using ST functions
i am new to sql server. as an exercise, i have a shapefile which i loaded in sql server. it is an administrative boundary polygon named brgy (loaded into sde.dbo). i would like to try perform a simple ... -
Unanswered0Voteshow do we match geometry column value from two tables? Error Shows Invalid operator for data type. Operator equals equal to, type equals geometry.
Dear All, Let me know that how do we match that Record Exists or not Exists based upon geometry coloumn value between two tables because if i am writing Query ... -
Unanswered0VotesSSRS Maps are not reload in IE while it's work perfect in google chrome......
Dear All, I have developed one GIS based rdl using sql geometry for generating maps. this report having both the features like drilldown & selection ... -
Answered0VotesDynamic SQL, Spatial Intersects, Stored Proc - 1st run - slow; Next runs - better.
dear Readers, thankyou for taking the time to read this post. i had to write a stored procedure where names of tables, (non-spatial) ... - Items 1 to 20 of 1075 Next ›


