We are using Geoserver to serve Oracle Multipoint geometries as GeoJSON for
use in Leaflet maps. The problem is for a multipoint oracle geometry only
one (the first) point is returned in the GeoJSON.
I have not been able to find much regarding this specific issue by
searching the Geoserver Mailing List Archives, however, this has been
mentioned in the GeoTools Issue Tracker here:
https://osgeo-org.atlassian.net/browse/GEOT-5018
Here is an example of our sdo_geometry as stored in Oracle:
MDSYS.SDO_GEOMETRY(2005,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1,3,1,1,5,1,1,7,1,1,9,1,1,11,1,1,13,1,1,15,1,1,17,1,1,19,1,1,21,1,1,23,1,1,25,1,1,27,1,1,29,1,1),MDSYS.SDO_ORDINATE_ARRAY(-94.5460377524086,20.6982790126949,-90.4738630431407,31.2499984169595,-90.455139056471,31.2500183780065,-90.4768843004608,31.2475569741882,-90.4677293254458,31.2475623172449,-90.4635038599556,31.247567709336,-90.4741218614148,31.2474940749101,-90.4594171576172,31.2465043475159,-90.4523872566151,31.245139626753,-90.453889962981,31.2449028444609,-90.45355210797,31.2436239106601,-90.4532291894738,31.2423062682822,-90.4462047630709,31.2321101141883,-90.4529960800564,31.2298086565983,-90.4633401444988,31.2263420787051))
And here is the GeoJSON as generated by GeoServer:
{"type":"FeatureCollection","totalFeatures":1,"features":[{"type":"Feature","id":"FMS_TEST.32778","geometry":{"type":"MultiPoint","coordinates":[[-94.5460377524086,20.6982790126949]]},"geometry_name":"GEOMETRY","properties":{"PROJECT_NO":"100829","PROJECT_DET":1000,"EXT_COR_PROJ_NO":"STP-0310-00(007)","CONV_PROJ_NO":"48-0310-00-007-10","PLAN_LINK":"4333_STP-0310(7)A","DELIVERY":"05","URL":"
http://some_link.com","SMB":"\\\\some_directory","P2":"http://anotherlink.
com <http://p2/p2projectlink.aspx?project_no=100829&project_det=1000>
","PDPM":null,"CREATE_OPER_ID":"RWD","CREATE_DATE":"2010-09-29T19:40:34Z","UPDATE_OPER_ID":"RWD","UPDATE_DATE":"2013-04-16T17:32:02Z","ENV":null,"DEPT":1}}],"crs":{"type":"EPSG","properties":{"code":"4326"}}}
I am wondering if this should be submitted (as a bug?) on the Geoserver
side as well.
Any update/advice is greatly appreciated,
Chris
see also:
https://osgeo-org.atlassian.net/browse/GEOT-5018
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
