Utilize MySQL Data for GIS iOS App in Swift
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
27 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Utilize MySQL Data for GIS iOS App in Swift to your Wishlist.

Add to Wishlist

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!
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
27 students enrolled
Created by Alfred Lam
Last updated 1/2017
English
Current price: $10 Original price: $40 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 17 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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;
View Curriculum
Requirements
  • 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);
Description

“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 is the target audience?
  • GIS users;
  • Students;
  • Developers;
  • Entrepreneurs;
  • Anyone who are interested in making GIS maps for iOS apps;
Curriculum For This Course
Expand All 20 Lectures Collapse All 20 Lectures 01:09:19
+
Prepare MySQL Database and Table Data
6 Lectures 14:50

This is the course introduction.

Preview 01:45

This lecture demonstrates how to create a MySQL database.


Create MySQL Database
02:15

This lecture demonstrates how to create a MySQL database table.
Preview 02:09

This lecture demonstrates how to input data to a MySQL database table.
Insert Table Data
03:05

This lecture demonstrates how to modify a php template in order to display the MySQL data on web.

Edit PHP Template
03:38

This lecture demonstrates how to upload your php file to your server and display the php generated results on web.

Display Data on Web
01:58
+
Display Data on iOS App Table
7 Lectures 25:36

This lecture demonstrates how to create an xcode demo project in swift.

Preview 01:56

This lecture covers the process of adding ArcGIS SDK to the project and making App Security Transport Setting.

Add ArcGIS SDK in CocoaPods
04:32

This lecture covers the process of adding a table view controller to the project.

Add a TableView Controller
05:11

This lecture covers the process of creating a downloadContents function to configure URLSession and perform the download task.
Download Url Contents of MySQL Database
04:44

This lecture covers the process of converting the downloaded data into a foundation NSArray.
Conduct Data Conversion
02:46

This lecture covers the process of populating converted data to the table view table.
Populate Data to Table
03:55

This lecture covers the process of adjusting the table view table style.

Adjust Table Style
02:32
+
Display Data on iOS App Map
7 Lectures 28:53

This lecture covers the process of adding a new view controller for map to the scene, and create a UIViewController subclass MapVC to be associated with the map view controller.

Preview 05:28

This lecture covers the process of adding a segue connection between the table view controller and the map view controller.

Add a Segue Connection
02:51

This lecture covers the process of passing selected data from the table view controller to the map view controller.
Pass Selected Data
04:12

This lecture covers the process of converting selected data geographic coordinate system from WGS84 to WebMercator.
Convert Coordinate System
04:43

This lecture covers the process of displaying selected location on map.

Display Selected Location on Map
03:53

This lecture covers the process of adopting ArcGIS callout delegate.

Adopt Callout Delegate
04:29

This lecture covers the process of adding attributes information to the callout.
Set Callout Attributes
03:17
About the Instructor
Alfred Lam
4.2 Average rating
256 Reviews
8,210 Students
13 Courses
GIS Developer

“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.