20251028
16380700
1.0
FALSE
CreateFeatureclass C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb Trees_Plotted POINT C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees DISABLED DISABLED "PROJCS["NAD_1983_2011_StatePlane_Ohio_North_FIPS_3401_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192]];-118963900 -96373800 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # 0 0 0 # SAME_AS_TEMPLATE
XYTableToPoint C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted X_Coord Y_Coord # "PROJCS["NAD_1983_2011_StatePlane_Ohio_North_FIPS_3401_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192]];-118963900 -96373800 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision"
ExportFeatures Trees_Plotted C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_Geocode # NOT_USE_ALIAS "Field "Field" true true false 4 Long 0 0,First,#,Trees_Plotted,Field,-1,-1;Site_ID "Site ID" true true false 8 Double 0 0,First,#,Trees_Plotted,Site_ID,-1,-1;Address "Address" true true false 255 Text 0 0,First,#,Trees_Plotted,Address,0,254;Key_Blockside "Key Blockside" true true false 8 Double 0 0,First,#,Trees_Plotted,Key_Blockside,-1,-1;Area "Area" true true false 255 Text 0 0,First,#,Trees_Plotted,Area,0,254;Side "Side" true true false 255 Text 0 0,First,#,Trees_Plotted,Side,0,254;Tree_ "Tree#" true true false 8 Double 0 0,First,#,Trees_Plotted,Tree_,-1,-1;City_Managed "City Managed" true true false 255 Text 0 0,First,#,Trees_Plotted,City_Managed,0,254;Location "Location" true true false 255 Text 0 0,First,#,Trees_Plotted,Location,0,254;Land_Use "Land Use" true true false 255 Text 0 0,First,#,Trees_Plotted,Land_Use,0,254;Key_Species "Key Species" true true false 255 Text 0 0,First,#,Trees_Plotted,Key_Species,0,254;Diameter "Diameter" true true false 8 Double 0 0,First,#,Trees_Plotted,Diameter,-1,-1;Maintenence_Pri "Maintenence Pri" true true false 255 Text 0 0,First,#,Trees_Plotted,Maintenence_Pri,0,254;Maintenence_Type "Maintenence Type" true true false 255 Text 0 0,First,#,Trees_Plotted,Maintenence_Type,0,254;Failure_Size "Failure Size" true true false 255 Text 0 0,First,#,Trees_Plotted,Failure_Size,0,254;Condition_Wood "Condition Wood" true true false 255 Text 0 0,First,#,Trees_Plotted,Condition_Wood,0,254;Condition_Leaves "Condition Leaves" true true false 255 Text 0 0,First,#,Trees_Plotted,Condition_Leaves,0,254;Key_Wires "Key Wires" true true false 255 Text 0 0,First,#,Trees_Plotted,Key_Wires,0,254;Hardscape_Damage "Hardscape Damage" true true false 255 Text 0 0,First,#,Trees_Plotted,Hardscape_Damage,0,254;Root_Space "Root Space" true true false 8 Double 0 0,First,#,Trees_Plotted,Root_Space,-1,-1;Key_Project "Key Project" true true false 255 Text 0 0,First,#,Trees_Plotted,Key_Project,0,254;Observations "Observations" true true false 255 Text 0 0,First,#,Trees_Plotted,Observations,0,254;Notes "Notes" true true false 255 Text 0 0,First,#,Trees_Plotted,Notes,0,254;Inventory_Date "Inventory Date" true true false 8 Date 0 0,First,#,Trees_Plotted,Inventory_Date,-1,-1;Key_Staff "Key Staff" true true false 255 Text 0 0,First,#,Trees_Plotted,Key_Staff,0,254;Key_cboLookup1 "Key cboLookup1" true true false 255 Text 0 0,First,#,Trees_Plotted,Key_cboLookup1,0,254;Key_cboLookup2 "Key cboLookup2" true true false 255 Text 0 0,First,#,Trees_Plotted,Key_cboLookup2,0,254;txtCustom1 "txtCustom1" true true false 255 Text 0 0,First,#,Trees_Plotted,txtCustom1,0,254;txtCustom2 "txtCustom2" true true false 255 Text 0 0,First,#,Trees_Plotted,txtCustom2,0,254;X_Coord "X_Coord" true true false 8 Double 0 0,First,#,Trees_Plotted,X_Coord,-1,-1;Y_Coord "Y_Coord" true true false 8 Double 0 0,First,#,Trees_Plotted,Y_Coord,-1,-1;Removed "Removed" true true false 2 Short 0 0,First,#,Trees_Plotted,Removed,-1,-1;City "City" true true false 255 Text 0 0,First,#;State "State" true true false 255 Text 0 0,First,#;Zipcode "Zipcode" true true false 255 Text 0 0,First,#" #
CalculateField Trees_Plotted_Geocode City "Perrysburg" PYTHON3 # TEXT NO_ENFORCE_DOMAINS
CalculateField Trees_Plotted_Geocode State "Ohio" PYTHON3 # TEXT NO_ENFORCE_DOMAINS
CalculateField Trees_Plotted_Geocode Zipcode "43551" PYTHON3 # TEXT NO_ENFORCE_DOMAINS
Rename C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_Geocode C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_Final FeatureClass
Append 'Trees Plotted old' Trees_Plotted_Final NO_TEST "Field "Field" true true false 4 Long 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Field,-1,-1;Site_ID "Site ID" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Site_ID,-1,-1;Address "Address" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Address,0,254;Key_Blockside "Key Blockside" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_Blockside,-1,-1;Area "Area" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Area,0,254;Side "Side" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Side,0,254;Tree_ "Tree#" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Tree_,-1,-1;City_Managed "City Managed" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,City_Managed,0,254;Location "Location" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Location,0,254;Land_Use "Land Use" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Land_Use,0,254;Key_Species "Key Species" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_Species,0,254;Diameter "Diameter" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Diameter,-1,-1;Maintenence_Pri "Maintenence Pri" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Maintenence_Pri,0,254;Maintenence_Type "Maintenence Type" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Maintenence_Type,0,254;Failure_Size "Failure Size" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Failure_Size,0,254;Condition_Wood "Condition Wood" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Condition_Wood,0,254;Condition_Leaves "Condition Leaves" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Condition_Leaves,0,254;Key_Wires "Key Wires" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_Wires,0,254;Hardscape_Damage "Hardscape Damage" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Hardscape_Damage,0,254;Root_Space "Root Space" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Root_Space,-1,-1;Key_Project "Key Project" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_Project,0,254;Observations "Observations" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Observations,0,254;Notes "Notes" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Notes,0,254;Inventory_Date "Inventory Date" true true false 8 Date 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Inventory_Date,-1,-1;Key_Staff "Key Staff" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_Staff,0,254;Key_cboLookup1 "Key cboLookup1" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_cboLookup1,0,254;Key_cboLookup2 "Key cboLookup2" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Key_cboLookup2,0,254;txtCustom1 "txtCustom1" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,txtCustom1,0,254;txtCustom2 "txtCustom2" true true false 255 Text 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,txtCustom2,0,254;X_Coord "X_Coord" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,X_Coord,-1,-1;Y_Coord "Y_Coord" true true false 8 Double 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Y_Coord,-1,-1;Removed "Removed" true true false 2 Short 0 0,First,#,C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees.gdb\Trees_Plotted_old,Removed,-1,-1;City "City" true true false 255 Text 0 0,First,#;State "State" true true false 255 Text 0 0,First,#;Zipcode "Zipcode" true true false 255 Text 0 0,First,#" # # # NOT_UPDATE_GEOMETRY NO_ENFORCE_DOMAINS USE_FEATURE_SERVICE_MODE
DeleteField Trees_Plotted_Final City;State;Zipcode DELETE_FIELDS
CopyFeatures Trees_Plotted_Final C:\Users\barmstrong\Documents\ArcGIS\Projects\Trees\Trees_EGDB.gdb\Trees_Plotted_Final # # # #
CopyMultiple "C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\Trees_EGDB.gdb\Trees_Plotted_Final FeatureClass" C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde Trees_Plotted_Final "Trees_Plotted_Final FeatureClass tree_data.postgres.Trees_Plotted_Final #"
Rename C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Trees_Plotted_Final C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Perrysburg_Trees FeatureClass
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>location</field_name><field_alias>Tree Location</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>key_species</field_name><field_alias>Tree Species</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>key_wires</field_name><field_alias>Wires</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>observations</field_name><domain_name>ObservationID</domain_name></AssignDomainToField></workflow></operationSequence>
AssignDomainToField Perrysburg_Trees key_species ObservationID #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>key_species</field_name></RemoveDomainFromField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>tree_data.postgres.Perrysburg_Trees.area</field_name><new_field_name>tree_area</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>tree_data.postgres.Perrysburg_Trees.area</field_name><new_field_name>tree_area</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>tree_area</field_name><domain_name>Tree_Area</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>side</field_name><domain_name>Tree_Side</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>location</field_name><domain_name>Tree_Location</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>land_use</field_name><domain_name>Land_Use</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>key_species</field_name><domain_name>Species</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>maintenence_pri</field_name><domain_name>Work_Maintenance_Priority</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>maintenence_type</field_name><domain_name>Work_Maintenance_Type</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>key_wires</field_name><domain_name>Yes_No</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>hardscape_damage</field_name><domain_name>Yes_No</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>key_staff</field_name><domain_name>Work_Staff</domain_name></AssignDomainToField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>tree_data.postgres.Perrysburg_Trees</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow><workflow><EnableAttachments /></workflow><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>"
UpdateSchema C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Perrysburg_Trees "<operationSequence><workflow><AddAttributeRule><rule_name>GenerateID</rule_name><rule_type>CALCULATION</rule_type><expression>/*
where_clause (Text): A SQL Expression used to determine if the rule should continue(matches query), or return early
seq_infos (Array): Array of sequence dictionaries
where_clause (Text): A SQL expression applied to $feature to identify the sequence to use
description (Text): A description of the sequence, this is for informational purposes and does not affect the execution
prefix (Text): A string place before the sequence value, can be an empty string
suffix (Text): A string placed after the sequence value, can be an empty string
padding (Text): Pads the sequence number to a given length, can be an empty string. The format must such as '0000' for a 4 digit number such as 0005
sequence_key (Text): The key used in the get_sequence_value function to identify the sequence
separator (Text): A string used to join the prefix, sequence and suffice, can be an empty string
intersect_values (Dictionary): The parameters used to look up a value in an intersecting layer to get an ID to determine a unique sequence for rows
target_name (Text): The unqualified target class name
where_clause (Text): An optional sql expression to limit the results from the target class. Only sequences created at execution are available in the expression.
spatial_operator (Text): The optional string for spatial filtering. Intersects/Within.
search_distance (Number): The optional buffer distance to apply to spatial_operator.
search_units (Text): The optional units to apply to search_distance.
row_id_field (Text): The field in the intersected class used to determine the sequence used. This will be inserted after prefix and before sequence value. To change order see last line of rule.
order_by_clause (Text): The field used to order features found using spatial_operator
id_values (Dictionary): A Dictionary where the keys are the values(as text) from the field in row_id_field in the intersected layers and the value is the key of the sequence to use
*/
var rule_settings = {
'where_clause': null,
'seq_infos': [
{
'where_clause': '',
'description': null,
'prefix': null,
'suffix': null,
'padding': '',
'sequence_key': 'Tree_ID_1',
'separator': null,
'intersect_values': {
'target_name': null,
'where_clause': null,
'spatial_operator': 'Intersects',
'search_distance': null,
'search_units': null,
'order_by_clause': null,
'row_id_field': null,
'id_values': {
},
},
},
],
};
function get_sequence_value(sequence_key) {
return Decode(
sequence_key,
'Tree_ID_1', NextSequenceValue('Tree_ID_1'),
null
);
}
function get_feature_set(key) {
return Decode(
key,
null
);
}
function IsEmpty2(value) {
var type = TypeOf(value);
if (type == '') {
return true; // null
} else if (type == 'Boolean') {
return !value;
} else if (type == 'String') {
return IsEmpty(value);
} else if (
(type == 'Array') ||
(type == 'Dictionary') ||
(type == 'FeatureSet')
) {
for (var x in value) {
return false;
}
return true;
} else if (type == 'Number') {
return IsNan(value);
} else if (type == 'Point') {
return IsNan(value.x);
} else if (type == 'Multipoint') {
return Count(value.points) == 0;
} else if (type == 'Polyline') {
return Count(value.paths) == 0;
} else if (type == 'Polygon') {
return Count(value.rings) == 0;
} else if (type == 'Extent') {
return IsNan(value.xmin);
} else if (
(type == 'Feature') ||
(type == 'DateOnly') ||
(type == 'Time') ||
(type == 'Date') ||
(type == 'FeatureSetCollection') ||
(type == 'Portal') ||
(type == 'Function')
) {
return false
}
return null;
}
function not_empty(x) {
return !IsEmpty(x);
}
function get_unit_code(unit) {
// Converts unit string to unit code
if (IsEmpty(unit)) {
return
}
var u = Lower(Replace(Replace(Replace(unit, ' ', ''), '-', ''), '_', ''));
// US / INT suffix differentiates the unit code. If no suffix, then it defaults to US Survey.
var international = false;
if (Right(u, 2) == 'us') {
u = Left(u, Count(u) - 2);
} else if (Right(u, 3) == 'int' && u != 'point') {
u = Left(u, Count(u) - 3);
international = true;
}
if (Right(u, 1) == 's' && u != 'inches') { // plural
u = Left(u, Count(u) - 1);
}
return When(
// Metric
u == 'km' || u == 'kilometer', 9036,
u == 'm' || u == 'meter', 9001,
u == 'dm' || u == 'decimeter', 109005,
u == 'cm' || u == 'centimeter', 1033,
u == 'mm' || u == 'millimeter', 1025,
// US Survey / International
u == 'nmi' || u == 'nauticalmile', IIf(international, 9030, 109012),
u == 'mi' || u == 'mile', IIf(international, 9093, 9035),
u == 'yd' || u == 'yard', IIf(international, 9096, 109002),
u == 'ft' || u == 'foot' || u == 'feet', IIf(international, 9002, 9003),
u == 'in' || u == 'inch' || u == 'inches', IIf(international, 109008, 109009),
// Misc
u == 'dd' || u == 'deg' || u == 'degree' || u == 'decimaldegree', 9102,
u == 'pt' || u == 'point', 109016,
// Default
null,
)
}
function pad_string(val, pad) {
if (IsEmpty(pad) || IsEmpty(val)) {
return Text(val);
}
return Right(Text(pad) + Text(val), Max([Count(Text(pad)), Count(Text(val))]));
}
function apply_sql_spatial_filter(feature_set, options) {
// Applies optional spatial/attribute filters and OrderBy clause to feature_set.
if (feature_set == null){
return;
}
var spatialFilter = Decode(
Lower(DefaultValue(options, 'spatial_operator', '')),
'intersects', Intersects,
'contains', Contains,
'crosses', Crosses,
'envelopeintersects', EnvelopeIntersects,
'overlaps', Overlaps,
'touches', Touches,
'within', Within,
null
);
var geo = DefaultValue(options, 'input_geometry', null);
if (!IsEmpty(spatialFilter) && !IsEmpty2(geo)) {
if (!IsEmpty(DefaultValue(options, 'search_distance', null))) {
geo = Buffer(geo, options.search_distance, get_unit_code(options.search_units));
}
feature_set = spatialFilter(feature_set, geo);
}
if (!IsEmpty(DefaultValue(options, 'where_clause', null))) {
feature_set = Filter(feature_set, options.where_clause);
}
if (!IsEmpty(DefaultValue(options, 'order_by_clause', null))) {
feature_set = OrderBy(feature_set, options.order_by_clause);
}
return feature_set;
}
if (!FeatureInFilter($feature, DefaultValue(rule_settings, 'where_clause', null))) {
return;
}
Expects($feature, 'site_id')
if (!IsEmpty($feature.site_id)) {
return;
}
var input_geometry = Geometry($feature);
for (var i in rule_settings.seq_infos) {
var seq = rule_settings.seq_infos[i];
if (!FeatureInFilter($feature, seq.where_clause)) {
continue;
}
var seq_val = null;
var row_id = null;
// If there are intersect lookup details, get the sequence key by intersecting the layer, if not, use
if (!IsEmpty2(DefaultValue(seq, ['intersect_values', 'id_values'], {}))) {
// Convert the key to the featureset
seq.intersect_values.input_geometry = input_geometry;
var intersect_fs = apply_sql_spatial_filter(get_feature_set(seq.intersect_values.target_name), seq.intersect_values);
for (var feat in intersect_fs) {
if (IsEmpty(seq.intersect_values.row_id_field)) {
// one sequence for entire intersect class
seq_val = get_sequence_value(seq.intersect_values.id_values['']);
break;
}
// Text(null) evaluates to empty string
row_id = Text(feat[seq.intersect_values.row_id_field]);
if (HasKey(seq.intersect_values.id_values, row_id)) {
seq_val = get_sequence_value(seq.intersect_values.id_values[row_id]);
if (!IsEmpty(seq_val)) {
break;
}
}
}
}
if (IsEmpty(seq_val) && !IsEmpty2(seq.sequence_key)) {
seq_val = get_sequence_value(seq.sequence_key);
}
// Check if seq was found
if (IsEmpty(seq_val)) {
continue;
}
return Concatenate(Filter([seq.prefix, row_id, pad_string(seq_val, seq.padding), seq.suffix], not_empty), seq.separator);
}
return;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Generate ID using Database Sequences</rule_description><field_name>site_id</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>field</triggering_fields><triggering_fields>site_id</triggering_fields><triggering_fields>address</triggering_fields><triggering_fields>key_blockside</triggering_fields><triggering_fields>tree_area</triggering_fields><triggering_fields>side</triggering_fields><triggering_fields>tree_</triggering_fields><triggering_fields>city_managed</triggering_fields><triggering_fields>location</triggering_fields><triggering_fields>land_use</triggering_fields><triggering_fields>key_species</triggering_fields><triggering_fields>diameter</triggering_fields><triggering_fields>maintenence_pri</triggering_fields><triggering_fields>maintenence_type</triggering_fields><triggering_fields>failure_size</triggering_fields><triggering_fields>condition_wood</triggering_fields><triggering_fields>condition_leaves</triggering_fields><triggering_fields>key_wires</triggering_fields><triggering_fields>hardscape_damage</triggering_fields><triggering_fields>root_space</triggering_fields><triggering_fields>key_project</triggering_fields><triggering_fields>observations</triggering_fields><triggering_fields>notes</triggering_fields><triggering_fields>inventory_date</triggering_fields><triggering_fields>key_staff</triggering_fields><triggering_fields>key_cbolookup1</triggering_fields><triggering_fields>key_cbolookup2</triggering_fields><triggering_fields>txtcustom1</triggering_fields><triggering_fields>txtcustom2</triggering_fields><triggering_fields>x_coord</triggering_fields><triggering_fields>y_coord</triggering_fields><triggering_fields>removed</triggering_fields><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>GenerateID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Perrysburg_Trees <operationSequence><workflow><DeleteAttributeRule><rule_name>GenerateID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>
UpdateSchema C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Perrysburg_Trees "<operationSequence><workflow><AddAttributeRule><rule_name>GenerateID</rule_name><rule_type>CALCULATION</rule_type><expression>/*
where_clause (Text): A SQL Expression used to determine if the rule should continue(matches query), or return early
seq_infos (Array): Array of sequence dictionaries
where_clause (Text): A SQL expression applied to $feature to identify the sequence to use
description (Text): A description of the sequence, this is for informational purposes and does not affect the execution
prefix (Text): A string place before the sequence value, can be an empty string
suffix (Text): A string placed after the sequence value, can be an empty string
padding (Text): Pads the sequence number to a given length, can be an empty string. The format must such as '0000' for a 4 digit number such as 0005
sequence_key (Text): The key used in the get_sequence_value function to identify the sequence
separator (Text): A string used to join the prefix, sequence and suffice, can be an empty string
intersect_values (Dictionary): The parameters used to look up a value in an intersecting layer to get an ID to determine a unique sequence for rows
target_name (Text): The unqualified target class name
where_clause (Text): An optional sql expression to limit the results from the target class. Only sequences created at execution are available in the expression.
spatial_operator (Text): The optional string for spatial filtering. Intersects/Within.
search_distance (Number): The optional buffer distance to apply to spatial_operator.
search_units (Text): The optional units to apply to search_distance.
row_id_field (Text): The field in the intersected class used to determine the sequence used. This will be inserted after prefix and before sequence value. To change order see last line of rule.
order_by_clause (Text): The field used to order features found using spatial_operator
id_values (Dictionary): A Dictionary where the keys are the values(as text) from the field in row_id_field in the intersected layers and the value is the key of the sequence to use
*/
var rule_settings = {
'where_clause': null,
'seq_infos': [
{
'where_clause': '',
'description': null,
'prefix': null,
'suffix': null,
'padding': '',
'sequence_key': 'Tree_ID_Seq_1',
'separator': null,
'intersect_values': {
'target_name': null,
'where_clause': null,
'spatial_operator': 'Intersects',
'search_distance': null,
'search_units': null,
'order_by_clause': null,
'row_id_field': null,
'id_values': {
},
},
},
],
};
function get_sequence_value(sequence_key) {
return Decode(
sequence_key,
'Tree_ID_Seq_1', NextSequenceValue('Tree_ID_Seq_1'),
null
);
}
function get_feature_set(key) {
return Decode(
key,
null
);
}
function IsEmpty2(value) {
var type = TypeOf(value);
if (type == '') {
return true; // null
} else if (type == 'Boolean') {
return !value;
} else if (type == 'String') {
return IsEmpty(value);
} else if (
(type == 'Array') ||
(type == 'Dictionary') ||
(type == 'FeatureSet')
) {
for (var x in value) {
return false;
}
return true;
} else if (type == 'Number') {
return IsNan(value);
} else if (type == 'Point') {
return IsNan(value.x);
} else if (type == 'Multipoint') {
return Count(value.points) == 0;
} else if (type == 'Polyline') {
return Count(value.paths) == 0;
} else if (type == 'Polygon') {
return Count(value.rings) == 0;
} else if (type == 'Extent') {
return IsNan(value.xmin);
} else if (
(type == 'Feature') ||
(type == 'DateOnly') ||
(type == 'Time') ||
(type == 'Date') ||
(type == 'FeatureSetCollection') ||
(type == 'Portal') ||
(type == 'Function')
) {
return false
}
return null;
}
function not_empty(x) {
return !IsEmpty(x);
}
function get_unit_code(unit) {
// Converts unit string to unit code
if (IsEmpty(unit)) {
return
}
var u = Lower(Replace(Replace(Replace(unit, ' ', ''), '-', ''), '_', ''));
// US / INT suffix differentiates the unit code. If no suffix, then it defaults to US Survey.
var international = false;
if (Right(u, 2) == 'us') {
u = Left(u, Count(u) - 2);
} else if (Right(u, 3) == 'int' && u != 'point') {
u = Left(u, Count(u) - 3);
international = true;
}
if (Right(u, 1) == 's' && u != 'inches') { // plural
u = Left(u, Count(u) - 1);
}
return When(
// Metric
u == 'km' || u == 'kilometer', 9036,
u == 'm' || u == 'meter', 9001,
u == 'dm' || u == 'decimeter', 109005,
u == 'cm' || u == 'centimeter', 1033,
u == 'mm' || u == 'millimeter', 1025,
// US Survey / International
u == 'nmi' || u == 'nauticalmile', IIf(international, 9030, 109012),
u == 'mi' || u == 'mile', IIf(international, 9093, 9035),
u == 'yd' || u == 'yard', IIf(international, 9096, 109002),
u == 'ft' || u == 'foot' || u == 'feet', IIf(international, 9002, 9003),
u == 'in' || u == 'inch' || u == 'inches', IIf(international, 109008, 109009),
// Misc
u == 'dd' || u == 'deg' || u == 'degree' || u == 'decimaldegree', 9102,
u == 'pt' || u == 'point', 109016,
// Default
null,
)
}
function pad_string(val, pad) {
if (IsEmpty(pad) || IsEmpty(val)) {
return Text(val);
}
return Right(Text(pad) + Text(val), Max([Count(Text(pad)), Count(Text(val))]));
}
function apply_sql_spatial_filter(feature_set, options) {
// Applies optional spatial/attribute filters and OrderBy clause to feature_set.
if (feature_set == null){
return;
}
var spatialFilter = Decode(
Lower(DefaultValue(options, 'spatial_operator', '')),
'intersects', Intersects,
'contains', Contains,
'crosses', Crosses,
'envelopeintersects', EnvelopeIntersects,
'overlaps', Overlaps,
'touches', Touches,
'within', Within,
null
);
var geo = DefaultValue(options, 'input_geometry', null);
if (!IsEmpty(spatialFilter) && !IsEmpty2(geo)) {
if (!IsEmpty(DefaultValue(options, 'search_distance', null))) {
geo = Buffer(geo, options.search_distance, get_unit_code(options.search_units));
}
feature_set = spatialFilter(feature_set, geo);
}
if (!IsEmpty(DefaultValue(options, 'where_clause', null))) {
feature_set = Filter(feature_set, options.where_clause);
}
if (!IsEmpty(DefaultValue(options, 'order_by_clause', null))) {
feature_set = OrderBy(feature_set, options.order_by_clause);
}
return feature_set;
}
if (!FeatureInFilter($feature, DefaultValue(rule_settings, 'where_clause', null))) {
return;
}
Expects($feature, 'site_id')
if (!IsEmpty($feature.site_id)) {
return;
}
var input_geometry = Geometry($feature);
for (var i in rule_settings.seq_infos) {
var seq = rule_settings.seq_infos[i];
if (!FeatureInFilter($feature, seq.where_clause)) {
continue;
}
var seq_val = null;
var row_id = null;
// If there are intersect lookup details, get the sequence key by intersecting the layer, if not, use
if (!IsEmpty2(DefaultValue(seq, ['intersect_values', 'id_values'], {}))) {
// Convert the key to the featureset
seq.intersect_values.input_geometry = input_geometry;
var intersect_fs = apply_sql_spatial_filter(get_feature_set(seq.intersect_values.target_name), seq.intersect_values);
for (var feat in intersect_fs) {
if (IsEmpty(seq.intersect_values.row_id_field)) {
// one sequence for entire intersect class
seq_val = get_sequence_value(seq.intersect_values.id_values['']);
break;
}
// Text(null) evaluates to empty string
row_id = Text(feat[seq.intersect_values.row_id_field]);
if (HasKey(seq.intersect_values.id_values, row_id)) {
seq_val = get_sequence_value(seq.intersect_values.id_values[row_id]);
if (!IsEmpty(seq_val)) {
break;
}
}
}
}
if (IsEmpty(seq_val) && !IsEmpty2(seq.sequence_key)) {
seq_val = get_sequence_value(seq.sequence_key);
}
// Check if seq was found
if (IsEmpty(seq_val)) {
continue;
}
return Concatenate(Filter([seq.prefix, row_id, pad_string(seq_val, seq.padding), seq.suffix], not_empty), seq.separator);
}
return;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Generate ID using Database Sequences</rule_description><field_name>site_id</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>GenerateID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Perrysburg_Trees <operationSequence><workflow><DeleteAttributeRule><rule_name>GenerateID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>
UpdateSchema C:\Users\Administrator\Documents\ArcGIS\Projects\EGDB_Connections\tree_data.sde\tree_data.postgres.Perrysburg_Trees "<operationSequence><workflow><AddAttributeRule><rule_name>GenerateID</rule_name><rule_type>CALCULATION</rule_type><expression>/*
where_clause (Text): A SQL Expression used to determine if the rule should continue(matches query), or return early
seq_infos (Array): Array of sequence dictionaries
where_clause (Text): A SQL expression applied to $feature to identify the sequence to use
description (Text): A description of the sequence, this is for informational purposes and does not affect the execution
prefix (Text): A string place before the sequence value, can be an empty string
suffix (Text): A string placed after the sequence value, can be an empty string
padding (Text): Pads the sequence number to a given length, can be an empty string. The format must such as '0000' for a 4 digit number such as 0005
sequence_key (Text): The key used in the get_sequence_value function to identify the sequence
separator (Text): A string used to join the prefix, sequence and suffice, can be an empty string
intersect_values (Dictionary): The parameters used to look up a value in an intersecting layer to get an ID to determine a unique sequence for rows
target_name (Text): The unqualified target class name
where_clause (Text): An optional sql expression to limit the results from the target class
spatial_operator (Text): The optional string for spatial filtering. Intersects/Within.
search_distance (Number): The optional buffer distance to apply to spatial_operator.
search_units (Text): The optional units to apply to search_distance.
row_id_field (Text): The field in the intersected class used to determine the sequence used
id_values (Dictionary): A Dictionary where the keys are the values(as text) from the field in row_id_field in the intersected layers and the value is the key of the sequence to use
*/
var rule_settings = {
'where_clause': null,
'seq_infos': [
{
'where_clause': '',
'description': null,
'prefix': null,
'suffix': null,
'padding': '',
'sequence_key': 'Tree_Seq_ID_',
'separator': null,
'intersect_values': {
'target_name': null,
'where_clause': null,
'spatial_operator': 'Intersects',
'search_distance': null,
'search_units': null,
'order_by_clause': null,
'row_id_field': null,
'id_values': {
},
},
},
],
};
function get_sequence_value(sequence_key) {
return Decode(
sequence_key,
'Tree_Seq_ID_', NextSequenceValue('Tree_Seq_ID_'),
null
);
}
function get_feature_set(key) {
return Decode(
key,
null
);
}
function IsEmpty2(value) {
var type = TypeOf(value);
if (type == '') {
return true; // null
} else if (type == 'Boolean') {
return !value;
} else if (type == 'String') {
return IsEmpty(value);
} else if (
(type == 'Array') ||
(type == 'Dictionary') ||
(type == 'FeatureSet')
) {
for (var x in value) {
return false;
}
return true;
} else if (type == 'Number') {
return IsNan(value);
} else if (type == 'Point') {
return IsNan(value.x);
} else if (type == 'Multipoint') {
return Count(value.points) == 0;
} else if (type == 'Polyline') {
return Count(value.paths) == 0;
} else if (type == 'Polygon') {
return Count(value.rings) == 0;
} else if (type == 'Extent') {
return IsNan(value.xmin);
} else if (
(type == 'Feature') ||
(type == 'DateOnly') ||
(type == 'Time') ||
(type == 'Date') ||
(type == 'FeatureSetCollection') ||
(type == 'Portal') ||
(type == 'Function')
) {
return false
}
return null;
}
function features_to_featureset(features) {
// Converts features array to feature set.
if (TypeOf(features) == 'FeatureSet') {
return features;
}
var rows = [];
var feat, feat_dict;
for (var i in features) {
feat = features[i];
feat_dict = {
'__oid__': i + 1, // Incrementing OID field.
};
for (var j in feat) {
feat_dict[j] = feat[j];
}
Push(rows, {
'attributes': feat_dict,
});
}
if (IsEmpty(feat)) {
return;
}
// Add OID field to schema.
var feat_schema = Array(Schema(feat).fields);
Push(feat_schema, {
'name': '__oid__',
'type': 'esriFieldTypeInteger',
});
return FeatureSet({
'fields': feat_schema,
'features': rows,
});
}
function count_features(features, where_clause) {
// count features that match where_clause
if (IsEmpty2(features)) {
return 0;
}
if (IsEmpty(where_clause)) {
return Count(features);
}
var fs = features_to_featureset(features);
if (IsEmpty(fs)) {
return 0;
}
return Count(Filter(fs, where_clause));
}
function not_empty(x) {
return !IsEmpty(x);
}
function get_unit_code(unit) {
// Converts unit string to unit code
if (IsEmpty(unit)) {
return
}
var u = Lower(Replace(Replace(Replace(unit, ' ', ''), '-', ''), '_', ''));
// US / INT suffix differentiates the unit code. If no suffix, then it defaults to US Survey.
var international = false;
if (Right(u, 2) == 'us') {
u = Left(u, Count(u) - 2);
} else if (Right(u, 3) == 'int' && u != 'point') {
u = Left(u, Count(u) - 3);
international = true;
}
if (Right(u, 1) == 's' && u != 'inches') { // plural
u = Left(u, Count(u) - 1);
}
return When(
// Metric
u == 'km' || u == 'kilometer', 9036,
u == 'm' || u == 'meter', 9001,
u == 'dm' || u == 'decimeter', 109005,
u == 'cm' || u == 'centimeter', 1033,
u == 'mm' || u == 'millimeter', 1025,
// US Survey / International
u == 'nmi' || u == 'nauticalmile', IIf(international, 9030, 109012),
u == 'mi' || u == 'mile', IIf(international, 9093, 9035),
u == 'yd' || u == 'yard', IIf(international, 9096, 109002),
u == 'ft' || u == 'foot' || u == 'feet', IIf(international, 9002, 9003),
u == 'in' || u == 'inch' || u == 'inches', IIf(international, 109008, 109009),
// Misc
u == 'dd' || u == 'deg' || u == 'degree' || u == 'decimaldegree', 9102,
u == 'pt' || u == 'point', 109016,
// Default
null,
)
}
function pad_string(val, pad) {
if (IsEmpty(pad) || IsEmpty(val)) {
return Text(val);
}
return Right(Text(pad) + Text(val), Max([Count(Text(pad)), Count(Text(val))]));
}
function apply_sql_spatial_filter(feature_set, options) {
// Applies optional spatial/attribute filters and OrderBy clause to feature_set.
var spatialFilter = Decode(
Lower(DefaultValue(options, 'spatial_operator', '')),
'intersects', Intersects,
'contains', Contains,
'crosses', Crosses,
'envelopeintersects', EnvelopeIntersects,
'intersects', Intersects,
'overlaps', Overlaps,
'touches', Touches,
'within', Within,
null
);
var geo = DefaultValue(options, 'input_geometry', null);
if (!IsEmpty(spatialFilter) && !IsEmpty2(geo)) {
if (!IsEmpty(DefaultValue(options, 'search_distance', null))) {
geo = Buffer(geo, options.search_distance, get_unit_code(options.search_units));
}
feature_set = spatialFilter(feature_set, geo);
}
if (!IsEmpty(DefaultValue(options, 'where_clause', null))) {
feature_set = Filter(feature_set, options.where_clause);
}
if (!IsEmpty(DefaultValue(options, 'order_by_clause', null))) {
feature_set = OrderBy(feature_set, options.order_by_clause);
}
return feature_set;
}
if (count_features([$feature], DefaultValue(rule_settings, 'where_clause', null)) != 1) {
return;
}
Expects($feature, 'site_id')
if (!IsEmpty($feature.site_id)) {
return;
}
var fs = features_to_featureset([$feature]);
var seq_val = null;
var input_geometry = Geometry($feature);
for (var i in rule_settings.seq_infos) {
var seq = rule_settings.seq_infos[i];
if (count_features(fs, seq.where_clause) == 1) {
var seq_val = null;
// If there are intersect lookup details, get the sequence key by intersecting the layer, if not, use
if (!IsEmpty2(DefaultValue(seq, ['intersect_values', 'id_values'], {}))) {
// Convert the key to the featureset
seq.intersect_values.input_geometry = input_geometry;
var intersect_fs = apply_sql_spatial_filter(get_feature_set(seq.intersect_values.target_name), seq.intersect_values);
for (var feat in intersect_fs) {
var row_id = Text(feat[seq.intersect_values.row_id_field]);
if (HasKey(seq.intersect_values.id_values, row_id)) {
seq_val = get_sequence_value(seq.intersect_values.id_values[row_id]);
if (!IsEmpty(seq_val)) {
break;
}
}
}
}
if (IsEmpty(seq_val) && !IsEmpty2(seq.sequence_key)) {
seq_val = get_sequence_value(seq.sequence_key);
}
// Check if seq was found
if (IsEmpty(seq_val)) {
continue;
}
return Concatenate(Filter([seq.prefix, pad_string(seq_val, seq.padding), seq.suffix], not_empty), seq.separator);
}
}
return;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Generate ID using Database Sequences</rule_description><field_name>site_id</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>GenerateID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
Trees_Plotted_Final
002
Server=EC2AMAZ-8V72VPV; Service=sde:postgresql:EC2AMAZ-8V72VPV; Database=tree_data; User=postgres; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_NAD_1983_2011
Linear Unit: Foot_US (0.304801)
NAD_1983_2011_StatePlane_Ohio_North_FIPS_3401_Ft_US
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WKT>PROJCS["NAD_1983_2011_StatePlane_Ohio_North_FIPS_3401_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",6549]]</WKT><XOrigin>-118963900</XOrigin><YOrigin>-96373800</YOrigin><XYScale>3048.00609601219</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.00328083333333333</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103129</WKID><LatestWKID>6549</LatestWKID></ProjectedCoordinateSystem>
20251028
15513600
20251028
15513600
Microsoft Windows 10 Version 10.0 (Build 26200) ; Esri ArcGIS 13.5.3.57366
Perrysburg_Trees
Perrysburg_Trees_Fix
MapServer
File Geodatabase Feature Class
dataset
EPSG
8.2.10(10.3.1)
0
Simple
FALSE
0
TRUE
FALSE
Trees_Plotted_Final
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
Field
Field
Integer
4
0
0
Site_ID
Site ID
Double
8
0
0
Address
Address
String
255
0
0
Key_Blockside
Key Blockside
Double
8
0
0
Area
Area
String
255
0
0
Side
Side
String
255
0
0
Tree_
Tree#
Double
8
0
0
City_Managed
City Managed
String
255
0
0
Location
Location
String
255
0
0
Land_Use
Land Use
String
255
0
0
Key_Species
Key Species
String
255
0
0
Diameter
Diameter
Double
8
0
0
Maintenence_Pri
Maintenence Pri
String
255
0
0
Maintenence_Type
Maintenence Type
String
255
0
0
Failure_Size
Failure Size
String
255
0
0
Condition_Wood
Condition Wood
String
255
0
0
Condition_Leaves
Condition Leaves
String
255
0
0
Key_Wires
Key Wires
String
255
0
0
Hardscape_Damage
Hardscape Damage
String
255
0
0
Root_Space
Root Space
Double
8
0
0
Key_Project
Key Project
String
255
0
0
Observations
Observations
String
255
0
0
Notes
Notes
String
255
0
0
Inventory_Date
Inventory Date
Date
8
0
0
Key_Staff
Key Staff
String
255
0
0
Key_cboLookup1
Key cboLookup1
String
255
0
0
Key_cboLookup2
Key cboLookup2
String
255
0
0
txtCustom1
txtCustom1
String
255
0
0
txtCustom2
txtCustom2
String
255
0
0
X_Coord
X_Coord
Double
8
0
0
Y_Coord
Y_Coord
Double
8
0
0
Removed
Removed
SmallInteger
2
0
0
20251028
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAIABJREFUeJztnedy4+mV3g9yjgRJMGeyc5rOMz1R0kra1a5lf9jy1latv7rK
t+DyLfgCtsrlKtd+sFZar6W1NJJGo0k93dO5m93NnDNBggSRo+s5aHDQJEACJEASwPlNoYZNMIAA
/s978lGnUqkUVSQpWtyYpW9G/kC+0AZ/Rq8xUDKVJLvRyf9f3pynDlcv2Y0uml2foEBkiyLxMPlC
XmqwNFMiGeevy6BRaelMy2U633aVtGp93t+8sjlP3479iUw6C3//3Pokf77e4qYrXe9SvaWJtGrd
ETwHlUE8EaPXC0/p2cx9isYjeb/OrLfya4KvcZob6Fr3++S2tR7pY61U5tan6M+v/42i8TDFElHa
DHlxiZBCoaD1wCpd7/mQGqxNdKXjNhm0JqpU1FSxKMiks7I4BCJ+fhFSlKJw2EcrvkWyG+uoyd5O
W2Eff7Xd4KSRpRe0urVEyWSCv96ktRBlCZZOo6cGa3NesYqzwCVoZn2C1vwrfMtmPeChBxNfkkVv
pw9O/4TUSk2Zn4PKAAfHq/knOcUKwm7UmkivMdLq1iIplSpymuppbWuFvh39jH5+9R+O5TFXGjaD
g7rq+ygSi9D4ymuaWRsn2CJtzi6+T6VQ0fTqKOnVBmqr6yaXxU1KhZIqjQoWrPSJfLX7Dp1pvcxP
fjAaoD+8+Be+byO4Rlc63yWNWksKUtCUZ4T8YR8FI34y66x86rvtrfx/z9Yyn+zBSIAvmhZnZ84X
c2Vzge6Nfca/Jxf4Gev+Vb69nGuki+03yv4cVAKwbHHbiUFrJIPWTC9mH/D9oViAhetsyzvkNLt2
HQjC3tfCxY6bbP3r3ngadeYGMupMlEgmyBvw8HsdB8fY8iu61HGTBpouUKVR0YIFUYFbhhuwJWJ0
tft9WvMv0/nWq1RnaWSxWvDOUCQWJqPOTAqFklY3F2jdv0JfDf+OuuoHqKfhNJ9GG0EPeQNrFIoG
yaQz7/p964EVNrUL8aIteltZ/uZKBG4J/oMFnPk33G+j1kyPpr5mizgDXqe7o3+g230/IJvBWcBP
T1E4FiaVUsUWLX52LaJQKGh0aZCeTH3LzwPEKhj101Y4HS7BU++yNFK9tYnf41uhTapEKlqwdqJW
aVioQPYbF6eMy9xIN3s+5gsEsS6dWs8u5eTKML2Y+Y5UKg1d7rhFLc4uyveeP918ma0nnFB7gTdF
q7OrtH9cBdNe10tnWj004xkjpVJJ51qv0uz6JM2tTZBna+Wt1w+uC1xvuIqwnnMRigZoM7ROBo2J
XfxX849pI7jOMa/TzZeoVjnXepVezz+jcCzIcVo8h62uXorFo+xqw8N4OfeI3PY2Ot92rSyPAYcS
DqdyUVWCBXKdsDipr3Tdpmcz35FObSC3tZUWN2bo0eRXHLC36K1sRo8svmCrDRYXTv+d4MRa2pzb
9zGkUkl2Z5rsbSX7uyoZxAavdNyizvp+0qo05DDVc5wQF5Bea2A3HRYt4od4fSBIHXW9OUUfzy2C
9yNLg5xcwc8Ix0JsOc+uTZDD6CKnub4mkx5qpYYabM18MED8mx3tNLTwnJY2Z6nT1U+Tq8Ms8Ijf
Xmq/yc8TPj6MwGSSVrhuIJKZBFijrYWt6FJTdYKVT8RgTeGCcJpcZDfV0ejyS3b9HGYXbQTW2M/3
KJZpcnWEhhefU5uzm4OT2cx7p/kC2Q/ExPCmcdta+EISiDRqHTVam7efihZHB02svCar3k46lY6a
HO0cWwRWg5184Q2+GDKxRLjh/oiP1raWaXxlaDv2mC1kCxsz/Pp0N5yiU80X2ZKuJbwBDyc44D10
NQzwcwRvAAdtttsdi0fot89+QT2Np6jPfY5aHLljtvuBgwJuaCarO7TwjF8jSqXog9M/5eut1NSE
YIH0G3yJhQnxDpzODlMdnziB8BbFE1HSaHRsDaz6FjlLBdcu+00fjgaL+p21Gk8pBFwgLY4uPumj
iSgFwr7tGBesL4hX9smP7OzjyW9YlCKxUM6fiewvki2Dcw+ps76v5gRrzjvJ4oGDctozRs9nv2P3
cCdwucdWXvF1gJghnmuHyVX07/OHN2liZYjdca1aywZAhidTd+lMyxV2PzWq0mXLa0awcELDRIWI
ILW7EVrnJxJBd7gPCNTjhdwMerkUAm/2VPL7kgcAvx8BfqSNYSEgDrO0Mbt9/3ZpRTTEsTCUXgi5
gctyqvkC32C5Di085fKUsy2XqcnRwVYCLqjt14+IXFY3TXlG931K8TqUwx056agUKr4h+zq8+IK2
QmkrNReoGQR4ng7iPuNgeDT5zXYmNxSNv3U/XlPcEAZ4f+DH/HqXgpoRLJQ3QHDg5vkjW9TlGeW4
lce3TMOLz7gEYnR58M2pnGLrCxZXNriA+txnqafxNFsIcC1hmSEl32BtoWvddzj2laQUaWvwgjko
EH9ktWBRwcLNBocILkK1Us2uHrJgKB/Zi676/pqzrsDZ1nfIbnKxJ1BndrN1hXosiBbKRcz6dDZd
rzZyXBdC1ezoyBmv3Qt4KV8O/Y49lkLc1FKe2zUjWAAvEIroYDZbDQ56OPEVPZu5x6YsXI7b/T8k
lVJNqWSCljbmaNE7w9XBELZsMv5+q6OTyxfworTX9fD3CgcjIzCIRaEbIZaIcTAeLiCq3WERoKMg
uY9YAcS24GYaavD1aHF0cPgDbjEKmG1GJ4s9Eh1470M8sl1tJDgi8RALWqHg4MbBX4hgIfiOA6dU
1NwrCrfj/vifOZuBk9pisLGbh3+PLb2k0y2XKaFIUltdDwdw0dIDXxwxr50goI6KetyE0pBIJWna
M07TnlEO4PqCXlqwNrFVO78+zffvB4QNwflaLS0JxYK0vLnAGVhkW+GOcSXcjpgqDm609HS4+ooS
rExiZCdwLzkkEgtRvaWRrzWEXEqZeKo5wbIaHfzEoucK9Vl4Mg1aA/U1nSOT1szxj8nVIc4WXum8
zafD1OoIVwYL5QWW1YuZBzS9NsZClQnCIwmCYkdYu0qFghIFdL8W6+ZUE4lknPsJIVL7xafggiNg
XtzPT9DI4mDOsMuMZ5x/N7yOJlu6fAhWFqy8UlBzggWhQqwKZQeL3jmKJ2Ps4j0Y/4JbG1ABjwwL
TgmYvP/+2n+iWCJ/w65QOpDlQ9Z2M7j+9udTSbYOehvPUm/jGfIGPeyO3x//YtstgRWBRndYyrB4
0apSq1gNDrZIIfgo42mwtdBXQ79762tQ9Q7XGZYSSn6KI5Uz++j1eziTG46H+OejzQ2CibhvYV0L
+1NzggW3IhD2UzQeS1cC2zrJZXZTMpWihY0pziCinAH1LChmxMUytvyaA/XIXDVYmqjN1cMfC6UF
MUCb0cGncq77YBFnpjfgdcFkjcG5Rxx/RP9hf9M5zuwqlMqyVlufdJQKJZ1qukAD7vNc4Q4XER0A
OIjVKjV3BLQ6uymRSic0srOxhaHgYD1KIvC9Jr2VLDor/X7wVxRJRPj3q5QaPoAeT9+lRnsr3ez5
qCRTImpOsPCk3ej5kCc3oNkZcZK7Y3/k2h+NUsNtDAigozH0bMsVbnRGYBItPGBY8YIuhK7RO13v
HfefUnVAePzh3U3SIBjZ4owuihFxQeDW3TDAwXiDzkRaVdr1URR98VUnCoVyu8XMoDHSpY5bHJdF
zBZWFQRdRQd7riBSaOxHjBCTNnDwf/r8l3yIwAJGIgoxX1hauKbwu0o1uaSmBAsVv5ja0FbXxXUk
aAydXR+nLtcANzXD94cZi/qRn1/7BzaZMbkhu9YKWSzcjxRyLabOy4lSgdEyLlIrVbTsW+CDAq4g
2nVQM4f6IsWOr0cWTNgfPHetzk4qFXjvIyOZOWjg9qFQFeUpyE6y5UUWPljY2i2RwVtTgoVTGCd1
RnQQCETLAtw7vKCrviWKxqMcA0CzNIK/ODFwimSPlIGpi/YGEaxy1Mpd5UwgYlNo1IUrCHcGMSlk
c6XV6eSBgwNDAiFgcEEz7jhP6EilOJkST8RLUsxbU4KFwOyNno/of9//RxqcfcjZC1TqotAOrQnw
yxEsbLS2cg0Qegw/ff7PbEoj6wQLDSc+5mhZcqR1hcORLhxNW61wyzNlCZU4aK7WONN8+c2BH3kr
IA8xM+ttUul+EPBkPp25x0WhJr2Z41cucwN5/MvsIiLYjibO++Ofk0Kp4PhIWBOiaCLCQV1kFBED
q+URJkdJPqFCrATuu/JAAWOhHODa+dnlv+O4GYYEIlt7jsMmRs5WlqqfsKYsLAQHMUNJpVJTu6uX
A4IQJWQ7JlaHuO8JLqPb3sJfqyAlLXin+aKAm4giPAQvJW5ytOANH42F2d1ABTyyiDjN68z1XPRY
i6NkTiKZtqpzrdcomcJMs9Jn0mtKsGAhITay4kPJgpU2Ah4KxULUbG+jD079hGzGOm4Yhes3uTLC
tVgogoNgoXARbsq8d4pPEVwowtEA1xxLLNILKqJccgK3Ay49psraVXXiNp4gUDpRLmmpKcFChS4G
8EGEUECKuhS4FxAxBHR1vAhhiVtD4C5mRiHj+1BQCiFDUSOyh0adZbvjXSgfODQgVhjYh2RHNpj+
ioJIuPE3ez8u6RgT4WRSU4IVivjpVNNFnig6sjxIU6ujPGnBYayjdlcPT6t8Pf+EBW3n3HZsxIFA
+UKbnMZF5uMgLG/OcSwNG31KNXKjWsH4nhnPKI0sveTM7k7wOiFpggwVpsbCXReqm5oSLARpUYcV
iUe4Yv3v3/0v6WmkWgTgt7hW5GrXHa6mfjj5NXexo6YErgcyVsu+RWqwuikUCZJNby84/oIZW0+n
v2URhDuDz77TfYfH1opVsNfrpaSJ1eFtsYI1jOcQn4d7vxXe5EJfrKxCHV32hFKhOlHXWuMzLBsE
bTODx1DfA9HAAD8EDbmKWqnkxudAdIsarS2cRfSF1rnQFIWNPLKjAOsIYoWYGGbFY4JA9l4+9FyF
IgGe0SWTSXPTaGumfvd5rseCUMEVR+wK9W8QKJ61hA1FBhu36cjzWP3UlGABtOVgxhKyfxAdzG7H
sL6vhj/lqQBqDXoJm9nqGl56wcWjaNPRq/VcI4TGWlwchfRFZS4yWHU7l4jCFZW9e/tbxJlxyOiH
W/EtcBxxJziAsMoNhcGojxMr6+SC+kYcLAftK6w5wcJuQnSyo00Bb+xM6vV6zwf0r4/+F6ViQX7j
I0aFqmu4bRhWhqp4pNQBZjXdG/ucXUXUmuRLq/M4Zo0h7wAzNPoK+UGbFMb8QNjxca4JAWDNv0rf
jv6Rg/JopSrH8gPh4CDWiIMbU3gxXjy9ku0DNhSKpeYEK1NRvXNgGSrd4QY+nrpLoWSQt65c7/mQ
+9ngkuB+tOm8mH1IT6fvceAdAXQ04OYTLFhYmA8P6yAXS2/iWTL7PTeoj4OFBcHKrI/KB8pTkFHc
ackKxwviiosbszzdF5l3HCq4LvA6IV7MM86KKP6tScHK534gy5SdacKTPb78iit3AdLrSKVn349d
h5jlnrHWst0R3A+rAJYWRC1zMaEfTqVQcuwMFxp6FYXdoAUKxbwofEPgHQKPRnTEBrm5Fr2FpOAZ
+rf7PmELGAW+wska5wSxQidJNnDvH05+RXcGflyUpyGCtcfpjiA76n8yZItVBgjaOgL2agNdaL/+
1lheuJEooYB1htP/1dxjNo/hsmCBRXoBgIhVPuCaf3L2b9gdxM47BOB/P/hL0qh07E5c63qf45DI
GMLNcJrqa3JbzklGpVRyvDYXGENTbJeCCFYOkH16Pf+U63sKWZyKKnigXdRzEWO2CCELmZl+iTov
lEpAsKSdpFDSpSDYf4fDANuNYJnigECdFlxzTHRAMBdjlZvt7RzHEk4GGIzJLt/bNb8MDhq8fsUg
gpUDnNZY611scWgo6ueYVz6rqd4qlfHFgjVfWCgBUBqCpAms36AiwFbrTjJz4IWTAVzBfItvMUAT
G36KQQQrB3aj40BTANBYjemOQumAi9fZMLA90A9WFuracqHV6DmuJZwcYPFeaLvORsDi5izPkYMb
jxq7ZntH0eUNIlg5wA63C+036N7Ynwp+IhGnutn7EVsAQulAEqMLpSXObg684yDB50aXXqbvqx+g
K13vsvuO2rmDrFwXyofTXM83gNds2TdH51uvcZgE2cJi29NEsHKAwDgqqYsBGUEsZDVozTKjqcQg
y5rdwtTTcIonxFp0NmpytLMLLsmLkw/GKON2GESwcoBYycTy66KeSExxeDT1Nd3u+4Gk1stMo601
XRyq4PWg5f51wglCBCsH8LcR7C0WZBSRwpVaoPIjs91rExGsHNgM6aA7BsYVA5qiRawEoXyIYOWg
u+EU1/6gtAHNtNhPiDqg2bWJt9LmyGClhS3BdVXYPCxZKkEoHyJYebjV9wkvm0BFOkBWA5NJM+u+
0IbzTudtjqeg1gTZDlhmmNGEDTuyHEEQSo8I1h5kxAogyItSB4hWNBGlNmcXmXVWnpXltrXQ8uYC
fT37e7a6MOOqyd52oBcExZDIOErWSxB2I4JVBJiDBUFBbAutIQ8mvth2G9EakumZ4uZmpZp3HBYy
mwkd7KgjwmSHqdURLpDEpAh8vyAI3yOCVSSYbwULCDGuZR+2t6THmmQzvz5Jq74F6m48zSM00AS9
F3Apv5v4gpurM/Pkvxj6f3S9+wO21GT2uyCkEcEqEogVZmY9n7m/59dAxCZXhsltbUmPSMkDGnif
Td/jcRs767oeT31D7/b/SCwtQXiDCNaBSJFOrd+3ORptOhipvBc2g33XrKAMcCvFuhKE7xHBKhLE
pLrrB7gaPuLfLVgob6gzN7IbiO3SWJCwF5FYuhk016RMXoiBra2CIDAiWEWC+BKWrWaP7MXMd2zX
wYIEuINz6xM0tz5FDrOLa7RgKeUD1hUC9rmAiIVjYbIain2UglCdiGAVSerNjOrMHJ9MdfsvH/4P
XrSK+eO4QWwgXudar7LI5VtBhR2IKINA4zQC9Zmm6676fnYpzTIuRahhIvEwJRLx7SkoIlgHAOKD
wlA03vY1nqXfPP2ndNaQl0qkl1yAee80ffr8n3kjD1aH5coWwmW81v0+f4xKeqwEw8wnjE0RhNoh
xf27uHYy3SP3x7+goYWnvJ3qvf4fpfeBHvfDrDQw7vVyx222puKJOFtT6e0338ewrHo7nwyoeF/x
LdLd0c/oZu/HVGeu37WtJxu4lrgJQq3hC21yaY9OreM9CFOeUZ7jDzIlRPBkRLAOgNVgo1PNl+jV
/GMOvmO4HCrgETzvcPWxmwdrCm08KP7EFAds3EEV/LWuOzLkTxB2MLzwjGY8Y/zx/PrUrtV42LGA
kcoiWAdCwdk7WEOv5p/ylEvEmqxGB0XjUZ5hPbj0klZ889TnPkeReISD9Ga9hZrtbbzIVUFKWa0u
1Dz+sI+9lJHll9vPRaZfN5tMbFgE6xDAz4bvjfKDBlsrb8QZXRqkQHiLXsw95Puezz7kGBUWRk56
RrjodHZ9gnoazlB7XY+IllCzTKwM0bOZ+yxQ+RZV7EQE6xDZQvT9haNBDhSGolv0cu4x9wPCVUQM
C0KWShEHDgeaztPo8kt6Mn2XfXFfcINjWmb93nVaglCtGLQmDrQXKlZABOvAKEit1PCYXoiTXmvk
RZ44NfBvZAXrLY20FdqggaYL2wWgmGaKGzIeslZdqGWa7G3UYGkif3iTS38KQQTrEKUNWIDgDXpo
cPYhBSI+Wtla5I07KCytNzdylgP1VTB5m+ztb2USEZiH6AlCLdPi7OSMYCJV2HRfEaxDgAwg4lNw
8db9K1zmgBgWwJYX1JMg0A6BwtysbHfSF/IWPYJZEKoJhFOQESxm+7MI1iFA7Aq1VmeaL9O/PPqf
XLHe3XCaewlRsf7J2X/HooQG6GzBiiViPEoGQXlBqFXmvVO0sDFdsDsIRLBKAOqvLHobhWNBGpx7
yCvp21zdtLQ5Rwvr07TmX2aRygCRc5obSLHPnCxBqGbiyTglk8mivkeumBIwsfKaq3EhWs2Odp6D
FU/GqN99nha8M9tihUC7zeCkWCLCAXqtSluKXy8IFUmduYEc5npa3pjj5BX2JmCV/c6BmNmIYB0S
BNVRSwKwgAL1VmjDSfcbqulmz0dczoA41vsDP+Zqd5jBLrM7nc412A/7EAShInFZ3BwDnlwZIqVC
xYXY8EpezD54K4OOkAr6CaPxsAjWYUG5QvaoGfQOEi1u15lgWYVJZ+bJDYhn/fb5L3j2+6mmC9Tf
dO7Qv18QKhn05OKWAfsRsN8ANY4qhYp63We5txDiBs9ELKxDotMYaKD5Ag0vPE8/4Xobz31HaYPd
6OSeqEdT33BBKYLsaEUAI0uD9M3IH+hSxy0ueUBWURBqHaPWxF5Ju7Obl7lgcgm8E6BSGkWwSsHt
vh/wE7wWWKV2Zw85zfX0myf/xFXsDye/5PlZyCgivgVg7sLMxWqwPw7+H3qn6z262H6jJI9FECod
eCY9jWdy3icWVgmAGLXV9fAtw0dnfkb/7Vf/mQOIeAFaHZ3cJN3i6Nz1/dOeUTrb+s6+23UE4bjI
lB7kG0R5VMgVUiawpOKnF/+WHk58yYWlGbN2J2jp6W86z/66IJwkIvEwvy8R1kDdoNPsIov+eJNE
IljlemJVGi5dQLBwT1LprdLHfXIJws4aqVdzj7kAGl4C1s5h1tu5tnd44/lxIYJVJpARnFkb3/fr
UGz6YPxL+uTc34hLKJwYy2p8+TUNLT7nLeQZRpdecAbvdt8n+66vKxciWGUCxaKYQloIvOK+iPYE
QSgnKIJGLVS2WGXe00sbszwaSQSrykBK1mqwb6/5QuV79jovFJAC3IepD5gVLwjHPYySSMEV6HZT
Xfog3QESSE5LAx0XYmGVCQzT//jMX7PLhxVFKC79ZuT3XBmPf2NGFmqvDBoj1VncPOxPEI6DUDRI
s2vjHKtSq9Sk0xhzilX6awPkD20e2/o5EawygnqsDLC2rvd8SGtby9Rga6EWR0d6ACBhZ6GIlXB8
zK1P0NOZeyxc6Y3lPZzlzmx4wqGbAZ/Pl/E+CkSwjgj0SmHFPea4Q6i+zwpKdlA4XqLxCEViYU4U
4d1o0lnoTPMVfmtiM/mTqbs8HbTF2cX1WHAXjwsRrCMEllQmdiUI5SDyZpdAMe8zWEw2g508/hVu
Ncss+MXnsXfAbW3lMh2dRn/sL5oIliBUKClKcSIHcSW4b3PeSbo78ke2kG72fUwddb0F/RysosMN
0z9hPeH7v0dBJn154lWZgQAQWCSfCkEESxAqlFg8Sg8mvuJlvmj7ypTRYGwRgugmrYXsJuebWGlh
89WPijhKJDZnacE7ywLZWd+3QyhzI4IlCBVGIhnn2WsYZYSAOWJQy5tzb1WpT6wMk9e/Rn1NZ6m3
8eyJK0rG5qin0/e3N6ZjrjtGjO/HyforBEHYRSwR5YUmRAou6sToovtjn5NBZ8q7Kg4WzOrWIgtb
V/2pEyVYcAWxtMUb8PDH+BsgWoVwcv4KQRB2AcsDVeeYxKlUKLmeD+4fYk2IOaFcZi+MOhOpj6Eo
eTPoJY1ay/OtdoK/A+OQUfYD0cL8uJ1V9fkQwToBIFUcjPp5TZg/vEETKyM8wQHjlqUpurZdv6XN
ed4oDisrA/ZcfnzmZ/TfR/8rD4xEZToEIBdnWq4UHNA+LN7gGu8zCEa2aHptnGNn7w38iJv7dw6o
bHZ08HTRVd8C/z3YNgVra78CahGsEwDMdsyFx3YdTCSFiRxNhOl082VqtDUf2RtOODmgWHNydYSH
P6bbZr6n0drCVhcOOdwgbLBScrlViG31Np7mOsBy4tlapgXvNL2af7ztpkYoxFnL0y2X6HTzxbfe
x3BZZzxjvEQVsTgsa0FhNab07oVcCccMWiAeTHzBsYnsbSGY9IDK4xs9H1K9telYH6Nw9OC1H19+
9WZHwNsYtEb6/PVv3mpKhqjlEqzRpZd0rvUqu5HlBEMoX80/ecsSBP6Ij9b8K9s9tRnQWwt3cNW3
yIuFIXi8lGUfRLCOGRTnwcLaudoIbiJe/KRMcahJ0ivjOsgf2eJZVLA8Am+a57E9BjVWOOTQNI8i
T8SL8pFpsSkl3sAaJwIyMTQcqrE326N2TuOF9bezkBX7CLM3Plv0Vhbi/RDBOmYQt4rG3z6VMmBv
of4EVBcL5QcFoElKUTQWoqcz97kmCYH2BxNfsrV1sf0aGbUWPsTmvTN0tesO9bnPcksNRnM/m7m3
veAE31tnaeSf6bI0FiQEhTC1OsqHayDio5HFF+S2t9Gt3o85FrUV2tz19aiMh2AhoB6Jh94STmQ4
3+3/EXU3nOK/D48XP2c/RLBOgEuIIGUu+HQNeXkBq1A9QHQQd4KLhGA0rOsXcw9o2jNGgfAWV7DD
IoHLlLayEzSzPkED7gv8/XChHk5+xWKEr/NsLVJ3/SmaXB1mt/Byxy3qcPWydZ4uhzgc+H14H055
Rli0MpYRCla/GPotXe1+n9YDK9wYDRDD0mp0HNbA44dQ4X2eLVgQMvz9rc7uoh6LCNYxg1MIG0Ig
WlgFthXe4JEzeq2J3QKT1nzcD1E4JMh+QXzg/sOdgzChYBIH0cX2mzQ494gmVobY0siACxwWFsYU
QXTqzI0sctkg7kNvpljd6r1CPY2n2T3MVLarStRXH4lHOD6FIHm2GwdWfAssmJfab1KLo4sSyRjH
zabWRikcDZFSqaRl3zxbZvgbDosI1jEDUbrZ+xFnTbD2C28ALF7FCBq88eDbHzW4MNClv7gxxxdA
oT1pQm4Qg7o78gduLEZzMtwnZAHn1qd4TjrEKVusACwl7OTDklHEp5rtHfR64QklsgTDpLdyjVWz
vZ3dwHKNfYEViLKJfDNxMeMd7hxueO9AiGFZaVU6LlPAYytVllIE6wQAsx43rOpucXZsf+6owOmP
TA4CuzgFcZI+mblHgbCPtGo9x9l6Gk4d2eOpFpA4QZZsePEFefzL26uyskF5AoosEX9CkzFcJYAL
3WaxBI0jAAARSUlEQVRw0Lm2q/y+UFLaUkFWDXVNZ1ouc8Ab7iMEY6+g+2FBFhJjkWEp5qu/6sBc
tzdunsvcyDG22fVJWtqYoY76fjKWyFMQwTpBwPTHf0cNKqaxnVqpUPAWagRJNwJr22/WyZXXIlhF
AiFBa8x3439m1y2XWAGsz4I7CMuEm38Vb7tiMGtwsaOA+M7AX3C8C1Y5KsiPavAjYlioC8T/M2EM
BPu3H2fWxwCZS2Q4EZSHC4n3tYJK81hFsGocuCbYhIILBs5Grk0/OCmxydppbqDTzZd4AYFU4O9N
RncSnL7PbZkAWCQd9Wm3EKOzcfGrlEq2bHGzGh38XOM/+zFtqoEre671Gpl1NhpbfknzG9M8jNJt
a2Mx6nWf3bYMM+AxY6dhqQ9gEawaBRfG4sYMB0PnvVN7fi2sAxQw4gbXEW0hhYwCqW0UvEDXYXaR
N7CaV7Tw/CMG9Rfn/wO7gUMLzzjl39eYFgHtm9KA40SpUHItFV57CCuECJnAC+3X2do7SkSwapSF
jRn6/NWvi/4+BIwxvkTYH64/4oJgxd4lA8F18oc3qb2ul651v89V4OUo9jwMsUSEkqk4JwNg6dkM
Thaxo0YEq0ZB9slhquOK5WJAo62MeS6EFE9WQPxqZynAThCYn/dOc/wQmb5CR63sRXo+u6Jk6+N0
agMLKqxtrKtvsDWXvT8xFyJYNQrS1D8493P6xf1/LPh7UKh4ufNWySqnq5l0iL3w5bjIxO4nbPux
EfCQRqWj2fUJruFC8ShKUkohWshgYvID1tPBRUR9lQiWcKQkd0wB2A+crhyLSe/bFPYA1g3KDwaa
ztOaf5WXOSDBMbTw/Pu4kNaYjlOpddRW17W9AKJYUqkUx5YeT9/lSvQM+BwWn+JxHHbvZbpkQVWS
yvnDIBZWjYICxs9e/mtR34OgK3rbJOheGBALtMmg2BNFwKh3Q+ICs9gbbS10o/cj0ig1fH869X+w
UyAQ2eJ6rtm1ybc+j+boP738NX14+i+p2dFO1YAIVo2y6J3hudrFgsJFZIgkS1gYqJVSv7FukDV8
rz9dSwWLK9N7pzxk6l+hULAY7mzdAbCIq6kERQSrRglE06NKigVCJQMFDwasKMQBS41KocorSslk
nOu70PpTDbFHEawaZcB9nnwhL72ef8r/xoiSRCLG5Q57geJRyRKeLLbCvl3z1ACq4WPJKH3+8tcc
NL/W9f6xbm0uBSJYNQpS5zd6PqKehtM8EQKNtCNLg9xOgnYcAEvqbOs7HIf5YujfuO6mv+lCVZzU
1YRZb+HAulql5Sb6zeAaB9kxXmZk6SW5rS3cmDy28ooutt+o6ANHBKuGwZsab/QM/e5z7Fq8nn/C
sZf2uh5uskXRYF/jufRMpJVhzhKWw7URDh7cv97zIZdFeHxLPAveZnTw5zOzt5ARzjQnVzKV/eiF
ktPbcJp0Kh2F42EO2OLNv7QxS2PLr7a/JpaMiWCdMDRcbKrhaR8uq5sPI7Rf4cDBIgtMfsBaLW7C
ruAYvAiWsItQLMhD5bCRBWNNUAKRzdzaJD1Wf8NZrq6GgZKNDhFKgWI7+wjXD/1+GOyHoZBopj7u
OqrDIoIl7KrdgTWF/rZ8oGEXdT9wG9FScq37A27zEU4eOrV+W8CqAREsgcFEgU+f/4qtqkJI78pL
8GgaLCUQwRKOAhEsgYnEo7u28xYCxuBWctbppIOAOQp1EXsy6sT1FsESGLethU41X6T7438u+BmB
UCGGhWCuUHpQ7DmzNkZLG3M8wfR82zWellHLiGAJ22SXOBQCmnZdWJIgFlbZ5mlxbZxvkYPlFr1N
BKs8T7VQiWD8bTEEowF6Nf+YN/sc1/jeamTBO8PNyultOgH+HFzCYNTPpQqYqV6riGAJ20H3ac/u
ee57gWmZXv8qZw1FsA4HBGlw7iGveUPm9WzLFRatfvd5Gl95zWUJbltrTYsVEMESmI2gN2e3/36g
Risai9TUs4iCWtwgMluhDS4bQK/eYdgMrdPs2jgtbS7w4D/0dKJ+6lLHTep1n+FVXoIIlvAGtHJg
eSsuGoCMFNo5cjXVZuMwuXifYa0AkUJMadm3wPPa8Xw5TPXco4fG4oMOysP0TvR3qlVqPjiyM7Yi
Vt8jFpbAOE31dL3nA57ThGFz6BXERTk4+5D70TIgyI4pmnBbANyUSp8AUAzYI4jNNliHhmURbGWF
NznWdLb1CrU6uw9UTa7X6OlC2w1qc6Kuzc/LU6WDYDciWMI26De70H5jexxu/Zus4ZOpu/x/lC9c
677D++g6Xf38ufTY3Np4GyFm92T6Lot1tvuMIlpsZW7caqUWRyeelaJ/Ntpm3PZWarA2sbtZikUU
1UhtvNOEglFniQ/cEoyWabK1kj/q58boDLUY/MUkC0ywyLVsFqUdJp350Asf8P2HnUBazYhgCfuC
leMCLCxiNzkXsIpQ6AnLSyl1aWVDBEsQinQL4b4hfpW9dYizhpQ69i3N1Y4IliAU4RKea7tKrc4u
DrRjqgVcaGRKkaRosLaQSiWXVDmRZ1cQisymOowunu4J4UJ2sN7axOu6IGhiYZUXESxBKBIIk0qh
rvm+vuNABEsQhIpBBEsQhIpBBEsQhIpBBEsQhIpBBEsQhIpBBEsQhIpBBEsQhIpBBEuoWDD2BhXn
PEBPd7gBekJlIIIlVCRoNB5aeEpTnlGeKnG16440adcAIlhCRYKRwtgog0UNAHOqfmL/2+N+WEKZ
EcESKhI0HRu0Ru7lSxGRRW8/7ockHAEiWEJFYtCa6HTzJV6JhWGCthqaK1/LiGAJFQmC7H3uc9Ti
7OQVWIoDLn8QKgsRLKGikUUNtYUIlnBs22f0WiNNrg6TL+il3sYzPFdKEPZCBEs4UrBhBnPPn818
x1uOo/Ew11NhDfvF9pvkNLkOvchBqF5EsIQjxRvw0OjSIC1sTPMi0gzTnjEuAr0z8GMZjCfkRQRL
OFKwbw/ilC1WGSKxMKkUYl0J+RHBEo4UvcZAWrWOXcCdINOXvaJdEHYigiUcKaib8oW8Oe+LxSO0
tDlPPXqrvCpCTkSwhCOl3uqmJkcHJRJxCsUCLF5qpYaLP/UaozQxC3sigiUcKRa9jT46/ZcUjgVp
dWuJ177XmRupva77zbp3mbog5EcESzhyEMPCzay38W4/xK2UEmwXCkAESzg2lAolz7IShEIRwRIE
oWIQwRIEoWIQwRKOrCUnmUqSWqUmBSnkWRcOhAiWUFYwETQQ8VMyGafZ9UlqdrRTi6MDZaLyzAtF
I4IllI1oPEIvZh/SvHeK5Wkr7KOp1RF6p+s9zg4iUygIxSCCJZTNshqce0hDC88omUpsfx4Nzl8P
f0qXOm7Rhfbr8uwLRSGCVSOkUkke46JSakh1BONbYFEtbsy+JVYZ4sk4maT9RjgAIlhVHOSGlaNQ
KHhhw9LmHE2ujlCzvZ266vtJpzGU9fdr1elWm3xIk7NwEESwqhRfaJ2eTN+jeCLGLS8QLGyYwTwq
LGxotDWXtbrcH/bxLR+rvkVqr+sp2+8XqhMRrCoEEz29gTWaXZvgj7Pxhzfpu/E/8zjiPvdZqreU
ZywxAupd9QO0EVgjb9CzPaHBbqpj66qZM4WCUBwiWFXGvHeans9+Rx7f0i6xyriKa/4VtrSC0QB9
fOavymJpGXQmutRxg5KpFAUiPno6fZ9MOjOdarrA9VhWg+wRFIpHBKvKgOUEdwuu4F5ANBDfKhco
DlUp1QQptBvr6MPTPy3b7xJqBxGsKkOr0tKppotcUrDn16l1dKHtWtHWFYQulUodSaZREHYiglWl
5Qv7AesHM9QhPvtbWikKRgLsYi5vLlAsGaUOV6/sBBSOHBGsKsPjX+Zdf/uBjOGjya/JbW8ltWLv
OeqhaJC+HfuMY16BsI+tLFSxd9T1chBdEI4KEawqA0PxICaFALdQSXuveN8MojziLk8GhTWW4dnM
fV6GeqPnQzLqzId+3IJQCCJYVYZOpaOzrVdobn2SGq0tFI6H+eNkMsGuH2qy8H8FKbkReb+lpcNL
L2hiZbfFhqD+RnCdovEoGaUlUDgiRLCqDAjQte736WrXHRYmbKmJRIMUiPq5lOByx222rGAVFVJt
3td4lgZncwXwFeQw1ZHFIBtuhKNDBKsK4czfmzh6i6OTzDorbUU2yaAx8VblYsoZsPQ0Nyla21pm
l9FpbijNAxeEfRDBqnIgTgiMHzQ47jTXk8vSSIlkklttYol0fAxOJe5Dz6AgHBUiWMKeYG6VxWDn
BmqMilnanKVTTZfIYXKRTq0jk17WcglHhwiWsO9mG4cxbZ1d7rhFCsVtruEShONA3nlC4W+WAoL0
glBORLAEQagYRLCEEwXaitb9mNnlIH2ZhwwKlYcIlnDsROIRGl54zuOUN4JrtLgxQ+dar9LZ1nc4
hiYIGUSwhJKSwn9vGqoL2T+IvsSt0AaNLb9kscrwYOJL3raD1h+HqV5eJYERwRIOBSY4wI1Dyw+a
o1d8C1xM2lbXQ/UW977fv7QxR1+P/J4noe4EkyGUCnmLCt8j7wbhUEBUYB2ZdBZa3VqiBe80fx47
CK923yGjxkiKPdw61HPpNfqcgoWspFYjhanC94hgCQcGI2rGll/xbSfTnlEKRwPksrjpYsdNLjzN
BayyfNNRI7EQbYW8ZJDgu/AGESzhQGACxMu5R7TsW8h5P0QI8+WXNufJrLfSQNOFnF+37l+hcCyU
9/dsBr3UYG2WV0lgRLCEA4GAOCZBIMi+X4xrr/lcna4+shhsFI4GaXlznoYWn/EMeFhm0XiY2pxd
8goJ24hgCQcCq+YxwA/bnffCqDVTk6M97/0atZbctlb+2GVtIre9jWuwrAaHlDQIuxDBEg48wqaQ
Vh1YT/sYYduYdRa+CUI+RLCEA+HxL/Gi1v2Amze6/JLqzPV7ZgsFoRBEsIQDMbc2WfDXIhYFI6t8
WxCFWkEESzgQ59qucs0VqtMx1dSztcQlCmkUpMyaatrvPi/xKKEkiGAJB8KgMdJfXf6P3FqD+Vjj
K6/p3uifeE48RiZf7rzFwoU9iZhYKgiloKYFi9e18xhhia0chMwqetBdP8CFpBa9jWwGJznMroJ6
CQWhGGpOsAKRLW7OjSViNLU6Qo22Zmqyt4lolUC8zrdeTU97L2LJhSAUQ80J1uTKCA0vPmPrKhQL
0vSagy62X6cme7vMXzok+SzVjYCHl1XIwlXhsNSMYMXiUd5ejC3GmC6Q3Rry+avfUE/jafrg1E+P
9TFWC/FknCZXhikQ8VMg4qPhxefUXtdD7/b/kAxa03E/PKGCqRnBSqQSNLEylLfR1m5wHfljqkaw
YdrrX+XDAXVaGMoH8O/giwBd7/mA3PZ0ZbsgFEvNCBa2HdtMTprfmKZUMrH7fo32WB5XtRFNROjl
/GOe1rATb9DDbrggHJSaESw04G4E1imVTOa8f82/cuSPqRrRqHTcvJz/ftm8IxwcdS25Kia9mRps
zRRNRNltycaqdxzbY6smEB/0hTbyTm5Ij5KRunfhYNSMYCFDdbXzPUokE6RSqemzl/+XL6BL7TfJ
qDVRnRQ3lgS04az5l/PeH4oEKJVCRrE0v0+oLWpGsIDuzeRKzHD68NRPSalUkl5jPO6HVVWY9TZ6
f+DH5I9skS/kpcHZhzzmuMHSxBnCZmeH1GkJB6amBCsDKrClJqg8YC0XrFXc4B6adVayGZ1kNdhl
c7RwaGpSsISjAZt0uhoG5OkWSoYIliAIFYMIlnBsRGJhisTDZNZbeIKpIOyHCJZwpKBd59X8Y45p
DS++4Kzi7f4f8macfKvABCGDvEOEIwFzsTZDXt70PDj3iP+d4cH4FzTQfJG66/u5SVoQ8iGCJRwJ
KBXFWjCs8coWq0yXwcjic2p1dBQtWOFYkN1J1NTNrU+R3egkp7mex90IVHX8f1he8aEkBDWeAAAA
AElFTkSuQmCC