<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6619.12">
<TITLE>RE: [fdo-users] RE: Defining SpatialContext - how and when?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Ah, yes, the WKT...<BR>
<BR>
WKT only needs to be manually set (using FdoICreateSpatialContext::SetCoordinateSystemWkt() for FDO providers that cannot generate WKT. This is the case for most providers (because their underlying datastores don't have native coordinate system support).<BR>
<BR>
For those that do natively support coordinate systems (like Oracle), the provider may also verify that the coordinate system name and WKT are in the datastore's catalogue. It's generally just a blind string comparison, so minor variations may cause a failure in WKT. To avoid this, just omit setting the WKT attribute.<BR>
<BR>
There is an FDO capability to let you know whether WKT generation is supported: FdoIConnectionCapabilities:: SupportsCSysWKTFromCSysName().<BR>
<BR>
By the way, while your code for creating a LineString will work, the FdoIDirectPosition type is not yet a pooled object, and will result in a lot of heap activity. I recommend looking at the other constructors that are more efficient if you plan to use a lot of features. For example, there is one that takes an array of ordinates. There are accessors that tend to be much faster as well. For example, GetItemByMembers() is the fastest one that does all the ordinate reading for you, and GetOrdinates() is the fastest if you want a raw ordinate array.<BR>
<BR>
Gavin<BR>
<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: fdo-users-bounces@lists.osgeo.org on behalf of Maksim Sestic<BR>
Sent: Sat 07-Jul-07 10:28 AM<BR>
To: fdo-users@lists.osgeo.org<BR>
Cc: <BR>
Subject: [fdo-users] RE: Defining SpatialContext - how and when?<BR>
<BR>
<BR>
Dear Gavin,<BR>
<BR>
Thanks for the tip. It's still bugging me. Here's what I'm doing:<BR>
<BR>
1) create new DataStore named "GIS"<BR>
<BR>
2) create SpatialContext named "MGI" using following parameters:<BR>
- Name: MGI<BR>
- Description: MGI<BR>
- Coordinate System: MGI / Balkans zone 6<BR>
- Coordinate System WKT: PROJCS["MGI / Balkans zone<BR>
6",GEOGCS["MGI",DATUM["Militar_Geographische_Institute",SPHEROID["Bessel<BR>
1841",6377397.155,299.1528128]],PRIMEM["Greenwich",0.000000],UNIT["Decimal<BR>
Degree",0.01745329251994330]],PROJECTION["Transverse_Mercator"],PARAMETER["Centr<BR>
al_Meridian",18],PARAMETER["Scale_Factor",0.9999],PARAMETER["False_Easting",6500<BR>
000.000000],PARAMETER["False_Northing",0.000000],UNIT["Meter",1.000000000000]]<BR>
- XY Tolerance: 0.0001<BR>
- Z Tolerance: 0.0001<BR>
- Extents Type: SpatialContextExtentType_Static<BR>
- Extents range from 0,0 to 7000000,7000000<BR>
<BR>
3) create schema "TESTSCHEMA" containing one class "TESTCLASS" with<BR>
GeometryValue defined as:<BR>
geomProperty.GeometryTypes = 7<BR>
geomProperty.SpatialContextAssociation = "MGI"<BR>
<BR>
-------------<BR>
<BR>
Still, when I try to issue an Insert on some geometry ti throws "Error<BR>
creating spatial context (null) (SRID=486518961), the WKT provided does not<BR>
match the catalog." again.<BR>
<BR>
Here's the geometry definition (sitting within specified spatial context<BR>
extents):<BR>
<BR>
Dim insertCommand As IInsert =<BR>
CType(m_Transaction.Connection.CreateCommand(CommandType.CommandType_Insert),<BR>
IInsert)<BR>
insertCommand.SetFeatureClassName("TESTSCHEMA:TESTCLASS")<BR>
<BR>
Dim factory As AgfGeometryFactory = New AgfGeometryFactory()<BR>
Dim pcollection As DirectPositionCollection = New DirectPositionCollection()<BR>
pcollection.Add(factory.CreatePositionXY(6500001, 4950001))<BR>
pcollection.Add(factory.CreatePositionXY(6534554.445, 4958445.342))<BR>
<BR>
Dim line As ILineString = factory.CreateLineString(pcollection)<BR>
Dim geometryValue As GeometryValue = New GeometryValue(factory.GetAgf(line))<BR>
insertCommand.PropertyValues.Add(New PropertyValue("geometry",<BR>
geometryValue))<BR>
insertCommand.Execute()<BR>
<BR>
---------------------------<BR>
<BR>
Regards,<BR>
Maksim Sestic<BR>
<BR>
<BR>
<BR>
<BR>
Gavin Cramer wrote:<BR>
><BR>
> Hello, Maksim. The "active" spatial context is a bit of a stale idea,<BR>
> and might become deprecated. Any provider that currently cares about it<BR>
> actually sets it internally, based on the relevant geometric property's<BR>
> spatial context association.<BR>
><BR>
> The association can be set when creating a schema definition via<BR>
> FdoGeometricPropertyDefinition:: SetSpatialContextAssociation().<BR>
><BR>
> Gavin<BR>
><BR>
><BR>
> -----Original Message-----<BR>
> From: fdo-users-bounces@lists.osgeo.org<BR>
> [<A HREF="mailto:fdo-users-bounces@lists.osgeo.org">mailto:fdo-users-bounces@lists.osgeo.org</A>] On Behalf Of Maksim Sestic<BR>
> Sent: Saturday, July 07, 2007 8:50 AM<BR>
> To: fdo-users@lists.osgeo.org<BR>
> Subject: [fdo-users] Defining SpatialContext - how and when?<BR>
><BR>
><BR>
> Autodesk Map 3D 2007 / MS SQL Server 2005<BR>
><BR>
> I have problems inserting a new GeometryValue due to the "Default"<BR>
> SpatialContext settings. "Default" SpatialContext has an envelope<BR>
> (extents)<BR>
> ranging from -2000000,-2000000 to 2000000,2000000, while my geometry<BR>
> lies<BR>
> way beyond default settings. Due to that fact, I keep receiving<BR>
> following<BR>
> error: "Error creating spatial context (null) (SRID=486518961), the WKT<BR>
> provided does not match the catalog."<BR>
><BR>
> I tried to update Extents value on "Default" spatial context using<BR>
> CreateSpatialContext command but it's not working (well, at least<BR>
> nothing<BR>
> changes in dbo.f_spatialcontextgroup table). Then I resorted to creating<BR>
> a<BR>
> new SC.<BR>
><BR>
> Now, I managed to create a new SpatialContext (named "MGI") with<BR>
> associated<BR>
> WKB string, proper extents settings, etc. Alas, I can not activate it<BR>
> :-)<BR>
> ActivateSpatialContext command does not affect present spatial contexts<BR>
> within DataStore - ISpatialContextReader always returns IsActive = False<BR>
> for<BR>
> every SC present.<BR>
><BR>
> I think I'm doing something wrong here, just can't figure out exactly<BR>
> what... :-) At what moment do I need to create custom SpatialContext<BR>
> (before<BR>
> or after creating feature schema?), and how do I apply newly established<BR>
> SC<BR>
> on present schema? How do I "force" my newly inserted geometric values<BR>
> "conformant" to present SC?<BR>
><BR>
> Regards,<BR>
> Maksim Sestic<BR>
><BR>
><BR>
> --<BR>
> View this message in context:<BR>
> <A HREF="http://www.nabble.com/Defining-SpatialContext---how-and-when--tf4040281s">http://www.nabble.com/Defining-SpatialContext---how-and-when--tf4040281s</A><BR>
> 18162.html#a11478212<BR>
> Sent from the fdo-users mailing list archive at Nabble.com.<BR>
><BR>
> _______________________________________________<BR>
> fdo-users mailing list<BR>
> fdo-users@lists.osgeo.org<BR>
> <A HREF="http://lists.osgeo.org/mailman/listinfo/fdo-users">http://lists.osgeo.org/mailman/listinfo/fdo-users</A><BR>
><BR>
> _______________________________________________<BR>
> fdo-users mailing list<BR>
> fdo-users@lists.osgeo.org<BR>
> <A HREF="http://lists.osgeo.org/mailman/listinfo/fdo-users">http://lists.osgeo.org/mailman/listinfo/fdo-users</A><BR>
><BR>
><BR>
<BR>
--<BR>
View this message in context: <A HREF="http://www.nabble.com/Defining-SpatialContext---how-and-when--tf4040281s18162.html#a11478979">http://www.nabble.com/Defining-SpatialContext---how-and-when--tf4040281s18162.html#a11478979</A><BR>
Sent from the fdo-users mailing list archive at Nabble.com.<BR>
<BR>
_______________________________________________<BR>
fdo-users mailing list<BR>
fdo-users@lists.osgeo.org<BR>
<A HREF="http://lists.osgeo.org/mailman/listinfo/fdo-users">http://lists.osgeo.org/mailman/listinfo/fdo-users</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>