The MS SQL Server SqlGeography type represents data in a geodetic (round earth) coordinate system.
Questions tagged [sqlgeography]
264 questions
0
votes
1 answer
Bug in SQL Server geography?
Can someone please confirm if this is a bug or I'm doing something wrong please?
I've this stored procedure (SQL Server 2008)
ALTER PROCEDURE [dbo].[Distance]
@origin varchar(50),@destination varchar(50),@unit varchar(5)
as
declare @or geography,…
polonskyg
- 4,269
- 9
- 41
- 93
0
votes
1 answer
Microsoft.SqlServer.Types.GLArgumentException: 24205
Hi i am trying to create an geography area our of North-West lat & long, South-east lat&long
But i get this exception when i run query with these co-ordinates.
Select (geography::STGeomFromText('POLYGON((-0.534717
0.524190,0.426951…
Amrit
- 423
- 6
- 22
0
votes
0 answers
ASP .NET MVC, Windows Azure and SQL Geography
I used this tutorial to create ASP .NET MVC Site which manages table of Persons.
Now, I want to add another table (with controller) which manage a table with SQLGeography type. EF 4.3 don't support SQLGeography, so if I use in the model It can't…
Shkolar
- 337
- 7
- 20
0
votes
1 answer
SQL Server - From longitude and latitude to geometry data type
Possible Duplicate:
SQL Server 2008 Spatial: find a point in polygon
I am working on an application that uses an SQL Server 2008 database. In this database I have a table named Session that has two fields Longitude and latitude, which indicate…
nick.katsip
- 868
- 3
- 12
- 32
-1
votes
2 answers
Convert varchar(max) to geography
I have an SQL table containing multipolygons (country borders) in varchar(max) format.
enter image description here
I want to convert them into geography format so that I can intersect them with geographical points (also in geography format).
So…
Turtle
- 1
-1
votes
1 answer
ST_INTERSECTS issue BigQuery Waze
I'm using the following code to query a dataset based on a polygon:
SELECT *
FROM `waze-public-dataset.partner_name.view_jams_clustered`
WHERE ST_INTERSECTS(geo, ST_GEOGFROMTEXT("POLYGON((-99.54913355822276 27.60526592074579,-99.52673174853038…
ZairaRosas
- 27
- 4
-1
votes
1 answer
Simplified GeoJSON reports fantom markers on google maps
I have a geography column in database. This column holds the original polygon. Next to it I have another column that holds the simplified version of this polygon. The simplification has been done with geography.Reduce()(I use tolerance of 100)…
Robert
- 2,407
- 1
- 24
- 35
-1
votes
1 answer
SQL STDistance where both locations are in same record
I'm new to geographic SQL queries. I have two tables; [station_information] which describes bicycle rental stations with a geography type spatial column, and [bike_rides] which has information on a trips on rental bikes.
[station_information] has…
jetgrindjaguar
- 1
- 1
-2
votes
1 answer
Export SQL Server geography to kml with altitude
I need to export a bunch of geography objects to kml, and with that include a 3rd element, altitude. Luckily it can be hard coded as 0.
This tutorial implies the coordinates need to be in the format of lat,long,alt
…
Hecatonchires
- 1,009
- 4
- 13
- 42