[mapguide-users] King.Oracle provider - how to create join with table without geometry data?

[Haris Kurtagic]

If I am not mistaken you can use KingFdoClass metadata table to add
non-geometry tables.

Haris

On Mon, Jan 25, 2010 at 2:10 PM, BojanFranc at FER <bojan.franc at fer.hr> wrote:

>
> Hi,
>
> I have a data warehouse with a FACT table containing a lot of points (GPS
> locations). And I have a DATE dimension table.
> I want to draw a layer containing all locations within 1 day (or a period
> of
> days).
>
> I was thinking of doing a JOIN with King.Oracle of that FACT and DIMENSION
> table, exporting it to XML and then in PHP editing the filter tag with
> "DATE
> = YYYY.MM.DD". After modifying the layer, I would insert the new layer into
> map and draw it.
> It should also work fast enough for users to be able to go BACK and FORWARD
> displaying maps for each day.
>
> The problem is, in King.Oracle provider, I see only tables and views with
> geometry fields. And I need to join my DATE dimension which has no geometry
> (logicaly).
> Is it possible?
>
> Also, has anyone a better solution for my problem?
>
> I have round 10 Mil GPS locations for every year.
>
> Thx!
> --
> View this message in context:
> http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100125/4db5aadc/attachment.html