I have a geodatabase (filename ends with .geodatabase) and when I drag this into QGIS, I see all the tables and can browse them.

On some of those tables there attributes that look like they are the shapefile encoded or in a binary format or something. See this example

enter image description here

In the table properties, source fields, this field is defined as Type:QString TypeName: Binary.

Assuming I am correctly understanding this and it is the shapefile. How can I get QGIS to see this as a layer?

  • 1
    It might be the geometry encoded as a binary or hexadecimal string but I don't think its in "Well-known Binary" (WKB) format. Can you post a complete example as text that we can cut and paste? – Spacedman Jul 9 '18 at 21:30
  • Through the UI, I only see the truncated version. Is there another way to get to the full value? – w7pea Jul 9 '18 at 22:09
  • I also tried to get to it through the python console and its truncated there as well.. That seems odd. – w7pea Jul 9 '18 at 22:16
  • The data is in binary format... see answer and comments for more information. – w7pea Jul 11 '18 at 17:56

This is a bit of a longshot, but I have only seen a *.geodatabase file when working with ArcGIS. It is a Runtime Geodatabase, created from ArcMap.

When I need to consume the information stored in this type of file I use the "Copy Runtime Geodatabase to File Geodatabase" Tool in ArcMap. From the help file I see it is available in All Licenses for ArcMap, although I think it was only added to the Toolbox in ArcMap 10.3.

If you have access to ArcMap +10.3, try running the tool and then opening the *.gdb created in QGIS. You should be able to extract the features that way. Or if you have access to ArcMap, simply extract the features directly.

  • I used the 21 day Trial of ArcGIS Pro to achieve this as you suggested. The commands are a bit different. You use Export XML Workspace Document to convert the runtime geodatabase to XML: pro.arcgis.com/en/pro-app/tool-reference/data-management/… Then use Import XML Workspace to get it into a file based gdb. pro.arcgis.com/en/pro-app/tool-reference/data-management/… And from there, I could drag n drop into QGIS. – w7pea Jul 11 '18 at 17:32
  • One additional note. When you are doing the Export, you need to select Storage Type : Normalized or the geometry|shapefile won't be converted to text. – w7pea Jul 11 '18 at 17:58
  • Good to know, thank you. I am still coming to grips with Pro and havent explored the differences in toolsets yet. I'll keep this in mind. – Keagan Allan Jul 11 '18 at 23:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.