topic Re: Event theme based on non-numeric fields in Data Management Questions

Event theme based on non-numeric fields

AdrianMarsden — Tue, 09 May 2017 12:16:12 GMT

We have a third party application with data stored in Oracle. There is a table with text fields for east/north.

We want to create an Event Layer. We cannot modify the table and as it is 3rd party don't want to add an Oracle view as it may mess with the support.

So, anyone any ideas if it is possible to cast/convert text fields within Desktop to create an event theme?

Cheers

ACM

Re: Event theme based on non-numeric fields

DanPatterson_Retired — Tue, 09 May 2017 12:18:56 GMT

you would have to add two new double fields and cast any text representations of numbers using 'float'. You can't create an event theme directly from text, so you will have to edit the original file, add the fields or perform the operation on a new file

Re: Event theme based on non-numeric fields

AdrianMarsden — Tue, 09 May 2017 12:21:15 GMT

I thought as much - we think we'll warehouse the data in SQL and do the conversion there. We don't like messing around in Oracle.

Thanks