Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a MySQL database full of data about students (name, age, school, university, city, etc). What I want to do is to transform the data I got to markers on the map. To be more specific, I will for example calculate the number of students who study at the university X and come from town Y. The result of this request (a number) will be set on the map as a marker. I've been looking for such an example but couldn't find one in the OpenLayers examples. Besides, POI examples have text files as data sources.

To sum up, I want to know how to implement the transformation of the results of my request into markers (or graphics) on the map.

I wish I could resolve this because I'm stuck onthis for more than three weeks :/

Thank you so much !

share|improve this question
    
How do you envision this working? For example, if a student is from Buffalo, NY, and attends school at Florida State, where does the marker go? –  L_Holcombe Feb 17 '13 at 21:40
    
Well, all the queries of my application return a number (they all start with a 'count(*)' ). The purpose of the web application is to provide an idea about the distribution of students in a geographical space. Hence, the unit is a group of student. –  Sherlock Feb 17 '13 at 22:29
    
Did I get it correctly: query 'number of students who study at the university X and come from town Y' should display marker on each university, and marker is labeled with count of students, who come from Y? –  user1702401 Feb 18 '13 at 7:34
    
Yes, the query is as you said.. Concerning the marker, it might be labeled with the number of students, but I prefer graphics (like a cercle representing the proportion of students who come from town Y) –  Sherlock Feb 18 '13 at 17:27
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.