[mapguide-users] How to best consume Map Data

TravellingNomad prasanth_sasidharan at infosys.com
Wed Sep 7 04:51:11 PDT 2016

That was very informative. Thanks for your help.

From: Hans Milling [via OSGeo.org] [mailto:ml-node+s1560n5284464h62 at n6.nabble.com]
Sent: 07 September 2016 19:40
To: Prasanth Sasidharan <Prasanth_Sasidharan at infosys.com>
Subject: Re: How to best consume Map Data

I know that oracle as a SDO_UTIL.FROM_WKTGEOMETRY you can use in an insert or update statement.

You need to convert your points to WKT (Well Known Text).
If you have the following data points that should turn into a polygon:
x, y
30, 10
40, 40
20, 40
10, 20
30, 10

TO write this in WKT format (Note that spaces devide each x and y and that comma devide each coordinate pair):
POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))

You can do an:
insert into mypolygons (attr1, attr2, geometrycolumn) Values(1, 'Name', SDO_UTIL.FROM_WKTGEOMETRY('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))');

The table has to have a geometry column of type SDO_GEOMETRY to store the geometry data and for MapGuide to be able to display these. The geometry column you specify an SRID that tells the database what coordinate system the coordinates are in. Two system are widely used. Either Latitude/Longitude in WGS84 that has SPID/EPSG 4326 or you are using your local EUREF89 UTM zone coordinates (A lot of different ID's are used, you can find them with a simple Google search).

Best regards
  Hans Milling...
If you reply to this email, your message will be added to the discussion below:
To unsubscribe from How to best consume Map Data, click here<http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5284418&code=cHJhc2FudGhfc2FzaWRoYXJhbkBpbmZvc3lzLmNvbXw1Mjg0NDE4fDEzMTYzMzg5NzA=>.

View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-best-consume-Map-Data-tp5284418p5284486.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20160907/1c598691/attachment.html>

More information about the mapguide-users mailing list