<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2>Hi All!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2>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!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=012172717-09112007><FONT face=Arial
color=#0000ff size=2>Joao</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Fonseca Hespanha de Oliveira, Joao da<BR><B>Sent:</B> vrijdag 9 november
2007 15:26<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> RE:
[postgis-users] UML Profile using PostGIS geometry typesandSQL-MMtopology
functions<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>Norman:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>Thanks for all the usefull advices concerning possible
implementations to follow in my tool development.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>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).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>There is also the possibility to specify queries (most will
be validation ones) from the model itself.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=330155813-09112007><FONT face=Arial
color=#0000ff size=2>Joao</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Norman Barker<BR><B>Sent:</B> donderdag 8 november 2007 21:19<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> RE: [postgis-users] UML Profile
using PostGIS geometry types andSQL-MMtopology functions<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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 <A
href="http://www.isotc211.org/">http://www.isotc211.org/</A> might be of
use.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Norman<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Fonseca Hespanha de Oliveira,
Joao da<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday,
November 08, 2007 11:12 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
postgis-users@postgis.refractions.net<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [postgis-users] UML Profile using
PostGIS geometry types and SQL-MMtopology
functions</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Hello all! <BR> <BR>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.
<BR> <BR>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.
<BR> <BR>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. <BR> <BR>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.<BR> <BR>If somebody has a suggestion on any other way to
interact, with or without EA software, ideas are also most
welcome. </SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">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).</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt"><BR>Looking forward to hear from you, <BR>Joao Paulo
Hespanha <BR>PhD Student, OTB Research Institute, <BR>TUDelft <BR>The
<st1:country-region w:st="on"><st1:place
w:st="on">Netherlands</st1:place></st1:country-region></SPAN></FONT><o:p></o:p></P></DIV></DIV></BODY></HTML>