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

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.
Jun
16
asked PostGIS Group By Error
Jun
16
revised How to display information when a certain dataset is loaded into QGIS?
added 9 characters in body
Jun
16
awarded  Citizen Patrol
Jun
13
revised Draw area from street borders
added 11 characters in body
Jun
10
reviewed Approve suggested edit on Change points to polygon
Jun
10
revised How to convert boundaries in image to polygons in QGIS
added 1 character in body; edited title
Jun
9
reviewed Approve suggested edit on How to create PostGIS template?
Jun
9
revised Free software to publish tiles on Amazon S3?
added 8 characters in body
Jun
9
answered Exporting to 2D (Arcview 3.0 compatible) shapefile in QGIS?
Jun
9
comment Z values all equal 0
Thats unfortunate. I have never tried this, but you could look at doing Zonal Statistics to Table, which is in Toolbox --> Spatial Analyst. I have successfully used it with polygons, but not points. If this does not work for a point file, you could buffer the points to a small distance (ie: 0.05m) and then run the process on the buffered points.