epn-vespa / tutorials

VESPA tutorials
3 stars 7 forks source link

surfaces>vo-qgis-plugin plugin for QGIS3 and ADQL query #21

Open Shronim opened 3 years ago

Shronim commented 3 years ago

on the tutorial: https://github.com/epn-vespa/tutorials/blob/master/surfaces/vo_qgis_plugin/vo-qgis-plugin.md

only the link for the plugin for QGIS2 is attached. maybe the link for the QGIS3 plugin should be mentioned as well "https://github.com/Hyradus/VO_QGIS3.x_plugin"

in the same tutorial, at "2.0 Query DaCHS with ADQL": copying and pasting the request gave an error.

Screenshot 2021-06-16 at 13 40 27

instead the following worked:

  1. goto page: https://epn1.epn-vespa.jacobs-university.de/__system__/adql/query/form

  2. paste: "select cra.granule_uid, cri., cra.diameter, cra.feature_name, cra.crater_morphology_3 FROM (select from mars_craters.epn_core as cra2 where cra2.diameter > 50 and cra2.diameter < 80) as cra INNER JOIN (select * from planetserver_crism.epn_core as cri2 where cri2.sensor_id='L') as cri ON (1=INTERSECTS( cri.s_region, cra.s_region ))"

    • where "crism.epn_core" is replaced with "planetserver_crism.epn_core"