[postgis-users] Data Models

Burgholzer,Robert rwburgholzer at deq.virginia.gov
Wed May 28 05:01:00 PDT 2008


Simon,
This looks like a great tool.  If you can provide a link to it, or, if you wish to get a sourceforge account and send me your username, I can add you as a developer on the data models project, and you can upload it yourself.

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 Simon Greener
Sent: Tuesday, May 27, 2008 5:54 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Data Models

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list