About the Author

Sajjad is a Bangalore based cartographer and programmer, building tools to scale the data team and analyze large spatial data-sets at Mapbox. He has been working closely with OpenStreetMap data and technology for over 6 years.

Designing a New Map Portal for Karnataka Learning Partnership.

The map is an important part of our project, action and process because it serves as the pivot point of navigation. I will quickly talk about the data and tools before we discuss the design aspects.

We have a fairly large dataset of schools in Karnataka. The name of the school, location, number of girls and boys etc. in a database. Fortunately, the data was clean and properly stored in a PostgreSQL database with PostGIS extensions. Most of my task was to modify the API to throw GeoJSON to the client using the ST_AsGeoJSON function and export the data.