Bridge height and weight app
This web based application uses the Warwickshire bridge height
restrictions data and the Warwickshire bridge weight restriction which
is displayed via Google maps.
Both of the restriction dataset were imported into MySQL database.
A single dynamic web page extracts the data from the database and
Bridges are displayed on the map depending on what is selected on the
dropdown menu. Selecting a bridge on the map will give details of the
bridge. Selecting the bridge in the menu box will not only display the
detailed bridge information but also zoom in on the bridge location.
There is also a feature to enter the height and weight of a vehicle
via the ‘Filter’ button which results in only the bridges been
displayed that are unsuitable for the vehicle to pass over or pass
This application took around three days to create, the code behind it
does have room for improvement and I do apologise for the poor layout
and the use of HTML tables!
Firstly I have found some possible errors with the height restriction
dataset, these are currently under investigation. The errors concern
the following bridges :-
Birmingham Rd Canal (A425/01) Easting 427087 Northing 265615
Bishoption Park and Ride (C93/15) Easting 418682 Northing 256834
Crackley Wood ( D5069/02 ) Easting 428831 Northing 274339
There is some room for improvement in these datasets. Both datasets
would benefit from having longitude and latitude coordinates
documented. These can be derived as in this application but it would
be an improvement to have these coordinates added at source in order
to reduce the risk of errors in translation.
The ‘Signed Headroom’ column does not state the units, they are
assumed to be in metres. Ideally the ‘Weight Limit’ column should
consist as two separate columns one for ‘PWL in tons’ and the other
‘Axel Limit in tons’, this would alleviate the need to parse text to
find the limit.
For the future
I haven’t really looked but I would like to think that there was some
sort of UK standard for this type of information. If not I would have
thought it worth while to have a set of standardised datasets for the
whole of the UK.
Can you find the bridge with a limit of zero tons?