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


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.
Dec
11
comment How to speed up queries for raster databases?
I agree - perhaps I did not emphasize that it is only useful if several values are needed at the same time; I'll clarify this.
Dec
11
comment How fill length and feature count in PostGIS table for each polygons
If you can, it's better not to use capitalized column names. Then you can write m.townname instead of m."TownName". In PgAdmin for example, sometimes the capitalized letters are not shown which can be puzzling.
Dec
10
comment building opentripplaner gtfs.zip
Please use the edit link on your question to add additional information. The Post Answer button should be used only for complete answers to the question.
Dec
5
comment Can't drop table with geography column
Can you login into the database using psql?
Nov
26
comment Geographic locators within Polygons
It sounds like a term you should search for is spatial join
Nov
23
comment Do postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.0.3. work together?
Your accept rate for previous questions is 0. Did any answers to your previous questions solve your problem? If so, please consider marking the questions as answered by ticking the checkmark beside the answer.