I have an N locations in (longitude, latitude) and given the demand for water for these locations from 2010 to 2020 according to demographical changes and I need to calculate the demand for 2021
data are like
indexof_location, xcor,ycor,2010,2011,12,13,14,15,16,17,18,19,20
we have 5000 location coordinate that's mean we have 5000 rows of this data now I need to calculate the demand for water for these locations in 2021 and 2022
Now I am confused: do I have to make a 5000 prediction model for this 5000 location or what to do because the rate of increasing water for different locations can be different.