[mapguide-users] Concatenate geographic and non-geographic data
ruidaniro at hotmail.co.uk
Tue Mar 10 08:28:50 EDT 2009
Sorry about the mess with thread names.
Thanks a lot for your help. I am using Mapguide Studio 2009 and my database
platform is PostgreSQL.
What do you mean with creating views in my database? I am a newbie with
database and programming.
I am using VISTA as OS and I can connect my non-geographic data via ODBC, so
I will try to connect or create a Join to my OGR greographic data.
Dave Wilson wrote:
> First of all I'm changing the thread name as this is completely unrelated
> to the previous heading.
> There are 2 options that come to mind:
> 1) Create views in your database. What is your database platform?
> 2) Try to connect to your non-geographic tables using an ODBC
> connection assuming you have a driver that works with your database and
> you can figure out how to set the DSN or create a connection string that
> works. Once you have the ODBC connection working in MapGuide you can
> attempt to Join the OGR connection to the ODBC connection. I suspect this
> is going to cause you all kinds of grief depending your OS and the
> database platforms and whether or not the OGR provider supports joins...(I
> honestly don't know).
> If you don't have a copy of MG Studio, I'm not sure how easy this is in
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rui Daniro
> Sent: Monday, March 09, 2009 11:32 AM
> To: mapguide-users at lists.osgeo.org
> Subject: RE: [mapguide-users] Weblayouts Buil-in commands
> Hi kenneth,
> I have a OGR connection to my database. I can see my data with geographic
> attributes but I can not see the other tables with non geographic data.
> How can I acess them to use the data stored there? I would like to
> concanate tables with geographic data with table with non geographic data
> to display attributes stored in several tables. Can you help me with this?
> De: Kenneth Skovhede, GEOGRAF A/S (via Nabble)
> [mailto:ml-user+64672-1645459268 at ...<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=2450420&i=0>]
> Enviada: 25 February 2009 11:54
> Para: Rui Daniro
> Assunto: Re: [mapguide-users] Weblayouts Buil-in commands
> That depends on what you mean by "edit/customize".
> If you mean "change the text" (eg, translate), you can do so with
> MapGuide Maestro, or you can manually modify the underlying xml.
> If you mean "alter functionality", you can look in the
> Regards, Kenneth Skovhede, GEOGRAF A/S
> Rui Daniro skrev:
>> Hi all,
>> I am usig MGE 2009 and I would like to know if it is possible
>> built-in commands. If yes, where and how can I get the code.
>> Thanks in advance.
> mapguide-users mailing list
> mapguide-users at ...<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=2383299&i=0>
> This email is a reply to your post @
> You can reply by email or by visting the link above.
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.7/1982 - Release Date: 03/03/09
> View this message in context: RE: [mapguide-users] Weblayouts Buil-in
> Sent from the MapGuide Users mailing list
> archive<http://n2.nabble.com/MapGuide-Users-f1803227.html> at Nabble.com.
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
View this message in context: http://n2.nabble.com/Weblayouts-Buil-in-commands-tp2383047p2454862.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users