6,938 reputation
350143
bio website djq.me
location Dublin, Ireland
age
visits member for 4 years, 1 month
seen Oct 13 at 19:22

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

twitter: @djq


Feb
1
comment Problem installing PostGIS on Ubuntu Server 13.10
ok, looks like the ppa does not exist for this version of ubuntu. I have only tested the above on 12.04
Feb
1
comment Problem installing PostGIS on Ubuntu Server 13.10
Can you try and run apt-get update --fix-missing to see if something was not downloaded/installed properly ?
Jan
21
comment calculate {minimal} distance between polygons in R
Would you consider using postgres/postgis in addition to R? I have used a workflow where I perform the majority of my work in R, but store the data in a database that I access using sqldf. This enables you to use all of the postgis functions (of which distance between polygons is straightfoward)
Jan
21
comment How to georeference downloaded map using ArcGIS for Desktop?
Would an answer about doing this using QGIS be of interest?
Jan
20
comment Can adding entropy to a copyrighted spatial data make it a new dataset?
I've updated my question. The data is from Ireland, I am in the USA.
Dec
16
comment Is there an opensource way of making 'streetview' panoramas?
AFAIK, this is not code to make a streetview scene, it just facilitates commenting on streetview instances.
Dec
16
comment Is there an opensource way of making 'streetview' panoramas?
@Mapperz I looked through this repo and could not find it. Could you point me to the exact code please? I did find some code for general commenting on Streetview which was cool, though!
Dec
15
comment Is there an opensource way of making 'streetview' panoramas?
It looks like openstreetview is just for static geotagged images (maybe I'm missing the photosphere functionality)
Dec
15
comment Is there an opensource way of making 'streetview' panoramas?
Both collecting and publishing. I'll clarify my question. Thanks for the OpenTrailView suggestion.
Dec
15
comment Can I simplify polygons in QGIS by Size?
Could you use a threshold for size? For example, if the area is > 10km^2, simplify. You could filter these polygons using area.
Dec
2
comment How to make working with Postgis vector layers in QGIS faster?
@CaoMinhTu You can use pgtune to tune: pgfoundry.org/projects/pgtune also, boundlessgeo have some instructions on their website
Oct
26
comment How can I fix QGIS 1.8.0 Spit Plugin “connection failed”?
Don't forget to restart postgres after editing the .conf files either
Oct
18
comment Inserting polygon centroids into an additional column in PostGIS
It has been answered (2 years ago) and with the correct answer marked
Oct
8
comment Best way to assign points to nearest roads in postgis?
maybe ORDER BY rank and LIMIT 1 might help (not sure - have not tried)
Oct
8
comment Best way to assign points to nearest roads in postgis?
I assume you have spatial indexes on your geometry columns; did you try adding a subquery to just get the row with rank 1?
Sep
28
comment Is there a world projection that looks like a 3D globe?
@Scro this was the most useful explanation - happy to mark it as the answer if you move it down!
Sep
15
comment Is there a world projection that looks like a 3D globe?
wow, thank you. I was completely unaware of the term. Is there any way of specifying which country you can center this around?
Jul
15
comment Loading raster data to postgis
This seems like a less than ideal 'raster'. Do you have access to the original data or just this image?
Jun
8
comment Linux alternatives to visualize and analyze LiDAR datasets
Are you interested in database approaches too? It seems like storing it in PostGIS would be logical and open up a few other ways to viewing it (but I don't know your work-flow)
Jun
6
comment How to define new custom projections in QGIS?
I filed it a long time ago....