OZRI_presentation_Nik&Rod
-
Upload
nicholas-henry -
Category
Documents
-
view
63 -
download
0
Transcript of OZRI_presentation_Nik&Rod
![Page 1: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/1.jpg)
1
Department of Environment & Climate Change NSW
Spatial Capture and Attribution of NaturalResource ManagementInvestment
Nik Henry and Rod Waski
![Page 2: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/2.jpg)
2
Speaker Background
Nik Henry Mapping and Surveying On ground activities, Land Use and Land
degradationRod Waski Programming and Design Spatial tool and database development
![Page 3: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/3.jpg)
3
Topics for this Presentation
Organisational Perspective
System Architecture
Live Demonstration
Questions and Answers
![Page 4: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/4.jpg)
4
Organisational Context Manage natural resource investment Develop and manage natural resource
datasets Use these spatial datasets for Planning,
Reporting, Monitoring and Evaluation Currently maintain these important datasets
- Land Use- Salinity Outbreaks- Groundwater Bores- Soil profiles and Soil Landscapes- Land Capability
![Page 5: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/5.jpg)
5
Examples of Natural Resource Investment
Establishment of localised native vegetation Riparian bed stabilisation and bank protection
works Fencing off areas of significant vegetation Location of troughs and tanks for water
supply infrastructure Removal and control of noxious weeds Trapping and control of feral animals
![Page 6: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/6.jpg)
6
Vegetation Establishment with Grazing Activities
![Page 7: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/7.jpg)
7
Native Vegetation Corridor Establishment
![Page 8: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/8.jpg)
8
![Page 9: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/9.jpg)
9
Landholder Cropping Management
![Page 10: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/10.jpg)
10
![Page 11: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/11.jpg)
11
Landholder Saline Site Management Activities
![Page 12: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/12.jpg)
12
Landholder Gazing Management Activities
![Page 13: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/13.jpg)
13
![Page 14: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/14.jpg)
14
Community Involvement with Monitoring
![Page 15: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/15.jpg)
15
Community Involvement with On-ground Activities
![Page 16: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/16.jpg)
16
Spatial Recording of Investment
Spatial record of on-ground works Detailed information about works Map products Data for Compliance processes Project monitoring Data for Long term planning Input to a range of models
![Page 17: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/17.jpg)
17
The Land Management Database
Primary user is the NSW Catchment Management Authority’s
A customisation of ArcMap Provides a consistent standardised
process Features compiled automatically on a
centralised database. Provides instant reporting (using Crystal
Reports) against a range of criteria Links to other natural resource datasets
![Page 18: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/18.jpg)
18
Background Developed over six (6) years The organisation had a significant Arcview
3.3 user base. Recently implemented Oracle spatials and
was beginning to use ArcGIS 8.1 New to ArcObjects development and how
it interacts with our new spatial infrastructure
![Page 19: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/19.jpg)
19
Background - continued Many workshops and data modelling
sessions. Discussions with our DBA’s who were
implementing our Oracle Spatial systems. Preliminary programming was undertaken
in 2003 however the project stalled in 2004 when Amanda left the organisation.
In 2005 further development occurred and it was implemented on ArcGIS 9.0
![Page 20: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/20.jpg)
20
Implementation The programming to export to the Central
database was completed in 2005. Went through our change control
procedure to the production database. We could now easily demonstrate the
benefits of a centralised database for corporate reporting.
Began marketing the LMD to the CMAs and within our organisation.
![Page 21: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/21.jpg)
21
Development Environment
Microsoft Visual Basic 6. Active-X dynamic link library (dll). ESRI ArcObjects libraries. Microsoft Jet Engine libraries High speed Wide Area network
![Page 22: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/22.jpg)
22
EDB
Users operate independently and store data centrally
![Page 23: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/23.jpg)
23
Database Environment Modelled and designed using Visio. Front-end and back-end solution “one-to-many-to-many” relational model. Points, lines or areas stored locally Centralised (EDB) database uses
Oracle spatial 10 with SDE 9.X elements.
![Page 24: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/24.jpg)
24
Database Key Management
Database are checked out with each LMD database
Keys are unique across the WAN
Upload of spatial data using Append function
Spatial integrity maintained locally
![Page 25: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/25.jpg)
25
LMD Feature Classes on EDB
![Page 26: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/26.jpg)
26
Spatial Feature Description Rels
One unique number (LMID) per spatial feature
To many sub-
typesTo many activities
![Page 27: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/27.jpg)
27
![Page 28: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/28.jpg)
28
Application Updates
The system Automatically updates itself across the WAN from the EDB.
One xml file on EDB controls the system versioning and updating functions.
All LMD Geodatabases link to lookup tables stored in an external reference database, no domains.
Allows easy update and management of the reference data for description or attribute list.
![Page 29: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/29.jpg)
29
Updating Functions
![Page 30: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/30.jpg)
30
Features of the LMD Tool
Standardised attribution list (1859) Customisation for all users, limit available
attributions. Detailed attribution of area, line and point
spatial features Up-load of attributed feature data Instant reporting once data up-loaded
![Page 31: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/31.jpg)
31
Simplified General ProcessStart ArcGIS
1.0 CreateDatabase
4.0 ExportFeatures
3.0 AttributeFeatures2.0 Digitise
Features
EDBP
Close ArcGISlmd_template
![Page 32: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/32.jpg)
32
Database Setup and Links
Contract or agreement numbers
![Page 33: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/33.jpg)
33
Spatial Feature Attribution
Selected area, line and point features are tagged with a unique number (LMID)
Three stage hierarchical display of attribute description.
![Page 34: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/34.jpg)
34
Spatial Feature Assessments
![Page 35: OZRI_presentation_Nik&Rod](https://reader035.fdocuments.co/reader035/viewer/2022070520/58f1a5d51a28ab7c6e8b45af/html5/thumbnails/35.jpg)
35
Reporting Enabled
Financial numbers - WBS element