[postgis-users] Data Models

[Simon Greener]

I have a basic tool built using xmlstartlet that can convert any of the ESRI GeoDatabase data models (as XML Schema of the GeoDatabase) to Oracle SQL. Modifying to convert to PostGIS is pretty trivial. The converter already converts the SewerStorm data model. It creates the domain tables, main tables, sets up foreign keys, creates a view for each SubType, Triggers for SubType default values. It also creates tables that hold the spatial relationship information for Topology and Network constraints (but this is an area I have not finished).
I am willing to share it with anyone who is interested.
regards
Simon Greener
On Wed, 28 May 2008 00:54:48 +1000, George Silva <georger.silva at gmail.com> wrote:

> Hello Robert.
>
> I provided on the list the XML data model used for arcgis, and someone was
> converting it.
>
> I will register on the sourceforge and as soon as possible, ill upload my
> data model.
>
> I think this is a major step, since data models can simplify everyones life!
>
> Thanks for answering Robert!
>
> George
>
> On Tue, May 27, 2008 at 9:45 AM, Burgholzer,Robert <
> rwburgholzer at deq.virginia.gov> wrote:
>
>>  George,
>>
>> I went so far as to set up a sourceforge project for this, but that iis as
>> far as it went.  One of the initial parties was going to look into uploading
>> the pipeline data model that they had, which if I recall was in M$Access,
>> and then we were going to parcel out the work of converting it into
>> PostgreSQL tables.
>>
>>
>>
>> https://sourceforge.net/projects/envirodata
>>
>>
>>
>> At such a time as the original pipeline model goes up, I would be delighted
>> to lend a hand in converting.  As for your interest in this, please register
>> on the project, and start uploading some stuff!
>>
>>
>>
>> r.b.
>>
>>
>>
>> Robert W. Burgholzer
>>
>> Surface Water Modeler
>>
>> Office of Water Supply and Planning
>>
>> Virginia Department of Environmental Quality
>>
>> rwburgholzer at deq.virginia.gov
>>
>> 804-698-4405
>>
>> Open Source Modeling Tools:
>>
>> http://sourceforge.net/projects/npsource/
>>
>> -----Original Message-----
>> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
>> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *George Silva
>> *Sent:* Friday, May 23, 2008 11:30 PM
>> *To:* PostGIS Users Discussion
>> *Subject:* [postgis-users] Data Models
>>
>>
>>
>> Some time ago, in this list there was a discussion about data models.
>>
>>
>>
>> Is anyone carrying out that idea? I remember that there was a buzz around a
>> pipeline data model, and im wondering if that ever happened.
>>
>>
>>
>> Im willing to contribute too, im building a data model(for my thesis in
>> college) for traffic accidents analisys, with a geocoder and informations
>> about the accidents. (Big thanks to David Bitner for providing the geocoder
>> - which i will help him writing some documentation too)
>>
>>
>>
>> Is anyone interested in building a repository for these data models or
>> something similar?
>>
>>
>>
>> George
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>



-- 
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
   Email: simon at spatialdbadvisor.com
   Voice: +613 9016 3910
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3