Google camping map

Google Camping Map General Project Description: This project will create an interactive map of camping sites in lower saxony in germany using google map technology. Users will be able to enter an address and a google map of the area around this address with tags at the campingsites will be displayed. The a click on the tag opens a bubble with address, link, email and telephone of the campingsite. One campingsite (mine) will be displayed red while all others are green. Also users can enter new camping sites and edit old ones. For every change a new record is generated. Admin can delete recods and decide which campingsites will be displayed in red. The user will be able to swich between different languages. I will use this map to promote my own very small camping site. Since it is in a very small town nobody will find it via google. But when someone is looking for a campingsite in a bigger town close to mine in a map, my camping site will be displayed, and there might just be a chance that someone clicks on it. To make it attractive for campers to use my map, many campingsites must be featured. I have a list of 200 camping sites in Lower saxony, so I think a map displaying them all will be useful. To increase the usefulness of the map, online updating by users is necessary. Since customers on my campingsite also come from the netherlands and from scandinavian countries, I need the possibility to add languages beside german and english. Detailed Project Description: Tables: 1.) Campsites: CampsiteNumber (Integer < 100000, automatic) Name (30 Characters, mandatory) Street (30 Characters, optional) ZipCode (5 Digits , optional) City (30 Characters, mandatroy) Telephone: (30 Characters, optional) Email (email format, optional) URL (url format, optional) X-coordinate (floatingpoint double precision, will be calculated by the script) Y-coordinate (floatingpoint double precision, will be calculated by the script) Timestamp (Date+Time, automatic) IsSpecial (boolean, can only be changed by admin) Webpages: 1) Admin login: Textfield: Enter Password Button: Overview (if password ok, goto Admin Overview) 2) Admin Overview A list of all campsites will be shown (most recent record for each campingsite). After each campsite an edit-button, a delete-button and a make-special/make nomal-button is displayed For nomal campsite make-special is displayed, for special campsites make-normal is displayed. Pushing the button flips the IsSpecial field. Edit-button will go to the Edit-Page, Delete-Button will delete the most recent record of the campsite. 3) Map Layout similar to [login to view URL] Textfield: Campsites near: (default „Lauenbrueck“) Button: Search Map with centered in the address of the textfield (green arrow), 5 km radius around this address is displayed with markers (green) at all normal campsites. Markes for special campsites will be red. Klick on a marker will open a bubble with: Name (linking to URL) Street Zip City Phone Email (as mailto-link) Link „edit“ (As example on [login to view URL] plus controls for zoom) Click on „edit“ will link to „edit-campsite“ (with number of current campingsite) Below the map there is a link „enter new campsite“. Clicking will linkt to „edit-campsite“ (with number zero) 4) Edit Campsite This will always be a new window. If number is 0 genenerate new number. Fields Name, Street, Zip, City, Phone, email, URL can be entered (Default: Most recent record if campingsite already exists) Fields X-coordinate, Y-coordinate are shown. Map around these coordinates, with marker at these coordinates is [login to view URL] no coordinates are given yet the center will be in Lauenbrueck, Germany (which is where my campingsite is). In this case no marker is shown. Button „move marker to above address“. Below the button display „If marker position is not correct, you can move it using the mouse“. Botton „save“. Button „don’t save“ If Button „move marker“ is pressed, coordinates of this address are requested from google and the map is centered around these coodinates. (As in example: [login to view URL]) On the map the marker can be moved. The coordinates will be changed accordingly (As in example: [login to view URL], without jumping, but with all controls including zoom displayed) If Button „save“ is pressed a new record for this camping site with current data and current timestamp is created. Close window. If „edit“ was called from „map“, redraw map centered around coordinates of current campsite. If Button „don’t save“ is pressed, just close window. Further instructions: 1) The script needs to be multilangual. For each language an XML-File is needed which contains translation of all texts. On each webpage flags of the available languages will we displayed and the user can swich language by clicking on the flag. New languages can be added by providing XML-File with translation and flag. The file for the language english is part of this project. The files for german and other languages will be provided by me when the programming is finished. 2) Installation of script and database at a service provider is part of this project 3) Filling Database with addresses of campingsites as provided in the attached excel file is part of the project. 4) A script that will ask google for coordinates of campsites that have no coordinates yet is also part of the project. The script will also save the coordinates recieved in the database. This script will be used to get coordinates of the adresses in the excel file. 5) on each web-page there will be a link "Suggestions" linking to a service that collects user-comments.