Can somebody help me, give me hints, inform me about related scripts,
create the first layout/design/set-up or any better ideas with the
following:
I want to create a non commercial site with Google Maps and Google
Streetview map using PHP 5 and MySQL with realtime (Ajax?) update
possibilities (Google maps api V3)
The database (named google) has 2 tables :
- users (id, username, password, address, zipcode, city, email) -
number of users: max 100
- poi (id, name, address, city, description, lat, lng, type, userid,
date) - number of poi's at this time: about 30.000
Requirements:
1. Visitors are users that are not logged in (guests) with only rights
to view data
2. Users are logged in users with rights to update and connect to the
database
3. Visitors can see all data, but can't update data.
4. Visitors can't save Lat and Lng of dragged markers (or if possible
they can't drag markers)
5. Users can update data and drag markers to new positions and can
save the updated data and positions into the database.
6. Map controls are the large 3D control and the Streetview control is
also available
7. POI's will be visible after selecting a city from a drop down list
created by a select distinct city from poi order by city
8. When a city is selected the poi's will be on the map, the map is
zoomed in and will fit all poi's
9. Markers will show the data from the databasefield 'name' (max 4
characters) of the poi table for the selected city
10. Markers that are not updated yet have a red color, updated markers
are colored green (color is stored in the database in the field 'type'
as red and green)
11. Marker names (the max 4 characters from databasefield 'name') are
ordered by name and clickable in a scrollable sidebar
12. The scrollable sidebar only contains the names of all markers of
the selected city and a little marker with the correct color in front
of it
13. When a marker is clicked on the map the correspondending item on
the sidebar will be highlighted and visible in the sidebar (the
sidebar has to scroll automatically when needed to show the
correspondending marker)
14. When a marker is clicked on the sidebar it should be highlighted
and on the map the marker.openInfoWindow(html) will be opened
15. When a marker is clicked (on the map or on the sidebar) a separate
Streetview map will be shown using the Lat and Lng values (Only shown
if Streetview is available for that location, otherwise show a message
in this window with text 'No Streetview avalable for this location')
16. When a marker is clicked (on the map or on the sidebar) a second
sidebar will be opened with the correspondending name, address, city
and description which can be edited by a user. The Lat and Lng will be
shown greyed out, these values will be updated automatically when the
correspondending marker is dragged to its correct location on the map
or Streetview window. The 'update changes' button is on the bottom of
this window.
17. After updating the marker location and attributes the user can
click op a button called update changes.
When the user has clicked 'update changes' button the values of name,
address, city, description, lat and lng
will be updated in the database with the new values and type (=color
of the marker) will be changed to green, userid will be updated with
de id of the logged in user and the date field will be update with the
date and time of the change
18. When the changes are stored in the database the markers and
sidebar will be updated with the new values and colors
19. When a user selects an other city from the drop down list the
Google maps window will zoom and fit to the markers of that city. The
sidebar will be updated with the correspondending values, Streetview
and the second sidebar (the update sidebar) are empty. (Till the user
clicks on a marker or on a marker name in the first sidebar)
Suggested interface:
If possible all windows should be available/shown on the same screen
On top:
select a city: [drop down list city] (See 7.)
Down to the drop down list:
Google maps window (where markers with the names are shown). On the
right of the Google maps window: Sidebar with ordered marker names
(highlighting is also done here)
Down to the Google maps window:
Google Streetview window (when a marker is clicked on the map or in
the first sidebar). On the right of the Google Streetview window:
Sidebar for updating (including 'update changes' button)
Same, but now trying to show it in a graphic design:
________________________
Select city : |Drop down list cities \/ |
________________________
_______________________________________ ______________
|
| | scrollable \/ |
|
| | sidebar. |
|
| | |
|
| | |
|
| | ordered |
| Google maps window | | list
of |
|
| | marker names |
|
| | and |
|
| | highlight |
|
| | |
|
| | |
_______________________________________ ______________
_______________________________________ _________
|
| | sidebar |
|
| | |
|
| | update |
| Google Streetview window | |
values |
|
| | and |
|
| | update |
|
| | changes |
|
| | button |
_______________________________________ _________
--
You received this message because you are subscribed to the Google Groups
"Google Maps JavaScript API v3" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-maps-js-api-v3?hl=en.
