The most generic solution would be to create a temporary SDF FeatureSource,
and then insert the features from the database, one by one.
Code for this can be found in the buffer.aspx/jsp/php file (except the read from db loop).

However, it may be easier and faster to create a regular layer, displaying the entire source table (or view). Instead of executing the select to the database, simply set the "Filter" of the
layer to match the "WHERE" clause in the SQL.
Obviosly, this is not always possible.

Another option would be to create a temporary table, which is supported by most
database systems, and use that as a FeatureSource.

Some databases can return an SHP file with the data. Such a file could be used to
create an SHP FeatureSource, and display it right away.

Regards, Kenneth Skovhede, GEOGRAF A/S



Peter Filip skrev:
Hello!

My sql select is returning spatial data. I'm looking for a neat solution for
display this data. I can't put this data to a DB table. So i need somehow
copy this data somewhere in the mapguide reposiroty. :-)  There will be
couple thousands of records. Any suggestions ?

_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to