Reputation
1,501
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
3 18
Newest
 Yearling
Impact
~79k people reached

  • 0 posts edited
  • 0 helpful flags
  • 28 votes cast
Jul
27
comment CartoDB - feature appears only on some scales
@iriberri i think its the refresh time. I added refreshTime: 2000 and it seems to really help. Going to implement a security definer - blog.cartodb.com/…
Jul
24
revised CartoDB - feature appears only on some scales
added 559 characters in body
Jul
24
asked CartoDB - feature appears only on some scales
Jul
17
comment WGS84 to OSGB, using VB script
If you would like a more accurate conversion you will need to use OSTN02 transformation rather than Helmert. Not sure if this exists in VB though but you can download the info from the OS website - ordnancesurvey.co.uk/business-and-government/help-and-support/…
Jun
3
comment ogr2ogr failing to open/convert GML
Just to let you know you can convert MasterMap GML with plain OGR2OGR, you do not need a GML reader. Something like this should work ogr2ogr -f GeoJSON output.json /vsigzip/mastermap.gz This will read straight from the GZip file rather than extracting to GML first
May
6
awarded  Yearling
Apr
28
awarded  Popular Question
Feb
4
asked CartoDB Custom Projection Fails
Jan
14
awarded  Popular Question
Dec
10
awarded  Popular Question
Oct
29
awarded  Popular Question
Oct
14
awarded  Popular Question
Sep
24
awarded  Autobiographer
Sep
3
accepted Find nearest distinct features to a point
Sep
3
comment Find nearest distinct features to a point
looks like I got your SQL working. ST_Distance did not seem to like have a st_makepoint, so I saved the point into its own table and then was able to do ST_Distance(table.geom, point.geom) Whizzed through 40mill records in 37mins!! Thanks
Sep
3
comment Find nearest distinct features to a point
Unfortunately this does not work. It wants ST_Distance to have st_distance(geometry, geometry, integer), that final integer I do not know.
Sep
2
asked Find nearest distinct features to a point
Jul
2
awarded  Curious
Jun
26
accepted MapInfo 12 problems with PostGIS database
Jun
26
comment MapInfo 12 problems with PostGIS database
Myself and all the team I work with are using PostGIS 2.1 so I guess it will have to wait to fully implement. However, I will try and test your answer on a different machine just to check it works. Thanks