6,889 reputation
247141
bio website djq.me
location Dublin, Ireland
age
visits member for 4 years
seen Aug 28 at 19:05

interested in postgis, geodjango, qgis, python, R and LaTeX.

twitter: @djq


Dec
27
comment How to install GDAL with Python on windows?
I'm having difficulty with this installer working as it is failing to detect my python installations. I have python26 and python27 installed in C:/Python2X but it can't find it.... nevermind! Choose 64 bit instead of 32....
Dec
24
comment How do I organize my GIS projects?
Just curious why the github limitation is significant. Are you using git for everything, non-code also? I'm starting to use version control for the very same purposes and trying to learn good practices.
Dec
21
comment Loading a raster using QGIS into a PostGIS2.0 enabled database
When I try loading running the program from the command line using this C:\Program Files (x86)\PostgreSQL\9.1\bin>raster2pgsql.exe -s 102003 -c -C F:\pop.tif > test.sql I get an Access is denied. message (not certain if I have to provide a schema or not). Is there a way I can run it as an administrator? When I right-click and choose the run as administrator option the screen just pops and disappears - I can't pass it any arguments.
Dec
21
revised Loading a raster using QGIS into a PostGIS2.0 enabled database
added version numbers to software mentioned
Dec
21
asked Loading a raster using QGIS into a PostGIS2.0 enabled database
Dec
21
comment How to run two PostGIS versions in parallel on Windows?
Thanks @LR1234567, running CREATE etc... by itself appeared to work. I was able to load a shapefile into that database and am currently trying to load a raster. I'm finding your book very helpful too.
Dec
21
accepted How to run two PostGIS versions in parallel on Windows?
Dec
15
comment Summing Attributes from a Related Table?
Yes - I was thinking of the same approach that you describe for a standalone script. I haven't figured out how to examine sections of the attribute table from within the UI; I await answers with interest!
Dec
15
comment Summing Attributes from a Related Table?
Might you be interested in using python and not doing this in the field-calculator?
Dec
15
comment How to run two PostGIS versions in parallel on Windows?
Thanks @LR1234567 I've tried copying everything into the respective folders on my Postgresql 9.1 installation. When I create a db in postgresql (choosing template postgis2.0); I get an error when I run CREATE EXTENSION postgis; The error is: ERROR: type "spheroid" already exists, SQL state: 42710
Dec
14
comment How to generate a thumbnail of an openlayers map?
Final thought - it seems like this might be most easily done using the webserver, rather than in browser. Geoserver (for example) can output to png opengeo.org/technology/geoserver as could Mapserver, Mapnik ....
Dec
14
comment How to generate a thumbnail of an openlayers map?
Are you using PostGIS to store the data? There is a PostGIS output to geoJson, and then using advice from @geographika's blog you can convert geoJson to png. geographika.co.uk/visualising-geojson-in-15-minutes
Dec
14
revised How to generate a thumbnail of an openlayers map?
added 59 characters in body
Dec
14
answered How to generate a thumbnail of an openlayers map?
Dec
14
answered What annoys you about your GIS Environment?
Dec
14
comment Exporting polygon features to individual image pngs
Perhaps you need to add an attribute column name in as an argument. The code above ran fine for me, but a more correct version might be to have spplot(demo, "fieldName")
Dec
14
comment Exporting polygon features to individual image pngs
Hmm, are you definitely reading the shapefile ok? To remove the border you can put the line trellis.par.set(axis.line=list(col=NA)) above spplot.... to remove the border. Glad it's of interest.
Dec
13
revised Exporting polygon features to individual image pngs
edited body
Dec
13
comment Exporting polygon features to individual image pngs
Hi @rasto Just curious - I saw your edit and as far I understand length(polygons(demo)) and length(demo) both return the same values. Are there cases when this is not true and you should choose one over there other?
Dec
13
answered Spatial Analyst Cell Statistics tool in Python gives inaccurate results