Skip to content

Instantly share code, notes, and snippets.

@exitflynn

exitflynn/querying_proba2_dslp.py

Created February 12, 2023 05:13
Show Gist options
  • Save exitflynn/ffa486170b93091e244ebc4c4e6c2469 to your computer and use it in GitHub Desktop.
Save exitflynn/ffa486170b93091e244ebc4c4e6c2469 to your computer and use it in GitHub Desktop.
Download ZIP
an example of the response received while querying proba-2 in-situ dslp data to help in development of a sunpy client
Raw
querying_proba2_dslp.py
import requests
import json
r = requests.get("http://p2sa.esac.esa.int/p2sa-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=JSON&PHASE=RUN&QUERY=SELECT * FROM p2sa.v_file WHERE (file_date >= '2014-10-01 00:00:00') AND (file_date <= '2014-10-31 00:00:00') AND (file_type in ('DSLP_DERIVED')) ORDER BY file_date ASC")
r.json()
"""
=================================(OUTPUT)==================================
{'metadata': [{'name': 'calibrated', 'datatype': 'BOOLEAN'},
{'name': 'extension', 'datatype': 'VARCHAR'},
{'name': 'file_date', 'datatype': 'TIMESTAMP', 'xtype': 'adql:TIMESTAMP'},
{'name': 'file_name', 'datatype': 'VARCHAR'},
{'name': 'file_oid', 'datatype': 'INTEGER'},
{'name': 'file_path', 'datatype': 'VARCHAR'},
{'name': 'file_size', 'datatype': 'BIGINT'},
{'name': 'file_type', 'datatype': 'VARCHAR'},
{'name': 'instrument_name', 'datatype': 'VARCHAR'},
{'name': 'instrument_oid', 'datatype': 'INTEGER'},
{'name': 'processing_level', 'datatype': 'VARCHAR'}],
'data': [['false',
'CDF',
'2014-10-01 00:00:00.0',
'DERIVED_SLPA_20141001.cdf',
'136478',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19815408',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-01 00:00:00.0',
'DERIVED_SLPB_20141001.cdf',
'136479',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19788276',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-02 00:00:00.0',
'DERIVED_SLPA_20141002.cdf',
'136480',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19186136',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-02 00:00:00.0',
'DERIVED_SLPB_20141002.cdf',
'136481',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19767332',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-03 00:00:00.0',
'DERIVED_SLPA_20141003.cdf',
'136482',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19816836',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-03 00:00:00.0',
'DERIVED_SLPB_20141003.cdf',
'136483',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19795416',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-04 00:00:00.0',
'DERIVED_SLPA_20141004.cdf',
'136484',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15200588',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-04 00:00:00.0',
'DERIVED_SLPB_20141004.cdf',
'136485',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'14230024',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-05 00:00:00.0',
'DERIVED_SLPA_20141005.cdf',
'136486',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'10987988',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-05 00:00:00.0',
'DERIVED_SLPB_20141005.cdf',
'136487',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'12154664',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-06 00:00:00.0',
'DERIVED_SLPA_20141006.cdf',
'136488',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15503800',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-06 00:00:00.0',
'DERIVED_SLPB_20141006.cdf',
'136489',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15348148',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-07 00:00:00.0',
'DERIVED_SLPA_20141007.cdf',
'136490',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'17531084',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-07 00:00:00.0',
'DERIVED_SLPB_20141007.cdf',
'136491',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19487920',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-08 00:00:00.0',
'DERIVED_SLPA_20141008.cdf',
'136492',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19743056',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-08 00:00:00.0',
'DERIVED_SLPB_20141008.cdf',
'136493',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19813028',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-09 00:00:00.0',
'DERIVED_SLPA_20141009.cdf',
'136494',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19810648',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-09 00:00:00.0',
'DERIVED_SLPB_20141009.cdf',
'136495',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19805412',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-10 00:00:00.0',
'DERIVED_SLPA_20141010.cdf',
'136496',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'16792808',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-10 00:00:00.0',
'DERIVED_SLPB_20141010.cdf',
'136497',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15851280',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-11 00:00:00.0',
'DERIVED_SLPA_20141011.cdf',
'136498',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15956476',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-11 00:00:00.0',
'DERIVED_SLPB_20141011.cdf',
'136499',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'14054380',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-12 00:00:00.0',
'DERIVED_SLPA_20141012.cdf',
'136500',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'11303576',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-12 00:00:00.0',
'DERIVED_SLPB_20141012.cdf',
'136501',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'9778472',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-13 00:00:00.0',
'DERIVED_SLPA_20141013.cdf',
'136502',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15355764',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-13 00:00:00.0',
'DERIVED_SLPB_20141013.cdf',
'136503',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'16276348',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-14 00:00:00.0',
'DERIVED_SLPA_20141014.cdf',
'136504',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19808268',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-14 00:00:00.0',
'DERIVED_SLPB_20141014.cdf',
'136505',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19799224',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-15 00:00:00.0',
'DERIVED_SLPA_20141015.cdf',
'136506',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19775424',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-15 00:00:00.0',
'DERIVED_SLPB_20141015.cdf',
'136507',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19754480',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-16 00:00:00.0',
'DERIVED_SLPA_20141016.cdf',
'136508',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19807792',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-16 00:00:00.0',
'DERIVED_SLPB_20141016.cdf',
'136509',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19796844',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-17 00:00:00.0',
'DERIVED_SLPA_20141017.cdf',
'136510',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'18959084',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-17 00:00:00.0',
'DERIVED_SLPB_20141017.cdf',
'136511',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19798272',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-18 00:00:00.0',
'DERIVED_SLPA_20141018.cdf',
'136512',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'13598848',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-18 00:00:00.0',
'DERIVED_SLPB_20141018.cdf',
'136513',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'11917616',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-19 00:00:00.0',
'DERIVED_SLPA_20141019.cdf',
'136514',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'11958076',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-19 00:00:00.0',
'DERIVED_SLPB_20141019.cdf',
'136515',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'9321512',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-20 00:00:00.0',
'DERIVED_SLPA_20141020.cdf',
'136516',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'14806460',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-20 00:00:00.0',
'DERIVED_SLPB_20141020.cdf',
'136517',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'16047868',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-21 00:00:00.0',
'DERIVED_SLPA_20141021.cdf',
'136518',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'18048496',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-21 00:00:00.0',
'DERIVED_SLPB_20141021.cdf',
'136519',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19377488',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-22 00:00:00.0',
'DERIVED_SLPA_20141022.cdf',
'136520',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19765904',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-22 00:00:00.0',
'DERIVED_SLPB_20141022.cdf',
'136521',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19814456',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-23 00:00:00.0',
'DERIVED_SLPA_20141023.cdf',
'136522',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19787800',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-23 00:00:00.0',
'DERIVED_SLPB_20141023.cdf',
'136523',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19786848',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-24 00:00:00.0',
'DERIVED_SLPA_20141024.cdf',
'136524',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19782088',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-24 00:00:00.0',
'DERIVED_SLPB_20141024.cdf',
'136525',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19793036',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-25 00:00:00.0',
'DERIVED_SLPA_20141025.cdf',
'136526',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'16022640',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-25 00:00:00.0',
'DERIVED_SLPB_20141025.cdf',
'136527',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'14003448',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-26 00:00:00.0',
'DERIVED_SLPA_20141026.cdf',
'136528',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'10074068',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-26 00:00:00.0',
'DERIVED_SLPB_20141026.cdf',
'136529',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'10569584',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-27 00:00:00.0',
'DERIVED_SLPA_20141027.cdf',
'136530',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15186784',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-27 00:00:00.0',
'DERIVED_SLPB_20141027.cdf',
'136531',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'15193448',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-28 00:00:00.0',
'DERIVED_SLPA_20141028.cdf',
'136532',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19774948',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-28 00:00:00.0',
'DERIVED_SLPB_20141028.cdf',
'136533',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19801128',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-29 00:00:00.0',
'DERIVED_SLPA_20141029.cdf',
'136534',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19044764',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-29 00:00:00.0',
'DERIVED_SLPB_20141029.cdf',
'136535',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19774472',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-30 00:00:00.0',
'DERIVED_SLPA_20141030.cdf',
'136536',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'16967024',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-30 00:00:00.0',
'DERIVED_SLPB_20141030.cdf',
'136537',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'14146724',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-31 00:00:00.0',
'DERIVED_SLPA_20141031.cdf',
'136538',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19826356',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A'],
['false',
'CDF',
'2014-10-31 00:00:00.0',
'DERIVED_SLPB_20141031.cdf',
'136539',
'\\/p2sa\\/p2saps\\/science\\/dslp\\/dslp_derived\\/2014\\/10',
'19634528',
'DSLP_DERIVED',
'DSLP',
'3',
'N\\/A']]}
"""
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment