4,156 reputation
732
bio website
location Hamilton, Canada
age 35
visits member for 2 years, 4 months
seen 3 hours ago

Jun
26
answered Can Cartodb map show only United States?
Jun
25
answered Cropping with GDALWarp in QGIS
Jun
24
revised Using the Rule-based style to calculate each grid cell from overlaps
added 83 characters in body
Jun
24
comment Using the Rule-based style to calculate each grid cell from overlaps
No problem Joseph. What I do in cases like yours is to add a filter for each option (ie: CASE). So if you have 4 options you are looking at, then you would want to add 4 different filters. Each filter could have a multiple attribute query. I have added a graphic showing what I mean.
Jun
24
answered Using the Rule-based style to calculate each grid cell from overlaps
Jun
24
awarded  Popular Question
Jun
20
revised Create shapefile from data postgis / kml using java
spelling correction
Jun
19
comment Is there a way to use gdal functions from OSGeo4W out of their shell?
Then I am not sure what you mean. If you can access gdal commands from OSGeo4W then what is the issue? Do you want to bundle things from your ESRI python? That may not be possible, but I will let someone else tackle it. I have python scripts that call gdal. What I have done is to evoke it from a commandline tool, but I have to type python first, then the python script file (ie: python c:\temp\cool_script.py) If you want to use an ESRI script and a gdal script for processing, you may have to batch that. Create a bat file that calls the scripts in order, or even a python script to do that
Jun
19
comment Is there a way to use gdal functions from OSGeo4W out of their shell?
So for example, in OSGeo4W if you type gdal_merge nothing comes up? You should see something like this: Usage: gdal_merge.py [-o out_filename] [-of out_format] [-co NAME=VALUE]* [-ps pixelsize_x pixelsize_y] [-tap] [-separate] [-q] [-v] [-pct] [-ul_lr ulx uly lrx lry] [-init "value [value...]"] [-n nodata_value] [-a_nodata output_nodata_value] [-ot datatype] [-createonly] input_files [--help-general]
Jun
19
answered Saving Shapefile to File Geodatabase in QGIS 2.2?
Jun
19
answered Is there a way to use gdal functions from OSGeo4W out of their shell?
Jun
19
revised Is there a way to use gdal functions from OSGeo4W out of their shell?
spelling mistakes, overall readability
Jun
18
revised How to assign correct flow direction to stream network polylines?
deleted 3 characters in body
Jun
18
answered What satellite imagery would help to show spring locations?
Jun
17
revised QGIS-Merge or create virtual raster files without losing definition?
deleted 1 character in body; edited title
Jun
16
comment PostGIS Group By Error
Sorry Paul, I didn't know you were filling something in. If you want to add the answer back up, I am sure others would find it useful. I do understand the meaning of GROUP BY; this example doesn't properly show my example. But thank you for your help.
Jun
16
comment PostGIS Group By Error
Thanks, that worked. Do you have any idea why it would need a uid / gid? I haven't needed to do this with other databases.
Jun
16
accepted PostGIS Group By Error
Jun
16
revised PostGIS Group By Error
added 358 characters in body
Jun
16
comment PostGIS Group By Error
When I perform a similar query in Spatialite I do not see this issue. What I am looking for is all the city names that have a city_abbr of nyc. I want to make sure I only get one return if there are cities that share the same city name. I understand distinct will give me this result, but I don't understand why GROUP BY needs to have all the columns that are identified in the SELECT.