20190116
11491900
1.0
FALSE
CreateFeatureclass C:\ArcGIS\RPM\Capital_Improvements.gdb FacilityPlans Polygon # No Yes "PROJCS['NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Transverse_Mercator'],PARAMETER['False_Easting',656166.6666666665],PARAMETER['False_Northing',26246666.66666666],PARAMETER['Central_Meridian',-115.5833333333333],PARAMETER['Scale_Factor',0.9999],PARAMETER['Latitude_Of_Origin',34.75],UNIT['Foot_US',0.3048006096012192]];-17790500 -19184900 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # FacilityPlans
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ProjectNumber Text # # 10 ProjectNumber NON_NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ProjectName Text # # 255 "Project Name" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans StreetNumber Text # # 255 "Street Number" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans StreetName Text # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans City Text # # 255 City NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans State Text # # 255 State NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ZipCode "Long (large integer)" # # 255 ZipCode NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans GenInfo Text # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ScopeDescr Text # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans WO_No "Long (large integer)" # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans PO_Date Date # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans PO_Issuance Text # # 255 "P.O. Issuance" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans PO_Amount "Float (single precision)" # # 255 "P.O. Amount" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans FundingSource Text # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans PlannedStartDate Date # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans PlannedEndDate Date # # 255 "Planned End Date" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans CofA_Cost "Float (single precision)" # # 255 "CofA Cost" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans RPM_ContactName Text # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans RPM_ContactPhone Text # # 10 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans Vendor Text # # 255 Vendor NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans VendorContact Text # # 30 "Vendor Contact" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans VendorAddress Text # # 50 VendorAddress NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans VendorNo Text # # 10 "Vendor Number" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans VendorContactCell Text # # 255 "Vendor Contact Cell" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans VendorContactEmail Text # # 20 "Vendor Contact Email" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ContractorName Text # # 255 "Contractor Name" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ProjStatus Text # # 255 "Project Status" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans StartDate Date # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans EndDate Date # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ProjCost "Float (single precision)" # # 255 # NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ContractType Text # # 255 "Contract Type" NULLABLE NON_REQUIRED #
AddField C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans ContractLimit "Float (single precision)" # # 255 ContractLimit NULLABLE NON_REQUIRED #
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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>ProjectNumber</field_name><new_field_name>ProjectNo</new_field_name><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>ProjectNo</field_name><field_length>15</field_length><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>RPM_ContactPhone</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>RPM_ContactPhone</field_name><field_type>LONG</field_type><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AssignDefaultToField><field_name>VendorNo</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>VendorNo</field_name><field_type>LONG</field_type><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AssignDefaultToField><field_name>VendorContactCell</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>VendorContactCell</field_name><field_type>LONG</field_type><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>ProjectNo</field_name><field_length>15</field_length><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>ProjectNo</field_name><field_length>15</field_length><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>ProjectNo</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>ProjectNo</field_name><field_type>LONG</field_type><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>ProjectNo</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>ProjectNo</field_name><field_type>TEXT</field_type><field_length>15</field_length><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>PO_Amount</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>PO_Amount</field_name><field_type>FLOAT</field_type><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>ProjectNo</field_name><field_alias>Project Number</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>StreetName</field_name><field_alias>Street Name</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AssignDomainToField><field_name>City</field_name><domain_name>City1</domain_name></AssignDomainToField></workflow><workflow><AlterField><field_name>ZipCode</field_name><field_alias>Zip Code</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>GenInfo</field_name><field_alias>General Information</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>ScopeDescr</field_name><field_alias>Scope Description</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>WO_No</field_name><field_alias>Work Order Number</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>PO_Date</field_name><field_alias>P.O. Date</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>PlannedStartDate</field_name><field_alias>Planned Start Date</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>CofA_Cost</field_name><field_alias>C of A Cost</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>RPM_ContactName</field_name><field_alias>RPM Contact Name</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>RPM_ContactPhone</field_name><field_alias>RPM Contact Phone</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>VendorAddress</field_name><field_alias>Vendor Address</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>StartDate</field_name><field_alias>Start Date</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>EndDate</field_name><field_alias>End Date</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>ProjCost</field_name><field_alias>Proj Cost</field_alias><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>ContractLimit</field_name><field_alias>Contract Limit</field_alias><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>VendorNum</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>VendorNum</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>VendorNo</field_name></DeleteField></workflow><workflow><AlterField><field_name>VendorNo</field_name><new_field_name>VendorNo</new_field_name><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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DeleteField><field_name>RPM_ContactPhone</field_name><field_name>VendorContactCell</field_name></DeleteField></workflow><workflow><AddField><field_name>VendorNo</field_name><field_type>LONG</field_type><field_length>10</field_length><field_alias>Vendor Number</field_alias><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>VendorNo</field_name><field_type>LONG</field_type><field_length>10</field_length><field_alias>Vendor Number</field_alias><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>VendorCell</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>Vendor Cell Number</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>RPM_ContactNo</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>RPM Contact Phone</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>VendorNo</field_name><field_type>LONG</field_type><field_length>10</field_length><field_alias>Vendor Number</field_alias><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>VendorNo</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>Vendor Phone Number</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>RPM_ContactName</field_name><domain_name>RPM_Conact</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>ProjStatus</field_name><domain_name>Status</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>ContractType</field_name><domain_name>ContractType</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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>OverBudget</field_name><field_type>FLOAT</field_type><field_alias>OverBudget</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField FacilityPlans OverBudget "PO_Amount - ProjCost" "Python 3" #
CalculateField FacilityPlans OverBudget "PO_Amount - ProjCost" Arcade #
CalculateField FacilityPlans OverBudget " ( PO_Amount - ProjCost ) " "Python 3" #
CalculateField FacilityPlans OverBudget "!PO_Amount! - !ProjCost!" "Python 3" #
Append C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans "Use the Field Map to reconcile schema differences" "ProjectNo "Project Number" true false false 15 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,ProjectNo,0,15;ProjectName "Project Name" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,ProjectNam,0,255;StreetNumber "Street Number" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,StreetNumb,0,255;StreetName "Street Name" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,StreetName,0,254;City "City" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,City,0,254;State "State" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,State,0,254;ZipCode "Zip Code" true true false 4 Long 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,ZipCode,-1,-1;GenInfo "General Information" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,GenInfo,0,254;ScopeDescr "Scope Description" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,ScopeDescr,0,254;WO_No "Work Order Number" true true false 4 Long 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,WO_No,-1,-1;PO_Date "P.O. Date" true true false 8 Date 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,PO_Date,-1,-1;PO_Issuance "P.O. Issuance" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,PO_Issuanc,0,255;PO_Amount "P.O. Amount" true false false 4 Float 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,PO_Amount,-1,-1;FundingSource "FundingSource" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,FundingSou,0,255;PlannedStartDate "Planned Start Date" true true false 8 Date 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,PlannedSta,-1,-1;PlannedEndDate "Planned End Date" true true false 8 Date 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,PlannedEnd,-1,-1;CofA_Cost "C of A Cost" true true false 4 Float 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,CofA_Cost,-1,-1;RPM_ContactName "RPM Contact Name" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,RPM_Contac,0,255;Vendor "Vendor" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,Vendor,0,254;VendorContact "Vendor Contact" true true false 30 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,VendorCont,0,30;VendorAddress "Vendor Address" true true false 50 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,VendorAddr,0,50;VendorContactEmail "Vendor Contact Email" true true false 20 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,VendorCo_1,0,20;ContractorName "Contractor Name" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,Contractor,0,255;ProjStatus "Project Status" true true false 255 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,ProjStatus,0,254;StartDate "Start Date" true true false 8 Date 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,StartDate,-1,-1;EndDate "End Date" true true false 8 Date 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,EndDate,-1,-1;ProjCost "Proj Cost" true true false 4 Float 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,ProjCost,-1,-1;ContractType "Contract Type" true true false 255 Text 0 0,First,#;ContractLimit "Contract Limit" true true false 4 Float 0 0,First,#;VendorNum "VendorNum" true true false 10 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,VendorNum,0,10;VendorCell "Vendor Cell Number" true true false 10 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,VendorCell,0,10;RPM_ContactNo "RPM Contact Phone" true true false 10 Text 0 0,First,#;VendorNo "Vendor Phone Number" true true false 10 Text 0 0,First,#,C:\ArcGIS\RPM\FacilityPlans\FacilityPlans.shp,VendorNo,0,10;OverBudget "OverBudget" true true false 4 Float 0 0,First,#" # #
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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>ProjEst</field_name><field_type>FLOAT</field_type><field_alias>Project Estimate</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>RPM_Contact_Email</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>RPM Contact Email</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>APN</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>APN</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>CommDist</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Commision District</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>CommDist</field_domain></AddField></workflow><workflow><AddField><field_name>ParksDist</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Parks District</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Comments</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Comments</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.2.0'><WorkspaceConnectionString>DATABASE=C:\ArcGIS\RPM\Capital_Improvements.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FacilityPlans</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>ParksDist</field_name><domain_name>ParkDist</domain_name></AssignDomainToField></workflow></operationSequence>
Copy "C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans " C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans_1 FeatureClass "FacilityPlans FeatureClass FacilityPlans_1 #"
Rename C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlans_1 C:\ArcGIS\RPM\Capital_Improvements.gdb\FacilityPlansOrig FeatureClass
FeatureClassToFeatureClass C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig "Database Connections\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.RPM" FacilityPlansTestData # "ProjectNo "Project Number" true false false 15 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ProjectNo,-1,-1;ProjectName "Project Name" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ProjectName,-1,-1;StreetNumber "Street Number" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,StreetNumber,-1,-1;StreetName "Street Name" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,StreetName,-1,-1;City "City" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,City,-1,-1;State "State" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,State,-1,-1;ZipCode "Zip Code" true true false 4 Long 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ZipCode,-1,-1;GenInfo "General Information" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,GenInfo,-1,-1;ScopeDescr "Scope Description" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ScopeDescr,-1,-1;WO_No "Work Order Number" true true false 4 Long 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,WO_No,-1,-1;PO_Date "P.O. Date" true true false 8 Date 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,PO_Date,-1,-1;PO_Issuance "P.O. Issuance" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,PO_Issuance,-1,-1;PO_Amount "P.O. Amount" true false false 4 Float 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,PO_Amount,-1,-1;FundingSource "FundingSource" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,FundingSource,-1,-1;PlannedStartDate "Planned Start Date" true true false 8 Date 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,PlannedStartDate,-1,-1;PlannedEndDate "Planned End Date" true true false 8 Date 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,PlannedEndDate,-1,-1;CofA_Cost "C of A Cost" true true false 4 Float 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,CofA_Cost,-1,-1;RPM_ContactName "RPM Contact Name" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,RPM_ContactName,-1,-1;Vendor "Vendor" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,Vendor,-1,-1;VendorContact "Vendor Contact" true true false 30 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,VendorContact,-1,-1;VendorAddress "Vendor Address" true true false 50 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,VendorAddress,-1,-1;VendorContactEmail "Vendor Contact Email" true true false 20 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,VendorContactEmail,-1,-1;ContractorName "Contractor Name" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ContractorName,-1,-1;ProjStatus "Project Status" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ProjStatus,-1,-1;StartDate "Start Date" true true false 8 Date 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,StartDate,-1,-1;EndDate "End Date" true true false 8 Date 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,EndDate,-1,-1;ProjCost "Proj Cost" true true false 4 Float 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ProjCost,-1,-1;ContractType "Contract Type" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ContractType,-1,-1;ContractLimit "Contract Limit" true true false 4 Float 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ContractLimit,-1,-1;VendorNum "VendorNum" true true false 10 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,VendorNum,-1,-1;VendorCell "Vendor Cell Number" true true false 10 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,VendorCell,-1,-1;RPM_ContactNo "RPM Contact Phone" true true false 10 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,RPM_ContactNo,-1,-1;VendorNo "Vendor Phone Number" true true false 10 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,VendorNo,-1,-1;OverBudget "OverBudget" true true false 4 Float 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,OverBudget,-1,-1;ProjEst "Project Estimate" true true false 4 Float 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ProjEst,-1,-1;RPM_Contact_Email "RPM Contact Email" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,RPM_Contact_Email,-1,-1;APN "APN" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,APN,-1,-1;CommDist "Commision District" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,CommDist,-1,-1;ParksDist "Parks District" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,ParksDist,-1,-1;Comments "Comments" true true false 255 Text 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,Comments,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,C:\workspace\RPM\Capital_Improvements.gdb\FacilityPlansOrig,Shape_Area,-1,-1" #
CalculateField FacilityPlansTestData OverBudget !ProjEst!-!ProjCost! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData OverBudget !ProjEst!-!ProjCost! "Python 3" # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.0.0'><FeatureDataset>prdgis.GISMO.RPM</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686d7138617a47626d774454365877334d4f3030395539544b414657666f6a4a6b63315976656e63484f58553d2a00;ENCRYPTED_PASSWORD=00022e6830674d4938624b6d545567334e6e723646626c4234555a674b564565795055654f462f6442636a65466c633d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.FacilityPlansTestData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>LateStart</field_name><field_type>LONG</field_type><field_precision>5</field_precision><field_alias>LateStart</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LateEnd</field_name><field_type>LONG</field_type><field_precision>5</field_precision><field_alias>LateEnd</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField FacilityPlansTestData LateStart !StartDate!-!PlannedStartDate! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData LateStart "var startDate = Date($feature.PlannedStartDate)
var endDate = Date($feature.StartDate)
var results = DateDiff(endDate, startDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
UpdateSchema "C:\Users\eburmeis\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.RPM\prdgis.GISMO.FacilityPlansTestData" "<operationSequence><workflow><AddAttributeRule><rule_name>LateStat</rule_name><rule_type>CALCULATION</rule_type><expression>var startDate = Date($feature.PlannedStartDate)
var endDate = Date($feature.StartDate)
var results = DateDiff(endDate, startDate, 'days')
return results</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates the wether the date started is later or early from the planned start date.</rule_description><field_name>LateStart</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>LateStat</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "C:\Users\eburmeis\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.RPM\prdgis.GISMO.FacilityPlansTestData" "<operationSequence><workflow><AddAttributeRule><rule_name>LateStat</rule_name><rule_type>CALCULATION</rule_type><expression>var startDate = Date($feature.PlannedStartDate)
var endDate = Date($feature.StartDate)
var results = DateDiff(endDate, startDate, 'days')
return results</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates the wether the date started is later or early from the planned start date.</rule_description><field_name>LateStart</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>LateStat</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "C:\Users\eburmeis\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.RPM\prdgis.GISMO.FacilityPlansTestData" "<operationSequence><workflow><AddAttributeRule><rule_name>StartDif</rule_name><rule_type>CALCULATION</rule_type><expression>var date1 = Date($feature.PlannedStartDate)
var date2 = Date($feature.StartDate)
var dateDif = DateDiff(date2, date1, 'days')
return dateDif</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>1</error_number><error_message>Could not calculate the difference between the actaul start date and the planned start date due to at least one of the dates Null. Please check make sure that the null is a valid value.</error_message><rule_description>Calculates wether the project strarted late or early and how many days late or early it started</rule_description><field_name>StartDate</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>StartDif</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.0.0'><FeatureDataset>prdgis.GISMO.RPM</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684e7a636658547479703262326d422f4137384336645054485970754f735437684d396a45504b2f7362794d3d2a00;ENCRYPTED_PASSWORD=00022e686e6e30347246375a4878526a77784a436d47584669344a486b556f65526f4f51423041684a6761306479493d2a00;SERVER=ccentgis;INSTANCE=sde:sqlserver:ccentgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ccentgis;DATABASE=prdgis;USER=gismo;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>prdgis.GISMO.FacilityPlansTestData</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
UpdateSchema "C:\Users\eburmeis\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\server=ccentgis db=prdgis user=gismo.sde\prdgis.GISMO.RPM\prdgis.GISMO.FacilityPlansTestData" "<operationSequence><workflow><AddAttributeRule><rule_name>StartDif</rule_name><rule_type>CALCULATION</rule_type><expression>var date1 = Date($feature.PlannedStartDate)
var date2 = Date($feature.StartDate)
var dateDif = DateDiff(date2, date1, 'days')
return dateDif</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>1</error_number><error_message>Could not calculate the difference between the actaul start date and the planned start date due to at least one of the dates Null. Please check make sure that the null is a valid value.</error_message><rule_description>Calculates wether the project strarted late or early and how many days late or early it started</rule_description><field_name>StartDate</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>StartDif</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
CalculateField FacilityPlansTestData LateStart "var startDate = Date($feature.PlannedStartDate)
var endDate = Date($feature.StartDate)
var results = DateDiff(endDate, startDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData LateStart "var startDate = Date($feature.PlannedStartDate)
var endDate = Date($feature.StartDate)
var results = DateDiff(endDate, startDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData LateEnd "var startDate = Date($feature.PlannedEndDate)
var endDate = Date($feature.EndDate)
var results = DateDiff(endDate, startDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData LateEnd "var startDate = Date($feature.PlannedEndDate)
var endDate = Date($feature.EndDate)
var results = DateDiff(startDate, endDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData LateStart "var startDate = Date($feature.PlannedEndDate)
var endDate = Date($feature.EndDate)
var results = DateDiff(endDate, startDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
CalculateField FacilityPlansTestData LateStart "var startDate = Date($feature.PlannedStartDate)
var endDate = Date($feature.StartDate)
var results = DateDiff(endDate, startDate, 'days')
return results" Arcade "dateDif(!LateStart!)
def dateDif(LateStart):
date1 = !Planned Start Date!
date2 = !Start Date!
return date1" Text NO_ENFORCE_DOMAINS
Server=ccentgis; Service=sde:sqlserver:ccentgis; Database=prdgis; User=gismo; Version=dbo.DEFAULT
ArcSDE Connection
prdgis.GISMO.FacilityPlansTestData
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet
<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/10.8'><WKT>PROJCS["NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",26246666.66666666],PARAMETER["Central_Meridian",-115.5833333333333],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",34.75],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3421]]</WKT><XOrigin>-17790500</XOrigin><YOrigin>-19184900</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102707</WKID><LatestWKID>3421</LatestWKID></ProjectedCoordinateSystem>
20220711
14353000
20220711
14353000
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
FacilityProjects
RPM
Service created of the RPM Facility Projects
SDE Feature Class
dataset
EPSG
8.2.10(9.3.0.0)
0
Simple
FALSE
0
TRUE
FALSE
prdgis.GISMO.FacilityPlansTestData
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
ProjectNo
Project Number
String
15
0
0
ProjectName
Project Name
String
255
0
0
StreetNumber
Street Number
String
255
0
0
StreetName
Street Name
String
255
0
0
City
City
String
255
0
0
State
State
String
255
0
0
ZipCode
Zip Code
Integer
4
10
0
GenInfo
General Information
String
255
0
0
ScopeDescr
Scope Description
String
255
0
0
WO_No
Work Order Number
Integer
4
10
0
PO_Date
P.O. Date
Date
8
0
0
PO_Issuance
P.O. Issuance
String
255
0
0
PO_Amount
P.O. Amount
Double
8
38
8
FundingSource
FundingSource
String
255
0
0
PlannedStartDate
Planned Start Date
Date
8
0
0
PlannedEndDate
Planned End Date
Date
8
0
0
CofA_Cost
C of A Cost
Double
8
38
8
RPM_ContactName
RPM Contact Name
String
255
0
0
Vendor
Vendor
String
255
0
0
VendorContact
Vendor Contact
String
30
0
0
VendorAddress
Vendor Address
String
50
0
0
VendorContactEmail
Vendor Contact Email
String
20
0
0
ContractorName
Contractor Name
String
255
0
0
ProjStatus
Project Status
String
255
0
0
StartDate
Start Date
Date
8
0
0
EndDate
End Date
Date
8
0
0
ProjCost
Proj Cost
Double
8
38
8
ContractType
Contract Type
String
255
0
0
ContractLimit
Contract Limit
Double
8
38
8
VendorNum
VendorNum
String
10
0
0
VendorCell
Vendor Cell Number
String
10
0
0
RPM_ContactNo
RPM Contact Phone
String
10
0
0
VendorNo
Vendor Phone Number
String
10
0
0
OverBudget
OverBudget
Double
8
38
8
ProjEst
Project Estimate
Double
8
38
8
RPM_Contact_Email
RPM Contact Email
String
255
0
0
APN
APN
String
255
0
0
CommDist
Commision District
String
255
0
0
ParksDist
Parks District
String
255
0
0
Comments
Comments
String
255
0
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20220711
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKzSvnTTOzPguQuHIwBx29wT+NROagrsaVzSoqklxLDxIDIn95R8
w+o7/h+VW0kSRAyMGU9xTjJS2Bqw6iiiqEFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAEc0ohiZyCcdAO57CqkalUAOM9Tj1p0zed
cYx8kR/Nv/rD+Zorkrzu7GkUFMKEPvjYo/qO/wBR3p9FYptaooel5twtwAh/vj7p/wAPxq1VKmIH
gx5LfJ/zzb7v4en8vauiFfpIhx7GhRUMNykp2kFJMZ2N1/8Ar1NXQnfYgKKKKYBRRRQAUUUUAFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVDczeVF8v+sY7UHv/nmp
qoF/PmMoOUXKp6e5/wA+nvUVJ8sbjSuwRBGgUEnHc9TTqKK4DUKKKKACiiigBrorjDDPce1OSaWH
AOZY/X+If4/560UVcZuOwmky1FKkybo2BH8vrT6zzGC4dSUcfxL1/H1FSx3bJhbgAf8ATRen4+n8
q6oVlLRkOLRbopAQQCDkHoRS1qSFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUEgAknAFAFe7kIQRI2Hk4z6Duf8APqKhACqABgDgU1WMrtMf4/u+y9v8fxp9cVWf
NI1irIKKKKyGFFFFABRRRQAUUUUAFFFFADFV4TmBtvOSh+6f8PwqzFdI5COPLkJxtbv9D3qGkZVd
drAEe9awquJLimXqKopJNB0JlTP3SfmH0Pf8fzq1FNHMDsbJHBB4I+orqjNS2IaaJKKKKsQUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVXvEkkhCIu4FhvGcZX0/l+GasUUmrqwGe
sisxXkOOqsMEfhT6tSwxzLtkQN6eo+h7VWa2ljOY38xf7r8EfQ/4/nXNKg18JopdxKKYsoLbWBR/
7rDB/wDr/hT6waa3KCiiikAUUUUAFFFFABRRRQAUUUUAFMaMMQ3KuOjLwRT6KadtgFW6ePInGU/5
6KP5j/P4VbVldQykMp6EHOap0zY0ZLQtsY9RjKn6iuiFfpIhx7GhRVeO7UsElHluemTwfoasV0Jp
6ogKKKKYBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFADZI0lTa6hl9DVZrWRCTF
JuH9yQ/yP+Oat0VMoqW407GeJOQsiNG56K3f6HoafU16oazkz/CN4+o5H8qhrkqwUHoaRdwoorLn
1+ytrZrqcTR2wkMazFMhyCRwAcnkHt79KiMXLYbdjUoqp/adj9ka6+1ReQoUl93A3Y2j6nI468im
6dqlrqqzPZs0kUbhRMMbJOM5Ug8jnrRyS3sF0XaKKKkAooooAKKKKACiiigBGUMpVgCCMEHvSI8s
B+Ql0/uMeR9D/j+lOoqoycXdA1csRXEc2QpIYDJRuCKlqg8avgkcjoQcEfQ0+O4kjZEl/eKxChx1
z7j+o/KuqFZS0Zm42LlFFFbEhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAEc43
QSD1Uj9KqIdyKRyCAatXEvkwM/foo9SeB+tVY0EcSRjoqgD8K5sR0LgRSXcMVx5LkqfJaYsegVSA
f5isRLbQNSikW3unuUIe4WGG5YhSSwJUZwDuLcdj6VqahpNpqYIuRIVaJ4XCyFQyNjcpx1BwKZZa
HYWFytzbxMJVV1DM5Y4d97dfVuaiMoxW+o2mzKt5PDyW9xYPfIhmuDe/NL5b7jiZWXBzwAPrtbjr
VvTr7QNLtPsVneQxxQru2NISwG4J35J3YHrk+9KPC2lxRSLbQmFmQpuDsR1YrkZ52lzj0GB2GGQe
E9NjgmSYSTyXAf7RIzsPMLsrMcZ7lV/AfjVuUGtWxJNCa9/aRvLX7Abvaba42m3xt8/MXlb88bce
Z14/St1d2xd+N2OcdM0KoRFRRhVAAHtS1jKV0kUkFFFFQMKKKKACiiigAooooAKLdfNnMhztiO1f
Qt3P4dPzpkhYKFTHmMdq56Z/zzV2KMRRKi9FGMnvXRQhd8zJk+g+iiiuozCiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKRiFUsTgAZJoAqXLb7hEA4jG4n3PA/TP6UlMi3Mpkb70h3H29
B+AwKfXDUlzSuapWQUUUVmMKKKKACiiigAooooAKKKKACiiigAoopkm47Y0zvc4BHb1P4U0ruyAk
tU8yVpiOFyif1P8AT8KuU1EWNFRBhVGAKdXfGPKrGTdwoooqhBRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFVbxgVSDvIeR/sjr/QfjVqqlxHIJjMq712gEDqOv59aid+V2GtxtFNV1fO09
Oo6EfWnVwGoUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU60XezTk5B+VB7dz+J/QConBkZYVOC/U+
i9z/AJ9RV9VCqFUYAGAK6aEPtMiT6C0UUV0kBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQBFNbxzcsCHHR1OCKrNHNEeV8xMfeUfN+I/w/Kr1FRKEZbjTaKCOsi7lIIp1Ty2s
cp3DKSf316/j6/jVZxLB/rF3J/fQfzHauadGUdtS1JMdRSBgwypBHqKWsSgooooAKKKKACiiigAo
opjL5zrBzhuWx2Xv+fSnFXdkD0JrNCQ07DBfhfZe359atUAYGB0or0ErKyMXqFFFFMAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCvJaI7M6ExyHuvQ/Ud6rsZ
IcecuB/fXlfx9P8APNaFFZzpxkNSaKQIIyDkGipHs1zuhby264H3T+H+FQM7RcTrs5xuzlT+P+Nc
06UomikmPooorIYUUUUAISFBJOAOSTUtmh8szMCGk5wRjA7D/PrUOwzTLEMbR8z/AE9PxP8AI1fr
qoQ+0yJPoFFFFdBAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR
RRQAUUUUAFFFFABSEAggjIPUGlooAqvabeYG2f7B5U/4fh+VQ7yjBJV8tz0z0P0Pf+daFIyq6lWA
IPUEVlOlGRSk0U6RmCIWbgAZNPa0aMf6O3A/gc8fgeoqNEeacI8TqqfM24cE9gD39fw5rD2Mr2K5
kWLWIxxlnGJHO5vb0H4VPRRXWlZWRmFFFFMAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigD/9k=