Re: [mapguide-users] Help with Spatial Contexts
Since the PostgreSQL provider is built on the same GenericRdbms core as the other relational providers, you should still be able to activate tracing via the FDO_TRACE_FILE environment variable and have a look at the SQL statements the provider is executing to get its spatial contexts http://themapguyde.blogspot.com.au/2013/01/mapguide-tidbits-fdo-rdbms-provider.html - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Help-with-Spatial-Contexts-tp5310988p5311693.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Help with Spatial Contexts
Maestro does no auto-numbering. Definitely comes from the FDO provider. - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Help-with-Spatial-Contexts-tp5310988p5311692.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Help with Spatial Contexts
Where do the sc_1, sc_2, etc come from when you list Coordinate Systems Overrides for SQL server in Maestro? Is this just an autonumber internally to Maestro or is this stored somewhere in SQL? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Help-with-Spatial-Contexts-tp5310988p5311687.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Help with Spatial Contexts
I know for SQL Server, the provider may create a f_scinfo table to store intermediate data for spatial contexts. Since the PostgreSQL provider is built on the same core, it may be creating a f_scinfo table for this purpose as well. Does your database have this table? - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Help-with-Spatial-Contexts-tp5310988p5311686.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Help with Spatial Contexts
Thanks for the thorough answer. That does match what my understanding has been. My question arose because I added a data table to PostGIS recently. In the Maestro Preview of that data source, the table showed sc_3 as the spatial context of the table. The layer showed sc_2 as its selected spatial context. SC_3 was a 10TM zone and sc_2 was a UTM11 zone. The data shift, when adding the layer to the map, was equal to the difference in the two UTM zone definitions. I tried to refresh the spatial contexts list. I dropped and recreated the layer. The problem never went away. I have not tried to re-create the data source as I have an application with quite a few layers using this data source. I have quite a lot of tables in the database as well as about 9 -10 different spatial contexts. Tables have been added and dropped over time. Maybe I need to vacuum the database or do some other maintenance to clean it up. I will try to recreate the data source to see if there is anything related to that. Thanks again. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Help-with-Spatial-Contexts-tp5310988p5311605.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users