def get_static_info(self, level_name=None, x_index=None, y_index=None, tile_type_id=None):
        """Retrieve static (i.e. not time varying) data for specified processing level(s) (e.g. 'DSM')""" 
        x_index = x_index or self.x_index
        y_index = y_index or self.y_index
        tile_type_id = tile_type_id or self.default_tile_type_id
        
        db_cursor2 = self.db_connection.cursor()
                
        sql = """-- Retrieve all tile details for static data
select distinct
  level_name,
  dataset_path,
  tile_pathname
from dataset
inner join processing_level using(level_id)
inner join tile t using (dataset_id)
inner join tile_footprint tf using (x_index, y_index, tile_type_id)
where tile_type_id = %(tile_type_id)s
  and tile_class_id = 1 -- Select only valid tiles
  and (%(level_name)s is null or level_name = %(level_name)s)
  and x_index = %(x_index)s
  and y_index = %(y_index)s
  and acquisition_id is null -- No acquisition for static data
order by
  level_name, 
  dataset_path;
"""
        params = {'level_name': level_name,
                  'x_index': x_index,
                  'y_index': y_index,
                  'tile_type_id': tile_type_id,
                  }
                      
        log_multiline(logger.debug, db_cursor2.mogrify(sql, params), 'SQL', '\t')
        db_cursor2.execute(sql, params)
        
        static_info_dict = {}
        last_level_name = ''
        for record in db_cursor2:   
            static_data = {'level_name': record[0],
                      'dataset_path': record[1],
                      'tile_pathname': record[2]
                      }
            
            assert static_data['level_name'] != last_level_name, 'Duplicate data source found for level %s' % static_data['level_name']
            
            band_info = self.bands[tile_type_id].get(('DERIVED', static_data['level_name']))
                        
            static_info_dict[static_data['level_name']] = {
                                                           'level_name': static_data['level_name'],
                                                           'nodata_value': band_info.values()[0]['nodata_value'], # All values the same for the one level
                                                           'tile_pathname': static_data['tile_pathname'],
                                                           'x_index': x_index,
                                                           'y_index': y_index
                                                           #====================
                                                           # 'band_name': None,
                                                           # 'band_tag': None,
                                                           # 'end_datetime': None,
                                                           # 'end_row': None,
                                                           # 'path': None,
                                                           # 'satellite_tag': None,
                                                           # 'sensor_name': None,
                                                           # 'start_datetime': None,
                                                           # 'start_row': None,
                                                           # 'tile_layer': 1,
                                                           # 'gcp_count': None,
                                                           # 'cloud_cover': None
                                                           #====================
                                                           }        
            
        return static_info_dict
dataset/ETHPy150Open GeoscienceAustralia/agdc/src/stacker.py/Stacker.get_static_info/original