Skip to content Skip to sidebar Skip to footer
Showing posts with the label Gis
Sql Query For Point-in-polygon Using Postgresql

Sql Query For Point-in-polygon Using Postgresql

Post a Comment
I have the following simple table: CREATE TABLE tbl_test ( id serial NOT NULL, poly polygon NOT… Read more Sql Query For Point-in-polygon Using Postgresql
Efficient Sorted Bounding Box Query

Efficient Sorted Bounding Box Query

Post a Comment
How would I create indexes in PostgresSQL 8.3 which would make a sorted bounding box query efficien… Read more Efficient Sorted Bounding Box Query
Gis Buffer Value Degree To Meters With Spatiallite

Gis Buffer Value Degree To Meters With Spatiallite

Post a Comment
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
Plpgsql Function To Calculate Bearing

Plpgsql Function To Calculate Bearing

Post a Comment
Basically I can't get my head around the syntax of plpgsql and would appreciate some help with … Read more Plpgsql Function To Calculate Bearing