mkoneya

Generating SQL Geometry on the Fly in View or Query Layer

Discussion created by mkoneya on Nov 22, 2013
Latest reply on Nov 23, 2013 by mboeringa2010
I was watching an ESRI video called "Web Enabling Databases with ArcGIS for Server" and I thought I heard them say that SQL Geomety could be created on the fly in a view or in ESRI terms with a Query Layer.

I have a couple of SQL tables that have LAT/LONG and I would like to used this information to create SQL geometry for each row rather than creating an event theme from the LAT/LONG values.      Due to restrictions on the database table,   I am not able to add a Geomtry field to the table itself so I thought I would try to do it via a view/query layer and bring it into ArcMap that way.

I have not been able to find any examples of doing this.    

Let me know if this is possible and more importantly,  if there are some examples of doing so.

Thanks,

Mele

Outcomes