That was very informative. Thanks for your help.
From: Hans Milling [via OSGeo.org]
[mailto:[email protected]]
Sent: 07 September 2016 19:40
To: Prasanth Sasidharan <[email protected]>
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:
http://osgeo-org.1560.x6.nabble.com/How-to-best-consume-Map-Data-tp5284418p5284464.html
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=>.
NAML<http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
--
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._______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
