Hi Andrea,
Srid 90112 is almost th same as 28992 = epsg.
Can you try with this one?
What is the explanation that the testcases with gtype=2002 are not visualised
and gtype=2003 are correctly visualised with srid=90112?
Ron
On 2 mei 2015, at 16:03, Andrea Aime <[email protected]> wrote:
> On Thu, Apr 30, 2015 at 1:31 PM, Ron Lindhoudt <[email protected]> wrote:
> Maybe it works for the test coordinate system (srid=32632) but not for my
> coordinate system (srid=90112).
>
> Could you test it with the following:
>
> String sql = "CREATE TABLE CURVES ("
> + "id INT, name VARCHAR(64), geometry MDSYS.SDO_GEOMETRY,
> PRIMARY KEY(id))";
> run(sql);
>
> sql = "INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME,
> DIMINFO, SRID ) "
> + "VALUES
> ('curves','geometry',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',0,1000000,0.0005),
> "
> + "MDSYS.SDO_DIM_ELEMENT('Y',0,1000000,0.0005)), 90112)";
> run(sql);
>
> sql = "CREATE INDEX CURVES_GEOMETRY_IDX ON CURVES(GEOMETRY) INDEXTYPE
> IS MDSYS.SPATIAL_INDEX" //
> + " PARAMETERS ('SDO_INDX_DIMS=2')";
> run(sql);
>
> // adding data
> sql = "INSERT INTO CURVES VALUES (0, 'Arc segment', "
> + "sdo_geometry (2002, 90112, null, sdo_elem_info_array
> (1,2,2), sdo_ordinate_array (263333, 472000, 263383, 472050, 263433,
> 472000)))";
> run(sql);
>
> This is not visualised in my case.
>
>
> Yep, they are not visualized for me either. You have an odd coordinate system
> there:
>
> PROJCS["Netherlands National System",
> GEOGCS["Netherlands Bessel",
> DATUM["Netherlands Bessel",
> SPHEROID["Bessel 1841", 6377397.155, 299.1528128]],
> PRIMEM["Greenwich", 0.0],
> UNIT["degree", 0.017453292519943295],
> AXIS["Longitude", EAST],
> AXIS["Latitude", NORTH]],
> PROJECTION["Stereographic"],
> PARAMETER["central_meridian", 5.387639],
> PARAMETER["latitude_of_origin", 52.156161000000004],
> PARAMETER["scale_factor", 0.999908],
> PARAMETER["false_easting", 155000.0],
> PARAMETER["false_northing", 463000.0],
> UNIT["m", 1.0],
> AXIS["x", EAST],
> AXIS["y", NORTH]]
>
> I could not find an equivalent epsg code for it, do you know if there is one?
> For this one, I did setup a EPSG:4326 and used "reproject native to declared",
> and got not output.
>
> But when I force EPSG:404000 instead + force declared, I get it to display
> fine:
>
> <nurc-CURVES2.png>
>
> "Reproject native to declared" is rarely used, so that might be the cause, or
> it can
> be related to reprojection. Not sure yet.
>
> Cheers
> Andrea
>
>
>
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/NWWaa2 for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
> file/s allegato/i sono da considerarsi strettamente riservate. Il loro
> utilizzo è consentito esclusivamente al destinatario del messaggio, per le
> finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio
> senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia
> via e-mail e di procedere alla distruzione del messaggio stesso,
> cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo
> anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per
> finalità diverse, costituisce comportamento contrario ai principi dettati dal
> D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named addressee(s).
> If you are not the intended recipient, please contact immediately the sender
> by telephone, fax or e-mail and delete the information in this message that
> has been received in error. The sender does not give any warranty or accept
> liability as the content, accuracy or completeness of sent messages and
> accepts no responsibility for changes made after they were sent or for other
> risks which arise as a result of e-mail transmission, viruses, etc.
>
>
> -------------------------------------------------------
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
