6,889 reputation
247142
bio website djq.me
location Dublin, Ireland
age
visits member for 4 years
seen Aug 28 at 19:05

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

twitter: @djq


Apr
17
comment Workflow to convert a DWG CAD file to a shapefile
Is it also possible to directly save it as a shapefile?
Apr
12
comment Workflow to convert a DWG CAD file to a shapefile
Thanks, I'm familiar with Postgis, so happy to store it there; how do I go about using the ground control point with ogr2ogr? Do I need a point (or points) of reference for the geolocation and within the CAD file?
Apr
12
comment Workflow to convert a DWG CAD file to a shapefile
Unfortunately, I do not have access to ArcGIS either
Apr
8
comment Workflow to convert a DWG CAD file to a shapefile
Unfortunately I do not have Autocad map 3D, but it's useful to know it's possible within that software.
Apr
8
comment Workflow to convert a DWG CAD file to a shapefile
@MichaelMiles-Stimson I don't have a large number, but it is a task I will need to repeat every few weeks. I haven't had much luck opening the dxf in QGIS - do you have any pointers?
Mar
31
comment What is wrong with how I am using ST_Within?
Did you have an index on the geometry column? You can add an index using something like this CREATE INDEX idx_districts ON geog USING GIST ( geog );
Mar
4
comment Trigger a click event on a leaflet map?
Thank you for your help, but what I am actually trying to do is to fire a click event at a particular lat/lon and not to create a new popup, but to trigger one that exists (I will update my question again).
Mar
3
comment Trigger a click event on a leaflet map?
I'd like to open a popup at the clicked location and I don't want markers.
Mar
3
comment Trigger a click event on a leaflet map?
I understand how to open the popup if it is stored in an array, I want to try open it based on clicking at a place on the map. I'll try and make this clearer in the question.
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.