Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Your Answer


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

Browse other questions tagged or ask your own question.