4,481 reputation
735
bio website
location Hamilton, Canada
age 36
visits member for 2 years, 7 months
seen 1 hour ago

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.
Jun
6
revised Contours from DEM with human features
added 1 character in body
Jun
6
comment How to add polygon height in QGIS or PostGIS?
Then I would suggest that you state that a little more clearly in your comments. Also, the title of the question should better reflect the question that is being asked.
Jun
6
comment How to select zip codes without using the lasso tool
A spatial join will intersect the zip code polygons, and put the attribute of the zip code in the point layer attribute table. With the attributes in the point layer, you can then perform SQL queries as needed, without any manual selections.
Jun
6
comment How to add polygon height in QGIS or PostGIS?
Technically no it doesn't, you are not viewing it in QGIS. QGIS provided the means to prep the data for viewing in a different viewing software, such as exporting a KML for viewing in Google Earth. However, in this case, you will want to have an attribute that has a height value, which will be used to extrude. This process is referred to as 2.5D, as it does not have 3D geometries.
Jun
6
revised How to add polygon height in QGIS or PostGIS?
deleted 1 character in body
Jun
6
answered How to add polygon height in QGIS or PostGIS?