topic Re: ArcSDESQLExecute => FGDB in Python Questions

ArcSDESQLExecute => FGDB

CharlesTilly — Wed, 22 May 2013 19:03:55 GMT

I'd like to take the results from a ArcSDESQLExecute query and bulk load that into a file geodatabase. Anyone know of a way to do that faster than using the InsertCursor?

Is the ArcSDESQLExecute.execute list castable to anything else like a FeatureSet or other ArcPy list?

Regards,

Chuck

Re: ArcSDESQLExecute => FGDB

ChrisSnyder — Thu, 23 May 2013 17:17:21 GMT

What does your ArcSDESQLExecute query look like and what is it returning? A spatial view, table view?

Re: ArcSDESQLExecute => FGDB

CharlesTilly — Thu, 23 May 2013 18:30:30 GMT

It shouldn't matter should it? The results of a ArcSDESQLExecute.excute is always going to be a list of lists isn't it? A SQL statement against a table is going to return the same sort of list that one against a view does. Correct?
I'd love to figure out how to get it to return a ref_cursor from a function if that is possible.

Re: ArcSDESQLExecute => FGDB

ChrisSnyder — Thu, 23 May 2013 19:39:07 GMT

I asked, since the "best" way probably depends on what the rows contain (i.e is there Shape data?).

However, if you are looking for a Python-based solution, I'm not sure how you would get away from using an insert cursor, which the cursor kinda being the "lowest level" operator available. Of course the new .da cursors (in v10.1) are much faster than the "old" cursors, so if you are running v10.1, that'd be the 1st thing I'd try.

If you were really handy, maybe you could use the new FGDB API, but that's above my head and I don't think there's a way to do it directly via Python.