topic Re: Join IN_MEMORY Table to FeatureClass in Geoprocessing Questions

Join IN_MEMORY Table to FeatureClass

JamesCrandall — Thu, 04 Oct 2012 14:56:18 GMT

ArcGIS 9.3.1
Python 2.5

I have a "IN_MEMORY" table verified by reviewing the gp.messaging:

newrows = gp.searchcursor("IN_MEMORY\TempDT") newrow = newrows.next() while newrow:   gp.AddMessage("Inserted: " + str(newrow.gis_station) + ", " +  str(newrow.station) + ", "  + str(newrow.sample_date)     newrow = newrows.next()

Now I'd like to join this with a FeatureClass in a PGDB. I suppose that I will then have to issue a copyfeatures_management in order to see the result? I really have no idea how else to see the joined FC in ArcMap.

Anyway, there is no error, but the output doesn't inlcude the joined fields either so any help is appreciated:

        tab = "IN_MEMORY\TempDT"     memtabname = "inmemtab"     gp.MakeTableView_management(tab, memtabname)     gp.AddJoin_management(memtabname, "gis_station", fc, "STATION", "KEEP_ALL")     gp.copyfeatures_management(fc, tempFC)

Re: Join IN_MEMORY Table to FeatureClass

JamesCrandall — Thu, 04 Oct 2012 17:56:39 GMT

Not going to mark my own post as the answer, but should someone need to do this the solution is to use the TableView and FeatureLayer object instead of the objects themselves (from what I can tell anyway).

tab = "IN_MEMORY\TempDT" gp.MakeFeatureLayer_management (fc, "pointFC") ### convert the FC memtabname = "inmemtab" gp.MakeTableView_management("IN_MEMORY\TempDT", memtabname)  ### convert the in_memory table  gp.AddJoin_management("pointFC", "STATION", memtabname, "gis_station", "KEEP_ALL")     if gp.Exists(tmpLayer):    gp.Delete_management(tmpLayer)    gp.CopyFeatures_management("pointFC", tmpLayer)

(tmpLayer is a .shp file that I save to the user's local drive and tab was generated by filling a cursor from a cx_Oracle.connect call)

Re: Join IN_MEMORY Table to FeatureClass

KenBuja — Thu, 04 Oct 2012 18:20:04 GMT

You should mark your own post as the answer. It makes it easier for someone looking for the correct answer to find your post. When doing a search, you're returned a list of threads, with the answered ones marked by a green "A". Wouldn't you look at those threads first?

Re: Join IN_MEMORY Table to FeatureClass

JamesCrandall — Thu, 04 Oct 2012 18:47:19 GMT

You should mark your own post as the answer. It makes it easier for someone looking for the correct answer to find your post. When doing a search, you're returned a list of threads, with the answered ones marked by a green "A". Wouldn't you look at those threads first?

Okay will do... Done!