Utilize MySQL Data for GIS iOS App in Swift

A bridge between your MySQL server and iPhone apps! Step by step to achieve your goal!
English [Auto]
Understand the workflow of utilizing MySQL data for usage of GIS iOS apps;
Create a database for MySQL;
Add a location table and input data for MySQL database;
Generate and display output on web with by editing a php template;
Add ArcGIS Runtime SDK for iOS to Xcode project in cocoapods;
Download php generated url contents to Xcode project;
Display MySQL database table data on iOS tableView;
Add a GIS basemap for iOS app;
Convert coordinates as per map geographic coordinate system;
Display selected location on map;
Add a callout and set callout attributes for map location;


  • No programming experience needed;
  • MySQL with web service are required;
  • Internet connection and a browser are required;
  • Hardware: An Intel-based Mac with OS Mountain Lion (OS X 10.8.4) or higher is required;
  • Some knowledge about Xcode, Swift, and CocoaPods are preferrable;
  • Software: XCode 8 or higher are preferrable (free download from Apple App store);


“The world we live is full of coordinates and I love it!" - Alfred Lam, the course instructor.

“The essence of creating a beautiful map is balance!" - Alfred Lam, the course instructor.

This GIS course is created to meet the needs of building iOS platform apps using MySQL server data in Swift. The code provided in this course are simple and easy understanding. The whole course is not long, it covers everything necessary to build a GIS iOS app utilizing MySQL data from scratch. The goal of this course is to provide an effective solution for students who would like to handle this coding skill with minimum time expentidure.

This is my first GIS course teaching how to use MySQL database data for GIS iOS applications. I created this course for I know there are many GIS users and mobile developers are interested in utilizing server data for their mobile map apps. However, solving this problem is either expensive or complicated. Here I want to give out a simple solution to bridge the gap. If you are an experienced programmer, you may find that there are other possible coding approaches as well.

Considering students are from all levels. I tried to demonstrate the workflow in this course step-by-step and to make the code simple, straightforward, and easy understanding. All the code are put to my lecture resources files in pdf format. The important thing is that you can repeat my experiment successfully, and you can achieve a higher goal by integrating the code into your own projects.

At the time of preparing this course, ESRI has just announced their new SDK version 100.0. However, I am using the SDK version: 10.2.5 for this course. The main reason is that the classes of the new version are different, therefore the code will be different for the new SDK version. If you are new to using GIS maps in mobile app development, you are encouraged to spend a bit of time to browse the ArcGIS SDK library. The ArcGIS Runtime SDK for iOS has been developed by ESRI, which is so far the biggest vendor of GIS systems and applications in the world.  

Time is precious for many app developers and programmers. This course was condensed with all necessary steps for building a GIS iOS app with working code. For those GIS users, students, iOS developers, and anyone who are interested in developing GIS mobile or web GIS apps with ArcGIS SDKs, please be aware of my other course announcements about Android, JavaScript, and iOS in the future.

Who this course is for:

  • GIS users;
  • Students;
  • Developers;
  • Entrepreneurs;
  • Anyone who are interested in making GIS maps for iOS apps;

Course content

1 section4 lectures9m total length
  • Introduction
  • Create MySQL Database
  • Create MySQL Database Table
  • Insert Table Data


GIS Developer
Alfred Lam
  • 4.2 Instructor Rating
  • 1,175 Reviews
  • 48,872 Students
  • 12 Courses

“The world we live is full of coordinates and I love it!" - Alfred Lam

“The essence of creating a beautiful map is balance!" - Alfred Lam

I am an enthusiastic GIS specialist and I have been using GIS for more than ten years. My previous position was a senior officer at a NGO maintaining geodatabase, doing field data collection, and perform GIS analysis with remote sensing, GIS, and GPS data for the whole organization. With the advent of mobile technology, I have been studying and working hard to code for iOS, Android, and JavaScript. I believe this is one of the most useful technologies that can help people in many aspects.

I am going to dedicate some of my time to be a GIS instrcutor here and teaching is fun. It is also great to let many mobile and web developers to know and use ESRI technology which is so far the best and the most comprehensive GIS system. The part I am giving lectures is even only a very small fraction of the whole ArcGIS system.Please find all my courses and special offers at my profile website. 

Coding is boundless. Like many other teachers, I’d like to share my knowledge and experiences here. As students are from all levels, I try not to make the code complicated. Maybe sometimes my pace is a bit slower, but I tried to make the code effective in a straightforward and simplest way. So that students can understand the mechanism of the code easily.