1,407 reputation
1617
bio website walkercivil.com
location Tuscaloosa, AL
age 43
visits member for 2 years, 9 months
seen 9 mins ago

GIS Manager for a civil engineering firm -- Currently doing most of my work with QGIS, postGIS, spatiaLite. Working to bring GIS to smalltown, USA.


1d
comment SQL “Case” statement when count(*) is 0
Per your second example, an empty geometry field does not indicate that there is no geometry. See postgis.net/2013/10/05/tip_pgAdmin_shows_no_data
Nov
12
comment Geoserver wms tile cache and saving
From the "Caching Defaults" page of the admin site, there is a check box to "Enable direct integration withGeoServer WMS". It's not on by default.
Nov
6
comment How to draw radius of a circular point buffer using PostGIS
Please accept an answer if it correctly addresses your question.
Nov
6
answered SpatiaLite - WITH, view or sub-query?
Nov
6
comment SpatiaLite - WITH, view or sub-query?
Is a column with a list of duplicate value IDs acceptable?
Nov
6
comment SpatiaLite - WITH, view or sub-query?
Subquery would be preferred. See this post for why. However, it's not clear to me what you are trying to do. Are you looking for the same values across all three "val" columns?
Nov
5
comment Can't add a postgis layer in tilemill (symbol shown grayed)
Just from casual searching and reading, I don't think 9.3 satisfies the 9.1 dependencies. I've never tried a side-by-side install of those, though.
Nov
5
answered Can't add a postgis layer in tilemill (symbol shown grayed)
Nov
5
answered Search Points within Buffered Polygon with PostGIS
Nov
5
revised How to draw radius of a circular point buffer using PostGIS
Point buffers in PostGIS are not circles, as correctly identified in the body of the OP's question.
Nov
5
suggested suggested edit on How to draw radius of a circular point buffer using PostGIS
Nov
3
comment Free website host for embedding tilemill/mapbox web map
@DevdattaTengshe The OP asked about embedding a map, so I really didn't think past the iframe example here. Are you thinking of something that requires more than javascript and the MapBox API?
Nov
3
revised Free website host for embedding tilemill/mapbox web map
Added repo info.
Oct
29
revised How to draw radius of a circular point buffer using PostGIS
added 307 characters in body
Oct
29
answered How to draw radius of a circular point buffer using PostGIS
Oct
16
comment Postgis database query optimisation
Using ST_SetSRID(ST_MakePoint($1, $2),4326) in lieu of string concats might save you some time if there are enough iterations.
Oct
12
comment How to migrate Postgres table having Lat Lon columns to an existing PostGIS database?
Creation of geometry tables from coordinates is well documented. If you have had trouble finding information or have been unsuccessful in applying what you have found, please include that in your question.
Oct
12
comment Spatialite WITH clause issue
The same general info that you posted for DM Manager regarding the SQLite version, etc. Wait, are you referring to the SQLite Manager plugin for Firefox? If so, it likely is compiled with a recent version of SQLite. To clarify, whether or not you can use a Common Table Expression depends on the client that you are using, not the version of the database file.
Oct
12
comment Spatialite WITH clause issue
@SS_Rebelious I am unable to check the bindings at the moment. Can you append that to your answer?
Oct
12
revised Spatialite WITH clause issue
added 115 characters in body