201 reputation
311
bio website noerd.biz
location
age
visits member for 2 years, 4 months
seen May 26 at 21:03

Leisure-suit developer.


Apr
6
awarded  Yearling
Apr
6
accepted How to define Z dimension on table with PostGIS for import in TileMill?
Apr
6
comment How to define Z dimension on table with PostGIS for import in TileMill?
great answer, thanks!
Apr
3
awarded  Critic
Apr
3
comment ECW on QGIS 1.8 (Ubuntu 11.10)
The links are dead.
Jan
14
accepted How can I add another WHERE filter to a PostGIS query?
Jan
13
comment How can I add another WHERE filter to a PostGIS query?
I hadn't, but that works swimmingly! Embarassed... Thanks! Feel free to write up an answer that I can accept.
Jan
13
asked How can I add another WHERE filter to a PostGIS query?
Jan
12
comment PostGIS SQL syntax for bounding box
Works great. If I wanted to add a ST_Transform in there, to use lat/lon instead of meters, could I do that?
Jan
12
comment PostGIS SQL syntax for bounding box
Figured it out with the other answer. Thanks for your help!
Jan
12
accepted PostGIS SQL syntax for bounding box
Jan
12
comment PostGIS SQL syntax for bounding box
Actually, had some issues with coordinates. Seems to work swell! Thanks a lot!
Jan
12
comment PostGIS SQL syntax for bounding box
No errors, but doesn't return any data either?
Jan
12
comment PostGIS SQL syntax for bounding box
Also, properties now return as null.
Jan
12
comment PostGIS SQL syntax for bounding box
BB vs. intersects, ok thanks! :)
Jan
12
comment PostGIS SQL syntax for bounding box
I added the WHERE clause inside the FROM parenthesis', which worked. But I think it's returning too many results.
Jan
12
comment PostGIS SQL syntax for bounding box
Thanks for your input. See my edit. Tried your untested query also, but same error. How come the ST_Intersects syntax is not used? Thanks again!
Jan
12
revised PostGIS SQL syntax for bounding box
added 583 characters in body
Jan
12
asked PostGIS SQL syntax for bounding box
Dec
30
awarded  Notable Question