[mapguide-users] R: MapGuide WFS uniqueID

[gvtomm]

Hi Mark

Thank you, I tried with MG_CONTROL (very good script!!) and my  polygon
table

 

Insert into MG_CONTROL

   ( FDO_ORA_OWNER, FDO_ORA_NAME, FDO_ORA_GEOMCOLUMN,  FDO_CLASS_NAME,
FDO_SRID,

    FDO_IDENTITY)

Values

   ('ATS_BASE', 'BA_MUNICIPALITY_POLYGON', 'GEOM', 'MY_POLYGON', 82087, 

    'FID');

 

than I Used the Mapagent Web Tier Test page with WFS GETCAPABILITIES to see
the result

http://xxx:8018/mapguide/mapagent/index.html

 



 

When I use Gaia to test the service, the reference name is
ns160697717:MY_POLYGON

 

Result

In my opinion MG_CONTROL can handle the name of the feature class, but not
the ID before the name that depends from the data source created in MGOS
(I’m trying to force/change the ID)

 

Do you have experienced something else, please?

 

Best regards

Gvtomm

 

 

 

 

Da: mapguide-users <mapguide-users-bounces at lists.osgeo.org> Per conto di
mark volz
Inviato: mercoledì 17 novembre 2021 22:11
A: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Oggetto: Re: [mapguide-users] MapGuide WFS uniqueID

 

Yes, you can.

 

When you create a connection, you can set “kingFDOClass”. This field needs
to point to a table with metadata information about the tables you want to
use within MapGuide. Typically I call this table mg_control, but you can
name it anything you want so long as it has all the required columns. In
addition to controlling the FDO class name (the exposed object names you
see), the control table allows you to use point data where you don’t have a
geometry field but have x and y columns.

 

The table needs to be in the same schema that you set in the OracleSchema
field.

 

Attached is a SQL statement to create the table and a trigger and sequence
to set the unique id field and comments on the key attributes.

 

Here is a sample insert statement:

Insert into MG_CONTROL

   ( FDO_ORA_OWNER, FDO_ORA_NAME, FDO_ORA_GEOMCOLUMN,  FDO_CLASS_NAME,
FDO_SRID,

    FDO_IDENTITY)

Values

   ('someSchema', 'someTable', 'theGeometryColumn', 'exposed feature name',
3112, 

    'primaryKeyOnTable');

 



 

From: mapguide-users <mapguide-users-bounces at lists.osgeo.org
<mailto:mapguide-users-bounces at lists.osgeo.org> > On Behalf Of gvtomm
Sent: Thursday, 18 November 2021 7:37 AM
To: mapguide-users at lists.osgeo.org <mailto:mapguide-users at lists.osgeo.org> 
Subject: [mapguide-users] MapGuide WFS uniqueID

 

Hi,

I’m using MGOS 3.1

When I publish a King.Oracle data source in WFS, the name of WFS service is
composed by an Identifier (yellow) and the name of the Oracle table/view

For example

 

<wfs:Name>ns125641909:ABC_BASE~TB_PERIMETER~GEOM</wfs:Name>

 

Is it possibile to change/force the identifier, after moving MGOS in a new
server?

Because my application works with static link for WFS service that I can’t
change

 

Best regards

gvtomm

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20211118/f873ef78/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5010 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20211118/f873ef78/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 29259 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20211118/f873ef78/attachment-0001.png>