Latest Contributions by JoshuaBixby

It appears you are using SQL Server native spatial types.  That said, it is best to be explicit and not make people guess. First, STIntersects isn't the method you need.  It is a check of intersection and returns a SqlBoolean. Below is an example using SQL Server native spatial types to retrieve the intersecting area of 2 polygons: Declare @g1 geometry; Declare @g2 geometry; SET @g1 = 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))' SET @g2 = 'POLYGON((5 5, 15 5, 15 15, 5 15, 5 5))' SELECT @g1.STIntersection(@g2).STArea() ... View more

When it comes to VBScript and ArcGIS, do what Nancy does, "just say no."  Model Builder has its place, it just isn't in my toolbox.  I encourage you to learn Python, it will open up ArcGIS to you much more than Model Builder, and the skills are infinitely more transferrable. The following should work for you.  Just paste the code into the interactive Python window and call the add_table_names function with the geodatabase in question.  The script will find all tables and feature classes not in feature datasets and append the name of the table or feature class as a new field.  If you want to recurse into the feature datasets, it isn't too hard to update the code. def add_table_names(workspace):     desc = arcpy.Describe(workspace)     for child in desc.children:         if child.datasetType not in ('Table', 'FeatureClass'): continue         arcpy.AddField_management(child.catalogPath, "FC_NAME", "TEXT")         arcpy.CalculateField_management(child.catalogPath,                                         "FC_NAME",                                         "'{}'".format(child.baseName),                                         "PYTHON_9.3") ... View more