Re: [mapguide-users] Help with Spatial Contexts

2017-04-17 Thread gom
I know this is a few weeks old but as I tried to add two new layers to a map I have struggled with Spatial Contexts again. I have captured some images from my data source and layer definition in order to show that the layer seems to choose the wrong Spatial Context. I have created and recreated t

Re: [mapguide-users] Help with Spatial Contexts

2017-03-13 Thread gom
Thanks for all the answers. I have a much clearer picture of what I should be doing. I see my database has no f_scinfo table but I do understand that this is optional. Needed only if I want a more clearly named spatial context as opposed to sc_1, sc_2 etc. -- View this message in context: ht

Re: [mapguide-users] Help with Spatial Contexts

2017-03-10 Thread Bernhard Maehler
I am using PostgreSQL 9.6.2 with PostGIS 2.3.2 and AIMS 2017. As Jackie has mentioned before, I can confirm that the PostgreSQL Provider uses the f_scinfo table to obtain the name of the spatial context. However this table has no data and it is not necessary to create it as it only provides the nam

Re: [mapguide-users] Help with Spatial Contexts

2017-03-10 Thread gom
I'll try this. Thanks -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Help-with-Spatial-Contexts-tp5310988p5311753.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-use

Re: [mapguide-users] Help with Spatial Contexts

2017-03-09 Thread Jackie Ng
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://themap

Re: [mapguide-users] Help with Spatial Contexts

2017-03-09 Thread Jackie Ng
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. _

Re: [mapguide-users] Help with Spatial Contexts

2017-03-09 Thread Flipper
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-tp531

Re: [mapguide-users] Help with Spatial Contexts

2017-03-09 Thread Jackie Ng
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 mess

Re: [mapguide-users] Help with Spatial Contexts

2017-03-09 Thread gom
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 spatia

Re: [mapguide-users] Help with Spatial Contexts

2017-03-07 Thread Jackie Ng
The logical model goes like this: A Feature Source - Has 1..n spatial contexts - Each spatial context is uniquely named - Has 1..n feature classes - Each feature class has a designated logical geometry property - That geometry property has a spatial context association (to an existing

[mapguide-users] Help with Spatial Contexts

2017-03-06 Thread gom
I asked an earlier question about PostGis and spatial context issues. I'm not sure it was a very clear question so I decided it might be better to try and ask a more general question to see if I am making a more fundamental mistake in my approach to authoring resources. I need some help understan