<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:Z="urn:schemas-microsoft-com:" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>At this time, SQL Server Spatial for 3.2.x is submitted and
built from the <a href="http://svn.osgeo.org/fdordbms/branches/3.2.x"><span
style='color:windowtext'>http://svn.osgeo.org/fdordbms/branches/3.2.x</span></a>
repository. I would really like it that we put the PostGIS 3.2.x code somewhere
central so that is can be maintained and accessed by the community.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Based on previous patches and PostGIS involvement, I will
add Bruno as a contributor.<o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Greg<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org [mailto:fdo-internals-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Jason Birch<br>
<b>Sent:</b> Friday, April 04, 2008 5:04 PM<br>
<b>To:</b> FDO Internals Mail List; Bruno Scott<br>
<b>Subject:</b> RE: [fdo-internals] RE: FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'>This is all good
news. It’s great to see the PostGIS provider maturing.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'>For the previous 3.2
binary release of the provider, I just pulled down the 3.3 trunk version into a
local 3.2 tree and built it. I may have had to change a couple things,
but I don’t think so. Bruno, would you be willing to do this for
3.2, or should we look at having the OSGeo SAC set up yet another repository
for us? Greg, how are you handling this for the SQL 2008 provider?
It would be nice if the 3.2 repositories could eventually be archived and taken
offline, but given that most of the live implementations of FDO are still using
3.2, it will take a while until we get to that point.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'>I’m not sure
how Mateusz feels about this, but I think that if the first few of
Bruno’s patches look good that it would be more efficient for him to be
given commit access, and for Mateusz (or others) to do post-commit review.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'>I’m assuming
that we have received Bruno’s contribution agreements?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'>Jason<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Greg Boone<br>
<b>Sent:</b> Friday, April 04, 2008 13:29<br>
<b>To:</b> Bruno Scott<br>
<b>Cc:</b> FDO Internals Mail List<br>
<b>Subject:</b> [fdo-internals] RE: FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Hi Bruno,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for the update. </span><span
style='font-family:Wingdings;color:#1F497D'>J</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><u><span style='color:#1F497D'>For 3.3/3.4</span></u><span
style='color:#1F497D'>, Submit your changes into <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>3.4 -- <a
href="https://svn.osgeo.org/fdo/trunk/Providers/PostGIS">https://svn.osgeo.org/fdo/trunk/Providers/PostGIS</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>3.3 -- <a
href="https://svn.osgeo.org/fdo/branches/3.3/Providers/PostGIS">https://svn.osgeo.org/fdo/branches/3.3/Providers/PostGIS</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Please have Mateusz review and
if needed, submit those submissions<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><u><span style='color:#1F497D'>For 3.2.x <o:p></o:p></span></u></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>This is a trickier issue. We do
not have a SVN repository available for PostGIS built on 3.2.x. We could create
a new SVN repository that follows the existing 3.2.x pattern as described on <a
href="http://fdo.osgeo.org/roadMap.html">http://fdo.osgeo.org/roadMap.html</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>This repository name would be:
<a href="http://svn.osgeo.org/fdopostgis/branches/3.2.x">http://svn.osgeo.org/fdopostgis/branches/3.2.x</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>You would need Jason or Frank to
help you with this.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Once all the submissions are in,
we can kick off the respective 3.2.x and 3.3.x builds and post patches on
fdo.osgeo.org.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Greg<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Bruno Scott
[mailto:Bruno@geomapgis.com] <br>
<b>Sent:</b> Friday, March 28, 2008 7:30 AM<br>
<b>To:</b> Greg Boone<br>
<b>Cc:</b> Gwenael Bachelot<br>
<b>Subject:</b> RE: FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Hi Greg<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>We have still a couple issues
with the PostGIS Driver<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/94"
title="Generate extent for features assigned to default spatial context">#94</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Generate extent for
features assigned to default spatial context<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
We’re going to check that one<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/106"
title="PostGIS provider cannot delete a feature class">#106</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>PostGIS provider cannot
delete a feature class<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Deleting works with feature class and non feature class<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
But the table must be empty<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/117"
title="PostGIS provider does not display attribute names in MapGuide when no PK ...">#117</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>PostGIS provider does
not display attribute names in MapGuide when no PK present<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:#548DD4'>This is a normal
behavior<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#17365D'>
<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/171"
title="Fdo Postgis Autogenated identity property is mandatory">#171</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis Autogenated
identity property is mandatory<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Not mandatory anymore<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/178"
title="PostGIS : Can't insert in a non-feature class">#178</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>PostGIS : Can't insert
in a non-feature class<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Non-feature class works well with insert,delete,update and for displaying with
join<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/232"
title="Fdo Postgis null and not null filter does not work">232</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis null and not
null filter does not work<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Not yet implemented, I will add this one in our unit tests<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/233"
title="Fdo Postgis in and not in filter does not work">#233</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis in and not
in filter does not work<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
fixed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/234"
title="Fdo Postgis currently does not support anything but lowercase identifiers">234</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis currently
does not support anything but lowercase identifiers<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:#548DD4'>Still some pending
problems with that one<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/235"
title="Fdo Postgis Exception with insert">#235</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis Exception
with insert<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
fixed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/236"
title="Fdo Postgis does not support non spatial classes">#236</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis does not
support non spatial classes<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
fixed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/241"
title="Implement Support for SelectAggregates, SpatialExtents and Count">#241</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Implement Support for
SelectAggregates, SpatialExtents and Count<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Select Count works fine now, so selectAggregates also<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Nothing was implemented<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
More testing should be done<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>Other things, there was
a discussion with the community according to the class naming convention<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>So we have fallow the
community recommendation and we have replaces the “shema~class” by
“class” only.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>We ran our test in different
environments<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
100% FDO / C++ program ( without any map or Mapguide)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
Map 2008 / fdo 3.2<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
Map 2009 / fdo 3.3<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
Mapguide 1.2 / fdo 3.2<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>
Mapguide 2.0 / fdo 3.3<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Using the same Postgres/PostGIS
version as Matheus ( 8.2.4 + 1.2.1)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>We have 3 primary spatial tables
with all the same columns (one for point, one for line/multi-line and one for
polygon/multi-polygon)<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>KEY_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>STRING_1
String<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>INT32_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>DOUBLE_1
Double<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>DATE_1
DateTime<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>STR_CODE_1
String 64<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>INT_CODE_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>GEOMETRY_1
GEOMETRY<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>plus one primary alpha table
(without geometry)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>and one primary X/Y table (
Postgis provider does not support displaying it YET)<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>We have one secondary alpha
table for 1-1 joining ( KEY_1 = j_KEY_1) with the 5 primary tables<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>J_KEY_1
Int32
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>J_STRING_1
String
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>J_INT32_1
Int32
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>J_DOUBLE_1
Double
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>J_DATE_1
DateTime
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>J_STR_CODE_1
String
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>J_INT_CODE_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>We have two secondary alpha
table for n-1 joining (INT_CODE_1 = INT_CODE_1 / STR_CODE_1 = STR_CODE_1) with
the 5 primary tables<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>INT_CODE_1
Int32
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>DESC_1
String <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>And<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>STR_CODE_1
String<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>DESC_1
String<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='color:#1F497D'>Unit test with FDO/C++
( all test succeed, 0 failed)<o:p></o:p></span></b></p>
<p class=MsoNormal><b> Schema modification<o:p></o:p></b></p>
<p class=MsoNormal>
Drop spatial table ( failed if data in the table)<o:p></o:p></p>
<p class=MsoNormal>
Drop non-spatial table ( failed if data in the table)<o:p></o:p></p>
<p class=MsoNormal>
Create spatial table<o:p></o:p></p>
<p class=MsoNormal>
Create non-spatial table<o:p></o:p></p>
<p class=MsoNormal> All our test table are dropped and
recreated using FDO prior doing any other test<o:p></o:p></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-size:10.0pt'><o:p> </o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-size:10.0pt'>
Alpha Filter test<o:p></o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Using <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>FdoCommandType_Select (select column from … )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>FdoCommandType_SelectAggregates ( select Count(1) from
… )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>FdoCommandType_SQLCommand ( complexe query with 1-1 /
n-1 joins )<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key = 1<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key In (1,2)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key Not In (1,2)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key > 99<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key >= 99<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key < 2<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Key <= 2<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
String = 'Bb'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
String In ('Bb','Dd')<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
String Not In ('Bb','Dd')<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
String Like 'B%'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
String Not Like 'B%'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
</span><span lang=FR style='font-size:10.0pt'>Int = 10010<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int > 10990<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int >= 10990<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int < 10020<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int <= 10020<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double = 20010.0000001<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double > 118010.0097903<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double >= 118010.0097903<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double < 21010.0001<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double <= 21010.0001<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Date = 2007-01-01<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> </span><span style='font-size:10.0pt'>Date >
2007-04-09<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Date >= 2007-04-09<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Date < 2007-01-02<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Date <= 2007-01-02<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
DateTime = 2007-01-01 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
DateTime > 2007-04-09 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
DateTime >= 2007-04-09 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
DateTime < 2007-01-02 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
DateTime <= 2007-01-02 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-size:10.0pt'>
Spatial Filter test<o:p></o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Using <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>FdoCommandType_Select (select column from … )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>FdoCommandType_SelectAggregates ( select Count(1) from
… )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>FdoCommandType_SQLCommand ( complexe query with join )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>geometry ENVELOPEINTERSECTS GeomFromText('POLYGON XY
…')"<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>geometry ENVELOPEINTERSECTS GeomFromText(POINT XY
…')"<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>we didn’t test the LINESTRING ( we should )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span style='font-size:10.0pt'>
Update test<o:p></o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Insert simple polygon<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Insert multi polygon<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Insert polygon with hole<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>Insert linestring<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>Insert multi linestring<o:p></o:p></span></p>
<p class=MsoNormal>
Insert point<o:p></o:p></p>
<p class=MsoNormal>
Insert alpha ( no geometry in table)<o:p></o:p></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt'>
Delete polygon<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
style='font-size:10.0pt'>Delete linestring<o:p></o:p></span></p>
<p class=MsoNormal>
<span style='font-size:10.0pt'>Delete </span>point<o:p></o:p></p>
<p class=MsoNormal>
<span style='font-size:10.0pt'>Delete </span>alpha ( no geometry in table)<o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update int32 ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update String ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update double ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update date ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update datetime ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update geometry simple polygon<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update geometry multi polygon<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update geometry polygon with hole<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update geometry linestring<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update geometry multi linestring<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>
Update geometry point<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal>Test with Map 2008<o:p></o:p></p>
<p class=MsoNormal>
Connecting OK<o:p></o:p></p>
<p class=MsoNormal>
Attaching table with srid OK <o:p></o:p></p>
<p class=MsoNormal>
Attaching table without srid -> map display a warning<o:p></o:p></p>
<p class=MsoNormal>
Display point ok<o:p></o:p></p>
<p class=MsoNormal>
Display linestring ok<o:p></o:p></p>
<p class=MsoNormal>
Display polygon ok<o:p></o:p></p>
<p class=MsoNormal>
Joining spatial table to non-spatial table ok<o:p></o:p></p>
<p class=MsoNormal>
Table view display ok<o:p></o:p></p>
<p class=MsoNormal>
Updating in the table view ok but the check-in crashes map<o:p></o:p></p>
<p class=MsoNormal>
Check-out crashes map<o:p></o:p></p>
<p class=MsoNormal>
<o:p></o:p></p>
<p class=MsoNormal>Test with Map 2009<o:p></o:p></p>
<p class=MsoNormal>
This after noon<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Test with Mapguide 1.2<o:p></o:p></p>
<p class=MsoNormal>
Everything seems ok<o:p></o:p></p>
<p class=MsoNormal>
But still some testing to do with srid<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Test with Mapguide 2.0<o:p></o:p></p>
<p class=MsoNormal>
Everything seems ok<o:p></o:p></p>
<p class=MsoNormal>
But still some testing to do with srid<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>We are actually investigating on the crash problem within
map 2008.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I don’t know exactly what are the process to submit
all our code changes with the release 3.2.2 and 3.3.0.<o:p></o:p></p>
<p class=MsoNormal>If you could provide some help on that point it will be
appreciated.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Cheers<o:p></o:p></p>
<p class=MsoNormal>Bruno<o:p></o:p></p>
<p class=MsoNormal><b><span style='color:#1F497D'><o:p> </o:p></span></b></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt'>From:</span></b><span
style='font-size:10.0pt'> Greg Boone [mailto:greg.boone@autodesk.com] <br>
<b>Sent:</b> jeudi 27 mars 2008 18:29<br>
<b>To:</b> Bruno Scott (External)<br>
<b>Subject:</b> FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi Bruno,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I was wondering if you could provide an update on the status
of the FDO OSGeo PostGIS Provider modifications that your team has been working
on?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>What changes have been made so far and how do these relate
to the FDO Track issues that have been logged?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>What is your plan to submit changes to the FDO OSGeo SVN?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>When can your changes be rolled into our formalized build
process and released as an official patch to the FDO 3.3 release?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Will you changes also support FDO 3.2? <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>If so, we need to get that the FDO 3.2 code dropped as well,
and an official provider release posted.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Cheers,<o:p></o:p></p>
<p class=MsoNormal>Greg<o:p></o:p></p>
</div>
</body>
</html>