I am trying to understand how to create a database view that shows a 150 foot buffer around each point in a table. The table of points changes pretty frequently and I would like to use a view instead of just buffering the points and having to update the polygon layer all the time.
I am using ArcGIS 10.2.1 and my SDE database is running on SQL Server 2012.
I have some experience building view layers in a PostgreSQL environment but that was a while ago and I'm struggling to get my head around doing things in this new space.
I started out reading the documentation for the 'Create Database View' tool but am having trouble figuring out how to put together the SQL statement. Where do I put the
.ST_Buffer() part of the statement? I'm confused because
.ST_Buffer() only accepts the distance as an argument, and it has a dot prefix, which makes me think that I need to use it as a function. I can't seem to find any references to doing this anywhere on the web. Is it even possible to do this in the software environment I'm using?
This is the best stab I have taken:
SELECT OBJECTID, LocationID, shape.st_buffer(47.5) FROM gisdb.DCGIS.TransformerBank
When I run that the tool errors out and reports:
ERROR 999999: Error executing function.
[[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find either column "shape" or the user-defined function or aggregate "shape.st_buffer", or the name is ambiguous.]
DBMS table not found
Failed to execute (CreateDatabaseView).