Rudy,
define a source data store for your Oracle instance:
http://docs.geoserver.org/latest/en/user/data/app-schema/data-stores.html
Then write a mapping from a geometry column of your source type (table
or view) to a GML geometry property type. GeoServer will automatically
convert your geometry into GML. For example:
<AttributeMapping>
<targetAttribute>gsml:shape</targetAttribute>
<sourceExpression>
<OCQL>GEOM</OCQL>
</sourceExpression>
</AttributeMapping>
Note that Oracle identifiers such as table and column names are uppercase.
Note also that Oracle geometry columns must be registered in
USER_SDO_GEOM_METADATA:
http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm#i1001937
Kind regards,
Ben.
On 29/06/12 16:58, RudyWI wrote:
> Hi,
>
> I'm using App-schema plugin.
> I try to map Geometry from Oracle database (ex: 2002, 4326, null,
> oracle.sql.ARRAY@566fbd76, oracle.sql.ARRAY@41ffba4f) to GML (ex:
> <gml:LinearRing><gml:posList>143.561948 -38.532217 143.561012 -38.53336
> 143.549986 -38.52647 143.561948 -38.532217</gml:posList></gml:LinearRing>).
>
> How to do it into an App-schema mapping file ?
>
> Best regards,
>
> Rudy.
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/App-schema-How-to-map-Oracle-Geometry-into-GML-tp4984781.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ben Caradoc-Davies <[email protected]>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
