0

Is it possible to have a live ArcMap 10.4 connection to a database that will update database changes without the need to export the database table as a GDB?

Do I always have to do the export?

I mean this particularly in regards to linear referencing.

3
  • It sounds like you want to use Dynamic Segmentation so I think the answers are Yes and then No. What have you tried? Where are you stuck?
    – PolyGeo
    Commented Jan 10, 2017 at 20:46
  • Well im not stuck anywhere but people I work around ask me often whether changes in the 11g database would quickly manifest themselves in the ArcMap map. I never quite know what to say.
    – Thomas_
    Commented Jan 10, 2017 at 20:51
  • But exporting the database table is the only way I know to bring in data to ArcMap. Aside from a spreasheet of course.
    – Thomas_
    Commented Jan 10, 2017 at 20:53

1 Answer 1

1

You can Connect to Oracle from ArcMap.

Once you can view an Oracle table you should be able to use it as an event table with Dynamic Segmentation:

Geographic data is represented on a map as a layer. Route events are no different. To display route events on a map, however, you must first define the parameters of the relationship between the table storing the events and the routes that the events reference.

The technology used to do this has a long history that dates from 1989 and Esri UK's Chainage Module and Highway Information System (ArcHIS) which became the Dynamic Segmentation capability of ARC/INFO a year or two later. It was using Oracle to store event tables then so I would not expect that functionality to have been lost in the intervening years.

3
  • OK that sounds good. How do I go about doing that? Is there a function for it in the toolbox? I have not been able to find one.
    – Thomas_
    Commented Jan 11, 2017 at 16:51
  • @hollow_Victory Have you been able to connect to and view Oracle tables in ArcMap yet? If that is where you are stuck try using the first documentation link that I provided. If you are still stuck then research/ask how to connect to and view Oracle tables in ArcMap as a separate question.
    – PolyGeo
    Commented Jan 11, 2017 at 21:37
  • I am connected to an Oracle database right now and I can access the tables. As far as viewing them, do you mean exporting the table as a single geodatabase?
    – Thomas_
    Commented Jan 12, 2017 at 14:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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