Update cookies preferences

Introduction to Computing Applications in Forestry and Natural Resource Management [Hardback]

  • Format: Hardback, 398 pages, height x width: 234x156 mm, weight: 814 g, 40 Tables, black and white; 28 Illustrations, color; 144 Illustrations, black and white
  • Pub. Date: 01-Sep-2017
  • Publisher: CRC Press
  • ISBN-10: 1138626309
  • ISBN-13: 9781138626300
Other books in subject:
  • Hardback
  • Price: 164,80 €
  • This book is not in stock. Book will arrive in about 2-4 weeks. Please allow another 2 weeks for shipping outside Estonia.
  • Quantity:
  • Add to basket
  • Delivery time 4-6 weeks
  • Add to Wishlist
  • Format: Hardback, 398 pages, height x width: 234x156 mm, weight: 814 g, 40 Tables, black and white; 28 Illustrations, color; 144 Illustrations, black and white
  • Pub. Date: 01-Sep-2017
  • Publisher: CRC Press
  • ISBN-10: 1138626309
  • ISBN-13: 9781138626300
Other books in subject:

Due to the complexity of operational forestry problems, computing applications are becoming pervasive in all aspects of forest and natural resource management. This book provides a comprehensive introduction to computers and their applications in forest and natural resource management and is designed for both undergraduate and graduate students in forestry and natural resources. It introduces state-of-the-art applications for several of the most important computer technologies in terms of data acquisition, data manipulation, basic programming techniques, and other related computer and Internet concepts and applications. This book consists of six parts and 19 chapters.

Reviews

"Dr. Jingxin Wang has authored an excellent textbook to introduce students in the natural resource management to the foundations of computing and common computing applications. It takes a student beyond the simplistic use of spreadsheets to help them master more complex analysis and take advantage of the power of relational databases including search protocols. I expect this book will find use in many programs to expand students use of computing to help solve natural resource management problems." Dale Greene, University of Georgia, Athens, Georgia, USA

"This must-read book fills an important gap in the toolbox of the modern forester, and is full of important information for anyone who wants to make proficient use of the large computing potential hidden within most general-purpose software. Prof. Wang is clearly most competent with the subject and offers an effective guide through the complexity of computing. A clear explanation of the general theory is supported by practical examples with forestry subjects, in a logical progression that leads to full apprehension and proficiency. This is go-to-guide that will occupy a prominent and often-visited spot on our bookshelves!" Raffaele Spinelli, CNR IVALSA, Florence, Italy

"Jingxin Wang has compiled a textbook that covers the use and applications of computers in Forestry that will be extremely helpful to the reader. He starts from the beginning and informs the reader where and how computer applications can be applied to increase efficiencies for a user. He has summarized the steps needed to assist the reader with program development that will ensure the user is recording, storing and using any data in the manner they require. This book will be a valuable resource for all in the forest products industry, including educators, managers and field personnel, who manipulate data." Tom Gallagher, Auburn University, Auburn, Alabama, USA

"Introduction to Com

Preface xvii
Author xix
Section I: Foundations
1 Fundamental Computing Concepts
3(10)
1.1 Computer Operating Systems
3(1)
1.2 Brief History of Operating Systems
4(1)
1.3 Types of Operating Systems
5(1)
1.4 Major Operating System Responsibilities
6(2)
1.4.1 User Interface
7(1)
1.4.2 Device Management
7(1)
1.4.3 Time Management
7(1)
1.4.4 Memory Management
7(1)
1.4.5 File Management
8(1)
1.5 Computer Resources and File Systems
8(3)
1.5.1 Computer Resources
8(1)
1.5.2 File Systems
8(7)
1.5.2.1 File Attributes or Properties
9(1)
1.5.2.2 File Operations
9(1)
1.5.2.3 File Types and Naming
10(1)
1.5.2.4 Directory Structure
10(1)
Class Exercises
11(1)
References
11(2)
2 Programming Languages and Software Engineering
13(14)
2.1 Programming Languages
13(2)
2.2 Object-Oriented Programming
15(2)
2.2.1 C and C++
16(1)
2.2.2 Visual Basic .NET
16(1)
2.3 Software Engineering
17(3)
2.4 Example of Forest Harvesting Simulator Design
20(3)
2.4.1 System Design
20(1)
2.4.2 Functional Requirements
21(6)
2.4.2.1 Specification Document
22(1)
Class Exercises
23(1)
References
23(4)
Section II: Data Manipulation and Analysis
3 Elementary Data Manipulation Using Excel
27(26)
3.1 Excel Formulas
27(5)
3.1.1 Operators in Formulas
28(1)
3.1.2 Entering Formulas
28(1)
3.1.3 Referencing Cells Outside the Worksheet
29(1)
3.1.4 Relative versus Absolute References
29(3)
3.1.4.1 Relative Reference
30(1)
3.1.4.2 Absolute Reference
31(1)
3.2 Excel Functions
32(2)
3.2.1 Function Arguments
33(1)
3.2.2 Entering Functions
33(1)
3.3 Major Excel Functions
34(7)
3.3.1 Mathematical and Trigonometric Functions
35(2)
3.3.1.1 INT
35(1)
3.3.1.2 RAND
35(1)
3.3.1.3 ROUND
36(1)
3.3.1.4 SIN or COS
36(1)
3.3.1.5 SQRT
36(1)
3.3.1.6 SUM
37(1)
3.3.1.7 SUMIF
37(1)
3.3.2 Statistical Functions
37(2)
3.3.2.1 AVERAGE, MEDIAN, and MODE
37(1)
3.3.2.2 COUNT
38(1)
3.3.2.3 COUNTIF
38(1)
3.3.2.4 MAX and MIN
38(1)
3.3.2.5 STDEV
38(1)
3.3.3 Text Functions
39(1)
3.3.3.1 LEFT and RIGHT
39(1)
3.3.3.2 LEN
39(1)
3.3.3.3 MID
39(1)
3.3.3.4 REPLACE and SUBSTITUTE
39(1)
3.3.3.5 UPPER, LOWER, and PROPER
40(1)
3.3.3.6 FIND
40(1)
3.3.4 Logical Functions
40(2)
3.3.4.1 IF
40(1)
3.4 Build Your Own Functions
41(1)
3.5 Charts
42(7)
3.5.1 Excel Chart Example
42(3)
3.5.2 Combination Chart
45(1)
3.5.3 Gantt Chart
46(3)
Class Exercises
49(3)
References
52(1)
4 Statistical Analysis and Mathematical Programming Using Excel
53(30)
4.1 Data Analysis with Analysis ToolPak
53(9)
4.1.1 Correlation
53(1)
4.1.2 Regression
54(4)
4.1.3 t-Test
58(4)
4.2 Mathematical Programming in Forest Management
62(6)
4.2.1 Linear Programming
62(1)
4.2.2 Network Analysis
63(1)
4.2.3 Multi-Objective Programming
64(1)
4.2.4 Integer Programming
64(1)
4.2.5 Dynamic Programming
65(3)
4.3 Linear Programming Formulation
68(1)
4.4 Solve Mathematical Models in Forest Management Using Excel Solver
69(7)
4.4.1 Example of Optimization Problem
69(4)
4.4.2 Activate Excel Solver
73(1)
4.4.3 Use Excel Solver
73(3)
Class Exercises
76(5)
References
81(2)
5 Visual Basic for Applications in Microsoft Excel
83(16)
5.1 Introduction to VBA
83(4)
5.1.1 Visual Basic Editor in Excel
83(1)
5.1.2 Writing Code in VB Editor
84(1)
5.1.3 Running Events within Excel
85(2)
5.2 VBA Fundamentals
87(1)
5.2.1 Variables and Data Types
87(1)
5.2.2 Modules
87(1)
5.2.3 Variable Scope
88(1)
5.3 Harvesting Machine Rate Spreadsheet Program
88(5)
5.3.1 Machine Rate
88(1)
5.3.2 Example of Machine Rate Program with VBA
89(10)
5.3.2.1 Design Interface
90(1)
5.3.2.2 Write Code
91(2)
5.4 VBA User Forms and Controls
93(3)
Class Exercises
96(1)
References
96(3)
Section III: Database Management
6 Database Concepts and the Entity-Relationship Model
99(10)
6.1 Fundamental Database Concepts
99(2)
6.1.1 Database Management System
99(1)
6.1.2 Database
99(1)
6.1.3 Table, Record, and Field
100(1)
6.1.4 MS Access Database
100(1)
6.2 Relational Databases and the Entity-Relationship Model
101(4)
6.2.1 Entity
102(1)
6.2.2 Keys
102(1)
6.2.3 Relationships
102(1)
6.2.4 Types of Relationships
103(2)
6.3 ER Model Examples in Forest Operations
105(3)
6.3.1 ER Model Notations
105(1)
6.3.2 ER Model for Timber Cruising
105(1)
6.3.3 ER Model for Time Study of Timber Harvesting
106(2)
Class Exercises
108(1)
References
108(1)
7 Introduction to MS Access
109(16)
7.1 MS Access Usability and Functionality
109(2)
7.1.1 MS Access Usability
109(1)
7.1.2 Major MS Access Functionality
110(1)
7.1.3 Why Use More than One Table?
110(1)
7.2 Access Tables and Queries
111(5)
7.2.1 Access Tables
111(1)
7.2.2 Relationships between Tables
112(1)
7.2.3 Access Queries
113(3)
7.3 Access Forms and Reports
116(4)
7.3.1 Access Forms
116(1)
7.3.2 Access Reports
117(3)
Class Exercises
120(3)
References
123(2)
8 Structured Query Language and Access Query Examples
125(16)
8.1 Structured Query Language
125(2)
8.1.1 SQL Statements and Clauses
125(1)
8.1.2 SQL Syntax
125(2)
8.2 Basic SQL Examples
127(5)
8.2.1 Statements and Clauses
127(3)
8.2.2 SQL Functions
130(2)
8.3 MS Access Queries
132(4)
Class Exercises
136(1)
References
137(4)
Section IV: Handheld Devices
9 Handheld Computers and Windows Mobile
141(12)
9.1 Handheld Terms and Features
141(2)
9.2 Handheld PCs and Windows Mobile
143(6)
9.2.1 Hewlett-Packard Jornada Series
143(1)
9.2.2 Zebra Workabout Handheld Field PC
143(2)
9.2.3 Allegro Field PC
145(1)
9.2.4 Archer Field PC
146(1)
9.2.5 NAUTIZ X7 Field PC
146(2)
9.2.6 Trimble GeoExplorer 3000 Series Handhelds
148(1)
9.3 Mobile Operating Systems and Data Communications
149(1)
9.3.1 Mobile Operating Systems
149(1)
9.3.2 Data Communications between HPCs and PCs
150(1)
9.4 Data Storage and Program Execution
150(2)
9.4.1 Random Access Memory
151(1)
9.4.2 External PC, CF, and SD Cards
151(1)
9.4.3 Program Execution
151(1)
Class Exercises
152(1)
References
152(1)
10 Handheld PC Applications: An Integrated Computer-Based Cruising System
153(12)
10.1 Introduction
153(2)
10.2 System Structure
155(2)
10.3 System Implementation
157(4)
10.3.1 Handheld System
157(2)
10.3.2 Data Transfer
159(1)
10.3.3 Data Analysis
159(2)
Class Exercises
161(1)
References
162(3)
11 Introduction to Geospatial Technology Applications in Forest Management
165(28)
11.1 GPS Applications
165(3)
11.1.1 What Is GPS?
165(1)
11.1.2 GPS in Forestry and Natural Resource Management
166(2)
11.1.2.1 Data Collection
166(1)
11.1.2.2 Data Transfer
167(1)
11.2 GIS Applications
168(9)
11.2.1 What Is GIS?
168(2)
11.2.2 GIS in Forestry and Natural Resource Management
170(5)
11.2.3 GIS Software and Data
175(2)
11.3 Remote Sensing Applications
177(1)
11.3.1 What Is Remote Sensing?
177(1)
11.3.2 RS in Forestry and Natural Resource Management
177(1)
11.4 GIS Mapping and Analysis Examples
178(7)
11.4.1 Identifying and Mapping Vegetation Phenology
178(4)
11.4.1.1 Data Preparation
179(1)
11.4.1.2 Identifying Phenology
179(3)
11.4.1.3 Mapping the Phenology Using ArcGIS
182(1)
11.4.2 Mapping and Analyzing Winter CO2 Efflux in a Conifer Forest Area of North America
182(11)
11.4.2.1 Data Preparation
182(1)
11.4.2.2 Data Analysis
183(1)
11.4.2.3 Mapping CO2 Efflux Using ArcGIS
184(1)
Class Exercises
185(3)
References
188(5)
Section V: Visual Basic .NET Programming
12 Introduction to Visual Basic .NET Programming
193(12)
12.1 What Is Visual Basic?
193(2)
12.1.1 Visual Basic and VB.NET Concepts
194(1)
12.1.1.1 Windows, Events, and Messages
194(1)
12.1.1.2 Procedural Programming
194(1)
12.1.1.3 Event-Driven Programming
194(1)
12.1.1.4 Object-Oriented Programming
195(1)
12.1.2 VB Integrated Development Environment
195(1)
12.2 VB.NET Programming Examples
195(8)
12.2.1 First Application
195(1)
12.2.2 Example for Calculating Basal Area of Trees
196(3)
12.2.2.1 Creating the Interface and Setting Properties
197(1)
12.2.2.2 Writing Code
198(1)
12.2.2.3 Running the Application
198(1)
12.2.3 Database Connection and Data Display Application
199(6)
12.2.3.1 Creating the Interface
199(1)
12.2.3.2 Setting Properties
200(1)
12.2.3.3 Writing Code
200(3)
12.2.3.4 Running the Application
203(1)
Class Exercises
203(1)
References
203(2)
13 VB.NET Controls, Project, and Menu Design
205(20)
13.1 Types of Controls
205(1)
13.2 Using Timer, Option Button, Groupbox, and Checkbox Controls
205(6)
13.2.1 Creating the Interface and Setting Properties
207(1)
13.2.2 Writing Code
208(2)
13.2.3 Running the Application
210(1)
13.3 Using Drive, Dir, File, Combo, List, Frame Controls
211(4)
13.3.1 Creating the Interface and Setting Properties
211(2)
13.3.2 Writing Code
213(1)
13.3.3 Running the Application
214(1)
13.4 Working with a Project
215(1)
13.4.1 Form Class
216(1)
13.4.2 User-Defined Class
216(1)
13.4.3 Standard Modules
216(1)
13.4.4 Standard Controls
216(1)
13.5 Menu Design of VB Project
216(7)
Class Exercises
223(1)
Reference
223(2)
14 VB.NET Programming Fundamentals
225(30)
14.1 Variables and Constants
225(1)
14.1.1 Declaring Variables
225(1)
14.1.2 Scope of Variables
225(1)
14.1.3 Private versus Public
225(1)
14.1.4 Static versus Dim
226(1)
14.1.5 Constants
226(1)
14.2 Data Types
226(2)
14.3 Arrays
228(1)
14.3.1 Declaring Arrays
228(1)
14.3.2 Multidimensional Arrays
228(1)
14.4 Classes and Procedures
228(6)
14.4.1 Class
228(3)
14.4.2 Sub Procedures
231(1)
14.4.2.1 Event Procedures
231(1)
14.4.2.2 General Procedures
232(1)
14.4.3 Function Procedures
232(1)
14.4.4 Sample Exercise
232(2)
14.4.4.1 Passing by Value versus Passing by Reference
234(1)
14.5 Control Structures
234(2)
14.5.1 Decision Structures
235(1)
14.5.2 Loop Structures
235(1)
14.6 Input and Output Files
236(2)
14.6.1 Direct File Access
236(1)
14.6.2 File Access Types
237(1)
14.6.3 Opening Files for Sequential Access
237(1)
14.7 Example
238(4)
14.8 Data Access
242(6)
14.9 Data Manipulation
248(5)
14.9.1 Example
249(4)
Class Exercises
253(1)
References
254(1)
15 Programming Application Examples in Forest Resource Management
255(52)
15.1 Forest Harvesting Simulator
255(8)
15.1.1 Forest Stand Generation
256(1)
15.1.1.1 Random Pattern
256(1)
15.1.1.2 Uniform Pattern
256(1)
15.1.1.3 Clustered Pattern
256(1)
15.1.2 Felling Operations
257(1)
15.1.2.1 Chainsaw Felling
257(1)
15.1.2.2 Feller-Buncher Felling
257(1)
15.1.2.3 Harvester Felling
257(1)
15.1.3 Extraction Simulation
258(3)
15.1.3.1 Extraction Patterns
258(1)
15.1.3.2 Traffic Intensity
259(2)
15.1.4 Simulation Example
261(2)
15.2 Timber Cruising and Inventory
263(9)
15.2.1 Manipulate Field Cruising Data
263(1)
15.2.2 Import Data
264(1)
15.2.3 Load Data
264(1)
15.2.4 Cruise Design
265(2)
15.2.5 Report
267(1)
15.2.6 Programming
268(4)
15.3 VBA for Harvesting System Production and Cost Analysis
272(6)
15.3.1 Excel and VBA
273(1)
15.3.2 System Design and Implementation
273(3)
15.3.3 Application Example
276(2)
15.4 3D Log Bucking Optimization
278(5)
15.4.1 System Design
278(3)
15.4.1.1 System Structure
278(1)
15.4.1.2 Data Manipulation and Storage
278(1)
15.4.1.3 3D Stem Modeling
278(2)
15.4.1.4 Optimal Bucking Algorithm
280(1)
15.4.2 Bucking System Implementation
281(2)
15.5 3D Lumber Edging and Trimming System
283(6)
15.5.1 Data Manipulation and Storage
284(1)
15.5.2 3D Lumber Modeling
284(1)
15.5.3 Lumber Grading
285(1)
15.5.4 Optimal Edging and Trimming Algorithm
285(1)
15.5.5 Optimal Edging and Trimming System Implementation
286(3)
15.6 3D Log Processing Optimization System
289(6)
15.6.1 System Components and Data Management
289(2)
15.6.1.1 System Components
289(2)
15.6.1.2 System Data Management
291(1)
15.6.2 System Modeling and Algorithms
291(1)
15.6.2.1 3D Log and Internal Defect Modeling
291(1)
15.6.2.2 Determining Opening Face
292(1)
15.6.3 Primary Log Sawing Simulation
292(3)
15.6.3.1 Heuristic Algorithm
292(1)
15.6.3.2 Dynamic Programming Algorithm
293(2)
15.6.3.3 Example
295(1)
15.7 Forest and Biomass Harvest Scheduling and Optimization
295(8)
15.7.1 Forest Inventory Data
295(1)
15.7.2 Forest Stand Growth Simulation
295(1)
15.7.3 Harvest Scheduling Model Development
296(2)
15.7.4 Case Study
298(5)
Class Exercises
303(1)
References
303(4)
16 Programming for Mobile Devices and Applications in lime Study of limber Harvesting Machines
307(22)
16.1 Programming for Mobile Devices
307(3)
16.1.1 iPhone/iPad App Programming
307(1)
16.1.1.1 Programming Languages
307(1)
16.1.1.2 iPhone Development Frameworks
308(1)
16.1.2 Android Programming
308(1)
16.1.2.1 Android Application Development Framework
309(1)
16.1.3 Windows Mobile
309(1)
16.1.3.1 .NET Compact Framework
309(1)
16.2 Visual Basic .NET for Windows Mobile
310(9)
16.2.1 Windows Mobile SDK
310(1)
16.2.2 New Project Types
310(1)
16.2.3 Features in VB.NET for Windows Mobile
311(1)
16.2.4 Programming Examples of VB.NET for Windows Mobile
311(8)
16.3 VB.NET for Mobile Device Application in Time Study of Timber Harvesting
319(6)
16.3.1 System Structure
319(3)
16.3.2 System Implementation
322(2)
16.3.2.1 Design Module
322(1)
16.3.2.2 Collect Module
322(2)
16.3.3 Transfer Data
324(1)
Class Exercises
325(1)
References
325(4)
Section VI: Web-Based Applications
17 Introduction to HTML
329(20)
17.1 Terms and HTML Files
329(1)
17.2 HTML Structure
330(2)
17.3 Applications of HTML Tags
332(15)
17.3.1 HTML
333(1)
17.3.2 Head
333(1)
17.3.3 Title
333(1)
17.3.4 Body
333(1)
17.3.5 Headings
333(1)
17.3.6 Paragraphs
334(2)
17.3.7 Lists
336(1)
17.3.8 Forced Line Breaks
337(1)
17.3.9 Tables and Images
338(3)
17.3.10 Forms
341(6)
Class Exercises
347(1)
Reference
347(2)
18 Introduction to ASP.NET
349(10)
18.1 ASP.NET Programming
349(4)
18.2 Basic ASP.NET Techniques
353(5)
18.2.1 Request and Response
353(3)
18.2.2 QueryString
356(2)
Class Exercises
358(1)
References
358(1)
19 ASP/ASP.NET Applications
359(14)
19.1 Web-Based Data Entry and Retrieval System for Forest Health Protection
359(1)
19.2 Online Timber Cruising System
360(5)
19.2.1 Main Menu
363(1)
19.2.2 Add/Edit Data
363(2)
19.2.3 Reports
365(1)
19.3 Web-Based DSS for Analyzing Biomass and Timber Harvesting Costs and Productivity
365(7)
19.3.1 System Design
367(1)
19.3.2 Main Page
367(2)
19.3.2.1 General Information
367(1)
19.3.2.2 Machines
368(1)
19.3.2.3 Machine Productivity
368(1)
19.3.2.4 Machine Cost
368(1)
19.3.2.5 System
369(1)
19.3.3 Machine Rate Program Page and Summary Page
369(3)
19.3.3.1 Implementation
370(2)
19.3.3.2 Applications
372(1)
Class Exercises
372(1)
References
372(1)
Index 373
Dr. Jingxin Wang is Professor and Associate Director for Research, and the Director of Renewable Materials and Bioenergy Research Center in the Division of Forestry and Natural Resources at West Virginia University, USA. He received his degrees in Forest/Mechanical Engineering from Northeast Forestry University, China. He received a M.S. in Computer Science from West Virginia University, and a Ph.D. in Forest Resource Management from the University of Georgia, USA. His research interests include biomass energy and bioproducts, forest carbon sequestration and optimization, computer simulation and system modeling, and forest ecosystem management and climate change. Dr. Wang has authored or coauthored 150 refereed papers, and 12 books or book chapters. Currently, he is a leading PI for seven USDA and USDOE biomass energy and bioproducts projects. He has served as an editorial board member and associate editor for four international journals and adjunct professor for four Chinese universities/institutions. He is an active member in six international professional societies.