Dear All
I have one Oracle table containing Lat/Long seperate fields, and this table is updated (new inserts) daily, and i need to convert these coordinate daynamically to points. and as far as i want these locations to be shown all the times and up-to-date , i want to create an SDE spatial view (as far as its a view and will reflect the up-to-date state of the records).
My proplem is when using the sdetable -o create_view command , i have to add a shape field in order to convert it to spatial view? in my case the coordinates is exists on two columns (lat/long) and not on shapefield?is there anyway that support the idea i just raised?
I know that i can use the Add even theme or convert xy tools available and schedule them based on time interval, but i need something more dynamic.
I hope someone have solution for that (Unfortunatly i am not a programer and i know that this also can be accomplished using webservice (if someone familiar on creating a service that deal with this scenario i wwill appreciate it)
All the best