1,411 reputation
215
bio website
location United Kingdom
age
visits member for 2 years, 5 months
seen 3 hours ago

I currently work as a Senior GIS Consultant for Ordnance Survey Great Britain's National Mapping Authority. I support our customers across all sectors highlighting the benefits of GI data and GIS.

My specialties are web services, open source software and newer technologies and how they apply to GIS.


1d
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
Jun
25
comment MapInfo 12 problems with PostGIS database
@Mapperz I successfully did that, its point 7) in my list, and the schema and table was successfully created. But it seems it is empty until i make the tables mappable. Have you managed to get it to work? thanks
Jun
25
answered gsconfig installation in windows 7
Jun
25
asked MapInfo 12 problems with PostGIS database
Jun
17
answered Classic United Kingdom Projection?
Jun
12
comment TIFF to MBTILES conversion on a mac
not sure i understand what you mean? whn you loaded the new tiff file to tilemill did you see it in tilemill project? if not i dont think you are using tilemill correctly
Jun
12
revised TIFF to MBTILES conversion on a mac
added 994 characters in body
Jun
11
comment TIFF to MBTILES conversion on a mac
can you give me more details on which rasters you are trying to reproject? The problem with batch converting each tile seperately is that you will get a black NO DATA are around each and when you come to put them side to side it will look terrible. So your method of creating a VRT is the best route. If it does not work in QGIS download and install the GDAL Complete binary (if on windows) and open the command prompt and run the command from there
Jun
10
comment Postgres SSL SYSCALL error: EOF detected with python and psycopg
check does this query run in pgadminIII? If it does then it may be how the python code is intepreting your query. You may have to wrap it like """ query """
Jun
10
answered TIFF to MBTILES conversion on a mac
May
6
awarded  Yearling