204 reputation
311
bio website noerd.biz
location
age
visits member for 2 years, 5 months
seen yesterday

Leisure-suit developer.


1d
comment Add PostGIS spatial functions to a custom schema other than “public” in PostgreSQL
How do you add data to another schema, ie. not public? Adding data with eg. shp2psql to test.table still puts data in public?
Jul
1
comment PostGIS Best Practices with thousands of entries
Just want to add that each file doesn't yield just one row in the table - it can yield > 1M rows (huge files).
Jul
1
revised PostGIS Best Practices with thousands of entries
added 94 characters in body
Jul
1
revised PostGIS Best Practices with thousands of entries
added 80 characters in body
Jul
1
comment PostGIS Best Practices with thousands of entries
@underdark The data is different - it has different columns. They all have a geom column, but otherwise different.
Jun
30
comment PostGIS Best Practices with thousands of entries
Thanks. I edited it down to one question only, I don't know if someone will "unhold" it for me. Personally I don't understand why it's so important to close down questions five minutes after they've been asked, even if they are a bit broad. I'm part of this community also, and I sincerely need answers to this question, and this is the best forum for it.
Jun
30
revised PostGIS Best Practices with thousands of entries
simplified question to ONE specific
Jun
29
asked PostGIS Best Practices with thousands of entries
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!