20220930 14523000 1.0 FALSE CreateFeatureclass G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb Reg2_Site_Structure Point # No Yes "PROJCS["NAD_1983_StatePlane_Idaho_West_FIPS_1103_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",2624666.666666666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-115.75],PARAMETER["Scale_Factor",0.9999333333333333],PARAMETER["Latitude_Of_Origin",41.66666666666666],UNIT["Foot_US",0.3048006096012192]];-15822600 -47951700 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # # UpdateSchema G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Site_Structure "<operationSequence><workflow><AddField><field_name>DiscrpAgID</field_name><field_type>TEXT</field_type><field_alias>Discrepancy Agency ID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>CreateDate</field_name><field_type>TEXT</field_type><field_alias>CreateDate</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>DateUpdate</field_name><field_type>DATE</field_type><field_alias>Date Updated</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Effective</field_name><field_type>DATE</field_type><field_alias>Effective Date</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Expire</field_name><field_type>DATE</field_type><field_alias>Expiration Date</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Site_NGUID</field_name><field_type>TEXT</field_type><field_alias>Site_NGUID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>254</field_length></AddField></workflow><workflow><AddField><field_name>GIS_STEW</field_name><field_type>TEXT</field_type><field_alias>GIS_STEW</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>20</field_length></AddField></workflow><workflow><AddField><field_name>Data_Source</field_name><field_type>TEXT</field_type><field_alias>DATA_SOURCE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>Data_Source_ID</field_name><field_type>TEXT</field_type><field_alias>DATA_SOURCE_ID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>PIN</field_name><field_type>TEXT</field_type><field_alias>PIN</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>20</field_length></AddField></workflow><workflow><AddField><field_name>SID</field_name><field_type>Long</field_type><field_alias>SID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>MUID</field_name><field_type>Long</field_type><field_alias>MUID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>AddNum_Pre</field_name><field_type>TEXT</field_type><field_alias>Address Number Prefix</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>15</field_length></AddField></workflow><workflow><AddField><field_name>Add_Number</field_name><field_type>Long</field_type><field_alias>Address Number</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>AddNum_Suf</field_name><field_type>TEXT</field_type><field_alias>Address Number Suffix</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>15</field_length></AddField></workflow><workflow><AddField><field_name>Site</field_name><field_type>TEXT</field_type><field_alias>Site</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>SubSite</field_name><field_type>TEXT</field_type><field_alias>SubSite</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Structure</field_name><field_type>TEXT</field_type><field_alias>Structure</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Wing</field_name><field_type>TEXT</field_type><field_alias>Wing</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Unit_Type</field_name><field_type>TEXT</field_type><field_alias>Unit_Type</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Unit_Value</field_name><field_type>TEXT</field_type><field_alias>Unit_Value</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Room</field_name><field_type>TEXT</field_type><field_alias>Room</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Section</field_name><field_type>TEXT</field_type><field_alias>Section</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Row</field_name><field_type>TEXT</field_type><field_alias>Row</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Seat</field_name><field_type>TEXT</field_type><field_alias>Seat</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>Floor</field_name><field_type>TEXT</field_type><field_alias>Floor</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>St_PreMod</field_name><field_type>TEXT</field_type><field_alias>Street name Pre Modifier</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>15</field_length></AddField></workflow><workflow><AddField><field_name>St_PreDir</field_name><field_type>TEXT</field_type><field_alias>Street Name Pre Directional</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>9</field_length></AddField></workflow><workflow><AddField><field_name>St_PreTyp</field_name><field_type>TEXT</field_type><field_alias>Street Name Pre Type</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>St_PreSep</field_name><field_type>TEXT</field_type><field_alias>Street Name Pre Type Separator</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>20</field_length></AddField></workflow><workflow><AddField><field_name>St_Name</field_name><field_type>TEXT</field_type><field_alias>Street Name</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>60</field_length></AddField></workflow><workflow><AddField><field_name>St_PosTyp</field_name><field_type>TEXT</field_type><field_alias>Street Name Post Type</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>St_PosDir</field_name><field_type>TEXT</field_type><field_alias>Street Name Post Directional</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>9</field_length></AddField></workflow><workflow><AddField><field_name>St_PosMod</field_name><field_type>TEXT</field_type><field_alias>Street Name Post Modifier</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>25</field_length></AddField></workflow><workflow><AddField><field_name>LSt_PreDir</field_name><field_type>TEXT</field_type><field_alias>Legacy Street Name Pre Directional</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>LSt_Name</field_name><field_type>TEXT</field_type><field_alias>Legacy Street Name</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>75</field_length></AddField></workflow><workflow><AddField><field_name>LSt_Type</field_name><field_type>TEXT</field_type><field_alias>Legacy Street Name Type</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>LSt_PosDir</field_name><field_type>TEXT</field_type><field_alias>Legacy Street Name Post Directional</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>Full_Address</field_name><field_type>TEXT</field_type><field_alias>Full_Address</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>Label</field_name><field_type>TEXT</field_type><field_alias>Label</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>LandmkName</field_name><field_type>TEXT</field_type><field_alias>LandmkName</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>150</field_length></AddField></workflow><workflow><AddField><field_name>Country</field_name><field_type>TEXT</field_type><field_alias>Country</field_alias><field_is_nullable>TRUE</field_is_nullable><field_default_value>US</field_default_value><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>State</field_name><field_type>TEXT</field_type><field_alias>State</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>County</field_name><field_type>TEXT</field_type><field_alias>County</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>40</field_length></AddField></workflow><workflow><AddField><field_name>Inc_Muni</field_name><field_type>TEXT</field_type><field_alias>Incorporated Municipality</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>Uninc_Comm</field_name><field_type>TEXT</field_type><field_alias>Unincorporated Community</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>Nbrhd_Comm</field_name><field_type>TEXT</field_type><field_alias>Neighborhood Community</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>100</field_length></AddField></workflow><workflow><AddField><field_name>Post_Comm</field_name><field_type>TEXT</field_type><field_alias>Postal Community Name</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>40</field_length></AddField></workflow><workflow><AddField><field_name>Post_Code</field_name><field_type>TEXT</field_type><field_alias>Postal Code</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>7</field_length></AddField></workflow><workflow><AddField><field_name>Post_Code4</field_name><field_type>TEXT</field_type><field_alias>ZIP Plus 4</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>ESN</field_name><field_type>TEXT</field_type><field_alias>ESN</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>5</field_length></AddField></workflow><workflow><AddField><field_name>MSAGComm</field_name><field_type>TEXT</field_type><field_alias>MSAG Community Name</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>30</field_length></AddField></workflow><workflow><AddField><field_name>Addtl_Loc</field_name><field_type>TEXT</field_type><field_alias>Addtl_Loc</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>225</field_length></AddField></workflow><workflow><AddField><field_name>Milepost</field_name><field_type>TEXT</field_type><field_alias>Milepost</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>150</field_length></AddField></workflow><workflow><AddField><field_name>APA_Code</field_name><field_type>Long</field_type><field_alias>APACODE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>Place_Type</field_name><field_type>TEXT</field_type><field_alias>Place Type</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>PlacementMethod</field_name><field_type>TEXT</field_type><field_alias>Placement Method</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>25</field_length></AddField></workflow><workflow><AddField><field_name>Long</field_name><field_type>DOUBLE</field_type><field_alias>Longitude</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Lat</field_name><field_type>DOUBLE</field_type><field_alias>Latitude</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>8</field_length></AddField></workflow><workflow><AddField><field_name>Elev</field_name><field_type>Short</field_type><field_alias>Elevation</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>2</field_length></AddField></workflow><workflow><AddField><field_name>AddDataURI</field_name><field_type>TEXT</field_type><field_alias>AddDataURI</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>254</field_length></AddField></workflow><workflow><AddField><field_name>Comments</field_name><field_type>TEXT</field_type><field_alias>Comments</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>JUNK</field_name><field_type>TEXT</field_type><field_alias>JUNK</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>JUNK2</field_name><field_type>TEXT</field_type><field_alias>JUNK</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>JUNK3</field_name><field_type>TEXT</field_type><field_alias>JUNK</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>RCL_MUID</field_name><field_type>TEXT</field_type><field_alias>RCL_MUID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>SBUNITTYPE</field_name><field_type>TEXT</field_type><field_alias>SBUNITTYPE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>SBUNITID</field_name><field_type>TEXT</field_type><field_alias>SBUNITID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>PRIMSTRUCT</field_name><field_type>TEXT</field_type><field_alias>PRIMSTRUCT</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>PRIMADD</field_name><field_type>TEXT</field_type><field_alias>PRIMADD</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>10</field_length></AddField></workflow><workflow><AddField><field_name>PRUNITTYPE</field_name><field_type>TEXT</field_type><field_alias>PRUNITTYPE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>PRUNITID</field_name><field_type>TEXT</field_type><field_alias>PRUNITID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>STRUCTTYPE</field_name><field_type>TEXT</field_type><field_alias>STRUCTTYPE</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>LANDMARK</field_name><field_type>TEXT</field_type><field_alias>LANDMARK</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>50</field_length></AddField></workflow><workflow><AddField><field_name>Place_Name</field_name><field_type>TEXT</field_type><field_alias>Place_Name</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>CommonName</field_name><field_type>TEXT</field_type><field_alias>CommonName</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow></operationSequence>" AssignDefaultToField G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Site_Structure Country US # DO_NOT_CLEAR UpdateSchema G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Site_Structure <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>DiscrpAgID</field_name><field_alias>DiscrpAgID</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>DateUpdate</field_name><field_alias>DateUpdate</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Effective</field_name><field_alias>Effective</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Expire</field_name><field_alias>Expire</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Data_Source</field_name><field_alias>Data_Source</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>Data_Source_ID</field_name><field_alias>Data_Source_ID</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>AddNum_Pre</field_name><field_alias>AddNum_Pre</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>Add_Number</field_name><field_alias>Add_Number</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>AddNum_Suf</field_name><field_alias>AddNum_Suf</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>St_PreMod</field_name><field_alias>St_PreMod</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>St_PreDir</field_name><field_alias>St_PreDir</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>St_PreTyp</field_name><field_alias>St_PreTyp</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>St_PreSep</field_name><field_alias>St_PreSep</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>St_Name</field_name><field_alias>St_Name</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>St_PosTyp</field_name><field_alias>St_PosTyp</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>St_PosDir</field_name><field_alias>St_PosDir</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>St_PosMod</field_name><field_alias>St_PosMod</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>LSt_PreDir</field_name><field_alias>LSt_PreDir</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>LSt_Name</field_name><field_alias>LSt_Name</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>LSt_Type</field_name><field_alias>LSt_Type</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>LSt_PosDir</field_name><field_alias>LSt_PosDir</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>Inc_Muni</field_name><field_alias>Inc_Muni</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>Uninc_Comm</field_name><field_alias>Uninc_Comm</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>Nbrhd_Comm</field_name><field_alias>Nbrhd_Comm</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>Post_Comm</field_name><field_alias>Post_Comm</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>Post_Code</field_name><field_alias>Post_Code</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>Post_Code4</field_name><field_alias>Post_Code4</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>MSAGComm</field_name><field_alias>MSAGComm</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>APA_Code</field_name><field_alias>APA_Code</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Place_Type</field_name><field_alias>Place_Type</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>PlacementMethod</field_name><field_alias>PlacementMethod</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>Long</field_name><field_alias>Long</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Lat</field_name><field_alias>Lat</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Elev</field_name><field_alias>Elev</field_alias><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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>DiscrpAgID</field_name><field_type>TEXT</field_type><field_length>100</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>County</field_name><field_type>TEXT</field_type><field_length>100</field_length><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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>LSt_Type</field_name><new_field_name>LSt_Typ</new_field_name><field_alias>LSt_Typ</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Post_Code4</field_name><new_field_name>PostCodeEx</new_field_name><field_alias>PostCodeEx</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> Append Reg2_Structure_Pts Reg2_Site_Structure "Use the field map to reconcile field differences" "DiscrpAgID "DiscrpAgID" true true false 100 Text 0 0,First,#;Site_NGUID "Site_NGUID" true true false 254 Text 0 0,First,#;GIS_STEW "GIS_STEW" true true false 20 Text 0 0,First,#,Reg2_Structure_Pts,GISSTEW,0,20;Data_Source "Data_Source" true true false 255 Text 0 0,First,#;Data_Source_ID "Data_Source_ID" true true false 255 Text 0 0,First,#;PIN "PIN" true true false 20 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,PIN,0,20;SID "SID" true true false 4 Long 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,SID,-1,-1;MUID "MUID" true true false 4 Long 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,MUID,-1,-1;AddNum_Pre "AddNum_Pre" true true false 15 Text 0 0,First,#,Reg2_Structure_Pts,ADDPFX,0,3;Add_Number "Add_Number" true true false 4 Long 0 0,First,#,Reg2_Structure_Pts,ADDNUM,-1,-1;AddNum_Suf "AddNum_Suf" true true false 15 Text 0 0,First,#,Reg2_Structure_Pts,ADDSFX,0,3;Site "Site" true true false 75 Text 0 0,First,#;SubSite "SubSite" true true false 75 Text 0 0,First,#;Structure "Structure" true true false 75 Text 0 0,First,#;Wing "Wing" true true false 75 Text 0 0,First,#;Unit_Type "Unit_Type" true true false 75 Text 0 0,First,#;Unit_Value "Unit_Value" true true false 75 Text 0 0,First,#;Room "Room" true true false 75 Text 0 0,First,#;Section "Section" true true false 75 Text 0 0,First,#;Row "Row" true true false 75 Text 0 0,First,#;Seat "Seat" true true false 75 Text 0 0,First,#;Floor "Floor" true true false 75 Text 0 0,First,#;St_PreMod "St_PreMod" true true false 15 Text 0 0,First,#,Reg2_Structure_Pts,RDRPREMOD,0,6;St_PreDir "St_PreDir" true true false 9 Text 0 0,First,#,Reg2_Structure_Pts,RDRPREDIR,0,3;St_PreTyp "St_PreTyp" true true false 50 Text 0 0,First,#,Reg2_Structure_Pts,RDRPREFIX,0,6;St_PreSep "St_PreSep" true true false 20 Text 0 0,First,#;St_Name "St_Name" true true false 60 Text 0 0,First,#,Reg2_Structure_Pts,RDNAME,0,60;St_PosTyp "St_PosTyp" true true false 50 Text 0 0,First,#,Reg2_Structure_Pts,RDSUFFIX,0,6;St_PosDir "St_PosDir" true true false 9 Text 0 0,First,#,Reg2_Structure_Pts,RDPOSTDIR,0,3;St_PosMod "St_PosMod" true true false 25 Text 0 0,First,#,Reg2_Structure_Pts,RDPOSTMOD,0,6;LSt_PreDir "LSt_PreDir" true true false 2 Text 0 0,First,#;LSt_Name "LSt_Name" true true false 75 Text 0 0,First,#;LSt_Typ "LSt_Typ" true true false 4 Text 0 0,First,#;LSt_PosDir "LSt_PosDir" true true false 2 Text 0 0,First,#;Full_Address "Full_Address" true true false 100 Text 0 0,First,#,Reg2_Structure_Pts,FULLADDRESS,0,100;Label "Label" true true false 100 Text 0 0,First,#,Reg2_Structure_Pts,ROADNM,0,70;LandmkName "LandmkName" true true false 150 Text 0 0,First,#;Country "Country" true true false 2 Text 0 0,First,#;State "State" true true false 2 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,STATE,0,2;County "County" true true false 100 Text 0 0,First,#;Inc_Muni "Inc_Muni" true true false 100 Text 0 0,First,#,Reg2_Structure_Pts,INC,0,6;Uninc_Comm "Uninc_Comm" true true false 100 Text 0 0,First,#;Nbrhd_Comm "Nbrhd_Comm" true true false 100 Text 0 0,First,#;Post_Comm "Post_Comm" true true false 40 Text 0 0,First,#,Reg2_Structure_Pts,COMMNAME,0,25;Post_Code "Post_Code" true true false 7 Text 0 0,First,#,Reg2_Structure_Pts,ZIP,0,12;Post_Code4 "Post_Code4" true true false 4 Text 0 0,First,#,Reg2_Structure_Pts,ZIP_4,0,6;ESN "ESN" true true false 5 Text 0 0,First,#;MSAGComm "MSAGComm" true true false 30 Text 0 0,First,#;Addtl_Loc "Addtl_Loc" true true false 225 Text 0 0,First,#;Milepost "Milepost" true true false 150 Text 0 0,First,#;APA_Code "APA_Code" true true false 4 Long 0 0,First,#,Reg2_Structure_Pts,APACODE,-1,-1;Place_Type "Place_Type" true true false 50 Text 0 0,First,#;PlacementMethod "PlacementMethod" true true false 25 Text 0 0,First,#;Long "Long" true true false 8 Double 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,LONG,-1,-1;Lat "Lat" true true false 8 Double 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,LAT,-1,-1;Elev "Elev" true true false 2 Short 0 0,First,#;AddDataURI "AddDataURI" true true false 254 Text 0 0,First,#;CreateDate "CreateDate" true true false 255 Text 0 0,First,#,Reg2_Structure_Pts,CRTEDATE,0,255;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,Reg2_Structure_Pts,CHNGDATE,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#;Expire "Expire" true true false 8 Date 0 0,First,#;Comments "Comments" true true false 255 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,COMMENTS,0,250;JUNK "JUNK" true true false 255 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,JUNK,0,255;JUNK2 "JUNK" true true false 255 Text 0 0,First,#;JUNK3 "JUNK" true true false 255 Text 0 0,First,#;RCL_MUID "RCL_MUID" true true false 255 Text 0 0,First,#;SBUNITTYPE "SBUNITTYPE" true true false 10 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,SBUNITTYPE,0,10;SBUNITID "SBUNITID" true true false 10 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,SBUNITID,0,10;PRIMSTRUCT "PRIMSTRUCT" true true false 10 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,PRIMSTRUCT,0,10;PRIMADD "PRIMADD" true true false 10 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,PRIMADD,0,10;PRUNITTYPE "PRUNITTYPE" true true false 255 Text 0 0,First,#;PRUNITID "PRUNITID" true true false 255 Text 0 0,First,#;STRUCTTYPE "STRUCTTYPE" true true false 255 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,STRUCTTYPE,0,15;LANDMARK "LANDMARK" true true false 50 Text 0 0,First,#,G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Structure_Pts,LANDMARK,0,50;Place_Name "Place_Name" true true false 255 Text 0 0,First,#;CommonName "CommonName" true true false 255 Text 0 0,First,#" # # FeatureClassToFeatureClass Reg2_Site_Structure G:\GIS_Projects\Projects\E911\VestaMap\vesta_NPC.gdb Reg2_Site_Structure_Angel # "DiscrpAgID "DiscrpAgID" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,DiscrpAgID,0,100;Site_NGUID "Site_NGUID" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,Site_NGUID,0,254;GIS_STEW "GIS_STEW" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,GIS_STEW,0,20;PIN "PIN" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,PIN,0,20;SID "SID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,SID,-1,-1;MUID "MUID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,MUID,-1,-1;AddNum_Pre "AddNum_Pre" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Pre,0,15;Add_Number "Add_Number" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,Add_Number,-1,-1;AddNum_Suf "AddNum_Suf" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Suf,0,15;Site "Site" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Site,0,75;SubSite "SubSite" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,SubSite,0,75;Structure "Structure" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Structure,0,75;Wing "Wing" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Wing,0,75;Unit_Type "Unit_Type" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Type,0,75;Unit_Value "Unit_Value" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Value,0,75;Room "Room" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Room,0,75;Section "Section" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Section,0,75;Row "Row" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Row,0,75;Seat "Seat" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Seat,0,75;Floor "Floor" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Floor,0,75;St_PreMod "St_PreMod" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,St_PreMod,0,15;St_PreDir "St_PreDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PreDir,0,9;St_PreTyp "St_PreTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PreTyp,0,50;St_PreSep "St_PreSep" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,St_PreSep,0,20;St_Name "St_Name" true true false 60 Text 0 0,First,#,Reg2_Site_Structure,St_Name,0,60;St_PosTyp "St_PosTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PosTyp,0,50;St_PosDir "St_PosDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PosDir,0,9;St_PosMod "St_PosMod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,St_PosMod,0,25;LSt_PreDir "LSt_PreDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PreDir,0,2;LSt_Name "LSt_Name" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,LSt_Name,0,75;LSt_Typ "LSt_Typ" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,LSt_Typ,0,4;LSt_PosDir "LSt_PosDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PosDir,0,2;Full_Address "Full_Address" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Full_Address,0,100;Label "Label" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Label,0,100;LandmkName "LandmkName" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,LandmkName,0,150;Country "Country" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,Country,0,2;State "State" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,State,0,2;County "County" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,County,0,100;Inc_Muni "Inc_Muni" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Nbrhd_Comm,0,100;Post_Comm "Post_Comm" true true false 40 Text 0 0,First,#,Reg2_Site_Structure,Post_Comm,0,40;Post_Code "Post_Code" true true false 7 Text 0 0,First,#,Reg2_Site_Structure,Post_Code,0,7;PostCodeEx "Post_Code4" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,PostCodeEx,0,4;ESN "ESN" true true false 5 Text 0 0,First,#,Reg2_Site_Structure,ESN,0,5;MSAGComm "MSAGComm" true true false 30 Text 0 0,First,#,Reg2_Site_Structure,MSAGComm,0,30;Addtl_Loc "Addtl_Loc" true true false 225 Text 0 0,First,#,Reg2_Site_Structure,Addtl_Loc,0,225;Milepost "Milepost" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,Milepost,0,150;APA_Code "APA_Code" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,APA_Code,-1,-1;Place_Type "Place_Type" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,Place_Type,0,50;PlacementMethod "PlacementMethod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,PlacementMethod,0,25;Long "Long" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Long,-1,-1;Lat "Lat" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Lat,-1,-1;Elev "Elev" true true false 2 Short 0 0,First,#,Reg2_Site_Structure,Elev,-1,-1;CreateDate "CreateDate" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,CreateDate,0,255;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Expire,-1,-1;AddDataURI "AddDataURI" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,AddDataURI,0,254;Comments "Comments" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Comments,0,255;Data_Source "Data_Source" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source,0,255;Data_Source_ID "Data_Source_ID" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source_ID,0,255;JUNK "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK,0,255;JUNK2 "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK2,0,255;JUNK3 "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK3,0,255;SBUNITTYPE "SBUNITTYPE" true true false 10 Text 0 0,First,#,Reg2_Site_Structure,SBUNITTYPE,0,10;SBUNITID "SBUNITID" true true false 10 Text 0 0,First,#,Reg2_Site_Structure,SBUNITID,0,10;PRIMSTRUCT "PRIMSTRUCT" true true false 10 Text 0 0,First,#,Reg2_Site_Structure,PRIMSTRUCT,0,10;PRIMADD "PRIMADD" true true false 10 Text 0 0,First,#,Reg2_Site_Structure,PRIMADD,0,10;PRUNITTYPE "PRUNITTYPE" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,PRUNITTYPE,0,255;PRUNITID "PRUNITID" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,PRUNITID,0,255;STRUCTTYPE "STRUCTTYPE" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,STRUCTTYPE,0,255;LANDMARK "LANDMARK" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,LANDMARK,0,50;Place_Name "Place_Name" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Place_Name,0,255;CommonName "CommonName" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,CommonName,0,255" # CopyMultiple "G:\GIS_Projects\Projects\E911\VestaMap\vesta_NPC.gdb\Reg2_Site_Structure_Angel FeatureClass" G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb Reg2_Site_Structure_Angel "Reg2_Site_Structure_Angel FeatureClass Reg2_Site_Structure_Angel #" Rename G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Site_Structure_Angel G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb\Reg2_Site_Structure 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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>GIS_STEW</field_name><domain_name>Reg2_GIS_STEW</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PreMod</field_name><domain_name>Reg2_StreetNamePreMod</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PreDir</field_name><domain_name>Reg2_StreetNameDirectional</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PreTyp</field_name><domain_name>Reg2_StreetNamePreType</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PreSep</field_name><domain_name>Reg2_StreetNamePreTypeSeparator</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PosTyp</field_name><domain_name>Reg2_StreetNamePostType</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PosDir</field_name><domain_name>Reg2_StreetNameDirectional</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PosMod</field_name><domain_name>Reg2_StreetNamePostMod</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LSt_PreDir</field_name><domain_name>Reg2_LegacyStreetNameDirectional</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LSt_Typ</field_name><domain_name>Reg2_LegacyStreetNameType</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LSt_PosDir</field_name><domain_name>Reg2_LegacyStreetNameDirectional</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Country</field_name><domain_name>Reg2_Country</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>State</field_name><domain_name>Reg2_State</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>County</field_name><domain_name>Reg2_County</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Inc_Muni</field_name><domain_name>Reg2_Inc_Muni</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>PlacementMethod</field_name><domain_name>Reg2_PlacementMethod</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>PlacementMethod</field_name><domain_name>Reg2_PlacementMethod</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField Reg2_Site_Structure AddNum_Pre None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure AddNum_Suf None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure AddNum_Pre None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure AddNum_Suf None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PreMod None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PreDir None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PreTyp None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosDir None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosMod None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosMod None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LSt_PreDir None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Full_Address None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure State "ID" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure SBUNITTYPE None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure SBUNITID None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PRIMSTRUCT None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PRUNITTYPE None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PRIMADD None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure STRUCTTYPE None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LANDMARK None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PIN None "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>PostCodeEx</field_name><new_field_name>Post_Code4</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Place_Name</field_name><field_name>CommonName</field_name></DeleteField></workflow></operationSequence> CalculateField Reg2_Site_Structure LandmkName !LANDMARK! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure LANDMARK "Delete Fields" DeleteField Reg2_Site_Structure PRUNITTYPE;PRUNITID "Delete Fields" DeleteField Reg2_Site_Structure STRUCTTYPE "Delete Fields" DeleteField Reg2_Site_Structure PRIMADD "Delete Fields" 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>St_PosTyp</field_name></RemoveDomainFromField></workflow></operationSequence> CalculateField Reg2_Site_Structure St_PosTyp "AVENUE" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "STREET" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "DRIVE" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "ROAD" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "LANE" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "COURT" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "BOULEVARD" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name "!St_Name! + " RIDGE"" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name "!St_Name! + " HIGHWAY"" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "CIRCLE" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "ALLEY" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "BYPASS" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "TERRACE" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "POINT" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "VIEW" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "CANYON" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "PLACE" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "BEND" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "TRAIL" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PosTyp "RANCH" "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>St_PosTyp</field_name><domain_name>Reg2_StreetNamePostType</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>GIS_STEW</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Lot</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>Lot</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Court</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Court</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure PARSER_a myParser(!Full_Address!) "Python 3" "def myParser(inString): splitString = inString.split(' ') a = splitString[0] b = splitString[1] c = ' '.join(splitString[2:-1]) d = splitString[-1] return a " Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_b myParser(!Full_Address!) "Python 3" "def myParser(inString): splitString = inString.split(' ') ###splits the address into a list a = splitString[0] ### list item 0 is the house number b = splitString[1] ### list item 1 is the prefix c = ' '.join(splitString[2:-1]) ### this returns the street name d = splitString[-1] ### this returns the suf dir or street type return b ###choose appropriate variable" Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_c myParser(!Full_Address!) "Python 3" "def myParser(inString): splitString = inString.split(' ') ###splits the address into a list a = splitString[0] ### list item 0 is the house number b = splitString[1] ### list item 1 is the prefix c = ' '.join(splitString[2:-1]) ### this returns the street name d = splitString[-1] ### this returns the suf dir or street type return c ###choose appropriate variable" Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_d myParser(!Full_Address!) "Python 3" "def myParser(inString): splitString = inString.split(' ') ###splits the address into a list a = splitString[0] ### list item 0 is the house number b = splitString[1] ### list item 1 is the prefix c = ' '.join(splitString[2:-1]) ### this returns the street name d = splitString[-1] ### this returns the suf dir or street type return d ###choose appropriate variable" Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_c myParser(!Full_Address!) "Python 3" "def myParser(inString): splitString = inString.split(' ') ###splits the address into a list a = splitString[0] ### list item 0 is the house number b = splitString[1] ### list item 1 is the prefix c = ' '.join(splitString[2:-1]) ### this returns the street name d = splitString[-1] ### this returns the suf dir or street type return c ###choose appropriate variable" Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_c myParser(!Label!) "Python 3" "def myParser(inString): splitString = inString.split(' ') ###splits the address into a list c = ' '.join(splitString[0:-1]) ### this returns the street name d = splitString[-1] ### this returns the suf dir or street type return c ###choose appropriate variable" Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_d myParser(!Label!) "Python 3" "def myParser(inString): splitString = inString.split(' ') ###splits the address into a list c = ' '.join(splitString[0:-1]) ### this returns the street name d = splitString[-1] ### this returns the suf dir or street type return d ###choose appropriate variable" Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure JUNK "NEW - NO DATA" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure JUNK2 "PARSE IN PROGRESS" "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>PARSER_a_text</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>PARSER_a_text</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure PARSER_a_text !PARSER_a! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure PARSER_a_text "Delete Fields" 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>PARSE_a_num</field_name><field_type>LONG</field_type><field_alias>PARSE_a_num</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure PARSE_a_num !PARSER_a! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure PARSE_a_num "Delete Fields" DeleteField Reg2_Site_Structure PARSER_a "Delete Fields" 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>ORIGINAL_NAME</field_name><field_type>LONG</field_type><field_alias>ORIGINAL_NAME</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>ORIGINAL_NAME</field_name></DeleteField></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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>ORIGINAL_NAME</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>ORIGINAL_NAME</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure PARSER_c !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_PreTyp !PARSER_c! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LSt_Name "!PARSER_c! + " " + !St_Name!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure ORIGINAL_NAME !Label! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_c! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure ORIGINAL_NAME !Label! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Unit_Value !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Unit_Value !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure ORIGINAL_NAME !Full_Address! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure ORIGINAL_NAME !Label! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_c! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>St_PreMod</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>St_PreMod</field_name><domain_name>Reg2_StreetNamePreMod</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField Reg2_Site_Structure PARSER_c "!PARSER_b! + " " + !PARSER_c!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_b "!PARSER_b! + " " + !PARSER_d!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_b! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_d !Label! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_d! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_c! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_b! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure PARSER_b None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_c! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name "!PARSER_b! + " " + !PARSER_c!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name "!PARSER_b! + " " + !PARSER_c!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name "!PARSER_b! + " " + !PARSER_c!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name !PARSER_c! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure St_Name "!PARSER_b! + " " + !PARSER_c!" "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure PARSER_d "Delete Fields" DeleteField Reg2_Site_Structure PARSER_b;PARSER_c "Delete Fields" CalculateField Reg2_Site_Structure Site !Court! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Court! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Unit_Type !SBUNITTYPE! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Unit_Value !SBUNITID! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure SBUNITTYPE;SBUNITID "Delete Fields" CalculateField Reg2_Site_Structure JUNK "UNIT CHECK FULL ADDRESS" "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure Court "Delete Fields" CalculateField Reg2_Site_Structure Comments ""UNIT DISCREPANCY - " + !Lot!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments ""Unit Discrepancy - " + !Lot!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments ""Check Unit Discrepancy - " + !Lot!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments ""check Unit discrepancy - " + !Lot!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments ""check Unit_Value discrepancy - " + !Lot!" "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure Lot "Delete Fields" CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Unit_Range</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Unit_Range</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure Unit_Range !Unit_Value! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Structure !LandmkName! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Structure! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Structure! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Structure! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Structure! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Structure! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Structure! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Structure None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Comments None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>COMMENTS2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>COMMENTS2</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>CONCAT_ID</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>CONCAT_ID</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure CONCAT_ID "$feature.GIS_STEW + "." + $feature.SID" Arcade # Text NO_ENFORCE_DOMAINS AddIndex "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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" CONCAT_ID CONCAT_ID NON_UNIQUE NON_ASCENDING CalculateField Reg2_Site_Structure Site_NGUID !CONCAT_ID! "Python 3" # Text NO_ENFORCE_DOMAINS AddIndex "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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" Site_NGUID Site_NGUID NON_UNIQUE NON_ASCENDING RemoveIndex "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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" CONCAT_ID RemoveIndex "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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" Site_NGUID DeleteField Reg2_Site_Structure CONCAT_ID "Delete Fields" DeleteField Reg2_Site_Structure COMMENTS2 "Delete Fields" CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Structure !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure LandmkName !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Structure !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Reg2_Site_Structure Site !Comments! "Python 3" # Text NO_ENFORCE_DOMAINS FeatureClassToFeatureClass Reg2_Site_Structure G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb Reg2_Site_Structure_new # "DiscrpAgID "DiscrpAgID" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,DiscrpAgID,0,100;Site_NGUID "Site_NGUID" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,Site_NGUID,0,254;GIS_Steward "GIS_Steward" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,GIS_STEW,0,20;Parcel_ID "Parcel_ID" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,PIN,0,20;SID "SID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,SID,-1,-1;MUID "MUID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,MUID,-1,-1;AddNum_Pre "AddNum_Pre" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Pre,0,15;Add_Number "Add_Number" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,Add_Number,-1,-1;AddNum_Suf "AddNum_Suf" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Suf,0,15;Site "Site" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Site,0,75;SubSite "SubSite" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,SubSite,0,75;Structure "Structure" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Structure,0,75;Wing "Wing" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Wing,0,75;Unit_Type "Unit_Type" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Type,0,75;Unit_Value "Unit_Value" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Value,0,75;Unit_Range "Unit_Range" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Unit_Range,0,255;Room "Room" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Room,0,75;Section "Section" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Section,0,75;Row "Row" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Row,0,75;Seat "Seat" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Seat,0,75;Floor "Floor" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Floor,0,75;Addtl_Loc "Addtl_Loc" true true false 225 Text 0 0,First,#,Reg2_Site_Structure,Addtl_Loc,0,225;LandmkName "LandmkName" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,LandmkName,0,150;St_PreMod "St_PreMod" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,St_PreMod,0,15;St_PreDir "St_PreDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PreDir,0,9;St_PreTyp "St_PreTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PreTyp,0,50;St_PreSep "St_PreSep" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,St_PreSep,0,20;St_Name "St_Name" true true false 60 Text 0 0,First,#,Reg2_Site_Structure,St_Name,0,60;St_PosTyp "St_PosTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PosTyp,0,50;St_PosDir "St_PosDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PosDir,0,9;St_PosMod "St_PosMod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,St_PosMod,0,25;LSt_PreDir "LSt_PreDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PreDir,0,2;LSt_Name "LSt_Name" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,LSt_Name,0,75;LSt_Typ "LSt_Typ" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,LSt_Typ,0,4;LSt_PosDir "LSt_PosDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PosDir,0,2;Full_Address "Full_Address" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Full_Address,0,100;Label "Label" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Label,0,100;Country "Country" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,Country,0,2;State "State" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,State,0,2;County "County" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,County,0,100;Inc_Muni "Inc_Muni" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Nbrhd_Comm,0,100;Post_Comm "Post_Comm" true true false 40 Text 0 0,First,#,Reg2_Site_Structure,Post_Comm,0,40;Post_Code "Post_Code" true true false 7 Text 0 0,First,#,Reg2_Site_Structure,Post_Code,0,7;Post_Code4 "Post_Code4" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,Post_Code4,0,4;ESN "ESN" true true false 5 Text 0 0,First,#,Reg2_Site_Structure,ESN,0,5;MSAGComm "MSAGComm" true true false 30 Text 0 0,First,#,Reg2_Site_Structure,MSAGComm,0,30;Milepost "Milepost" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,Milepost,0,150;Long "Long" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Long,-1,-1;Lat "Lat" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Lat,-1,-1;Elev "Elev" true true false 2 Short 0 0,First,#,Reg2_Site_Structure,Elev,-1,-1;APA_Code "APA_Code" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,APA_Code,-1,-1;Place_Type "Place_Type" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,Place_Type,0,50;PlacementMethod "PlacementMethod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,PlacementMethod,0,25;Data_Source "Data_Source" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source,0,255;Data_Source_ID "Data_Source_ID" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source_ID,0,255;AddDataURI "AddDataURI" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,AddDataURI,0,254;Date_Create "Date_Create" true true false 255 Date 0 0,First,#;Date_Update "Date_Update" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,DateUpdate,-1,-1;Date_Effective "Date_Effective" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Effective,-1,-1;Date_Expire "Date_Expire" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Expire,-1,-1;Comments "Comments" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Comments,0,255;Date_Create_text "Date_Create_text" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,CreateDate,0,255;JUNK "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK,0,255;JUNK2 "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK2,0,255;JUNK3 "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK3,0,255;PRIMSTRUCT "PRIMSTRUCT" true true false 10 Text 0 0,First,#,Reg2_Site_Structure,PRIMSTRUCT,0,10;ORIGINAL_NAME "ORIGINAL_NAME" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,ORIGINAL_NAME,0,255" # CalculateField Reg2_Site_Structure_new Date_Create !Date_Create_text! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure_new Date_Create_text "Delete Fields" 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure_new</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>STATUS</field_name><field_type>TEXT</field_type><field_length>75</field_length><field_alias>STATUS</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure_new STATUS "!PRIMSTRUCT! + " STRUCTURE"" "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure_new PRIMSTRUCT "Delete Fields" FeatureClassToFeatureClass Reg2_Site_Structure_new G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb Reg2_Site_Structure # "DiscrpAgID "DiscrpAgID" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,DiscrpAgID,0,100;Site_NGUID "Site_NGUID" true true false 254 Text 0 0,First,#,Reg2_Site_Structure_new,Site_NGUID,0,254;GIS_Steward "GIS_Steward" true true false 20 Text 0 0,First,#,Reg2_Site_Structure_new,GIS_Steward,0,20;Parcel_ID "Parcel_ID" true true false 20 Text 0 0,First,#,Reg2_Site_Structure_new,Parcel_ID,0,20;SID "SID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure_new,SID,-1,-1;MUID "MUID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure_new,MUID,-1,-1;AddNum_Pre "AddNum_Pre" true true false 15 Text 0 0,First,#,Reg2_Site_Structure_new,AddNum_Pre,0,15;Add_Number "Add_Number" true true false 4 Long 0 0,First,#,Reg2_Site_Structure_new,Add_Number,-1,-1;AddNum_Suf "AddNum_Suf" true true false 15 Text 0 0,First,#,Reg2_Site_Structure_new,AddNum_Suf,0,15;Site "Site" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Site,0,75;SubSite "SubSite" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,SubSite,0,75;Structure "Structure" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Structure,0,75;Status "Status" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,STATUS,0,75;Wing "Wing" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Wing,0,75;Unit_Type "Unit_Type" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Unit_Type,0,75;Unit_Value "Unit_Value" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Unit_Value,0,75;Unit_Range "Unit_Range" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,Unit_Range,0,255;Room "Room" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Room,0,75;Section "Section" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Section,0,75;Row "Row" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Row,0,75;Seat "Seat" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Seat,0,75;Floor "Floor" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,Floor,0,75;Addtl_Loc "Addtl_Loc" true true false 225 Text 0 0,First,#,Reg2_Site_Structure_new,Addtl_Loc,0,225;LandmkName "LandmkName" true true false 150 Text 0 0,First,#,Reg2_Site_Structure_new,LandmkName,0,150;St_PreMod "St_PreMod" true true false 15 Text 0 0,First,#,Reg2_Site_Structure_new,St_PreMod,0,15;St_PreDir "St_PreDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure_new,St_PreDir,0,9;St_PreTyp "St_PreTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure_new,St_PreTyp,0,50;St_PreSep "St_PreSep" true true false 20 Text 0 0,First,#,Reg2_Site_Structure_new,St_PreSep,0,20;St_Name "St_Name" true true false 60 Text 0 0,First,#,Reg2_Site_Structure_new,St_Name,0,60;St_PosTyp "St_PosTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure_new,St_PosTyp,0,50;St_PosDir "St_PosDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure_new,St_PosDir,0,9;St_PosMod "St_PosMod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure_new,St_PosMod,0,25;LSt_PreDir "LSt_PreDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure_new,LSt_PreDir,0,2;LSt_Name "LSt_Name" true true false 75 Text 0 0,First,#,Reg2_Site_Structure_new,LSt_Name,0,75;LSt_Typ "LSt_Typ" true true false 4 Text 0 0,First,#,Reg2_Site_Structure_new,LSt_Typ,0,4;LSt_PosDir "LSt_PosDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure_new,LSt_PosDir,0,2;Full_Address "Full_Address" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,Full_Address,0,100;Label "Label" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,Label,0,100;Country "Country" true true false 2 Text 0 0,First,#,Reg2_Site_Structure_new,Country,0,2;State "State" true true false 2 Text 0 0,First,#,Reg2_Site_Structure_new,State,0,2;County "County" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,County,0,100;Inc_Muni "Inc_Muni" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure_new,Nbrhd_Comm,0,100;Post_Comm "Post_Comm" true true false 40 Text 0 0,First,#,Reg2_Site_Structure_new,Post_Comm,0,40;Post_Code "Post_Code" true true false 7 Text 0 0,First,#,Reg2_Site_Structure_new,Post_Code,0,7;Post_Code4 "Post_Code4" true true false 4 Text 0 0,First,#,Reg2_Site_Structure_new,Post_Code4,0,4;ESN "ESN" true true false 5 Text 0 0,First,#,Reg2_Site_Structure_new,ESN,0,5;MSAGComm "MSAGComm" true true false 30 Text 0 0,First,#,Reg2_Site_Structure_new,MSAGComm,0,30;APA_Code "APA_Code" true true false 4 Long 0 0,First,#,Reg2_Site_Structure_new,APA_Code,-1,-1;Place_Type "Place_Type" true true false 50 Text 0 0,First,#,Reg2_Site_Structure_new,Place_Type,0,50;PlacementMethod "PlacementMethod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure_new,PlacementMethod,0,25;Data_Source "Data_Source" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,Data_Source,0,255;Data_Source_ID "Data_Source_ID" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,Data_Source_ID,0,255;AddDataURI "AddDataURI" true true false 254 Text 0 0,First,#,Reg2_Site_Structure_new,AddDataURI,0,254;Milepost "Milepost" true true false 150 Text 0 0,First,#,Reg2_Site_Structure_new,Milepost,0,150;Long "Long" true true false 8 Double 0 0,First,#,Reg2_Site_Structure_new,Long,-1,-1;Lat "Lat" true true false 8 Double 0 0,First,#,Reg2_Site_Structure_new,Lat,-1,-1;Elev "Elev" true true false 2 Short 0 0,First,#,Reg2_Site_Structure_new,Elev,-1,-1;Date_Create "Date_Create" true true false 8 Date 0 0,First,#,Reg2_Site_Structure_new,Date_Create,-1,-1;Date_Update "Date_Update" true true false 8 Date 0 0,First,#,Reg2_Site_Structure_new,Date_Update,-1,-1;Date_Effective "Date_Effective" true true false 8 Date 0 0,First,#,Reg2_Site_Structure_new,Date_Effective,-1,-1;Date_Expire "Date_Expire" true true false 8 Date 0 0,First,#,Reg2_Site_Structure_new,Date_Expire,-1,-1;Comments "Comments" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,Comments,0,255;JUNK "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,JUNK,0,255;JUNK2 "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,JUNK2,0,255;JUNK3 "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure_new,JUNK3,0,255" # CalculateField Reg2_Site_Structure JUNK !JUNK3! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Reg2_Site_Structure JUNK2;JUNK3 "Delete Fields" 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>GIS_Steward</field_name><domain_name>Reg2_GIS_Steward</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Add_Number</field_name><domain_name>NENA_AddressNumber</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Status</field_name><new_field_name>Address_Status</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><CreateDomain><domain_name>Reg2_Status</domain_name><field_type>TEXT</field_type><domain_type>CODED</domain_type><split_policy>DEFAULT</split_policy><merge_policy>DEFAULT</merge_policy></CreateDomain><AddCodedValueToDomain><domain_name>Reg2_Status</domain_name></AddCodedValueToDomain></workflow><workflow><AlterField><field_name>Address_Status</field_name><new_field_name>Status</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Status</field_name><domain_name>Reg2_Status</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Status</field_name><new_field_name>Address_Status</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> FeatureClassToFeatureClass Reg2_Site_Structure G:\GIS_Projects\Projects\E911\VestaMap\vesta_NPC.gdb Reg2_Site_Structure # "DiscrpAgID "DiscrpAgID" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,DiscrpAgID,0,100;Site_NGUID "Site_NGUID" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,Site_NGUID,0,254;GIS_Steward "GIS_Steward" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,GIS_Steward,0,20;Parcel_ID "Parcel_ID" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,Parcel_ID,0,20;SID "SID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,SID,-1,-1;MUID "MUID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,MUID,-1,-1;AddNum_Pre "AddNum_Pre" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Pre,0,15;Add_Number "Add_Number" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,Add_Number,-1,-1;AddNum_Suf "AddNum_Suf" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Suf,0,15;Site "Site" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Site,0,75;SubSite "SubSite" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,SubSite,0,75;Structure "Structure" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Structure,0,75;Address_Status "Address_Status" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Address_Status,0,75;Wing "Wing" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Wing,0,75;Unit_Type "Unit_Type" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Type,0,75;Unit_Value "Unit_Value" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Value,0,75;Unit_Range "Unit_Range" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Unit_Range,0,255;Room "Room" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Room,0,75;Section "Section" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Section,0,75;Row "Row" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Row,0,75;Seat "Seat" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Seat,0,75;Floor "Floor" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Floor,0,75;Addtl_Loc "Addtl_Loc" true true false 225 Text 0 0,First,#,Reg2_Site_Structure,Addtl_Loc,0,225;LandmkName "LandmkName" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,LandmkName,0,150;St_PreMod "St_PreMod" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,St_PreMod,0,15;St_PreDir "St_PreDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PreDir,0,9;St_PreTyp "St_PreTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PreTyp,0,50;St_PreSep "St_PreSep" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,St_PreSep,0,20;St_Name "St_Name" true true false 60 Text 0 0,First,#,Reg2_Site_Structure,St_Name,0,60;St_PosTyp "St_PosTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PosTyp,0,50;St_PosDir "St_PosDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PosDir,0,9;St_PosMod "St_PosMod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,St_PosMod,0,25;LSt_PreDir "LSt_PreDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PreDir,0,2;LSt_Name "LSt_Name" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,LSt_Name,0,75;LSt_Typ "LSt_Typ" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,LSt_Typ,0,4;LSt_PosDir "LSt_PosDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PosDir,0,2;Full_Address "Full_Address" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Full_Address,0,100;Label "Label" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Label,0,100;Country "Country" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,Country,0,2;State "State" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,State,0,2;County "County" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,County,0,100;Inc_Muni "Inc_Muni" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Nbrhd_Comm,0,100;Post_Comm "Post_Comm" true true false 40 Text 0 0,First,#,Reg2_Site_Structure,Post_Comm,0,40;Post_Code "Post_Code" true true false 7 Text 0 0,First,#,Reg2_Site_Structure,Post_Code,0,7;Post_Code4 "Post_Code4" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,Post_Code4,0,4;ESN "ESN" true true false 5 Text 0 0,First,#,Reg2_Site_Structure,ESN,0,5;MSAGComm "MSAGComm" true true false 30 Text 0 0,First,#,Reg2_Site_Structure,MSAGComm,0,30;APA_Code "APA_Code" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,APA_Code,-1,-1;Place_Type "Place_Type" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,Place_Type,0,50;PlacementMethod "PlacementMethod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,PlacementMethod,0,25;Milepost "Milepost" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,Milepost,0,150;Long "Long" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Long,-1,-1;Lat "Lat" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Lat,-1,-1;Elev "Elev" true true false 2 Short 0 0,First,#,Reg2_Site_Structure,Elev,-1,-1;Data_Source "Data_Source" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source,0,255;Data_Source_ID "Data_Source_ID" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source_ID,0,255;AddDataURI "AddDataURI" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,AddDataURI,0,254;Date_Create "Date_Create" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Create,-1,-1;Date_Update "Date_Update" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Update,-1,-1;Date_Effective "Date_Effective" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Effective,-1,-1;Date_Expire "Date_Expire" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Expire,-1,-1;Comments "Comments" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Comments,0,255;JUNK "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK,0,255" # FeatureClassToFeatureClass Reg2_Site_Structure G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb Reg2_Site_Structure # "DiscrpAgID "DiscrpAgID" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,DiscrpAgID,0,100;Site_NGUID "Site_NGUID" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,Site_NGUID,0,254;GIS_Steward "GIS_Steward" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,GIS_Steward,0,20;Parcel_ID "Parcel_ID" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,Parcel_ID,0,20;SID "SID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,SID,-1,-1;MUID "MUID" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,MUID,-1,-1;AddNum_Pre "AddNum_Pre" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Pre,0,15;Add_Number "Add_Number" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,Add_Number,-1,-1;AddNum_Suf "AddNum_Suf" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,AddNum_Suf,0,15;Site "Site" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Site,0,75;SubSite "SubSite" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,SubSite,0,75;Structure "Structure" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Structure,0,75;Address_Status "Address_Status" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Address_Status,0,75;Wing "Wing" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Wing,0,75;Unit_Type "Unit_Type" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Type,0,75;Unit_Value "Unit_Value" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Unit_Value,0,75;Unit_Range "Unit_Range" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Unit_Range,0,255;Room "Room" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Room,0,75;Section "Section" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Section,0,75;Row "Row" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Row,0,75;Seat "Seat" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Seat,0,75;Floor "Floor" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,Floor,0,75;Addtl_Loc "Addtl_Loc" true true false 225 Text 0 0,First,#,Reg2_Site_Structure,Addtl_Loc,0,225;LandmkName "LandmkName" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,LandmkName,0,150;St_PreMod "St_PreMod" true true false 15 Text 0 0,First,#,Reg2_Site_Structure,St_PreMod,0,15;St_PreDir "St_PreDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PreDir,0,9;St_PreTyp "St_PreTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PreTyp,0,50;St_PreSep "St_PreSep" true true false 20 Text 0 0,First,#,Reg2_Site_Structure,St_PreSep,0,20;St_Name "St_Name" true true false 60 Text 0 0,First,#,Reg2_Site_Structure,St_Name,0,60;St_PosTyp "St_PosTyp" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,St_PosTyp,0,50;St_PosDir "St_PosDir" true true false 9 Text 0 0,First,#,Reg2_Site_Structure,St_PosDir,0,9;St_PosMod "St_PosMod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,St_PosMod,0,25;LSt_PreDir "LSt_PreDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PreDir,0,2;LSt_Name "LSt_Name" true true false 75 Text 0 0,First,#,Reg2_Site_Structure,LSt_Name,0,75;LSt_Typ "LSt_Typ" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,LSt_Typ,0,4;LSt_PosDir "LSt_PosDir" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,LSt_PosDir,0,2;Full_Address "Full_Address" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Full_Address,0,100;Label "Label" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Label,0,100;Country "Country" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,Country,0,2;State "State" true true false 2 Text 0 0,First,#,Reg2_Site_Structure,State,0,2;County "County" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,County,0,100;Inc_Muni "Inc_Muni" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true true false 100 Text 0 0,First,#,Reg2_Site_Structure,Nbrhd_Comm,0,100;Post_Comm "Post_Comm" true true false 40 Text 0 0,First,#,Reg2_Site_Structure,Post_Comm,0,40;Post_Code "Post_Code" true true false 7 Text 0 0,First,#,Reg2_Site_Structure,Post_Code,0,7;Post_Code4 "Post_Code4" true true false 4 Text 0 0,First,#,Reg2_Site_Structure,Post_Code4,0,4;ESN "ESN" true true false 5 Text 0 0,First,#,Reg2_Site_Structure,ESN,0,5;MSAGComm "MSAGComm" true true false 30 Text 0 0,First,#,Reg2_Site_Structure,MSAGComm,0,30;APA_Code "APA_Code" true true false 4 Long 0 0,First,#,Reg2_Site_Structure,APA_Code,-1,-1;Place_Type "Place_Type" true true false 50 Text 0 0,First,#,Reg2_Site_Structure,Place_Type,0,50;PlacementMethod "PlacementMethod" true true false 25 Text 0 0,First,#,Reg2_Site_Structure,PlacementMethod,0,25;Milepost "Milepost" true true false 150 Text 0 0,First,#,Reg2_Site_Structure,Milepost,0,150;Long "Long" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Long,-1,-1;Lat "Lat" true true false 8 Double 0 0,First,#,Reg2_Site_Structure,Lat,-1,-1;Elev "Elev" true true false 2 Short 0 0,First,#,Reg2_Site_Structure,Elev,-1,-1;Data_Source "Data_Source" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source,0,255;Data_Source_ID "Data_Source_ID" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Data_Source_ID,0,255;AddDataURI "AddDataURI" true true false 254 Text 0 0,First,#,Reg2_Site_Structure,AddDataURI,0,254;Date_Create "Date_Create" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Create,-1,-1;Date_Update "Date_Update" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Update,-1,-1;Date_Effective "Date_Effective" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Effective,-1,-1;Date_Expire "Date_Expire" true true false 8 Date 0 0,First,#,Reg2_Site_Structure,Date_Expire,-1,-1;Comments "Comments" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,Comments,0,255;JUNK "JUNK" true true false 255 Text 0 0,First,#,Reg2_Site_Structure,JUNK,0,255" # 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>GIS_Steward</field_name><domain_name>Reg2_GIS_Steward</domain_name></AssignDomainToField></workflow><workflow><AddField><field_name>junk2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>junk2</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Reg2_Site_Structure junk2 !GIS_Steward! "Python 3" # Text NO_ENFORCE_DOMAINS 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>GIS_Steward</field_name><domain_name>Reg2_GIS_STEW</domain_name></AssignDomainToField></workflow></operationSequence> DeleteField Reg2_Site_Structure junk2 "Delete Fields" 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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>St_PosDir</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>St_PosDir</field_name><domain_name>Reg2_StreetNameDirectional</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.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>St_PreDir</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/2.9.0'><WorkspaceConnectionString>DATABASE=G:\GIS_Projects\Projects\E911\VestaMap\vesta_map_Reg2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Reg2_Site_Structure</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>St_PreDir</field_name><domain_name>Reg2_StreetNameDirectional</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField NPC_GIS.GIS.Reg2_Site_Structure JUNK [MUID_FIPS] VB # CalculateField NPC_GIS.GIS.Reg2_Site_Structure MUID_FIPS "<NULL>" VB # CalculateField NPC_GIS.GIS.Reg2_Site_Structure MUID_FIPS [Milepost] VB # CopyFeatures "J:\GIS\LAYERS AND DATA\COUNTY\NezPerce\2022Update\npc_ng911\Reg2_Site_RCL.gdb\Reg2_SiteStructurePoints" C:\Users\avanderpas\Documents\ArcGIS\Projects\Addressing\cgE911.sde\cgE911.DBO.enNextGeneration\cgE911.DBO.Reg2_SiteStructurePoints # # # # CopyFeatures cgE911.DBO.Reg2_SiteStructurePoints "J:\LAYERS AND DATA\LEWISTON\STORMWATER\STORMWATER_UTILITY\DataBuildStormwater\cgAddress.sde\DBO.adAddressing\DBO.cgE911_DBO_Reg2_SiteStructurePoints" # # # # Rename "J:\LAYERS AND DATA\LEWISTON\STORMWATER\STORMWATER_UTILITY\DataBuildStormwater\cgAddress.sde\DBO.adAddressing\DBO.cgE911_DBO_Reg2_SiteStructurePoints" "J:\LAYERS AND DATA\LEWISTON\STORMWATER\STORMWATER_UTILITY\DataBuildStormwater\cgAddress.sde\DBO.adAddressing\DBO.adAddress" FeatureClass 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>DBO.adAddressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6833684c465151324d5459516c4e31774248386f4f35653937314249666e705242592f635a657251343279343d2a00;ENCRYPTED_PASSWORD=00022e6839646c6639446453433164766e4736724847655a434a786b73486a6875504b3132797865344d68394331673d2a00;SERVER=vsmsql-02;INSTANCE=sde:sqlserver:vsmsql-02\gisenterprise;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=vsmsql-02\gisenterprise;DATABASE=cgAddress;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>adAddress</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CartegraphID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Installed</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Retired</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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>DBO.adAddressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6833684c465151324d5459516c4e31774248386f4f35653937314249666e705242592f635a657251343279343d2a00;ENCRYPTED_PASSWORD=00022e6839646c6639446453433164766e4736724847655a434a786b73486a6875504b3132797865344d68394331673d2a00;SERVER=vsmsql-02;INSTANCE=sde:sqlserver:vsmsql-02\gisenterprise;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=vsmsql-02\gisenterprise;DATABASE=cgAddress;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>adAddress</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>adFloor</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>adFootprint</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>adSite</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField adAddress CartegraphID !OBJECTID! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress CartegraphID ""adad" + !CartegraphID!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress QC_Status "965" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress QC_Status None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "adAddress selection selection" QC_Status "965" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress QC_Status None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "adAddress selection selection" QC_Status "965" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress QC_Status None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress QC_Status "965" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress Comments None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField adAddress QC_Status None "Python 3" # Text NO_ENFORCE_DOMAINS DBO.cgE911_DBO_Reg2_SiteStructurePoints 002 Server=vsmsql-02; Service=sde:sqlserver:vsmsql-02\gisenterprise; Database=cgAddress; User=sa; Version=sde.DEFAULT ArcSDE Connection Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Idaho_West_FIPS_1103_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/3.0.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Idaho_West_FIPS_1103_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,2624666.666666666],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-115.75],PARAMETER[&quot;Scale_Factor&quot;,0.9999333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,41.66666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2243]]</WKT><XOrigin>-15822600</XOrigin><YOrigin>-47951700</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102670</WKID><LatestWKID>2243</LatestWKID></ProjectedCoordinateSystem> 20230105 14015600 20230105 14015600 Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.0.2.36056 adAddressH address Hosted address layer (copy) 04-15-2024 Enterprise Geodatabase Feature Class dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE DBO.cgE911_DBO_Reg2_SiteStructurePoints Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. DiscrpAgID DiscrpAgID String 100 0 0 NGUID NGUID String 254 0 0 FIPSCode FIPSCode Integer 4 10 0 GIS_Steward GIS_Steward String 25 0 0 LUID LUID Integer 4 10 0 Parcel_ID Parcel_ID String 25 0 0 FullAddress FullAddress String 254 0 0 MUID MUID Integer 4 10 0 Placement Placement String 25 0 0 Site_Status Site_Status String 25 0 0 AddNum_Pre AddNum_Pre String 15 0 0 Add_Number Add_Number Integer 4 10 0 LSt_Label LSt_Label String 100 0 0 AddNum_Suf AddNum_Suf String 15 0 0 Building Building String 75 0 0 Unit_Type Unit_Type String 10 0 0 FullUnit FullUnit String 75 0 0 Unit_Value Unit_Value String 25 0 0 Unit_Range Unit_Range String 25 0 0 Room Room String 75 0 0 Floor Floor String 75 0 0 LocateInfo LocateInfo String 225 0 0 FullStName FullStName String 254 0 0 St_PreMod St_PreMod String 15 0 0 St_PreDir St_PreDir String 9 0 0 St_PreTyp St_PreTyp String 50 0 0 St_PreSep St_PreSep String 20 0 0 St_Name St_Name String 254 0 0 St_PosTyp St_PosTyp String 50 0 0 St_PosDir St_PosDir String 9 0 0 St_PosMod St_PosMod String 25 0 0 LSt_PreDir LSt_PreDir String 2 0 0 LSt_Name LSt_Name String 75 0 0 LSt_Typ LSt_Typ String 4 0 0 LSt_PosDir LSt_PosDir String 2 0 0 LandmkName LandmkName String 150 0 0 Country Country String 2 0 0 State State String 2 0 0 County County String 100 0 0 Inc_Muni Inc_Muni String 100 0 0 Post_Comm Post_Comm String 40 0 0 PostCodeEx PostCodeEx String 4 0 0 Post_Code Post_Code String 7 0 0 ESN ESN String 5 0 0 MSAGComm MSAGComm String 30 0 0 APACode APACode Integer 4 10 0 Milepost Milepost String 150 0 0 Longitude Longitude Double 8 38 8 Latitude Latitude Double 8 38 8 Elevation Elevation Integer 4 10 0 DataSource DataSource String 100 0 0 DataSrceType DataSrceType String 25 0 0 DataSrceID DataSrceID String 100 0 0 DataSrceURL DataSrceURL String 254 0 0 Place_Type Place_Type String 50 0 0 DateCreate DateCreate Date 8 0 0 DateUpdate DateUpdate Date 8 0 0 DateEffective DateEffective Date 8 0 0 DateExpire DateExpire Date 8 0 0 Comments Comments String 254 0 0 QC_Status QC_Status String 75 0 0 QC_Notes QC_Notes String 254 0 0 20230105 iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAABqFJREFUeJzt3M+LnAcdx/HP/NrN7uyvrqmmzSZNmtqG/oqp0Uq1FxW8SNFD qaUHEVEED949eBAP9eDBP0AU9CBeYtGDqKCIFiyVCEHbpElb26ZNu9ndtskmmZndGdm9iSh6mn4z r9dl4JnL9xmYN88z851pj0ajUQAKaI97AID/lWABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZg AWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmAB ZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFl CBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUI FlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgW UIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQhmABZQgWUIZgAWUIFlCGYAFlCBZQ hmABZQgWUIZgAWUIFlDGRAZrOBzuPjabzXGPAvwfJi5Y165ey/nnz2fYGObQoUPp93tptpppNJqZ X5xPuz1xLwmUMTHvzu2t7Wxe2cy5v57N9776ZNZ661m57UDeffvdDKdGueXgLXnsG0/k+Inj6Xa7 4x4XmNRg7cTqhb+dzY+f/GGeO/N8Xn79pSy05vLO5loubW2k1Wjm8vmNfPfMd/Lo1x/PY1/+Qqan p8c9NjCJwRoM+jl/+oWc/vWpnF1/OdOzU1ndWk+70c6V7c3MNPdkpjWdPWudXHr69bz6yVdzx9E7 xj02MInBarXbWdi3lLf6a+l2Z3J5czOz3ZndYHVbs1lqL6TX6efQvYdz+DN35bYjt417ZGBSgzUa jbJ9fSsr07dkdbCehcW5bI+GmW5OZX3wdhYbC1m8azmPfuuJfPThB8c9LjDJwer1evn7mefy7taV 3aup68Ne0kg2tt7JTGNPWs1mVm5dycHDB9Pv9TM1PTXukYFJDdagP8iFV17L+vbb2dtYzlSjk+bO GkOrmzcHl7K2vZHR8+fz1A9O5r6PH8vR+49mdqGbTqeTVqs17vGBSQnWzu3g+ltrOfWbZ3dDtXMb 2Gl0cnV4NauDS1mcWkxvdpD1tfWc/P7P8uyv/pyHPv9wDh45mAN3H8qRO4+IFrxHtCdhUfSZPz2T zQtXsjXazoX+xTSzs+E+Sn80yKjfSHPQ2L3i6idZfWs1P//JyeTSdo498uF85Ztfy8qBlTQajXGf Cky89o2+f3X29Jk89aOTWZnal2ujXv7Rey17mtO5deoDebX3Rpbbi9kcXt09NhhtZ+PSRtYubmSp tZhXnn4pf/zFH/LIFz+X7pxlUhi3GzpY/V4vp37/l1z++3p6jUEWpueyvLic+e58tla30+iN8mLv lezr3JzhaLTzOXy6rZlcGW5mbnY2gwzSu3htdxtesGD8buhgdaamct9Dx/LcA6fzzvuv5aa5xdxx 1wezvLyc3/30t3nz1Go6V9vpNNt5YePF3Ln3SK42erm8cSVL+2/K/Y88kI89/ons279v3KcC3OjB anfauefEvXni21/K4Xtu311X2Plx8/Vr17OwdzFLv3xf3jh3IdPp5MDC7bl5dm8y18wbF1/PwvxC jh8/nqN3Hx33aQCTEKwdM7MzOfbQh/7l2Nz8XD712U/nxMMfybkz5zIaDLP/0P7dv5vpzs9lY30j veu9zPkRNLyn3PDB+k92vvVbWlrKiQdP/Ntz8/PzY5kJ+O8mNlhAPYIFlCFYQBmCBZQhWEAZggWU IVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQh WEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFY QBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhA GYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZ ggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQBmCBZQhWEAZggWUIVhAGYIFlCFYQKr4 J5+bRfuXMBT1AAAAAElFTkSuQmCC