6,764 reputation
244133
bio website djq.me
location Dublin, Ireland
age
visits member for 3 years, 10 months
seen Jul 21 at 21:59

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

twitter: @djq


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....
May
22
comment Can POSTGIS 2.0 be install with POSTGRES 9.2 on Ubuntu 12.04 OS at the moment?
Recently I had a problem installing PostGis using the commands @MikeToews suggested (only using postgres 9.1) due to a missing package. Not sure if this is your problem, but it threw me off for a few hours until I realized I need to repair the packages using apt-get update --fix-missing
May
7
comment How can a 3D model of a building be displayed in a web-browser?
I'm using PostGIS, so exporting in KML is fine (I'm interested in general massing, rather than details at the moment). I would prefer that users do not need to download a plugin which is why I have shied away from google earth. I'll take a look at OSM3D, thanks.
May
4
comment How can a 3D model of a building be displayed in a web-browser?
I did think about this method - but I would like an approach that does not require a plugin. I do understand that that streetview is not a 3D building, but I wondered if there was any approach that could enable the panorama of images to be edited such that a building could be inserted.
Apr
21
comment What is the easiest one click install method for PostGIS and it's entire dependencies?
Is CREATE EXTENSION postgis only for PostGis 2.0?
Apr
21
comment Which function for creating a POINT in PostGIS?
Thanks for a great explanation about how to calculate this. I'm curious about the SQL syntax, <POINT CONSTRUCTOR METHOD>. Is that just pseudocode to refer to the four different approaches, or are you making some kind of function?