[mapguide-users] SQL Server 2005

[Lockyer James]

I was thinking about storing XML fragments on the MS SQL. Must admit to still trying to get my head round how the FDO stuff connects accross both autodesk and the datasource.  Presumably the FDO provider 'converts' the data into GML which Mapguide then processes.  
 
James Lockyer
GIS Specialist
IM&T
Bradford and Airedale Teaching PCT
New Mill, Victoria Road, Saltaire, Shipley, West Yorkshire, BD18 3LD
 
Tel: 01274 366031
 
This email is intended for the use of the addressee only and may contain confidential information, copyright material or views/opinions that do not necessarily reflect those of the organisation. If you receive this email by mistake please advise the sender immediately. All should be aware that this email may be subject to public disclosure under the Freedom of Information Act 2000 and that emails are monitored periodically.

________________________________

From: Frank Warmerdam [mailto:warmerdam at pobox.com]
Sent: Wed 04/10/2006 15:45
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] SQL Server 2005



Lockyer James wrote:
...
> In case you have X,Y,Z coordinates stored in different columns, the ODBC provider should be used against SQL Server data. - has this been speeded up in the latest release?  As when I tried this it took over 40 minutes to map out four points.
> 
> Has anyone thought about using GML as a storage mechanism?

Jim,

Were you thinking of gml geometry fragments as a representation for
geometry in records in SQL Server or a GML file-on-disk provider?  If
built against Xerces the OGR FDO Provider can read some varieties of GML2
though the GML support has many ... flaws.  (my fault).

I don't know if the normal binary for the OGR Provider includes xerces/gml
support or not.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org <http://osgeo.org/> 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org



-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5681 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061004/4c096e08/attachment.bin