Integration of large spatial databases

A core issue in the context of the Immediate Action Plan for Irrigated Agriculture in Brazil is to solve the problem of spatial compatibility between two different meshes of the Brazilian territory. The first mesh contains vector spatial data of the country microbasins. The second mesh contains raster spatial data related to the spatial delimitation of rural properties. The challenge in the integration of these spatial datasets is to allocate each rural property to a single microbasin, i.e., to assign to each rural property the microbasin of the largest area of spatial intersection. In this technical report, we describe two efficient solutions to this challenge: one based on microbasin coordinates extraction and another based on geometric data indexing. We show that both solutions nicely solve the problem, guaranteeing low execution time despite the volume and the heterogeneity of spatial data.