1,249 reputation
413
bio website
location
age
visits member for 2 years, 2 months
seen Apr 23 at 12:30

Feb
18
comment Getting coordinates from random directions
I still don't get what you want to extract from those rows. Could you provide an example on what data values you want to extract from the string "CR 70 & CR 53, N1, W 5/10, S 5/10 INTO "?
Feb
17
comment Converting in batch into 8 unsigned bit format using GDAL?
What happens when you run your command on a single .img file?
Feb
14
awarded  Yearling
Jan
19
comment How can I remove cloud cover on landsat8 imagery?
What do you mean by "remove" - show the true terrain under the cloud (thats impossible, as far as i know), or mask the cloud, so that your analysis will not try to analyze the cloud (thats what @Luke suggests using the QA band)
Jan
14
comment QGIS how to 'compare' points (latitude/longitude) w/address data (zip) to a zipcode boundaries shapefile
The "spatial join" solution sounds more GIS-y, whereas my proposal is more database-y :-)
Jan
13
comment PostGIS ST_Contains query return empty
Please keep in mind the possible SQL injection you open yourself to if $route is somehow influencable by an end user.
Jan
12
comment How to export SpatialPolygons as Shapefile
What software do you use? From the syntax and the term "Data frame" I guess you use "R". Please edit your question to include the software.
Jan
9
answered QGIS how to 'compare' points (latitude/longitude) w/address data (zip) to a zipcode boundaries shapefile
Jan
7
revised Qgis corrupted excel file, possibility to repair?
title reworded to be less sensational, more correct
Jan
7
suggested approved edit on Qgis corrupted excel file, possibility to repair?
Jan
7
comment Tutorials to handle spatial data in R?
I find this very hard to grasp. It only has 4 slides that mainly say "look at these packages", and non-commented code that will give you examples, but leave all the research on what exactly this does to the reader.
Dec
22
comment Can't find the proper settings to import Europe map using osm2pgsql?
To address your problem of dynamic IPs and the ssh connection not staying open you can use the "screen" command to create a virtual screen. See "man screen" command, or ss64.com/bash/screen.html
Dec
22
comment 78% cease calculation and “no message” from QGIS
You could try to only calculate your stuff on a subset of your data. That way you can see if there is a general problem with the workflow you want to perform, or if it "merely" is a problem with the data amount. Also: do you use a 64 bit QGis? If you use 32 bit this will only be able to use about 3,5 GB of RAM.
Dec
22
revised How to remove WMS layer from OpenLayers
has nothing to do with WMS and geoserver
Dec
22
suggested approved edit on How to remove WMS layer from OpenLayers
Dec
22
answered How to remove WMS layer from OpenLayers
Dec
16
answered Fire frequency Map
Dec
12
answered Is it possible to use spatial function to retrieve non-spatial data?
Dec
12
revised downloading DEM for free
retag with more appropriate tags
Dec
12
comment Is it possible to use spatial function to retrieve non-spatial data?
I dont fully understand the question. You have a non-spatial database, where you store the WKB representation of a point in a column with type varchar? If thats the case, you can use the function ST_PointFromWKB postgis.refractions.net/documentation/manual-1.4/… on the WKB value to get a geometry instance.