Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)
I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
Upon adding a database to my postgres pgadmin iii server I attempted a replace query in the sql gui, and it worked. However I put in the wrong value to replace and whenever I try to do so again to fix ...
I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database. Now I have a table which holds all the track points of these ...
Why does ST_Area(g.geom) + ST_Area(p.geom) - ST_Area(ST_Union(g.geom,p.geom)) produce negative result when using ST_Overlaps(g.geom, p.geom) = true?
I have two set of shape data. Let's say file gov.shp contains list of post codes and their boundaries. File post.shp contains list of government area name and their boundaries. I want to find out the ...
How do I connect Google Earth with any relation database? I have live database containing spatial co-ordinates i.e latitude and longitude. User should be able to view these live data on google earth.
I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...