Oracle BLOB data extract from N_1_JTOPO

Question

Hi All,

Can you please advise if there's a way to extract coordinates from N_1_JTOPO table/PAGELOB field?

Can it be done somehow using ArcCatalog/ArcMap? Or there's simply an Oracle matter of extracting binary data (painful).

Any help would be much appreciated!

Thank you,

Daniel

blob.png

George_Thompson · Answer

Yes, ArcGIS is writing (an reading) this information to the tables under the hood. Think of these tables like the GDB or SDE tables in the enterprise geodatabase. They are there to help everything function correctly, but not to be "seen directly" in the ArcGIS clients.

I would only recommend using the ArcGIS client tools for collecting information on the GN. I have never heard of anyone wanting to read the blob field directly.

Is there an issue with their network that you are trying to analyze?

Are you using custom tools to interpret the network?

DanielSotreanu · Answer

Isn't it that ArcGis write this information into Oracle? How come ArcGis cannot read what it is writing?

DanielSotreanu · Answer

Thanks George. No harm can be done in this case. I only have a db backup from the customer and we are trying to analyze their network.

We are stuck at N_1_JTOPO/PAGELOB, hoping to get information about junctions and edges.

I thought ArcGis tools can interpret blob data and help us extract the data out.