[mapguide-users] RE: ODBC problem...

Andy Morsell amorsell at spatialgis.com
Wed Apr 19 14:29:36 EDT 2006

I agree that the options and flexibility are good and that making your
primary the spatial datasource is the most intuitive.  It's just confusing
from a UI standpoint.  In this case, I defined a primary ODBC datasource and
I create an extension off of that to a secondary spatial datasource (SDF).
I then create new layer from that, choose my extension as the feature class,
and then I can select the geometry from the secondary as the Geometry (it's
the only geometry in this case since there is none defined in the primary).
Studio even detects the type of geometry (polygon) and sets up its default
style parameters accordingly.  I would expect this layer to work and display
just as if I had done it the other way around since the geometry is
available for me to choose when defining the layer.  



From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Wednesday, April 19, 2006 11:14 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: ODBC problem...

One of the features of having the join on the ODBC resource is that you
could chain multiple Attribute tables together if you needed to rather than
combining the data in a table or view. Of course the more you chain together
the slower your performance will likely be.
Chaining the spatial to spatial or attribute to spatial doesn't make sense
for the most part I agree although you could join an SDF to an SHP to get
attributes if you really didn't want to merge the data, but I'm not sure how
likely that case would be. Of course I could argue then I have a POINT
source in ODBC and join it to an SHP for attrbutes, but again would you
really want to do it?
I think the options are there for flexibility.


From: Andy Morsell [mailto:amorsell at spatialgis.com] 
Sent: Wednesday, April 19, 2006 12:06 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: ODBC problem...

Thanks for the clarification Dave.  I hadn't even looked at my spatial
datasource to notice that there is now a Join portion of the dialog at that
level.  I was thinking the join was only defined from the tabular
datasource.  Now that I have set it up there (pretty much using the same
steps I previously outlined) it is working fine.  I can display my parcel
polygons with tooltips and properties derived from the secondary Access
It is a little confusing that it can be done the other way around and that a
layer can be seemingly created from that while choosing the geometry feature
from the secondary datasource.  That process should probably be changed in
Studio to prevent that from happening.
I'm still having problems with point data from an ODBC resource, but will do
some more experimenting later.



From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Wednesday, April 19, 2006 7:26 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: ODBC problem...

Am I correct in understanding you are using the spatial resource as the
Secondary resource? The Spatial resource needs to be the primary resource if
this is what the layer is to be based on. The join is generally for
attaching attribute data to spatial data such as adding properties from an
Access table to an SDF.
Point data from an ODBC resource should also work as a primary resource.
Dave Wilson


From: Andy Morsell [mailto:amorsell at spatialgis.com] 
Sent: Tuesday, April 18, 2006 6:22 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: ODBC problem...

Here are the steps I took to create the join.  Note that I wasn't able to do
with anything with the join in terms of creating a layer from it, however.

*	Once your datasource is setup and you can see the tables listed in
the Refine Data Setup area, click the New Extended Feature Class button.  

*	Choose your other datasource in the repository that you are
connecting to 

*	Choose the Primary Feature class (table) 

*	Click on your New Join below the Extension you just created 

*	You will most likely only have one option for the Secondary class

*	Select your Primary Column and Secondary Column fields.  These are
the key fields tying together your primary (tabular) and secondary (spatial)

If you get this far, please let us know if you can successfully create a
layer where you can view the resultant objects.  I also tried creating a
layer from X and Y points in a table from this database and, again, was not
able to view the resultant geometry.

Andy Morsell 

-----Original Message----- 
From: Thud732 [ <mailto:devlin.fung at sapience360.com>
mailto:devlin.fung at sapience360.com] 
Sent: Tuesday, April 18, 2006 4:30 PM 
To: users at mapguide.osgeo.org 
Subject: [mapguide-users] RE: ODBC problem... 

Hi Andy: 

Can you please outline your 'join connection' steps? I was able to establish
a successful test connection, but failed when joining.

Thank you. 
View this message in context:

Sent from the OSGeo MapGuide forum at Nabble.com. 

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20060419/e58ec74e/attachment.html

More information about the Mapguide-users mailing list