How do I get the extent of tables (feature classes) in a geopackage?

EricEagle

import arcpy
import os

gpkg = r"C:\Data\georgia.gpkg"

desc = arcpy.Describe(gpkg)
print(desc.dataType)
print(desc.workspaceType)

Result:

Workspace
LocalDatabase<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

walk = arcpy.da.Walk(gpkg)

for path, names, filenames in walk:
    for fname in filenames:
        d = arcpy.Describe(os.path.join(path, fname))
        print(fname, d.dataType)

Result:

main.ga_admin FeatureClass
main.ga_highway FeatureClass
main.ga_natural FeatureClass
main.ga_poi FeatureClass
main.ga_water FeatureClass<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

But if I add...

for path, names, filenames in walk:
    for fname in filenames:
        d = arcpy.Describe(os.path.join(path, fname))
        print(fname, d.dataType)
        print(f"Extent of feature class: {d.extent.XMin}, {d.extent.YMin}, {d.extent.XMax}, {d.extent.YMax}")
        print(d.extent) # sanity check

Result:

main.ga_admin FeatureClass
Extent of feature class: nan, nan, nan, nan
nan nan nan nan NaN NaN NaN NaN
main.ga_highway FeatureClass
Extent of feature class: nan, nan, nan, nan
nan nan nan nan NaN NaN NaN NaN
main.ga_natural FeatureClass
Extent of feature class: nan, nan, nan, nan
nan nan nan nan NaN NaN NaN NaN
main.ga_poi FeatureClass
Extent of feature class: nan, nan, nan, nan
nan nan nan nan NaN NaN NaN NaN
main.ga_water FeatureClass
Extent of feature class: nan, nan, nan, nan
nan nan nan nan NaN NaN NaN NaN<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

No extent.  However, if I load this content in ArcGIS Pro, it calculates the extent correctly.

How do I get the extent of layers in a geopackage?

JoshuaBixby

I tested your code with a GeoPackage I just created, and it works fine.  So, I am wondering where did this GeoPackage come from?  If third-party software created the GeoPackage, it may be that not all of the GeoPackage data tables were properly populated.  If the GeoPackage was created by third-party software, try copying the contents to a new GPKG you create from Pro, and then see if you get expected results.