[GIS] How to join two shapefiles and create a new shapefile using ArcObjects

arcobjectsshapefile

Newbie in ArcObjects programming. Using C#. Developing a desktop application.

I have two shapefiles. One is a point shapefile Called Addresses and another Polygon shapefile which is called Area. The Address shapefile has an attribute called Address_Number while the Area shapefile has a attribute called Area_Number.

I need to select only the features that match "Address_Number" (from Addresses) to "Area_Number" (from Area) and then create a new shapefile.

How can I do this?

Any help with some code example is greatly appreciated.

Best Answer

join the dbf from the area shape with a many to one, to the addresses shape. select the oid of area not null and export.

Related Solutions

[GIS] Writing the where clause in IQueryFilter

If the number of individual categories is fairly low (you have 3 now) something along those lines would be both simple and quite efficent:

WHERE NOT
(
  (LimitFrom > 130 and Category = 1)
  or (LimitTo > 130 and Category = 1)
  or (LimitFrom >= 101 and LimitFrom <= 130 and Category = 2)
  or (LimitTo >= 101 and LimitTo <= 130 and Category = 2)
  or (LimitFrom >= 91 and LimitFrom <= 100 and Category = 3)
  or (LimitTo >= 91 and LimitTo <= 100 and Category = 3)
)

Tested with your sample data on Oracle, should work virtually everywhere since it's standard SQL.

[GIS] Creating a new layer from query results

The AO-API has got an example. This would mean that you would have to extent your code by the following lines:

IFeatureDataset featureDataset = featureWorkspace.OpenFeatureQuery("MyJoin", queryDef);
IFeatureClassContainer featureClassContainer = (IFeatureClassContainer)featureDataset;
IFeatureClass featureClass = featureClassContainer.get_ClassByName("MyJoin");

And just assign that feture class to a feature layer. Assuming you really want to create a new shapefile in the filesystem, you can export the created feature class with a geoprocessor like FeatureClassToShapefile.

Best Answer

Related Solutions

[GIS] Writing the where clause in IQueryFilter

[GIS] Creating a new layer from query results

Related Question