| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 4 months |
| seen | May 21 at 5:57 | |
| stats | profile views | 10 |
My day job is Information Security for The University of Auckland, New Zealand.
I have been working in IT for around 35 years. My degree was in science with a heavy emphasis on Mathematics (particularly statistical and computational).
First job was as a statistician in University Zoology Dept after a few years I moved to what was then the "Computer Centre" where I was mostly involved with user support for statistical packages.
Over the years I have done worked in most non management areas in academic IT -- for the last 15 years I have been largely responsible for the technical side of Information Security at tht University.
My specific interest in GIS is centered around my conservation work on Tiritiri Matangi Island www.tiritirimatangi.org.nz where I am the volunteer coordinator for the weeding program.
We are currently setting up a GIS system of our own to keep track of weed related data.
The Island is jointly managed by the SOTM -- "Supporters" and Department of Conservation. DOC have lots of GIS resources but these are not accessible to volunteers and so we have decided to do our own thing with QGIS and export data for DOC's records rather than pass the data direct to DOC.
|
Apr 11 |
comment |
merging layer stored in PostGIS When I tried this - assuming that by copy you mean via clipboard (on a mac with QGIS 1.8.0) I got errors on saving the combined layer back into PostGIS about duplicate GIDs. When I looked at the attribute table the GIDs were blank for the features that I had added. Maybe 1.9.0 has fixed this behaviour. Bravo if that is the case. |
|
Apr 11 |
comment |
merging layer stored in PostGIS THanks! that will do nicely :) I figured that it should be straight forward using SQL but as a long time mysql user I am still coming to grips with Postgres and what you can and can't do with sequences. |
|
Apr 11 |
accepted | merging layer stored in PostGIS |
|
Apr 11 |
asked | merging layer stored in PostGIS |
|
Apr 8 |
revised |
Storing features in PostGIS and then creating layers using queries fix typo |
|
Apr 7 |
comment |
Storing features in PostGIS and then creating layers using queries I have just looked at PostGIS Topology and yes that fits the bill but I suspect it is overkill for what I need. But it does answer the question. "How do professionals do it?". Thanks Nicklas. |
|
Apr 6 |
revised |
Storing features in PostGIS and then creating layers using queries added 649 characters in body |
|
Apr 6 |
accepted | I have detached the layer panel — how do I get it back to the side bar? |
|
Apr 6 |
comment |
I have detached the layer panel — how do I get it back to the side bar? Thanks! I knew it had to be something simple! |
|
Apr 6 |
asked | I have detached the layer panel — how do I get it back to the side bar? |
|
Apr 6 |
accepted | Can one load multiple GPX files at once? |
|
Apr 6 |
comment |
Can one load multiple GPX files at once? Ah! yes that works. The small catch is that you still need to select between track, waypoint, route, etc. with no indication of which gpx file you are referring to. Still beats going throught all the menus for each file. Also the file names are not reflected in the layer names. |
|
Apr 6 |
revised |
Can one load multiple GPX files at once? added 79 characters in body |
|
Apr 6 |
asked | Storing features in PostGIS and then creating layers using queries |
|
Apr 6 |
asked | Can one load multiple GPX files at once? |
|
Mar 19 |
accepted | QGIS: using postgis can I define a layer using sql? |
|
Mar 18 |
comment |
QGIS: using postgis can I define a layer using sql? I figured this was the only way to set up something that is automated. And can be used across multiple pojects. The combination of James' and your answers is great. |
|
Mar 18 |
comment |
QGIS: using postgis can I define a layer using sql? Thanks, I had missed then sql button in the database manager. This would be really good for testing and one offs -- getting the sql right and then viewing the results in QGIS. |
|
Mar 18 |
asked | QGIS: using postgis can I define a layer using sql? |
|
Mar 12 |
awarded | Teacher |

