Revision: 6199 http://sourceforge.net/p/jump-pilot/code/6199 Author: elnico Date: 2019-10-09 16:34:35 +0000 (Wed, 09 Oct 2019) Log Message: ----------- bad initial import
Removed Paths: ------------- plug-ins/META-INF/ plug-ins/OjWorldWind.iml plug-ins/Readme.txt plug-ins/notes.txt plug-ins/out/ plug-ins/src/ plug-ins/test-data/ plug-ins/test.bash plug-ins/test.sql plug-ins/tmp/ Deleted: plug-ins/OjWorldWind.iml =================================================================== --- plug-ins/OjWorldWind.iml 2019-10-09 16:31:39 UTC (rev 6198) +++ plug-ins/OjWorldWind.iml 2019-10-09 16:34:35 UTC (rev 6199) @@ -1,24 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<module type="JAVA_MODULE" version="4"> - <component name="NewModuleRootManager" inherit-compiler-output="true"> - <exclude-output /> - <content url="file://$MODULE_DIR$"> - <sourceFolder url="file://$MODULE_DIR$/src" isTestSource="false" /> - </content> - <orderEntry type="inheritedJdk" /> - <orderEntry type="sourceFolder" forTests="false" /> - <orderEntry type="library" name="worldwind" level="project" /> - <orderEntry type="module-library"> - <library> - <CLASSES> - <root url="jar://$MODULE_DIR$/../openjump-svn/core/trunk/target/OpenJUMP-1.14.0-r6083.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MODULE_DIR$/../openjump-svn/core/trunk/target/OpenJUMP-1.14.0-r6083.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="library" name="OJ SVN" level="project" /> - </component> -</module> \ No newline at end of file Deleted: plug-ins/Readme.txt =================================================================== --- plug-ins/Readme.txt 2019-10-09 16:31:39 UTC (rev 6198) +++ plug-ins/Readme.txt 2019-10-09 16:34:35 UTC (rev 6199) @@ -1,10 +0,0 @@ -OpenJump WorldWind plugin - -Installation: - • download WorldWind library (https://github.com/NASAWorldWind/WorldWindJava/releases) and extract zip folder - in the OJ lib/ext folder - - • copy ojworldwind.jar in the lib/ext folder - -Usage: - Deleted: plug-ins/notes.txt =================================================================== --- plug-ins/notes.txt 2019-10-09 16:31:39 UTC (rev 6198) +++ plug-ins/notes.txt 2019-10-09 16:34:35 UTC (rev 6199) @@ -1,30 +0,0 @@ --- 08 aout 2018: --- first attempt to integrate worldwind to OJ: - --- link to plugin in svn oj, folder: -/Volumes/gro/code/java/OJ/openjump-svn/core/trunk/lib/ext -ln -s /Volumes/gro/code/java/OJ/ojworldwind/target/oj-worldwind-1.0-SNAPSHOT.jar . - --- new config to run OJ SVN: -class: com.vividsolutions.jump.workbench.JUMPWorkbench - -vm: -Djava.system.class.loader=com.vividsolutions.jump.workbench.plugin.PlugInClassLoader - -args: -default-plugins scripts/default-plugins.xml - -work dir: /Volumes/gro/code/java/OJ/openjump-svn/core/trunk - --Djava.system.class.loader=com.vividsolutions.jump.workbench.plugin.PlugInClassLoader -default-plugins scripts/default-plugins.xml /Volumes/gro/code/java/OJ/openjump-svn/core/trunk - - --- 12 octobre: --- more tests to integrate OJ layer. - -TODO: --- on remove event dans oj --- todo labels => geojson attributes ? --- other WW features --- lines not in 3D with shapefile format --- choice of pivot format shapefile or geojson --- Layer name ?? --- shapefile layer less aliased than geojson ? \ No newline at end of file Deleted: plug-ins/test.bash =================================================================== --- plug-ins/test.bash 2019-10-09 16:31:39 UTC (rev 6198) +++ plug-ins/test.bash 2019-10-09 16:34:35 UTC (rev 6199) @@ -1,11 +0,0 @@ -#!/usr/bin/env bash -# 12 octobre 2018: -# converts tissot indicatrix from GDB to shapefile for OJ test: -ogr2ogr tissotellipses.shp /Users/nicolas/Downloads/TissotsIndicatrix/TissotsIndicatrix.gdb TissotEllipses - -# loads into postgis to test -shp2pgsql -ID -g geom -s 4326 tissotellipses.shp tissotellipses | psql - - -#batparis from serveur qv -pg_dump -p 5435 -h localhost -t batparis quelleville | psql \ No newline at end of file Deleted: plug-ins/test.sql =================================================================== --- plug-ins/test.sql 2019-10-09 16:31:39 UTC (rev 6198) +++ plug-ins/test.sql 2019-10-09 16:34:35 UTC (rev 6199) @@ -1,147 +0,0 @@ --- 12 octobre 2018: --- test for 4326 objects : 3D, etc - -select st_summary(geom), st_asewkt(geom) -from tissotellipses; - --- adds 3D: - -alter table tissotellipses alter column geom type geometry(polygon, 4326) using st_geometryN(geom, 1); - -select st_asewkt(geom) -from fdr; - -drop table fdr_simple; -create table fdr_simple as - select id, geom - from fdr - tablesample system(10) - ; - --- sample -create table fdr_simple2 as select * from ta; - -drop table fdr_fir_simple; -create table fdr_fir_simple as -select flight_id, st_simplifypreservetopology(geom, 0.0025) -from fdr_fir; - --- batiments 3D paris: -alter table batparis alter column geom type geometry(multipolygon, 4326) using st_transform(st_setsrid(geom, 2154), 4326); -create index batparis_geom_gist on batparis using gist (geom); -analyse batparis; - --- transform to 3D -select gid, altitude, height, hauteur_ign, hauteur_osm, st_asewkt(geom) -from batparis; - --- by boundary + set point= pas terrible -with tmp as ( - select gid, height, st_dump(st_boundary(geom)) as d - from batparis -) select gid, height, st_asewkt(st_setpoint( - st_force3d((d).geom), - g-1, - st_makePoint( - st_X(st_pointN((d).geom, g)), - st_Y(st_pointN((d).geom, g)), - height))) as geom -from tmp t cross join generate_series(1, st_numpoints((d).geom)) as g; - -with tmp as ( - select gid, height, st_dump(st_boundary(geom)) as d - from batparis - limit 10 - ) select gid, height, g, st_numpoints((d).geom), (d).path -from tmp t cross join generate_series(1, st_numpoints((d).geom)) as g; - --- par dumppoints: -drop table batparis3d; -create table batparis3d as - with tmp as ( - select gid, height, altitude, st_dumpPoints(st_boundary(geom)) as d - from batparis - where st_numgeometries(geom) = 1 - -- where gid = 2885 - ), tmp1 as ( - select gid,height, altitude,(d).path, - st_makePoint(st_X((d).geom), st_Y((d).geom), altitude + 50) as newgeom - from tmp t - ), tmp2 as ( - select gid, path [ 1 ] as path, height, st_makeline(newgeom order by path [2]) as geom - from tmp1 - group by gid, path [ 1 ], height - ), tmp3 as ( - select gid, height, array_agg(geom order by path) as geomarr - from tmp2 - group by gid, height - ) select gid, height, - st_setSRID(st_makepolygon(geomarr[1], geomarr[2:]), 4326)::geometry(polygonz, 4326) as geom - -- st_isclosed(geomarr[1]), geomarr[2:] - from tmp3; - -alter table batparis3d add primary key (gid); -create index batparis3d_geom_gist on batparis3d using gist(geom); -vacuum analyse batparis3d; - -select st_asewkt(geom) -from batparis3d; - -select st_astext(geom) -from batparis -where gid = 2885; - -select st_isvalidreason(geom) -from batparis3d -where not st_isvalid(geom); - -select min(height), max(height) -from batparis; - -select ('{1, 2, 3}'::int[])[2:]; - -with tmp as ( - select gid, name, geom::box2d as e from country -) select * -from tmp -where st_xmin(e) < -180.0; - -update country set geom = st_buffer(geom, -0.001) -where gid = 156; - --- 16 octobre 2018: --- test custom height generation from countries to diplay extruded polygons: -select c.name -from country c; - --- table population -create table country_pop ( - id int primary key , - name text, - continent_region text, - stat_region text, - pop2016 bigint, - pop2017 bigint, - change text -); - -copy country_pop from '/Users/nicolas/tmp/country_pop.csv' with (format csv, header false, delimiter ','); - --- some cleanup -select name, regexp_replace(name, E'\\[.*\\]', '') as newname -from country_pop; - -select format('|%s|', name), format('|%s|', trim(both ' ' from name)) -from country_pop; --- hou hugly space char --- | Jordan| - -update country_pop set name = ltrim(regexp_replace(name, E'\\[.*\\]', '')); -update country_pop set name = trim(both ' ' from name); - --- must have an Z coord > 0 for extrusion -drop table country_stats; -create table country_stats as -select c.gid, c.name, p.pop2016, p.pop2017, p.pop2017 * 100 * 1000/(select sum(pop2017)::float from country_pop) as height, - st_geomfromewkt(replace(replace(st_asewkt(st_force3d(c.geom)), ' 0,', ' 10,'), ' 0)', ' 10)')) as geom -from country as c left join country_pop as p on c.name = p.name; _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel