Skip to content Skip to sidebar Skip to footer
Showing posts with the label Geospatial

Sql Query To Query Nearby Points Of Interest Based On Lat/long - Sqlite

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

What Is Srid 0 For Geometry Columns?

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?

Mysql Insert/update On Point Column

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 To Decimal Degrees?

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?

How Can I Extend This Sql Query To Find The K Nearest Neighbors?

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-server 2008 R2 Geospatial Query Error For Circular String

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