Joining Oracle based CAMA Data to SDE Dataset

[HectorGutierrez1]

I am trying to join data from the Assessor's Office CAMA ssytem (Realware) to the Parcel Feature class through catalog so that all parcels include ownership information on the SDE Database versus doing a join on each computer and having to update everyone periodically.

[JohnFell]

Hector,

We have found that using spatial views within SDE has been helpful for this purpose. We generate multiple views for various departments given that appraisal staff in these departments have different data needs. A spatial view can be defined on the parcel feature class and one or more tables. We create spatial views based on tables generated using SQL queries and stored procedures. These can be viewed in ArcMap, used in an ArcGIS map service, or even as input in geoprocessing tasks. You can read more about creating spatial views using Oracle here.

[HectorGutierrez1]

Thanks John i will try this