1,411 reputation
214
bio website
location United Kingdom
age
visits member for 2 years, 5 months
seen 15 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.


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.
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
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
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 """
Apr
30
comment gdalwarp increase resolution
@kyle thanks for the tip about NUM_THREADS very useful. I was using --config GDAl_CACHEMAX 1024 and -wm 1024 which also help
Feb
3
comment Import CSV file into Postgis DB with Location-field formatting?
can you edit your post and put a sample of your csv up, say first 5 rows
Jan
28
comment Batch merge large numbers of.asc grid files
Did you want a .asc file as the output or a geotiff or a hillshade?
Dec
3
comment Map background and style
yes you will need an SLD for your points, lines and polygons.
Dec
3
comment Map background and style
In order to create a map as detailed as Google Maps you need all the points, lines and polygons that make up a map. In your image you are only showing points. If you have this data then you need to create an SLD for each geometry type and style individual features, for example style rivers blue while roads are red. I would recommend looking at the SLD Cookbook and maybe this workshop workshops.boundlessgeo.com/geoserver-intro/styling/…
Nov
26
comment Ordnance Survey 1 km Grid
@Vesanto totally understand but will need to check internally how Ordnance Survey can best do this for other users rather than keep it where it is.
Nov
26
comment Loading / georeferencing OS rasters in QGIS
Glad I could help. Can you accept the answer so that other people can find it useful in the future
Nov
21
comment postgis: difference with && operator and st_intersects
When I have tested && and ST_Intersects before, the && version just compares bounding boxes. So it is very quick but in a way not that accurate. Where as the ST_Intersect does a bounding box to reduce the number of features to check against, and then does a full geometry check feature against feature.
Nov
18
comment Using OS Mastermap SLDs in QGIS
Hi Chris - I often start small and build up. For example, for cartographic text drop the OSMM style and see if the points show on the map. Then use the label and use the textstring, does the label show? Then use the data derived options and shift the position of text and the orientation using the new columns you have added. see what I mean? Here is a link to one I have used successfully - dropbox.com/s/udon2b1dv40l4vy/…
Nov
16
comment Using OS Mastermap SLDs in QGIS
you might be intersted in looking here for styles - github.com/QGIS-UK/Styles.
Nov
14
comment Problems installing the Astun Technology Loader in Windows 7
@user23808 it depends. If you use the standard ogr2ogr command found in the loader.config file it will load directly into Postgis. This is slightly slower though. The alternative is to create SQL dump files and this uses the loader.config in the pgdump folder but I would not do it this way just yet
Nov
13
comment Create interactive map with no server
@johanvwd I amended your code and successfully got it working but it is awfully slow even on a topojson of 1.4Mb, let alone the one is need to use which is 8Mb. Any other thoughts??
Nov
13
comment D3 adding topojson - no data visible
@Mapperz - thanks for the links. The boundaries I require are different from those included as OpenSpace boundaries, as a result I need to add them as a seperate overlay. The .js script I am sure will be useful