9,538 reputation
1834
bio website geospark.co.uk
location Liverpool, United Kingdom
age 39
visits member for 2 years, 1 month
seen Apr 16 at 16:12
stats profile views 351

Maps. Archaeological geophysics. Programming. The holy trinity of my science geekery.

I'm a freelance geospatial and archaeological software developer.


Apr
3
awarded  Yearling
Feb
1
awarded  Revival
Jan
22
comment Ordnance Survey TOIDS: converting from strings to integers
I agree. If you're worrying about space or performance of the extra 4 bytes, you're doing something wrong. If you do get data from several different sources, you could preprocess the string to strip the 'osgb' part (AKA the authority in WKT terms) and place it in a column of its own. If you're really picky about space, you could use a byte to use as a look-up into an authority string table.
Dec
5
revised Are there any tricks to using a schema other than public in PostGIS?
Added syntax highlighting.
Dec
3
answered Scripting (with) WPS?
Nov
24
awarded  Nice Answer
Nov
19
awarded  raster
Nov
14
awarded  Nice Answer
Oct
3
answered Representing degrees between -1 and 0 in Degrees:Minutes:Seconds
Oct
2
comment Is there a difference between projecting shapefiles then rasterizing & rasterizing shapefiles then projecting?
Curse your sophism! :) In my mental GIS, which is based on PostGIS/QGIS, line segments never have extra vertices added to them, unless the user adds them beforehand. I can't speak for "good" GISes though :p
Oct
2
answered Is there a difference between projecting shapefiles then rasterizing & rasterizing shapefiles then projecting?
Oct
1
revised Does QGIS have WMS-T (WMS with time) support?
edited title
Sep
25
answered What is the correct spelling: CSW or CS-W?
Sep
24
awarded  Revival
Sep
21
awarded  Custodian
Sep
14
answered For the non-IT savvy GIS person (not great w/ Linux & Apache) could someone suggest how to set up PostgreSQL, Geoserver, and ISS/Apache?
Sep
13
comment Is NAD 83 the same as EPSG:4326?
This answer might help clarify things: gis.stackexchange.com/questions/23690/…
Sep
11
awarded  Fanatic
Sep
7
revised Using render_list to render only map extract
Typo
Sep
6
awarded  Synonymizer