have you looked at the API Docs? http://mapguide.osgeo.org/files/mapguide/docs/2.0/dd/db3/class_mg_agf_reader_writer.htm http://mapguide.osgeo.org/files/mapguide/docs/2.0/d5/da0/class_mg_wkt_reader_writer.htm
z On Mon, May 23, 2011 at 8:38 PM, mahpooya <[email protected]> wrote: > Let me introduce my code > I use php and oracle database. > I have an AGF geometry string ($geometryString in below code) that contain a > circular sector ; > But oracle is not support AGF text format. > Oracle have "SDO_UTIL.FROM_WKTGEOMETRY" that input geometry from wkt. > I want to convert AGF to WKT and insert it to database. > How can i convert it? > > $geometryString="CURVEPOLYGON ((67.894181638047 32.989785090909 > (LINESTRINGSEGMENT (70.229107873737 33.852692612795), CIRCULARARCSEGMENT > (70.38340259381948 32.973385371885676 , 70.2175355016466 > 32.096187451063344))))"; > > $conn = oci_pconnect('gis', '123456', '127.0.0.1:1521/orcl'); > > if (!$conn) { > $e = oci_error(); > trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); > } > $sql='INSERT INTO "GIS"."P" ("ID_AUTO", "MYINT", "MYSTR", "GEOMETRY") VALUES > (1, 123, \'asd\', SDO_UTIL.FROM_WKTGEOMETRY(\''.$geometryString.'\') )'; > > $stid = oci_parse($conn, $sql); > > $r = oci_execute($stid, OCI_NO_AUTO_COMMIT); > if (!$r) { > $e = oci_error($stid); > oci_rollback($conn); // rollback changes > trigger_error(htmlentities($e['message']), E_USER_ERROR); > } > ________________________________ > View this message in context: Re: how to convert agf to wkt? > Sent from the MapGuide Users mailing list archive at Nabble.com. > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
