Lab Sql

Given a database that contains three fields: Latitude Longitude Proximity Where Lat and Long are GP… Read more Sql Query To Query Nearby Points Of Interest Based On Lat/long - Sqlite

So I added geometry columns to a spatial table and using some of the msdn references I ended up spe… Read more What Is Srid 0 For Geometry Columns?

I'm trying to populate my DB with geographical places of my country. One of my tables have 4 fi… Read more Mysql Insert/update On Point Column

How do I convert SRID 3857 formatted geometery coordinates into to decimal degrees? My current sta… Read more How Do I Convert Srid 3857 To Decimal Degrees?

I have a database full of two-dimensional data - points on a map. Each record has a field of the ge… Read more How Can I Extend This Sql Query To Find The K Nearest Neighbors?

SQL Spatial Features: SQL geometry Point, Linestring working well but the Circular string is not wo… Read more Sql-server 2008 R2 Geospatial Query Error For Circular String

I have a some tables in SQL Server 2008 R2. I want to create view to publish it on Geoserver. But I… Read more How To Connect Lines In Single Feature In Sql Server?

I have a number of spatial entities in a table, with a geometry field called Boundaries. I want to … Read more Combine (union?) And Simplify/reduce Dbgeometry Records For Geojson

How do I convert SRID 3857 formatted geometery coordinates into to decimal degrees? My current sta… Read more How Do I Convert Srid 3857 To Decimal Degrees?

Here is my problem, I have a SQLite table with locations and latitudes / longitudes. Basically I ne… Read more Calculating Great-circle Distance With Sqlite

I'm using SQL Server 2008 and the Geometry datatype to store a list of UK a roads, which I'… Read more How To Combine Multiple Linestring Rows Into A Single Row Collection

I am new to Spatialite. I have following query: select A.* from linka as A, pointa as B where Con… Read more Gis Buffer Value Degree To Meters With Spatiallite

In sql-server-2012 I want to generate view with all points from geometry type. How can I do this? V… Read more Generate View With X And Y From Geometry Type

Update: this has been reported to Microsoft. In a simple (SQL Server 2012) table with a geography … Read more A Bug In Sql Geography Point Lat, Long

I want to create trigger which after insert longitude and latitude to table Vehicle create point f… Read more How To Do Trigger Which Create A Point After Insert Longitude And Latitude?

In sql-server-2012 I want to generate view with all points from geometry type. How can I do this? V… Read more Generate View With X And Y From Geometry Type