top of page

Public Forum

Public forum for posting questions and answers.  Posting is open to website members.

Forums

Forum

Public·2 members

Originally posted by: ecohen


Rich, I am trying to run a query on cruises which have an actual quality calls on a cruise. The challenge is all stands have a grade weather we measured in field or not. How could I go about doing this only to isolate the stand which had an actual field call on logs. Let me know if you have time to discuss or respond to my email. Hope all is well. Thanks Eric

5 Views
Guest
Mar 31

Originally posted by: Rich Howard


Sounds like you are trying to find all the cruises with field called logs as opposed to cruises with only total heights called. The Logs table should have everything you need since it stores all the field called logs and grades. If there is a record in the Logs table, then there was a log called in the field.

Run a query like the following:

SELECT Stand

FROM Logs

WHERE NOT Grade IS NULL

GROUP BY Stand

Rich

Originally posted by: pfund


Good Morning, As I work my way through ASSISI I keep coming up with questions about the compile procedure and the subsequent results. 1) I get an error message that Organon needs a DF,GF,WH to compile a stand. This stand was a pure hardwood type. When I added a DF in to the plots and re-compiled it ran without an error. If the need for a DF, or GF, or WH is a Organon requirement is there any way to get around it? Or do I have to add a DF to each hardwood stand? 2) I have compiled several hardwood stands or stands with a hardwood component and find that I get cubic foot volume but I never get board foot volume. I checked the calibrations/species under Red Alder, Big leaf maple, actually all hardwoods and found …

2 Views
Guest
Mar 31

Originally posted by: david.hann


1) The only version of ORGANON that allows pure hardwood stands is the red alder plantation version (RAP-ORGANON) because this is the only hardwood species with site index and dominant height equations and the only species that had data sets from pure hardwood stands. The remaining hardwood species in ORGANON came mostly from stands that were predominately conifer in composition.

2) The ORGANON board foot volume estimates are calculated using taper equations and when the model was developed there were no taper equations available for hardwood species. Therefore, there are no ORGANON board foot equations for hardwood species. Perhaps there are other equations that could be incorporated into the ASSISI software.

Originally posted by: ryan.stewart


Rich I would like to filter out certain stand components from the summaries. For instance, I have separated our trees into two subplots, one is trees 3 to 10" DBH and the other is 10" and above. If I wanted to generate a stand summary for one or the other subplot (timber vs regen/ biomass) how would I go about it? Thanks, Ryan

2 Views
Guest
Mar 31

Originally posted by: Rich Howard


Hey Ryan,

You can exclude any trees on Regen type sub plots by setting “Compile Regen Sub Plots to Summaries?” to false. This will exclude TPA, BA etc from the summary tables from which reports are made. Note that if you view the individual trees in the Inventory Editor you will still see processed regen trees. They just won’t be included on the “rollup” type summaries (by species, by stand, by DBH class, etc) from which the reports are made.

The Compile Regen... option is set on the Volume view in Calibration Editor.

Rich

Originally posted by: ryan.stewart


Hey Rich- Adding a field for number of plots per stand in the stand viewer would be great. Maybe on the next setup..

2 Views
Guest
Mar 31

Originally posted by: Rich Howard


Added a Plots table view to Cruise. This shows all the plots and their data when you click on a cruise.Rich

Originally posted by: ryan.stewart


Hi Rich, Hope things are going well! I have a GIS question for you... When it comes to personal geodatabases vs. file geodatabases do you prefer one or the other for use with Assisi? I would assume that you would want us to stick with the personal format (.mdb) so that we could tie in with Access and Assisi more easily. Let me know what you think or if it matters at all. Thanks, Ryan

Guest
Mar 31

Originally posted by: Rich Howard


HI Ryan,

You can really use whatever GIS format you want since it’s the GIS program rather than Assisi that determines how easy it is to link to Assisi’s database. Although ESRI does recommend the File Geodatabase over the Personal Geodatabase. See these links for more:

http://webhelp.esri.com/arcgisdeskt...odatabases

www.esri.com/news/arcuser/0309/files/9reasons.pdf

The one exception is if you want to use Assisi itself to display maps within the Assisi Interface. Then your maps have to be in shape file format. Shape files are old technology but you can use Assisi itself to browse stands, plots and trees by clicking on features in the shape file viewer in Assisi. In the future we will add direct geodatabase support but we haven’t heard all that much call for adding more mapping ability to Assisi as of yet. I suspect external tools are what everyone is already comfortably with. However, moving to a more visual interface is where we want to go in the future, and that means more mapping.

Maybe we should move that up on our todo list?

Rich

Originally posted by: ryan.stewart


I need to add a TreeDefect catagory to the trees table and possibly an allowed TreeDefect table to be associated with it. Trees with defect would be recorded in the field as a percent and then c, n or x. c for cull, n for nonmerch and x for missing. For example a tree with a broken top would have its % missing estimated in the field and then coded 20x in the field computer, for 20% missing. or if it were cull, "20c" , and "20n" for 20% nonmerch. This is how FORSEE removes volume from damaged trees. I am trying to get the two programs to accept similar field data so its easy to setup FORSEE import data files. I will be importing field data using Assisi, and then exporting tree, stand and site data into a FORSEE upload …

Guest
Mar 31

Originally posted by: Rich Howard


Hi Ryan,

I think you are on the right track. There is a Trees.Defect field that is meant to hold a defect that is applied to the whole tree. If you enter a value (direct database stores it as a fraction: .2 = 20%) then that defect will be applied in addition to any log level defects to get net volumes from gross volumes. But this applies to the whole tree, not just a broken top.

It’s tempting to use the IsBrokenTop flag to single that the defect be assumed from a broken top. But the IsBrokenTop flag is currently used to trigger estimation of the missing heights for volume of non broken sections. It’s probably better to add a defect type field to store a user defined type of defect as I think you are saying. It wouldn’t trigger any special processing but could be used to export to FORSEE better. Assisi however will still apply the defect to the whole tree as it does now unless a broken top height is entered explicitly.

Rich

Originally posted by: ecohen


We need the "diameter" thin option for Organon. In the Organon diameter thin rule you set a lower dbh and a percent removal of that (e.g. 6” dbh thin 100%) and the highest diameter to be thinned (e.g. 13” dbh and 10%) and the program thins the other dbh classes by a percent that is from a linear interpolation between the min and the max.

2 Views
Guest
Mar 31

Originally posted by: Rich Howard


Hi Jeff,I'm working on this as we speak It should be ready in the next setup later this week.In the meantime attached is a screen shot of the latest Thinning Rule Editor. Rich

Originally posted by: ecohen


Trying to produce a Unit level butt diameter report wtih multiple stands. Can you confirm the steps of this process.

1 View
Guest
Mar 31

Originally posted by: Rich Howard


Hi Eric,

There are a few ways to create reports in Assisi.The main Reports menu creates reports for all selected stands across any units. For example, clicking Reports|Butt Diameter will create Butt Diameter reports for every stand: a potentially many page report depending on the number of stands selected. If you want a report for a single stand, open Inventory, select a stand then click Inventory's Butt Diameter report. If you're after a Unit level report where many stands are averaged and sampling errors combined, then also use the Inventory editor, but this time select a Unit rather than a Stand, then click Inventory's Butt Diameter report. Hope this helps!

Rich

Originally posted by: ecohen


Rich, Do you have handy the publication or equation for Walter, Hann 1986. If you do can you provide that to me thanks. Eric

1 View
Guest
Mar 31

Originally posted by: Rich Howard


Hi Eric.The best place to go is the ORGANON web site itself: http://www.cof.orst.edu/cof/fr/research/organon

You can also get just about any forest modeling paper that's been published at the USFS site here: http://www.treesearch.fs.fed.us/ I'm thinking you are interested in the taper equations for SMC or NWO regions. The ORGANON taper models were developed for the SWO region first and then calibrated for other regions later. Only the SWO results were published: http://www.cof.orst.edu/cof/fr/research/organon/pubs/FRL_RB56.pdf (Walters & Hann 1986). The coefficients for other regions have to be obtained from the ORGANON source code directly. Going to the code is the best way to ensure you have the latest models and coefficients because publications don't always occur. In this case, there actually was another taper re-calibration, with SWO published in 2011. I would assume the taper models and coefficients for NWO and SMC regions were updated as well, but would have to look at code to see.

Rich

Originally posted by: jbull


This afternoon we are starting our seasonal inventory cruising program. Radial growth measurement. I would like a 5 year growth measurement. You have a field in Assisi for this, but I don’t see one on the spreadsheet. Just add it before the first segment call?

Guest
Mar 31

Originally posted by: Rich Howard


Hi Loren,Yes. Just add a column to the Cruise Entry sheet. The Validation and Export VBA code will have to be changed, but that’s what’s supposed to happen: you change the Cruise Entry sheet to what you want and I or someone else change the Validation and Export code to match.So go ahead and add a radial growth field when you are back from the field, send me the sheet and I will update the code to match your changes.Rich

Originally posted by: jbull


Is is possible to change the BAF in the middle of a cruise?

Guest
Mar 31

Originally posted by: Rich Howard


Loren,If you change the BAF in the middle of a cruise, then you are changing the survey intensity in the middle of a cruise and plot to plot statistics will no longer be valid. I know Atterbury allows changing the BAF mid cruise and even a per tree basis, but if there is not consistent BAF usage between all plots, then plot to plot stats will not be valid. Volume and other measures can still be calculated, but the sample stats can't.Now, changing the BAF during a cruise is not the same as doing a Big BAF or Count Plot sample. Big BAF and Count Plots are examples of what is called Double Sampling. Double Sampling is statistically correct, and has been shown to be more efficient for a cruiser's time while in the field. Everyone should consider using it. The important difference from changing BAFs mid cruise is that in Double Sampling you are consistently using your BAFs throughout the cruise so plot to plot stat's are OK.Another way of putting it is changing BAFs change the likelihood of selecting trees to measure. If the likelihood is changing from plot to plot, then the trees on each plot are really not comparable to each other.So for Assisi, the real answer is unfortunately no. But, Double Sample IS a huge part of Assisi's features. You can set the measure and count BAFs as you need at the start of each cruise and they can be different for each cruise. Just be sure to not change them during a cruise. Ie, make the plots you want to compile together have the same sample intensities.Rich

Originally posted by: Rich Howard


Wanted to give a quick update on Assisi Cruiser, our upcoming data collector.


Our prototype in PowerApps is working OK, but PowerApps has too many restrictions like meant to be online and can only share apps with members of the same computer domain. So now I am also prototyping in Xamarin: the cross platform (iOS, Android & Windows) tool of choice for most serious developers. It's going well and I should have something for others to test soon.

Send me a note if you are interested in beta testing!

Rich


Guest
Mar 31

Originally posted by: Rich Howard


New Update. Assisi Cruiser is now being built in Xamarin. I hit too many roadblocks with PowerApps. Perhaps in the future PowerApps will be offline and programmable, but not now. So I switched to Xamarin and haven't looked back.The prototype is working great. It stores data in a mobile database which you email to the office with a couple clicks. At the office, you import from the database just as you do with all the other formats Assisi imports.The mobile app is robust, reliable and I will be able to expand without limits in the future to add in field compiling and more. I am expecting a release 1Q 2018 with a beta before that.Right now I am building an Export from Assisi Forest that fills Assisi Cruiser Cruise Designs, Calibrations, Markets and everything else one needs in the field. Selected Field Data is also exported.The plan is be able to fully design a cruise project in Assisi with plot locations, species settings survey design, then export to Assisi Cruiser and off you go!Rich

Originally posted by: Elijah Allensworth


I started using Assisi about six or seven months again and have mostly been leaning on Rich to answer questions. After suggesting to him that he should form a Q&A site, he let me know that one already existed! It doesn't seem like this community has been too active for the last year or so, but I'd like to bring it back. If anyone is still checking on this site, post a comment here so we can see who's around still. Looking forward to working with you all.


Elijah

1 View
Guest
Mar 31

Originally posted by: Rich Howard


😁

Originally posted by: Elijah Allensworth


Hey Rich,


I've noticed that the stand-level summary data (SummaryByStand) features both QMD and QMDS. Based on our conversation, it sounds like QMDS is what we would traditionally think of as stand-level quadratic mean diameter:


QMD = (BA / (TPA * 0.005454154)) ^ 0.5


where

BA = stand basal area in sqft/ac


Guest
Mar 31

Originally posted by: Rich Howard


Hi Eli,QMDS is from stand level BA and TPA. QMD is the average of plot QMDs.I was curious to see the difference when plot to plot variability is large. QMD is larger than QMDS in these cases. I think due to the plot avg version weighting each plot QMD equally while stand level in effect weights QMD by tree TPA.Stand 010302 in the sample database is a good example. 3 plots with ~.1" DBH trees. 3 plots with ~20" DBH trees. 1 empty plot. What is the best estimate of the "tree with average BA"? The plot average: 15" or the stand "avg": 4"? Does it matter?It's custom to use stand level BA and TPA for QMD so refer to QMDS. I am probably going to rename QMDS to QMD and plot level QMD to QMDP or remove it entirely.Rich

Originally posted by: silvasaunterra


Guest
Mar 31

Originally posted by: Rich Howard


It's likely that new species need to be added. Depending on the error wording, species may need adding to the Master list, Calibrations, Markets or Growth Model mappings.Missing Master SpeciesThe first place a species needs to be defined is in the "Master Species List". The list is accessed using the Calibration Editor as shown below. To add a species, make a new entry in the table by hand. Species, ID and Code are required and must be unique across all species. This is how each species is uniquely identified throughout Assisi.Once a species is defined in the Master list, it can be added to other places within Assisi.Missing Market SpeciesFor example, If the error says grade "G" can not be found for species "S", then grades for species S must be added to the grades for the Market you are processing with. This can be the case for grades or sorts or products. Note that if your sorts or products use grades or sorts as min criteria, then those grades or sorts must be defined as well. IE, even though you haven't called a certain grade or sort in the field, the products may need to refer to them anyway.So for Market errors, go through and add every combination of species and grade or sort or product you might use now or in the future. There are SQL queries int he Query Tool that will copy existing grades to new species. Give it a try. Edit the species and market values first.Missing Calibration SpeciesIf a species is missing in a calibration, you will see and error at compilation that species "S" is not found in calibration "C". This is easier to fix than adding species to markets: just copy and paste an existing species in the Calibration Editor. Choose a species that is closest to the new species in terms of growth, taper and other models. OK, not so easy after all, but its easy to add a new species from an existing species as a starting point.Here I am selecting Bitter Cherry as my existing species:I do ctrl C then ctrl V and a copy of Bitter Cherry is added to the ORGANON calibration. The species name defaults to the 1st species not already in ORGANON: Acadia in this case:Lastly, I choose Black Cherry as the new Species name:This adds a new species to a Calibration, but it will be modeled exactly like the species it was copied from. However, now you can change model settings as needed. What those model settings should be is a combination of what is available which is a mini research project of its own.Missing Growth Model SpeciesAnother place that missing species errors pop up is when they are in a calibration, but don't have a growth model mapping to a species a growth model understands. Growth model mappings are set in the Growth tab of a calibration.Below is the Growth tab for the ORGANON calibration. All growth models have different sets of default species they can process. Species other than these must be mapped to the growth model's defaults. In Assisi, this is done by adding a "SpeciesMapping" line to the list as seen below:The mapping line added must map to species through species code and the source species must be one that ORGANON inherently understands.SummaryThere are a number of places new species must be added and the places depend on what models and procedures in Assisi are being used. But, the errors that show up for missing species should point the way to where they need to be added.Rich

Originally posted by: silvasaunterra


Guest
Mar 31

Originally posted by: Rich Howard


It sounds like you are calling logs in the field on softwood, but only occasionally on hardwoods and what you want is to get board volume from only the logs called in the field? If that's correct, then I think the answer is to use Assisi's Market grading process to map field called logs to board, but anything other logs Assisi creates during compilation to cubic.This can be done by calling both a Grade and a Quality on logs in the field. Call the Grade as usual, but also assign a Quality of say "Sawlog" as well. Then in the Assisi Market, set Min Quality to "Sawlog" for all grades you are mapping to board volume. For grades being mapped to cubic, such as Pulp, leave the Min Quality setting blank.When Assisi compiles your cruise, the "Sawlog" Quality requirement will restrict those grades to only the logs you called in the field. Other logs that Assisi calculated and grades during compile will not have the "Sawlog" quality and therefore wont be mapped to "Sawlog" grades.

For example, here I've selected "S" Min Quality on DF grades in the Market Editor. "S" is the code for the "Sawlog" Quality

Rich

Originally posted by: Elijah Allensworth


Hey Rich,


I'm looking to store seedlot codes in our Assisi inventory and was wondering if an appropriate field existed for that? The HistoryPlanting.Source seems promising, but I've only seen it via SSMS and not within the GUI editor.


Thanks!


Elijah

Guest
Mar 31

Originally posted by: Rich Howard


Hi Eli,Yes, the History table is where details about planting, thinning or other action are recorded. Assisi will simulate the details as stands are grown forward.You can get to Stand History through the Field Data Editor. Click a stand, then click the History view:Once a History record's Action is set, a little "+" box will show. click that and a table shows up where you can enter the planting stock details.

Originally posted by: alannahpcross


Hello,


I noticed that in the Navigator window for Field Data that certain stands are highlighted gray. I am unable to "select" (blue highlight) any of these gray highlighted stands. I am only able to "focus" (yellow highlight) on the gray highlighted stands. I can resolve this issue by closing out of the program.


What is the function/purpose of the gray selection? How do I toggle this function on/off?


Many thanks,

Guest
Mar 31

Originally posted by: Rich Howard


Hi Alannah,The greying of stands is to show the stands are not “locked” by you yet. Locking is a feature of the Enterprise version of Assisi, but sometimes when I edit data using an Enterprise version, I forget to unlock the stands when I am done. Sorry, I forgot to unlock them when I was done.The way it works is this: If stand backgrounds are grey, they are not locked by anyone. Lock them by right clicking with ctrl key down. To lock all stands, select all units, then ctrl right click to lock.If stands are grey and dimmed, then they are already locked by someone else. Since you run in Desktop and not Enterprise mode, you should unlock all stands using the "Reset Locks" query in the Query Editor. This will unlock all stands so that you can lock them using ctrl right lick.Note that Plans and Operations work the same way. work the same way: they lock and unlock.Hope this helps!Rich

Originally posted by: joshjulien


When creating a new database within Assisi, the code behind throws an unhandled exception.


System.Exception: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.


The database is still created but not all of the data is removed.


Thoughts?

Guest
Mar 31

Originally posted by: Rich Howard


MaxLocksPerFile is a registry entry that limits the number of file system locks on the Access database file. It has been set at 9500 since its debut 2 decades ago but today it needs and can be set much higher. I routinely set it at 100,000 by running reg edit and searching for "MaxLocksPerFile". The Assisi setup wont do this for you because security and best practice is to not fool with other registry entries than the ones the setup creates.So, just run regedit, search for "MaxLocksPerFile" and change its value to 100,000. Regedit will show values in hex so us 100,000 in hex. Continue to search and change until all "MaxLocksPerFile" are set to 100,000. There can be many, like over 5 or so.

Originally posted by: joshjulien


Tried to run Assisi while offline and it won't load. Thrown exception about the website and the dreaded NullReferenceException.


Does Assisi really require internet Access to run?

Guest
Mar 31

Originally posted by: joshjulien


I didn't get any handled error. it was the standard VS unhandled window. If I can reproduce the error I'll send you the log.Thanks

bottom of page