Home

RSA Compiler User`s Manual - Alberta Environment and Parks

1. cccceesccessseceeececsecessceceeaeeceeeessaeceeaeeceeeeeeaeeseaaeceeneeees 23 5 4 2 Validating the Sample Selection Tool output data ceeceseceseceseceseeeseeeeeeeeaeeeaeeeneeenaes 24 DD Edit nenduan nn sestbadves des aa cdeay ah e dave aa E a dagaraeed eae ee eae 25 5 6 Compilers n cee eee etn ie Mee ied eta ait AEAEE ann pie isla noes 26 5 6 1 Compilation Setup for 3rd Party Models ccsccceescecesscesseceeneeceeeeeesaeceeaeeceeneeeeaeeeeaaeceeneeee 28 5 6 2 The RSA Compilation Process nesei iiet cadens decbensgencteevdacubinesosdee oudsavdardoevadeotbedeess 29 OL REPOTt AES EA A nes credatiedse ppsnes act gquseee sas seeerbaveeatetacig EE 31 DO EX POL LAE co cieeos Ae A cot olde idle ed sores tetect odes caddee A E eeeeeks 32 5 8 1 Exporting the Performance Survey Data ccecccesscecssscesseceeeeeceeeeeesaeceeaaeceeneeeeaeeeeaaeceeneeee 32 5 8 2 Exporting the Sample Selection Data cceececccceescecseeeesaeceeaeeceeeeeaeceeaaeceeeeeesaeeeeaaeceeaeeee 33 SI AUAI sos eeen eG sets Seas cede Shree ty E A a Ghee cau haus Soweto ae ag E caters A EEE 33 9 9 Shadow Compilaton 02 scscesedesskasnnns eienen sued cateul Sosnta ered enced saduaa ses cncvent gat avers E E aeit 33 5 92 ARIS Data Verification reeet een aA EE Ee a E E Ea NNE SE En EEEE 33 59 3 Field Data Verification iiaeie eee e eae e e Ea A E e a E a EEEa Eea 33 SLO Abuta ai i aa te Mees Lae eet eh ee 34 May 6 2015 RSA Complier User s Manual Page 4 of 7
2. hddd dddd W 2015 Government of Alberta ESRD RSA Compiler User s Manual Where GPS_COOR_SYS UTM or NA Eligible code blank W 129 GPS_UTM_ZONE Where GPS_COOR_ SYS LL or NA Eligible codes blank W Where GPS_COOR_SYS UTM Eligible codes 11N 12N W May 6 2015 RSA Complier User s Manual Page 63 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Ground2 G2 Import Critical Error Validation 208 209 e Every unique opening and polygon combination in this dataset must also occur in Ground dataset e Every unique opening and polygon combination that occurs in the Ground dataset also occurs in this dataset e Every row in this dataset must have a unique non blank opening polygon and plot_id combination i e no duplicates Attribute Validation Criteria Error E Warning W Fields OPENING POLYGON PLOT_ID 151 PLOT_TYPE 152 PLOT_X_COOR 152 PLOT_Y_COOR 153 SHRUB_COVER May 6 2015 Criteria Non blank E Non blank E Non blank E Eligible codes B or D E Non blank W Non blank W Eligible codes 0 to 100 W RSA Complier User s Manual Page 64 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Ground3 G3 Import Critical Error Validation 210 e Every unique opening polygon and plot_id combination in this dataset must also occur
3. The Compilation Specifications window is split into five sections Program Status Section The user can review the status of each program If any loaded program is not ready to be compiled the status pane is highlighted in yellow and the user needs to go back and carry out the steps that are missing before the program can be compiled successfully MAI Age Interval Section This section shows the age interval the MAIs will be compiled and reported by The age interval is set to 10 years as a default and it cannot be changed by the user Other Model Section This section is for users who want to apply a growth and yield model other than GYPSY to calculate MAIs The 3 party model must be approved by ESRD prior to its use This option is discussed in detail in Section 5 6 1 Utilization Limits Section This section shows the utilization limits to be used for conifer and deciduous species during the compilation The utilization is set at 15 cm minimum stump diameter over bark Sdob 10 cm top May 6 2015 RSA Complier User s Manual Page 27 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual diameter inside bark Tdib and 30 cm stump height Stht These default values cannot be changed by the user as all GYPSY projections must be made at these utilization limits Primary Species Section The user can set the default primary species for each stratum in the loaded programs The default setting is deciduous
4. Summary Error Warning Erom Description O Opening Poly Plot ID SpG Site index extreme value SI_SB 7 4m 4090793255 000006 1003 Site index extreme value SI_SB 6 7m 4090793255 000011 1003 Site index extreme value SI_PL m 4110841972 000001 1003 Site index extreme value SI_SB 7 6m 4110841972 003 000031 1003 Site index extreme value SI_SW 7 8m 4120700948 000023 1003 Site index extreme value SI_SW 6 6m 4120700948 000024 1003 Site index extreme value SI_SW 7 5m 4120701135 000020 1003 Site index extreme value SI_SVV 7 4m 4230800755 000006 Continue Cancel Figure 19 Compilation validation report 12 The MAI values must be reported at the culmination age The culmination age must be given in 10 year intervals and the MAIs must be based on the RSA default 15 10 30 utilization limit The sum of the given MAI values for SB SW and PL must be equal to the Conifer MAI 13 Note that the Compile button is disabled greyed out until all criteria for compilation are met May 6 2015 RSA Complier User s Manual Page 29 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual The validation checks the pre compiled data for any extreme values before the Growth and Yield Projection System GYPSY model is run The list of validation rules and the produced errors and warnings are listed in Appendix 5 At this point the user can cancel out of the compilation and go back to th
5. TABLE Interp 1 I1 Import Critical Error Validation 201 202 203 e Every opening that occurs in this dataset must also occur in the Opening dataset e Every opening in the Opening dataset that has SYSTEM TYPE Aerial must also occur in this dataset e Every row in this dataset must have a unique non blank opening and polygon combination i e no duplicates e Every row in this dataset must have a unique non blank opening higher_strat sp_cl and den_cl combination i e no duplicate strata in an opening Attribute Validation Criteria Error E Warning W Ann RAUN ee 10 11 12 13 14 15 16 17 18 19 20 May 6 Fields PHOTO_Y PHOTO_M PHOTO_D EMULSION SCALE LEAF INTRP_Y INTRP_M INTRP OPENING POLYGON UNIQUE_ID AREA_HA HIGHER_STRAT NAA SP1 SP5 SP1_PER SP2_PER SP5_PER SP_CL DENSITY DEN_CL AVE_HT SPATIAL MIXED R_SP1 R_SP3 R_SP1_PER 2015 Criteria Eligible codes 2012 to 2015 W Eligible codes 1 to 12 W Eligible codes 1 to 31 W Eligible codes TC CIR BW W Non blank W Eligible codes leaf on leaf off W Eligible codes 2008 to 2013 W Eligible codes 1 to 12 W Non blank W Non blank E Non blank E Equal to OPENING _ POLYGON W Eligible codes 0 01 to 9999 99 W Non blank E Eligible codes 0 1 or 2 E Eligible codes blank Sw Se Sb PI Pj Pa PP F
6. 5 4 2 Validating the Sample Selection Tool output data Clicking the Validate button and choosing the Sample Selection Tool SST data option will trigger the validation of the sample selection weights and associated information The validation rules include cross checking the selected samples against the ground information and any inconsistencies found are reported May 6 2015 RSA Complier User s Manual Page 24 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 5 5 Edit This menu item is used to edit the performance survey data and sample selection data that have been validated in the previous step The data editing process can be triggered by clicking the button on the RSA Compiler main interface The Edit module provides a context driven interface to fix any errors and warnings found during the data validation step Figure 16 The errors and warnings are directly integrated in the Edit window to make it easier for the user to fix data issues The user can drill down in the data by selecting the opening then the polygon s and finally the plot s that have issues Filtering may be made by looking at errors only or data issues in an individual opening or even looking at issues by data table The Editor window is split into four sections Program Section The user can select an individual program that is loaded into the database or review all programs default selection Display Section The user ma
7. ESRD RSA Compiler User s Manual After selecting the program and the file name suffix the user can click the Export button to choose the folder location for the CSV files The export process will also create a data dictionary file datadict_suffix csv that contains the source table name and the name type and short description of each field in the source tables The dictionary file could be useful for 3 party database applications to read in the corrected performance survey data 5 8 2 Exporting the Sample Selection Data As shown in Figure 10 the user can import the O1 master opening list and I1 I2 interpreted polygons data from the CSV files into the RSA Compiler once the population of openings has been identified and the polygon delineation and photo interpretation steps are completed The RSA Compiler has built in validation rules to ensure that all opening and polygon attributes are clean The cleaned polygon data can then be exported to the Sample Selection Excel Tool so that the proper sampling of polygons can be completed and the sample selection weights can be calculated The interpreted polygon data can be exported into a Microsoft Excel file by selecting the Sample Selection data option on the Export menu item 5 9 Audit If the user clicks on the Audit button on the RSA Compiler main interface an Audit Module Login window pops up requesting an inspector name and a Password The Audit Module is designed with restricte
8. 0 01 to S 9999 99 UPDATE_AREA 7 2 Updated Area hectares Eligible codes blank or 0 01 from ARIS to 9999 99 SKID_YEAR 4 Year of Skid Clearance Eligible codes 1994 to 2058 SKID_MONTH 2 Month of Skid Clearance Eligible codes 1 to 12 SKID_DAY 2 Day of Skid Clearance Eligible codes 1 to 31 May 6 2015 RSA Complier User s Manual Page 41 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Field Name Format Description Note PR_AREA 7 2 Poorly regenerated area Eligible codes blank or 0 00 hectares Where the to 9999 99 system type is Non photo this must be provided by the user Where the system type is Aerial it can be left blank May 6 2015 RSA Complier User s Manual Page 42 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Table A2 2 Interp1 Interpreted sampling units Aerial Stratification System only Field Name Format Description Note PHOTO_Y 4 Year of photography For example 2008 2009 2010 etc no blanks allowed PHOTO_M 2 Month of photography Eligible codes 1 to 12 PHOTO_D 2 Day of photography Eligible codes 1 to 31 EMULSION 3 00 Emulsion of photography Eligible codes TC CIR BW no TC True color CIR blanks allowed Color infrared BW Black and white SCALE 10 00 Scale of photography For example 20000 15000 no blanks
9. DEC for the Hw Stratum and conifer CON for all other strata C CD and DC cover types These values can be modified by the user based on the assumptions in their approved Detailed Forest Management Plan DFMP 5 6 1 Compilation Setup for 3 Party Models In an effort to accommodate the use of other growth and yield models i e Mixedwood Growth Model the RSA Compiler is equipped with the option of entering MAIs and culmination ages generated by 3 party models The onus is on the user to ensure that the use of the alternative model is pre approved by ESRD The approval of such model will need to cover the following e Which strata the 3 part model is to be applied to e Description of the data collection procedures that were used over and above the minimum required by the RSA Data structures for the additional information Description of the compilation procedures Description of the compiled model input formats Specific details on the model and version to be used Applicable validation results for this model and version and Any relevant modeling assumptions that may need to be defined to successfully replicate the forecast by an independent reviewer Clicking the 3 Party Model button in the Compilation Specifications window will enable the user to enter MAI values for selected strata Aerial Stratification System or polygons Non photo System as shown in Figure 18 Third Party Model Program AERIAL v 2010 ACME Ser
10. Unique plot identifier not more no blanks allowed than 8 alphanumeric characters SPECIES 2 00 SDL Species code Where no tree Eligible codes Sw Sb Se PI species are present in detailed Pj Pw Pf Lt Lw Ls plot enter No Fb Fd Fa Aw Pb No TOPHT 4 Height cm of largest diameter Eligible codes 30 to 9999 where SDL tree 1 e top height tree species No then blank TH_DBH 3 Diameter at breast height of Eligible codes 1 to 999 blank largest diameter SDL tree mm i e top height tree optional measurement TOTAL_AGE 2 Total age of largest diameter Eligible codes 1 to 20 where species SDL tree years i e top height No then blank tree May 6 2015 RSA Complier User s Manual Page 51 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Table A2 8 Ground5 Optional diameter measurements Field Name Format ___ Description Note OPENING 11 00 Opening number consistent with ARIS E g 423075229A no blanks allowed POLYGON 3 00 Unique Sampling Unit number within an E g 001 002 003 etc no opening blanks allowed PLOT_ID 8 00 Unique plot identifier not more than 8 no blanks allowed alphanumeric characters SPECIES 2 00 SDL Species code Where no tree Eligible codes Sw Sb S
11. allowed LEAF 8 00 Indicator of season of Eligible codes leaf on leaf off photography INTRP_Y 4 Year of interpretation For example 2008 2009 2010 etc no blanks allowed INTRP_M 2 Month of interpretation Eligible codes 1 to 12 INTRP 20 00 Name of interpreter For example Elihu Steward Reginald Loomis etc no blanks allowed OPENING 11 00 Opening number consistent For example 423075229A etc no with ARIS blanks allowed POLYGON 3 00 Unique Sampling Unit For example 001 002 003 etc no number within an opening blanks allowed UNIQUE_ID 16 00 Unique identifier is made For example 423075229A_001 up of opening number and 423075229A_002 etc no blanks polygon allowed AREA_HA 7 2 Area hectares of polygon Eligible codes 0 01 to 9999 99 HIGHER_STRA 5 00 Descriptor for higher level For example SA UF LF or T stratification Tend Tend2 If not applicable then 0 NAA 2 Net Assessment Area Eligible codes 0 1 or 2 indicator SP1 2 00 Species code of most Eligible codes blank Sw Se Sb dominant species in the PI Pj Pa Pf Fb Fa Fd regeneration layer La Lt Lw Aw Pb Bw P A SP1_PER 2 SPI s contribution to Eligible codes 0 2 3 4 5 6 7 8 9 10 species composition to nearest 10 SP2 2 00 Species code of second E
12. 2 00 Species code of second Eligible codes blank Sw Se Sb most dominant species in PT Py Pa Pf Fb Fa Fd the residual layer La Lt Lw Aw Pb Bw P A R_SP2_PER 2 R_SP2 s contribution to Eligible codes 0 1 2 3 4 5 6 7 8 9 10 species composition to nearest 10 R_SP3 2 00 Species code of third most Eligible codes blank Sw Se Sb dominant species in the PI Py Pa Pf Fb Fa Fd residual layer La Lt Lw Aw Pb Bw P A R_SP3_PER 2 R_SP3 s contribution to Eligible codes 0 1 2 3 4 5 6 7 8 9 10 species composition to nearest 10 May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 44 of 73 ESRD RSA Compiler User s Manual Field Name Format Description Note R_DEN 6 Total density stems per ha Eligible codes 0 to 999999 call for the residual layer R_CC 2 Crown closure of the Eligible codes 0 2 3 4 5 6 7 8 9 10 residual layer to the nearest 10 R_AVE_HT 4 1 Average height of the Eligible codes 0 to 99 9 residual layer R_SPT 1 Spatial distribution call for Eligible codes 0 1 2 3 4 5 the residual layer May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 45 of 73 ESR
13. Compiler version 20110831p GYPSY DLL version 20100829 Build 35 Progam 1 Program Descriptor ACME Aerial CompanyName ACME System Type Aerial Program Year 2010 FMA or FMU FMA123456 Planned Population Area 526 5 ha Ground Sampling Area 306 1 ha of Openings 31 of Sampling Units 37 of Units 52 ofPlots total 1 489 detail 377 Strata Summary Planned Population Sampled Model Optional _Merch Mean Annual Incr mafha year Strata Units Area ha Units Area ha Diameter Con Decid Sb Sw Pine O_Hwsx 21 261 6 14 137 7 GYPSY version1 0 Yes 142 192 01389 11338 0 1442 OHw 15 1344 7 54 0 GYPSY version1 0 Yes 098 3 02 0 0283 0 9252 0 0292 O_SvHwSkHw 8 64 8 8 57 8 GYPSY version1 0 Yes 176 1 31 0 5662 09427 0 2520 O_Sbhisw z 63 0 7 53 5 GYPSY version1 0 Yes 2419 081 0 8322 05889 0 7673 OPIHw 1 34 1 314 GYPSY version1 0 Yes 138 182 0 2111 0 2747 0 8930 Total 52 526 5 37 306 1 Population Changes Opening Exceptions Opening Area ha Flag Opening Comments 4210520017 25 9 1 Burned Sampling Unit Exceptions Opening Polygon Area ha Stratum Selection Flag Sampling Unit Comments 4210520017 1 7 61 O_HwSx 5 1 Bumed 4210520017 2 10 14 O_Hw 3 1 Bumed 4210520017 3 3 17 O_Hw 5 1 Bumed 4210520017 4 4 93 O_Hw 4 1 Bumed Wamings Class Description COMP Site index extreme value G3 SDL Tally trees extreme value warring G3 ADY Tally trees extreme value warning G4 Total Age gt Survey_Year Skid_Year 2 G5 Deciduous 3 or m ore tr
14. DLL it was compiled and tested on Windows XP and the latest version of Windows Vista With the release of Windows 7 64 bit systems some users may experience one of two error messages at the time of the GYPSY DLL registration Error message 1 The module C path_to_your DLL GYPSY 2009 dll failed to load Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent DLL files The specified module could not be found Error message 2 The module C Program Files F Rx Software FRx 6 filename DLL was loaded but the call to DilRegisterServer failed with error code Ox80004005 Error message 1 Cause The GYPSY 2009 DLL was compiled on 32 bit Windows systems and it is relying on a number of standard 32 bit Windows components to run properly The Windows 7 64 bit operating system has these 32 bit components embedded however some of the component files are not used by the 64 bit Windows and thus are tucked away in some folders that are not automatically searched by the system The challenge is to 1 find out which 32 bit component file is missing 2 find the file on your Windows system and 3 copy the file into a folder that is automatically searched by Windows 7 e g C Windows SysWOW64 For users who experience registration issues it is generally only 1 or 2 component files that may need to be copied These missing files vary by user and system so below we provide
15. SP1 SP_CLASS DEN_CL and MIXED must be non blank W Where SP2 is non blank then SP2_PER should be non zero and vice versa W Where SP3 is non blank then SP3_PER should be non zero and vice versa W Where SP4 is non blank then SP_4PER should be non zero and vice versa W Where SP5 is non blank then SP5_PER should be non zero and vice versa W Where SP2 is blank then SP3 SP4 and SP5 should be blank W Where SP3 is blank then SP4 and SP5 should be blank W Where SP4 is blank then SP5 should be blank W SP2_PER should not be larger than SP1_PER W SP3_PER should not be larger than SP2_PER W SP4_PER should not be larger than SP3_PER W SP5_PER should not be larger than SP4_PER W SP1_PER SP2_PER SP3_PER SP4_PER and SP5_PER should sum to 10 W SP_CL should correspond with the detailed species composition from the SP1 through SP5 E May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 58 of 73 ESRD RSA Compiler User s Manual Table A3 1 Species composition class definitions SP_CL Conifer percent Leading conifer species 0 20 NA Hw 30 DEN_CL should correspond with the DENSITY E Table A3 2 Density class definitions DEN_CL DENSITY range 2 001 5 000 D gt 5 000 31 If both coniferous and deciduous species are present in SP1 through SP5 then MIXED cannot be attributed as P W 28 Where a regeneration layer is not present a SP1_PER SP2
16. This menu item is used to import the performance survey data into the user s database For an Aerial Stratification System program the RSA Compiler will also require the loading of the selection weights from the RSA Sample Selection Tool output file Figure 1 The new database file will have the mdb file extension even under Microsoft Access 2007 This is because the RSA Compiler was developed under Microsoft Access 2003 The issue is that in one system a polygon number may be stored as 1 while the RSA Compiler may use zero padding and outputs the same polygon as 001 These two values will not link up properly which may result in database integrity errors May 6 2015 RSA Complier User s Manual Page 16 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Before import the performance survey data must be organized in a series of comma delimited CSV files note the output from the sample selection tool should be a MS Excel file The CSV files require the first line to include the field names and must follow the specifications for the field names and field types as presented in Appendix 2 There is no required file naming convention as the import module identifies the CSV files based on their internal structure however it is recommended that users organize their files into folders by program The suggested file naming conventions are presented in Table 1 Table 1 Suggested file naming conven
17. a general process that should help resolve the error Resolution STEP 1 The very first step is to double check the regsvr32 statement that was typed into the run command to ensure that the path to the location of the GYPSY 2009 DLL is referenced correctly Windows 7 users must follow the DLL installation instructions given for Windows Vista and run the Command Prompt as administrators If everything is confirmed to be typed correctly and the error still occurs proceed to Step 2 STEP 2 We need to find out which 32 bit component file is missing i e not found by Windows 7 May 6 2015 RSA Complier User s Manual Page 36 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual There is a free software tool called Dependency Walker version 2 1 3623 that requires no installation and can be found at http support microsoft com kb 256872 Download the link called Download Dependsx86version2 1 3623 exe now from the References section of the web page Follow the instructions to unzip the file The software tool contains 4 files as shown in Figure Al 1 The application can be launched by double clicking the depends exe executable file Open Organize v Share with v Burn New folder a Fr Favorites F E Desktop B Downloads Name _ depends cnt depends dll Date modified Type 16 04 2002 6 10 AM 16 04 2002 6 10 AM CNT File Application extension F Dropbox mg depends
18. exe 16 04 2002 6 10 AM Application S Recent Places Libraries B Documents d Music depends hlp 16 04 2002 6 10 AM Help file m E Application depends exe Date modified 16 04 2002 6 10 AM Size 620 KB Date created 16 04 2002 6 10 AM Figure A1 1 Dependency Walker files Upon opening the GYPSY_2009 dIl under File Open the user will be able to identify the 32 bit component files that the Windows 7 system could not find Figure A1 2 ed ORY cA de SE GE GYPSY_2009 DLL KERNEL32 DLL m O USER32 DLL O ADVAPB2 DLL R MSVCRT DLL W NTDLL DLL W KERNELBASE DLL O API MS WIN SERVICE CORE O API MS WIN SERVICE WINS E API MS WIN SERVICE MAN O API MS WIN SERVICE MAN SW APT MS WWIN CORF I ocan z it m Module File Time Stamp _ Link Time Stamp _ File Size _ Attr _ Lik Checksum MSVCR71 DLL GPSVC DLL TESHIMS DLL v OMG Q 22 1EFRAME DLL S OO P1 Ordinal Hint Function Entry Point _ E__ Ordinal Hit 2 1 00001 0 00000 DiiCanUnloadNow 00000 BFFO 2 00002 1 0x0001 DilGetClassObject 00000 CBB0 3 00003 2 0x0002 DilRegisterServer 00000CCDO 4 00004 3 0x0003 DilUnregisterServer 00000 CCFO Error opening file The system cannot find the file specified 2 Error opening file The system cannot find the file specified 2 Error
19. it needs to be registered on the user s system After registration the DLL components can be freely accessed by any program without having to explicitly reference it again The DLL can be placed in any folder on the user s system Registering it differs slightly on Windows 95 2000 XP and Vista operating systems Windows 95 2000 XP 1 Click the Start button located in the lower left corner of the user s screen 2 Select Run as shown in Figure 2 3 Enter regsvr32 path to your dlNfolder WGYPSY_2009 dll For example if the user placed the DLL into C Windows System32 then regsvr32 C Windows System32 GYPSY_2009 dll will need to be entered The must use the double quotation marks as given 4 Click the OK button Type the name of a program folder document or Internet resource and Windows will open it for you 3 Open regsvr32 C Windows System32 GYPSY_2009 dll x 3 A Log Off Shut Down a start gt gt 0 unread Yahoo M Figure 2 Registering the DLL on Windows XP If you have Windows 7 please follow the instructions given here under Windows Vista May 6 2015 RSA Complier User s Manual Page 11 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Windows Vista 1 Click the Start button located in the lower left corner of your screen 2 Select the Accessories folder 3 Right click on the Command Prompt icon 4 Select Run as administrat
20. may be an effective way to fix a select set of data issues The first configuration setting allows plot tallies in datasets G3 and G6 to be filled with zeros where blanks are provided Plot tallies are interpreted as missing data if not entered When this setting is turned on it automatically replaces the blanks with zero tallies upon import This option must be used with caution as blank entries could also mean data entry errors The other two configuration settings are related to E Configuration left zero padding in the polygon and plot fields Pieper Polygon and plot numbers can be made consistent E X G3 and G6 Tallies across various data sets by forcing left zero TARARE i en importing data pandin y Whuchmadiis tor example that the Populate tated Bans wih eros omaa and whoo anaa polygon number of 1 would be replaced with 001 E during import across all performance survey data Leading Zeros sets This option is useful to help the user ay Pera ae automatically resolve inconsistencies between the H various datasets However if the compiled data will be exported and linked back to an outside database it may be better not to use the left zero padding option to ensure proper linkages by polygon and plot Where these key fields are already consistently labeled across the datasets this configuration setting should be left unchecked Figure 9 Import Configuration Settings 5 3 Import
21. opening file The system cannot find the file specified 2 20142010 7 24 O11 20103 0 6 90008 A7B1 9 705 472 A 00094356F 640 512 A 0x00A1449 03 11 2011 2 46p 03 11 2011 2 45p 20 11 2010 7 24p 20 11 2010 3 54a Error At least one required implicit or forwarded dependency was not found Warning At least one delay load dependency module was not found Warning At least one module has an unresolved import due to a missing export function in a delay load dependent module For Help press F1 Real C a 0000 0009 0000 _ A Figure A1 2 Dependency Walker interface S Upon opening the DLL the User may be shown an error message generated by the Dependency Walker that indicates that there are missing crucial dependencies that are not found by the system May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 37 of 73 ESRD RSA Compiler User s Manual Two reported missing dependencies called GPSVC DLL and IESHIMS DLL can be ignored as they are not important for the GYPSY 2009 DLL Any other missing files must be recovered and placed in the C Windows SysWOW64 folder In our example shown in Figure A1 2 it appears that we are missing MSVCR71 DLL It is very likely on the system in most cases with multiple copies The files however are located in folders that are not normally searched by Windows 7 during DLL registration In order to find the missing MSVCR71 DLL
22. p4 Validate k Edit ul kompie Report Export gt i 2 Audit 4 Configuration I Display database window Figure 8 RSA Compiler User Interface The following sections detail the steps that should be followed in the RSA compilation process 5 1 Connect to a user database As mentioned in the previous section the RSA Compiler follows a split database design so the program needs to be connected with the user s data This can be achieved by 1 either creating a new user data template or 2 by connecting to an already existing dataset 1 The user can create a new database mdb file by clicking on the BJ button May 6 2015 RSA Complier User s Manual Page 15 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 2 Connecting to an existing database e g a company s mdb file can be achieved by clicking the button The new dataset can be created in any folder with a user defined name 5 2 Set Import Configuration After creating a database the user may review the database configuration before trying to import some data by clicking the The configuration window will provide the user with a number of options as shown in Figure 9 It is suggested that the user have these configurations settings turned off as a default for the initial import Following the import and validation steps the user may find that adjusting these configuration settings and re importing
23. ready to be imported into the user s database by clicking the Import button The import process counts on the datasets conforming to the defined data structures Where deviations from the defined data structures exist the user may get an error message box during the import process which prevents any other evaluation of the data for critical import errors For example if the user has an alphanumeric character in a numeric field the import will be interrupted before a full evaluation is possible The RSA Compiler checks for any data structure issues or any non standard items in the CSV files and reports datasets that do not conform to the published standards Figure 12 May 6 2015 RSA Complier User s Manual Page 20 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual File INFO Report File INFO Summary 1 Number of datasets a selected b successfully read c unable to read due to missing or non standard Format file 2 Files read x successfully read X unable to read optional ID Set Name System 01 W 12 G1 G2 G3 G4 G5 G6 NS 1 X AERIAL Aerial E A E Ce 1 NS Number of non standard format CS files found within each dataset folder a Figure 12 File Information Summary before the CSV data import Details on the non standard files and potential data issues including the row numbers where the data failed can be reviewed by clicking the File amp Folder Details button The File I
24. 0 vAcknowledgemients c2 cs38065 ges ied catia ae ae g die ed uli Ge ae 8 200 OSCOPGviagenien aii ate an ely a pad ain etl nin Sind em neg ins wings en ieee 9 3 0 General process jase oss raaa RL a RN en TS Be to a ete ea ee 10 4 0 SottwareanstallatwOnys s eeccgiecetatedenseel es a A E E et nh lect elena led be A E E tlecs acct obs E estes 11 4 1 Registering the GYPSY 2009 COM DEL isise eee ireo roeie oea ereet ATRE KESE ATEGES DEN 11 4 2 Installing the RSA Compilen erie ceia ea a e ae aae aE a iee o E E a EE EEA 13 5 0 Software USAGE ances aair i Tus IEE EAE EEEE A AIA E EO CEEE OSTEN Eene E anio KETSE ee eA aiT 15 5 1 Connectto a ser databasen nn a dees e eiea REEE De ES aT ie 15 5 2 Set Import C On SuratiOn ix erisir s rE S EAS e ETE E EAE E O E TA T ass 16 ee Ena B10 i ANE ETE AE E E ET 16 5 3 1 Data flow for the Aerial Stratification System ssseeesesesesessseessesssesssersseessessssesssssseessseeses 17 5 3 2 Data flow for the Non photo System c cc eeccccsssecesececseecessaeceeaeeceeeeeesaeceeaaeceeeeeeeaeeeeaaeceeaeeees 18 5 3 3 Importing the performance survey data eee eeeeseeseecssecssecesecesecsseeeeceseeeseeseneeeaeeeaeeenaeenaes 19 5 3 4 Importing the Sample Selection Tool output data eee ceesceceeeceeseeceeaeeceeeeeeeaeeeeaeceeeeeees 22 54 Validate sais cass Wav rt tens tee A lees hat send Shed egies dete east tee aoe evens SAGE great Ea dees 22 5 4 1 Validating performance survey data
25. 230530114 Errors 4230530115 4230530116 4230530121 z Total 4230530129 Warnings Figure 16 The Data Editor May 6 2015 RSA Complier User s Manual Page 25 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual After completing the data edits the user needs to re validate the data to ensure that there are no errors found If there are still errors they need to be fixed in the Edit module and the validation must be repeated This iterative process needs to continue until all errors are fixed with both the performance survey data and the sample selection weight data Area Stratification System only The sample selection data can be reviewed once it was imported and validated by clicking the SST Data button The SST data is viewable but cannot be edited inside the RSA Compiler The best strategy is to tackle errors first as many of the warnings may also be resolved by fixing the errors Revalidate the data after a few errors have been fixed For programs using the Aerial Stratification System the Edit module offers the opportunity to deal with changes to the planned population Under some limited circumstances an opening which was originally included in the population may no longer be part of the population for example where an opening is known to have burned since the photo was captured In the Edit module in the O1 data tab there is an OPENING_FLAG and an OPEN
26. 3 2015 Government of Alberta ESRD RSA Compiler User s Manual List of Tables Table 1 Suggested file naming convention for Performance Survey CSV files 0 0 cece eseeseeseecseeceseceseceseenseeees 17 Table 2 Summary report warning Categories 0 ee ee eeseeseessecssecsseceseceseceseceseesseeseaeeeseeeaeecsaecsaecsaeceaeesseeseessaeens 32 Table A2 1 Opening Master Opening list 0 cece cee ee eee e cent ene ene ence ee eeeeeseneeneeeaetenteseeeeenenaes 41 Table A2 2 Interp1 Interpreted sampling units Aerial Stratification System only cee eeseeseceeeeerene eeeeee 43 Table A2 3 Interp2 Interpreted poorly regenerated areas Aerial Stratification System only 00 46 Fable A2 4 Ground Umit headers 55a siete this iaae naa tas EEEN ORASE E EEE E EAA A ERAAN 47 Table A2 5 Ground2 Plot header 0 i Ea ar E EE EEEE ENAS EEE LAET AOO E R E 49 Table A2 6 Ground3 Basic plotio evenor oaeoi is nra ETEEN E E E E EE AEE EAE TEE 50 Table A2 7 Ground4 Detailed plot 0 0 2 cc cece ccc ec re aa e ENE EEEE Aa EITE EET ena Ea 51 Table A2 8 Grounds Optional diameter measureMents ce ceece eee ne ene cree eee eeeteeeeeeeee ene eneeneene ea 52 Table A2 9 Ground6 Optional gt 130 cm coniferous tree tally 0 cece cece cee e nee eeneee neta eee eeeeeeeeeenens 53 Table A3 1 Species composition class definitions cece cece cece ene ence nee e nee n eens taste
27. 423075229A no blanks ARIS allowed POLYGON 3 00 Unique Sampling Unit number E g 001 002 003 etc no within an opening blanks allowed PLOT_ID 8 00 Unique plot identifier not more no blanks allowed than 8 alphanumeric characters PLOT_TYPE 1 00 Identifies the type of plot as Basic Eligible codes B or D B or Detailed D PLOT_X_COOR 14 00 GPS X coordinate for the plot LL examples If the GPS_COOR_SYS is LL then W114 47714 8 the X coordinate is longitude negative with west longitude If the GPS_COOR_SYS is UTM W114 7874 then the X coordinate is a measurement of the East West position in meters Easting mE If the GPS_COOR_SYS is NA then the X coordinate is blank UTM examples 569842 630084 PLOT_Y_COOR 14 00 GPS Y coordinate for the plot LL examples If the GPS_COOR_SYS is LL then N043 38 33 24 the Y coordinate is latitude If GPS_COOR_SYS is UTM then N043 6425 the X coordinate is a measurement of the North South position in meters Northing mN If the GPS_COOR_SYS is NA then the Y coordinate is blank UTM examples 4282182 4833438 SHRUB_COVE 3 Percent cover of shrubs gt 30 cm Eligible codes 0 to 100 R May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 49 of 73 ESRD RSA Compiler User s Manual Table A2 6 Ground3 Basic plot POCB MET Format Desc
28. 99 STRATA 16 00 Where SYSTEM_TYPE is A Where SYSTEM_TYPE is A Sampling Strata Combination of Without higher strata E g higher level strata and species OPI O_Sw Sb composition SP_CLASS or 0 _HwSw etc aggregated strata With higher strata E g Tl Sw T2 Sw T1_SwHw etc Where SYSTEM_TYPE is N Where SYSTEM_TYPE is N then the eligible codes are Name of stratum polygon within Hw L MxPI L MxSx the Opening L Sw L PI L Sb L Hw M MxPI M MxSx M Sw M PI M Sb M Hw H MxPI H MxSx H Sw H PI H Sb H SURVEYOR_ID1 30 00 Name first and surname of E g Elihu Steward no primary qualified surveyor blanks allowed SURVEYOR_ID2 30 00 Name first and surname of E g Reginald Loomis qualified surveyor SURVEY_YEAR 4 Year of field survey For example 2009 2010 etc no blanks allowed SURVEY_MONTH 2 Month of field survey Eligible codes 1 to 12 SURVEY_DAY 2 Day of field survey Eligible codes 1 to 31 N_BASIC_PLOTS 3 Number of Basic plots Eligible codes 1 to 999 N_DETAILED_PLOT 3 Number of Detailed plots Eligible codes 1 to 999 S OPTIONAL_DIAM 1 00 Flag to indicate the measurement Eligible codes Y or N of optional diameter sample GPS_MAKE 10 00 GPS receiver make E g Garmin blank if GPS not used GPS_MODEL 20 00 GPS receive
29. D RSA Compiler User s Manual Table A2 3 Interp2 Interpreted poorly regenerated areas Aerial Stratification System only OCBYE Tt Format Description Note OPENING 11 00 Opening number consistent with For example 423075229A etc no ARIS blanks allowed POLYGON 5 00 Unique poorly regenerated For example PR1 PR2 PR3 etc polygon number within an no blanks allowed opening UNIQUE_ID 17 00 Unique identifier is made up of For example 423075229A_PRI1 opening number and polygon 423075229A_PR2 etc no blanks allowed AREA_HA 7 2 Area hectares of polygon Eligible codes 0 1 to 9999 9 NAA 2 Net Assessment Area indicator Eligible codes 0 1 or 2 PR_SP1 2 00 Species code of most dominant Eligible codes blank Sw Se species in the poorly regenerated Sb PI Pj Pa PP Fb Fa area Fd La Lt Lw Aw Pb Bw SPE AS PR_SP1_PER 2 SP1 s contribution to species Eligible codes 0 4 5 6 7 8 9 10 composition to nearest 10 PR_SP2 2 00 Species code of second most Eligible codes blank Sw Se dominant species in the poorly Sb PI Py Pa Pf Fb Fa regenerated area Fd La Lt Lw Aw Pb Bw P SEA PR_SP2_PER 2 SP2 s contribution to species El
30. DIAM Y 217 e Every unique opening and polygon combination that occurs in the Ground dataset as OPTIONAL DIAM Y must also occur in this dataset e Every row in this dataset must have a unique non blank opening polygon plot_id species and tree_num combination i e no duplicates Attribute Validation Criteria Error E Warning W Fields Criteria OPENING Non blank E POLYGON Non blank E PLOT_ID Non blank E 154 SPECIES Eligible codes Sw Sb Se PI Pj Pw PP Lt Lw Ls Fb Fd Fa Aw Pb Bw No E 155 TREE_NUM Eligible code 1 to 99 E 156 TREE_TYPE Eligible codes SDL or ADV E 159 DBH Eligible codes 1 to 999 E Provide a warning where DBH gt 100 W 160 HEIGHT Eligible codes 30 con and 130 decid to 999 W For conifer species SW species group Sw Fb Fd Fa Se SB species group Sb Pl species group PP Pj Pw Pf Lt Lw Ls 251 e Where a non zero SDL_tally_130 for a species group occurs in Ground6 and no SDL diameter tree is present for that species group in that plot then a warning should be generated W 252 e Where the sum of SDL_tally_130 for a species group is equal to 2 in Ground6 and there are not 2 SDL diameter trees present for that species group in that plot then a warning should be generated
31. DM berbos Government Reforestation Standard of Alberta Compiler User s Manual May 2015 ESRD RSA Compiler User s Manual Printed documents are not controlled For a digital copy of this document visit the ESRD website and use the following search term RSA Compiler e esrd alberta ca May 6 2015 RSA Complier User s Manual Page 2 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Suggested citation Alberta Environment and Sustainable Resource Development 2015 Reforestation Standard of Alberta RSA Compiler User s Manual Government of Alberta Department of Environment and Sustainable Resource Development Edmonton Alberta 73 p Inquiries regarding this document should be directed to Alberta Environment and Sustainable Resource Development Forestry and Emergency Response Division Forest Management Branch Forest Program Management Section 7th Floor Great West Life Building 9920 108 Street Edmonton Alberta Tel 780 427 8474 Website esrd alberta ca General Disclaimer Inclusion in this document of the name of any trade designation equipment supplier consultant or contractor does not constitute an endorsement of that trade designation equipment supplier consultant or contractor to the exclusion of any other May 6 2015 RSA Complier User s Manual Page 3 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Table of Contents 1
32. ING COMMENT field These can be used to flag population exceptions at the opening level Where the user wants to flag an opening as no longer being part of the population the OPENING_FLAG should be made equal to 1 and a comment should be added to the OPENING_COMMENT indicating the reason for the exclusion For the Aerial Stratification System where individual sampling units are to be dropped from the population instead of entire openings due to new disturbances a SU FLAG and SU COMMENT field found under the I1 data tab are available Where the user wants to flag an SU as no longer being part of the population the SU_FLAG should be made equal to 1 and a comment should be added to the SU_COMMENT indicating the reason for the exclusion 5 6 Compile This menu item is used to compile the performance survey data and sample selection data that have been imported into the user s database and have gone through the extensive validation and editing process The compilation can be triggered by clicking the button on the RSA Compiler main interface In order to proceed with the compilation of a program two main criteria must be met 10 The best way to carry out the data edits is to check the A checkbox and proceed with the edits from left to right following the implied data hierarchy openings interpreted polygons sampled polygons plots Selecting an opening in the Browse panel and clicking the Summary tab takes t
33. Non blank E AREA _FINAL Eligible codes 0 01 to 9999 99 E STRATA Where SYSTEM TYPE A must be consistent with the STRATA for each opening as found in the INCLUSION_PROB worksheet from the Sample Selection Tool Excel output E Where SYSTEM _TYPE N Eligible codes Hw L MxPI L MxSx L Sw L PI L Sb L Hw M MxPI M MxSx M Sw M PI M Sb M Hw H MxPI H MxSx H Sw H PI H Sb H E SURVEYOR_ID1 Non blank W SURVEYOR_ID2 SURVEY_YEAR Eligible codes 2012 to 2015 W SURVEY_MONTHEligible codes 1 to 12 E SURVEY_DAY Eligible codes 1 to 31 W N_BASIC_PLOTS Eligible codes 1 to 999 and must equal the sum of all plots for the opening and polygon combination in the Ground2 dataset W also 172 N_DETAILED_PLOTS Eligible codes 1 to 999and must equal the sum of all plots with PLOT_TYPE D for the opening and polygon combination in the Ground2 dataset W also 173 OPTIONAL_DIAMEligible codes Y or N E GPS_MAKE Where GPS_COOR_SYS LL or UTM then non blank W Where GPS_COOR_SYS NA then blank W GPS_MODEL Where GPS_COOR_SYS LL or UTM then non blank W Where GPS_COOR_SYS NA then blank W GPS_COOR_SYS_ Eligible codes LL UTM NA W GPS_LL_FORM Where GPS_COOR_SYS LL Eligible codes hddd mm ss s hddd mm mmm
34. Page 60 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Interp 2 I2 Import Critical Error Validation 204 e Every opening that occurs in this dataset must also occur in the Interp1 dataset e Every row in this dataset must have a unique non blank opening and polygon combination i e no duplicates Attribute Validation Criteria Error E Warning W Fields Criteria OPENING Non blank E POLYGON Non blank E UNIQUE_ID Equal to OPENING _ POLYGON W 7 AREA_HA Eligible codes 0 01 to 9999 99 W 9 NAA Eligible codes 0 W 10 PR_SP1 PR_SP3 Eligible codes blank Sw Se Sb PI Pj Pa PP Fb Fa Fd La Lt Lw Aw Pb Bw lt p ead W 11 PR_SP1_PER Eligible codes 0 4 5 6 7 8 9 10 W 12 PR_SP2_PER Eligible codes 0 1 2 3 4 5 6 7 8 9 10 W PR_SP3_PER Eligible codes 0 1 2 3 4 5 6 7 8 9 10 W 13 PR_SP_CL Eligible codes blank Hw HwPI HwSx SwHw PlHw SbHw Sw PI Sb Fd W 14 PR_DEN Eligible codes 0 to 199 W 24 PR_AVE_HT Eligible codes 0 to 99 9 W Poorly regenerated area attribute format checks Where trees are present 34 a PR_SP1_PER PR_DEN and PR_AVE_HT must non zero W 34 b PR_SPI must be non blank W 34 c PR_DEN must less than 200 W 33 Where PR_SP2
35. W 253 e Where the sum of SDL_tally_130 for a species group is greater than or equal to 3 in Ground6 and there are not 3 SDL diameter trees present for that species group in that plot then a warning should be generated W 254 e Where a zero SDL_tally_130 for a species group occurs in Ground6 and SDL diameter tree is present for that species group in that plot then a warning should be generated W For deciduous species AW species group Aw Pb and Bw 257 e Where a non zero SDL_tally for a species group occurs in Ground3 and no SDL diameter tree is present for that species group in that plot then a warning should be generated W May 6 2015 RSA Complier User s Manual Page 67 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 258 e Where the sum of SDL_tally for a species group is equal to 2 in Ground3 and there are not 2 SDL diameter trees present for that species group in that plot then a warning should be generated W 259 e Where the sum of SDL_tally for a species group is greater than or equal to 3 in Ground3 and there are not 3 SDL diameter trees present for that species group in that plot then a warning should be generated W 260 e Where a zero SDL_tally for a species group occurs in Ground3 and SDL diameter tree is present for that species group in that plot then a warning should be generated W May 6 2015 RSA Complier User s Manual Page 68 of 73 2015 Government of Al
36. _PER SP3_PER SP4_PER SP5_PER DENSITY AVE_HT and SPATIAL must be zero W b SP1 SP2 SP3 SP4 SP5 SP_CL DEN_CL and MIXED must be blank W May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 59 of 73 ESRD RSA Compiler User s Manual Residual layer attribute checks Where a residual layer is present i e crown closure is gt 15 34 a R_SP1_PER R_DEN R_CC R_AVE_HT and R_SPT must be non zero W 34 b R_SP1 must be non blank W 35 c R_AVE_HT should be larger than AVE_HT W 33 Where R_SP2 is non blank then R_SP2_PER should be non zero and vice versa W 33 Where R_SP3 is non blank then R_SP3_PER should be non zero and vice versa W 33 Where R_SP2 field is blank then R_SP3 field should be blank W 33 R_SP2_PER should not be larger than R_SP1_PER W 33 R_SP3_PER should not be larger than R_SP2_PER W 32 R_SP1_PER R_SP2_PER and R_SP3_PER fields should sum to 10 i e 100 W Where a residual layer is not present 34 a R_SP1_PER R_SP2_PER R_SP3_PER R_DEN R_CC R_AVE_HT and R_SPT must be zero W 34 b R_SP1 R_SP2 and R_SP3 must be blank W Polygon size check 36 Where polygons are less than 2 ha and the final net assessment area of the entire opening is greater than 2 ha i e there are multiple sampling units that should not have been divided due to size 2 ha minimum rule then a warning is produced W May 6 2015 RSA Complier User s Manual
37. as a Trusted Location under the Office Button Access Options Trust Center Settings This automatically enables VBA macros in any program under the RSA Compiler folder e Create remove or change a trusted location for your files May 6 2015 RSA Complier User s Manual Page 14 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 5 0 Software usage The RSA Compiler was designed using the split database concept which means that the programming logic internal lookup tables and the user interface are separated from the actual field survey and other user data as shown in Figure 7 The RSA Compiler program can be connected to different user databases and can be manipulated using the same program The advantage of this approach is that if new functionality is added the new program front end database can be distributed to users without disrupting the users data The new program can be re connected to the user s database and the data may be re compiled RSA COMPILER USER INTERFACE Ow zon lt Ma ba OF ex T BACK END DATABASE Upon opening the RSA Compiler the user will see the RSA Compiler user interface as shown in Figure 8 USER DATA USER DATA USER DATA 1 2 3 Figure 7 RSA Compiler split database design E RSA Compiler Reforestation Standard of Alberta Performance Survey Compiler Database not connected Select or create a new data file a AOA Import lil
38. automatically maps and validates the data it finds in the program folders Dataset Section The user can select or un select particular datasets by double clicking the dataset name All information is automatically re summarized by the RSA Compiler Summary Tabs Section The user can review the datasets about to be imported The Summary tab provides a quick overview of the data and the critical errors the RSA Compiler found The Detail tab shows the critical errors by dataset and file type The Error tab helps identify the details about the error The rest of the tabs provide further details by file type The file types with errors are easy to pick out as the tabs are shown in red The user can also check the Display only the records with critical errors option button to filter the relevant information The RSA Compiler automatically checks all selected datasets for the following errors Duplicate IDs for opening polygon or plot in a dataset Blank IDs Orphan records Sampling unit is already loaded and Duplicate sampling units within the currently selected datasets 7 In the Aerial Stratification System the user must import the survey data before they can import the Sample Selection Tool data 8 Orphans are those records that do not link to any particular data For example a plot is present in the G3 file but its opening number is missing from the O1 file May 6 2015 RSA Complier User s Manual Page 19 of 73 2015 Gover
39. b Fa Fd La Lt Lw Aw Pb Bw P A W Eligible codes 0 2 3 4 5 6 7 8 9 10 W Eligible codes 0 1 2 3 4 5 6 7 8 9 10 W Eligible codes blank Hw HwPI HwSx SwHw PIHw SbHw Sw PI Sb Fd E Eligible codes 0 to 999999 W Eligible codes blank L M H D W Eligible codes 0 to 99 9 W Eligible codes 0 1 2 3 4 5 W Eligible codes blank T A P W Eligible codes blank Sw Se Sb PI Pj Pa PP Fb Fa Fd La Lt Lw Aw Pb Bw P A W Eligible codes 0 4 5 6 7 8 9 10 W RSA Complier User s Manual 2015 Government of Alberta Page 57 of 73 ESRD RSA Compiler User s Manual 21 22 23 24 25 R_SP2_PER R_SP3_PER R_DEN R_CC R_AVE_HT R_SPT Eligible codes 0 1 2 3 4 5 6 W Eligible codes 0 1 2 3 4 5 6 W Eligible codes 0 to 999999 W Eligible codes 0 2 3 4 5 6 7 8 9 10 W Eligible codes 0 to 99 9 W Eligible codes 0 1 2 3 4 5 W Regeneration layer attribute checks 28 28 28 27 27 27 27 27 27 27 27 27 27 27 26 29 Where a regeneration layer is present a SP1_PER DENSITY AVE_HT and SPATIAL must be non zero W b
40. berta ESRD RSA Compiler User s Manual TABLE Ground6 G6 Import Critical Error Validation 218 219 220 e Every unique opening polygon and plot_id combination in this dataset must also occur in Ground2 dataset as PLOT_TYPE D e Every unique opening polygon and plot_id combination that occurs in the Ground2 dataset as PLOT_TYPE D must also occur in this dataset e Every unique opening polygon plot_id species and WGR combination in this dataset must also occur in the Ground3 dataset e Every row in this dataset must have a unique opening polygon plot_id species and WGR combination i e no duplicates Attribute Validation Criteria Error E Warning W Criteria Non blank E Non blank E Non blank E Eligible codes Sw Sb Se PI Pj Pw Pf Lt Lw Ls Fb Fd Fa No E No deciduous species are allowed E Eligible code Y blank E Eligible codes 0 to 999 E Must not exceed the SDL_TALLY in the Ground3 for the same UNQIUE_ID PLOT_ID SPECIES WGR E Eligible codes 0 to 999 E Must not exceed the SDL_TALLY in the Ground3 for the same UNQIUE_ID PLOT_ID SPECIES WGR E e Where a non zero SDL_tally_130 for a species group occurs in Ground5 and no SDL diameter tree is present for that species group in that plot then a warning should be generated W e Where the sum of SDL_tally_130 for a speci
41. by opening and polygon that is used in the GYPSY projections Detailed description of the data compilation protocols can be found in the RSA MAI Output includes GYPSY projections based on the performance survey data MAIs and culmination age are reported for each sampled polygon Opening includes the opening level MAI rollup information SU includes the SU level MAI rollup information Strata includes the strata level MAI rollup information Aerial Stratification System only All of these rollup tabs can be copied and pasted into third party software such as Microsoft Excel or Access for further analysis or storage May 6 2015 RSA Complier User s Manual Page 30 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 5 7 Report This menu item is used to show the compilation results directly from the RSA Compiler main interface Clicking the button will open the compilation output as shown in Figure 20 The RSA Performance Survey Compiler Summary Report can be viewed or sent directly to the printer by clicking the PreView Compilation Summary or Print buttons An example of the summary report for an Aerial Stratification System program is shown in Figure 21 The user can also view or print the final validation report by clicking on the PreView Validation Report or Print buttons RSA Performance Survey Compiler Summary Report Genera Description Number of Programs 1 Compilation date 5 4 2011
42. cedures for Aerial Stratification and Non Photo Systems can be found in the approved RSA which can be viewed and or downloaded by visiting the ESRD website and using the following search term Reforestation Standard of Alberta e esrd alberta ca This user s manual documents the utility of the RSA Compiler Note that no changes to the core compilation were made between this version of the RSA Compiler and the previous versions May 6 2015 RSA Complier User s Manual Page 9 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 3 0 General process The general overview of the RSA Performance Survey compilation process is shown below in Figure 1 The RSA Compiler can hold multiple programs including the compilation and reporting on Aerial Stratification and Non photo Systems for the same Forest Management Agreement FMA or Forest Management Unit FMU Each step in the RSA Compiler process will be described in detail in the following sections INSTALL GYPSY DLL os lt a E CE p CE qm D 222 Figure 1 General overview of the RSA compilation process May 6 2015 RSA Complier User s Manual Page 10 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 4 0 Software Installation 4 1 Registering the GYPSY 2009 COM DLL The GYPSY 2009 DLL is a Microsoft COM type DLL which means that
43. d access for Forest Operations Monitoring Program FOMP Inspectors only The Audit Module is designed to provide three main functions shadow compilation ARIS data verification and field data verification Following program level submissions of the compiled user database an inspector can open the submitted user database with this version of the RSA Compiler and click on the Audit button to enter into the Audit Module 5 9 1 Shadow Compilation The first utility in the Audit Module is the Shadow Compilation This step simply ensures the user database is sound by checking whether the raw data housed within the user database properly relates to the compiled data housed within the user database Any outages are detailed in a report 5 9 2 ARIS Data Verification The second utility in the Audit Module is the ARIS Data Verification This step reads in ARIS data of submitted performance survey results and compares key opening level attributes between the compiled data in the RSA Compiler user database and the results reported in ARIS ARIS fields such as Survey_Date SURVEY_AREA C_MAI D_MAT and ARIS_COMP_LABEL are included in this data validation Any differences between the RSA Compiler user data and the ARIS data are detailed in a report 5 9 3 Field Data Verification The third and final utility in the Audit Module is the Field Data Verification This utility allows the inspector to select a subsample of Sampling Units randomly ordered from tho
44. diameter measures the RSA Compiler should compile all sampling units in the stratum as if diameter was not measured May 6 2015 RSA Complier User s Manual Page 73 of 73 2015 Government of Alberta
45. e Sb dominant species in the PI Py Pa Pf Fb Fa Fd regeneration layer La Lt Lw Aw Pb Bw P A SP5_PER 2 SP5 s contribution to Eligible codes 0 1 2 3 4 5 6 7 8 9 10 species composition to nearest 10 SP_CL 4 00 Species composition class Eligible codes blank Hw HwPI derived field based on SP1 HwSx SwHw PIHw SbHw through SP5 Sw PI Sb Fd DENSITY 6 Total density stems per ha Eligible codes 0 to 999999 call for the regeneration layer DEN_CL 2 00 Density class derived field Eligible codes blank L M H D based on DENSITY AVE_HT 4 1 Average height of the Eligible codes 0 to 99 9 regeneration layer in meters SPATIAL 1 Spatial distribution call for Eligible codes 0 1 2 3 4 5 the regeneration layer MIXED 1 00 Mixedwood pattern call for Eligible codes blank T A P the regeneration layer R_SP1 2 00 Species code of most Eligible codes blank Sw Se Sb dominant species in the PI Py Pa Pf Fb Fa Fd residual layer La Lt Lw Aw Pb Bw P A R_SP1_PER 2 R_SPI s contribution to Eligible codes 0 4 5 6 7 8 9 10 species composition to nearest 10 R_SP2
46. e species taller than 130cm are present in PP Pj Pw PRESET basic plot enter No Lw Ls Fb Fd Fa Aw Pb Bw No TREE_NUM 2 Unique tree identifier by species group Eligible code 1 to 99 TREE_TYPE 3 00 Identifies the tree as seedling tree SDL Eligible codes SDL or ADV or advanced tree ADV DBH 3 Sample tree diameter at breast height Eligible codes 1 to 999 mm HEIGHT 4 Height of sample tree cm optional Eligible codes 130 to 9999 blank measurement May 6 2015 RSA Complier User s Manual Page 52 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Table A2 9 Ground6 Optional gt 130 cm coniferous tree tally Forma Field Name t Description Note OPENING 11 00 Opening number consistent with E g 423075229A no blanks ARIS allowed POLYGON 3 00 Unique Sampling Unit number E g 001 002 003 etc no within an opening blanks allowed PLOT_ID 8 00 Unique plot identifier not more no blanks allowed than 8 alphanumeric characters SPECIES 2 00 SDL Species code Where no Eligible codes Sw Sb Se coniferous tree species taller than PI Pj Pw Pf Lt Lw 130cm are present in basic plot Ls Fb Fd Fa No enter No WGR 1 00 Y i
47. e This error message is displayed if the regsvr32 exe command is not run as an administrator on the Windows Vista or 7 computers Resolution Execute the regsvr32 exe command as an administrator of the Windows Vista or 7 computers Step 1 Click Start gt All Programs Accessories and then right click Command Prompt Step 2 Click Run as administrator If you are prompted with a logon enter as the Administrator Otherwise click Continue to enable the action Step 3 Within the Command Prompt type regsvr32 exe and then type enter the path of the dll file to be registered May 6 2015 RSA Complier User s Manual Page 39 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Appendix 2 Performance survey CSV file formats May 6 2015 RSA Complier User s Manual Page 40 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual The following tables provide the data formats and naming conventions to be used in the comma delimited CSV import files for the performance survey data Formats for data are either character or numeric The character format is identified by the symbol and is a combination of alphabetic and numeric alphanumeric characters Alphanumeric characters consist of numbers 0 to 9 and letters A to Z The numeric format will contain numbers 0 to 9 only The character and numeric formats include width and number of decimal places For example the format for AREA_HA be
48. e 55 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Opening 01 Import Critical Error Validation Every row in this dataset must have a unique non blank opening number i e no duplicates Attribute Validation Criteria Error E Warning W 101 102 103 104 105 105 106 107 109 110 110 108 310 Fields SYSTEM_TYPE DISPOSITION_HOLDER DISPOSITION FOREST_AREA FIELD_NUMBER OPENING NET_HARVEST_HECTARES UPDATE_AREA SKID_YEAR SKID_MONTH SKID_DAY PR_AREA Criteria Eligible codes A or N E Non blank W Non blank W Eligible codes NEB1 NEB2 NEB3 NES1 NES2 NES3 NWB1 NWB2 NWB3 NWBS5 NWB6 NWB7 NWB8 SESI SES2 SES3 SES4 W Non blank W Non blank E Eligible codes 0 01 to 9999 99 E Eligible codes blank or 0 01 to 9999 99 W Eligible codes 1900 to 2010 E Eligible codes 1 to 12 E Eligible codes 1 to 31 W Where SYSTEM _TYPE A Eligible codes blank W Where SYSTEM_TYPE N then Eligible codes 0 00 to 9999 99 W Verify that the Skid Date is within the eligible performance survey window W Eligible performance survey window is editable by user in the validation interface May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 56 of 73 ESRD RSA Compiler User s Manual
49. e edit routine to address any errors or warnings that may have been encountered during the compilation process The user must click the Continue button to proceed with the data compilation GYPSY projections and the MAI rollup at the opening SU and strata Aerial Stratification System only levels The opening level summary also follows the MAI Label Compilation Procedures as found in the RSA Where specified the 3 party model is used for all strata and polygons in the MAI rollup The compilation output is organized by program and data summary level as shown in Figure 20 E Compilation Output Program ACME Aerial v 2010 ACME Gypsy Input MAI Output Opening Strata 63 68 O_HwSx 2 56 0_Hw 31 45 O_Hw 33 64 O_HwSx 5 56 O_HwSx 5 46 O_HwSx 7 61 O_HwSx 10 14 O_Hw 3 17 0_Hw 4 93 0_Hw 13 64 O_HwSx 6 62 0_SwHw SbHw 5 69 O_HwSx 6 33 O_HwSx 6 76 O_HwSx 23 O_SwHw SbHw 9 29 O_HwSx 8 89 0_SbiSw 4 99 0_SbhiSw Preview Compilation Report Preview Validation Report Figure 20 Compilation output 4210520011 4210520011 4210520011 4210520013 4210520013 4210520017 4210520017 4210520017 4210520017 4210530020 4210530024 4210540029 4210540030 4210540030 4210540031 4220520033 4220520033 4220520034 lt ajla e242 yp 2424242 puna WBA on w After selecting a program the user can browse a number of tabs GYPSY Input includes the compiled performance survey data
50. ees in G3 but in G5 fewer than 3 G5 Deciduous species group SDL in G3 but not in GS 11 Inconsistent residual layer attributes 1 Inconsistent NAA code 1 Inconsistent average height 01 Skid date not between eligible perfomance window Total Count a NN N FO j N oj gt Figure 21 RSA Performance Survey Compiler Summary Report RSA Complier User s Manual 2015 Government of Alberta May 6 2015 Page 31 of 73 ESRD RSA Compiler User s Manual The summary report provides detailed information Table 2 Summary report warning categories on the population and ground sample by program a The report also shows compiled summary statistics Class Category by strata for the Aerial Stratification System and the COM detailed statistics by SU for the Non photo System P Compilation related warnings O1 Master opening list All Sampling Unit Exceptions flagged by the user ll Interpretation attribute data are reported along with the warnings that have not DQ Interpreted poorly regenerated areas prevented the compilation of the data but may impact the compiled results Table 2 Gr Ground sample poy gon Meader date G2 Ground sample plot header data The user should review the summary report very G3 Ground sample basic plot data carefully to ensure they understand the population G4 Ground sample detailed plot data and sample characteristics resulting MAIs lists of G5 Ground sample diameter data population changes l
51. ene eee ene eneene eae 59 Table A3 2 Density class definitions c cece ccc cence cece eee nee n nee nee ne ene ene en nE Eee nee test ene etna eee ees 59 May 6 2015 RSA Complier User s Manual Page 5 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual List of Figures Figure 1 General overview of the RSA compilation Process scsesscesecesecsseceseceseeseeeeseeeeseeeseesaaecsaeceaeeeaaeenaees 10 Figure 2 Registering the DLL on Windows XP 00 eeceeeeeseeeseeesseccecseceseceseceseceseceseesseessaeeeaeeeaeecaaecsaecsaesaeenaeees 11 Figure 3 Registering the DLL on Windows Vista eeeeeseeseesseessecesecsseceseceseceseesseeeseeecneeeaeeeaeecaaecaaessaesaesaeen 12 Figure 4 Successful registration of the DLL Arecont 13 Figure 5 Microsoft Access 2003 Security Warning csecseescecsecssecsseceseceseceseeeseeeseessaeeeseeeaeecaaecaaecsaecaeenaeens 13 Figure 6 Security Warning in Microsoft Access 2007 essssesssecssecsseceseceseceseceseceseeeseeecaeeeaeeeaeecaaecaaecsaesaesaeen 14 Figure 7 RSA Compiler split database design ee eeeeeeeseeseeeseecssecesecesecesecsseceseesseeeseeesaeecaeeeaeecaaecsaecsaesaeeaaees 15 Figure 8 RSA Compiler User Interfaccia e a N i ed e pasen ii 15 Figure 9 Import Configuration Settings 00 0 cee ees eeseesceesseesseeeseecsaecssecaecesecsseesseesseeseeescaeeeaeeeseecaaecsaeseaeeenaeenaees 16 Figure 10 General data flow for the Aerial Stratification Syste
52. er than 3 Deciduous Trees recorded in G5 but zero trees in G3 Opening Polygon Plot in G6 but not in G2 or not as plot_t Inconsistent species class Species code Secondary species percents Density class Sum of Species percent Inconsistent species code and percent Inconsistent NAA code Inconsistent density class Inconsistent residual layer attributes Inconsistent average height Skid year error broad range Skid date or day warning Total Number of Errors and Warnings ESmMSESTELSTE MSS SM EMSEEM Figure 15 The Validation Report The Validation Report window is split into three sections Program Section The user can select an individual program that is loaded into the database or review all programs default selection Display Section The user may select to show errors or warnings only by clicking the appropriate checkbox Summary Section The user is presented with a graphical and statistical summary of the validation results in the main window pane of the Validation Report The number of errors and warnings are reported by error type and data table for the selected program The data table tabs with errors and or warnings are highlighted in red Clicking the individual tab will take the user to a tabular view of all errors and or warnings associated with a particular data table The errors and warnings can be reviewed by clicking the Report button The errors and warnings report can be printed off
53. es group is equal to 2 in Ground5 and there are not 2 SDL diameter trees present for that species group in that plot then a warning should be generated W e Where the sum of SDL_tally_130 for a species group is greater than or equal to 3 in Ground5 and there are not 3 SDL diameter trees present for that species group in that plot then a warning should be generated W Fields OPENING POLYGON PLOT_ID 154 SPECIES 263 163 WGR 161 SDL_TALLY_130 161 ADV_TALLY_130 254 255 256 May 6 2015 RSA Complier User s Manual Page 69 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Appendix 4 Validation rules Sample selection data May 6 2015 RSA Complier User s Manual Page 70 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual The sample selection data must be imported into the RSA Compiler and validated before the compilation can proceed for the aerial programs The RSA Compiler has built in validation rules to ensure that the population of sampling units 11 matches the population the ground sample was based on A number of crosschecks between the planned sample list identified in the Excel Sample Selection Tool and the actual ground sample G1 are also carried out Discrepancies can be identified and flagged at the opening or sampling unit level by the user by adding a flag and comment to the sampling unit or entire opening in the Edit Module window For example if a sampling unit se
54. etween I1 and SU_Data worksheet W 514 Consistent HIGHER_STRAT between I1 and SU_Sample_List worksheet W 515 Consistent SP_CL between I and SU_Sample_List worksheet W 516 Consistent DEN_CL between I1 and SU_Sample_List worksheet W May 6 2015 RSA Complier User s Manual Page 71 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Appendix 5 Validation rules GYPSY input data May 6 2015 RSA Complier User s Manual Page 72 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual The GYPSY model requires further validation of the input data before the compilation takes place At this point in time all validation errors have been corrected and only a limited amount of further data checking is required as listed below Error identifiers are shown in red for easier reference ID Description Type 1001 When calculating stand age flag extreme ages gt 20 years as errors E 1002 When calculating stand age generate a warning for ages that are outside of W allowable expected range lt 12yrs or gt 14yrs 1003 When calculating site index for individual plots generate a warning where site W index values are lt 8m or gt 28m 1004 Confirm that all sample units in a stratum are consistently either E OPTIONAL_DIAM Y or N If optional diameter measures are taken they must be taken on all sampling units within a stratum If only part of a stratum has optional
55. f WGR encircles gt 50 of Eligible code Y blank the main stem diameter SDL_TALLY_130 3 Tally of the number of acceptable Eligible codes 0 to 999 SDL 130 cm in height by species ADV_TALLY_13 3 Tally of the number of acceptable Eligible codes 0 to 999 0 ADV 130 cm in height by species May 6 2015 RSA Complier User s Manual Page 53 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Appendix 3 Validation rules Performance survey data May 6 2015 RSA Complier User s Manual Page 54 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual The performance survey data are pre validated for data integrity errors such as orphan or duplicate records missing key identifiers such as opening or polygon numbers during the import of the CSV files into the user s database as described in Section 5 3 3 After import the performance survey data must be checked for issues that may prevent the proper compilation of MAIs The data issues are categorized as errors E and warnings W Errors must be fixed by the user before compilation can proceed The RSA Compiler has an extensive list of validation rules that are described below For easier reference the error identifiers Error ID are shown in red The presented information is based on the Microsoft Word document Validation Criteria May14_2010 prepared by Darren Aitkin ESRD May 6 2015 RSA Complier User s Manual Pag
56. ft Excel output and the O1 I1 and I2 CSV datasets All the necessary data is now ready for import into the RSA Compiler 5 3 2 Data flow for the Non photo System The Non photo System data flow is simpler as it does not require photo interpretation sample selection and the calculation of selection weights Upon completion of the field data collection the user must generate the O1 G1 G2 G3 and G4 CSV datasets to the defined specifications Where optional basal area measurements were taken then the G5 and G6 CSV datasets will also need to be created These datasets can be put into one folder All the necessary data is now ready for import into the RSA Compiler May 6 2015 RSA Complier User s Manual Page 18 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 5 3 3 Importing the performance survey data Once all required datasets are ready and organized by program in separate folders the user is ready to import the performance survey data by clicking the button on the RSA Compiler main interface After selecting the CSV option and picking the program folder the RSA Compiler attempts to read all eligible files and the import window appears as shown in Figure 11 The Import CSV files window is organized into three 3 main sections Folder Section The user can change the folder to select other datasets Checking the Include subfolders option enables the user to import several datasets at once as the RSA Compiler
57. fully imported and the program descriptors are assigned the user can exit the Import window by clicking the Close button 5 3 4 Importing the Sample Selection Tool output data The Aerial Stratification System requires the import of the Sample Selection Tool output excel file before compilation of the data can commence The RSA Compiler is designed to accept only the specific format provided in the Sample Selection Tool Microsoft Excel output file Once the performance survey CSV files are imported for a program the user can import the sample selection weights by clicking the button and selecting the Sample Selection Tool option 5 4 Validate This menu item is used to validate the performance survey data and sample selection data that have been imported into the user s database The validation process can be triggered by clicking the LEJ button on the RSA Compiler main interface The RSA Compiler has a very extensive set of validation rules that enables the user to catch and fix issues with the data before running the compilation The data issues are categorized into errors and warnings The Sample Selection Tool option is disabled greyed out in the Import process until performance data from an Aerial Stratification System is successfully imported into the user s database May 6 2015 RSA Complier User s Manual Page 22 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Errors are critical problems
58. he user back to the starting point H Flagging the openings and or SUs is only for the Aerial Stratification System Flags cannot be used for Non photo System May 6 2015 RSA Complier User s Manual Page 26 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 1 All performance survey and associated sample selection tool output data Aerial Stratification System only must be imported into the database 2 All performance survey and associated sample selection tool output data Aerial Stratification System only must be validated without errors Warnings are allowed however users are encouraged to fix any warnings that may occur The RSA Compiler automatically checks these criteria and the compilation cannot proceed for a particular program until the above criteria are met The status of each program can be reviewed in the Compilation Specifications window Figure 17 Compilation Specifications Status Primary Species compile Display status for each Program m MAI Age interval ie Calculate MAls based on years 0_SwHwiSbHw Ezana L E Sar Fi paar Other Model Use a model other than GYPSY 3rd Party Model Enter calculated MAls Utilization Limits Merch Volume pm Sdob Tdib St ht Species lem em fm Conifer 15 10 _03 o Figure 17 The Compilation Specifications window 0 3 0 3 Desciduous
59. ial Sel STRATA Use 3rd Party Model Other than GYPSY NB 0_PIHw Model MGM Version 20094 Y 0_PIHw Comments Approved Sep 20 2010 O_SwHw SbHw Culmination Age and MAIs for Conifer Deciduous Black Spruce White Spruce and Pine Opening Polygon cum Age Conifer Deciuuous Se sw M 2 102 5 C Select all Figure 18 The 3 party model data entry May 6 2015 RSA Complier User s Manual Page 28 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual First the user needs to select the program and the strata Aerial Stratification System or polygons Non photo System to which the approved alternative model can be applied For each polygon in a selected stratum the user needs to fill out 1 Model description and version number 2 Additional comments i e approval letter date or reference number and 3 Culmination age and MAI values for deciduous and for SB SW and PL 5 6 2 The RSA Compilation Process Once all loaded programs and associated data are validated and cleaned and the compilation parameters are setup the user can compile the data by clicking the Compile button in the Compilation Specifications window Figure 17 The RSA Compiler checks if there are any further data issues that may prevent successful compilation and a validation report is produced Figure 19 GYPSY input data validation Program AERIAL v 2010 ACME Serial
60. igible codes 0 1 2 3 4 5 6 7 8 9 composition to nearest 10 10 PR_SP3 2 00 Species code of third most Eligible codes blank Sw Se dominant species in the poorly Sb PI Pj Pa PP Fb Fa regenerated area Fd La Lt Lw Aw Pb Bw CPs eA PR_SP3_PER 2 SP3 s contribution to species Eligible codes 0 1 2 3 4 5 6 7 8 9 composition to nearest 10 10 PR_SP_CL 4 00 Species composition class Eligible codes blank Hw HwPI derived field based on SP1 HwSx SwHw PIHw SbHw through SP3 Sw PI Sb Fd PR_DEN 6 Total density stems per ha call Eligible codes 0 to 199 for the poorly regenerated area PR_AVE_HT 4 1 Average height of the poorly Eligible codes 0 to 99 9 regenerated area in meters May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 46 of 73 ESRD RSA Compiler User s Manual Table A2 4 Ground1 Unit header Field Name Format Description Note OPENING 11 00 Opening number consistent with E g 423075229A no ARIS blanks allowed POLYGON 3 00 Unique Sampling Unit number E g 001 002 003 etc within an opening no blanks allowed AREA_FINAL 7 2 Area hectares of Sampling strata Eligible codes 0 01 to following field assessment 9999
61. igure Al 1 Dependency Walker files 00 cece eaan n eee ecee eee N ences eee RE A RE ARN a 37 Figure Al 2 Dependency Walker interface ssssssssseersrrersrerresresserrrssserrrresesseererrererrseeseeseressss 37 Figure Al 3 Searching for missing files in Windows Explorer 0 0 ecceeecee eee e eee ee eee eeeeeensneeneeneenenaes 39 Figure Al 4 Successful registration of the GYPSY 2009 DLL 0 c cece cece cece nee ne en eneee nce eeeeneeneneen es 39 May 6 2015 RSA Complier User s Manual Page 6 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Appendices Appendix 1 Trouble Shooting Tips For Registering The GYPSY DLL cece eee ence sence nee neeeeenes 35 Appendix 2 Performance Survey CSV File Formats eccccecececeeceeeeeeeeeeeeceneeeeseeeeneeeeeaeneeeees 40 Appendix 3 Validation Rules Performance Survey Data ccceceecec eee neeeeneeceeeeneeaeeteaeeeeaeneenas 54 Appendix 4 Validation Rules Sample Selection Data 00 cccecece nce e ne ecee ene ee ene en eee eaeeeeneneeneenenes 70 Appendix 5 Validation rules GYPSY input data 00 eee eee eee ene eneneeene ene ene ene eneeneeneeneeneneneeas 72 May 6 2015 RSA Complier User s Manual Page 7 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 1 0 Acknowledgements ef SOURCE Meg The Reforestation Standard of Alberta RSA Compiler f
62. in Ground dataset 211 e Every unique opening polygon and plot_id combination that occurs in the Ground2 dataset must also occur in this dataset e Every row in this dataset must have a unique opening polygon plot_id species and WGR combination i e no duplicates Attribute Validation Criteria Error E Warning W Fields Criteria OPENING Non blank E POLYGON Non blank E PLOT_ID Non blank E 154 SPECIES Eligible codes Sw Sb Se PI Pj Pw PP Lt Lw Ls Fb Fd Fa Aw Pb Bw No E 163 WGR Eligible code Y blank E 161 SDL_TALLY Eligible codes 0 to 999 E 164 Provide warning where SDL_TALLY gt 20 W 161 ADV_TALLY Eligible codes 0 to 999 E 165 Provide warning where ADV_TALLY gt 10 W May 6 2015 RSA Complier User s Manual Page 65 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Ground4 G4 Import Critical Error Validation 212 e Every unique opening polygon and plot_id combination in this dataset must also occur in Ground2 dataset as PLOT_TYPE D 213 e Every unique opening polygon and plot_id combination that occurs in the Ground2 dataset as PLOT_TYPE D must also occur in this dataset e Every row in this dataset must have a unique non blank opening polygon plot_id and species combination i e no duplicates Attribute Validation Criteria Erro
63. ing the CSV data option will take the user to the Validation setup interface Figure 14 The user can review the summary information number of records to be validated by data table and select which table s to validate The skid date for the assessed openings can be set so that the RSA Compiler checks if the skid date is within the eligible performance survey window Persons with administrative rights to the RSA Compiler program may also review and set the validation criteria by clicking the Setup button This option is password protected Clicking the Validate button will carry out the validation and will take the user to the Validation Report as shown in Figure 15 May 6 2015 RSA Complier User s Manual Page 23 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual E Validation Report _ Program ALL Programs wv ALL Loaded Programs Display Errors Warnings Report Edit Close J Summary Number of Errors and Warnings ALL Programs Data Class Class Type Error ID Description Number of E Errors Warnings Opening Polygon Plot in G2 but not in G3 SDL Tally trees warning ADY Tally trees warning Opening Polygon Plot in G4 but not in G2 or not as plot_t Total Age gt Survey_Year Skid_Year 2 Opening Polygon Plot in GS but not in G2 or not as plot_t Deciduous species group SDL in G3 but not in GS Deciduous 3 or more trees in G3 but in G5 few
64. is non blank then PR_SP2_PER should be non zero and vice versa W 33 Where PR_SP3 is non blank then PR_SP3_PER should be non zero and vice versa W 33 Where PR_SP2 is blank then PR_SP3 should be blank W 33 PR_SP2_PER should not be larger than PR_SP1_PER W 33 PR_SP3_PER should not be larger than PR_SP2_PER W 33 PR_SP1_PER PR_SP2_PER and PR_SP3_PER fields should sum to 10 W Where trees are NOT present 34 a R_SP1I_PER PR_SP2_PER PR_SP3_PER PR_DEN and PR_AVE_HT must be zero W 34 b PR_SP1 PR_SP2 and PR_SP3 must be blank W May 6 2015 RSA Complier User s Manual Page 61 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Ground G1 Import Critical Error Validation 205 206 207 e Every opening that occurs in this dataset must also occur in the Opening dataset e Every opening in the Opening dataset that has SYSTEM_TYPE Non photo must also occur in this dataset e Every unique opening and polygon combination that occurs in this dataset must occur in the Interp1 dataset when the opening is SYSTEM_TYPE Aerial e Every row in this dataset must have a unique non blank opening and polygon combination i e no duplicates Attribute Validation Criteria Error E Warning W 121 122 123 124 125 125 125 126 127 128 129 129 129 129 May 6 2015 RSA Complier User s Manual Page 62 of 73 Fields Criteria OPENING Non blank E POLYGON
65. ist of outstanding warnings G6 Ground sample conifer 130 tally data the list of le outages Soe One apres SST Sample Selection Tool data 5 8 Export This menu item is used to export the performance survey data and sample selection data The export process can be triggered by clicking the button on the RSA Compiler main interface 5 8 1 Exporting the Performance Survey Data The RSA Compiler provides convenient features to validate and fix errors in the performance survey data Once the errors and warnings are fixed the user may require the corrected data to be available for other systems The corrected performance survey data can be exported into a series of CSV files by selecting the CSV datasets option on the Export menu item The number of CSV files will depend on the program type Aerial Stratification or Non photo System and whether any optional data have been collected The file names will follow the suggested long file naming convention as shown in Table 1 For example the master opening list for the aerial program will be called OPENINGI AERIAL CSV Alternatively the users can specify their own suffix for the selected program Figure 22 Export data File format Data Type only raw data Data Selection Select by s Program Program vss ii ALL Filename Suffix ALL_Sets i Figure 22 Export to CSV datasets May 6 2015 RSA Complier User s Manual Page 32 of 73 2015 Government of Alberta
66. lected for sampling has been entirely disturbed by a new disturbance or a disturbance missed during photo interpretation the user may flag the sampling unit and provide a comment so that the unit can be excluded from the population for MAI calculations and the RSA Compiler can select the next available contingency as a replacement The opening still receives the roll up results from the SUs that remain The inconsistencies between the planned and actual sample are flagged and reported in the RSA Performance Survey Compiler Summary Report The validation rules used by the RSA Compiler for the sample selection data are given below ID Description Type 501 SU in Inclusion_Prob worksheet must occur in I1 table E 502 SU in I1 and NAA 0 must occur in Inclusion_Prob worksheet E 503 Consistent final strata in Inclusion_Prob worksheet and G1 table E 504 Total runs must be equal to 5000 505 Selection weights must be 1 E 506 SU was planned to be sampled but was not surveyed W 507 SU was surveyed but was not part of the planned sample list W 508 Consistent HIGHER_STRAT between I1 and Inclusion_Prob worksheet W 509 Consistent SP_CL between I1 and Inclusion_Prob worksheet W 510 Consistent DEN_CL between I1 and Inclusion_Prob worksheet W 511 Consistent HIGHER_STRAT between I1 and SU_Data worksheet W 512 Consistent SP_CL between I1 and SU_Data worksheet W 513 Consistent DEN_CL b
67. ligible codes blank Sw Se Sb most dominant species in PI Py Pa Pf Fb Fa Fd the regeneration layer La Lt Lw Aw Pb Bw P A SP2_PER 2 SP2 s contribution to Eligible codes 0 1 2 3 4 5 6 7 8 9 10 species composition to nearest 10 SP3 2 00 Species code of third most Eligible codes blank Sw Se Sb dominant species in the PI Pj Pa Pf Fb Fa Fd regeneration layer La Lt Lw Aw Pb Bw P A May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 43 of 73 ESRD RSA Compiler User s Manual Field Name Format Description Note SP3_PER 2 SP3 s contribution to Eligible codes 0 1 2 3 4 5 6 7 8 9 10 species composition to nearest 10 SP4 2 00 Species code of fourth most Eligible codes blank Sw Se Sb dominant species in the PI Py Pa Pf Fb Fa Fd regeneration layer La Lt Lw Aw Pb Bw P A SP4_PER 2 SP4 s contribution to Eligible codes 0 1 2 3 4 5 6 7 8 9 10 species composition to nearest 10 SP5 2 00 Species code of fifth most Eligible codes blank Sw S
68. low is 7 2 The width is 7 including the decimal and the number of decimal places is 2 The decimal and values after the decimal should not be used for the character format Table A2 1 Opening1 Master opening list Field Name Format Description Note SYSTEM_TYPE 1 00 Type of performance Eligible codes A or N assessment DISPOSITION_HOLDER 28 00 Timber Disposition E g River City Timber Holder the legal name of Ltd the forest company or organization that retains the reforestation liability for the opening DISPOSITION 10 00 Disposition refers to the E g FMA0900088 legal document that grants CTQA130010 the right to harvest timber DTAA090001 etc Reforestation liability is attached to the disposition FOREST_AREA 4 00 The Alberta administrative Eligible codes NEB1 unit region area where NEB2 NEB3 NES1 the opening is located NES2 NES3 NWB1 NWB2 NWB3 NWBS NWB6O NWB7 NWB8 SES1 SES2 SES3 SES4 FIELD_NUMBER 12 00 The number assigned by E g 1234 the Timber Disposition Holder to the opening that appears on the AOP or harvest plan map OPENING 11 00 Opening number consistent E g 423075229A no with ARIS blanks allowed NET_HARVEST_HECTARE 7 2 Area hectares from ARIS Eligible codes
69. m oo ccc eeceecesceseceeeeeseeeeseeeseecsaecsaecaeseaeeenaees 18 Pigure 11 importin CSV Tiles 3 cscs cescasedeesdesdectaee thc degeusnecgdecec ces eaae oan VEE AO Aa EEEE Eee SE Ea EE ieena 20 Figure 12 File Information Summary before the CSV data import essesseseeseessesesssesessrssresrrsresesrrsserrreseesressese 21 Figure 13 The Program Descriptor WindOW csccessceeseeeseeesceeseecscecssecsecaecsseceseeeseessneseneeeseeeseecaaecsaeenaecaaeenaeed 22 Figure 14 The Validation setup interface eee eeeeeseeeseeeseeeseecseecsaecsecesecesecsseesseeeeeessaeesaeeeseecaaecaaesaeeesaeenaeed 23 Figure 15 The Validation Reports ceruen e eri ea A EE ene ee ees 24 Figure 16 The Data Editomececseir uenea eiea e a a a a a a teehee oa 25 Figure 17 The Compilation Specifications windoW sseeseeseeseserssteeesstesrsstesresressestesstsrtssrestrstentestessesrrsseestssrent 27 Figure 18 The 3 party model data entry csi0i3 5 sserecdcxstisvie asst dea cdhs ates aside aeeiay eae aes we 28 Figure 19 Compilation validation report 0 0 0 eeceeceeseeeceeeseeeeeeseecsaecssecsecsaeesseceseesseesseessaeeeaeeesaecaaecaaeseaaeeaaeenaees 29 Figure 20 Compilation Output ei eles Ane eg a cs eee es eee eee a ek ee et 30 Figure 21 RSA Performance Survey Compiler Summary Report 2 0 0 0 cescesceeeceseceeeeeseeeeseeeseecaaecsaecsaecnaeeenaees 31 Figure 22 Export t0 CS V datasets enar een rne reata aeae ETE KE EE Ea ERa PE sca PATEE EAER Er 32 F
70. nformation window will only appear if there are issues with any of the imported datasets However the information can be reviewed at any time by clicking the File INFO button as shown in Figure 11 After the import process is complete the user is prompted to enter the program description for each dataset Figure 13 The requested information includes a program descriptor year company name and FMA or FMU identifier This information is used in various reports the RSA Compiler generates and is intended to help the user keep track of the various programs If there is more than one dataset per program the user needs to enter the program descriptors only the first time Subsequent datasets from the same program can simply be assigned to an existing program descriptor by selecting from the list May 6 2015 RSA Complier User s Manual Page 21 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual E Program Descriptor for NON PHOTO Program Descriptor for Dataset NON_PHOTO Enter or select the Program Descriptor for the dataset NON_PHOTO This info will be included into the standard summary reports Enter new program descriptor Descriptor Non phatdf Year 2010 Company ACME FMA or FMU 123456 Select a program descriptor or ID Descriptor Year_ Company FMA or FMU Figure 13 The Program Descriptor window Once all required datasets are success
71. nment of Alberta ESRD RSA Compiler User s Manual E Import CSV dataset s Folder C Documents and Settings gyulag Desktop Gyula RSA_Compiler DEMO Data ACME Aerial Import Errors C Include subfolders Teo Summary Detail eror o ME e aleg Sel Dataset Name Files Summary Yes ACME Aerial Import Errors 9 1 Number of datasets b ready to be imported free of critical errors 4 0of1 Data to be imported a datasets d sampling units b files H e plots total c openings f detail Number of critical errors in selected dataset s a duplicated IDs b blank IDs c orphans d sampling unit already loaded e duplicated sampling unit within current selected datasets Total number of errors 2 M Select all Switch all Select TE Re Waite Figure 11 Importing CSV files The import errors are considered critical as they would prevent the data to be imported into the various data tables in the user s database Most of these errors should be fixed outside the RSA Compiler using the same process that generated the CSV files The errors can be reviewed by clicking the List of Errors button The error report can be printed and provided to the contractor as a reference to fix the data issues Once these errors are fixed and the new CSV files are created the user should attempt to re import the data If no critical errors are found the datasets are
72. ns the internal lookup tables the main program uses 3 RSA_zero mdb This file contains the database templates the main program uses Upon opening the main program file make sure you click the Open button to by pass the Security Warning window as shown in Figure 5 Microsoft Access 2007 Unless the file is located in one of the Microsoft Access Trusted Locations you will get a Security Warning upon opening the file that is very difficult to notice in Microsoft Access 2007 The warning is located under the ribbon toolbar and it looks like the image in Figure 6 The latest Microsoft Access version at the time of this writing is version 2010 gt We suggest copying the program files into a folder called RSA_Compiler Prog This folder may need to be created May 6 2015 RSA Complier User s Manual Page 13 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual ANL EEES i iad Home Create External Data Database Tools amp Cut BEE i 53 Copy a po pa Ms z 3 ii ee J Format Painter Barb Ao IE i Views Clipboard __ j Font ooo y eR 7 Security Warning Certain content in the database has been disabled Figure 6 Security Warning in Microsoft Access 2007 Click the Options button and check Enable this content so that the Visual Basic for Application VBA macros will execute Alternatively the user can designate the RSA Compiler folder
73. opies of the missing file that are used by various applications installed on the user s system Sort the list by clicking on the list header Date modified and pick the most recent version of the file Copy the selected file into the C Windows SysWOW64 folder The user must have administrative rights on their computer to carry out this task 16 Windows only searches for files in folders that are included in the default system paths 17 Please note that the missing component can be any file The example msver71 dll is only one example that people with this DLL registration issue commonly encounter May 6 2015 RSA Complier User s Manual Page 38 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual After recovering all the missing components and copying them into C Windows SysWOW64 the user should be able to register the GYPSY 2009 DLL as per the original installation instructions Figure A1 4 RegSyvr32 e 1 DilRegisterServer in C Projects ASRD GYPSY_DLL GYPSY_20 100309b32 GYPSY_2009 dll succeeded Figure A1 4 Successful registration of the GYPSY 2009 DLL In the extremely rare case that the missing file already exists in C Windows SysWOW64 DO NOT REPLACE the existing file in C Windows SysWOW64 with the one you copied Contact developer for further debugging and advice If the missing file cannot be found on the system please also contact developer for further advice Error message 2 Caus
74. or Aerial Stratification and Non x photo Performance survey Systems was developed with funding through the Forest 2 Resource Improvement Association of Alberta FRIAA FRIAA Project HIWOOD 01 129129 titled Growth and Yield Projection System for Regenerated Stand Management s This FRIAA project was supported by the following companies nay OF no Company Funding Support In Kind Support Alberta Plywood Ltd v v ANC Timber Ltd v v Blue Ridge Lumber Ltd v v Canadian Forest Products Ltd v v West Fraser Mills Ltd Hinton v v Sundance Forest Industries Inc v v Sundre Forest Products Ltd v v Weyerhaeuser Company Ltd v v Alberta Pacific Forest Industries Inc 4 Foothills Forest Products Ltd v Millar Western Forest Products Ltd v This product is the result of several years of cooperative work between the project sponsors and Alberta Environment and Sustainable Resource Development The RSA Compiler project was completed under contract by TECO Natural Resource Group Ltd Project Manager Gyula Gulyas May 6 2015 RSA Complier User s Manual Page 8 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 2 0 Scope This user s manual only describes the installation and usage of the Reforestation Standard of Alberta RSA Compiler A detailed description of the stratification sample selection field survey data compilation Mean Annual Increment MAI computation and roll up pro
75. or from the menu as shown in Figure 3 5 Enter regsvr32 path to your dlNfolder GYPSY_2009 dll at the prompt For example if you placed the DLL into C Windows System32 then regsvr32 CA Windows System32 GYPSY_2009 dll will need to be entered Make sure that you also use the double quotation marks as given 6 Close the Command window A Windows Movie Maker ta Windows Photo Gallery Er Windows Update J Accessories E Calculator BJ Command Bremnt 2 Connect to Open Y Paint Open file location mi Remote De B Add to archive i5 Run Add to cmd rar SR Snipping T Compress and email L Sound Rec Compress to cmd rar and email Sync Cente Pin to Start Menu tg Add to Quick Launch a ae 5 Scan for viruses E WordPad Scan with Malwarebytes Anti Malware di Ease of Acq 3 Send To gt i Entertainm J System Toc Cut d Acoustica Mixe Copy J activePDF Paste db Amazon Delete Rename Start Search Properties Figure 3 Registering the DLL on Windows Vista If your registration was successful you will see a small window pop up with a message similar to the one shown in Figure 4 May 6 2015 RSA Complier User s Manual Page 12 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual RegSyvr32 e 1 DilRegisterServer in C Projects ASRD GYPSY_DLL GYPSY_20100309b32 GYPSY_2009 dll succeeded Figure 4 Successful registration of the DLL If registration
76. r E Warning W Fields Criteria OPENING Non blank E POLYGON Non blank E PLOT_ID Non blank E 154 SPECIES Eligible codes Sw Sb Se PI Pj Pw Pf Lt Lw Ls Fb Fd Fa Aw Pb No E 158 TOPHT Where species Sw Sb Se PI Py Pw PP Lt Lw Ls Fb Fd Fa then Eligible codes 30 to 9999 E Where species Aw Pb then Eligible codes 130 to 9999 E 175 Where species No then blank E 166 Provide a warning where TOPHT gt 1000 W 157 TH_DBH Extreme values turned off 162 TOTAL_AGE Where species other than No then Eligible codes to 20 E Where species No then blank E 174 Provide a warning where TOTAL_AGE gt SURVEY_YEAR SKID_YEAR 2 W May 6 2015 RSA Complier User s Manual Page 66 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual TABLE Ground5 G5 Import Critical Error Validation 214 e Every unique opening polygon and plot_id combination in this dataset must also occur in Ground2 dataset as PLOT_TYPE D 215 e Every unique opening polygon and plot_id combination that occurs in the Ground2 dataset as PLOT_TYPE D must also occur in this dataset 216 e Every unique opening and polygon combination in this dataset must also occur in Ground dataset as OPTIONAL
77. r model E g GPSmap 76CSx blank if GPS not used GPS_COOR_SYS 3 00 Identifies the GPS coordinate Eligible codes LL UTM system used longitude and latitude LL or Universal Transverse Mercator UTM Use NA where GPS was not used 2NA May 6 2015 RSA Complier User s Manual 2015 Government of Alberta Page 47 of 73 ESRD RSA Compiler User s Manual Field Name Format Description Note GPS_LL_FORM 13 00 GPS coordinate system format Eligible longitude and latitude when reporting plot locations position formats using longitude and latitude LL hddd mm ss s Three common formats are hddd mm mmm hddd dddd 1 degrees minutes and seconds Blank if UTM is recorded in the GPS_COOR_SYS field or if GPS not used 2 degrees and decimal minutes and 3 decimal degrees GPS_UTM_ZONE 3 00 Identifies the GPS UTM Zone N Eligible codes 11N 12N to designate northern hemisphere Blank if LL is recorded in when recording plot locations the GPS_COOR_SYS field or using the UTM coordinate system if GPS not used May 6 2015 RSA Complier User s Manual Page 48 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Table A2 5 Ground Plot header Field Name Format Description Note OPENING 11 00 Opening number consistent with E g
78. ription Note OPENING 11 00 Opening number consistent with E g 423075229A no blanks ARIS allowed POLYGON 3 00 Unique Sampling Unit number within E g 001 002 003 etc no an opening blanks allowed PLOT_ID 8 00 Unique plot identifier not more than 8 no blanks allowed alphanumeric characters SPECIES 2 00 Species code Where no tree species Eligible codes Sw Sb Se are present in basic plot enter No PI Py Pw Pf Lt Lw Ls Fb Fd Fa Aw Pb Bw No WGR 1 00 Y if WGR encircles gt 50 of the Eligible code Y blank main stem diameter SDL_TALLY 3 Tally of the number of acceptable Eligible codes 0 to 999 coniferous SDL gt 30 cm and deciduous SDL gt 130 cm by species ADV_TALL 3 Tally of the number of acceptable Eligible codes 0 to 999 Y coniferous ADV gt 30 cm and deciduous ADV gt 130 cm by species May 6 2015 RSA Complier User s Manual Page 50 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Table A2 7 Ground4 Detailed plot Field Name Format Description Note OPENING 11 00 Opening number consistent with E g 423075229A no blanks allowed ARIS POLYGON 3 00 Unique Sampling Unit number E g 001 002 003 etc no blanks within an opening allowed PLOT_ID 8 00
79. se that were field sampled as part of the program The inspector can then conduct the field inspection and enter the resulting inspection data in to the data entry interface provided in the Audit Module Any differences outside of allowable tolerances between the program field data and the inspection field data are detailed in a report 14 The Export module also includes the mdb option that will enable the user to export the raw and compiled survey data directly into an MS Access database in the future This option is not implemented yet May 6 2015 RSA Complier User s Manual Page 33 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual 5 10 About Clicking the About button on the RSA Compiler main interface will show the user the developer s information and the program and GYPSY DLL version number May 6 2015 RSA Complier User s Manual Page 34 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Appendix 1 Troubleshooting tips for registering the GYPSY DLL May 6 2015 RSA Complier User s Manual Page 35 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual Background The GYPSY 2009 DLL is a Microsoft COM type DLL which means that it needs to be registered on the user s system The DLL installation instructions can be found in the document GYPS Y_2009_DLL_Manual pdf included in the GYPSY DLL software package At the time of the development of the GYPSY
80. the population of openings to be assessed has been identified and the photo interpretation is completed The RSA Compiler has built in validation rules to help ensure that all opening and polygon attributes are free of detectable errors After successful validation and fixing of potential attribute errors the data can be exported back to corrected CSV files and saved in the program folder Step 2 The I1 dataset can be exported to the Sample Selection Tool SST to define the sample and calculate inclusion probabilities to compute the sample selection weights The output of the run must be saved as an Excel May 6 2015 RSA Complier User s Manual Page 17 of 73 2015 Government of Alberta ESRD RSA Compiler User s Manual workbook using the SST Output menu item This SST output workbook is needed by the RSA Compiler in this specific format Based on the selected sample field work can commence POPULATION OF OPENINGS IDENTIFIED PHOTO INTERPRETATION COMPLETED RSA COMPILER RSA COMPILER SAMPLE SELECTION TOOL FIELD SAMPLING COMPLETED Figure 10 General data flow for the Aerial Stratification System Step 3 Upon completion of the field data collection the user must generate the G1 G2 G3 and G4 CSV datasets to the defined specifications Where optional basal area measurements were taken G5 and G6 CSV datasets will also need to be created These datasets can be put into the same folder as the Sample Selection Tool Microso
81. tion for Performance Survey CSV files Suggested File Class _Component Name Notes Ol Master opening list O1 or OPENING1 Il Interpretation attribute data Il or INTERP1 Aerial only 12 Interpreted poorly regenerated areas I2 or INTERP2 Aerial only Gl Ground sample polygon header data G1 or GROUND1 G2 Ground sample plot header data G2 or GROUND2 G3 Ground sample basic plot data G3 or GROUND3 G4 Ground sample detailed plot data G4 or GROUND4 G5 Ground sample diameter data G5 or GROUNDS Optional G6 Ground sample conifer gt 130 cm G6 or GROUND6 Optional tally f where applicable The program name could be used as the folder name or alternatively it could be included as a prefix or a suffix in the CSV file names For example OPENING1_AERIAL CSV or AERIAL_O1 CSV Use an underscore _ to separate the program name from the rest of the file name Although the required file specifications are identical for the Aerial Stratification and Non photo systems the data flow differs slightly as the Aerial Stratification System involves photo interpretation and the calculation of sample selection weights for the population of units 5 3 1 Data flow for the Aerial Stratification System The general data flow for an Aerial Stratification System is presented in Figure 10 Below are the steps required in this process Step 1 The user can import the O1 Master Opening List and I1 I2 interpreted polygon data from the CSV files into the RSA Compiler once
82. was unsuccessful users should refer to the trouble shooting tips provided in Appendix 1 4 2 Installing the RSA Compiler After successfully registering the GYPSY 2009 DLL the RSA Compiler is ready to be installed The RSA Compiler was developed and tested for Microsoft Access 2003 and newer versions including Microsoft Access 2007 To determine your version of Microsoft Access just follow the menu Help About Microsoft Office Access If you cannot find the Help item on your menu then you most likely have Microsoft Access 2007 or a later version The installation and usage of the RSA Compiler is identical for Microsoft Access 2003 and earlier versions However Microsoft Access 2007 was a major upgrade in both interface and internal architecture therefore whenever warranted we provide a short section detailing the difference Security Warning Opening C Documents and Settings gyulag Desktop Gyula RS4_Compiler Prog RSA_Compiler mdb This File may not be safe if it contains code that was intended to harm your computer r r Do you want to open this file or cancel the operation The RSA Compiler does not require any aeaee special installation Just unzip the three 3 bu program files into any folder of your o choosing The three program files are called Figure 5 Microsoft Access 2003 Security Warning 1 RSA_Compiler mde This is the main program to open after installation RSA_Compiler_LUT mdb This file contai
83. we need to search the computer hard drive 1 Open Windows Explorer 2 Select the C drive in the left folder panel and 3 Type msvcr71 dll in the search box upper right corner Figure Al 3 shows the search results in our example CF ey gt gt Search Results in Local Disk C EEIE Organize v E Open with Save search Burn Searches might be slow in non indexed locations C Click to add to index a Name Date modified Type Folder Ft Favorites EE Desktop S ms 15 06 2011 5 59 PM Application extens YouCam C Program Files x86 CyberLin p Downloads a 15 06 2011 5 59PM Application extens YouCam C Program Files x86 CyberLin Dropbox D ms 28 01 2011 3 31 PM Application extens OLRSubmission C Program Files x86 C E Recent Places S ms 15 11 2010 1 12PM Application extens Runtime C Program Files x86 CyberLin 18 07 2007 2 33 PM Application extens in CA gygulyas AppData Roaming Libraries M 26 10 2006 2 45PM Application extens ADDINS C Program Files x86 Microsoft E Documents d Music Pictures E Videos Search again in J Libraries amp Homegroup pill Computer Custom Internet p File Contents a Homegroup al m i msvcr71 dll Date modified 15 06 2011 5 59 PM Date created 15 06 2011 5 59 PM s Application extension Size 343 KB Figure A1 3 Searching for missing files in Windows Explorer Generally there are several c
84. with the data that may significantly impact the compilation results therefore they must be fixed before the compilation can commence There are a number of different types of Warnings e Extreme values which should be double checked to make sure they are valid e Invalid codes or values which may or may not have an impact on the compilation results depending on the field and type of outage These should be corrected by the user e Relational inconsistencies between fields or datasets which may or may not have an impact on the compilation results depending on the outage These should be corrected by the user While all warnings should be addressed by the user warnings do not prevent compilation of performance survey results in the Compiler The validation rules are listed in detail in Appendix 3 and Appendix 4 E Validation Tables alidate the following tables Number Aerial Assessment Data of Records I1 Sampling unit 65 I2 Poorly regenerated areas 3 Ground Data O1 Opening header Openings G1 Unit header SUs G2 Plot header plots G3 Basic plot plots G4 Detailed plot 377 plots G5 Optional diameter measure 377 plots G6 Optional coniferous 130 tally 377 plots erify that skid date is within eligible performance survey window V Skid date between May 1997 and April 2000 w Figure 14 The Validation setup interface 5 4 1 Validating performance survey data Clicking the Validate button and select
85. y select to show all default errors or warnings only by clicking the appropriate checkbox Browser Section The user may browse the errors and warnings by opening in the left pane of the Edit window The opening list is automatically refreshed based on selection in the Display Section Multiple openings may be selected by holding down the Ctrl key and clicking individual openings in the opening list Data Tab Section The user can browse and fix errors and warnings in the right pane of the Edit window As with the Validation Report the data tables with issues are highlighted in red Program AERIAL v 2010 ACME Display v All Error _ Warning Revaldate ssr Data Close j u E EEE 4210520011 lc B Data Summary 4210520013 PROGRAM AERIAL EEE a General Description 4210530023 Program Descriptor AERIAL Program Year 2010 4210530024 Company Name FMA or FMU 123456 4210540029 System Type Aerial 4210540030 4210540031 4220520033 Sampling Information 4220520034 Selection Number of Number of Plots ee a i Openings Sampling Units Total Detail 4220520039 iy Number of items in selected a Program 24 41 1 641 414 4220520048 b Openings 24 41 1 641 414 4220530049 4220530060 4220540067 4220540100 Selected Program Number of Possible Errors and Warnings 4220540101 beai Data Class 4220540102 Number ol 4220540103 4 12 Gl G2 G3 G4 4

RSA Compiler User`s Manual - Alberta Environment and Parks

Contents

Download Pdf Manuals

Related Search

Related Contents