1,552 reputation
1717
bio website walkercivil.com
location Tuscaloosa, AL
age 43
visits member for 3 years, 1 month
seen 3 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.


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.
Jan
28
comment PostGIS ST within does not exist
@freakyfreak Yes. In fact, that mirrors the default search path used by PostgreSQL: $user, public.
Jan
27
comment PostGIS ST_Union Performance
There is also ST_MemUnion. Uses less memory, more processor: postgis.net/docs/ST_MemUnion.html
Jan
23
comment PostGIS ST_Union Performance
Depends also on your GEOS version. Better aggregation algorithms were introduced at version 3.1.0.
Jan
19
comment Write a query to find all geometries within a distance using ST_DWithin
There are a few ways, and it is not clear what you would like the result to be. If possible, create a few sample output rows so we can back into it.
Jan
8
comment How to create projects in Tilemill Ubuntu Web service?
The format of SE requires one, and only one, question per post.
Jan
6
answered QGIS Python SQLite using variable
Jan
5
comment How to visualize measure values along linestrings in QGIS?
To be clear, I was not being critical of the tags (or at all.) Merely pointing out that the tags were more inclusive than the title, and you might get more/better answers by not making it a QGIS-only question.