span8
span4
span8
span4
Is there a way to tell an SDE reader to forget the spatial?
I can read as SQL Server Non Spatial,but I lose the SDE ST.Area attribute,which I need.
However,I don't need the actual geometry and reading it wastes 30 minutes.
---- Hoping for an "opposite of Geometry Only".
Thanks,
Jake
Thanks guys.I use a lot of SQL Executor - tried it,but could only pull SHAPE.I've tried all syntax variants to pull what shows up as [SHAPE.STArea()] in ArcCatalog,without success.SSMS doesn't show this column (sub of SHAPE).I had hoped that since there is a "Geometry Only" setting,there'd be a "Table Only" setting for an SDE reader.Appreciate your input,but I think I'll go knock something else out now.
I agree with Richard,you could either use the SQLExecutor or the SQLCreator with the SQL Server non spatial reader.
If your geometries are stored assde.st_geometryobjects,you can do something like:
SELECT ATTRIBUTE_A,ATTRIBUTE_B,SDE.ST_LENGTH(SHAPE) AS SHAPE_LENGTHFROM MY_SCHEMA.MY_TABLE
Or if they're stored as SQL Server Spatialgeometryobjects,it will probably look more like:
SELECT ATTRIBUTE_A,ATTRIBUTE_B,SHAPE.ST_LENGTH() AS SHAPE_LENGTHFROM MY_SCHEMA.MY_TABLE
I think the easiest route is to try using the sqlExecutor to select just the columns you need.
© 2019 亚搏在线Safe Software Inc |Legal