Daniel Loughran

GIS & Data Analyst   |   Greater Toronto Area

GIS & Data Analyst
Greater Toronto Area

Learn More

About Me

Skydiving

I was born and raised just outside of Liverpool, United Kingdom. In 2010, I moved to Toronto on a temporary work permit and spent 6 months exploring the city and meeting new people. I enjoyed Toronto so much that I wanted to make the move permanent, but not long after returning to the UK, I landed a job in the offshore oil and gas industry. As fate would have it, the rig that I was assigned to was due to sail to Canada for its next contract. With a new work visa in hand, I was fortunate enough to move back to Canada in July 2013. I obtained Permanent Residency in January 2016.

I have had a keen interest in GIS ever since my first introduction to the topic at Liverpool John Moores University, but my passion for maps goes back to childhood, when I would spend countless hours exploring a world atlas and the illuminated globe that was passed down from my older brother.

In February 2016, I enrolled in the Applied Digital Geography and GIS Certificate program at Ryerson University in Toronto. I was still working offshore as a Sr. Data Analyst, but despite really enjoying this role, the 3-week rotation schedule was less than ideal. I had the opportunity for a change in June 2017 when I accepted a 3-month internship as GIS Analyst at Targeo, a media marketing company in Brampton, Ontario. After incorporating as Loughran Mapping Solutions, I obtained valuable experience as a GIS Technician at Metrolinx working on numerous high-profile projects. Now I am at the Regional Municipality of York, and was fortunate enough to be a part of the team that won the 2020 Esri President's Award, their highest honour. Esri recognizes one organization each year for making data-informed decisions that impact the world in a positive way.

This website is designed to help showcase my abilities and understanding of GIS and cartography, while demonstrating some of my other skills. It provides a platform for peers, colleagues, and prospective employers to learn a little more about me, including my drive and motivation to learn new things. I update the website regularly.

In my spare time, I like to experiment with custom-made wall maps by using various vector tile basemaps. I plan to incorporate this work as a side project for my business in the near future.

Parallax Alternative

Resume

Education

Certificate, Applied Digital Geography and GIS

Ryerson University - Toronto, ON.

Bachelor of Science - Geoscience (Hons)

Liverpool John Moores University - Liverpool, UK.

Professional Experience

GIS Analyst, Contract (Nov 2020 - Present)

The Regional Municipality of York - Vaughan, ON.

Project Lead for Mapping, Spatial Analysis, and Internal Power BI Dashboards

  • Other tasks include refreshing public-facing Tableau dashboard, and performing additional data processing using FME

GIS Technologist, Contract (May 2019 - Nov 2020)

The Regional Municipality of York - Newmarket, ON.

Hired to support team in designing data visualizations, improving program planning and service delivery, advancing cartographic principles, and delivering training.

  • Utilized ArcGIS Python API to extract user and content data from the organizational ArcGIS Online, which was leveraged to build a dashboard of KPI’s to support the cleanup of ArcGIS Online content
  • Redeployed in April 2020 to assist the Region’s COVID-19 response

GIS Technician, Consultant (Feb 2018 - May 2019)

Metrolinx (Loughran Mapping Solutions) - Toronto, ON.

Brought on to assist team in designing, building, and testing organizational data model, while also helping to enable business users.

  • Designed and created web maps, apps, and dashboards
  • Automated complex tasks using ArcPy/Pandas; e.g. what previously took an employee 3 days/month to complete now takes <1 hour.
  • With concerns of slow server performance, created script to find content that wasn’t accessible in Portal but still hosted on the server.

GIS Analyst, Intern/Contract (Jun 2017 - Jan 2018)

Targeo, TC Transcontinental - Brampton, ON.

Joined the GIS marketing team initially on a summer internship, to assist on project to standardize database and associated spatial data.

  • Maintained spatial database following updates from distributors

Skills

  • ArcMap / ArcGIS Pro
  • ArcGIS Online / Portal
  • Microsoft Power BI / Tableau
  • FME
  • Python (inc. ArcPy/ArcGIS API)
  • SQL
  • HTML
  • CSS
  • JavaScript
  • Data formats including JSON, XML, KML, and GeoJSON
  • Web Mapping JavaScript API’s including Google, Bing, Leaflet, Esri, and Mapbox

Highlights

  • Designed and automated creation of York Region's COVID-19 public-facing hexagon map with over 1 million views
  • 2x public Web App's on York Region’s ArcGIS Online platform
  • Achieved top mark in the class in 4 of 6 courses of the GIS Certificate program

Community Involvement

  • Co-organizer/group leader of Toronto GoGeomatics Meetup since Feb 2018
  • Esri GIS Ambassador

Other Certifications

  • Esri: Do It Yourself Geo-Apps
  • Esri: Spatial Analysis
  • Esri: Earth Imagery at Work
  • Esri: Cartography
  • Driver’s License (Ontario) - Class G
  • Permanent Resident of Canada

Timeline


My Timeline

Education


Chang School Logo

After the winter 2018 semester, I graduated with a certificate in Applied Digital Geography and GIS from Ryerson University. The program consisted of six courses and was designed for professionals currently practising or seeking careers in digital geography or GIS.

The first four courses of the certificate were taken online using the distance option made available to Continuing Education students. The courses really helped to build upon the skills that I initially acquired at Liverpool John Moores University, while also introducing newer concepts and technologies. The final two courses were taken in-person on campus.

The table below displays my course selection and results:

Course Letter Grade Grade Point Average
Required Courses
Spatial Databases and Digital Cartography A+ 4.33
Digital Geography and Spatial Analysis A 4.00
Electives: Group A
Digital Geography Applications in Community & Social Services A+ 4.33
Electives: Group B
Customizing GIS Software: Applications Programming A 4.00
Web Mapping A+ 4.33
Advanced Course: First Level
Spatial Statistical Methods A+ 4.33

Portfolio


My Maps



Mapping API's


Google Maps API w/ KML - NFL Directions Tool

NFL Directions Tool

Mapbox API w/ JSON - TTC Subway Times

TTC Subway Times

Leaflet API - My Work Sites

Work Sites

Web Mapping


Esri ArcGIS Online - NFL Teams & Stadiums vs State Population, 2010


SQL


Code (SQLite)

Using SQLite, a relational database management system, it is possible to create, read, update, or delete data. The following example code is used to create two tables called 'NFL Teams' and 'NFL Stadiums'. Then using a select statement with a join clause, the two tables can be joined using a common attribute, which in this case is the 'NFL ID'.

This code can be tested at SQLFiddle. Below is a screenshot of the result:

SQLFiddle

Contact