Latest Contributions by RPGIS

Which language is this? I want to say python, but it is hard to tell from the looks of it. If it is python, then you would need to adjust your dates to be equivalent to the following: from datetime import datetime FromDate = <FromDateField>.isoformat(timespec='seconds') ToDate = <ToDateField>.isoformat(timespec='seconds') time = f"closingdate >= {FromDate} AND closingdate <= {ToDate}" # Query the feature layer query_result = tankers.query(where=f"trip_name = {'MCC'} AND {time}")   ... View more

ArcGIS Pro - 3.2+ Enterprise - 10.9.1 Arcade Expression Version - 1.0.0+ var Asset = $feature.assetnum var Location = $feature.location var Check = $feature.CheckWorkOrder var Query = 'location = @Location OR asset = @Asset' var WO = OrderBy( FeatureSetByName($datastore, "table.MaxWOs"), 'reportdate DESC' ) if ( Boolean( Filter( WO , Query ) ) ){ WO = Filter( WO , Query ) Console( First( WO ) ) } The view is created using a linked server so I wouldn't be able to post the definition for it here. ... View more

Hi @SouthCoastGIS, You can use: import arcpy from arcpy.da import Editor as Editing, UpdateCursor as Updating, InsertCursor as Inserting, SearchCursor as Searching ##with arcpy.da.Editor( Workspace/database ) as edit: ## with ( Searching( ), Inserting( ) , Updating( ) ) as cursor: ## for row in cursor: ## logic handeling ## cursor.updateRow/cursor.insertRow( row ) There is plenty of documentation on editor if you research into it. ... View more

Hi @asmith_tssw., Depending on the method, either python or arcade, you can easily achieve this. You can do something like this: Python: Code Expression: !Concatenation( FieldA , FieldB , FieldC, etc... )! Code Block: def Concatenation( FieldA , FieldB , FieldC, etc... ): Values = [FieldA , FieldB , FieldC, etc...] ConcatNonNullValues = ''.join([ x for x in Values if x is not None ]) return ConcatNonNullValues   Arcade: var ValueList = [ $feature.FieldA , $feature.FieldB, $feature.FieldC, etc... ] var ConcatValue = '' for ( var index in ValueList ){ ListValue = ValueList[ index ] if ( IsEmpty( ListValue ) == False ){ ConcatValue + ListValue } } return ConcatValue You can use several arcade functions to make the code above easier, but it depends on how you want to go about it. Feel free to play around with the code above. It should work for what you need or at least point you in the right direction. ... View more

Hi @SaraChowdhury, Have you tried using the dissolve tool to see if that would get you the information that you need? If not, then you can give that a try and then use a group filter to filter databased on matching attributes in a field. Another option is to use arcade to get a total for each unique attribute and update each record with the total for each matching attribute. var State = $feature.State var StateTotal = sum( filter( $featureset , 'State = @State' ) , 'Number of Household Members' ) Console( StateTotal ) return StateTotal The above code should work for what you need. You can use it to field calculate the total for each state and get the household totals. ... View more

Hi @LeighErik, You can simply create a join table, which would look something like:   Select AB.Fielda , CD.Fieldb, etc.. From ( TableName ) Alias (ex: AB) Join ( TableName ) Alias (ex: CD) On AB.IDField = CD.IDField *In this case it would be the zip code field* *Where clause*   Without knowing the full code this should help with what you are looking for. This will also allow for you to construct a single table by basically combining multiple tables using matching rows in a single field. The other thing is I am unsure of the number of tables you wish to do this with, but you can repeatedly join tables based on matching records in a specified field. ... View more

Hi @VPCPlanningZoning, Based on the information, if I have this correctly, is you are trying to identify the width of the forest using the stream to determine the average width of the forest. If that is the case, then you can easily split the polygon into several smaller polygons by dividing the polygon into several smaller parts, convert the layer to a polyline feature using the feature to line tool, split each polyline feature by the vertices, and then get all line features that are identical, and get the average lengths of the intersecting segments to give you a more accurate estimate of the average width with greater accuracy. ... View more

The Includes function or a for loop I believe could also work as well. Plenty of options for achieving similar results. ... View more

Another option that works as well is using contingent values. This will automatically limit values based on inputs of other values. ... View more

You can save your arrow design as a symbol layer and have it applied to the entire layer. When you edit the layer it will draw using that symbol layer. ... View more

In memory simply creates a temporary feature. The feature itself is unrelated to the actual feature that the data is created from hence in memory. The processing would be roughly the same, though it largely depends on the type of cpu that you are using. If speed is something you are looking for then you could check out threading and multiprocessing. ... View more

Try this:     var ID = $feature.NewID //Change to whichever id field var CurrentLength = $feature.Shape_Length// Change to length field var IDField = 'NewID' if ( IsEmpty( ID ) ){ ID = 1000 }// Specify starting id value var SQLFilter = IDField + ' = ' var CompareMatchLen = Max( Filter( $featureset , SQLFilter ) , 'Shape_Length' ) if ( CurrentLength <= CompareMatchLen ){ ID = max( $featureset , IDField ) + 1 } console( ID ) return ID This works in version 10.9.1. for Enterprise and 2.8 for Pro.         ... View more