network profile
| bio | website | |
|---|---|---|
| location | United Kingdom | |
| age | ||
| visits | member for | 1 year, 1 month |
| seen | 22 hours ago | |
| stats | profile views | 35 |
I currently work as a GIS Consultant for Ordnance Survey Great Britain's National Mapping Agency. I support our customers across all sectors highlighting the benefits of GI data and GIS.
My specialities are web services, open source software and newer technologies and how they apply to GIS.
|
Jun 13 |
comment |
How can i enable PostGIS Shapefile and DBF Loader 2.0 plugin in PgAdmin III during the stack builder process you should have recieved a dialogue box aksing to install the PostGIS Shapefile Loader. Did you see this and say 'No' - then that is where it has gone wrong. You might be able to find the exe in the C:\Program Files\PostgreSQL\9.x\bin folder |
|
Jun 13 |
comment |
How to create shapefile from OS MasterMap data using ArcGIS Desktop 10? @Mark - good find. Didn't know about that one |
|
Jun 12 |
comment |
Integrating geoserver with openlayers using WMS if you are using Firefox install an add-on called Firebug and turn it on. This should allow you to see if the calls are actually being made to your geoserver. |
|
May 14 |
comment |
What Is The Ideal Workflow To Map (British) Postcode Territories @kieran_delaney PL/R falls over saying i need 22.3Gb. I launched a huge EC2 machine with 35Gb of RAM and it still fell over. This was only supposed to be a little test just for fun - I am now on a mission to solve! ;) |
|
May 14 |
comment |
What Is The Ideal Workflow To Map (British) Postcode Territories @kieran_delaney just got R and PL/R setup and just kicked off the query. Quick question tho - should I do a simple SELECT * FROM r_voronoi('codept_open','geom','gid'); or is best to create a new table? |
|
May 14 |
comment |
What Is The Ideal Workflow To Map (British) Postcode Territories I have tested this with Windows 7 x64, PostgreSQL 9.2 x64, PostGIS 2.0.1 x64, Python 3.2 x64 and ran the sql script which successfully loaded the Vornoi function and then run against codept open and it returns no values. In some of the comments at the bottom of that blog post below do say the Python 3 version still has some problems. If anyone gets this to work I would be interested to know how |
|
Apr 18 |
comment |
PostGIS Better ST_Intersects Query Hi Paul - thanks for your response. I thought that would have been the case but my initial query took so long I thought it was not using the &&. I have edited my initial question to show the two queries |
|
Apr 17 |
comment |
Using Python to parse an XML containing GML tags Hi Matt - I have never done it myself but a company called Astun Technology released an open source GML loader for Ordnance Survey GML files. You can find it here github.com/AstunTechnology/Loader. In the code it uses a GFS file that states what the structure of the GML looks like so the python module LXML can understand it. There may be some resuable code in there for your situation. |
|
Apr 5 |
comment |
Geoserver, openlayers and WMS We use PostGIS too, just make sure that is optimised too. Can you accept the answer if you are happy |
|
Apr 5 |
comment |
Geoserver, openlayers and WMS sorry last comment, what format is your data in? For the best performance and management put them into a database. |
|
Apr 5 |
comment |
Geoserver, openlayers and WMS I would also recommend some of the past presentations from FOSS4G from the likes of Andrea at GeoSolutions who talks about the importance of styling the data correctly, i.e don't show features at 1:1mill when they are really detailed. Looking at caching, which is in-built to GeoServer as GeoWebCache and maybe pre-render your mapping tiles. Just get started and see how you get on but do not worry, GeoServer can easily handle that number of features. |
|
Apr 5 |
comment |
Geoserver, openlayers and WMS hi Christain, where I work, Ordnance Survey GB, we use GeoServer to serve our OS MasterMap Topography Layer which has 500 million features, which show at scales from 1:500 to 1:6k, then various products all the way up to 1:10mill. Follow the GeoServer instructions on deploying in production - docs.geoserver.org/stable/en/user/production/index.html and also the OpenGeo White Paper which is fantastic. opengeo.org/publications/geoserver-production |
|
Mar 8 |
comment |
How to speed up an st_intersects() query? Does having the polygon from text enable a spatial index on that polygon to be created? So you might want to actually load in France as a single polygon, create a spatial index on it then run the query. I have also been wondering if clustering on the spatial index might help too. It is something I have yet to try but just a thought. |
|
Feb 28 |
comment |
Way to add 1km x 1km UTM grid onto online map service if that is the case then just write a simple OpenLayers HTML similar to this one openlayers.org/dev/examples/kml-layer.html and point to your KML of your grid. |
|
Feb 27 |
comment |
Way to add 1km x 1km UTM grid onto online map service yes that could work, but what will you do with the actual HTML page of google maps with the KML, use your own web server? |
|
Feb 25 |
comment |
GeoWebCache blank tiles are you using GWC within GeoServer? If so can you see your data in the standard layer preview? |
|
Oct 5 |
comment |
Open-source software for managing terabytes of different formats of geospatial data? Hi All Thanks for the replies, I get the feeling it is not a one stop solution. I think I will look in QGIS Browser first and compare against VoyagerGIS. |
|
May 6 |
comment |
Add building height from xyz points in PostGIS Hi Nicklaus the geometry of the building exists for all 400 but only some have a height. I am running the query on the full tables but it ran for 14 hrs and then crashed as it filled 32gb worth of hard drive space on my laptop. This makes me think it's definitely wrong. |
