non esri SQL table with mixed geometries

[AdrianMarsden]

Hi

I have a SQL database.  In this SQL database is a SQL Spatial table, from a NONE Esri source.  This table has mixed (ug!) geometries, points, multiponts and polygons.  This table is from a third party application and I have NO control over it.

I can view the data OK in ArcMap, when I add it on, I have to choose the geometry type and unique field.

However, if I try to do anything with layers I get a 99999 error "Invalid Entity type"

What I'm trying to do is to take this source, buffer the point features, then merge it with the polygon features to create a single ArcMap friendly layer.

Cheers

ACM

[VinceAngelo]

Try using views to limit to a single topology class via the where clause. -V

[AdrianMarsden]

Hi - tried that with an Esri view, and failed.  I tried to do it setting the view up on SQL, but couldn't get the syntax right for "GEOMETRY=POINT" or whatever.

Anyway, esri(uk) have told me they think 10.2 will work better, so I'm about to install that on a VPC to take a look.

Cheers

ACM

[VinceAngelo]

You have to work with the functions that Microsoft provides.  In this case, it's .InstanceOf(POINT). As a one time thing you can even cast to Well-Known Text and search for "Point%". -V

[AdrianMarsden]

🙂 I was just wondering myself if you could CAST a geometry column.

FYI - 10.2 behaves in exactly the same way with the approach I was using in 10.1

trying the CAST now.

ACM