[postgis-users] UML Profile using PostGIS geometry typesandSQL-MMtopology functions

Fri Nov 9 09:41:36 PST 2007

Hi All!

Relating to the question in my previous Email, I already have an answer,
through the online version of the PostGIS manual, chapter 6. I will look
to "Geometry Accessor" methods in order to prepare version 2 of the
geometry types diagram. Meanwhile, after consulting the manual and also
the Simple Features Access for SQL specification, I draw the UML Class
diagram I attach as a PDF file.

I think I depicted all the geometry types, both original and the SQL/MM
ones. However, the types with Measures (with M sufix) were not included
in the diagram. They would receive a new constraint, stating that an
association with a Measure Reference System should exist.

Did not find any references to the Polyhedral Surface and to the Surface
geometry types as defined in the specifications. They were not
implemented into PostGIS?

PS: Did not see any message regarding the use of attachments on this
list, so I assume it will be OK, specially for such a small one!

Joao

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Fonseca Hespanha de Oliveira, Joao da
Sent: vrijdag 9 november 2007 15:26
To: PostGIS Users Discussion
Subject: RE: [postgis-users] UML Profile using PostGIS geometry
typesandSQL-MMtopology functions

Norman:

Thanks for all the usefull advices concerning possible implementations
to follow in my tool development.
The UML Profile I intend to develop is just a piece of the whole
process, but an important one. I believe a good profile for spatial
features is required to get UML to (spatial) database transformations,
and currently EA has none.
Also, the current schema transformation templates do not take into
account the processing of OCL constraints. Even the XMI generated from
the UML tool does not have it in the UML2 namespace, just in its own
extended namespace (in the EA case, at least).
There is also the possibility to specify queries (most will be
validation ones) from the model itself.

I agree the full potential of such a tool could only be unleashed if
there will be an object model generated in between. I am currently
considering using the Eclipse EMF for that purpose, namely because it
offers UML and also OCL parsing in an Open Source environment.
Hibernate came into consideration just recently (I am a newbie
concerning Java technologies; was used to the MS platform :-) ), just
got a copy of the "Java Persistence with Hibernate". From a first look,
it seams it has indeed a lot of features, in fact it could supply much
of the functionality I have in mind.

Returning to the UML Profile for PostGIS geometry types, I am not being
able to get a full description of the methods which apply to each
geometry type, at least in the same way they are expressed on the Simple
Features Access or the SQL/MM standards. Is there any document on these
matters?

Consideration of PostGIS specific geometry types, constraints and
methods would make this a "UML PostGIS Profile", and not anymore a
generic SQL/MM Profile, but this serves well my immediate research
objectives.

Joao

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Norman Barker
Sent: donderdag 8 november 2007 21:19
To: PostGIS Users Discussion
Subject: RE: [postgis-users] UML Profile using PostGIS geometry types
andSQL-MMtopology functions

Hi,

I am not sure that UML to database is going to achieve that much in
terms of mapping, but certainly UML to object (so ejb3 or geodjango)
and hence database might be interesting.  To this end hibernate tools is
useful (and generates schematics) and just changing the free marker
templates allows geometry mappings.

Most of the work in this area has been in UML to xml schema mapping, and
to this end the models (including EA Architect) from 
http://www.isotc211.org/ might be of use.

If I were doing this work, then the tool I would use would be the new
eclipse UML tools, just because these are publicly available to
everyone, and the XMI they output would be useful in a lot of projects.

ERD tools such as dbdesigner for mysql already support spatial
functions, hence why I am struggling to see the benefit of your approach
- can you explain some more?

Thanks,

Norman

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Fonseca Hespanha de Oliveira, Joao da
Sent: Thursday, November 08, 2007 11:12 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] UML Profile using PostGIS geometry types and
SQL-MMtopology functions

Hello all! 

As part of my current PhD research, I am trying to specify a new UML
Profile to apply to UML Class diagrams representing spatial features,
that is, using geometry types. 

I am using PostgreSQL's PostGIS extension as reference for the actual
geometry types, but I think it could be applied to any spatial database
system which complies to the Simple Features Access for SQL
specification. 

Currently, also geometry types from SQL/MM ISO/IEC standard are also
being supported by such databases, and at least some will be added to
the Profile. 

I would like to receive any suggestions this forum members might have, I
am currently using Enterprise Architect (EA) as UML Modeling Tool and I
plan to present (attach) PDF files with the class diagrams and the final
Profile. Maybe the profile could be added to the EA add ons later on,
otherwise it could be transposed to other UML Tools.

If somebody has a suggestion on any other way to interact, with or
without EA software, ideas are also most welcome. 

The final aim of this research component is to define a CASE tool which
can use a UML model with the mentioned profile to generate a PostGIS
schema through an automatic generated SQL script (a process generally
known as Model-to-Text transformation).

Looking forward to hear from you, 
Joao Paulo Hespanha 
PhD Student, OTB Research Institute, 
TUDelft 
The Netherlands

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071109/80fd2038/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SimpleFeaturesProfile.pdf
Type: application/octet-stream
Size: 13559 bytes
Desc: SimpleFeaturesProfile.pdf
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071109/80fd2038/attachment.obj>