Go to content Go to navigation Go to search

Data Models - Computerised Tree Inventory System

Tuesday November 20 2007 at 22:27

ESRI hosts a set of community created, domain-specific, data models on its website. As I understand the licensing of these data models, they are effectively free and open source. I have converted some of these data models into a form that they can be used natively in any of the current spatially enables databases eg Oracle XE, SQL Server 2008 “Katmai”, MySQL and PostGIS.

However to start off my hosting of free data models I converted a data model that I created over 20 years ago for the management of urban trees (see The Urban Forest Project ). This data model was a part of my final year project in computing science at the University of Tasmania. The model and application (written in Knowledge Man) was used by Hobart City Council up until only a few years ago.

I recently converted this data model into a format that Oracle Spatial could use and also have tested it in SQL Server 2008; the MySQL and PostGIS versions have not been tested (the SQL is generated from the free data modelling tool Blueprint .) This model is complete and could be used as the basis for a computerised tree inventory system for councils both in Australia and overseas.

Computerised Tree Inventory System – Data Model
(Blue entities have a spatial description; Green entities only contains text attributes)

Computerised Tree Inventory System Database

Creative Commons License

post this at del.icio.uspost this at Diggpost this at Technoratipost this at Redditpost this at Farkpost this at Yahoo! my webpost this at Windows Livepost this at Google Bookmarkspost this to Twitter

Comment [4]

This model is complete and could be used as the basis for a computerised tree inventory system for councils both in Australia and overseas.

— Anonymous · 29 February 2012, 20:25 · #

I have numerous tools and accomplishing legitimate article of these worked admirably and vitality keeps on being seeing about this web blog. Go for this best essay writing service to having a wonderful assistant in writing and even you can get the guidelines too.

— Chrisatorain · 25 February 2017, 21:45 · #

<a href=“http://www.spatialdbadvisor.com”>Remember</a>

— Remember · 11 March 2017, 17:34 · #

What an awesome blog I have ever observed. I didn’t locate this sort of data till now. Much obliged to you such a great amount for sharing this data. You have magnificently made this article and Assignment Help it has astonishing substance and is deliberately framed and even I am restored by your made style also.

— Addy Addison · 11 March 2017, 17:37 · #