Payphone database

From Bob's Basement

Project Inception: 20th October, 2008

Status: In testing

Project Leader: BOfH

Contents 1 Introduction 2 Specification 3 Done 4 Future todo 5 How can I help?

[edit] Introduction

The idea of the project is to create and maintain a database of pay phones in the UK.

The site can be found at http://payphonedb.bobsbasement.co.uk. Where you can add phones, search phones and find more information on updating the database.

[edit] Specification

• Database records of:

• • Phone number
    
  • Address
  • Postcode
  • Model
  • GPS coordinates
  • Date record updated
  • Record updated by
  • Photo
  • Revision number
  • OS grid referance

• User level access control
• Confidence rating of user
• User stats
• Web frontend
• GPS lookup from postcode DB if GPS not available
• Version history of database updates
• Feedback of data to OpenStreetMap

[edit] Done

• Create database
  
• User login
  
• County list
  
• File upload
  
• Validate file
  
• Google maps
  
• GPS postcode lookup
  
• Add if exists
  
• Editing
  
• Image resizing
  
• Error trapping and logging
  
• Fix cwd (worked around)
  
• SSL login
  
• Add phone features and payment options
  
• Add created by
  
• Licensing
• Credits
• Validate county
  
• Limit search results per page
  

[edit] Future todo

• Convert between GPS and OS grid references
  
• More GPS validation
  
• More OS grid validation
  
• Gallery
  
• Help
  
• Show the payphone location on the OSM as well as Google maps
  
• Add an API
• Import data from OSM
• Unknown phone DB

[edit] How can I help?

We need people to add content to the database. Go out and find payphones and add them to the database.

I need some help creating a help page (ironic isn't it?) to identify payphones. If you can write a page explaining how to identify the different types of payphone that would be greate. Please use the Bob's Basement CSS or if you can only provide the content, do that and I shall webify it.