Re: [Talk-GB] OpenHants - doing something with the Hants CC data in the meantime

2012-06-14 Thread Nick Whitelegg
Hello Rob,

Sorry for the late reply on this. Basically how it works is:

- the shapefile was converted to Postgres SQL using shp2pgsql;
- the data was imported into a PostGIS database;
- some custom code (actually same underlying code as Freemap) was written to 
fetch data as GeoJSON from the database by bounding box;
- Leaflet was used to produce the overlay; this is quite easy as Leaflet 
automatically handles GeoJSON.

I'll try and write it up as a blog post. Some (old) code for doing this is on 
the Freemap github site; I'll try and update it in the next few days.

Nick

-Rob Nickerson rob.j.nicker...@gmail.com wrote: -
To: talk-gb@openstreetmap.org, nick.whitel...@solent.ac.uk
From: Rob Nickerson rob.j.nicker...@gmail.com
Date: 09/06/2012 12:02AM
Subject: Re: [Talk-GB] OpenHants - doing something with the Hants CC data in 
the meantime


Fantastic use of the data Nick!

Is there any guides for how to do something similar? I was trying to visualise 
the Natural England data using Leaflet but failed miserably as the shapefile is 
too big. Your website appears to load just the bit needed. Would I be able to 
use some of your code?
 
Cheers,
RobJN

p.s I'm not hugely tech savy, but with a simple set of steps (e.g. Load data in 
x, tweak code where there are references to yz, etc) should be enough to get 
me started as I can research the details on google.
 
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] Wychavon Way Revised Route

2012-06-14 Thread Robert Whittaker (OSM)
On 13 June 2012 22:29, Steve Brook srbr...@tiscali.co.uk wrote:
 Worcestershire County and Wychavon District Council have revised the route
 of the Wychavon Way long distance footpath so it now resides entirely within
 the Wychavon District.
[snip]
 To update the relation to reflect the new route; I have moved sections of
 the original route that were demoted into child relations contained within
  the original relation. I think this is a better solution for retaining the
 old route information

I'm not sure I agree here. Surely any bits of route contained in
sub-relations of a main relation will be seen as part of the route
defined by the main relation. So if you ask an OSM-based tool for the
route of the Wychavon Way as defined by the OSM relation, you'll end
up with the old and new routes together.

If you want to continue to record the original Wychavon Way and at the
same time avoid duplication of the parts that are common to the old
and new routes, I think you'd want to do the following:

Relation #1 for the original Wychavon Way -- contains relation #3 as a
child-relation, together with the ways that are in the old route but
not in the new route.
Relation #2 for the new/current Wychavon Way -- contains relation #3
as a child-relation, together with the ways that are in the new route
but not the old route.
Relation #3 for any ways that are common to both the new and old routes.

You could even go a stage further and define two other child-relations
for the sets of ways that are in the old route but not in the new
route, and the ways that are in the new route but not the old route.
Then each of the two main relations #1 and #2 would just contain two
child-relations.

Personally though, I think I'd just keep things simple and have one
standard relation (directly containing all the ways) for the
new/current route -- this is surely the most important thing. Then, if
you want to keep the data, another relation (directly containing all
the ways) for the old/original route.

Robert.

-- 
Robert Whittaker

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] OT: Is Bristol the UK's only cross-border city?

2012-06-14 Thread Shaun McDonald
On Wed, June 13, 2012 3:40 pm, Colin Smale wrote:
 On 13/06/2012 14:38, Philip Barnes wrote:

 The built up area of Chester straddles the England-Wales border and
 the football ground is right on the border. The pitch being in Wales
 and some of the car park and offices in England.


 I think this is a little curious, but it doesn't seem to imply any
 administrative ambiguity as there is in the Severn Estuary. May be a bit
 hard to swallow for Chester FC that their home ground is in Wales though.

 There are probably loads of buildings in the UK which straddle a border.
 I wonder how that is handled for council tax, planning etc. In
 Baarle-Hertog (BE)/Baarle-Nassau (NL) (see [1]) this happens a lot; for
 administrative expedience the nationality of a house is determined in
 practice by the country in which the front door is located. But there
 are also cases where the border goes through the front door. When the
 borders were re-surveyed a few years ago one house had suddenly switched
 countries. The problem was resolved by moving the front door by a couple
 of metres.

I heard of someone who lived on the boundary between Bromley and
Southwark, a third of the council tax went to one council and 2 thirds to
the other one. Eventually they moved the boundary such that they were
completely in one council area.

Shaun



___
Talk-GB mailing list
Talk-GB@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-gb