[JPP-Devel] SVN: [6133] core/trunk
Revision: 6133 http://sourceforge.net/p/jump-pilot/code/6133 Author: michaudm Date: 2019-02-21 07:21:47 + (Thu, 21 Feb 2019) Log Message: --- Add an option to connect to a WMS with unchecked certificate authority Modified Paths: -- core/trunk/ChangeLog core/trunk/src/com/vividsolutions/jump/workbench/model/WMSLayer.java core/trunk/src/com/vividsolutions/jump/workbench/ui/plugin/wms/EditWMSQueryPanel.java core/trunk/src/com/vividsolutions/jump/workbench/ui/plugin/wms/URLWizardPanel.java core/trunk/src/com/vividsolutions/wms/AbstractWMSRequest.java core/trunk/src/com/vividsolutions/wms/FeatureInfoRequest.java core/trunk/src/com/vividsolutions/wms/WMSRequest.java core/trunk/src/com/vividsolutions/wms/WMService.java core/trunk/src/com/vividsolutions/wms/ui/WMSViewer.java core/trunk/src/language/jump.properties core/trunk/src/language/jump_cz.properties core/trunk/src/language/jump_de.properties core/trunk/src/language/jump_es.properties core/trunk/src/language/jump_fi.properties core/trunk/src/language/jump_fr.properties core/trunk/src/language/jump_hu.properties core/trunk/src/language/jump_it.properties core/trunk/src/language/jump_ja_JP.properties core/trunk/src/language/jump_ml.properties core/trunk/src/language/jump_pt.properties core/trunk/src/language/jump_pt_BR.properties core/trunk/src/language/jump_ta_IN.properties core/trunk/src/language/jump_te.properties core/trunk/src/language/jump_zh_CN.properties core/trunk/src/language/jump_zh_HK.properties core/trunk/src/org/openjump/core/ui/plugin/file/open/OpenProjectWizard.java core/trunk/src/org/openjump/core/ui/plugin/wms/WMSLegendPlugIn.java Modified: core/trunk/ChangeLog === --- core/trunk/ChangeLog2019-02-20 14:38:45 UTC (rev 6132) +++ core/trunk/ChangeLog2019-02-21 07:21:47 UTC (rev 6133) @@ -3,6 +3,9 @@ # 2. make sure that lines break at 80 chars for constricted display situations #< 80 chars --># +2019-02-21 mmichaud + * Add an option to connect to a WMS with unchecked certificate authority + 2019-02-19 Nicolas Ribot * Corrected typo in SpatialiteDSMetadata datasetInfoQuery string preventing spatial tables to be listed Modified: core/trunk/src/com/vividsolutions/jump/workbench/model/WMSLayer.java === --- core/trunk/src/com/vividsolutions/jump/workbench/model/WMSLayer.java 2019-02-20 14:38:45 UTC (rev 6132) +++ core/trunk/src/com/vividsolutions/jump/workbench/model/WMSLayer.java 2019-02-21 07:21:47 UTC (rev 6133) @@ -38,6 +38,8 @@ import java.lang.ref.Reference; import java.lang.ref.SoftReference; import java.net.URL; +import java.security.KeyManagementException; +import java.security.NoSuchAlgorithmException; import java.util.ArrayList; import java.util.Collections; import java.util.List; @@ -84,13 +86,13 @@ } public WMSLayer(LayerManager layerManager, String serverURL, String srs, - List layerNames, String format, String version) throws IOException { + List layerNames, String format, String version) throws IOException, KeyManagementException, NoSuchAlgorithmException { this(layerManager, initializedService(serverURL, version), srs, layerNames, format); } private static WMService initializedService(String serverURL, String version) - throws IOException { + throws IOException, KeyManagementException, NoSuchAlgorithmException { WMService initializedService = new WMService(serverURL, version); initializedService.initialize(); return initializedService; @@ -150,7 +152,7 @@ this.alpha = alpha; } - public Image createImage(LayerViewPanel panel) throws IOException { + public Image createImage(LayerViewPanel panel) throws IOException, KeyManagementException, NoSuchAlgorithmException { MapRequest request = createRequest(panel); URL newURL = request.getURL(); @@ -181,7 +183,7 @@ return new BoundingBox(srs, e); } - public MapRequest createRequest(LayerViewPanel panel) throws IOException { + public MapRequest createRequest(LayerViewPanel panel) throws IOException, KeyManagementException, NoSuchAlgorithmException { MapRequest request = getService().createMapRequest(); request.setBoundingBox(toBoundingBox(srs, panel.getViewport() .getEnvelopeInModelCoordinates())); @@ -241,7 +243,7 @@ return blackboard; } - public WMService getService() throws IOException { + public WMService getService() throws IOException, KeyManagementException, NoSuchAlgorithmException { if (service == null) { Assert.isTrue(serverURL != null); setService(initializedService(serverURL, wmsVersion)); @@ -281,7 +283,7 @@
Re: [JPP-Devel] Slow parsing of date field from Spatialite database
hmmm GeometryColumn gc = dsm.getGeometryColumn(query.getDatasetName(), query.getGeometryAttributeName()); if (gc.isIndexed()) { gc is return as Null here. dunno why, but Nico should know :).. ede On 19.02.2019 21:08, Rahkonen Jukka (MML) wrote: > Hi, > > In r6130 the building of layer list from Geopackage datastore works (thanks > Nicolas) and parsing fields with the date/datetime data is very fast (thanks > Ede). > There seems to be still something wrong with adding Geopackage tables into > map through the layer list. Error gives a hint that building spatial index > query fails but the same error happens also if I drop the spatial index from > the geopackage db. > > java.lang.NullPointerException > at > com.vividsolutions.jump.datastore.spatialite.SpatialiteSQLBuilder.buildSpatialIndexFilter(SpatialiteSQLBuilder.java:157) > at > com.vividsolutions.jump.datastore.spatialite.SpatialiteSQLBuilder.buildBoxFilter(SpatialiteSQLBuilder.java:116) > at > com.vividsolutions.jump.datastore.spatialite.SpatialiteSQLBuilder.getSQL(SpatialiteSQLBuilder.java:39) > at > com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreDataSource.createFeatureCollection(DataStoreDataSource.java:165) > at > com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreDataSource$1.executeQuery(DataStoreDataSource.java:101) > at > com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreDataSource$1.executeQuery(DataStoreDataSource.java:112) > at > org.openjump.core.ui.plugin.datastore.AddDataStoreLayerWizard.executeQuery(AddDataStoreLayerWizard.java:175) > at > org.openjump.core.ui.plugin.datastore.AddDataStoreLayerWizard.load(AddDataStoreLayerWizard.java:164) > at > org.openjump.core.ui.plugin.datastore.AddDataStoreLayerWizard.createLayer(AddDataStoreLayerWizard.java:138) > at > org.openjump.core.ui.plugin.datastore.AddDataStoreLayerWizard.createLayers(AddDataStoreLayerWizard.java:156) > at > org.openjump.core.ui.plugin.datastore.AddDataStoreLayerWizard.run(AddDataStoreLayerWizard.java:71) > at > org.openjump.core.ui.plugin.file.OpenWizardPlugIn.run(OpenWizardPlugIn.java:110) > at > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:151) > > -Jukka- > > -Alkuperäinen viesti- > Lähettäjä: edgar.sol...@web.de > Lähetetty: tiistai 19. helmikuuta 2019 17.27 > Vastaanottaja: Rahkonen Jukka (MML) ; > jump devel ; Nicolas Ribot > > Aihe: Re: VS: [JPP-Devel] Slow parsing of date field from Spatialite database > > Jukka, > > i locally reverted Nico's last change to have the datastore tables listed and > work on the date/time slowness. OJ r6129 should fix the slow date issue with > the datastore functionality in OJ CORE. > when Nico fixes the table listing issue you should be able to double check it. > > DB Query extension is a somewhat harder nut to crack as i would have to setup > the external extension sources to patch them. do you think it is worth the > effort or urgently needed? > > ..ede > > On 19.02.2019 13:44, Rahkonen Jukka (MML) wrote: >> Hi, >> >> Here you can get a gpkg that works with DB Query >> http://latuviitta.org/downloads/stones.gpkg. As I told, DB Query can't read >> random_points.gpkg but the standard Run datastore query tool has no problem >> with that. >> Advice for reading gpkg can be found from the attached document. >> >> OJ build 5966 can build the layer list for the gpkg datastore, but build >> 5977 can't so something has happened in between. >> >> >> -Jukka- >> >> >> -Alkuperäinen viesti- >> Lähettäjä: edgar.sol...@web.de >> Lähetetty: tiistai 19. helmikuuta 2019 13.54 >> Vastaanottaja: Rahkonen Jukka (MML) >> >> Aihe: Re: [JPP-Devel] Slow parsing of date field from Spatialite >> database >> >> hey Jukka, >> >> not familiar with the drivers. could you give a short step-by-step for both >> (Run Datastore Query, DB Query) ? >> >> thanks.. ede >> >> On 17.02.2019 22:07, Rahkonen Jukka (MML) wrote: >>> Hi, >>> >>> Test geopackage finally ready here >>> http://latuviitta.org/downloads/random_points.gpkg. It contains >>> random_points: 105000 points with a date column >>> random_points_without_date : same points but date column dropped >>> >>> Data were created with the OpenJUMP Bean tools and GDAL. Observations: >>> 1) GeoPackage does not work with OpenJDK 13. Connection to SQLite is OK but >>> selecting spatial data fails. Use JRE 8 instead for these tests. >>> 2) When I create a new spatialite connection into gpkg file OpenJUMP >>> creates the connection but it does not find spatial tables and >>> adding data to the map is not possible through the Add data... route >>> 3) Run datastore query, however, does work. The test will be simply >>> to run select * from random_points; select * from >>> random_points_without_date; >>> >>> The first query creates a map in 30 seconds, the second one in one second. >>>
Re: [JPP-Devel] Metric distances for lat long coordinates
On Wed, 20 Feb 2019 10:20:14 +0100 Nicolas Ribot wrote: > Hi, > > > > > Sounds useful to me. But i am not sure its so easy given that the > > length of a degree is changing, but there may be some formulas out > > there (even web pages) that calculate great circle distances ... > > mhm... i think somewhere i even used such, once. > > > > Cheers, > > Stefan > > > > Yes, it is based on great circles computation. I used formula from > > this > rather complete page : > https://www.movable-type.co.uk/scripts/latlong.html > > Nicolas That page is a good source. Here's a java implementation: https://sourceforge.net/p/sarmanager/code/HEAD/tree/trunk/SMT/src/net/aa3sd/SMT/math/SphericalUtility.java#l486 with a very basic unit test: https://sourceforge.net/p/sarmanager/code/HEAD/tree/trunk/SMT/src/net/aa3sd/SMT/test/TestSphericalUtilityMethods.java#l64 Derived from the c implementation in xastir https://github.com/Xastir/Xastir/blob/master/src/util.c#L2913 Key choice is what value to use for the mean radius of the Earth. -Paul -- Paul J. Morris Biodiversity Informatics Manager Museum of Comparative Zoölogy, Harvard University m...@morris.net AA3SD PGP public key available ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [6132] core/trunk/lib/plus/OpenKLEMOJ-20190122.jar
Revision: 6132 http://sourceforge.net/p/jump-pilot/code/6132 Author: edso Date: 2019-02-20 14:38:45 + (Wed, 20 Feb 2019) Log Message: --- remove double OpenKLEM jar Removed Paths: - core/trunk/lib/plus/OpenKLEMOJ-20190122.jar Deleted: core/trunk/lib/plus/OpenKLEMOJ-20190122.jar === (Binary files differ) ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] Slow parsing of date field from Spatialite database
Hi Ede, DB Query does have some problems with dates and it would be nice to get them fixed. The plugin can't parse at all data with date fields from Oracle, Geopackage, and Spatialite databases. Only thing that used can do is to write SQL select so that date fields are not selected. Dates are not a problem with PostGIS. But this is not a new issue so I think that DB Query Extension may stay as it is. -Jukka- -Alkuperäinen viesti- Lähettäjä: edgar.sol...@web.de Lähetetty: keskiviikko 20. helmikuuta 2019 12.01 Vastaanottaja: OpenJump develop and use ; Rahkonen Jukka (MML) Aihe: Re: [JPP-Devel] Slow parsing of date field from Spatialite database Jukka, On 19.02.2019 21:08, Rahkonen Jukka (MML) wrote: > and parsing fields with the date/datetime data is very fast (thanks Ede) does that mean DB Query Extension can stay as it is? ..ede ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] SVN: [6131] core/trunk/ChangeLog
Revision: 6131 http://sourceforge.net/p/jump-pilot/code/6131 Author: edso Date: 2019-02-20 10:09:06 + (Wed, 20 Feb 2019) Log Message: --- reformat amend latest commits Modified Paths: -- core/trunk/ChangeLog Modified: core/trunk/ChangeLog === --- core/trunk/ChangeLog2019-02-19 18:15:21 UTC (rev 6130) +++ core/trunk/ChangeLog2019-02-20 10:09:06 UTC (rev 6131) @@ -4,8 +4,15 @@ #< 80 chars --># 2019-02-19 Nicolas Ribot - * Corrected typo in SpatialiteDSMetadata datasetInfoQuery string preventing spatial tables to be listed + * Corrected typo in SpatialiteDSMetadata datasetInfoQuery string preventing +spatial tables to be listed +2019-02-19 ede + * speedup loading GeoPackage datasets w/ date/time columns utilizing +flex feature's lazy conversion + * added format to FlexibleDateParser for dates containing +ISO 8601 time zone "-08; -0800; -08:00" eg. "2019/02/17 22:44:35.325+02" + 2019-02-17 ede * PLUS upgrade KML extension - 0.2.5 (2019-02-17) also read if no exists ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] Slow parsing of date field from Spatialite database
Jukka, On 19.02.2019 21:08, Rahkonen Jukka (MML) wrote: > and parsing fields with the date/datetime data is very fast (thanks Ede) does that mean DB Query Extension can stay as it is? ..ede ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
Re: [JPP-Devel] Metric distances for lat long coordinates
Hi, > > Sounds useful to me. But i am not sure its so easy given that the length > of a degree is changing, but there may be some formulas out there (even web > pages) that calculate great circle distances ... mhm... i think somewhere i > even used such, once. > > Cheers, > Stefan > > Yes, it is based on great circles computation. I used formula from this rather complete page : https://www.movable-type.co.uk/scripts/latlong.html Nicolas ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel