Test Tables for geopackage and shapefile

[Sov-trotter]

It's be nice to add tests for .shp and .gpkg files too. #118 (comment)

[Sov-trotter]

@yeesian could you add the goodfirstissue and Hacktoberfest tags?

[yeesian]

Linking https://github.com/OSGeo/gdal/blob/master/autotest/generate_sample_gpkg.py here. See also: https://github.com/OSGeo/gdal/tree/master/autotest#notes-about-availability-of-gdal-sample-and-test-data and http://download.osgeo.org/gdal/data/.

[mathieu17g]

@yeesian (cc: @Sov-trotter) this issue may be closed with PR #226 ?

ESRI Shapefile and GeoPackage layers exports to Table are somewhat tested in:

• ArchGDAL.jl/test/test_tables.jl

  Lines 541 to 594 in 8d6e1be

  	@testset "Conversion to table for ESRI Shapefile driver" begin
  	ESRI_Shapefile_test_reference_geotable = (
  	names = (Symbol(""), :id, :name),
  	types = (Union{Missing,ArchGDAL.IGeometry}, Int64, String),
  	values = (
  	Union{Missing,String}[
  	"POLYGON ((0 0,0 1,1 1))",
  	"MULTIPOLYGON (((0 0,0 1,1 1)),((0.9 0.9,0.0 0.9,0 0)))",
  	missing,
  	"POLYGON ((0 0,-1 0,-1 1))",
  	],
  	[1, 2, 3, 0],
  	["polygon1", "multipolygon1", "emptygeom", "emptyid"],
  	),
  	)
  	@test test_layer_to_table(
  	"ESRI Shapefile",
  	"polygon",
  	true,
  	true,
  	true,
  	ESRI_Shapefile_test_reference_geotable,
  	)
  	ESRI_Shapefile_test_reference_geotable = (
  	names = (Symbol(""), :id, :name),
  	types = (
  	Union{
  	Missing,
  	ArchGDAL.IGeometry{ArchGDAL.wkbLineString},
  	},
  	Int64,
  	String,
  	),
  	values = (
  	Union{Missing,String}[
  	"LINESTRING (1 2,2 3,3 4)",
  	"LINESTRING (3 4,4 5,5 6)",
  	missing,
  	"LINESTRING (5 6,6 7,7 8)",
  	],
  	[1, 2, 3, 0],
  	["line1", "line2", "emptygeom", "emptyid"],
  	),
  	)
  	@test test_layer_to_table(
  	"ESRI Shapefile",
  	"line",
  	true,
  	true,
  	false,
  	ESRI_Shapefile_test_reference_geotable,
  	)
  	end

• ArchGDAL.jl/test/test_tables.jl

  Lines 691 to 714 in 8d6e1be

  	@testset "Conversion to table for GPKG driver" begin
  	GPKG_test_reference_geotable = (
  	names = (:geom, :id, :name),
  	types = (Union{Missing,ArchGDAL.IGeometry}, Int64, String),
  	values = (
  	Union{Missing,String}[
  	"LINESTRING (1 2,2 3,3 4)",
  	"MULTILINESTRING ((1 2,2 3,3 4,4 5),(6 7,7 8,8 9,9 10))",
  	missing,
  	"LINESTRING (5 6,6 7,7 8)",
  	],
  	[1, 2, 3, 0],
  	["line1", "multiline1", "emptygeom", "emptyid"],
  	),
  	)
  	@test test_layer_to_table(
  	"GPKG",
  	"line",
  	true,
  	true,
  	true,
  	GPKG_test_reference_geotable,
  	)
  	end

[yeesian]

Thanks for triaging the issue @mathieu17g :)