6,988 reputation
353146
bio website djq.me
location Dublin, Ireland
age
visits member for 4 years, 2 months
seen 42 mins ago

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

twitter: @djq


Jan
8
comment How do I create multiple polylines from single polyline that consists of disjunct sections?
Can you describe what software and version you are using to do this, and perhaps link to a diagram of what you are doing?
Jan
1
comment Easiest way to create measured intervals between shape points
What software would you like to do this in?
Dec
28
comment Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function)
I assume that using ST_DWithin() is not relevant in this case? Also I don't know if it would make any difference but perhaps you could use SELECT .... LIMIT 1 on your second query instead of SELECT DISTINCT ON
Dec
26
comment Where can I download the Google Road network as shapefile?
An answer here: spatiallyadjusted.com/2012/12/26/…
Dec
20
comment How to colour polygons with a completely transparent fill using MapServer?
Thanks for your answer - is the SLD for geoserver related at all? I don't see the similarity between it and MapServer.
Dec
15
comment How to colour polygons with a completely transparent fill using MapServer?
Just added an image to explain what I mean.
Dec
15
comment Which Geo stack for an online strategic wargame?
OpenLayers might be another JavaScript library to consider as part of the workflow.
Dec
15
comment How to colour polygons with a completely transparent fill using MapServer?
Sorry for the double confusion; just clear polygon fill; lines do not matter.
Dec
14
comment How to colour polygons with a completely transparent fill using MapServer?
I don't mind if the lines appear or not; I just want a clear polygon fill.
Dec
14
comment How to colour polygons with a completely transparent fill using MapServer?
how could I have no-fill of the polygon that way?
Dec
14
comment How to colour polygons with a completely transparent fill using MapServer?
Did this result in a completely transparent polygon? I tried experimenting with values of TRANSPARENCY from 0 - 100 and it seemed to just adjust the opacity. I realize this was not clear in my question intially - I revised it.
Dec
12
comment How to re-project shapefiles?
I don't know your dataset or the google values well enough to judge, but as a reference a point in Dublin, Ireland using EPSG:900913 is -788694.0, 6956099.0. These coordinates are not lat/lng they are x/y in meters.
Dec
12
comment How to re-project shapefiles?
Can you try something like EPSG:900913 as a test? Moving between lat/long projection systems is still re-projecting; WGS84 is a lat/long system.
Dec
12
comment How to re-project shapefiles?
What do you want to project it to? You chose EPSG:4326 which converted the shapefile from the previous projection to WGS_84
Dec
12
comment How to re-project shapefiles?
yes... you can't reproject a qgis project file which is why I gave my first answer. Then I realized you wanted to reproject the shapefiles in bulk. One way of doing this is to loop through all the files in a folder using the command line with ogr (another would be to see if you can pass ogr a folder of shapefiles).
Dec
12
comment How to re-project shapefiles?
Are all the shapefiles in the one folder?
Dec
12
comment How to re-project shapefiles?
Are you trying to reproject a shapefile? A project file has a .qqs ending, a shapefile ends with .shp. I don't think you can re-project a project file but I could be wrong.
Dec
12
comment How to handle postgresql/postgis geometry type errors in a function?
Thanks for the suggestion. I still get an aggregation error though when using this approach: ERROR: aggregates not allowed in WHERE clause LINE 7: AND GeometryType(ST_ConcaveHull(ST_Collect(geom), 0.85)) != 'LINESTRING'
Dec
12
comment postgis error: when adding features geometry has z dimension but column does not
Thanks - I was unaware of it. Happy to add it to my answer unless you'd prefer to answer yourself......
Dec
11
comment Projecting PostGIS in Openlayers
Can you explain a little more what you want to do? To move between different projections you can use ST_Transform(). Many web-mapping tools use web-mercator - for example the google SRID for web-mapping is 900913.