[mapguide-users] Display Historival value assigned to a polygon

[RenoSun]

I have been using spatial views with by editing the Configuration Document of
the database data connection, and it works with SQL Server 2008 and 2016...

Also, the version of the Maestro may cause the problems too.

I am using AIMS 2017 with Maestro 6.0m7 without error messages when I am
trying to edit the Configuration Document of the database data connection.

However, I got error messages when I was using Maestro 6.0m8.

You may want to just create a temporary database, and create a table with
the fields that you would like to use for your spatial view. Then, use FDO
Schema Override Tool to extract the correct Configuration XML for your
spatial view...

Here is my example of the Configuration XML for DB data connection... but we
must have different coordinate system, and FDO provider... so please modify
them to fit your environment.

Change YOUR_GEOM_NAME to the geometry field name that you're using, and
SPATIAL_VIEW_NAME to your spatial view name.

<?xml version="1.0" encoding="UTF-8"?>
<fdo:DataStore xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:gml="http://www.opengis.net/gml"
xmlns:fdo="http://fdo.osgeo.org/schemas"
xmlns:fds="http://fdo.osgeo.org/schemas/fds">
  <gml:DerivedCRS gml:id="Default">
    <gml:remarks>Spatial context from SqlServer metadata</gml:remarks>
    <gml:srsName>Default</gml:srsName>
    <gml:validArea>
      <gml:boundingBox>
        <gml:pos>-2000000.000000 -2000000.000000</gml:pos>
        <gml:pos>2000000.000000 2000000.000000</gml:pos>
      </gml:boundingBox>
    </gml:validArea>
    <gml:baseCRS
xlink:href="http://fdo.osgeo.org/schemas/feature/crs/#UTM84-10N" />
    <gml:definedByConversion
xlink:href="http://fdo.osgeo.org/coord_conversions#identity" />
    <gml:derivedCRSType
codeSpace="http://fdo.osgeo.org/crs_types">geographic</gml:derivedCRSType>
    <gml:usesCS xlink:href="http://fdo.osgeo.org/cs#default_cartesian" />
  </gml:DerivedCRS>
  <gml:DerivedCRS gml:id="sc_5">
    <gml:remarks>Spatial context from SqlServer metadata</gml:remarks>
    <gml:srsName>sc_5</gml:srsName>
    <gml:validArea>
      <gml:boundingBox>
        <gml:pos>390000.000000 5464000.000000</gml:pos>
        <gml:pos>400000.000000 5469000.000000</gml:pos>
      </gml:boundingBox>
    </gml:validArea>
    <gml:baseCRS
xlink:href="http://fdo.osgeo.org/schemas/feature/crs/#UTM84-10N" />
    <gml:definedByConversion
xlink:href="http://fdo.osgeo.org/coord_conversions#identity" />
    <gml:derivedCRSType
codeSpace="http://fdo.osgeo.org/crs_types">geographic</gml:derivedCRSType>
    <gml:usesCS xlink:href="http://fdo.osgeo.org/cs#default_cartesian" />
  </gml:DerivedCRS>
  <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://fdo.osgeo.org/schemas/feature/dbo"
xmlns:fdo="http://fdo.osgeo.org/schemas"
xmlns:gml="http://www.opengis.net/gml"
xmlns:dbo="http://fdo.osgeo.org/schemas/feature/dbo"
elementFormDefault="qualified" attributeFormDefault="unqualified">
    <xs:element name="SPTIAL_VIEW_NAME" type="dbo:SPTIAL_VIEW_NAMEType"
abstract="false" substitutionGroup="gml:_Feature">
      <xs:key name="SPTIAL_VIEW_NAMEKey">
        <xs:selector xpath=".//SPTIAL_VIEW_NAME" />
        <xs:field xpath="Asset_ID" />
      </xs:key>
    </xs:element>
    <xs:complexType name="SPTIAL_VIEW_NAMEType" abstract="false"
fdo:geometryName="YOUR_GEOM_NAME">
      <xs:annotation>
        <xs:documentation />
        <xs:appinfo source="http://fdo.osgeo.org/schemas" />
      </xs:annotation>
      <xs:complexContent>
        <xs:extension base="gml:AbstractFeatureType">
          <xs:sequence>
            <xs:element name="Asset_ID" minOccurs="0">
              <xs:annotation>
                <xs:documentation />
              </xs:annotation>
              <xs:simpleType>
                <xs:restriction base="xs:string">
                  <xs:maxLength value="30" />
                </xs:restriction>
              </xs:simpleType>
            </xs:element>
            <xs:element name="MI_PRINX">
              <xs:simpleType>
                <xs:restriction base="xs:int" />
              </xs:simpleType>
              <xs:annotation>
                <xs:documentation />
              </xs:annotation>
            </xs:element>
            <xs:element name="YOUR_GEOM_NAME"
type="gml:AbstractGeometryType" fdo:hasMeasure="false"
fdo:hasElevation="false" fdo:srsName="sc_5" fdo:geometricTypes="point curve
surface " fdo:geometryTypes="point multipoint linestring multilinestring
curvestring multicurvestring polygon multipolygon curvepolygon
multicurvepolygon ">
              <xs:annotation>
                <xs:documentation />
              </xs:annotation>
            </xs:element>
          </xs:sequence>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:schema>
  <SchemaMapping xmlns:rdb="http://fdordbms.osgeo.org/schemas"
xmlns="http://www.autodesk.com/isd/fdo/SQLServerSpatialProvider"
textInRow="NotInRow" provider="OSGeo.SQLServerSpatial.3.8" name="dbo">
    <complexType name="SPTIAL_VIEW_NAMEType" tableMapping="Concrete"
identityIsGloballyUnique="false" identitySeed="0" identityIncrement="0"
identityPropertyName="">
      

      <element name="Asset_ID">
        <Column name="Asset_ID" />
      </element>
      <element name="MI_PRINX">
        <Column name="MI_PRINX" />
      </element>
      <element name="YOUR_GEOM_NAME">
        <GeometricColumn name="YOUR_GEOM_NAME" />
      </element>
    </complexType>
  </SchemaMapping>
</fdo:DataStore>



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html