In urban areas where multiple urban educational facilities (UEFs) are located in close proximity and dismiss students simultaneously, uncoordinated vehicle pickups often lead to localized congestion and prolonged idling. This study addresses this problem by proposing a four-phase pickup scheduling algorithm that enables spatio-temporal coordination across neighboring UEFs. The algorithm consists of four phases: (1) identifying related UEFs based on spatial proximity, (2) triggering batch scheduling when incoming requests reach a calculated threshold, (3) prioritizing requests using different strategies, and (4) assigning pickup intervals under travel-time feasibility and street capacity constraints. The approach was evaluated under various spatial and operational settings and compared with a non-scheduling baseline. Experimental results demonstrated that the proposed scheduling method reduces the variability of parent waiting times, the maximum parent waiting time, and overall makespan. These results highlight the effectiveness of coordinated scheduling across neighboring UEFs in improving pickup efficiency and alleviating localized congestion in urban school neighborhoods, thereby contributing to sustainable cities and communities.
Citation: Yuan-Ko Huang. Pickup scheduling algorithms with spatio-temporal coordination for urban educational facilities[J]. Journal of Industrial and Management Optimization, 2026, 22(6): 2726-2754. doi: 10.3934/jimo.2026100
In urban areas where multiple urban educational facilities (UEFs) are located in close proximity and dismiss students simultaneously, uncoordinated vehicle pickups often lead to localized congestion and prolonged idling. This study addresses this problem by proposing a four-phase pickup scheduling algorithm that enables spatio-temporal coordination across neighboring UEFs. The algorithm consists of four phases: (1) identifying related UEFs based on spatial proximity, (2) triggering batch scheduling when incoming requests reach a calculated threshold, (3) prioritizing requests using different strategies, and (4) assigning pickup intervals under travel-time feasibility and street capacity constraints. The approach was evaluated under various spatial and operational settings and compared with a non-scheduling baseline. Experimental results demonstrated that the proposed scheduling method reduces the variability of parent waiting times, the maximum parent waiting time, and overall makespan. These results highlight the effectiveness of coordinated scheduling across neighboring UEFs in improving pickup efficiency and alleviating localized congestion in urban school neighborhoods, thereby contributing to sustainable cities and communities.
| [1] | PikMyKid, Pikmykid [mobile app], App Store, 2025. Available from: https://apps.apple.com/us/app/pikmykid-parent/id1559538995. Accessed: 2025-07-21. |
| [2] | CurbSmart, Curbsmart [mobile app], App Store, 2025. Available from: https://apps.apple.com/tw/app/curbsmart/id1235680339. Accessed: 2025-07-21. |
| [3] | PickMeUp, Pickmeup [mobile app], App Store, 2020. Available from: https://apps.apple.com/tw/app/pick-me-up/id1447715891?l = en-GB. Accessed: 2025-07-21. |
| [4] | M. F. Mokbel, X. Xiong, W. G. Aref, Sina: Scalable incremental processing of continuous queries in spatio-temporal databases, SIGMOD '04: Proceedings of the 2004 ACM SIGMOD international conference on Management of data, (2004), 623–634. https://doi.org/10.1145/1007568.1007638 |
| [5] | Y. K. Huang, L. F. Lin, Continuous within query in road networks, 2011 7th International Wireless Communications and Mobile Computing Conference, Istanbul, Turkey, (2011), 1176–1181. https://doi.org/10.1109/IWCMC.2011.5982707 |
| [6] | A. D. Zhu, H. Ma, X. Xiao, S. Luo, Y. Tang, S. Zhou, Shortest path and distance queries on road networks: towards bridging theory and practice, SIGMOD '13: Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data, (2013), 857–868. https://doi.org/10.1145/2463676.2465277 |
| [7] |
A. Michalopoulos, D. Tsitsigkos, P. Bouros, N. Mamoulis, M. Terrovitis, Efficient distance queries on non-point data, ACM Trans. Spatial Algorithms Syst., 11 (2024), 1–37. https://doi.org/10.1145/3698194 doi: 10.1145/3698194
|
| [8] | H. Samet, Foundations of Multidimensional and Metric Data Structures, Morgan Kaufmann, San Francisco, CA, 2006. |
| [9] |
D. Taniar, W. Rahayu, A taxonomy for region queries in spatial databases, J. Comput. Syst. Sci., 81 (2015), 1508–1531. https://doi.org/10.1016/j.jcss.2014.12.025 doi: 10.1016/j.jcss.2014.12.025
|
| [10] |
Y. Tao, M. L. Yiu, N. Mamoulis, Reverse nearest neighbor search in metric spaces, IEEE Trans. Knowl. Data Eng., 18 (2006), 1239–1252. https://doi.org/10.1109/TKDE.2006.148 doi: 10.1109/TKDE.2006.148
|
| [11] |
W. Li, M. Cai, M. Gao, D. Wen, L. Qin, W. Wang, Expanding reverse nearest neighbors, Proceedings of the VLDB Endowment, 17 (2023), 630–642. https://doi.org/10.14778/3636218.3636220 doi: 10.14778/3636218.3636220
|
| [12] |
D. Papadias, Y. Tao, K. Mouratidis, C. K. Hui, Aggregate nearest neighbor queries in spatial databases, ACM Trans. Database Syst., 30 (2005), 529–576. https://doi.org/10.1145/1071610.1071616 doi: 10.1145/1071610.1071616
|
| [13] | C. F. Costa, J. Machado, J. A. F. Macêdo, M. A. Nascimento, Aggregate k-nearest neighbors queries in time-dependent road networks, in International Conference on Advances in Geographic Information Systems, 2015. https://doi.org/10.1145/2834126.2834129 |
| [14] |
Y. K. Huang, Location-based aggregate queries for heterogeneous neighboring objects, IEEE Access, 5 (2017), 4887–4900. https://doi.org/10.1109/ACCESS.2017.2688472 doi: 10.1109/ACCESS.2017.2688472
|
| [15] | I. De Felipe, V. Hristidis, N. Rishe, Keyword search on spatial databases, in 24th IEEE International Conference on Data Engineering, 2008,656–665. https://doi.org/10.1109/ICDE.2008.4497474 |
| [16] |
X. Cao, G. Cong, C. S. Jensen, Retrieving top-k prestige-based relevant spatial web objects, Proceedings of the VLDB Endowment, 3 (2010), 373–384. https://doi.org/10.14778/1920841.1920891 doi: 10.14778/1920841.1920891
|
| [17] | H. B. Ekomie, K. Yao, J. Li, G. Li, Y. Li, Group top-k spatial keyword query processing in road networks, in Database and Expert Systems Applications, 2017,395–408. https://doi.org/10.1007/978-3-319-64468-4_30 |
| [18] | X. Cao, G. Cong, C. S. Jensen, B. C. Ooi, Collective spatial keyword querying, in ACM SIGMOD Conference, 2011,373–384. https://doi.org/10.1145/1989323.1989363 |
| [19] |
X. Cao, G. Cong, T. Guo, C. S. Jensen, B. C. Ooi, Efficient processing of spatial group keyword queries, ACM Trans. Database Syst., 40 (2015), 1–48. https://doi.org/10.1145/2772600 doi: 10.1145/2772600
|
| [20] |
S. Su, S. Zhao, X. Cheng, R. Bi, X. Cao, J. Wang, Group-based collective keyword querying in road networks, Inf. Process. Lett., 118 (2017), 83–90. https://doi.org/10.1016/j.ipl.2016.10.008 doi: 10.1016/j.ipl.2016.10.008
|
| [21] | D. V. Kalashnikov, S. Prabhakar, S. Hambrusch, W. G. Aref, Efficient evaluation of continuous range queries on moving objects, in Database and Expert Systems Applications, 2002,731–740. https://doi.org/10.1007/3-540-46146-9_72 |
| [22] |
Y. K. Huang, L. F. Lin, Efficient processing of continuous min–max distance bounded query with updates in road networks, Inf. Sci., 278 (2014), 187–205. https://doi.org/10.1016/j.ins.2014.03.040 doi: 10.1016/j.ins.2014.03.040
|
| [23] |
M. Orabi, Z. Al Aghbari, I. Kamel, Skyeye: continuous processing of moving spatial-keyword queries over moving objects, GeoInformatica, 28 (2024), 559–603. https://doi.org/10.1007/s10707-024-00512-0 doi: 10.1007/s10707-024-00512-0
|
| [24] |
Z. Yu, X. Yu, T. Zhou, Y. Chen, Y. Liu, B. Li, Odin: Object density aware index for cknn queries over moving objects on road networks, IEEE Trans. Knowl. Data Eng., 36 (2024), 6758–6771. https://doi.org/10.1109/TKDE.2023.3344662 doi: 10.1109/TKDE.2023.3344662
|
| [25] |
Y. K. Huang, C. Lee, Efficient evaluation of continuous spatio-temporal queries on moving objects with uncertain velocity, GeoInformatica, 14 (2010), 163–200. https://doi.org/10.1007/s10707-009-0081-8 doi: 10.1007/s10707-009-0081-8
|
| [26] | K. Zheng, G. Trajcevski, X. Zhou, P. Scheuermann, Probabilistic range queries for uncertain trajectories on road networks, in International Conference on Extending Database Technology, 2011,283–294. https://doi.org/10.1145/1951365.1951400 |
| [27] |
J. Bernad, C. Bobed, E. Mena, Uncertain probabilistic range queries on multidimensional data, Inf. Sci., 537 (2020), 334–367. https://doi.org/10.1016/j.ins.2020.05.068 doi: 10.1016/j.ins.2020.05.068
|
| [28] | A. Züfle, Uncertain spatial data management: An overview, in Handbook of Big Geospatial Data, eds. M. Werner and Y. Y. Chiang, 2021,355–378. https://doi.org/10.1007/978-3-030-55462-0_14 |
| [29] | F. Lettich, S. Orlando, C. Silvestri, C. S. Jensen, Manycore processing of repeated range queries over massive moving objects observations, arXiv preprint arXiv: 1411.3212, 2022. https://doi.org/10.48550/arXiv.1411.3212 |
| [30] | H. Zhu, Z. Yu, Distributed processing of continuous range queries over moving objects, in Intelligent Computing, 2022,403–418. https://doi.org/10.1007/978-981-19-8915-5_35 |
| [31] |
A. Bhandari, P. Hamandawana, M. Attique, H. J. Cho, T. S. Chung, Parscl: A parallel and distributed framework to process all nearest neighbor queries on a road network, IEEE Access, 11 (2023), 94043–94055. https://doi.org/10.1109/ACCESS.2023.3308684 doi: 10.1109/ACCESS.2023.3308684
|
| [32] | A. Karabinos, P. Tampakis, C. Doukelis, A. Vlachou, Processing of spatial-keyword range queries in apache spark, in 11th ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data, 2023. https://doi.org/10.1145/3615833.3628592 |
| [33] |
M. M. Solomon, Algorithms for the vehicle routing and scheduling problems with time window constraints, Oper. Res., 35 (1987), 254–265. https://doi.org/10.1287/opre.35.2.254 doi: 10.1287/opre.35.2.254
|
| [34] |
J. Park, B. I. Kim, The school bus routing problem: A review, Eur. J. Oper. Res., 202 (2010), 311–319. https://doi.org/10.1016/j.ejor.2009.05.017 doi: 10.1016/j.ejor.2009.05.017
|
| [35] |
C. K. Y. Lin, A vehicle routing problem with pickup and delivery time windows, and coordination of transportable resources, Comput. Oper. Res., 38 (2011), 1596–1609. https://doi.org/10.1016/j.cor.2011.01.021 doi: 10.1016/j.cor.2011.01.021
|
| [36] |
M. Bögl, K. F. Doerner, S. N. Parragh, The school bus routing and scheduling problem with transfers, Networks, 65 (2015), 180–203. https://doi.org/10.1002/net.21589 doi: 10.1002/net.21589
|
| [37] |
X. Chen, Y. Kong, L. Dang, Y. Hou, X. Ye, Exact and metaheuristic approaches for a bi-objective school bus scheduling problem, PLOS ONE, 10 (2015), 1–20. https://doi.org/10.1371/journal.pone.0132600 doi: 10.1371/journal.pone.0132600
|
| [38] |
A. Shafahi, S. Aliari, A. Haghani, Balanced scheduling of school bus trips using a perfect matching heuristic, Transp. Res. Rec., 2672 (2018), 1–11. https://doi.org/10.1177/0361198118787803 doi: 10.1177/0361198118787803
|
| [39] |
L. Zeng, S. Chopra, K. Smilowitz, A bounded formulation for the school bus scheduling problem, Transp. Sci., 56 (2022), 1148–1164. https://doi.org/10.1287/trsc.2022.1130 doi: 10.1287/trsc.2022.1130
|
| [40] |
J. P. Orejuela Cabrera, M. A. Londoño, V. L. C. Pantoja, School bus routing problem considering affinity among children, Decis. Sci. Lett., 10 (2021), 535–548. https://doi.org/10.5267/j.dsl.2021.5.002 doi: 10.5267/j.dsl.2021.5.002
|
| [41] |
S. Ezquerro-Eguizábal, J. L. Moura-Berodia, A. Ibeas-Portilla, J. Benavente-Ponce, Optimization model for school transportation design based on economic and social efficiency, Transp. Policy, 67 (2018), 93–101. https://doi.org/10.1016/j.tranpol.2018.01.015 doi: 10.1016/j.tranpol.2018.01.015
|
| [42] |
M. Mateo-Doll, E. Aghezzaf, Optimizing extracurricular activities assignment and related logistical deployment cost between collaborating schools, Int. Trans. Oper. Res., 32 (2025), 745–768. https://doi.org/10.1111/itor.13458 doi: 10.1111/itor.13458
|
| [43] |
Y. Liu, H. Xu, X. Yu, J. Zhou, Heuristic feeder-bus operation strategy considering weather information: a chance-constrained model, Int. Trans. Oper. Res., 31 (2024), 2446–2471. https://doi.org/10.1111/itor.13211 doi: 10.1111/itor.13211
|
| [44] |
S. Sun, Z. Duan, Q. Xu, School bus routing problem in the stochastic and time-dependent transportation network, PLOS ONE, 13 (2018), 1–17. https://doi.org/10.1371/journal.pone.0202618 doi: 10.1371/journal.pone.0202618
|
| [45] |
Z. Wang, A. Haghani, Column generation-based stochastic school bell time and bus scheduling optimization, Eur. J. Oper. Res., 286 (2020), 1087–1102. https://doi.org/10.1016/j.ejor.2020.03.071 doi: 10.1016/j.ejor.2020.03.071
|
| [46] |
J. Díaz-Ramírez, C. M. Leal-Garza, C. Gómez-Acosta, A smart school routing and scheduling problem for the new normalcy, Comput. Ind. Eng., 166 (2022), 108101. https://doi.org/10.1016/j.cie.2022.108101 doi: 10.1016/j.cie.2022.108101
|
| [47] |
Z. Fu, J. Y. J. Chow, The pickup and delivery problem with synchronized en-route transfers for microtransit planning, Transp. Res. Part E: Log. Transp. Rev., 157 (2022), 102562. https://doi.org/10.1016/j.tre.2021.102562 doi: 10.1016/j.tre.2021.102562
|
| [48] |
Y. Wang, L. Ran, X. Guan, J. Fan, Y. Sun, H. Wang, Collaborative multicenter vehicle routing problem with time windows and mixed deliveries and pickups, Expert Syst. Appl., 197 (2022), 116690. https://doi.org/10.1016/j.eswa.2022.116690 doi: 10.1016/j.eswa.2022.116690
|
| [49] |
S. Effendy, R. H. C. Yap, Real-time passenger bus routing problems with preferences and tradeoffs, Ann. Math. Artif. Intell., 91 (2023), 287–307. https://doi.org/10.1007/s10472-022-09812-3 doi: 10.1007/s10472-022-09812-3
|
| [50] |
G. H. Wu, P. Pourhejazy, W. X. Li, T. H. Wu, A new dispatching mechanism for parallel-machine scheduling with different efficiencies and sequence-dependent setup times, Decis. Anal. J., 10 (2024), 100432. https://doi.org/10.1016/j.dajour.2024.100432 doi: 10.1016/j.dajour.2024.100432
|
| [51] |
C. Ferreira, G. Figueira, P. Amorim, Effective and interpretable dispatching rules for dynamic job shops via guided empirical learning, Omega, 111 (2022), 102643. https://doi.org/10.1016/j.omega.2022.102643 doi: 10.1016/j.omega.2022.102643
|
| [52] |
H. Xiong, H. Wang, S. Shi, K. Chen, Comparison study of dispatching rules and heuristics for online scheduling of single machine scheduling problem with predicted release time jobs, Expert Syst. Appl., 243 (2024), 122752. https://doi.org/10.1016/j.eswa.2023.122752 doi: 10.1016/j.eswa.2023.122752
|
| [53] |
D. Kasper, M. J. Land, R. H. Teunter, Towards system-state dispatching in high-variety manufacturing, Omega, 114 (2023), 102726. https://doi.org/10.1016/j.omega.2022.102726 doi: 10.1016/j.omega.2022.102726
|
| [54] |
M. Durasevic, F. J. Gil-Gala, D. Jakobovic, C. A. Coello Coello, Combining single-objective dispatching rules into multi-objective ensembles for the dynamic unrelated machines environment, Swarm and Evol. Comput., 80 (2023), 101318. https://doi.org/10.1016/j.swevo.2023.101318 doi: 10.1016/j.swevo.2023.101318
|
| [55] | KIDSDAY, Kidsday [mobile app], Android App. Available from: https://play.google.com/store/apps/details?id = com.kidsdayparents & hl = zh_TW. Accessed: 2025-07-21. |
| [56] | OpenStreetMap contributors, OpenStreetMap map at zoom 7, center 23.611,120.768. Available from: https://www.openstreetmap.org/#map = 7/23.611/120.768, 2025. Accessed: 2025-08-10. |
| [57] |
T. Brinkhoff, A framework for generating network-based moving objects, GeoInformatica, 6 (2002), 153–180. https://doi.org/10.1023/A:1015231126594 doi: 10.1023/A:1015231126594
|