6,938 reputation
249143
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


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?
Apr
17
comment How to georeference PNG images using QGIS?
I agree, my question is a duplicate. Wondering if there is a way to make the other question a little easier to find? I did try many search terms.
Apr
17
comment How to georeference PNG images using QGIS?
thank you, this is exactly what I needed.
Apr
17
comment How to georeference PNG images using QGIS?
no, they are maps but in png format
Mar
24
comment View PostGIS geometry in QGIS
Are you certain that your lat/longs are correct? Latitude is the Y axis, longitude is the X axis (I've got these backwards multiple times). I suspect QGIS is fine, and your data is incorrect.
Feb
24
comment Advice on choosing ideal software for consultancy
Could you add which part of the world you are in? I'm wondering if OpenStreetMap might be of use.
Feb
14
comment How to zoom to point boundary using OpenLayers?
This does make sense, but strangely firstExtent.extend(secondExtent) is undefined (both firstExtent and secondExtent have bounds that exist).
Feb
14
comment Why ST_Intersects() returns one row more than expected?
Why would this happen with ST_SummaryStats() though? Surely that is being calculated on all of the raster data that intersects?
Feb
14
comment How to zoom to point boundary using OpenLayers?
Do you know if there is a way of handling data on two separate layers? I have the two points style differently (I could also try to have them on the same layer but with separate styles I suppose).
Feb
14
comment Does QGIS support vector Rubbersheeting?
For those unaware of what RubberSheeting is: en.wikipedia.org/wiki/Rubbersheeting
Feb
13
comment Using PostGIS for a large trajectory dataset
If appropriate, there is also a package for connecting R to Postgresql (cran.r-project.org/web/packages/RPostgreSQL/index.html) which can be a convenient way of reading/writing from the database for non-spatial analysis (as R does not handle geometries).
Feb
8
comment How best to fix a non-noded intersection problem in PostGIS?
Not entirely clear on how I use st_node here - can I use it before st_intersection?
Feb
8
comment How best to fix a non-noded intersection problem in PostGIS?
That is a great presentation (thanks @PaulRamsey). How should I use ST_Node and ST_Dump? I imagine I would need to use them near this part of the function, but am not certain: st_intersection(''SRID=''||st_srid(%2$s)||'';%4$s''::text,''%5$s'') in
Feb
8
comment How best to fix a non-noded intersection problem in PostGIS?
Yes, I am using WHERE ST_IsValid(p.geom) to filter the points initially.
Feb
2
comment Get Lat & Lng from GeoDjango OSMGeoAdmin
You could pass an argument to this from the browser using an ajax request.
Jan
31
comment Turn-by-turn direction using PgRouting
@lewis I'm not sure on how best to calculate the angle at intersections - do you have any advice on how to do this?