1,452 reputation
1617
bio website walkercivil.com
location Tuscaloosa, AL
age 43
visits member for 2 years, 10 months
seen 28 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.


2d
comment Reduce building size in tilemill
What have you tried? Have you unsuccessfully searched for an answer?
Dec
18
comment What are alternatives for SLD editor?
The following question refers to GUI editors. Is your question different? gis.stackexchange.com/questions/93622/sld-editor-with-gui
Dec
17
comment Plotting Geo Points with “by arc centered at” Instructions
I do not know of a constructor for begin, end, center, so you will probably need to pre-process your data and calc the arc midpoint. Perhaps get the radius and project it through the linear geometric midpoint of the begin and end points.
Dec
17
comment Plotting Geo Points with “by arc centered at” Instructions
The CIRCULARSTRING feature creates a circular arc based on three points on the arc. You passed two points and the center point to the constructor.
Dec
13
comment How to create selective output from a QGIS layer, using QGIS2leaf?
@user27285 Not sure how you intend to combine filters, but the typical SQL logical operators AND and OR are available. Also, you can add the same data source multiple times with different filters.
Dec
12
answered How to create selective output from a QGIS layer, using QGIS2leaf?
Dec
8
comment Force St_split() to return geometries in specific pattern
Those SQL examples are identical.
Nov
19
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 approved 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.