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 [13]

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 · #

we recognized non-stochastic courses of action of platelet-discharged BRMs in platelet segments that prompted intense transfusion responses (ATRs).<a href=“http://www.groovyessays.com/write-my-essay/”> Write My Essay for me</a> These information give formal clinical proof that platelets produce discharge profiles under both sterile initiation and neurotic conditions.

— Write My Essay for me · 27 March 2017, 22:00 · #

The exceptionally imaginative and appealing your post. It’s useful and applicable always, Dissertation editing service I read your everything the substance.

— PeterStephen · 28 March 2017, 17:14 · #

nicely written and it also contains many useful facts i enjoyed your way of writing this post thanks you have made it very easy for me http://www.assignmentland.co.uk/

— judee · 30 March 2017, 22:01 · #

<a href=“http://www.vidwonders.com/”>video production company</a> [url=http://www.vidwonders.com/]video production company[/url]

— asd · 3 April 2017, 19:29 · #

The data models should be tested before the implementation phase otherwise all the model design would be broken up and some of them are trying to be best one as they are tested carefully and these designs are Write My Essay For Me much complicated than the other ones and this time they are looking forward for the new strategies which can be applicable for it and some of them are trying their best to remodel this thing in correct way.

— Zoe Banks · 19 April 2017, 16:41 · #

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 can you write my university assignment for me? 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.

— Jerry mckneil · 19 April 2017, 21:30 · #

ESRI has an arrangement of group made, area particular, information models on its site. As I comprehend the permitting of these information models, they are viably free and open source. I have changed over some of these information models into a shape that they can be utilized locally in any of the current spatially empowers databases eg Oracle XE, SQL Server 2008 “Katmai”, MySQL and PostGIS. <a href=“http://www.groovyessays.com/buy-essay/”>Buy Essay</a>

— jhon smith · 18 May 2017, 17:33 · #

Jerry,
The path to Hell is paved with good intentions.k
I write some scripts that transformed the ESRI data model into plain Oracle Spatial, Sql Server Spatial, PostGIS, but I never fully completed it for publication. I’ve sent what I’ve done to others who have asked, but never heard back about what happened (standard fare for this website and my work). If you want to have a look at what I have contract me privately.
Simon

— Simon Greener · 18 May 2017, 18:55 · #

Information displaying in programming building is the way toward making an information show by applying formal information demonstrate depictions utilizing information displaying systems. do my homework for me

— Susan James · 19 May 2017, 21:43 · #

Article Navigation: