Planning and managing the movement of people and goods is a demanding business operation. Whether applied to public transit, private automotive travel, or logistics of supply chains, geospatial analysis optimizes routing, conserves resources (time, fuel, package handling), improves cost effectiveness, or identifies new opportunities to expand business and regional growth.
In this lesson, we will learn how large transportation operators such as UPS use GIS and mobile networking to drive efficiencies into their massive fleets of local delivery trucks. Then we will simulate similar operations with a local business that is ready to expand but must make critical transportation decisions that will affect its growth and profitability. Fortunately, as we will discover, there are GIS tools that can model alternative transportation schemes, and with methodical analysis provide the insights business managers need to make optimal decisions.
Global commerce introduced efficiencies into large-scale logistics and led to standardized protocols of electronics, transportation signage, shipping container dimensions, metal fabrication strengths, and classifications of business. To grasp the potential applications of location intelligence with new technologies and standards, it is important for us to examine business sectors and topics such as:
At the successful completion of Lesson 7, you should be able to:
Lesson 7 will take us one week to complete. There are a number of required activities in this lesson listed below. For assignment details, refer to the lesson page noted.
Note: Please refer to the Calendar in Canvas for specific time frames and due dates.
7.1 Sectors of an Economy | ||
---|---|---|
Requirements | Details | Access / Directions |
Read |
Read the course content. |
Use the Lessons menu or the links below to continue moving through the lesson material. |
Murphy, Geography: Why It Matters, Chapter 5 Why We All Need Geography (pp.110-125) | The Geography: Why it Matters reading is from the required textbook for this course. | |
Deliverable | No Deliverable for 7.1 | N/A |
7.2 Introduction to Transportation Sector: Routing, Scheduling and Telematics | ||
---|---|---|
Requirements | Details | Access / Directions |
Do/Read | Read the course content. | Use the Lessons menu or the links below to continue moving through the lesson material. |
Watch video/Read articles on routing, scheduling, telematics. | Video and readings are provided in the course content. | |
Deliverable | Reply to at least one question, due Tuesday. | Post in Canvas to the Lesson 7.2 - Transportation Sector forum. |
7.3 Case Study in Routing/Scheduling | ||
---|---|---|
Requirements | Details | Access / Directions |
Read | Read the course content. | Use the Lessons menu or the links below to continue moving through the lesson material. |
Do | Case Study in Routing/Scheduling, “Delivering the Goods” and “Growing Pains”. | Directions are provided in the course text. |
Deliverable | Comment/screen shots, due Tuesday. | Post comment in Canvas to the Lesson 7.3 - Case Study: Transportation & Routing forum. |
7.4 Additional Sectors | ||
---|---|---|
Requirements | Details | Access / Directions |
Read | Read the course content. | Use the Lessons menu or the links below to continue moving through the lesson material. |
Skim | Links to content for 4 additional sectors of an economy. | Links are provided in the course text. |
Deliverable | Quiz 3: Sector Applications in Location Intelligence due Tuesday. |
Registered students can access the quiz in Canvas in the Lesson 7 module. |
7.5 Continue Working on Your Term Project | ||
---|---|---|
Requirements | Details | Access / Directions |
Read | Read the course content. | Use the Lessons menu or the links below to continue moving through the lesson material. |
Do | Continue gathering data, making maps/reports, and preparing for your presentation. | Manage your time wisely. |
Deliverable | No Deliverable for 7.5 | N/A |
The geo-advantages which Ryerson and Aronoff describe in Why ‘Where’ Matters vary across sectors of an economy. Industries are the production of goods or services that contribute to a nation’s gross domestic product (GDP). Standard classification systems ensure clarity in describing industries and communicating the purpose, products, and sector of a business. There are differences in US and global classifications; but most share similar major sectors. NAICS was discussed in Lesson 4, matching the industry sectors published by the Bureau of Labor Statistics, U.S. Department of Labor [1].
The most general description of industry is into primary, secondary, and tertiary:
Financial Markets use the Global Industry Classification Standard (GICS) [2], developed by MSCI & Standard and Poor’s:
The Bureau of Labor Statistics organizes industry sectors into broad classes (Table 6.1):
Industry Sector | Employment | Change | Percent distribution | Compound annual rate of change | ||||||
---|---|---|---|---|---|---|---|---|---|---|
2006 | 2016 | 2026 | 2006-16 | 2016-26 | 2006 | 2016 | 2026 | 2006-16 | 2016-26 | |
Total(1) | 144,047.0 | 150,539.9 | 160,328.8 | 6,492.9 | 9,788.9 | 100.0 | 100.0 | 100.0 | 0.4 | 0.6 |
Nonagriculture wage and salary(2) | 132,462.2 | 139,811.5 | 149,131.6 | 7,349.3 | 9,320.1 | 92.0 | 92.9 | 93.0 | 0.5 | 0.6 |
Goods-producing, excluding agriculture | 21,815.3 | 19,170.5 | 19,227.0 | -2,644.8 | 56.5 | 15.1 | 12.7 | 12.0 | -1.3 | 0.0 |
|
523.2 | 843.8 | 924.0 | 320.6 | 80.2 | 0.4 | 0.6 | 0.6 | 4.9 | 0.9 |
|
6,976.2 | 6,138.4 | 6,928.8 | -837.8 | 790.4 | 4.8 | 4.1 | 4.3 | -1.3 | 1.2 |
|
14,315.9 | 12,188.3 | 11,374.2 | -2,127.6 | -814.1 | 9.9 | 8.1 | 7.1 | -1.6 | -0.7 |
Services-providing | 110,646.9 | 120,641.0 | 129,904.6 | 9,994.1 | 9,263.6 | 76.8 | 80.1 | 81.0 | 0.9 | 0.7 |
|
563.8 | 553.0 | 505.1 | -10.8 | -47.9 | 0.4 | 0.4 | 0.3 | -0.2 | -0.9 |
|
5,663.0 | 5,826.0 | 6,151.4 | 163.0 | 325.4 | 3.9 | 3.9 | 3.8 | 0.3 | 0.5 |
|
15,058.2 | 15,364.5 | 16,129.1 | 306.3 | 764.6 | 10.5 | 10.2 | 10.1 | 0.2 | 0.5 |
|
4,248.6 | 4,640.3 | 4,776.9 | 391.7 | 136.6 | 2.9 | 3.1 | 3.0 | 0.9 | 0.3 |
|
3,118.3 | 2,739.7 | 2,712.6 | -378.6 | -27.1 | 2.2 | 1.8 | 1.7 | -1.3 | -0.1 |
|
8,105.1 | 7,979.5 | 8,486.7 | -125.6 | 507.2 | 5.6 | 5.3 | 5.3 | -0.2 | 0.6 |
|
16,394.9 | 19,096.2 | 20,985.5 | 2,701.3 | 1,889.3 | 11.4 | 12.7 | 13.1 | 1.5 | 0.9 |
|
2,762.5 | 3,417.4 | 3,756.1 | 654.9 | 338.7 | 1.9 | 2.3 | 2.3 | 2.2 | 0.9 |
|
14,429.8 | 18,057.4 | 21,852.2 | 3,627.6 | 3,794.8 | 10.0 | 12.0 | 13.6 | 2.3 | 1.9 |
|
12,493.1 | 14,710.0 | 15,651.2 | 2,216.9 | 941.2 | 8.7 | 9.8 | 9.8 | 1.6 | 0.6 |
|
6,188.3 | 6,394.0 | 6,662.0 | 205.7 | 268.0 | 4.3 | 4.2 | 4.2 | 0.3 | 0.4 |
|
2,730.0 | 2,729.0 | 2,345.6 | -1.0 | -383.4 | 1.9 | 1.8 | 1.5 | 0.0 | -1.5 |
|
18,891.3 | 19,134.0 | 19,890.1 | 242.7 | 756.1 | 13.1 | 12.7 | 12.4 | 0.1 | 0.4 |
Agriculture, forestry, fishing, and hunting(3) | 2,111.3 | 2,138.3 | 2,027.7 | 26.9 | -110.5 | 1.5 | 1.4 | 1.3 | 0.1 | -0.5 |
|
1,149.0 | 1,384.0 | 1,307.3 | 235.0 | -76.7 | 0.8 | 0.9 | 0.8 | 1.9 | -0.6 |
|
962.3 | 754.3 | 720.4 | -208.1 | -33.8 | 0.7 | 0.5 | 0.4 | -2.4 | -0.5 |
Nonagricultural self-employed workers | 9,473.6 | 8,590.2 | 9,169.5 | -883.4 | 579.3 | 6.6 | 5.7 | 5.7 | -1.0 | 0.7 |
Footnotes:
|
||||||||||
Source: Bureau of Labor Statistics, 2018. Employment by major industry sector. [3] |
Similar classification schemes assist in standardizing the descriptions of global commerce.
In the very last statement (in the Geospatial Revolutions video), the UPS manager describes the company as one that is “an information company that just happens to own trucks” rather than a trucking company that uses information.
Post a comment in Canvas to the Lesson 7.2 - Transportation Sector forum.
Due Tuesday 11:59 pm (Eastern Time).
Check the Calendar in Canvas for specific time frames and due dates.
Glossary of Transportation and Logistics Terms
If you are not familiar with logistics, supply chain, or transportation terminology, a quick internet search of federal or state Department of Transportation sites provides definitions and context.
Just-in-Time supply chains rely on a system where components or assembled products must be delivered to a destination at the exact time needed. The container or vehicle transporting the goods is the movable warehouse.
Route is the manner or track that a shipment moves; including the carriers handling it and the points where carriers transfer responsibility for delivering the goods.
Routing or route planning is an optimized delivery plan to coordinate multiple destinations, products, and customers. The process calculates the most cost-effective geographic routes for delivering goods to multiple stops (nodes) by minimizing the distance and/or time elapsed. Routing maps are provided to drivers in electronic, audible, and dynamic nagivation systems with options of integrated GPS, fuel efficiency measurements, and traffic analysis.
Supply chains are the logistical management system which integrates a sequence of activities; starting with delivery of raw materials to the manufacturer along a system of nodes and chains to delivery of the finished product to a customer.
Telematics are networked electronic sensors and component computers which are integrated in an information technology system to transmit real-time data. Telematics connect vehicles on the move, road safety systems, logistics networs for asset management, electical engineering, and company computer enterprise systems. Modern technologies create the networked environment using global satellite navigation systems (GPS, GNSS, GLONASS), cellular and wireless data transmission, IoT, and intelligent vehicle technologies.
You have been hired as a consultant to help "Sweet Nothin's Tasty Muffins" to understand their delivery needs and suggest a solution for their business. Please review the Scenario below and identify the following:
Your challenge is to identify the best and lowest cost solution for Sweet Nothin's Tasty Muffins. There is a rumor that they may be acquired by a very large bakery and will need a full time consultant to help manage their growth. In some sense, this is a full-time job opportunity.
The bakery, "Sweet Nothin's Tasty Muffins," (located at 100 West College Ave, State College, PA, 16801) has built a good reputation over the last two years for high quality baked goods. The business has grown from delivery of muffins out of your home kitchen to the great downtown State College bakery location.
Recently, Sweet Nothin's been contacted by Starbucks' district manager for the Centre region and a couple of additional local coffee houses in nearby towns to provide all of their muffins, scones, and coffee cakes. This opportunity could provide a chance for real growth—Sweet Nothin's knows their baking staff can handle the increased demand, but they need to ascertain whether you can handle the delivery logistics associated with this sudden growth.
Currently, they deliver all of the goods to the handful of shops they do business with. They know they are going to have to hire drivers and secure delivery vehicles but they are not sure if they need 1, 2, or 3 drivers to handle the increased business. Their good friend, a local florist, tells them he uses a routing application to help with planning his deliveries—they want to try a software package to see if it will help with their dilemma. Starbucks and the other potential customers would like to make the switch to Sweet Nothin's baked goods soon, so they had better get started planning!
At least two of their bakers, Barb and Johan, are interested in picking up some additional hours, and, lucky Sweet Nothin's, they both have minivans with roomy cargo areas! Until Sweet Nothin's is reaping the rewards of the continuous increased business, they decide Barb and Johan are the perfect solution to their near-term plans.
In addition to your own assessment of the situation and conversations with the coffee shop managers, the following are guidelines for solving their delivery dilemma:
Step 1. "Drivers" You will need to create a driver record for Barb and one for Johan.
Make sure you include:
Step 2. "Add Orders" listing all of the addresses of Sweet Nothin's potential customers.
Note: You may find problems with geocoding, based upon the data you got from your customers. (HINT: The airport is in the 16823 ZIP code. And while the Starbucks on N. Atherton has a mailing address in State College, it is technically located in Park Forest Village, PA.) You need to be able to correct addresses and geocoding when update your orders.
Also, you will need to provide the ability to adjust the orders to meet any special customer requirements.
Step 3. "Plan Optimal Routes" Once you've set all of the driver and order criteria to meet the guidelines, you can plan your routes! You may find it necessary to adjust certain elements to develop a desirable routing plan—remember, Sweet Nothin's is counting on you to spend their dollars wisely to efficiently plan their routing. (Hence, you may find it necessary to adjust your or your customers' expectations.)
Step 4. Once you have a route plan with which you're comfortable, save this route plan so you can return to it later.
Now, with this route plan established, move on to part 2:
Congratulations—Sweet Nothin's Tasty Muffins continues to grow and experience success! But with all growth comes growing pains—consider variations in this section (Part 2) on your current routing solution for Sweet Nothin's.
Perhaps Sweet Nothin's should call their business Sweet Nothin's Tasty Muffins and Such? Starbucks has asked them to supply ALL of its local baked goods. It's time to revisit your routing solution—you're going to need to allocate their drivers differently to accommodate the growth at Starbucks.
Are you able to do the following with one solution and not another?
Step 1. Open your saved routing plan.
Step 2. Increase the "Load Units" for the three Starbucks locations from "1" to "3" to accommodate space in the vehicle for the additional delivery goods.
Step 3. Better increase the "Service Time" too—it won't take three times as much to unload, but perhaps you need 15-20 minutes at each location?
Step 4. Barb really prefers to drive in and near State College (where all three Starbucks are located)—assign Barb to the Starbucks locations.
Step 5. How do these changes affect your routing solution? What other accommodations will you need to make?
Post a comment in Canvas to the Lesson 7.3 - Case Study: Transportation & Routing forum including:
Due Tuesday 11:59 pm (Eastern Time)
Check the Calendar in Canvas for specific time frames and due dates.
Skim the following material about Location Intelligence applications. While reading, think about the applications and the possibilities for other sectors.
Breading, Mark. 2018. The Most Important (and Overlooked) Tech. Location Intelligence Archives – Insurance Thought Leadership [18]. Blog (web). 24 Jul 2018.
Insurers should consider an enterprise location strategy which improves the use of GIS to store georeferenced demographic and connected sensors data, new spatial technologies for indoor and 3D mapping, and open platforms to gain improvements through collaboration. The data scientist role is emerging in insurance with significant access to open source and third-party data on weather events and forecasts, geographic location attributes, and consumer behavior.
Murray, Peter. 2018. Meet the growing demand for senior care facilities with a modern site planning approach [19]. CARTO. Blog. 13 Jun 2018.
Healthcare site planning now considers population behavioral patterns and human geography. The author indicates a trend where more seniors are moving to cities and metro areas to retire close to adult children. Location intelligence provides decision makers criteria, optimal sites, and recommendations to locate new healthcare and assisted living centers to meet future senior needs.
Voorhees, John. 2018. Secrets to Successful Branch Distribution [20]. Peak Performance consulting Group. 23 Aug 2018. Webinar.
Banks consider both location and site to grow and/or consolidate their branch banking operations. Locations and trade areas optimize where people shop, live, and commute; sites attract customers and align with local businesses. The financial intuition which creates the most convenient network will gain a greater share of customers and deposits.
Denchak, Melissa (2018). Flint Water Crisis: Everything You Need to Know. Natural Resources Defense Council (NRDC). 8 Nov 2018. https://www.nrdc.org/stories/flint-water-crisis-everything-you-need-know [21]
U.S. Geological Survey (USGS). (2020). New Report Presents a Framework for Assessing the Sustainability of Monitored Natural Attenuation. USGS: Environmental Health – Toxic Substances Hydrology Program. Online https://www.usgs.gov/publications/usgs-toxic-substances-hydrology-program-2010 [22]
Wiitala, S.W., Vanlier, K.E., & Krieger, R.A. (1963). Water Resources of the Flint Area Michigan. Department of the Interior, USGS: Geological Survey Water-Supply Paper 1499-E. The preservation of natural resources is not just a 21st-Century concern.
The U.S. Geological Survey (USGS) monitors water quality in surface waters and groundwater aquifers to study the availability, use, and quality of water for residential, business, industry, agriculture, energy production, and recreation access. Water is critical to balancing sustainable development and societal-environmental interdependence. Businesses and communities share a responsibility for the appropriate use of natural resources—to include water—without damaging the environment, conducting illegal activities, or drawing an unfair share of resources from society and nature. The Flint River crisis in Flint, Michigan highlights a recent example of harmful lead contamination in the public water sources impacting the health of citizens relying on their community.
Murphy reinforces tracing the connections of human-environment dynamics and understanding that what happens in one place affects or is affected by activities elsewhere (2018: pp.102-103). Geospatial analysis is central to modeling and confronting environmental sustainabilty challenges.
"Consider the local organic foods movement that has taken root in the United States and Europe over the past couple of decades. The movement was driven by a desire to promote sustainable local farms, undermine the power of corporate agriculture, and reduce the environmental impacts of the long-distance transport of consumables."
Emison, Bill. 2018. myWorld: A radical approach to location intelligence for non-GIS users in utilities [23]. SPAR3D. 1 Nov 2018.
The Utility sector includes facilities management, power generation and distribution, utility companies, and municipalities controlling infrastructure operations. The entire concept of Smart Cities highlights the connection of utilities, sensors, location intelligence, mobile communications, enterprise and cloud computing, and the ability for field workers to access accurate geospatial data.
There are no deliverables for 7.4 Additional Sectors, however, you must complete Quiz 3 as part of this weeks assignments. (See Deliverable below.)
Before moving on to this weeks information about the term project, please remember to return to Lesson 7 module in Canvas to take the Quiz 3: Sectors and Location Intelligence Companies/Platforms
Due Tuesday night 11:59 pm (Eastern Time). Check the calendar in Canvas for specific time frames and due dates.
Similar to Week 5, there is no specific deliverable required this week for your term project, but you really should be aiming to make some progress on your project this week!
Don't forget to allocate time this week to work on data gathering/research for your term project.
For the remainder of the term, if you have questions about your term project from which your classmates would benefit, please use the Term Project Discussion Forum - Questions, Answers & Advice. We will provide a link to the forum in the rest of the modules in Canvas. We will keep a running thread of project related questions, answers, and advice there through the rest of the course.
There are no deliverables for your term project this week.
Links
[1] https://www.bls.gov/iag/tgs/iag_index_alpha.htm
[2] https://www.msci.com/gics
[3] https://www.bls.gov/news.release/ecopro.t02.htm
[4] https://www.stat.go.jp/english/data/e-census/2016/industry.html
[5] https://unstats.un.org/unsd/publication/seriesM/seriesm_4rev4e.pdf
[6] https://www.youtube.com/embed/nMrhuKoE3cI?rel=0
[7] https://psu.instructure.com/files/131781692/download?download_frd=1
[8] https://psu.instructure.com/files/131781685/download?download_frd=1
[9] https://www.directionsmag.com/article/2040
[10] https://www.directionsmag.com/article/3267
[11] http://www.wastewaterpr.com/releases/view/1985/Roadnet-Technologies-Introduces-Geotuning-Logistics-Tool
[12] http://customerthink.com/the-real-key-to-retail-growth-is-last-mile-delivery/
[13] https://www.routexl.nl/?lang=en
[14] https://www.pcmiler.com/
[15] https://www.myrouteonline.com/customers/deliveries-and-distribution-customers
[16] https://www.route4me.com/
[17] https://www.mapbox.com/industries/logistics/
[18] http://insurancethoughtleadership.com/the-most-important-and-overlooked-tech/
[19] https://carto.com/blog/site-planning-for-nursing-homes/
[20] https://ppcgroup.com/resources/insights-and-downloads.html?task=routedownload&tmpl=component&id=1
[21] https://www.nrdc.org/stories/flint-water-crisis-everything-you-need-know
[22] https://www.usgs.gov/publications/usgs-toxic-substances-hydrology-program-2010
[23] https://www.spar3d.com/blogs/the-business-of-geospatial/myworld-a-radical-approach-to-location-intelligence-for-non-gis-users-in-utilities/