topic Re: ArcGIS 10.3: how to create Geopackage with raster tiles in Data Management Questions

ArcGIS 10.3: how to create Geopackage with raster tiles

KIMIWATANABE — Wed, 14 Jan 2015 21:47:54 GMT

Hello, everyone!

ArcGIS now supports the 1.0 OGC GeoPackage format. I am wondering how I can create geopackage files with raster tiles. Could you direct me to some documentation for it, please?

Thank you for your help in advance & happy mapping!

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

BrianLehman — Wed, 18 Feb 2015 17:01:10 GMT

A patch to 10.3 is forthcoming (late February) that will support reading/display and writing of GeoPackage tiles. Source code will also be released via the Esri Github site for a ready to use GP tool to load GeoPackage tiled rasters.

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

EszterGalicz1 — Tue, 14 Apr 2015 12:57:04 GMT

So 10.3 is available and it seems that reading raster tiles is supported with the tool Make Raster Layer via Data Management Tools > Layers and Table Views.

I am following this documentation:

Make Raster Layer—Help | ArcGIS for Desktop

The tool gives a feedback that the layer is created, however it is not added to the Table of Contents, and also does not appear in ArcMap in any way.

Is there a place in my file system where I can find this layer file?
Thanks

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

LanceShipman — Tue, 14 Apr 2015 15:33:01 GMT

The display of raster data from a geopackage at 10.3 requires a patch. The patch is in testing and should be available this month.

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

JoshuaBixby — Thu, 20 Aug 2015 21:54:57 GMT

Now that 10.3.1 is out, is the patch you reference already incorporated? I have ArcGIS 10.3.1 and am running into problems getting raster data from geopackages into ArcMap.

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

LanceShipman — Thu, 20 Aug 2015 22:10:39 GMT

You can pull the latest copy of the raster2gpkg tool from GitHub. We had to make additional changes to the gdal18.dll. Pull from Esri/raster2gpkg · GitHub

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

JoshuaBixby — Fri, 21 Aug 2015 18:30:50 GMT

Thanks. Unfortuantely, my problem isn't Esri Raster > GeoPackage but GeoPackage > Esri Raster. I can't seem to get Make Raster Layer to work with raster tiles in a GeoPackage. I even tried the ERDC Whitehorse Geopackage Download that is posted on the GeoPackage Encoding Standard web page. If I run the Make Raster Layer tool, it completes without errors but nothing happens. If I call the tool from Python, it generates an error:

Runtime error  Traceback (most recent call last):  File "<string>", line 1, in <module>  File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 7012, in MakeRasterLayer    raise e ExecuteError: ERROR 000582: Error occurred during execution.

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

LanceShipman — Fri, 21 Aug 2015 18:52:18 GMT

1) Have added the gdaal18.dll (for github) to Desktop10.3\bin)? are you using 10.3.1 or 10.3?

2) The Whitehorse Geopackage can't be displayed because it contains an invalid spatial reference.

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

JoshuaBixby — Fri, 21 Aug 2015 22:08:08 GMT

I am running ArcGIS 10.3.1.4959.

I downloaded gdal18.dll from GitHub. Both my installed copy and the GitHub copy say version 1.8.0.10300, but my installed copy is 7.87 MB and the GitHub copy is 9.48 MB. Although the names and file versions are the same, obviously the files aren't the same. I will move the GitHub copy over to \bin and test it shortly.

Regarding the Whitehorse GeoPackage, what table, data element, etc... are you using to determine an invalid spatial reference. The gpkg_spatial_ref_sys table does list undefined Cartesian and Geographic coordinate reference systems, but it also lists WGS84 and Web Mercator. The gpkg_contents and gpkg_tile_matrix_set tables state Web Mercator as the SRS ID.

UPDATE: Tried the GitHub gdal18.dll, same error: 000582. Something else I noticed, 150+ ~10KB SQLite files were created in my %TEMP% folder. Does this seem right? Are they supposed to be cleaned up at some time or will my %TEMP% folder be filled with these files?

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

JoshuaBixby — Thu, 27 Aug 2015 20:33:28 GMT

Lance Shipman, I figured out what was preventing the Whitehorse GeoPackage from loading. When working with tiles in GeoPackages, the Make Raster Layer tool appears to need the zoom levels to start at 0 and increment from there. The Whitehorse and other GeoPackages I am working with are sparse, i.e., they don't start with zoom level 0, so they fail to load. If I go in and reset the zoom levels to start at 0, then I can get them to load.

The fact that Make Raster Layer seems to need the zoom level to start at 0 is in violation of the GeoPackage standard as I read it. The standard specifically has a couple lines that state, "Tiles MAY or MAY NOT be provided for level 0 or any other particular zoom level. This means that a tile matrix set can be sparse, i.e. not contain a tile for any particular position at a certain tile zoom level."

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

juliaharrell2 — Fri, 23 Oct 2015 18:36:49 GMT

Lance - is there any estimate for when this compliance issue is expected to be resolved about not requiring tile/zoom levels to start at 0 ?

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

LanceShipman — Fri, 23 Oct 2015 18:42:07 GMT

We are currently working on this. I may be able to provide an estimate next week.

Lance

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

JoshuaBixby — Mon, 13 Feb 2017 19:16:43 GMT

Lance Shipman‌, I noticed in My Esri that the following bug was closed this past January as "Not in Current Product Plan."

#BUG-000090526 If a geopackage is input with zoom levels not beginning with 0, arcpy.MakeRasterLayer returns the following error, "Failed to execute. Parameters are not valid. ERROR 000865: Input raster: does not exist."

Even with the latest Desktop releases, I cannot get the OGC GeoPackage Whitehorse download to load properly. In ArcMap 10.5, I get:

ERROR 000860: Input raster: is not the type of Composite Geodataset, or does not exist. Failed to execute (MakeRasterLayer).

In ArcGIS Pro 1.4, I get:

ERROR 999999: Error executing function. Failed to execute (MakeRasterLayer).

I find the different error message interesting/odd.

Seeing the bug was closed and the issue still persists, did Esri just decide not to work on it?

UPDATE: See response below to Lance S. for update.

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

LanceShipman — Mon, 13 Feb 2017 19:38:01 GMT

There have been a lot of changes in the geopackage support since BUG-000090526. The raster2gpkg tool for 10.4 and 10.4.1 was updated in October 2016 base on the changes included in the 10.5 release.

Are you talking about the image located at:

https://portal.opengeospatial.org/files/63156

Re: ArcGIS 10.3: how to create Geopackage with raster tiles

JoshuaBixby — Mon, 13 Feb 2017 22:04:17 GMT

Yes, I was/am talking about the GeoPackage referenced at the link you provided.

Regarding the new errors, ERROR 000860 & ERROR 999999, my bad. I went back and tested it again, and it works. I used the wrong syntax when I first re-tested it. Using the correct syntax, it works in ArcMap 10.5 and ArcGIS Pro 1.4. I struck through most of my previous comment but didn't delete entire comment because bug status still an issue.

Seeing that it works, and whatever issue was resolved, I guess this is really a My Esri and Esri Support problem since the issue that caused the bug to be logged has been fixed but yet the system says it isn't and won't be fixed. I will inquire with Esri Support regarding the conflicting information in My Esri.