1,597 reputation
1817
bio website walkercivil.com
location Tuscaloosa, AL
age 43
visits member for 3 years, 3 months
seen 7 hours 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 In PostGIS, why does ST_Covers return f on this query?
@ChrisMorrow It would have been difficult to be comprehensive, and you probably just educated yourself better than anyone else could have. Thinking and doodles are good.
May
19
revised In PostGIS, why does ST_Covers return f on this query?
added 130 characters in body
May
19
answered In PostGIS, why does ST_Covers return f on this query?
May
18
comment Connect to PostGIS database from Q GIS
To clarify, the top line of the QGIS connection dialog is just a friendly name. You need to put "mb_sed_class" in the field labeled "Database".
May
18
comment Connect to PostGIS database from Q GIS
In the screenshot provided, you did not specify a database.
May
15
comment .dxf export in QGIS 2.0.1 gives hatches instead of polylines
Covered in this question: gis.stackexchange.com/questions/80293/…
Apr
1
awarded  Taxonomist
Mar
18
comment PostgreSQL default values in QGIS 2.8.1
@Sergio - The bug has been fixed and should be available at next update or nightly build. Please accept this as the correct answer if it solves the issue for you.
Mar
18
revised PostgreSQL default values in QGIS 2.8.1
New info on bug fix
Mar
17
revised PostgreSQL default values in QGIS 2.8.1
Added qgis bug ticket number
Mar
17
revised PostgreSQL default values in QGIS 2.8.1
Update based on new insight
Mar
17
comment PostgreSQL default values in QGIS 2.8.1
Okay, it just occurs to me that we are looking not at your actual CREATE statements, but a reverse engineered output such as pgAdmin. Will update answer.
Mar
17
comment PostgreSQL default values in QGIS 2.8.1
I have no idea why the QGIS versions work differently, but it's almost certainly a bigger issue that you are casting your default values (and check constraints) to a different data type than the column definitions.
Mar
17
answered PostgreSQL default values in QGIS 2.8.1
Mar
13
comment PostgreSQL default values in QGIS 2.8.1
Unable to duplicate this issue with a v2.8.1 OsGeo4w install on Windows 7. I tried this with a text column and an integer column, and in both cases QGIS loaded the default values (as defined from PostgreSQL) into the feature creation attribute form. You may need to add some info on what type of data, defaults and constraints you are working with.
Feb
13
awarded  Yearling
Feb
11
comment How to render an SVG from PostGIS using ST_AsSVG
Haven't tried it, but TileMill will let you style your PostGIS data and export it as SVG vector. Don't know your workflow, so maybe that's overkill for what you want to do.
Feb
5
comment Why are my transparent png tiles showing up weirdly in QGIS?
@Justin An image must be resampled if it is not used in its native projection. Briefly, your options seem to be: Change the CRS of your project to match the tiles; Find a source of tiles in your CRS; Find a source of tiles without transparency and place them lowest in layer order.
Feb
5
comment Why are my transparent png tiles showing up weirdly in QGIS?
I have not had success resampling transparent png files, at least not through WM(T)S, which I assume the OP is using since the given example is a tile.
Feb
5
comment Why are my transparent png tiles showing up weirdly in QGIS?
This can happen if your map is not the same coordinate system as the raster. I assume that this is because transparency cannot be resampled the way other values can.