Latest Contributions by TedKowal

When crazy things occur using points along a route, here in this thread I mentioned some things I try....  https://community.esri.com/thread/214168-create-route-event-layer-layer-doest-show-up  The most common issues I see when I use the tool: 1.  No ESRI recognized ObjectId in the event/overlay layer 2.  Projections not the same 3.  No valid route layer 4.  Screen refresh lag ... some times at a range of specific zoom levels the data will not display or disappears. Hope some of this helps... ... View more

This is why the upset on dropping the MS Access geodatabase, this affects FAR MORE than Access.  The power and speed of MS ACCESS comes with its ability to Link multitudes of various datasources in combination with Geometry.   Albeit the Geo-processing is slow, the speed on analyzing and viewing related data from multiple sources as well as its ability to be embedded in Most not all applications makes it a POWERFUL timesaving tool.  Those of you who do not use MS Assess as your geodatabase, be advised dropping access has far more reaching affects other than MS Access itself. Please do put your use case in as well as voting here as well  Enable ArcGIS Pro to access ESRI Personal Geodatabases ... View more

On a similar note and using "Select by Attributes", as Dan suggested that you can use a python script to build further complexity.  Following is an example of a script that I used in a model to build a where clause to get a one to many related records ....  hope this helps (it is crude but it gets the job done... I am a vb programmer not python) .... import arcpy, os # Local Variables OriginTable = arcpy.GetParameterAsText(0) #Sign Support -->   Make Table View DestinationTable = arcpy.GetParameterAsText(1) #Sign Panels --->  Make Table View PrimaryKeyField = arcpy.GetParameterAsText(2) #SupportID /Sign Support ForiegnKeyField = arcpy.GetParameterAsText(3) #SupportID /Sign Panels def buildWhereClauseFromList(OriginTable, PrimaryKeyField, valueList):   """Takes a list of values and constructs a SQL WHERE        clause to select those values within a given PrimaryKeyField        and OriginTable."""   fieldDelimited = arcpy.AddFieldDelimiters(arcpy.Describe(OriginTable).path, PrimaryKeyField)   # Determine field type   fieldType = arcpy.ListFields(OriginTable, PrimaryKeyField)[0].type   # Add DBMS-specific field delimiters   # Add single-quotes for string field values   if str(fieldType) == 'String':     valueList = ["'%s'" % value for value in valueList]   # Format WHERE clause in the form of an IN statement   whereClause = "%s IN(%s)" % (fieldDelimited, ', '.join(map(str, valueList)))   #arcpy.AddMessage(whereClause)   return whereClause def selectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField):     """Defines the record selection from the record selection of the OriginTable       and apply it to the DestinationTable using a SQL WHERE clause built       in the previous definition"""     # Set the SearchCursor to look through the selection of the OriginTable     sourceIDs = set([row[0] for row in arcpy.da.SearchCursor(OriginTable, PrimaryKeyField)])     # Establishes the where clause used to select records from DestinationTable     whereClause = buildWhereClauseFromList(DestinationTable, ForiegnKeyField, sourceIDs)     # Process: Select Layer By Attribute     arcpy.SelectLayerByAttribute_management(DestinationTable, "NEW_SELECTION", whereClause) # Process: Select related records between OriginTable and DestinationTable selectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField) #output same as Destination Table ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I do not believe it is wise to combine two different data sets, you will only gain more headaches in future use.  I would highly advise that you first approach your problem manually in order to gain insight in the steps needed to obtain your desired results.  Reading your problem, I am assuming that you currently have two layers:  1.  Layer containing the Projects  2.  Layer containing the Parcels.  What you are looking to do is to extract or identify those parcels that are within a certain projects. Manual Steps  1. Create a selection set of the projects you are interested in using Selection-> Select by Attributes  You can filter the projects in the selection query. (Source Selection Area) 2. Now I am ready to identify those Parcels that Intersect (Or other spatial operation you desire) those identified Projects.  Selection-> Select by Location .. Target layer will be your parcels... Source layer will be the your projects.  Click on the Use Selected features checkbox 3.  On your parcel layer (Parcels that intersect your project should be highlighted)  Here you have the options to do other things now You could add a Field to the Parcels and place the Project identifier in it. Right click on your Parcel layer and export the "Selected" features to a temporary data store (Shapefile, Geodatabase etc) .... By doing the manual stuff you now have an outline of what you need to  perform the operation you want to code for.... In my case above  I would have a source and target feature class, on the source create a selection set by projects, using a spatial filter class perform an intersect query... from there you can write or do whatever you want with the resultant data..... Hope this helps. ... View more

I am not seeing how you are using the filter .... When I need geometry I either use a SpatialFilterClass or simply attach the queryfilter using a cursor..... Example:              IFeatureLayer ilayer = (IFeatureLayer)ArcMap.Document.FocusMap.get_Layer(0);             IQueryFilter queryFilterlast = new QueryFilterClass();             IFeatureClass pFc = ilayer.FeatureClass;             IFeatureCursor pFCursor;             IFeature pF;             queryFilterlast.WhereClause = null;             pFCursor = pFc.Search(queryFilterlast, false);             pF = pFCursor.NextFeature();             while (pF != null && pF.Shape != null && pF.Shape.IsEmpty == false ) {                 if (pFc.ShapeType == esriGeometryType.esriGeometryLine || pFc.ShapeType == esriGeometryType.esriGeometryPolyline) {                     ICurve curveForLength = (ICurve)pF.Shape;                     System.Diagnostics.Debug.WriteLine(curveForLength.Length.ToString());                 }                 pF = pFCursor.NextFeature();             }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Try your query using your Database interface directly to test the where clause.  CAST is a database specific function -- I know SQL Server can used it; however; an error will occur if run against an MS Access database for that you would have to use INT(....). -- as an example -- ... View more

I am old fashion.... when I do overlapping percentages .. I use a semi-manual arithmatic process..... described here.  This does work, although it does take time to work through the process.   arcgis desktop - Calculating percentage of overlap between two different layers - Geographic Information Systems Stack E…  Logic also works for polygons in one layer. ... View more

Brett,  to be fair to ESRI, MS Access, does have a 64bit flavor,  does not perform well when the data is closing in on the Gigabyte data range and starts performing worse and worse as the data size increase.  However, in day to day practice, work from start to finish, speed is not measured by the efficiency of the data base alone, it includes preparation, communication with other software, conversions, cleaning, data accessibility, post operations and finally completion.  The efficiency of your database is important but in a lot cases that is negligible.  What access gives a user is ungodly compatibility with almost EVERYTHING so in most cases other than the data speed (which is only a small percentage of  the work effort)...you will be spending enormous amount of time and extra work to get data into the system, overhead management of the large databases, or file geodatabase, now have to export that data out to format other applications can read, for example, for reporting I use crystal reports, I know that product cannot read a file geodatabase, so right there is an additional step I would have to make exporting the data into a format that can be read.  While it is true, MSACCESS geodatabase is inefficient with large datasets, my point is that the Pre and Post time savings using Access far overwhelms it slowness in geo-processing. Please do vote:  Enable ArcGIS Pro to access ESRI Personal Geodatabases ... View more

But a shape file is?   MS Access if VERY compatible with Portal and Online Servers ... direct experience with this! ... View more

Vote here Enable ArcGIS Pro to access ESRI Personal Geodatabases   and possibly some action will be taken.  I know for fact...currently our department will not migrate to pro if MS Access is not accepted.   ... View more

Could this simply be a learning curve thing?  I am not a lover of toolbars...but in most apps where there in use...I have found ways of modifing them to suit my needs.  EG  I programmed a custom toolbar for Excel to fit my needs!  Looking at the project road map, it appears that most everything in ArcMap is being ported over.... Personally, I will not be moving over due to the one thing that will not be ported over to ArcMap (MSACCESS) personal geodatabase.  The requirement that all personal geodatabases must be converted to file base ones (A database that third party applications cannot read, nor does it handle standard ANSI SQL) is a show stopper for me. If you agree vote here toEnable ArcGIS Pro to access ESRI Personal Geodatabases My experience in using ARC GIS Pro: ARC GIS Pro Data Sharing  ... View more

I used arc catalog connection with the connection string file on a network drive , still have to make sure all users are using that ...and in my model I am connecting to that....... however you may gain some inspiration towards a solution here:   arcpy - Create an ArcCatalog OLE DB Connection using Python - Geographic Information Systems Stack Exchange  ... View more

Can you select the move option when editing?  If you can then you should be able to move the object.  If not.... upload a representative personalgeodatabase with a a feature class that does not work (move)...make sure there is no sensitive data... and I and I am sure others will take a look at it further...  It is sounding like more of corrupted data problem.. than anything else.   Can you export the feature to a shapefile, add that to the map and move the object?  I am trying to trigger a definitive error.....  Right now it is a bunch guesses! ... View more

I have tried this .... and the requirement for editing and updating overwrites and recreates the table every time you want to edit.  For example, in a signs table, I want to move one sign... I would have to overwrite the complete table to update.  (Again this could be a user set up issue Me)... but that's what I have found trying to update a SQL Server and or SQL Sever Light DB with the product using standard license....  That is unworkable. ... View more

To do a quick test, in regards to a permission issue, try to: Outside of ArcMap, within your window system, open the mdb you were given by double clicking on it from windows file explorer (you will be opening it from the Windows MS Access program).  If you are then prompted for a password, or get messsage along the lines that it is read only then it has been secured.  If it does open without error or warning try to create a test table and or query.  If your able to do this then it is not a permissions issue. Another thought came to mind:  Open up Access and perform a database compaction  ... View more