[mapguide-users] King.Oracle provider - how to create join with
table without geometry data?
haris at sl-king.com
Mon Jan 25 08:19:19 EST 2010
If I am not mistaken you can use KingFdoClass metadata table to add
On Mon, Jan 25, 2010 at 2:10 PM, BojanFranc at FER <bojan.franc at fer.hr> wrote:
> 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
> 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
> = 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
> Is it possible?
> Also, has anyone a better solution for my problem?
> I have round 10 Mil GPS locations for every year.
> View this message in context:
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapguide-users