Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm trying to turn data in a Microsoft Access file into an ArcGIS-10 layer. The table contains a column labeled "shape." Each line in this column reads "long binary data." What's that?

share|improve this question
add comment

4 Answers 4

up vote 1 down vote accepted

The Shape field is also known as the Geometry field. It has all of the geometry required to render each feature (or record) in your Table. The Information in this field is not able to be read as it is proprietary for the ArcGIS Software so decoding the Binary information is done by the ArcGIS (ArcObjects) Reference Library. The Long Binary Data you are seeing is a designation of the BLOB Data Type standing for Binary Large Object. This is a binary dataset, and can be used for rasters, video, images and other large data types.

Simple thing is leave it alone as it is the geometry for all features in this feature class. So if you Open ArcCatalog and point to your Access database you should then be able to see the symbology as written by Brad Nesom. Before you do this make sure you have the data stored as an MDB and not an ACCDB, reason being is that the Personal Geodatabase is native to MDB but ACCDB is read only and only for attribute data.

Have Fun, CDB

share|improve this answer
    
thanks! -- beth –  Beth Dec 7 '10 at 23:40
    
not a problem :) –  Brad Nesom Dec 8 '10 at 2:41
add comment

If your mdb table has a shape field it should already be esri data.

Does it contain an OID, FID or GUID as well?

Edit: > Yes OBJECTID is the one I forgot to put in the list.

If you view the db in arccatalog you should see icons feature type icons

for the tables that have geodata in them. Other tables will have a table icon.

My example shows the table icons first, then it has a file based gdb, but the icons are the same regardless.

share|improve this answer
1  
There's a column labeled "OBJECTID" -- I assume that's an OID? Is it sufficient for the column to be named as such or does it have to be hooked up in some way? –  Beth Dec 6 '10 at 18:09
1  
there is no hooking up just veiw the data in esri product. –  Brad Nesom Dec 6 '10 at 20:30
    
great images and desc Brad :) –  CDBrown Dec 12 '10 at 23:42
add comment

I believe your data is already in a personal geodatabase. I would suggest you confirm this by looking at your database in arc-catalog

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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