Script para convertir una tabla de XLSX a GeoPackage

guion.bat

@echo off 

REM "Script para convertir una tabla de XLSX a GeoPackage"
REM "Samuel Mesa"

REM set GDALBIN_FOLDER=C:\tmp\bin\
set XLSX_FOLDER=C:\tmp\xlsx\

REM set PATH=%PATH%;%GDALBIN_FOLDER%
REM set PROJ_LIB=%GDALBIN_FOLDER%proj6\share\
REM set GDAL_DATA=%GDALBIN_FOLDER%gdal-data
REM set GDAL_DRIVER_PATH=%GDALBIN_FOLDER%gdal\plugins


For /R %XLSX_FOLDER% %%G IN (*.xlsx) do (
	echo "Construyendo los puntos a partir de la hoja de EXCEL %%~nG.xlsx" 	
	
	ogr2ogr.exe -f "GPKG" -geomfield geom -dialect sqlite -sql "SELECT *, GeomFromText('POINT Z(' || CAST( x AS integer) || ' ' || CAST( y AS integer) || ' ' || CAST (altitud AS integer) || ')', 3116 ) AS geom FROM Sheet1" --config OGR_XLSX_HEADERS FORCE %XLSX_FOLDER%%%~nG.gpkg %%G

	ogrinfo.exe %XLSX_FOLDER%%%~nG.gpkg -sql "ALTER TABLE SELECT RENAME TO vertices"

	echo "Construyendo la ruta a partir de la capa de puntos" 

	ogr2ogr.exe -update -dialect sqlite -sql "SELECT 'user_id', MakeLine(geom) FROM vertices GROUP BY 'user_id'" %XLSX_FOLDER%%%~nG.gpkg %XLSX_FOLDER%%%~nG.gpkg

	ogrinfo %XLSX_FOLDER%%%~nG.gpkg -sql "ALTER TABLE SELECT RENAME TO ruta"
)

echo "*****************************************************************"
echo "Todas las rutas fueron creadas correctamente en %XLSX_FOLDER%"
echo "*****************************************************************"