6,963 reputation
353146
bio website djq.me
location Dublin, Ireland
age
visits member for 4 years, 2 months
seen 13 hours ago

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

twitter: @djq


Mar
3
comment Trigger a click event on a leaflet map?
Thank you for the suggestion. Do you know if it is possible to trigger this, without creating a popup? In my case I add 70 points to a map (binding a popup), and want to trigger one of these popups later.
Feb
17
comment What do the parameters for Google Streetview mean?
Thanks for the link and description. That all makes sense for construction of the older style streetview URLs, but the link that I pasted above uses a different structure, AFAIK
Feb
17
comment Is there an opensource way of making 'streetview' panoramas?
Very cool, I look forward to playing with it more!
Feb
17
comment Get geometry column back when counting points in polygon using PostGIS
Does each borders.name have a matching borders.geom? If so you can do a GROUP BY ch01.borders.name, borders.geom and it should return both name and geom.
Feb
4
comment How to add an offset to a GeoJSON layer in Leaflet?
One way of achieving this could be to make a Javascript function that takes in myLines and then returns a geojson object with the coordinates offset. You would need to loop through the coordinates and and the offset to the values.
Feb
2
comment Is it possible that a good spatial index just cannot be made?
Out of curiosity, have you explored the same approach using Postgres/PostGIS? It would be interesting to see how it compares.
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)