topic Re: non esri SQL table with mixed geometries in Data Management Questions

non esri SQL table with mixed geometries

AdrianMarsden — Mon, 05 Aug 2013 13:41:33 GMT

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

Re: non esri SQL table with mixed geometries

VinceAngelo — Wed, 07 Aug 2013 00:30:57 GMT

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

Re: non esri SQL table with mixed geometries

AdrianMarsden — Wed, 07 Aug 2013 07:24:34 GMT

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

Re: non esri SQL table with mixed geometries

VinceAngelo — Wed, 07 Aug 2013 10:39:53 GMT

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

Re: non esri SQL table with mixed geometries

AdrianMarsden — Wed, 07 Aug 2013 10:45:01 GMT

🙂 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